Skip to content

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, newest first

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' 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'
  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'
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 FTW75ORG71Accident · No injuriesClosedPiper PA-30 · Zihuathnejo, MexicoNov 22, 1974 · N78684 · Substantial damage NTSB FTW75ORG49Accident · No injuriesClosedPiper PA-32 · Agualeguas, MexicoOct 11, 1974 · N3470W · Destroyed NTSB LAX75OL009Accident · No injuriesClosedCessna 150 · Rosarito, MexicoOct 6, 1974 · N11357 · Substantial damage NTSB LAX75OL007Accident · 1 fatalClosedCessna 337 · Chiconcuac, MexicoJul 28, 1974 · N85953 · Destroyed NTSB LAX75OL001Accident · No injuriesClosedCessna 172E · Ensenada, MexicoJul 26, 1974 · N5566T · Substantial damage NTSB FTW75OPA06Accident · Minor injuriesClosedPiper PA-32 · Mazatlan, MexicoJul 24, 1974 · N56662 · Destroyed NTSB FTW75ORG07Accident · No injuriesClosedCessna P206A · Coahuila, MexicoJul 7, 1974 · N5720J · Destroyed NTSB UNK74X0112Accident · No injuriesClosedLockheed 12A · Q.Roo, MexicoJun 24, 1974 · N36P · Substantial damage NTSB LAX75OL008Accident · 2 fatalClosedCessna 210 · Magdalena, MexicoMay 24, 1974 · N1187Q · Destroyed NTSB LAX74OL087Accident · No injuriesClosedPiper PA-28 · Hermosilla, MexicoMay 18, 1974 · N15735 · Substantial damage NTSB FTW74OQD20Accident · 2 fatalClosedCessna 210 · Arteaga, MexicoApr 26, 1974 · N59082 · Destroyed NTSB FTW74ORG81Accident · 2 fatalClosedCessna 182J · Zihauatanejo, MexicoApr 25, 1974 · N3302F · Destroyed NTSB LAX74OL076Incident · No injuriesClosedPiper PA-24 · Mexicali, MexicoApr 21, 1974 · N6744P · Minor damage NTSB LAX75OL006Accident · No injuriesClosedPiper PA-32 · Tecoripa, MexicoApr 17, 1974 · N98217 · Substantial damage NTSB OAK74DVG40Accident · No injuriesClosedPiper PA-28R · Mexicali, MexicoApr 8, 1974 · N2810T · Substantial damage NTSB LAX74OL064Accident · No injuriesClosedCessna 150 · Mazatlan, MexicoMar 9, 1974 · N1269Y · Substantial damage NTSB FTW74OPD36Accident · No injuriesClosedBeech V35A · Padilla, MexicoFeb 28, 1974 · N827W · Substantial damage NTSB LAX74OL067Accident · Serious injuriesClosedCessna 177 · Nogales, MexicoFeb 23, 1974 · N3130T · Destroyed NTSB LAX74OL086Accident · No injuriesClosedCessna 210 · Tijuana, MexicoFeb 17, 1974 · N3916Y · Substantial damage NTSB FTW74DRG60Accident · Serious injuriesClosedBreezy TCD 11BR · Guerrero, MexicoFeb 9, 1974 · N11WT · Destroyed NTSB FTW74DRA24Accident · No injuriesClosedBeech S35 · Lapesca, MexicoJan 26, 1974 · N5838K · Substantial damage NTSB FTW74DRG47Accident · No injuriesClosedCessna 177RG · Reynosa, MexicoDec 27, 1973 · N1955Q · Substantial damage NTSB LAX74OL051Accident · No injuriesClosedCessna 310 · Mazatlan, MexicoDec 26, 1973 · N3092D · Substantial damage NTSB LAX74OL049Accident · 4 fatalClosedMooney M20C · Mulege, MexicoDec 22, 1973 · N9082V · Destroyed NTSB OAK74DVD33Accident · 3 fatalClosedCessna 205 · Yecora, MexicoOct 28, 1973 · N8299Z · Destroyed NTSB IAD74DLQ16Accident · No injuriesClosedPiper PA-28 · Renosa, MexicoOct 14, 1973 · N15091 · Substantial damage NTSB LAX74OL032Accident · 2 fatalClosedAero Comdr 100 · Hermosillo, MexicoSep 29, 1973 · N4038X · Substantial damage NTSB DEN74DQA15Accident · No injuriesClosedBellanca 17-30 · Chihuahua, MexicoAug 26, 1973 · N4925V · Substantial damage NTSB LAX74OL022Accident · No injuriesClosedBeech 35 · Mulege, MexicoAug 25, 1973 · N520B · 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 LAX74OL007Accident · No injuriesClosedCessna 172L · Sonoyta, MexicoJul 14, 1973 · N1256T · Substantial damage NTSB LAX74OL009Accident · No injuriesClosedPiper PA-28 · Tiburon, MexicoJul 7, 1973 · N4801T · Destroyed NTSB DEN74OD010Accident · Minor injuriesClosedCessna TP206B · Tahuahueto, MexicoJun 10, 1973 · N4751F · Substantial damage NTSB OAK73DVD36Accident · No injuriesClosedPiper PA-24 · Mazatlan, MexicoMay 11, 1973 · N9468P · Substantial damage NTSB OAK73DVG63Accident · Serious injuriesClosedCessna T210L · Mexicali, MexicoApr 30, 1973 · N1160Q · Substantial damage NTSB FTW73DRG65Accident · No injuriesClosedCessna 150 · Matamoros, MexicoApr 1, 1973 · N7160C · Substantial damage NTSB SEA73OYE32Accident · Minor injuriesClosedCessna 172K · Baja, MexicoMar 13, 1973 · N7473G · Substantial damage NTSB FTW73DPD26Accident · No injuriesClosedPiper PA-32 · Ojinaga, MexicoMar 10, 1973 · N4138W · Substantial damage NTSB FTW73DRG86Accident · No injuriesClosedCessna 182P · Charcas, MexicoMar 3, 1973 · N21445 · Substantial damage NTSB CHI73DEP41Accident · Serious injuriesClosedPiper PA-28 · Hermosa, MexicoFeb 26, 1973 · N9809W · Destroyed NTSB FTW73DRG42Accident · No injuriesClosedCessna 210L · Muzquiz, MexicoJan 15, 1973 · N4616Q · Substantial damage NTSB MKC73DCA16Accident · No injuriesClosedBeechcraft K35 · Cardenas, MexicoJan 11, 1973 · N805R · Substantial damage NTSB LAX73OL008Accident · No injuriesClosedBellanca 17-31 · 1, MexicoDec 27, 1972 · N7357V · Substantial damage NTSB LAX73AL028Accident · 1 fatalClosedPiper PA-28 · Mexicali, MexicoDec 17, 1972 · N1256T · Destroyed NTSB FTW73DRG38Accident · No injuriesClosedCessna 182 · Progresso, MexicoDec 17, 1972 · N9291G · Substantial damage NTSB UNK73X0102Accident · No injuriesClosedPiper PA-28 · Tepic, MexicoNov 26, 1972 · N4860L · Substantial damage NTSB LAX73OL006Accident · 3 fatalClosedPiper PA-24 · Topia, MexicoNov 22, 1972 · N8581P · Destroyed NTSB LAX730LO07Accident · No injuriesClosedCessna 182 · Baja Calif, MexicoNov 9, 1972 · N8488S · Substantial damage NTSB LAX73OLO05Accident · No injuriesClosedPiper PA-32 · Mulege, MexicoSep 18, 1972 · N5252S · Substantial damage