Looking at the photo evidence in post#983 above, a thought that crossed my mind - would a simple left handed thread on the shaft have prevented this tragedy?
Having recently changed a rear wheel bearing, even my old car has a left handed thread on the left hand side stub axle, to prevent the hub nut coming loose in service.