Skip to content

NTSB investigations, 1973

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") = 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 IAD74AI035Accident · Minor injuriesClosedDouglas DC-9 · Greensboro, NCDec 17, 1973 · N8978E · Substantial damage NTSB DEN74FQA27Accident · No injuriesClosedCessna 182 · Albuquerque, NMDec 17, 1973 · N9363G · Substantial damage NTSB DCA74AZ014Accident · Serious injuriesClosedDouglas DC-10 · Boston, MADec 17, 1973 · EC-CBN · Substantial damage NTSB OAK74DXQ17Accident · Minor injuriesClosedPiper PA-28R · Lake Tahoe, CADec 16, 1973 · N5146S · Substantial damage NTSB MKC74FER26Accident · Serious injuriesClosedPiper PA-28 · Rochester, MNDec 16, 1973 · N1549J · Destroyed NTSB MIA74DKJ35Accident · Minor injuriesClosedPitts S-2A · Letohatchee, ALDec 16, 1973 · N80029 · Destroyed NTSB FTW74AF043Accident · 2 fatalClosedAeronca 7BCM · Grainola, OKDec 16, 1973 · N75068 · Destroyed NTSB CHI74DEM30Accident · Minor injuriesClosedPiper PA-11 · Newaygo, MIDec 16, 1973 · N78698 · Substantial damage NTSB SEA74DTI15Accident · No injuriesClosedPiper PA-22 · Hogeland, MTDec 15, 1973 · N803A · Substantial damage NTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYDec 15, 1973 · N2641 · 2 aircraft · Destroyed NTSB MKC74AK032Accident · 1 fatalClosedBellanca 7GCBC · Lebanon, SDDec 15, 1973 · N12201 · Destroyed NTSB IAD74FIG18Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDDec 15, 1973 · N5663Z · Substantial damage NTSB IAD74FID24Accident · Minor injuriesClosedCessna 150K · St Stephens C, VADec 15, 1973 · N5703G · Substantial damage NTSB FTW74FRJ21Accident · No injuriesClosedHelio Acft H-295 · Mt.Pleasant, TXDec 15, 1973 · N6350V · Substantial damage NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYDec 15, 1973 · N19583 · Destroyed NTSB DCA74AZ013Accident · 3 fatalClosedLockheed 1049H · Miami, FLDec 15, 1973 · N6917C · Destroyed NTSB CHI74DEC22Accident · Minor injuriesClosedTaylorcraft BC12-D · Owosso, MIDec 15, 1973 · N5123M · Substantial damage NTSB OAK74FJA10Accident · No injuriesClosedCessna 177A · Kalapana, HIDec 14, 1973 · N30599 · Substantial damage NTSB MIA74FKG47Accident · Serious injuriesClosedAeronca 7AC · Dalton, GADec 14, 1973 · N83556 · Substantial damage NTSB MIA74DLD46Accident · No injuriesClosedEL Tomcat 47 · Arcadia, FLDec 14, 1973 · N208B · Substantial damage NTSB FTW74FPM14Accident · No injuriesClosedBoeing A75 · Tulsa, OKDec 14, 1973 · N61492 · Substantial damage NTSB FTW74DRG43Accident · No injuriesClosedAeronca 7AC · Marble Falls, TXDec 14, 1973 · N2603E · Substantial damage NTSB FTW74DRD21Accident · Serious injuriesClosedBell 47G-4A · Gulf Of Mexico (Gulf of Mexico)Dec 14, 1973 · N6234N · 2 aircraft · Substantial damage NTSB DEN74DTE38Accident · No injuriesClosedAeronca L-3 · Stratton, CODec 14, 1973 · N49112 · Destroyed NTSB CHI74FEM29Accident · No injuriesClosedCessna 411 · Lansing, MIDec 14, 1973 · N1056R · Destroyed NTSB ANC74AA049Accident · 2 fatalClosedPiper PA-18 · Puntilla, AKDec 14, 1973 · N7908P · Destroyed NTSB MIA74DLD51Accident · No injuriesClosedBeech A24R · Cocoa Beach, FLDec 13, 1973 · N24625 · Substantial damage NTSB MIA74DKT50Accident · No injuriesClosedCessna 172 · Miami, FLDec 13, 1973 · N8443U · Substantial damage NTSB LAX74FUA15Accident · No injuriesClosedBeech E55 · Fullerton, CADec 13, 1973 · N305T · Substantial damage NTSB FTW74AF042Accident · No injuriesClosedCessna 180H · Pilottown, LADec 13, 1973 · N7994V · Substantial damage NTSB FTW74AF041Accident · No injuriesClosedBeech E18S · Oklahoma Cty, OKDec 13, 1973 · N2939B · Substantial damage NTSB CHI74AC049Accident · No injuriesClosedBeech E18S · Geneva, ILDec 13, 1973 · N503J · Substantial damage NTSB MKC74AK031Accident · 1 fatalClosedBeech 95-B55 · Willow Springs, MODec 12, 1973 · N8689Q · Destroyed NTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MODec 12, 1973 · N12271 · Destroyed NTSB FTW74DPD32Accident · No injuriesClosedStinson 108 · Mineral Wells, TXDec 12, 1973 · N8406K · Substantial damage NTSB CHI74FEV30Accident · Serious injuriesClosedCessna P206 · Macomb, ILDec 12, 1973 · N2567X · Destroyed NTSB CHI74FEE36Accident · No injuriesClosedPiper PA-28 · Chicago, ILDec 12, 1973 · N5796F · Substantial damage NTSB SEA74FYE31Accident · Serious injuriesClosedCessna 337A · Maynard, WADec 11, 1973 · N5313S · Destroyed NTSB SEA74DYE30Accident · No injuriesClosedCessna 182 · Tacoma, WADec 11, 1973 · N5501B · Substantial damage NTSB NYC74FGM12Accident · No injuriesClosedErco 415-C · West Middlesex, PADec 11, 1973 · N2955H · Substantial damage NTSB LAX74DUM14Accident · Serious injuriesClosedSchweizer SGU222 · San Diego, CADec 11, 1973 · N2718Z · Substantial damage NTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYDec 11, 1973 · N3250T · Substantial damage NTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VADec 11, 1973 · N1905T · Destroyed NTSB FTW74DQG33Accident · No injuriesClosedPiper PA-25 · Floydada, TXDec 11, 1973 · N6057Z · Substantial damage NTSB CHI74DEM28Accident · No injuriesClosedCessna 177 · Evart, MIDec 11, 1973 · N3284T · Substantial damage NTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damage NTSB MIA74DKJ34Accident · No injuriesClosedTradewind C-45H · Jasper, ALDec 10, 1973 · N711FW · Substantial damage NTSB LAX74DUG34Accident · No injuriesClosedBeech A35 · Boron, CADec 10, 1973 · N597B · Substantial damage NTSB DEN74DTE33Accident · No injuriesClosedPiper PA-22 · Byers, CODec 10, 1973 · N8585C · Substantial damage