Place it in the middle of an edit, after a confident setup and before the reveal of the damage. Pair it with a dramatic sting beforehand to build tension, then follow it with a metal pipe clang and a fail sound to sell the wreckage.