Fatal NTSB investigations, 1973

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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.

Cases per year

19622026
Fatal NTSB investigations, 1973 per year, 1962–2026: 30,831 cases
196211
196313
1964539
1965560
1966581
1967625
1968718
1969655
1970643
1971664
1972697
1973731
1974727
1975692
1976707
1977713
1978800
1979691
1980672
1981705
1982638
1983651
1984617
1985555
1986507
1987496
1988502
1989484
1990499
1991482
1992494
1993437
1994445
1995456
1996421
1997402
1998422
1999404
2000443
2001412
2002417
2003440
2004418
2005428
2006408
2007387
2008373
2009359
2010363
2011398
2012389
2013344
2014360
2015365
2016341
2017338
2018361
2019381
2020294
2021321
2022330
2023295
2024292
2025275
2026243

Latest cases

Query with SQL
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
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CADec 31, 1973 · N4582K · DestroyedNTSB ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKDec 31, 1973 · N7694D · Substantial damageNTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WADec 30, 1973 · N58661 · DestroyedNTSB MIA74AM051Accident · 2 fatalClosedMooney M20F · Huntsville, ALDec 30, 1973 · N9619M · DestroyedNTSB IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYDec 29, 1973 · N711RD · DestroyedNTSB LAX74AL047Accident · 5 fatalClosedCessna 210-5 · Hesperia, CADec 28, 1973 · N8263Z · DestroyedNTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · DestroyedNTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WADec 27, 1973 · N66798 · DestroyedNTSB IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDDec 27, 1973 · N8566M · DestroyedNTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LADec 27, 1973 · N7133X · DestroyedNTSB OAK74AP025Accident · 3 fatalClosedBeech C35 · Kings Ldg, CADec 26, 1973 · N68626 · DestroyedNTSB FTW74AF047Accident · 1 fatalClosedBeech C-45H · Dallas, TXDec 26, 1973 · N118X · DestroyedNTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CODec 25, 1973 · N5543G · DestroyedNTSB MKC74AK035Accident · 6 fatalClosedBeech 95-55 · New Salem, NDDec 24, 1973 · N9385Y · DestroyedNTSB OAK74AP024Accident · 3 fatalClosedCessna 150C · Stockton, CADec 23, 1973 · N7925Z · DestroyedNTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SDDec 23, 1973 · N7020G · Substantial damageNTSB MIA74FLD49Accident · 1 fatalClosedPitts S1C · Leesburg, FLDec 23, 1973 · N7J · DestroyedNTSB CHI74AC052Accident · 2 fatalClosedCessna 182B · Claytonville, ILDec 23, 1973 · N7249E · DestroyedNTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPDec 22, 1973 · N21963 · DestroyedNTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PADec 22, 1973 · N4561D · DestroyedNTSB LAX74OL049Accident · 4 fatalClosedMooney M20C · Mulege, MexicoDec 22, 1973 · N9082V · DestroyedNTSB FTW74AF046Accident · 1 fatalClosedCessna 150G · De Soto, TXDec 22, 1973 · N2227J · DestroyedNTSB OAK74FJA11Accident · 4 fatalClosedPiper PA-28 · Kukuihaele, HIDec 21, 1973 · N4200T · DestroyedNTSB OAK74AP026Accident · 3 fatalClosedCessna 172I · Callahan, CADec 21, 1973 · N35578 · DestroyedNTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PADec 21, 1973 · N77RG · DestroyedNTSB NYC74IN055Incident · 1 fatalClosedBoeing 727 · Syracuse, NYDec 20, 1973 · N964 · No damageNTSB NYC74AN056Accident · 2 fatalClosedBeech 95-B55 · Colonie, NYDec 20, 1973 · N5729K · DestroyedNTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoDec 20, 1973 · N39385 · DestroyedNTSB MIA74AM049Accident · 2 fatalClosedBeech C90 · W Columbia, SCDec 20, 1973 · N711FC · DestroyedNTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CADec 20, 1973 · N6043J · DestroyedNTSB LAX74AL044Accident · 2 fatalClosedPiper PA-28 · Corona, CADec 20, 1973 · N5382W · Substantial damageNTSB OAK74AP023Accident · 2 fatalClosedPiper PA-22 · Concord, CADec 19, 1973 · N8245C · DestroyedNTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INDec 19, 1973 · N6299V · DestroyedNTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSDec 18, 1973 · N3269X · DestroyedNTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKDec 18, 1973 · N14099 · DestroyedNTSB UNK74X0101Incident · 31 fatalClosedBoeing 707 · Rome, ItalyDec 17, 1973 · N407PA · DestroyedNTSB FTW74AF043Accident · 2 fatalClosedAeronca 7BCM · Grainola, OKDec 16, 1973 · N75068 · DestroyedNTSB MKC74AK032Accident · 1 fatalClosedBellanca 7GCBC · Lebanon, SDDec 15, 1973 · N12201 · DestroyedNTSB DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYDec 15, 1973 · N19583 · DestroyedNTSB DCA74AZ013Accident · 3 fatalClosedLockheed 1049H · Miami, FLDec 15, 1973 · N6917C · DestroyedNTSB ANC74AA049Accident · 2 fatalClosedPiper PA-18 · Puntilla, AKDec 14, 1973 · N7908P · DestroyedNTSB MKC74AK031Accident · 1 fatalClosedBeech 95-B55 · Willow Springs, MODec 12, 1973 · N8689Q · DestroyedNTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MODec 12, 1973 · N12271 · DestroyedNTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VADec 11, 1973 · N1905T · DestroyedNTSB OAK74FVG20Accident · 1 fatalClosedSemco T · Chico, CADec 8, 1973 · N9975 · Substantial damageNTSB NYC74FHD28Accident · 1 fatalClosedTaylor Mono · Millville, NJDec 8, 1973 · N71RC · DestroyedNTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTDec 8, 1973 · N118B · DestroyedNTSB CHI74AC047Accident · 1 fatalClosedChampion 7GCAA · South Haven, MIDec 8, 1973 · N1122 · DestroyedNTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PADec 7, 1973 · N387B · DestroyedNTSB FTW74DRD20Accident · 2 fatalClosedCessna 182 · Mexico City, MexicoDec 7, 1973 · N869TX · Substantial damage