Place it at the moment of the miss, before any reaction shot, then follow it with the Nope sound to let the failure sink in, and save an impact sound for the next successful hit in the sequence.