# NTSB investigations, Mexico

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 2 of 5 · 240 cases

## Cases, newest first

- [NTSB FTW75ORG71](https://openairdocs.org/ntsb/FTW75ORG71.md): Piper PA-30 · Zihuathnejo, Mexico · Accident · No injuries · Closed · Nov 22, 1974 · N78684 · Substantial damage
- [NTSB FTW75ORG49](https://openairdocs.org/ntsb/FTW75ORG49.md): Piper PA-32 · Agualeguas, Mexico · Accident · No injuries · Closed · Oct 11, 1974 · N3470W · Destroyed
- [NTSB LAX75OL009](https://openairdocs.org/ntsb/LAX75OL009.md): Cessna 150 · Rosarito, Mexico · Accident · No injuries · Closed · Oct 6, 1974 · N11357 · Substantial damage
- [NTSB LAX75OL007](https://openairdocs.org/ntsb/LAX75OL007.md): Cessna 337 · Chiconcuac, Mexico · Accident · 1 fatal · Closed · Jul 28, 1974 · N85953 · Destroyed
- [NTSB LAX75OL001](https://openairdocs.org/ntsb/LAX75OL001.md): Cessna 172E · Ensenada, Mexico · Accident · No injuries · Closed · Jul 26, 1974 · N5566T · Substantial damage
- [NTSB FTW75OPA06](https://openairdocs.org/ntsb/FTW75OPA06.md): Piper PA-32 · Mazatlan, Mexico · Accident · Minor injuries · Closed · Jul 24, 1974 · N56662 · Destroyed
- [NTSB FTW75ORG07](https://openairdocs.org/ntsb/FTW75ORG07.md): Cessna P206A · Coahuila, Mexico · Accident · No injuries · Closed · Jul 7, 1974 · N5720J · Destroyed
- [NTSB UNK74X0112](https://openairdocs.org/ntsb/UNK74X0112.md): Lockheed 12A · Q.Roo, Mexico · Accident · No injuries · Closed · Jun 24, 1974 · N36P · Substantial damage
- [NTSB LAX75OL008](https://openairdocs.org/ntsb/LAX75OL008.md): Cessna 210 · Magdalena, Mexico · Accident · 2 fatal · Closed · May 24, 1974 · N1187Q · Destroyed
- [NTSB LAX74OL087](https://openairdocs.org/ntsb/LAX74OL087.md): Piper PA-28 · Hermosilla, Mexico · Accident · No injuries · Closed · May 18, 1974 · N15735 · Substantial damage
- [NTSB FTW74OQD20](https://openairdocs.org/ntsb/FTW74OQD20.md): Cessna 210 · Arteaga, Mexico · Accident · 2 fatal · Closed · Apr 26, 1974 · N59082 · Destroyed
- [NTSB FTW74ORG81](https://openairdocs.org/ntsb/FTW74ORG81.md): Cessna 182J · Zihauatanejo, Mexico · Accident · 2 fatal · Closed · Apr 25, 1974 · N3302F · Destroyed
- [NTSB LAX74OL076](https://openairdocs.org/ntsb/LAX74OL076.md): Piper PA-24 · Mexicali, Mexico · Incident · No injuries · Closed · Apr 21, 1974 · N6744P · Minor damage
- [NTSB LAX75OL006](https://openairdocs.org/ntsb/LAX75OL006.md): Piper PA-32 · Tecoripa, Mexico · Accident · No injuries · Closed · Apr 17, 1974 · N98217 · Substantial damage
- [NTSB OAK74DVG40](https://openairdocs.org/ntsb/OAK74DVG40.md): Piper PA-28R · Mexicali, Mexico · Accident · No injuries · Closed · Apr 8, 1974 · N2810T · Substantial damage
- [NTSB LAX74OL064](https://openairdocs.org/ntsb/LAX74OL064.md): Cessna 150 · Mazatlan, Mexico · Accident · No injuries · Closed · Mar 9, 1974 · N1269Y · Substantial damage
- [NTSB FTW74OPD36](https://openairdocs.org/ntsb/FTW74OPD36.md): Beech V35A · Padilla, Mexico · Accident · No injuries · Closed · Feb 28, 1974 · N827W · Substantial damage
- [NTSB LAX74OL067](https://openairdocs.org/ntsb/LAX74OL067.md): Cessna 177 · Nogales, Mexico · Accident · Serious injuries · Closed · Feb 23, 1974 · N3130T · Destroyed
- [NTSB LAX74OL086](https://openairdocs.org/ntsb/LAX74OL086.md): Cessna 210 · Tijuana, Mexico · Accident · No injuries · Closed · Feb 17, 1974 · N3916Y · Substantial damage
- [NTSB FTW74DRG60](https://openairdocs.org/ntsb/FTW74DRG60.md): Breezy TCD 11BR · Guerrero, Mexico · Accident · Serious injuries · Closed · Feb 9, 1974 · N11WT · Destroyed
- [NTSB FTW74DRA24](https://openairdocs.org/ntsb/FTW74DRA24.md): Beech S35 · Lapesca, Mexico · Accident · No injuries · Closed · Jan 26, 1974 · N5838K · Substantial damage
- [NTSB FTW74DRG47](https://openairdocs.org/ntsb/FTW74DRG47.md): Cessna 177RG · Reynosa, Mexico · Accident · No injuries · Closed · Dec 27, 1973 · N1955Q · Substantial damage
- [NTSB LAX74OL051](https://openairdocs.org/ntsb/LAX74OL051.md): Cessna 310 · Mazatlan, Mexico · Accident · No injuries · Closed · Dec 26, 1973 · N3092D · Substantial damage
- [NTSB LAX74OL049](https://openairdocs.org/ntsb/LAX74OL049.md): Mooney M20C · Mulege, Mexico · Accident · 4 fatal · Closed · Dec 22, 1973 · N9082V · Destroyed
- [NTSB OAK74DVD33](https://openairdocs.org/ntsb/OAK74DVD33.md): Cessna 205 · Yecora, Mexico · Accident · 3 fatal · Closed · Oct 28, 1973 · N8299Z · Destroyed
- [NTSB IAD74DLQ16](https://openairdocs.org/ntsb/IAD74DLQ16.md): Piper PA-28 · Renosa, Mexico · Accident · No injuries · Closed · Oct 14, 1973 · N15091 · Substantial damage
- [NTSB LAX74OL032](https://openairdocs.org/ntsb/LAX74OL032.md): Aero Comdr 100 · Hermosillo, Mexico · Accident · 2 fatal · Closed · Sep 29, 1973 · N4038X · Substantial damage
- [NTSB DEN74DQA15](https://openairdocs.org/ntsb/DEN74DQA15.md): Bellanca 17-30 · Chihuahua, Mexico · Accident · No injuries · Closed · Aug 26, 1973 · N4925V · Substantial damage
- [NTSB LAX74OL022](https://openairdocs.org/ntsb/LAX74OL022.md): Beech 35 · Mulege, Mexico · Accident · No injuries · Closed · Aug 25, 1973 · N520B · Substantial damage
- [NTSB FTW74DRG14](https://openairdocs.org/ntsb/FTW74DRG14.md): Piper PA-28 · Coahuila, Mexico · Accident · 2 fatal · Closed · Aug 18, 1973 · N1876T · Destroyed
- [NTSB FTW74DRA15](https://openairdocs.org/ntsb/FTW74DRA15.md): Piper PA-28 · Empalme, Mexico · Accident · 1 fatal · Closed · Jul 31, 1973 · N5198L · Destroyed
- [NTSB LAX74OL007](https://openairdocs.org/ntsb/LAX74OL007.md): Cessna 172L · Sonoyta, Mexico · Accident · No injuries · Closed · Jul 14, 1973 · N1256T · Substantial damage
- [NTSB LAX74OL009](https://openairdocs.org/ntsb/LAX74OL009.md): Piper PA-28 · Tiburon, Mexico · Accident · No injuries · Closed · Jul 7, 1973 · N4801T · Destroyed
- [NTSB DEN74OD010](https://openairdocs.org/ntsb/DEN74OD010.md): Cessna TP206B · Tahuahueto, Mexico · Accident · Minor injuries · Closed · Jun 10, 1973 · N4751F · Substantial damage
- [NTSB OAK73DVD36](https://openairdocs.org/ntsb/OAK73DVD36.md): Piper PA-24 · Mazatlan, Mexico · Accident · No injuries · Closed · May 11, 1973 · N9468P · Substantial damage
- [NTSB OAK73DVG63](https://openairdocs.org/ntsb/OAK73DVG63-189859.md): Cessna T210L · Mexicali, Mexico · Accident · Serious injuries · Closed · Apr 30, 1973 · N1160Q · Substantial damage
- [NTSB FTW73DRG65](https://openairdocs.org/ntsb/FTW73DRG65.md): Cessna 150 · Matamoros, Mexico · Accident · No injuries · Closed · Apr 1, 1973 · N7160C · Substantial damage
- [NTSB SEA73OYE32](https://openairdocs.org/ntsb/SEA73OYE32.md): Cessna 172K · Baja, Mexico · Accident · Minor injuries · Closed · Mar 13, 1973 · N7473G · Substantial damage
- [NTSB FTW73DPD26](https://openairdocs.org/ntsb/FTW73DPD26.md): Piper PA-32 · Ojinaga, Mexico · Accident · No injuries · Closed · Mar 10, 1973 · N4138W · Substantial damage
- [NTSB FTW73DRG86](https://openairdocs.org/ntsb/FTW73DRG86.md): Cessna 182P · Charcas, Mexico · Accident · No injuries · Closed · Mar 3, 1973 · N21445 · Substantial damage
- [NTSB CHI73DEP41](https://openairdocs.org/ntsb/CHI73DEP41.md): Piper PA-28 · Hermosa, Mexico · Accident · Serious injuries · Closed · Feb 26, 1973 · N9809W · Destroyed
- [NTSB FTW73DRG42](https://openairdocs.org/ntsb/FTW73DRG42.md): Cessna 210L · Muzquiz, Mexico · Accident · No injuries · Closed · Jan 15, 1973 · N4616Q · Substantial damage
- [NTSB MKC73DCA16](https://openairdocs.org/ntsb/MKC73DCA16.md): Beechcraft K35 · Cardenas, Mexico · Accident · No injuries · Closed · Jan 11, 1973 · N805R · Substantial damage
- [NTSB LAX73OL008](https://openairdocs.org/ntsb/LAX73OL008.md): Bellanca 17-31 · 1, Mexico · Accident · No injuries · Closed · Dec 27, 1972 · N7357V · Substantial damage
- [NTSB LAX73AL028](https://openairdocs.org/ntsb/LAX73AL028.md): Piper PA-28 · Mexicali, Mexico · Accident · 1 fatal · Closed · Dec 17, 1972 · N1256T · Destroyed
- [NTSB FTW73DRG38](https://openairdocs.org/ntsb/FTW73DRG38.md): Cessna 182 · Progresso, Mexico · Accident · No injuries · Closed · Dec 17, 1972 · N9291G · Substantial damage
- [NTSB UNK73X0102](https://openairdocs.org/ntsb/UNK73X0102.md): Piper PA-28 · Tepic, Mexico · Accident · No injuries · Closed · Nov 26, 1972 · N4860L · Substantial damage
- [NTSB LAX73OL006](https://openairdocs.org/ntsb/LAX73OL006.md): Piper PA-24 · Topia, Mexico · Accident · 3 fatal · Closed · Nov 22, 1972 · N8581P · Destroyed
- [NTSB LAX730LO07](https://openairdocs.org/ntsb/LAX730LO07.md): Cessna 182 · Baja Calif, Mexico · Accident · No injuries · Closed · Nov 9, 1972 · N8488S · Substantial damage
- [NTSB LAX73OLO05](https://openairdocs.org/ntsb/LAX73OLO05.md): Piper PA-32 · Mulege, Mexico · Accident · No injuries · Closed · Sep 18, 1972 · N5252S · Substantial damage

Next page: https://openairdocs.org/ntsb.md?state=MX&page=3

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'MX' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?page=2&state=MX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.