Here are two more launch failures involving launchers with SRBs:
18 April 1986, Titan 34D, Vandenberg AFB, KH-9 payload: This was another SRB failure, caused by separation of insulation within one of the SRBs near a field joint and burn-through during flight, somewhat similar to the Challenger STS-51L failure.
12 Aug 1998, Titan IVA, Cape Canaveral AFS, NRO payload:
This one was more like the Delta/GOES-G failure in 1986 in that the cause was an electrical short, not an SRB failure. Power was momentarily lost to the guidance computer, which in turn provided control signals to the guidance platform. The platform tumbled. When power came back, the guidance computer commanded a hardover of the engines to compensate for a large, illusory attitude error and aerodynamic forces ripped the vehicle apart starting with one of the SRBs. This triggered the destruct system.
Destruct ordnance can be fired not only by a command from the ground, but automatically by the vehicle itself when breakwires detect that it's coming apart anyway.
Since these were both Titans that use hypergolic propellants in their core stages, the explosions produced huge clouds of toxic brown N
2O
4 gas (actually a mixture of NO
2 and N
2O
4). This is the same stuff that gives smog its yellow-brown color. I don't think any western launch vehicle lower stages use it anymore, though it's still common in upper stages and in spacecraft.