Skip to content

NTSB investigations, 1972, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c."eventDate") = 1972 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\") = 1972
    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") = 1972
  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 OAK73OJA02Accident · No injuriesClosedCessna 150G · Clark Afbase, RPApr 11, 1972 · N3843S · Substantial damage NTSB MIA72IM111Incident · No injuriesClosedDouglas DC-8 · Mexico City, MexicoApr 11, 1972 · N8613 · Minor damage NTSB FTW72DRG78Accident · Minor injuriesClosedCessna 172 · S.Luis Potosi, MexicoApr 10, 1972 · N5352T · Substantial damage NTSB IFO72DYZ04Accident · No injuriesClosedCessna 140 · Hanau, GeorgiaApr 9, 1972 · N76938 · Substantial damage NTSB OAK72DJY04Accident · 1 fatalClosedPilatus PC6CH2 · Ban Xieng, LaosApr 8, 1972 · N152L · Destroyed NTSB FTW72DRG64Accident · No injuriesClosedCessna 210T · Cabo San Lucs, MexicoApr 8, 1972 · N6763R · Substantial damage NTSB OAK72DJY02Accident · No injuriesClosedPilatus PC6CH2 · Bn Xieng Lom, LaosApr 7, 1972 · N359F · Substantial damage NTSB FTW72DRG63Accident · 1 fatalClosedCessna 210 · Novillo Cueva, MexicoApr 6, 1972 · N9438X · Substantial damage NTSB UNK72X0107Accident · No injuriesClosedAero Comdr 680 FL · Bremgarten, EswatiniMar 28, 1972 · N669SA · Substantial damage NTSB OAK72DJY18Accident · No injuriesClosedPilatus PC6-H2 · Song Lai, LaosMar 21, 1972 · N391R · Substantial damage NTSB OAK72FJZ00Accident · No injuriesClosedBoeing 707 · Tokyo, JAMar 20, 1972 · N307WA · Substantial damage NTSB OAK72DJY17Accident · No injuriesClosedPilatus PC6CH2 · Nong Kha, LaosMar 20, 1972 · N365F · Substantial damage NTSB OAK72FJY14Accident · 2 fatalClosedBeech 23 · Castillejos, RPMar 10, 1972 · N3786 · Destroyed NTSB FTW72DRG58Accident · No injuriesClosedBeech D18S · Nuevo Laredo, MexicoMar 10, 1972 · N80383 · Substantial damage NTSB DCA72RZ014Accident · No injuriesClosedBoeing 747 · London, United KingdomMar 8, 1972 · N738PA · 2 aircraft · Substantial damage NTSB UNK72X0105Accident · No injuriesClosedPiper PA-23 · Pelee Is, CanadaMar 6, 1972 · N1941 · Substantial damage NTSB BAH72ATC25Accident · 2 fatalClosedCessna 207 · San Salvdor, Burkina FasoMar 4, 1972 · N1607U · Destroyed NTSB FTW72DRG53Accident · No injuriesClosedCessna 172 · Puerto Penaso, MexicoMar 3, 1972 · N84308 · Substantial damage NTSB OAK72DJY12Accident · No injuriesClosedBell 204B · Vientiane, LaosFeb 27, 1972 · N8513F · Substantial damage NTSB MIA72OKT70Accident · Minor injuriesClosedMooney M20C · Porvenir Islnd, RPFeb 26, 1972 · N5844Q · Substantial damage NTSB OAK72FJA03Accident · No injuriesClosedRepublic RC-3 · Kasumiga-Ur, JAFeb 15, 1972 · N114N · Substantial damage NTSB MIA72OKT67Accident · Minor injuriesClosedBeech D18S · Pitts Twn, Burkina FasoFeb 13, 1972 · N90291 · Substantial damage NTSB OAK72DJY09Accident · No injuriesClosedCessna 172 · Castillejos, RPFeb 12, 1972 · N8422U · Substantial damage NTSB MIA72/M081Accident · No injuriesClosedLockheed Ga 382E · Montalvo, EcuadorFeb 10, 1972 · N9232R · Substantial damage NTSB OAK72DJY08Accident · No injuriesClosedDehavilland DHC-6 · Bouam Long, LaosFeb 6, 1972 · N774M · Substantial damage NTSB FTW72DRG57Accident · No injuriesClosedBeech C-18S · Santa Rosalin, MexicoFeb 1, 1972 · N7939C · Substantial damage NTSB MIA72OM076Accident · No injuriesClosedPiper PA-23 · St.Maarten, NTJan 31, 1972 · N19273 · Destroyed NTSB UNK72X0104Accident · 1 fatalClosedCessna 182 · Kibati, TanzaniaJan 26, 1972 · N6251A · Substantial damage NTSB LAX72DUJ76Accident · No injuriesClosedCessna T210K · Kino Bay, MexicoJan 14, 1972 · N9442M · Substantial damage