These events are always amusing in hindsight - just as long as no-one is hurt and only egos get bruised.
Such as the F3 giving a display over the wrong village, countless Dishforth/Leeming cock-ups by JP students, the Mirage IV attacking Rattlesden instead of Wattisham - and a narrowly avoided join at Withybush instead of Brawdy....by yours truly. Fortunately I spotted my error running in from the Initial Point (I'd identified the wrong old church...) and at 450 KIAS and about 5G I was able to pull hard enough to avoid the ATZ....just
!
No-one ever complained though...
But the chap who landed the highly secret F-117 at El Paso Muni instead of Biggs AAF didn't get off so lightly!
The Sleap/Shawbury cock-up was in 1975. A student on a dual training flight with his Sqn OC in the back was diverted to Shawbury due to the weather at Valley. On the PAR approach, his QFI told him to stop dicking about, took control and landed.
An unusual blue car stopped next to their Gnat. The Sqn OC asked what the hell it was doing there - the chap in the protoype Ford asked what the hell the Gnat was doing landing in the middle of a car testing session at Sleap.
The studes on the course were in the process of making a "WELCOME TO RAF ST MAWGAN" sign to welcome the Sqn OC back to RAF Valley, but were persuaded that this wouldn't be a very good idea!