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 UNK68X0116Accident · 4 fatalClosedCessna 210 · Naucalpan, MexicoDec 22, 1967 · N3701Y · Destroyed NTSB UNK68X0113Accident · No injuriesClosedCessna 310 · Navojoa, MexicoDec 16, 1967 · N1793H · Minor damage NTSB FTW68O0012Accident · No injuriesClosedPiper PA-30 · Acapulco, MexicoDec 5, 1967 · N7160Y · Substantial damage NTSB FTW68O0014Accident · No injuriesClosedCessna 180 · Tamaulipas, MexicoDec 4, 1967 · N9275C · Substantial damage NTSB FTW68O0013Accident · No injuriesClosedCessna 182 · Ures, MexicoDec 3, 1967 · N2633Q · Substantial damage NTSB LAX68O0292Incident · No injuriesClosedCessna 320 · Novojoa, MexicoDec 1, 1967 · N3019T · Minor damage NTSB FTW68O0010Accident · Minor injuriesClosedPiper PA-24 · Zempoala, MexicoNov 19, 1967 · N5372P · Destroyed NTSB LAX68O0295Accident · Minor injuriesClosedPiper PA-22 · Nogales, MexicoNov 12, 1967 · N7202D · Destroyed NTSB LAX68D0177Accident · Minor injuriesClosedCessna 180 · Sasabe, MexicoNov 4, 1967 · N7912V NTSB FTW68O0009Accident · No injuriesClosedCessna 182 · Mante, MexicoOct 18, 1967 · N2716Q · Substantial damage NTSB FTW68O0008Accident · Minor injuriesClosedLuscombe 8A · Mendez, MexicoOct 13, 1967 · N37017 · Substantial damage NTSB FTW68O0007Accident · 1 fatalClosedPiper PA-25 · Ojinaga, MexicoSep 16, 1967 · N6526Z · Destroyed NTSB FTW68O0011Accident · No injuriesClosedBeech D35 · Torreon, MexicoSep 6, 1967 · N2128D · Substantial damage NTSB DEN68O0001Accident · No injuriesClosedCessna 206 · Zapotes, MexicoSep 3, 1967 · N3839G · Substantial damage NTSB MIA68D0240Accident · No injuriesClosedCessna 172 · Pachuca, MexicoSep 2, 1967 · N8119B · Substantial damage NTSB UNK67X0146Accident · No injuriesClosedCessna 206 · Yahalica, MexicoAug 9, 1967 · N5237U · Substantial damage NTSB FTW68O0006Accident · No injuriesClosedStinson 108-1 · Reynosa, MexicoJul 31, 1967 · N8706K · Substantial damage NTSB FTW68O0005Accident · Minor injuriesClosedAero Comdr 500 · Ixmequilpan, MexicoJul 31, 1967 · N6259B · Substantial damage NTSB LAX68D0056Accident · No injuriesClosedPiper PA-24 · Trinidad, MexicoJul 15, 1967 · N9145P · Substantial damage NTSB FTW68O0001Accident · No injuriesClosedAero Comdr 500B · Mulege, MexicoJul 2, 1967 · N6172X NTSB FTW68D0061Accident · No injuriesClosedBeech D35 · Toluca, MexicoJul 1, 1967 · N2161D · Substantial damage NTSB FTW68D0051Accident · No injuriesClosedCessna 210B · Mulege, MexicoMay 28, 1967 · N9584X · Substantial damage NTSB UNK67X0124Incident · No injuriesClosedBeech E35 · Mulege, MexicoApr 30, 1967 · N3328C · Minor damage NTSB FTW67D0671Accident · No injuriesClosedCessna 206 · Mulege, MexicoApr 27, 1967 · N2548X · Substantial damage NTSB FTW67D0579Accident · No injuriesClosedNavion A · Mulege, MexicoApr 10, 1967 · N8557H · Substantial damage NTSB FTW67D0530Accident · No injuriesClosedCessna 206 · Tamaulipas, MexicoApr 2, 1967 · N5223U · Substantial damage NTSB FTW67D0670Accident · No injuriesClosedBeech 95 · Sonoita, MexicoMar 29, 1967 · N2035C · Substantial damage NTSB FTW67D0605Accident · No injuriesClosedCessna 180 · Reynosa, MexicoMar 21, 1967 · N5308D · Substantial damage NTSB LAX67D0329Accident · Minor injuriesClosedPiper PA-24 · Magdalena, MexicoMar 13, 1967 · N7238P · Destroyed NTSB MKC67D0504Accident · No injuriesClosedTemco D-16 · Loretto, MexicoMar 2, 1967 · N8624H · Substantial damage NTSB FTW67D0629Accident · No injuriesClosedPiper PA-23 · Pitiquito, MexicoFeb 19, 1967 · N1294P · Destroyed NTSB FTW67D0477Accident · No injuriesClosedPiper PA-24 · Irapuato, MexicoFeb 17, 1967 · N8393P · Substantial damage NTSB FTW67D0504Accident · No injuriesClosedPiper PA-24 · Paredon, MexicoFeb 6, 1967 · N5151P · Substantial damage NTSB FTW67D0606Accident · No injuriesClosedMooney M21 · Mulege, MexicoJan 31, 1967 · N79813 · Substantial damage NTSB FTW67D0502Accident · No injuriesClosedCessna U206 · Batopilas, MexicoJan 29, 1967 · N5121U · Substantial damage NTSB UNK67X0109Accident · No injuriesClosedPiper PA-24 · Mulege, MexicoJan 21, 1967 · N6528P · Substantial damage NTSB OAK67A0056Accident · 10 fatalClosedLockheed 18 · Baja, MexicoDec 20, 1966 · N2222B · Destroyed NTSB FTW67D0573Accident · No injuriesClosedCessna 195 · Sinaloa, MexicoNov 15, 1966 · N9731A · Substantial damage NTSB UNK66X0130Accident · No injuriesClosedCessna 180 · Aguey, MexicoMar 8, 1966 · N224H · Substantial damage NTSB FTW66A0011Accident · No injuriesClosedFairchild C-82 · Campeche, MexicoJul 29, 1965 · N4834V · Destroyed