Skip to content

NTSB investigations, 1972

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 MKC73DER29Accident · No injuriesClosedCessna 180B · St. Cloud, MNDec 21, 1972 · N5095E · Substantial damage NTSB DEN73FTM14Accident · No injuriesClosedCessna 305A · Ogden, UTDec 21, 1972 · N5271G · Substantial damage NTSB CHI73AC059Accident · 2 fatalClosedBeech H18S · Bloominton, ILDec 21, 1972 · N800G · Destroyed NTSB NYC73AN087Accident · No injuriesClosedPiper PA-23 · Allentown, PADec 20, 1972 · N5811Y · Destroyed NTSB NYC73AN086Accident · 2 fatalClosedPiper PA-23 · New Boston, MIDec 20, 1972 · N6303Y · Destroyed NTSB MKC73FGC21Accident · 1 fatalClosedBeech T-34A · Wheeling, MODec 20, 1972 · N74020 · Substantial damage NTSB MKC73AKO43Accident · 5 fatalClosedCessna T210K · Eden Prarie, MNDec 20, 1972 · N8202M · Substantial damage NTSB MIA73FKT39Accident · 1 fatalClosedBoeing E75 · Clewiston, FLDec 20, 1972 · N1206M · Destroyed NTSB MIA73AMO64Accident · 2 fatalClosedCessna 310 · Shellman, GADec 20, 1972 · N2691C · Destroyed NTSB FTW73AF032Accident · 1 fatalClosedCessna 172F · Cleveland, TXDec 20, 1972 · N8589U · Destroyed NTSB FTW73AF031Accident · 2 fatalClosedPiper PA-28 · Grand Prairie, TXDec 20, 1972 · N9677W · Destroyed NTSB DCA73AZ004Accident · 10 fatalClosedConvair 880 · Chicago, ILDec 20, 1972 · N8807E · 2 aircraft · Substantial damage NTSB NYC73DNA32Accident · No injuriesClosedTaylorcraft BL1265 · E.Falmouth, MADec 19, 1972 · N34035 · Destroyed NTSB NYC73DHD73Accident · No injuriesClosedBrantly B-2 · Downingtown, PADec 19, 1972 · N4997C · Substantial damage NTSB NYC73AN091Accident · 2 fatalClosedBeech C35 · Malone, NYDec 19, 1972 · N5754K · Destroyed NTSB NYC73AN088Accident · 2 fatalClosedAmer Avco AA-1A · Clermont, PADec 19, 1972 · N9409L · Substantial damage NTSB NYC73AN085Accident · 2 fatalClosedPiper PA-22 · Newsoms, VADec 19, 1972 · N183A · Substantial damage NTSB MKC73AK042Accident · 2 fatalClosedCessna 172 · Concordia, KSDec 19, 1972 · N46155 · Destroyed NTSB MIA73FKG53Accident · No injuriesClosedCessna 150G · Chamblee, GADec 19, 1972 · N8392J · Substantial damage NTSB CHI73FEV18Accident · No injuriesClosedBeech D55 · Champaign, ILDec 19, 1972 · N7731R · Substantial damage NTSB CHI73FEE36Accident · No injuriesClosedCessna 500 · Chicago, ILDec 19, 1972 · N522JD · Substantial damage NTSB UNK73X0104Accident · 4 fatalClosedPiper PA-30 · Mrn Diablotin, DRDec 18, 1972 · N7769Y · Destroyed NTSB OAK73DVM20Accident · No injuriesClosedJungster II RK-2 · Soledad, CADec 18, 1972 · N4086K · Substantial damage NTSB NYC73FNE13Accident · No injuriesClosedCessna 170 · Turner Falls, MADec 18, 1972 · N2587V · Substantial damage NTSB MKC73FCA12Accident · No injuriesClosedCessna 337B · St Louis, MODec 18, 1972 · N2421S · Substantial damage NTSB MKC73AK041Accident · 1 fatalClosedCessna 172K · Dickinson, NDDec 18, 1972 · N84887 · Destroyed NTSB MIA73DLD44Accident · No injuriesClosedPiper PA-28 · Myakka City, FLDec 18, 1972 · N626FL · Substantial damage NTSB MIA73DKT37Accident · No injuriesClosedCessna 150F · Lake Park, FLDec 18, 1972 · N7012F · Substantial damage NTSB LAX73DUM16Accident · No injuriesClosedCessna 177 · Imperial, CADec 18, 1972 · N3478T · Substantial damage NTSB FTW73DRD12Accident · No injuriesClosedGrumman G-164A · Duson, LADec 18, 1972 · N962X · Substantial damage NTSB FTW73AF030Accident · 1 fatalClosedCessna 210J · Bedford, TXDec 18, 1972 · N3319S · Destroyed NTSB FTW73AF029Accident · 1 fatalClosedHughes 369HS · Venice, LADec 18, 1972 · N9093F · Destroyed NTSB DEN73FTE40Accident · No injuriesClosedCessna 150E · Aurora, CODec 18, 1972 · N3918U · Substantial damage NTSB CHI73FEK12Accident · No injuriesClosedPiper PA-30 · St Clairsvle, OHDec 18, 1972 · N7495Y · Substantial damage NTSB CHI73FEG13Accident · No injuriesClosedCessna 172I · W Carrollton, OHDec 18, 1972 · N35456 · Substantial damage NTSB SEA73AS036Accident · 5 fatalClosedPiper PA-24 · Malad City, IDDec 17, 1972 · N5774P · Destroyed NTSB NYC73DID15Accident · No injuriesClosedErco 415-C · South Boston, VADec 17, 1972 · N87119 · Destroyed NTSB MIA73FKG52Accident · Minor injuriesClosedBeech A23 · Jefferson, GADec 17, 1972 · N3559R · Destroyed NTSB LAX73DVA34Accident · No injuriesClosedCessna 150 · Taft, CADec 17, 1972 · N7729E · Substantial damage NTSB LAX73AL028Accident · 1 fatalClosedPiper PA-28 · Mexicali, MexicoDec 17, 1972 · N1256T · Destroyed NTSB FTW73DRG38Accident · No injuriesClosedCessna 182 · Progresso, MexicoDec 17, 1972 · N9291G · Substantial damage NTSB DEN73DTC14Accident · No injuriesClosedPiper PA-28 · Cheyenne, WYDec 17, 1972 · N470FL · Substantial damage NTSB CHI73FEC18Accident · No injuriesClosedStinson 108-3 · Brighton, MIDec 17, 1972 · N6769M · Substantial damage NTSB NYC73AN084Accident · 3 fatalClosedCessna 421 · Cheektowaga, NYDec 16, 1972 · N121X · Destroyed NTSB MIA73FLD47Accident · No injuriesClosedPiper PA-28 · Sarasota, FLDec 16, 1972 · N4206T · Substantial damage NTSB MIA73FLA24Accident · No injuriesClosedCessna 310 · Jacksonville, FLDec 16, 1972 · N4849B · Substantial damage NTSB MIA73DLD46Accident · No injuriesClosedPiper PA-22 · Ft Pierce, FLDec 16, 1972 · N5072Z · Substantial damage NTSB MIA73DKJ37Accident · No injuriesClosedPiper PA-28 · Russellville, ALDec 16, 1972 · N8370R · Substantial damage NTSB LAX73AL027Accident · 1 fatalClosedAmer Avco AA-1A · Pacoima, CADec 16, 1972 · N9358L · Destroyed NTSB DEN73DQA22Accident · Minor injuriesClosedLuscombe 11A · Santa Fe, NMDec 16, 1972 · N1650B · Destroyed