Many people posting here have already seen this report of the results of fatigue tests of a number of high-end road bike frames as performed for the German Tour magazine back in 1997, but for those who haven't, here it is. (Short version: two aluminum frames and one carbon frame survived the testing. All of the steel and titanium frames failed. The testers concluded that the failures had less to do with the frame material and more to do with the design of each frame and with how careful the builder was during the building process.)

For those who might object that the steel and titanium alloys used for building frames have improved since 1997---that's true, but aluminum and carbon technology has improved too, of course.

https://www.sheldonbrown.com/rinard/...tigue_test.htm