Skip to content

NTSB investigations, 1973

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") = 1973 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\") = 1973
  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") = 1973
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 SEA74DYG21Accident · No injuriesClosedCessna 150 · Priest River, IDDec 2, 1973 · N7711E · Substantial damage NTSB SEA74DTI14Accident · No injuriesClosedBell 47G-3 · Missoula, MTDec 2, 1973 · N178B · Substantial damage NTSB OAK74FVW10Accident · No injuriesClosedPiper PA-23 · Las Vegas, NVDec 2, 1973 · N5171Y · Substantial damage NTSB OAK74DVM14Accident · No injuriesClosedRyan PT-22 · Morgan Hill, CADec 2, 1973 · N22JK · No damage NTSB OAK74AP021Accident · 2 fatalClosedBeech H35 · Georgetown, CADec 2, 1973 · N5581D · Destroyed NTSB OAK74AJA08Accident · No injuriesClosedMooney M20B · Kamuela, HIDec 2, 1973 · N74519 · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB NYC74FHJ16Accident · No injuriesClosedBeech V35B · White Plains, NYDec 2, 1973 · N4277A · Substantial damage NTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NEDec 2, 1973 · N2594L · Destroyed NTSB MKC74DCJ19Accident · No injuriesClosedBell 206A · North Platte, NEDec 2, 1973 · N7881S · Substantial damage NTSB MIA74DLD44Accident · Minor injuriesClosedRepublic RC-3 · Umatilla, FLDec 2, 1973 · N6277K · Substantial damage NTSB IAD74FIG15Accident · No injuriesClosedPiper PA-28 · Frederick, MDDec 2, 1973 · N9185W · Substantial damage NTSB IAD74DLJ24Accident · No injuriesClosedCessna 172M · Wilmington, NCDec 2, 1973 · N20512 · Substantial damage NTSB FTW74FPJ15Accident · No injuriesClosedCessna 177 · Norman, OKDec 2, 1973 · N3274T · Substantial damage NTSB FTW74DRJ20Accident · Minor injuriesClosedCessna 182 · Lufkin, TXDec 2, 1973 · N5991B · Substantial damage NTSB DEN74AD030Accident · 1 fatalClosedCessna 320 · Spanish Fork, UTDec 2, 1973 · N5204X · Destroyed NTSB CHI74DEE35Accident · No injuriesClosedCessna 180 · Joliet, ILDec 2, 1973 · N3196C · Substantial damage NTSB CHI74AC045Accident · No injuriesClosedDouglas DC3A · Ypsilanti, MIDec 2, 1973 · N8661 · Substantial damage NTSB SEA74DYE29Accident · No injuriesClosedCessna 180H · Tillacum, WADec 1, 1973 · N8237V · Substantial damage NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB NYC74FNE13Accident · No injuriesClosedCessna 150L · Chester, CTDec 1, 1973 · N18130 · Substantial damage NTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NEDec 1, 1973 · N3323A · Substantial damage NTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSDec 1, 1973 · N1502D · Substantial damage NTSB MKC74AK029Accident · 1 fatalClosedPiper PA-28 · Cuba, MODec 1, 1973 · N6554J · Destroyed NTSB IAD74AI031Accident · 3 fatalClosedPiper PA-28 · Jamestown, TNDec 1, 1973 · N8477W · Destroyed NTSB DEN74FTC22Accident · Minor injuriesClosedPiper PA-28 · Casper, WYDec 1, 1973 · N4944L · Substantial damage NTSB DEN74DQD12Accident · No injuriesClosedCessna 170B · Las Cruces, NMDec 1, 1973 · N43F · Substantial damage NTSB DEN74AD029Accident · 2 fatalClosedBeech A35 · Plain City, UTDec 1, 1973 · N8512A · Destroyed NTSB CHI74FEV29Accident · No injuriesClosedCessna 150L · Laharpe, ILDec 1, 1973 · N1545Q · Substantial damage NTSB CHI74FEM25Accident · No injuriesClosedBeech 95 · Midland, MIDec 1, 1973 · N274C · Substantial damage NTSB CHI74DEP23Accident · Minor injuriesClosedAeronca 11AC · Neshkoro, WIDec 1, 1973 · N9353E · Substantial damage NTSB CHI74DEA22Accident · No injuriesClosedPiper PA-22 · Francisco, INDec 1, 1973 · N4698Z · Substantial damage NTSB SEA74DYA16Accident · No injuriesClosedCessna 150F · Rexburg, IDNov 30, 1973 · N8292F · Substantial damage NTSB SEA74AYE28Accident · Serious injuriesClosedBeech A23-19 · Everett, WANov 30, 1973 · N8735M · Substantial damage NTSB NYC74FFA17Accident · 1 fatalClosedCessna 140A · Scotia, NYNov 30, 1973 · N3787V · Destroyed NTSB MIA74FKG45Accident · No injuriesClosedAeronca L-16 · Brunswick, GANov 30, 1973 · N2554B · Substantial damage NTSB MIA74DKJ33Accident · No injuriesClosedCessna 182 · New Hope, ALNov 30, 1973 · N217CC · Substantial damage NTSB LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANov 30, 1973 · N4741R · Substantial damage NTSB LAX74AL043Accident · 3 fatalClosedBeech 23 · Gorman, CANov 30, 1973 · N2360Z · Destroyed NTSB FTW74DPA13Accident · No injuriesClosedCessna 150L · Poynor, TXNov 30, 1973 · N5302Q · Substantial damage NTSB OAK74FXQ16Accident · Minor injuriesClosedCessna 210 · Carson City, NVNov 29, 1973 · N7480E · Substantial damage NTSB OAK74DVA36Accident · No injuriesClosedCessna 150L · Modesto, CANov 29, 1973 · N18160 · Destroyed NTSB MIA740KT47Accident · No injuriesClosedCessna 402 · San Vicente, MexicoNov 29, 1973 · N111RN · Destroyed NTSB FTW74FRD19Accident · No injuriesClosedBell 212 · Ehib 370 Gulf Mex (Gulf of Mexico)Nov 29, 1973 · N83235 · No damage NTSB FTW74FPJ14Accident · No injuriesClosedPiper PA-28 · Sayre, OKNov 29, 1973 · N8540N · Substantial damage NTSB FTW74DRG40Accident · Serious injuriesClosedPiper PA-28 · Mexico City, MexicoNov 29, 1973 · N5872U · Destroyed NTSB FTW74DPG39Accident · No injuriesClosedCessna 172 · Carlisle, ARNov 29, 1973 · N8462L · Substantial damage NTSB DEN74AD028Accident · 3 fatalClosedCessna 182 · Cokeville, WYNov 29, 1973 · N9338G · Destroyed NTSB DEN74AD027Accident · 1 fatalClosedCessna 182C · Walden, CONov 29, 1973 · N175X · Destroyed NTSB NYC74DHA19Accident · No injuriesClosedPiper PA-24 · Schwenksville, PANov 28, 1973 · N5478P · Substantial damage