When did Alastor 'Mad-Eye' Moody die?
In Harry Potter and the Deathly Hallows.
There are loads of teachers: Minerva McGonogal, Albus Wolfric Brian Dumbledore, Severous Snape, Filious Flitwick, Quirrinous Quirrel, Dolores Umbridge, Remus Lupin, Gilderoy Lockhart, Madeye Moody, Alastor Moody, Horace Slughorn, Rubeus Hagrid, Poppy Pomfrey, Pomona Sprout and there's probably more. By the way you didn't need possesive apostrophy on Hogwarts (').
Alastor 'Mad-Eye' Moody didn't actually explain the disturbance, because the disturbance was him being captured by Barty Crouch Jr. Barty promptly took Polyjuice potion transforming himself into Moody. Moody's dustbins were a deterrent against intruders and were set to fire rubbish in the air. The muggle police were baffled when they arrived, and Arthur Weasley was sent to solve the situation. Crouch (appearing as Moody) didn't have to explain much as it was well known…