Place it right after the unfair moment peaks, then follow it with the Mission Failed sound to confirm the failure, or cut to the GTA V Wasted sting when a game goes wrong. For a lighter fail, end with Ba Dum Tss instead.