This sound effect can be found on Sound Effects - Greatest Hits, which was made by Compose.
https://soundeffects.fandom.com/wiki/File:Compose,_Demolition_Derby_(Almost_3_Minutes_Of_Crashes).ogg