The car is a Porsche 911 RSR of the 964 flavor. The barrier is a large cement line of the Jersery flavor. The water is of the you-don't-want-to-land-upside-down-in-it flavor.
The scene: Driver Harry Kleinjan, attempting to tear through a stage of the Hellendoorn rally in the Netherlands, swings the 911 RSR tail-out around one corner, then accelerates flat out while up-shifting, only to realize that either his co-driver got the pace notes wrong, or he heard them wrong, because he immediately locks all four wheels when he sees the barrier.
But it's too late.
The 911, Kleinjan, and his co-driver then slam into the low cement retainer at considerable speed, ripping the left-side wheels from the car and vaulting it upward, flipping onto its roof as it lands in the pond.
Fortunately, both Kleinjan and co-driver escaped the car and the water unharmed, despite the brutal impact.