Put it at the peak of a fail, just after the mistake is clear and before the reaction shot. Follow it with Awkward Crickets when the embarrassment needs to linger, or lead into it with Shocking Sound Effect when a surprise hit comes out of nowhere.