# 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 1 of 5 · 240 cases

## Latest cases

- [NTSB LAX81OA021](https://openairdocs.org/ntsb/LAX81OA021.md): Piper PA-31 · Magdelena, Mexico · Accident · 2 fatal · Closed · Sep 30, 1980 · N3542X · Destroyed
- [NTSB UNK79X0105](https://openairdocs.org/ntsb/UNK79X0105.md): Piper PA-24 · Ocoroni, Mexico · Accident · No injuries · Closed · Dec 2, 1978 · N843PS · Destroyed
- [NTSB UNK78X0126](https://openairdocs.org/ntsb/UNK78X0126.md): Piper PA22 · Arramberri, Mexico · Accident · 1 fatal · Closed · Jun 15, 1978 · N9014D · Destroyed
- [NTSB UNK78X0116](https://openairdocs.org/ntsb/UNK78X0116.md): Beech 65 · Zamora, Mexico · Accident · Serious injuries · Closed · Apr 24, 1978 · N640PH · Destroyed
- [NTSB UNK78X0111](https://openairdocs.org/ntsb/UNK78X0111.md): Beech B35 · Martinez, Mexico · Accident · Minor injuries · Closed · Mar 25, 1978 · N5185C · Substantial damage
- [NTSB LAX780A003](https://openairdocs.org/ntsb/LAX780A003.md): Cessna 182 · Baja, Mexico · Accident · No injuries · Closed · Feb 27, 1978 · N3454U · Destroyed
- [NTSB UNK78X0109](https://openairdocs.org/ntsb/UNK78X0109.md): Piper PA-32 · Cerralvo, Mexico · Accident · No injuries · Closed · Feb 21, 1978 · N3737M · Substantial damage
- [NTSB FTW77OA005](https://openairdocs.org/ntsb/FTW77OA005.md): Cessna 182H · Chimaltit, Mexico · Accident · No injuries · Closed · Aug 10, 1977 · N8339S · Destroyed
- [NTSB FTW77OA004](https://openairdocs.org/ntsb/FTW77OA004.md): Piper PA-28R · Cautrocienega, Mexico · Accident · No injuries · Closed · Jun 17, 1977 · N3569Q · Substantial damage
- [NTSB LAX77OA007](https://openairdocs.org/ntsb/LAX77OA007.md): Piper PA-22 · Puertocitas, Mexico · Accident · Serious injuries · Closed · Jun 11, 1977 · N7040D · Destroyed
- [NTSB LAX77OA008](https://openairdocs.org/ntsb/LAX77OA008.md): Cessna 172D · Hermisillo, Mexico · Accident · No injuries · Closed · Jun 9, 1977 · N8553X · Substantial damage
- [NTSB FTW770A003](https://openairdocs.org/ntsb/FTW770A003.md): Cessna 207 · Matamoros, Mexico · Accident · No injuries · Closed · Jun 6, 1977 · N1520U · Substantial damage
- [NTSB MKC770A001](https://openairdocs.org/ntsb/MKC770A001.md): Cessna 177RG · Hermosillo, Mexico · Accident · No injuries · Closed · Jan 5, 1977 · N2533V · Substantial damage
- [NTSB LAX770A002](https://openairdocs.org/ntsb/LAX770A002.md): Cessna 172 · Baja, Mexico · Accident · No injuries · Closed · Nov 6, 1976 · N73620 · Substantial damage
- [NTSB FTW76O0010](https://openairdocs.org/ntsb/FTW76O0010.md): Navion B · Texistepec, Mexico · Accident · No injuries · Closed · Sep 4, 1976 · N5258K · Substantial damage
- [NTSB FTW76O0009](https://openairdocs.org/ntsb/FTW76O0009.md): Cessna 320 · Ciudad, Mexico · Accident · No injuries · Closed · Sep 2, 1976 · N4196T · Destroyed
- [NTSB MIA760M010](https://openairdocs.org/ntsb/MIA760M010.md): Avions Mrcl Falcon · Acapulco, Mexico · Accident · 3 fatal · Closed · Aug 7, 1976 · N888AR · Destroyed
- [NTSB FTW76O0007](https://openairdocs.org/ntsb/FTW76O0007.md): Cessna 206 · Tamaulipas, Mexico · Accident · No injuries · Closed · Aug 7, 1976 · N1249V · Substantial damage
- [NTSB LAX76A0021](https://openairdocs.org/ntsb/LAX76A0021.md): Piper PA-32R · Hermosillo, Mexico · Accident · No injuries · Closed · Aug 6, 1976 · N4435X · Substantial damage
- [NTSB FTW76ORG71](https://openairdocs.org/ntsb/FTW76ORG71.md): Cessna 337 · Amatlan, Mexico · Accident · 2 fatal · Closed · Jul 6, 1976 · N53417 · Destroyed
- [NTSB FTW76DRG63](https://openairdocs.org/ntsb/FTW76DRG63.md): Cessna 182 · Coahuila, Mexico · Accident · 3 fatal · Closed · Jun 21, 1976 · N1402M · Destroyed
- [NTSB LAX7600019](https://openairdocs.org/ntsb/LAX7600019.md): Cessna 182 · Tezapoca, Mexico · Accident · Minor injuries · Closed · Jun 5, 1976 · N84488 · Substantial damage
- [NTSB FTW76O0006](https://openairdocs.org/ntsb/FTW76O0006.md): Dehavilland DHC-2 · Acapulco, Mexico · Accident · 3 fatal · Closed · May 14, 1976 · N3010F · Destroyed
- [NTSB FTW76O0004](https://openairdocs.org/ntsb/FTW76O0004.md): Piper PA-23 · Huascato, Mexico · Accident · No injuries · Closed · Mar 20, 1976 · N4779P · Destroyed
- [NTSB FTW7600003](https://openairdocs.org/ntsb/FTW7600003.md): Cessna 206 · Tuxpan, Mexico · Accident · No injuries · Closed · Mar 12, 1976 · N5020U · Substantial damage
- [NTSB FTW76O0005](https://openairdocs.org/ntsb/FTW76O0005.md): Piper PA-24 · Colima, Mexico · Accident · No injuries · Closed · Mar 6, 1976 · N7695P · Substantial damage
- [NTSB FTW76OF002](https://openairdocs.org/ntsb/FTW76OF002.md): Maule M5220C · Jalisco, Mexico · Accident · No injuries · Closed · Feb 22, 1976 · N51637 · Substantial damage
- [NTSB LAX76F0015](https://openairdocs.org/ntsb/LAX76F0015.md): Beech E18S · Bahia De L.A., Mexico · Accident · No injuries · Closed · Feb 20, 1976 · N342E · Substantial damage
- [NTSB LAX7600016](https://openairdocs.org/ntsb/LAX7600016.md): Piper PA-28 · Ensenada, Mexico · Accident · No injuries · Closed · Feb 20, 1976 · N7449J · Substantial damage
- [NTSB LAX76O0009](https://openairdocs.org/ntsb/LAX76O0009.md): Piper PA-24 · Palenque, Mexico · Accident · Minor injuries · Closed · Dec 26, 1975 · N7888P · Substantial damage
- [NTSB LAX7600014](https://openairdocs.org/ntsb/LAX7600014.md): Cessna 210 · Culiacan, Mexico · Accident · No injuries · Closed · Dec 25, 1975 · N5279V · Substantial damage
- [NTSB LAX7600017](https://openairdocs.org/ntsb/LAX7600017.md): Piper PA-32 · Bachiniva, Mexico · Accident · Serious injuries · Closed · Dec 4, 1975 · N5227S · Substantial damage
- [NTSB FTW76FPA16](https://openairdocs.org/ntsb/FTW76FPA16.md): Cessna 402 · Cerralvo, Mexico · Accident · No injuries · Closed · Dec 1, 1975 · N33WT · Substantial damage
- [NTSB LAX76O0013](https://openairdocs.org/ntsb/LAX76O0013.md): Piper PA-32 · Mulege, Mexico · Accident · No injuries · Closed · Nov 5, 1975 · N4147R · Substantial damage
- [NTSB LAX76A0008](https://openairdocs.org/ntsb/LAX76A0008.md): Piper PA-32 · Navajoa, Mexico · Accident · No injuries · Closed · Sep 17, 1975 · N43152 · Substantial damage
- [NTSB LAX76O0002](https://openairdocs.org/ntsb/LAX76O0002.md): Navion B · Ensenada, Mexico · Accident · 1 fatal · Closed · Aug 25, 1975 · N5273K · Destroyed
- [NTSB FTW76OQD05](https://openairdocs.org/ntsb/FTW76OQD05.md): Cessna P206A · Juarez, Mexico · Accident · No injuries · Closed · Aug 24, 1975 · N4663F · Destroyed
- [NTSB LAX7600003](https://openairdocs.org/ntsb/LAX7600003.md): Cessna 195A · Mulege, Mexico · Accident · Serious injuries · Closed · Aug 18, 1975 · N1076D · Substantial damage
- [NTSB LAX76O0001](https://openairdocs.org/ntsb/LAX76O0001.md): Cessna T337 · Mulege, Mexico · Accident · Serious injuries · Closed · Jul 28, 1975 · N23664 · Destroyed
- [NTSB LAX7500027](https://openairdocs.org/ntsb/LAX7500027.md): Cessna 150 · Mexicali, Mexico · Accident · No injuries · Closed · May 3, 1975 · N3955J · Substantial damage
- [NTSB FTW75OPG89](https://openairdocs.org/ntsb/FTW75OPG89.md): Beech D18S · Jalisco, Mexico · Accident · No injuries · Closed · May 3, 1975 · N64R · Destroyed
- [NTSB LAX75O0031](https://openairdocs.org/ntsb/LAX75O0031.md): Cessna 182 · Loreto, Mexico · Accident · No injuries · Closed · Apr 28, 1975 · N52315 · Substantial damage
- [NTSB LAX7500026](https://openairdocs.org/ntsb/LAX7500026.md): Cessna 182 · Loreto, Mexico · Accident · No injuries · Closed · Apr 28, 1975 · N52315 · Substantial damage
- [NTSB MKC75OK003](https://openairdocs.org/ntsb/MKC75OK003.md): Cessna T210L · Valles, Mexico · Accident · No injuries · Closed · Apr 12, 1975 · N22430 · Destroyed
- [NTSB LAX76O0012](https://openairdocs.org/ntsb/LAX76O0012.md): Lockheed PV-1 · Culiacan, Mexico · Accident · 2 fatal · Closed · Apr 1, 1975 · N730EG · Substantial damage
- [NTSB LAX75O0021](https://openairdocs.org/ntsb/LAX75O0021.md): Grum Amer AA5 · Puertecitos, Mexico · Accident · No injuries · Closed · Mar 22, 1975 · N7291L · Substantial damage
- [NTSB LAX75O0018](https://openairdocs.org/ntsb/LAX75O0018.md): Cessna 172 · Puertecitos, Mexico · Accident · Minor injuries · Closed · Mar 6, 1975 · N18674 · Substantial damage
- [NTSB FTW75ORG72](https://openairdocs.org/ntsb/FTW75ORG72.md): Cessna 205 · Muzquin, Mexico · Accident · Minor injuries · Closed · Feb 17, 1975 · N8318Z · Destroyed
- [NTSB LAX7500025](https://openairdocs.org/ntsb/LAX7500025.md): Cessna 180 · Vecora, Mexico · Accident · 3 fatal · Closed · Jan 26, 1975 · N4659A · Destroyed
- [NTSB LAX75O0016](https://openairdocs.org/ntsb/LAX75O0016.md): Cessna 177RG · Platinito, Mexico · Accident · No injuries · Closed · Dec 7, 1974 · N2151Q · Substantial damage

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

## 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?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.