Skip to content

NTSB investigations, 1973, MI

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

NTSB investigations, 1973, MI per year, 1962–2026: 4,705 cases
1962	1
1963	1
1964	145
1965	153
1966	169
1967	193
1968	174
1969	182
1970	176
1971	159
1972	150
1973	149
1974	141
1975	115
1976	131
1977	106
1978	121
1979	118
1980	98
1981	116
1982	87
1983	101
1984	91
1985	82
1986	86
1987	57
1988	63
1989	69
1990	86
1991	65
1992	66
1993	60
1994	52
1995	56
1996	58
1997	52
1998	51
1999	50
2000	46
2001	62
2002	44
2003	50
2004	39
2005	43
2006	48
2007	36
2008	32
2009	35
2010	30
2011	34
2012	38
2013	29
2014	31
2015	26
2016	24
2017	22
2018	28
2019	23
2020	22
2021	29
2022	17
2023	21
2024	21
2025	26
2026	19

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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
  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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
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 CHI74DEM32Accident · No injuriesClosedPiper PA-32 · Boyne Falls, MIDec 30, 1973 · N15922 · 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 CHI74DEM33Accident · No injuriesClosedBell 47G-2 · Greenville, MIDec 29, 1973 · N6738D · Substantial damage NTSB CHI74DEM34Accident · No injuriesClosedAeronca 7AC · Ironwood, MIDec 23, 1973 · N83234 · Substantial damage NTSB CHI74AC066Accident · Serious injuriesClosedBoeing 727 · Detroit, MIDec 22, 1973 · N2914 · No damage NTSB CHI74DEM31Accident · No injuriesClosedCessna 150 · Ludington, MIDec 21, 1973 · N6491F · Substantial damage NTSB CHI74DEC23Accident · No injuriesClosedCessna 150 · Troy, MIDec 21, 1973 · N6463S · Substantial damage NTSB CHI74AC050Accident · No injuriesClosedGates Lear 25 · Detroit, MIDec 19, 1973 · N360AA · Substantial damage NTSB CHI74DEM30Accident · Minor injuriesClosedPiper PA-11 · Newaygo, MIDec 16, 1973 · N78698 · Substantial damage NTSB CHI74DEC22Accident · Minor injuriesClosedTaylorcraft BC12-D · Owosso, MIDec 15, 1973 · N5123M · Substantial damage NTSB CHI74FEM29Accident · No injuriesClosedCessna 411 · Lansing, MIDec 14, 1973 · N1056R · Destroyed NTSB CHI74DEM28Accident · No injuriesClosedCessna 177 · Evart, MIDec 11, 1973 · N3284T · Substantial damage NTSB CHI74AC047Accident · 1 fatalClosedChampion 7GCAA · South Haven, MIDec 8, 1973 · N1122 · Destroyed NTSB CHI74FEC21Accident · Minor injuriesClosedCessna 177 · Lapeer, MIDec 6, 1973 · N34150 · Substantial damage NTSB CHI74AC046Accident · Serious injuriesClosedBeech C-45H · Plymouth, MIDec 5, 1973 · N9909Z · Destroyed NTSB CHI74AC045Accident · No injuriesClosedDouglas DC3A · Ypsilanti, MIDec 2, 1973 · N8661 · Substantial damage NTSB CHI74FEM25Accident · No injuriesClosedBeech 95 · Midland, MIDec 1, 1973 · N274C · Substantial damage NTSB CHI74FEM27Accident · Minor injuriesClosedCessna 150 · Rockford, MINov 14, 1973 · N6853G · Substantial damage NTSB CHI74FEC20Accident · No injuriesClosedHughes 269A · Howell, MINov 9, 1973 · N8798F · Substantial damage NTSB CHI74FEC19Accident · No injuriesClosedCessna 120 · Troy, MIOct 27, 1973 · N76610 · Substantial damage NTSB CHI74FEC18Accident · Minor injuriesClosedCessna 120 · Stockbridge, MIOct 25, 1973 · N4085N · Substantial damage NTSB MKC74AK018Accident · 3 fatalClosedCessna 170A · Beaverton, MIOct 21, 1973 · N5580C · Destroyed NTSB CHI74DEM26Accident · No injuriesClosedCessna 172 · Lake City, MIOct 14, 1973 · N4435Q · Substantial damage NTSB CHI74AC036Accident · 3 fatalClosedPiper PA-28 · Port Austin, MIOct 12, 1973 · N9034W · Destroyed NTSB CHI74FEM24Accident · No injuriesClosedPiper PA-32 · Lansing, MIOct 11, 1973 · N4189R · Substantial damage NTSB CHI74AC034Accident · 8 fatalClosedBeech 95-B55 · Inkster, MIOct 9, 1973 · N233Z · Destroyed NTSB CHI74FEC17Accident · Minor injuriesClosedPiper PA-28 · Lapeer, MIOct 7, 1973 · N256W · Destroyed NTSB CHI74FEM23Accident · No injuriesClosedCessna 150 · Freeland, MIOct 6, 1973 · N5883G · Substantial damage NTSB CHI74DEC16Accident · No injuriesClosedCessna 177 · Birmingham, MIOct 5, 1973 · N34089 · Substantial damage NTSB CHI74AC030Accident · 1 fatalClosedCessna 337 · Mackinac Cty, MIOct 3, 1973 · N1876M · Destroyed NTSB CHI74FEC15Accident · No injuriesClosedPiper PA-32 · Brooklyn, MIOct 2, 1973 · N15279 · Substantial damage NTSB CHI74AC028Accident · Minor injuriesClosedCessna 206 · New Hudson, MIOct 2, 1973 · N2GS · Substantial damage NTSB CHI74AC026Accident · 2 fatalClosedCessna A150L · Holly, MISep 23, 1973 · N6047J · Destroyed NTSB CHI74FEC13Accident · Serious injuriesClosedPiper PA-28 · Salem, MISep 18, 1973 · N7953N · Substantial damage NTSB CHI74DEM21Accident · No injuriesClosedCessna 150 · Muskegon, MISep 16, 1973 · N51094 · Substantial damage NTSB CHI74FEM22Accident · No injuriesClosedMooney M20A · Muskegon, MISep 12, 1973 · N8348E · Substantial damage NTSB CHI74FEC12Accident · No injuriesClosedPiper PA-28 · Dexter, MISep 11, 1973 · N1760T · Substantial damage NTSB CHI74FEM20Accident · Serious injuriesClosedCessna 175 · Kalamazoo, MISep 9, 1973 · N7482M · No damage NTSB CHI74FEC10Accident · No injuriesClosedCessna 177 · Port Huron, MISep 2, 1973 · N30032 · Substantial damage NTSB CHI74FEC06Accident · No injuriesClosedPiper PA-30 · Dansville, MISep 2, 1973 · N7968Y · Substantial damage NTSB CHI74FEC11Accident · No injuriesClosedPiper PA-28R · Tecumseh, MISep 1, 1973 · N2944R · Substantial damage NTSB CHI73FEC09Accident · No injuriesClosedBensen Hydro · Bellevile Lk, MISep 1, 1973 · N5460 · Destroyed NTSB CHI74FEM07Accident · 1 fatalClosedBreezy RLU-1 · Hale, MIAug 31, 1973 · N4029 · Substantial damage NTSB CHI74DEM18Accident · No injuriesClosedPiper PA-16 · Lake City, MIAug 31, 1973 · N5868H · Substantial damage NTSB CHI74AC019Accident · 2 fatalClosedBeech A24R · Jackson, MIAug 31, 1973 · N8048R · Destroyed NTSB CHI74AC018Accident · 2 fatalClosedPiper PA-28R · Penconning, MIAug 31, 1973 · N3987T · Destroyed NTSB CHI74FEM17Accident · No injuriesClosedPiper PA-28 · Holland, MIAug 26, 1973 · N6103W · Substantial damage NTSB CHI74FEC08Accident · No injuriesClosedMaule M-4 · Otisville, MIAug 18, 1973 · N4736T · Substantial damage NTSB CHI74FEC07Accident · No injuriesClosedPiper PA-22 · Petersburg, MIAug 16, 1973 · N3767A · Substantial damage