Skip to content

NTSB investigations, Mexico

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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

19652026

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' 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 LAX81OA021Accident · 2 fatalClosedPiper PA-31 · Magdelena, MexicoSep 30, 1980 · N3542X · Destroyed NTSB UNK79X0105Accident · No injuriesClosedPiper PA-24 · Ocoroni, MexicoDec 2, 1978 · N843PS · Destroyed NTSB UNK78X0126Accident · 1 fatalClosedPiper PA22 · Arramberri, MexicoJun 15, 1978 · N9014D · Destroyed NTSB UNK78X0116Accident · Serious injuriesClosedBeech 65 · Zamora, MexicoApr 24, 1978 · N640PH · Destroyed NTSB UNK78X0111Accident · Minor injuriesClosedBeech B35 · Martinez, MexicoMar 25, 1978 · N5185C · Substantial damage NTSB LAX780A003Accident · No injuriesClosedCessna 182 · Baja, MexicoFeb 27, 1978 · N3454U · Destroyed NTSB UNK78X0109Accident · No injuriesClosedPiper PA-32 · Cerralvo, MexicoFeb 21, 1978 · N3737M · Substantial damage NTSB FTW77OA005Accident · No injuriesClosedCessna 182H · Chimaltit, MexicoAug 10, 1977 · N8339S · Destroyed NTSB FTW77OA004Accident · No injuriesClosedPiper PA-28R · Cautrocienega, MexicoJun 17, 1977 · N3569Q · Substantial damage NTSB LAX77OA007Accident · Serious injuriesClosedPiper PA-22 · Puertocitas, MexicoJun 11, 1977 · N7040D · Destroyed NTSB LAX77OA008Accident · No injuriesClosedCessna 172D · Hermisillo, MexicoJun 9, 1977 · N8553X · Substantial damage NTSB FTW770A003Accident · No injuriesClosedCessna 207 · Matamoros, MexicoJun 6, 1977 · N1520U · Substantial damage NTSB MKC770A001Accident · No injuriesClosedCessna 177RG · Hermosillo, MexicoJan 5, 1977 · N2533V · Substantial damage NTSB LAX770A002Accident · No injuriesClosedCessna 172 · Baja, MexicoNov 6, 1976 · N73620 · Substantial damage NTSB FTW76O0010Accident · No injuriesClosedNavion B · Texistepec, MexicoSep 4, 1976 · N5258K · Substantial damage NTSB FTW76O0009Accident · No injuriesClosedCessna 320 · Ciudad, MexicoSep 2, 1976 · N4196T · Destroyed NTSB MIA760M010Accident · 3 fatalClosedAvions Mrcl Falcon · Acapulco, MexicoAug 7, 1976 · N888AR · Destroyed NTSB FTW76O0007Accident · No injuriesClosedCessna 206 · Tamaulipas, MexicoAug 7, 1976 · N1249V · Substantial damage NTSB LAX76A0021Accident · No injuriesClosedPiper PA-32R · Hermosillo, MexicoAug 6, 1976 · N4435X · Substantial damage NTSB FTW76ORG71Accident · 2 fatalClosedCessna 337 · Amatlan, MexicoJul 6, 1976 · N53417 · Destroyed NTSB FTW76DRG63Accident · 3 fatalClosedCessna 182 · Coahuila, MexicoJun 21, 1976 · N1402M · Destroyed NTSB LAX7600019Accident · Minor injuriesClosedCessna 182 · Tezapoca, MexicoJun 5, 1976 · N84488 · Substantial damage NTSB FTW76O0006Accident · 3 fatalClosedDehavilland DHC-2 · Acapulco, MexicoMay 14, 1976 · N3010F · Destroyed NTSB FTW76O0004Accident · No injuriesClosedPiper PA-23 · Huascato, MexicoMar 20, 1976 · N4779P · Destroyed NTSB FTW7600003Accident · No injuriesClosedCessna 206 · Tuxpan, MexicoMar 12, 1976 · N5020U · Substantial damage NTSB FTW76O0005Accident · No injuriesClosedPiper PA-24 · Colima, MexicoMar 6, 1976 · N7695P · Substantial damage NTSB FTW76OF002Accident · No injuriesClosedMaule M5220C · Jalisco, MexicoFeb 22, 1976 · N51637 · Substantial damage NTSB LAX76F0015Accident · No injuriesClosedBeech E18S · Bahia De L.A., MexicoFeb 20, 1976 · N342E · Substantial damage NTSB LAX7600016Accident · No injuriesClosedPiper PA-28 · Ensenada, MexicoFeb 20, 1976 · N7449J · Substantial damage NTSB LAX76O0009Accident · Minor injuriesClosedPiper PA-24 · Palenque, MexicoDec 26, 1975 · N7888P · Substantial damage NTSB LAX7600014Accident · No injuriesClosedCessna 210 · Culiacan, MexicoDec 25, 1975 · N5279V · Substantial damage NTSB LAX7600017Accident · Serious injuriesClosedPiper PA-32 · Bachiniva, MexicoDec 4, 1975 · N5227S · Substantial damage NTSB FTW76FPA16Accident · No injuriesClosedCessna 402 · Cerralvo, MexicoDec 1, 1975 · N33WT · Substantial damage NTSB LAX76O0013Accident · No injuriesClosedPiper PA-32 · Mulege, MexicoNov 5, 1975 · N4147R · Substantial damage NTSB LAX76A0008Accident · No injuriesClosedPiper PA-32 · Navajoa, MexicoSep 17, 1975 · N43152 · Substantial damage NTSB LAX76O0002Accident · 1 fatalClosedNavion B · Ensenada, MexicoAug 25, 1975 · N5273K · Destroyed NTSB FTW76OQD05Accident · No injuriesClosedCessna P206A · Juarez, MexicoAug 24, 1975 · N4663F · Destroyed NTSB LAX7600003Accident · Serious injuriesClosedCessna 195A · Mulege, MexicoAug 18, 1975 · N1076D · Substantial damage NTSB LAX76O0001Accident · Serious injuriesClosedCessna T337 · Mulege, MexicoJul 28, 1975 · N23664 · Destroyed NTSB LAX7500027Accident · No injuriesClosedCessna 150 · Mexicali, MexicoMay 3, 1975 · N3955J · Substantial damage NTSB FTW75OPG89Accident · No injuriesClosedBeech D18S · Jalisco, MexicoMay 3, 1975 · N64R · Destroyed NTSB LAX75O0031Accident · No injuriesClosedCessna 182 · Loreto, MexicoApr 28, 1975 · N52315 · Substantial damage NTSB LAX7500026Accident · No injuriesClosedCessna 182 · Loreto, MexicoApr 28, 1975 · N52315 · Substantial damage NTSB MKC75OK003Accident · No injuriesClosedCessna T210L · Valles, MexicoApr 12, 1975 · N22430 · Destroyed NTSB LAX76O0012Accident · 2 fatalClosedLockheed PV-1 · Culiacan, MexicoApr 1, 1975 · N730EG · Substantial damage NTSB LAX75O0021Accident · No injuriesClosedGrum Amer AA5 · Puertecitos, MexicoMar 22, 1975 · N7291L · Substantial damage NTSB LAX75O0018Accident · Minor injuriesClosedCessna 172 · Puertecitos, MexicoMar 6, 1975 · N18674 · Substantial damage NTSB FTW75ORG72Accident · Minor injuriesClosedCessna 205 · Muzquin, MexicoFeb 17, 1975 · N8318Z · Destroyed NTSB LAX7500025Accident · 3 fatalClosedCessna 180 · Vecora, MexicoJan 26, 1975 · N4659A · Destroyed NTSB LAX75O0016Accident · No injuriesClosedCessna 177RG · Platinito, MexicoDec 7, 1974 · N2151Q · Substantial damage