Skip to content

NTSB investigations, 1968, 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

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 year(c."eventDate") = 1968 AND 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 year(c.\"eventDate\") = 1968
    AND 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 year(c."eventDate") = 1968
  AND 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 FTW69D0012Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoDec 30, 1968 · N166DP · Substantial damage NTSB FTW69O0008Accident · No injuriesClosedCessna 177 · Mulege, MexicoDec 1, 1968 · N2340Y · Substantial damage NTSB LAX69O0211Accident · No injuriesClosedBeech D35 · Navajoa, MexicoNov 24, 1968 · N3700N · Substantial damage NTSB FTW69O0007Accident · Minor injuriesClosedCessna 195 · Calamahue, MexicoNov 11, 1968 · N4382N · Substantial damage NTSB LAX69O0156Accident · 3 fatalClosedCessna 170 · Mexicali, MexicoSep 8, 1968 · N4248V · Destroyed NTSB FTW69O0004Accident · Minor injuriesClosedCessna 182 · Zaragoza, MexicoSep 5, 1968 · N6028B · Substantial damage NTSB LAX69O0160Accident · No injuriesClosedCessna 337B · Mazatlan, MexicoSep 3, 1968 · N446AB · Substantial damage NTSB UNK68X0156Accident · No injuriesClosedCessna 195 · Huautl, MexicoJul 19, 1968 · N7770C · Substantial damage NTSB FTW69O0003Accident · No injuriesClosedCessna 320D · Torreon, MexicoJun 28, 1968 · N4171T · Destroyed NTSB FTW69O0002Accident · No injuriesClosedCessna 182 · Torreon, MexicoJun 27, 1968 · N5494B · Substantial damage NTSB UNK68X0147Accident · Minor injuriesClosedDouglas DC3A · Tampico, MexicoJun 7, 1968 · N74139 · Destroyed NTSB LAX69O0075Accident · No injuriesClosedCessna 182 · Moctezuma, MexicoJun 4, 1968 · N2083G · Substantial damage NTSB OAK69O0013Accident · No injuriesClosedPiper PA-28 · Mexicali, MexicoMay 25, 1968 · N9269J · Substantial damage NTSB FTW69O0019Accident · No injuriesClosedNavion A · Eltordo, MexicoMay 20, 1968 · N8750H · Substantial damage NTSB UNK68X0140Accident · Minor injuriesClosedBeech A35 · Moctezuma, MexicoMay 18, 1968 · N8740A · Substantial damage NTSB UNK68X0137Accident · 2 fatalClosedCessna 140 · Tiajuana, MexicoApr 28, 1968 · N76659 · Destroyed NTSB UNK68X0136Accident · Minor injuriesClosedPiper PA-22 · Mexicali, MexicoApr 27, 1968 · N5270Z · Substantial damage NTSB FTW68O0018Accident · Minor injuriesClosedWaco YKS-7 · Zaragoza, MexicoApr 18, 1968 · N29371 · Substantial damage NTSB UNK68X0132Accident · No injuriesClosedPiper PA-28 · Tampico, MexicoApr 17, 1968 · N6692W · Substantial damage NTSB UNK68X0131Accident · No injuriesClosedLockheed 18 · Loreto, MexicoApr 12, 1968 · N1940S · Substantial damage NTSB LAX68D0418Accident · No injuriesClosedLockheed 18 · Loreto, MexicoApr 11, 1968 · N1940S · Substantial damage NTSB FTW68O0016Accident · No injuriesClosedPiper PA-28 · Mulege, MexicoMar 22, 1968 · N3938T · Substantial damage NTSB UNK68X0126Accident · 1 fatalClosedBellanca 14-13 · Mazatlan, MexicoMar 17, 1968 · N86749 · Destroyed NTSB MIA68D0485Accident · No injuriesClosedCessna 182A · Cruillas, MexicoMar 3, 1968 · N2189G · Substantial damage NTSB UNK68X0124Accident · No injuriesClosedBellanca 14-19 · Tizmin, MexicoFeb 27, 1968 · N8518R · Substantial damage NTSB LAX68O0360Accident · No injuriesClosedCessna 170 · Ensenada, MexicoFeb 25, 1968 · N4272V · Substantial damage NTSB UNK68X0122Accident · No injuriesClosedPiper PA-25 · Mecayapan, MexicoFeb 17, 1968 · N6863Z · Substantial damage NTSB UNK68X0121Accident · No injuriesClosedPiper PA-28 · Reynosa, MexicoFeb 4, 1968 · N6984W · Substantial damage