Skip to content

NTSB investigations, 1981, 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, 1981, 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") = 1981 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\") = 1981
    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") = 1981
  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 CHI82FET03Accident · No injuriesClosedBeech 95-B55 · Dowagiac, MIDec 26, 1981 · N2BB · Substantial damage NTSB MKC82FA013Accident · 3 fatalClosedCessna T210N · Jackson, MIDec 17, 1981 · N6347Y · Destroyed NTSB CHI82FA018Accident · No injuriesClosedCessna T182Q · Lansing, MIDec 7, 1981 · N9314H · Substantial damage NTSB CHI82DEC07Accident · No injuriesClosedCessna 152 · Howell, MIDec 7, 1981 · N69011 · Substantial damage NTSB CHI82FEM05Accident · Serious injuriesClosedPiper PA-22 · Wayland, MINov 18, 1981 · N1711T · Destroyed NTSB CHI82FEM04Accident · Serious injuriesClosedCessna 172 · Kinross, MINov 16, 1981 · N79225 · Substantial damage NTSB CHI82FEM02Accident · Minor injuriesClosedBeech T-34 · Lansing, MINov 13, 1981 · N20M · Substantial damage NTSB CHI82FEC06Accident · No injuriesClosedGrumman AA5B · Jackson, MINov 11, 1981 · N28427 · Substantial damage NTSB CHI82DEM03Accident · No injuriesClosedCessna 177 · Mattawan, MINov 10, 1981 · N3194T · Destroyed NTSB CHI82DEP10Accident · Minor injuriesClosedGreat Lakes 2T-1A · Dalton, MINov 7, 1981 · N10551 · Substantial damage NTSB CHI82FEC05Accident · Serious injuriesClosedPiper PA-22 · Howell, MIOct 24, 1981 · N7439D · Substantial damage NTSB CHI82FEC04Accident · No injuriesClosedBeech G-35 · Pontiac, MIOct 17, 1981 · N4653D · Substantial damage NTSB CHI82DEM01Accident · No injuriesClosedQuickie · Plainwell, MIOct 16, 1981 · N12QQ · Substantial damage NTSB CHI82FEC03Accident · No injuriesClosedBeech A-35 · Troy, MIOct 13, 1981 · N484B · Substantial damage NTSB CHI82FEC02Accident · 1 fatalClosedGulfstream AA-1B · Carsonville, MIOct 8, 1981 · N878 · Destroyed NTSB CHI82FEC01Accident · No injuriesClosedCessna 177A · Gibralter, MIOct 5, 1981 · N30624 · Substantial damage NTSB CHI82FA001Accident · 1 fatalClosedBeech D-18S · Fraser, MIOct 4, 1981 · N6675 · Destroyed NTSB CHI81FA104Accident · 2 fatalClosedPiper PA-32 · Newberry, MISep 25, 1981 · N9574C · Destroyed NTSB CHI81FEC47Accident · No injuriesClosedPiper PA-34 · Linden, MISep 22, 1981 · N56413 · Substantial damage NTSB CHI81FA103Accident · 4 fatalClosedMooney M20F · Detroit, MISep 18, 1981 · N7410V · Destroyed NTSB CHI81FA101Accident · 1 fatalClosedCessna 172 · Faithorn, MISep 12, 1981 · N8697U · Destroyed NTSB CHI81FEC46Accident · No injuriesClosedCessna A185F · Detroit, MISep 11, 1981 · N1017F · Substantial damage NTSB CHI81FEC45Accident · No injuriesClosedCessna 182L · Brighton, MISep 8, 1981 · N3316R · Substantial damage NTSB CHI81FET12Accident · Minor injuriesClosedBell 47J · Dowagiac, MISep 7, 1981 · N6734D · Substantial damage NTSB CHI81FEM43Accident · No injuriesClosedAeronca 65-TC · Plainwell, MISep 7, 1981 · N31751 · Substantial damage NTSB CHI81FET11Accident · 1 fatalClosedFairchild M-62A · Coldwater, MISep 6, 1981 · N20Y · Destroyed NTSB CHI81FEC44Accident · 1 fatalClosedLuscombe 8A · Farmington, MISep 6, 1981 · N71993 · Destroyed NTSB CHI81FEC43Accident · Serious injuriesClosedPitts S-1S · Romeo, MIAug 31, 1981 · N12AL · Substantial damage NTSB CHI81FEC42Accident · No injuriesClosedBellanca 7FC · Ann Arbor, MIAug 30, 1981 · N7690E · Substantial damage NTSB CHI81DEM41Accident · No injuriesClosedBeech B-23 · Marshall, MIAug 29, 1981 · N6632L · Substantial damage NTSB CHI81FEM42Accident · Serious injuriesClosedCessna C210 · Kalamazoo, MIAug 28, 1981 · N1198Q · Destroyed NTSB CHI81FA093Accident · 4 fatalClosedCessna 172N · Adrian, MIAug 27, 1981 · N1967F · Destroyed NTSB CHI81DEM39Accident · No injuriesClosedCessna 150 · East Lansing, MIAug 25, 1981 · N5842G · Substantial damage NTSB CHI81DEM10Accident · No injuriesClosedPiper PA-38 · Saginaw, MIAug 21, 1981 · N9258T · Destroyed NTSB CHI81FEM37Accident · No injuriesClosedPiper PA-28 · Cheboygan, MIAug 19, 1981 · N7703W · Substantial damage NTSB CHI81DEC41Accident · Minor injuriesClosedBlanik L-13 · Oxford, MIAug 19, 1981 · N3462 · Substantial damage NTSB CHI81DEM38Accident · No injuriesClosedCessna 150 · Mcbain, MIAug 18, 1981 · N7983R · Substantial damage NTSB CHI81FEM85Accident · No injuriesClosedLuscombe 8E · Gladwin, MIAug 16, 1981 · N2052K · Substantial damage NTSB CHI81FEM36Accident · Serious injuriesClosedPiper PA-28 · Mackinaw, MIAug 14, 1981 · N2964B · Destroyed NTSB CHI81FEC40Accident · No injuriesClosedPiper PA-22 · Lapeer, MIAug 13, 1981 · N8503C · Substantial damage NTSB CHI81FEM33Accident · 3 fatalClosedVarieze RAF · Holland, MIAug 8, 1981 · N16DT · Destroyed NTSB CHI81DEC39Accident · No injuriesClosedCessna 182 · Lapeer, MIAug 7, 1981 · N92095 · Substantial damage NTSB CHI81FEC48Accident · No injuriesClosedCessna 310N · Pontiac, MIAug 1, 1981 · N5070Q · Substantial damage NTSB CHI81FEC38Accident · No injuriesClosedPiper PA-28 · Oxford, MIJul 31, 1981 · N2139N · Substantial damage NTSB CHI81FEC26Accident · No injuriesClosedCessna 150 · Monroe, MIJul 29, 1981 · N17134 · Substantial damage NTSB CHI81FEM31Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIJul 26, 1981 · N39659 · Substantial damage NTSB CHI81DEC35Accident · No injuriesClosedCessna 172 · Deford, MIJul 25, 1981 · N13203 · Substantial damage NTSB CHI81DEM34Accident · No injuriesClosedCessna 172K · Mackinac Is, MIJul 24, 1981 · N78424 · Substantial damage NTSB CHI81FEM30Accident · No injuriesClosedGrumman G-164A · Howard City, MIJul 23, 1981 · N5083 · Substantial damage NTSB CHI81DEC37Accident · No injuriesClosedVliegtuigbo SA-013 · Adrian, MIJul 22, 1981 · N9121 · Substantial damage