9C also produced an incredibly powerful explosion that leveled the entire service tower on LC-12
I read the postflight report for 48D and it gives a fairly detailed description of the events during the attempted launch.
51D actually should not have lifted from the pad, but the RCC sensor in the B-1 engine was not working so it allowed the missile to be released anyway. The B-1 RCC sensor on 48D wasn't working either but the malfunction occurred in the B-2 so that engine's RCC operated correctly and terminated thrust before lifoff could be achieved.
Ultimately the blame for the failure lay on Flight Director Walter Williams both for ordering the launch to take place without the LES and for launching it into cloudy weather where the booster couldn't be filmed after the first 20 or so seconds of flight (as well as depriving us of footage of what was probably a pretty cool explosion).
Also on the topic of MA-3, I can think of at least three other flights that went straight up and didn't pitch over. These were a pair of Thor launches from VAFB in 1959 and an Atlas R/V test in 1968. The Thors failed because some technician forgot to cut a wire holding the programmer tape in place so they never executed the pitch and roll sequence. The Atlas (95F specifically, it had an ABRES TVX vehicle) I'm not sure of the exact reason for the failure, but probably similar circumstances to MA-3.