Skip to content

NTSB investigations, 1972

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 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
  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
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 OAK73FJY10Accident · Serious injuriesClosedCessna 150H · Agana, GUDec 15, 1972 · N6788S · Destroyed NTSB OAK73DVM21Accident · No injuriesClosedBell 47G-2 · Salinas, CADec 15, 1972 · N6727D · Substantial damage NTSB NYC73AN083Accident · 4 fatalClosedCessna 411 · Winooski, VTDec 15, 1972 · N111DS · Destroyed NTSB MKC73DCD41Accident · No injuriesClosedCessna 150K · Waterloo, IADec 15, 1972 · N6404G · Substantial damage NTSB MKC73DCA11Accident · No injuriesClosedPiper PA-28R · Festus, MODec 15, 1972 · N3808T · Substantial damage NTSB MIA73AM062Accident · Minor injuriesClosedBoeing 747 · Miami, FLDec 15, 1972 · N602US · Substantial damage NTSB CHI73DEP34Accident · No injuriesClosedCessna 310 · Lake Geneva, WIDec 15, 1972 · N6886T · Substantial damage NTSB CHI73AC058Accident · 2 fatalClosedLear 23 · Romulus, MIDec 15, 1972 · N20M · Destroyed NTSB SEA73FYG21Accident · 2 fatalClosedSikorsky S-61A · Chelan, WADec 14, 1972 · N318Y · Destroyed NTSB NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDDec 14, 1972 · N6434G · Substantial damage NTSB NYC73DKM19Accident · No injuriesClosedSikorsky S-61L · Black Mtn, NCDec 14, 1972 · N402S · Substantial damage NTSB NYC73AN082Accident · 1 fatalClosedCessna 320D · Benton Hrbr, MIDec 14, 1972 · N9212U · Destroyed NTSB MIA73FLT14Accident · No injuriesClosedBeech D18S · Tunica, MSDec 14, 1972 · TG-HIH · Destroyed NTSB LAX73DVA33Accident · Minor injuriesClosedCessna 150J · Bakersfield, CADec 14, 1972 · N61337 · Substantial damage NTSB FTW73IF028Incident · Minor injuriesClosedBoeing 707 · Little Rock, ARDec 14, 1972 · N7569A · No damage NTSB DEN73FTC13Accident · No injuriesClosedPiper PA-30 · Riverton, WYDec 14, 1972 · N7657Y · Substantial damage NTSB CHI73FEP33Accident · No injuriesClosedCessna 172C · New Holstein, WIDec 14, 1972 · N1535Y · Substantial damage NTSB CHI73FEE35Accident · No injuriesClosedPiper PA-28 · Northbrook, ILDec 14, 1972 · N5393S · Substantial damage NTSB CHI73DEM32Accident · No injuriesClosedCessna 150 · Traverse Cty, MIDec 14, 1972 · N22120 · Substantial damage NTSB ANC73DAA18Accident · No injuriesClosedCessna 150G · Nenana, AKDec 14, 1972 · N2882S · Substantial damage NTSB NYC73FID14Accident · Serious injuriesClosedFairchild FH1100 · Roanoke, VADec 13, 1972 · N30VA · Substantial damage NTSB MKC73DCA09Accident · Minor injuriesClosedBell 47G-5 · Chesterfield, MODec 13, 1972 · N7042J · Destroyed NTSB MIA73FLD43Accident · Minor injuriesClosedStinson 108 · Lake Alfred, FLDec 13, 1972 · N97400 · Substantial damage NTSB MIA73DLD42Accident · No injuriesClosedDenson GN-1 · Tampa, FLDec 13, 1972 · N17RD · Substantial damage NTSB FTW73DRG32Accident · No injuriesClosedHughes 269A · Uvalde, TXDec 13, 1972 · N8774F · Substantial damage NTSB OAK73IP016Incident · No injuriesClosedCessna 320A · Redding, CADec 12, 1972 · N3044R · Minor damage NTSB NYC73AN080Accident · No injuriesClosedBoeing 707 · Jamaica, NYDec 12, 1972 · N788TW · Substantial damage NTSB NYC73AN079Accident · 1 fatalClosedCessna 172K · Bennington, VTDec 12, 1972 · N46717 · Destroyed NTSB MIA73DKW13Accident · Minor injuriesClosedCessna 182B · Gainesboro, TNDec 12, 1972 · N2491G · Substantial damage NTSB MIA73AM073Accident · 1 fatalClosedCessna 172 · Biloxi, MSDec 12, 1972 · N8015B · Destroyed NTSB FTW73AF027Accident · No injuriesClosedBeech C-45H · Houma, LADec 12, 1972 · N3329G · Substantial damage NTSB DEN73FTE39Accident · No injuriesClosedCessna 150 · Broomfield, CODec 12, 1972 · N18551 · Substantial damage NTSB CHI73AC057Accident · Minor injuriesClosedHawker-Sdly DH125 · Findlay, OHDec 12, 1972 · N521M · Destroyed NTSB CHI73AC056Accident · No injuriesClosedHamilton TC-45J · Cleveland, OHDec 12, 1972 · N10AS · Substantial damage NTSB CHI73AC055Accident · No injuriesClosedLear Jet 23 · Ypsilanti, MIDec 12, 1972 · N613W · Substantial damage NTSB OAK73FXQ19Accident · No injuriesClosedPiper PA-28 · Carson City, NVDec 11, 1972 · N8786W · Substantial damage NTSB OAK73FJA10Accident · No injuriesClosedCessna 150K · Barbers Pt, HIDec 11, 1972 · N6150G · Substantial damage NTSB NYC73DIJ12Accident · No injuriesClosedBeech 65-A80 · Ceredo, WVDec 11, 1972 · N314Q · Substantial damage NTSB MIA73AM061Accident · 1 fatalClosedAero Comdr 560-E · Tupelo, MSDec 11, 1972 · N2690B · Destroyed NTSB LAX73FUD06Accident · No injuriesClosedPiper PA-28 · Compton, CADec 11, 1972 · N7238J · Substantial damage NTSB DEN73DTE43Accident · No injuriesClosedCessna 182L · Littleton, CODec 11, 1972 · N3188R · Substantial damage NTSB CHI73FEM31Accident · No injuriesClosedPiper PA-23 · Gwinn, MIDec 11, 1972 · N3048P · Substantial damage NTSB ANC73AA037Accident · Serious injuriesClosedDehavilland DHC-2 · Sagwon, AKDec 11, 1972 · N53011 · Substantial damage NTSB OAK73FVG34Accident · No injuriesClosedAmer Avco AA-1A · Lincoln, CADec 10, 1972 · N9304L · Substantial damage NTSB OAK73DVD21Accident · No injuriesClosedCessna 172 · Livermore, CADec 10, 1972 · N5363T · Substantial damage NTSB MIA73FLD41Accident · No injuriesClosedBeech B95 · Masaryktown, FLDec 10, 1972 · N2060C · Substantial damage NTSB MIA73FLD40Accident · No injuriesClosedErco 415-C · St.Petersburg, FLDec 10, 1972 · N94114 · Substantial damage NTSB MIA73DLD39Accident · Minor injuriesClosedJeannies T. I · Palma Sola, FLDec 10, 1972 · N3779 · Substantial damage NTSB MIA73AM060Accident · 3 fatalClosedBeech 58 · Anderson, SCDec 10, 1972 · N1643W · Destroyed NTSB ANC73DAG69Accident · No injuriesClosedCessna 170B · Bethel, AKDec 10, 1972 · N4606C · Substantial damage