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 MKC74DCA17Accident · No injuriesClosedCessna 182P · Chesterfield, MONov 22, 1973 · N21358 · Substantial damage NTSB MIA74DKJ32Accident · Minor injuriesClosedCessna 206 · Huntsville, ALNov 22, 1973 · N4628F · Substantial damage NTSB MIA74AM047Accident · 4 fatalClosedCessna 182P · Key West, FLNov 22, 1973 · N21312 · Destroyed NTSB MIA74AM046Accident · 1 fatalClosedAero Comdr 680-E · Birmingham, ALNov 22, 1973 · N277LP · Destroyed NTSB LAX74FUM13Accident · Minor injuriesClosedRyan ST-3KR · Ramona, CANov 22, 1973 · N46705 · Substantial damage NTSB LAX74FUA13Accident · No injuriesClosedBeech B35 · Long Beach, CANov 22, 1973 · N3019V · Substantial damage NTSB IAD74DKM29Accident · No injuriesClosedCessna 150 · Gastonia, NCNov 22, 1973 · N6314G · Substantial damage NTSB FTW74DPD29Accident · Minor injuriesClosedCessna 150F · Breckenridge, TXNov 22, 1973 · N8073S · Destroyed NTSB FTW74AF036Accident · 1 fatalClosedPiper PA-28 · Slidell, LANov 22, 1973 · N6629J · Destroyed NTSB CHI74DEP22Accident · Minor injuriesClosedCessna 172G · Elkhorn, WINov 22, 1973 · N1346F · Substantial damage NTSB CHI74DEP21Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WINov 22, 1973 · N1783T · Substantial damage NTSB SEA74DTA14Accident · No injuriesClosedPiper J-3 · Culbertson, MTNov 21, 1973 · N70234 · Substantial damage NTSB NYC74FHM12Accident · Minor injuriesClosedBrantly B-2 · North Bergen, NJNov 21, 1973 · N5946X · Destroyed NTSB NYC74AN047Accident · 3 fatalClosedPiper PA-24 · Dupont, PANov 21, 1973 · N8149P · Destroyed NTSB MKC74FER23Accident · Serious injuriesClosedBeech V35B · St Paul, KSNov 21, 1973 · N1877W · Substantial damage NTSB MKC74DER24Accident · No injuriesClosedPiper PA-31 · Grand Marais, MNNov 21, 1973 · N7486L · Substantial damage NTSB LAX74OL078Accident · No injuriesClosedPiper PA-20 · La Salina, MexicoNov 21, 1973 · N1521A · Substantial damage NTSB LAX74OL040Accident · 5 fatalClosedBeech 95-B55 · R.Buena Vista, MexicoNov 21, 1973 · N8842M · Destroyed NTSB LAX74FUQ20Accident · No injuriesClosedBeech A35 · Burbank, CANov 21, 1973 · N5058C · Substantial damage NTSB LAX74FUJ31Accident · No injuriesClosedAmer Avco AA5 · Phoenix, AZNov 21, 1973 · N9434L · Substantial damage NTSB FTW74FRG35Accident · Minor injuriesClosedAmer Avco AA-1A · Brownsville, TXNov 21, 1973 · N6426L · Substantial damage NTSB FTW74DPD27Accident · Minor injuriesClosedPiper PA-24 · Abilene, TXNov 21, 1973 · N6572P · Substantial damage NTSB DEN74AD026Accident · 2 fatalClosedCessna 421A · Roosevelt, UTNov 21, 1973 · N2217Q · Destroyed NTSB DEN74AD025Accident · No injuriesClosedCessna 310C · Montrose, CONov 21, 1973 · N1819H · Destroyed NTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · Destroyed NTSB MIA74FLA23Accident · No injuriesClosedPiper PA-24 · Jacksonville, FLNov 20, 1973 · N5549P · Substantial damage NTSB MIA74DKT39Accident · No injuriesClosedCessna 150 · Clewiston, FLNov 20, 1973 · N5646E · Substantial damage NTSB MIA74AM045Accident · 1 fatalClosedPiper PA-32 · Evergreen, ALNov 20, 1973 · N8665N · Destroyed NTSB LAX74FUJ33Accident · No injuriesClosedCessna 150L · Florence, AZNov 20, 1973 · N1613Q · Substantial damage NTSB IAD74FHD12Accident · No injuriesClosedPiper PA-28 · Wilmington, DENov 20, 1973 · N55598 · Substantial damage NTSB FTW74AF034Accident · Minor injuriesClosedBell 206B · Intrcstl Cty, LANov 20, 1973 · N7904J · Destroyed NTSB SEA74AS024Accident · 2 fatalClosedCessna 210 · Quilcene, WANov 19, 1973 · N9550T · Destroyed NTSB NYC74FNC31Accident · Serious injuriesClosedCessna 172M · Rangeley, MENov 19, 1973 · N92899 · Destroyed NTSB NYC74AN045Accident · 2 fatalClosedBeech T-34B · Kinston, NCNov 19, 1973 · N14514 · 2 aircraft · Destroyed NTSB MKC74FCQ17Accident · No injuriesClosedPiper PA-24 · Larned, KSNov 19, 1973 · N8131P · Substantial damage NTSB MKC74AK025Accident · 2 fatalClosedPiper PA-28R · Columbia, MONov 19, 1973 · N2307T · Destroyed NTSB MIA74FLD43Accident · No injuriesClosedCessna A188B · Zellwood, FLNov 19, 1973 · N21717 · Destroyed NTSB MIA74AM044Accident · 1 fatalClosedCessna 337 · Ft Lauderdale, FLNov 19, 1973 · N333DD · Destroyed NTSB LAX74FUM12Accident · No injuriesClosedHiller Acft UH-12E · Brawley, CANov 19, 1973 · N9770C · Substantial damage NTSB LAX74DUJ34Accident · No injuriesClosedBell 206B · Tucson, AZNov 19, 1973 · N42AL · Substantial damage NTSB DEN74FTE31Accident · Minor injuriesClosedBeech M35 · Denver, CONov 19, 1973 · N9310Y · Substantial damage NTSB SEA74FTA13Accident · No injuriesClosedCessna 172H · Forsyth, MTNov 18, 1973 · N1720F · Substantial damage NTSB SEA74DYI09Accident · No injuriesClosedCessna 177 · North Bend, ORNov 18, 1973 · N2289Y · Substantial damage NTSB OAK74FVA34Accident · Minor injuriesClosedBellanca 17-30 · Los Banos, CANov 18, 1973 · N4936V · Substantial damage NTSB OAK74FJA07Accident · 1 fatalClosedCessna 150L · Honolulu, HINov 18, 1973 · N6814G · Substantial damage NTSB NYC74FNE12Accident · Minor injuriesClosedCessna 150K · Hartford, CTNov 18, 1973 · N6209G · Substantial damage NTSB NYC74AN044Accident · 3 fatalClosedPiper PA-28 · Manchester, VTNov 18, 1973 · N9DC · Destroyed NTSB MIA74FLA22Accident · Minor injuriesClosedStinson 108 · Baker, FLNov 18, 1973 · N97378 · Substantial damage NTSB LAX74AL038Accident · 1 fatalClosedBeech 95-C55 · Kayenta, AZNov 18, 1973 · N2077W · Destroyed NTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNov 18, 1973 · N3556C · Destroyed