Skip to content

NTSB investigations, 1972

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI73FEM30Accident · No injuriesClosedAeronca 7AC · Charlotte, MIDec 3, 1972 · N2757E · Substantial damage NTSB CHI73FEI22Accident · No injuriesClosedBeech C23 · Cleveland, OHDec 3, 1972 · N7675R · Substantial damage NTSB CHI73DET11Incident · Minor injuriesClosedPiper PA-28 · Culver, INDec 3, 1972 · N673FL · Minor damage NTSB SEA73DYI08Accident · Minor injuriesClosedPiper PA-28 · Klamath Fall, ORDec 2, 1972 · N1223T · Substantial damage NTSB NYC73DNC41Accident · No injuriesClosedCessna 150 · Brewer, MEDec 2, 1972 · N17046 · Substantial damage NTSB NYC73DGT06Accident · No injuriesClosedPiper PA-23 · Lititz, PADec 2, 1972 · N4040P · Substantial damage NTSB MIA73FKG50Accident · Minor injuriesClosedCessna 150H · Reidsville, GADec 2, 1972 · N6982S · Substantial damage NTSB MIA73DLD38Accident · No injuriesClosedPitts Spcial · Melbourne, FLDec 2, 1972 · N5311 · 2 aircraft · No damage NTSB FTW73FQG25Accident · Serious injuriesClosedStits SA6-B · Spearman, TXDec 2, 1972 · N5960 · Destroyed NTSB CHI73FEG12Accident · Serious injuriesClosedAmer Avco AA1A · Dayton, OHDec 2, 1972 · N9278L · Destroyed NTSB CHI73DEK11Accident · No injuriesClosedPiper PA-24 · Bryan, OHDec 2, 1972 · N6143P · Substantial damage NTSB NYC73AN077Accident · 1 fatalClosedCessna 210 · Greensboro, NCDec 1, 1972 · N20EA · Minor damage NTSB MIA73DKW12Accident · No injuriesClosedCessna 172G · Waverly, TNDec 1, 1972 · N5965R · Substantial damage NTSB FTW73AF022Accident · 1 fatalClosedCessna 150E · Flatonia, TXDec 1, 1972 · N3034J · Destroyed NTSB SEA73FTI16Accident · No injuriesClosedCessna 175B · Great Falls, MTNov 30, 1972 · N8170T · Substantial damage NTSB SEA73AS014Accident · 2 fatalClosedBeech H35 · Lolo, MTNov 30, 1972 · N4695D · Destroyed NTSB NYC73IN076Incident · No injuriesClosedBeech 99 · New Cumberland, PANov 30, 1972 · N7486N · Minor damage NTSB NYC73AN075Accident · 1 fatalClosedBeech D50 · Avoca, PANov 30, 1972 · N634H · Destroyed NTSB MIA73OKT41Accident · No injuriesClosedCessna 172 · Freeport, Burkina FasoNov 30, 1972 · N7213A · Substantial damage NTSB LAX73DVA30Accident · No injuriesClosedBell 47G-2 · Richgrove, CANov 30, 1972 · N10194 · Substantial damage NTSB FTW73AF021Accident · 1 fatalClosedCessna 150F · New Orleans, LANov 30, 1972 · N6958F · Destroyed NTSB CHI73AC052Accident · 1 fatalClosedBeech 3TM · Missing AircraftNov 30, 1972 · N15212 · Destroyed NTSB ANC73DAG67Accident · No injuriesClosedTaylorcraft BC12-D · Anchorage, AKNov 30, 1972 · N94964 · Substantial damage NTSB SEA73AS016Accident · 1 fatalClosedCessna 206D · Kamian, IDNov 29, 1972 · N8768Z · Destroyed NTSB OAK73FJA09Accident · No injuriesClosedBell 206A · Kaimuki, HINov 29, 1972 · N1404W · Substantial damage NTSB OAK73DVG33Accident · No injuriesClosedCessna 150 · Davis, CANov 29, 1972 · N3476J · Substantial damage NTSB NYC73ANO74Accident · 1 fatalClosedCessna 172 · Missing AircraftNov 29, 1972 · N7344T · Destroyed NTSB MKC73AK040Accident · 2 fatalClosedBeech C-45H · St.Paul, MNNov 29, 1972 · N717B · Destroyed NTSB MIA73FKJ35Accident · No injuriesClosedSwift GC-1B · Birmingham, ALNov 29, 1972 · N2328B · Substantial damage NTSB CHI73FEI20Accident · No injuriesClosedCessna 150E · Wadsworth, OHNov 29, 1972 · N4045U · Destroyed NTSB UNK73X0103Incident · No injuriesClosedBeech 65-80 · Ora, LibyaNov 28, 1972 · N2613 · Minor damage NTSB SEA73ASO13Accident · 1 fatalClosedLuscombe 8A · Ellensburg, WANov 28, 1972 · N1170B · Destroyed NTSB OAK73AP014Accident · 3 fatalClosedBeech C18S · Searchlight, NVNov 28, 1972 · N5552V · Destroyed NTSB NYC73F1D12Accident · No injuriesClosedEnstrom F-28A · Charlottsville, VANov 28, 1972 · N9569 · Substantial damage NTSB MKC73FCJ26Accident · No injuriesClosedBeech D95A · North Platte, NENov 28, 1972 · N816G · Substantial damage NTSB FTW73DPA19Accident · No injuriesClosedCessna 150 · Greenville, TXNov 28, 1972 · N1706Q · Substantial damage NTSB SEA73FYE21Accident · Minor injuriesClosedCessna T337D · Kent, WANov 27, 1972 · N85866 · Substantial damage NTSB MIA73FKG49Accident · Minor injuriesClosedCessna 150J · Hartwell, GANov 27, 1972 · N50572 · Destroyed NTSB MIA73DLD36Accident · No injuriesClosedCessna 150 · Winter Haven, FLNov 27, 1972 · N8269S · Substantial damage NTSB MIA73DKT30Accident · No injuriesClosedPiper PA-30 · Ft Lauderdale, FLNov 27, 1972 · N8503Y · Substantial damage NTSB MIA73AM058Accident · 3 fatalClosedBeech G35 · Nashville, TNNov 27, 1972 · N4548D · Destroyed NTSB CHI73FEV17Accident · No injuriesClosedPiper PA-28R · Fairfield, ILNov 27, 1972 · N4663J · Substantial damage NTSB CHI73FEE32Accident · No injuriesClosedBeech 65-B80 · Rockford, ILNov 27, 1972 · N7813L · Substantial damage NTSB CHI73AC051Accident · 2 fatalClosedAeronca 7AC · Georgetown, KYNov 27, 1972 · N83459 · Destroyed NTSB UNK73X0102Accident · No injuriesClosedPiper PA-28 · Tepic, MexicoNov 26, 1972 · N4860L · Substantial damage NTSB SEA73AS015Accident · 3 fatalClosedPiper PA-28 · Bend, ORNov 26, 1972 · N4447J · Substantial damage NTSB OAK73FVG32Accident · Serious injuriesClosedBellanca 17-30 · Auburn, CANov 26, 1972 · N4717V · Destroyed NTSB OAK73AP013Accident · 1 fatalClosedCessna 150D · Auburn, CANov 26, 1972 · N4107U · Destroyed NTSB NYC73DIJ13Accident · No injuriesClosedCessna U206 · Willamson, WVNov 26, 1972 · N4955F · Substantial damage NTSB MKC73DTK10Accident · No injuriesClosedPiper J3C · Volga, SDNov 26, 1972 · N35124 · Substantial damage