Skip to content

NTSB investigations, 1971, MI

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 CHI72DEM41Accident · No injuriesClosedPiper PA-28 · Alma, MIDec 31, 1971 · N8111W · Substantial damage NTSB CHI72FEC20Accident · No injuriesClosedCessna 172G · Corunna, MIDec 22, 1971 · N4142L · Substantial damage NTSB CHI72AC050Accident · 1 fatalClosedHughes 269C · Clarkston, MIDec 8, 1971 · N9652F · Destroyed NTSB CHI72FEM40Accident · No injuriesClosedTaylorcraft BC12-D · Williamsburg, MINov 25, 1971 · N95943 · Substantial damage NTSB CHI72FEC19Accident · No injuriesClosedBeech M35 · Owosso, MINov 23, 1971 · N9751R · Substantial damage NTSB CHI72FEC18Accident · No injuriesClosedCessna 337 · Ann Arbor, MINov 10, 1971 · N2113X · Substantial damage NTSB CHI72AC043Accident · 1 fatalClosedPiper PA-24 · Ypsilanti, MINov 10, 1971 · N6861P · Destroyed NTSB CHI72FEM39Accident · Minor injuriesClosedCessna 150 · Riverdale, MINov 8, 1971 · N7117S · Substantial damage NTSB CHI72FEM37Accident · Serious injuriesClosedCessna 180 · Portage, MIOct 30, 1971 · N4743B · Substantial damage NTSB CHI72FEM38Accident · No injuriesClosedDehavilland DH.115 · Kalamazoo, MIOct 29, 1971 · N11925 · Substantial damage NTSB CHI72FEM36Accident · No injuriesClosedRyan ST-3KR · Grand Rapids, MIOct 28, 1971 · N47554 · Substantial damage NTSB CHI72FEC17Accident · No injuriesClosedChampion 7ECA · Salem, MIOct 10, 1971 · N9006L · Substantial damage NTSB CHI72AC037Accident · 2 fatalClosedAeronca 7AC · South Lyon, MIOct 10, 1971 · N82410 · Destroyed NTSB CHI72AC036Accident · 3 fatalClosedPiper PA-24 · Brighton, MIOct 10, 1971 · N9015P · Destroyed NTSB CHI72AC032Accident · 1 fatalClosedPiper PA-28 · Concord, MIOct 8, 1971 · N4700L · Destroyed NTSB CHI72FEC16Accident · No injuriesClosedMcculloch J-2 · Linden, MIOct 4, 1971 · N4317G · Destroyed NTSB CHI72FEC15Accident · No injuriesClosedPiper PA-28 · S Rockwood, MIOct 3, 1971 · N95236 · Substantial damage NTSB CHI72DEC14Accident · No injuriesClosedAeronca 15AC · Morenci, MIOct 2, 1971 · N1175H · Substantial damage NTSB CHI72FEM35Accident · No injuriesClosedCessna 150K · Bath, MISep 30, 1971 · N6069G · Substantial damage NTSB CHI72AC030Accident · 4 fatalClosedPiper PA-28 · Crystal Fall, MISep 27, 1971 · N8178W · Destroyed NTSB CHI72FEM34Accident · No injuriesClosedCessna 150G · Montague, MISep 24, 1971 · N3444J · Substantial damage NTSB CHI72AC026Accident · 1 fatalClosedPiper PA-28 · Toledo, MISep 23, 1971 · N814CR · Destroyed NTSB CHI72FEM32Accident · No injuriesClosedBeech A23-24 · Wayland, MISep 21, 1971 · N3652Q · Substantial damage NTSB CHI72FEM33Accident · Minor injuriesClosedMccullough J-2 · Greenville, MISep 20, 1971 · N4313G · Substantial damage NTSB CHI72DEM31Accident · No injuriesClosedMooney M20F · Brevort, MISep 17, 1971 · N6765V · Substantial damage NTSB CHI72FEM30Accident · No injuriesClosedPiper PA-28 · Pellston, MISep 15, 1971 · N201MA · Substantial damage NTSB CHI72FEM29Accident · No injuriesClosedCessna 150 · Traverse Cty, MISep 15, 1971 · N8893S · Substantial damage NTSB CHI72FEC13Accident · No injuriesClosedPiper PA-22 · Marine City, MISep 14, 1971 · N8705C · Substantial damage NTSB CHI72FEM28Accident · Minor injuriesClosedCessna 172K · Acme, MISep 10, 1971 · CF-YJZ · Substantial damage NTSB CHI72AC021Accident · Serious injuriesClosedPiper PA-28R · Flint, MISep 7, 1971 · N2070T · 2 aircraft · Destroyed NTSB CHI72FEM20Accident · 1 fatalClosedMong Sport MS-2 · Negaunee, MISep 6, 1971 · N38M · Destroyed NTSB CHI72DEM22Accident · No injuriesClosedCessna 172G · Hart, MISep 6, 1971 · N4485L · Substantial damage NTSB CHI72FEM21Accident · No injuriesClosedAmer Avco AA1A · Hastings, MISep 5, 1971 · N9312L · Substantial damage NTSB CHI72FEC12Accident · No injuriesClosedAeronca 7AC · Millington, MISep 5, 1971 · N84546 · Substantial damage NTSB CHI72AC020Accident · 1 fatalClosedStinson 108-3 · Fowlerville, MISep 5, 1971 · N6480M · Destroyed NTSB CHI72FEM23Accident · No injuriesClosedBell 47G2 · Manistee, MISep 4, 1971 · N10NR · Destroyed NTSB CHI72FEM19Accident · Serious injuriesClosedSchweizer 1-26 · Ionia, MISep 4, 1971 · N3809A · Substantial damage NTSB CHI72DEM26Accident · No injuriesClosedCessna 182 · Charlevoix, MISep 4, 1971 · N3179R · Substantial damage NTSB CHI72DEM25Accident · No injuriesClosedPiper J-3 · Fremont, MISep 4, 1971 · N6840H · Substantial damage NTSB CHI72DEM18Incident · No injuriesClosedCessna 310 · Pellston, MISep 4, 1971 · N191R · Minor damage NTSB CHI72DEM17Accident · No injuriesClosedCessna 150H · Bruce Crosng, MISep 3, 1971 · N6501S · Substantial damage NTSB CHI72DET07Accident · No injuriesClosedPiper PA-25 · Colon, MISep 1, 1971 · N7200Z · Substantial damage NTSB CHI72FEC10Accident · No injuriesClosedCessna 177 RG · Horton, MIAug 29, 1971 · N8237G · Substantial damage NTSB CHI72FEM24Accident · No injuriesClosedPiper J3 · Otsego, MIAug 28, 1971 · N78521 · Substantial damage NTSB CHI72AC018Accident · 4 fatalClosedPiper PA-28 · Marshall, MIAug 27, 1971 · N7905W · Destroyed NTSB CHI72AC017Accident · 2 fatalClosedPiper PA-22 · Cadillac, MIAug 27, 1971 · N7039B · Destroyed NTSB CHI72FEC08Accident · No injuriesClosedCessna 182G · Ann Arbor, MIAug 22, 1971 · N2468R · Substantial damage NTSB CHI72DEM14Accident · No injuriesClosedAeronca 15AC · Marquette, MIAug 22, 1971 · N1199H · Substantial damage NTSB CHI72FEM12Accident · No injuriesClosedPiper PA-28 · Battle Creek, MIAug 21, 1971 · N1810T · Substantial damage NTSB CHI72FEC03Accident · No injuriesClosedCessna 140 · Pontiac, MIAug 21, 1971 · N76130 · Substantial damage