>>The unmanned rocket was destroyed when its self-destruct system was triggered after an unexplained malfunction. It's interesting these rockets are equipped with self-destruct systems. What scenario would warrant a rocket purposely self-destruct?
I can't seem to find any good numbers, but it seems like the F9 rocket should have somewhere around 200 tons of fuel & oxidiser (kerosene & liquid oxygen). That, in addition to the few other hundred tons of rocket landing anywhere public is probably not going to end well.
IIRC, most rockets over a certain size are required to have some form of 'range safety package'[1] which may include a self-destruct capability for exactly these reasons.
In the course of the Challenger shuttle accident, the Solid Rocket Boosters were remotely destroyed by the range safety officer[2]