Place it at the exact frame of the mistake in your edit, after a build-up sound and before a reaction follow-up. Pair it with a cartoon slip for physical fails, or follow it with the sad violin for the aftermath.