Place it after the fail is shown and before the aftermath, then follow it with GTA V Wasted to mark the loss, or Mission Failed when the whole attempt collapses. Keep it as the centre of the sequence, with a short reaction sound before it only if the setup needs a beat.