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

## 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 UNK78X0126](https://openairdocs.org/ntsb/UNK78X0126.md): Piper PA22 · Arramberri, Mexico · Accident · 1 fatal · Closed · Jun 15, 1978 · N9014D · Destroyed
- [NTSB MIA760M010](https://openairdocs.org/ntsb/MIA760M010.md): Avions Mrcl Falcon · Acapulco, Mexico · Accident · 3 fatal · Closed · Aug 7, 1976 · N888AR · Destroyed
- [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 FTW76O0006](https://openairdocs.org/ntsb/FTW76O0006.md): Dehavilland DHC-2 · Acapulco, Mexico · Accident · 3 fatal · Closed · May 14, 1976 · N3010F · Destroyed
- [NTSB LAX76O0002](https://openairdocs.org/ntsb/LAX76O0002.md): Navion B · Ensenada, Mexico · Accident · 1 fatal · Closed · Aug 25, 1975 · N5273K · 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 LAX7500025](https://openairdocs.org/ntsb/LAX7500025.md): Cessna 180 · Vecora, Mexico · Accident · 3 fatal · Closed · Jan 26, 1975 · N4659A · Destroyed
- [NTSB LAX75OL007](https://openairdocs.org/ntsb/LAX75OL007.md): Cessna 337 · Chiconcuac, Mexico · Accident · 1 fatal · Closed · Jul 28, 1974 · N85953 · Destroyed
- [NTSB LAX75OL008](https://openairdocs.org/ntsb/LAX75OL008.md): Cessna 210 · Magdalena, Mexico · Accident · 2 fatal · Closed · May 24, 1974 · N1187Q · Destroyed
- [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 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 LAX74OL032](https://openairdocs.org/ntsb/LAX74OL032.md): Aero Comdr 100 · Hermosillo, Mexico · Accident · 2 fatal · Closed · Sep 29, 1973 · N4038X · 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 LAX73AL028](https://openairdocs.org/ntsb/LAX73AL028.md): Piper PA-28 · Mexicali, Mexico · Accident · 1 fatal · Closed · Dec 17, 1972 · N1256T · Destroyed
- [NTSB LAX73OL006](https://openairdocs.org/ntsb/LAX73OL006.md): Piper PA-24 · Topia, Mexico · Accident · 3 fatal · Closed · Nov 22, 1972 · N8581P · Destroyed
- [NTSB FTW72DQD16](https://openairdocs.org/ntsb/FTW72DQD16.md): Cessna 172E · S.Buenaventra, Mexico · Accident · 4 fatal · Closed · Nov 5, 1971 · N3602S · Destroyed
- [NTSB FTW71DPA25](https://openairdocs.org/ntsb/FTW71DPA25.md): Piper PA-24 · Baborigane, Mexico · Accident · 1 fatal · Closed · Mar 14, 1971 · N9104D · Destroyed
- [NTSB FTW71DRG89](https://openairdocs.org/ntsb/FTW71DRG89.md): Cessna 206 · Lagunitas, Mexico · Accident · 1 fatal · Closed · Mar 1, 1971 · N2660X · Destroyed
- [NTSB FTW71DRG42](https://openairdocs.org/ntsb/FTW71DRG42.md): Cessna 172 · Tijuana, Mexico · Accident · 3 fatal · Closed · Oct 25, 1970 · N8312B · Destroyed
- [NTSB FTW71DQG46](https://openairdocs.org/ntsb/FTW71DQG46.md): Piper PA-30 · Juarez, Mexico · Accident · 2 fatal · Closed · Sep 28, 1970 · N8825Y · Destroyed
- [NTSB LAX71DUJ13](https://openairdocs.org/ntsb/LAX71DUJ13.md): Mooney M20C · Sonora, Mexico · Accident · 4 fatal · Closed · Aug 2, 1970 · N9124V · Destroyed
- [NTSB LAX69O0156](https://openairdocs.org/ntsb/LAX69O0156.md): Cessna 170 · Mexicali, Mexico · Accident · 3 fatal · Closed · Sep 8, 1968 · N4248V · Destroyed
- [NTSB UNK68X0137](https://openairdocs.org/ntsb/UNK68X0137.md): Cessna 140 · Tiajuana, Mexico · Accident · 2 fatal · Closed · Apr 28, 1968 · N76659 · Destroyed
- [NTSB UNK68X0126](https://openairdocs.org/ntsb/UNK68X0126.md): Bellanca 14-13 · Mazatlan, Mexico · Accident · 1 fatal · Closed · Mar 17, 1968 · N86749 · Destroyed
- [NTSB UNK68X0116](https://openairdocs.org/ntsb/UNK68X0116.md): Cessna 210 · Naucalpan, Mexico · Accident · 4 fatal · Closed · Dec 22, 1967 · N3701Y · Destroyed
- [NTSB FTW68O0007](https://openairdocs.org/ntsb/FTW68O0007.md): Piper PA-25 · Ojinaga, Mexico · Accident · 1 fatal · Closed · Sep 16, 1967 · N6526Z · Destroyed
- [NTSB OAK67A0056](https://openairdocs.org/ntsb/OAK67A0056.md): Lockheed 18 · Baja, Mexico · Accident · 10 fatal · Closed · Dec 20, 1966 · N2222B · Destroyed

## 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'
  AND c."highestInjuryLevel" = 'Fatal'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&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.