Place it right after the big build-up, once the tackle is underway, and let Crowd Cheering set up the expectation before the miss. Follow the fail immediately with Sad Trombone to close the sequence and move on to the next play.