Place it at the end of a rescue or comeback sequence, after the problem has been shown and just before the payoff lands. Pair it with a fail sound beforehand to set up the turnaround, then follow it with a cheer to close the sequence.