It's a fairly new theory that an asteroid impact killed off the dinosaurs, but the impact area they think resulted is called the Chicxulub Crater. It's located half on the Yucatan Peninsula and half in the Gulf of Mexico.
Wikipedia: Chicxulub Crater.