Put it at the end of a setup or build sequence, at the point the edit cuts to the broken result. Follow it with the Classic Error Sound to underline the fault, then close with the Vine Boom Sound if the fail is the climax of the clip.