I have cracked a few steel frames, presumably from fatigue, mostly at stress risers (e.g. dropouts, downtube shifter bosses) and tube ends (e.g. just above BB) and a Cannondale 2.8 (typical failure at the cantilevered dropout).
I've not spent enough time on a Ti or carbon frame to fatigue them...