Place it at the end of a failed moment, after the action has finished and before any reaction shot. Pair it with the Classic Error Sound for a double miss, or follow it with Dun Dun Dun when the failure needs a bigger payoff, then cut straight to the next scene.