Skip to content

NTSB investigations, 1973

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CHI74AC053Accident · No injuriesClosedBeech E18S · Chicago, ILDec 27, 1973 · N5612D · Substantial damage NTSB OAK74AP025Accident · 3 fatalClosedBeech C35 · Kings Ldg, CADec 26, 1973 · N68626 · Destroyed NTSB MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damage NTSB LAX74OL051Accident · No injuriesClosedCessna 310 · Mazatlan, MexicoDec 26, 1973 · N3092D · Substantial damage NTSB IAD74DLQ20Accident · No injuriesClosedCessna 172 · Moreland, KYDec 26, 1973 · N20351 · Substantial damage NTSB IAD74DKM32Accident · Minor injuriesClosedMooney M20B · Rosman, NCDec 26, 1973 · N74578 · Substantial damage NTSB FTW74FPM16Accident · No injuriesClosedCessna 150K · Sand Springs, OKDec 26, 1973 · N6032G · No damage NTSB FTW74AF047Accident · 1 fatalClosedBeech C-45H · Dallas, TXDec 26, 1973 · N118X · Destroyed NTSB DEN74FTM10Accident · No injuriesClosedCessna 205 · Bountiful, UTDec 26, 1973 · N1828Z · Substantial damage NTSB MKC74DER31Accident · No injuriesClosedCessna 182 · Austin, MNDec 25, 1973 · N9043X · Substantial damage NTSB MIA74FLA26Accident · No injuriesClosedBeech 65 · Gainsville, FLDec 25, 1973 · N330CB · Substantial damage NTSB IAD74DKW21Accident · No injuriesClosedLuscombe 8A · Morristown, TNDec 25, 1973 · N25215 · Substantial damage NTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CODec 25, 1973 · N5543G · Destroyed NTSB OAK74DVM15Accident · Minor injuriesClosedCessna 150G · San Jose, CADec 24, 1973 · N2249J · Substantial damage NTSB MKC74AK035Accident · 6 fatalClosedBeech 95-55 · New Salem, NDDec 24, 1973 · N9385Y · Destroyed NTSB LAX74FUQ25Accident · No injuriesClosedLuscombe 8A · Pacoima, CADec 24, 1973 · N71464 · Substantial damage NTSB FTW74FRA21Accident · Serious injuriesClosedMaule M4220C · Cordele, TXDec 24, 1973 · N2005U · Destroyed NTSB FTW74DPG41Accident · No injuriesClosedPiper PA-32 · Mena, ARDec 24, 1973 · N4048R · Substantial damage NTSB DEN74FTE32Accident · Serious injuriesClosedCessna 172D · Walsenburg, CODec 24, 1973 · N2324U · Destroyed NTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CADec 23, 1973 · N7925Z · Destroyed NTSB NYC74FHA22Accident · Minor injuriesClosedPiper PA-23 · Reading, PADec 23, 1973 · N1478P · Destroyed NTSB NYC74DNA29Accident · No injuriesClosedCessna 180 · Stow, MADec 23, 1973 · N1607C · Substantial damage NTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SDDec 23, 1973 · N7020G · Substantial damage NTSB MIA74FLD49Accident · 1 fatalClosedPitts S1C · Leesburg, FLDec 23, 1973 · N7J · Destroyed NTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLDec 23, 1973 · N8869K · Substantial damage NTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CADec 23, 1973 · N6206M · Substantial damage NTSB IAD74FKM31Accident · No injuriesClosedChampion 7HC · Thomasville, NCDec 23, 1973 · N8555E · Substantial damage NTSB FTW74DRG44Accident · Minor injuriesClosedLuscombe 8A · New Braunfels, TXDec 23, 1973 · N45722 · Substantial damage NTSB CHI74FEV32Accident · No injuriesClosedPiper PA-30 · Peoria, ILDec 23, 1973 · N7087Y · Substantial damage NTSB CHI74FEE42Accident · No injuriesClosedAmer Avco AA1 · Woodstock, ILDec 23, 1973 · N6152L · Substantial damage NTSB CHI74DEM34Accident · No injuriesClosedAeronca 7AC · Ironwood, MIDec 23, 1973 · N83234 · Substantial damage NTSB CHI74DEE38Accident · No injuriesClosedCessna 182F · Schaumberg, ILDec 23, 1973 · N3479U · Substantial damage NTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILDec 23, 1973 · N7249E · Destroyed NTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPDec 22, 1973 · N21963 · Destroyed NTSB NYC74FHA23Accident · No injuriesClosedCessna 177B · Manville, NJDec 22, 1973 · N34832 · Substantial damage NTSB NYC74DFJ25Accident · Minor injuriesClosedBeech E18S · Syracuse, NYDec 22, 1973 · N249K · Substantial damage NTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PADec 22, 1973 · N4561D · Destroyed NTSB MKC74DCQ21Accident · No injuriesClosedCessna 177 · Great Bend, KSDec 22, 1973 · N30335 · Substantial damage NTSB LAX74OL049Accident · 4 fatalClosedMooney M20C · Mulege, MexicoDec 22, 1973 · N9082V · Destroyed NTSB LAX74IL046Incident · No injuriesClosedCessna 310P · Riverside, CADec 22, 1973 · N3175K · Minor damage NTSB LAX74FUQ24Accident · Serious injuriesClosedLaister LP-49 · Santa Brbra, CADec 22, 1973 · N275LP · Destroyed NTSB FTW74FPM15Accident · No injuriesClosedHughes 269B · Tulsa, OKDec 22, 1973 · N11XC · Substantial damage NTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXDec 22, 1973 · N2227J · Destroyed NTSB CHI74FEK18Accident · No injuriesClosedCessna 172M · Defiance, OHDec 22, 1973 · N13364 · Substantial damage NTSB CHI74FEE37Accident · Serious injuriesClosedCessna TU206B · West Chicago, ILDec 22, 1973 · N3450L · Substantial damage NTSB CHI74AC066Accident · Serious injuriesClosedBoeing 727 · Detroit, MIDec 22, 1973 · N2914 · No damage NTSB ANC74DAG85Accident · No injuriesClosedCessna 185 · Illiamna, AKDec 22, 1973 · N185ML · Substantial damage NTSB SEA74AS026Accident · No injuriesClosedCessna 182 · Anacortes, WADec 21, 1973 · N1814X · Destroyed NTSB OAK74FJA11Accident · 4 fatalClosedPiper PA-28 · Kukuihaele, HIDec 21, 1973 · N4200T · Destroyed NTSB OAK74AP026Accident · 3 fatalClosedCessna 172I · Callahan, CADec 21, 1973 · N35578 · Destroyed