Skip to content

Fatal NTSB investigations, Mexico

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Latest cases

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX81OA021Accident · 2 fatalClosedPiper PA-31 · Magdelena, MexicoSep 30, 1980 · N3542X · Destroyed NTSB UNK78X0126Accident · 1 fatalClosedPiper PA22 · Arramberri, MexicoJun 15, 1978 · N9014D · Destroyed NTSB MIA760M010Accident · 3 fatalClosedAvions Mrcl Falcon · Acapulco, MexicoAug 7, 1976 · N888AR · Destroyed NTSB FTW76ORG71Accident · 2 fatalClosedCessna 337 · Amatlan, MexicoJul 6, 1976 · N53417 · Destroyed NTSB FTW76DRG63Accident · 3 fatalClosedCessna 182 · Coahuila, MexicoJun 21, 1976 · N1402M · Destroyed NTSB FTW76O0006Accident · 3 fatalClosedDehavilland DHC-2 · Acapulco, MexicoMay 14, 1976 · N3010F · Destroyed NTSB LAX76O0002Accident · 1 fatalClosedNavion B · Ensenada, MexicoAug 25, 1975 · N5273K · Destroyed NTSB LAX76O0012Accident · 2 fatalClosedLockheed PV-1 · Culiacan, MexicoApr 1, 1975 · N730EG · Substantial damage NTSB LAX7500025Accident · 3 fatalClosedCessna 180 · Vecora, MexicoJan 26, 1975 · N4659A · Destroyed NTSB LAX75OL007Accident · 1 fatalClosedCessna 337 · Chiconcuac, MexicoJul 28, 1974 · N85953 · Destroyed NTSB LAX75OL008Accident · 2 fatalClosedCessna 210 · Magdalena, MexicoMay 24, 1974 · N1187Q · Destroyed NTSB FTW74OQD20Accident · 2 fatalClosedCessna 210 · Arteaga, MexicoApr 26, 1974 · N59082 · Destroyed NTSB FTW74ORG81Accident · 2 fatalClosedCessna 182J · Zihauatanejo, MexicoApr 25, 1974 · N3302F · Destroyed NTSB LAX74OL049Accident · 4 fatalClosedMooney M20C · Mulege, MexicoDec 22, 1973 · N9082V · Destroyed NTSB OAK74DVD33Accident · 3 fatalClosedCessna 205 · Yecora, MexicoOct 28, 1973 · N8299Z · Destroyed NTSB LAX74OL032Accident · 2 fatalClosedAero Comdr 100 · Hermosillo, MexicoSep 29, 1973 · N4038X · Substantial damage NTSB FTW74DRG14Accident · 2 fatalClosedPiper PA-28 · Coahuila, MexicoAug 18, 1973 · N1876T · Destroyed NTSB FTW74DRA15Accident · 1 fatalClosedPiper PA-28 · Empalme, MexicoJul 31, 1973 · N5198L · Destroyed NTSB LAX73AL028Accident · 1 fatalClosedPiper PA-28 · Mexicali, MexicoDec 17, 1972 · N1256T · Destroyed NTSB LAX73OL006Accident · 3 fatalClosedPiper PA-24 · Topia, MexicoNov 22, 1972 · N8581P · Destroyed NTSB FTW72DQD16Accident · 4 fatalClosedCessna 172E · S.Buenaventra, MexicoNov 5, 1971 · N3602S · Destroyed NTSB FTW71DPA25Accident · 1 fatalClosedPiper PA-24 · Baborigane, MexicoMar 14, 1971 · N9104D · Destroyed NTSB FTW71DRG89Accident · 1 fatalClosedCessna 206 · Lagunitas, MexicoMar 1, 1971 · N2660X · Destroyed NTSB FTW71DRG42Accident · 3 fatalClosedCessna 172 · Tijuana, MexicoOct 25, 1970 · N8312B · Destroyed NTSB FTW71DQG46Accident · 2 fatalClosedPiper PA-30 · Juarez, MexicoSep 28, 1970 · N8825Y · Destroyed NTSB LAX71DUJ13Accident · 4 fatalClosedMooney M20C · Sonora, MexicoAug 2, 1970 · N9124V · Destroyed NTSB LAX69O0156Accident · 3 fatalClosedCessna 170 · Mexicali, MexicoSep 8, 1968 · N4248V · Destroyed NTSB UNK68X0137Accident · 2 fatalClosedCessna 140 · Tiajuana, MexicoApr 28, 1968 · N76659 · Destroyed NTSB UNK68X0126Accident · 1 fatalClosedBellanca 14-13 · Mazatlan, MexicoMar 17, 1968 · N86749 · Destroyed NTSB UNK68X0116Accident · 4 fatalClosedCessna 210 · Naucalpan, MexicoDec 22, 1967 · N3701Y · Destroyed NTSB FTW68O0007Accident · 1 fatalClosedPiper PA-25 · Ojinaga, MexicoSep 16, 1967 · N6526Z · Destroyed NTSB OAK67A0056Accident · 10 fatalClosedLockheed 18 · Baja, MexicoDec 20, 1966 · N2222B · Destroyed