well, the nature of Ricardo Palleti crash was wery specific, and that can repeat anytime, no matter of safety improvements.
The fact is that Ferrari of Didier Pironi stood still and therefore making very dangerous obstacle. Even more dangerous than the wall itself. Why? because when the car is beeing hit from behind it tends (and especially in those days, when cars had short noses)) to climb up the nose of the car that hit him from behind, immediate consequence is that the gearbox of the standing car will hit the driver's head in the other car.
Simmilar accident occured at Imola '94 when Benetton-Ford driven by J.J. Lehto stalled, and was hit from behind by Pedro Lamy, only difference was that Lotus hit Benetton under angle and therefore slid sideways and not underneath the Benetton, so It was a lucky circumstance, (although it just might be the thing that influenced the things that were about to happen, because the accident brought out safety car, so if there was a clear race with no pace car maybie, and just maybie Senna's suspension or steering or whatever broke would broke maybie ten meters before or ten meters after and the angle of impact would be slightly different and maybie Ayrton would survive, maybie the parts of his suspension would just fly by his helmet instead of piercing it. but back to topic), so Pedro Lamy slid sideways, but if the impact had been more direct Lotus would dive beneath Benetton therefore hitting Lamy in the head.
So it is really a thing that cannot be avoided if you want to have an open cockpit car, If formula 1 would adopt fully enclosed cockpit with a narrow window through which driver would look , then it can be avoided.
There was actually a pre WW2 race car I think it was Auto Union or Mercedes that looked like that, but I'm not sure, I'll go now and I will try to find some pictures of it, I remember I saw a drawing rather than a picture of that car. It was running on a high banked curve, think it was old Avus but I'm not sure. Car looked a bit like batmobile TBH.
I will try to find it and I'll paste it here, or post a link or something.