A character saves the day by accident, thanks to his flaws.
There are many moments: Awesome Moments, Funny Moments, Heartwarming Moments, you name it. And then there's this. Basically, a hypothetical set-up is sorta like this: the situation is desperate, or even worse, hell, even the Darkest Hour. The heroes are about to be killed... but hey, this is the moment where the Big Damn Heroes rush in and save the day, at the last second... any second now... right... right... right?!? Oh no, here he comes! The idiot rushed in instead. So, not only the heroes are boned, but the last guy they get to see is this epic dumbass. Oh, and he popped up in a room filled with the same fire he's deathly afraid of, to boot. How can things get any worse... what? The fool, while running away from the fire, bumped on the villain and made him fall over! How is this even possible? Give yourself a high-five, dude - or take a shot, if this is what you've been seeking all along - for you've got yerself a Clowning Moment Of Awesome. This is what happens when a character's flaw proves vital to turn the tables in a given situation, and generally, it sort of goes just as well as in the given example. It doesn't need to either be a Crowning Moment Of Awesome, nor a Crowning Moment of Funny, but might be either one as well, if not both.
Examples of this trope in action:Anime and Manga