Put it at the very end of a failed attempt, after the Classic Error Sound has flagged the mistake and before any outro music returns. Follow a tense build with Dun Dun Dun, then let this clip close the sequence so the next scene starts clean. Pair it with a single reaction sound, not a stack of effects.