Skip to content

Final 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 per year

19622026

Final NTSB investigations, 1973 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

Where

Latest cases

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 AND c."completionStatus" = 'Completed' 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
    AND c.\"completionStatus\" = 'Completed'
  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
  AND c."completionStatus" = 'Completed'
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 SEA74DYG22Accident · No injuriesClosedPiper PA-28 · Richland, WADec 31, 1973 · N2350T · Substantial damage NTSB OAK74AP027Accident · 4 fatalClosedNavion A · Firebaugh, CADec 31, 1973 · N4582K · Destroyed NTSB MKC74DCJ22Accident · No injuriesClosedCessna 120 · Wilber, NEDec 31, 1973 · N2447N · Substantial damage NTSB MIA74FKG48Accident · Minor injuriesClosedCessna 150L · Tifton, GADec 31, 1973 · N5389Q · Destroyed NTSB LAX74DUJ38Accident · No injuriesClosedGrumman G-164A · Tonopah, AZDec 31, 1973 · N5363 · Substantial damage NTSB CHI74DEE41Accident · Minor injuriesClosedCessna 150 · Wheeling, ILDec 31, 1973 · N19277 · Substantial damage NTSB ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKDec 31, 1973 · N7694D · Substantial damage NTSB SEA74DYC30Accident · No injuriesClosedPiper PA-28 · Mocalla, ORDec 30, 1973 · N55620 · Substantial damage NTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WADec 30, 1973 · N58661 · Destroyed NTSB MKC74AK036Accident · No injuriesClosedDouglas DC-3 · Springfield, MODec 30, 1973 · N15565 · Substantial damage NTSB MIA74AM051Accident · 2 fatalClosedMooney M20F · Huntsville, ALDec 30, 1973 · N9619M · Destroyed NTSB FTW74FQG36Accident · No injuriesClosedBell 47G-2 · Stratford, TXDec 30, 1973 · N6708D · Substantial damage NTSB CHI74FEE44Accident · No injuriesClosedPiper PA-24 · Princeton, ILDec 30, 1973 · N6906P · Substantial damage NTSB CHI74DEM32Accident · No injuriesClosedPiper PA-32 · Boyne Falls, MIDec 30, 1973 · N15922 · Substantial damage NTSB CHI74DEE45Accident · No injuriesClosedCessna 150 · Lansing, ILDec 30, 1973 · N19240 · Substantial damage NTSB ANC74FAA23Accident · Minor injuriesClosedCessna 180 · Ft.Yukon, AKDec 30, 1973 · N9625B · Substantial damage NTSB ANC74DAG83Accident · Minor injuriesClosedPiper PA-12 · Anchorage, AKDec 30, 1973 · N3029M · Substantial damage NTSB SEA74FTA15Accident · No injuriesClosedCessna 150 · Belle Creek, MTDec 29, 1973 · N2295J · Substantial damage NTSB SEA74DYA18Accident · No injuriesClosedPiper PA-22 · Bone, IDDec 29, 1973 · N8002D · Substantial damage NTSB MKC74DER32Accident · No injuriesClosedCessna U206C · Austin, MNDec 29, 1973 · N29136 · Substantial damage NTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NEDec 29, 1973 · N8213B · Substantial damage NTSB MIA74DKT45Accident · No injuriesClosedCessna 180 · Delray Beach, FLDec 29, 1973 · N4571B · Substantial damage NTSB IAD74DKM33Accident · No injuriesClosedCessna 150 · High Point, NCDec 29, 1973 · N5958G · Substantial damage NTSB IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYDec 29, 1973 · N711RD · Destroyed NTSB FTW74DRJ22Accident · No injuriesClosedCessna 177 · Jonesville, LADec 29, 1973 · N3170T · Substantial damage NTSB DEN74FTE35Accident · No injuriesClosedCessna 172G · Broomfield, CODec 29, 1973 · N7128G · Substantial damage NTSB DEN74FTE34Accident · Minor injuriesClosedCessna 421B · Aspen, CODec 29, 1973 · N421AT · Substantial damage NTSB CHI74FEV31Accident · No injuriesClosedCessna P206 · Chillicothe, ILDec 29, 1973 · N2543X · Substantial damage NTSB CHI74FEC25Accident · No injuriesClosedCessna 411 · Birmingham, MIDec 29, 1973 · N7766X · Substantial damage NTSB CHI74FEC24Accident · Minor injuriesClosedBeech G18S · Ann Arbor, MIDec 29, 1973 · N118W · Destroyed NTSB CHI74DEV33Accident · No injuriesClosedPiper PA-28 · Decatur, ILDec 29, 1973 · N4770T · Substantial damage NTSB CHI74DEP27Accident · No injuriesClosedCessna 172 · Kenosha, WIDec 29, 1973 · N7120G · Substantial damage NTSB CHI74DEP25Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 29, 1973 · N3907Q · Substantial damage NTSB CHI74DEM33Accident · No injuriesClosedBell 47G-2 · Greenville, MIDec 29, 1973 · N6738D · Substantial damage NTSB SEA74DYE32Accident · No injuriesClosedHiller UH-12E · Queets, WADec 28, 1973 · N28875 · Destroyed NTSB OAK74DJA12Accident · Minor injuriesClosedCessna 207 · Lihue, HIDec 28, 1973 · N91017 · Destroyed NTSB LAX74AL047Accident · 5 fatalClosedCessna 210-5 · Hesperia, CADec 28, 1973 · N8263Z · Destroyed NTSB CHI74FEK12Accident · No injuriesClosedCessna 170B · Lima, OHDec 28, 1973 · N813MD · Substantial damage NTSB CHI74FEK10Accident · No injuriesClosedCessna 150J · Vanwert, OHDec 28, 1973 · N50675 · Substantial damage NTSB CHI74AC054Accident · 4 fatalClosedBeech A23A · Cabery, ILDec 28, 1973 · N2303W · Destroyed NTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WADec 27, 1973 · N66798 · Destroyed NTSB NYC74DHM14Accident · No injuriesClosedCessna 150 · Lincoln Park, NJDec 27, 1973 · N30425 · Substantial damage NTSB MKC74DCJ23Accident · No injuriesClosedCessna 170A · Merriman, NEDec 27, 1973 · N1418D · Substantial damage NTSB MIA74FKT44Accident · No injuriesClosedPiper PA-18A · Ft Lauderdale, FLDec 27, 1973 · N8573D · Substantial damage NTSB MIA74AM050Accident · Minor injuriesClosedDouglas DC3A · W.Palm Beach, FLDec 27, 1973 · N19428 · Substantial damage NTSB IAD74DLT11Accident · No injuriesClosedAero Comdr 500-A · Memphis, TNDec 27, 1973 · N6143X · Substantial damage NTSB IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDDec 27, 1973 · N8566M · Destroyed NTSB FTW74DRG47Accident · No injuriesClosedCessna 177RG · Reynosa, MexicoDec 27, 1973 · N1955Q · Substantial damage NTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LADec 27, 1973 · N7133X · Destroyed NTSB CHI74FET16Accident · Serious injuriesClosedPiper PA-24 · Fort Wayne, INDec 27, 1973 · N8074D · Destroyed