Skip to content

NTSB investigations, 1980, MI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1980, 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") = 1980 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\") = 1980
    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") = 1980
  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 CHI81DAMS2Accident · 5 fatalClosedCessna 421B · Muskegon, MIDec 29, 1980 · N9394A · Destroyed NTSB CHI81FEM04Accident · No injuriesClosedCessna 172N · Pellston, MIDec 24, 1980 · N4800J · Substantial damage NTSB CHI81FEC07Accident · No injuriesClosedPiper PA-32R · Belleville, MIDec 20, 1980 · N5421F · Substantial damage NTSB CHI81FA012Accident · 2 fatalClosedPiper PA-28R · Kalkaska, MIDec 12, 1980 · N559PA · Destroyed NTSB CHI81FEC06Accident · Minor injuriesClosedCessna 421B · Detroit, MINov 26, 1980 · N200SM · Destroyed NTSB CHI81FEC05Accident · Serious injuriesClosedStinson L-5 · New Hudson, MINov 22, 1980 · N57576 · Substantial damage NTSB CHI81FA006Accident · 2 fatalClosedPiper PA-28 · Fremont, MINov 13, 1980 · N7956N · Destroyed NTSB CHI81FEC04Accident · No injuriesClosedCessna 182Q · Britton, MINov 10, 1980 · N96437 · Substantial damage NTSB CHI81FEC03Accident · No injuriesClosedCessna 152 · Hillsdale, MINov 6, 1980 · N7352W · Destroyed NTSB CHI81FA004Accident · 3 fatalClosedCessna 152 · Linden, MINov 2, 1980 · N24552 · 2 aircraft · Destroyed NTSB CHI81FEM03Accident · No injuriesClosedCessna 172M · Lansing, MIOct 31, 1980 · N9019H · Substantial damage NTSB CHI81FEM02Accident · No injuriesClosedCessna 402B · Traverse City, MIOct 30, 1980 · N3AP · Substantial damage NTSB CHI81DEC02Accident · Serious injuriesClosedPiccard AX-6 · Metamora, MIOct 23, 1980 · N2454Z · Substantial damage NTSB CHI81DEC01Accident · No injuriesClosedCessna 152 · Flushing, MIOct 16, 1980 · N24251 · Substantial damage NTSB CHI81FA001Accident · 3 fatalClosedCessna 337H · Waterford, MIOct 14, 1980 · N1333L · 2 aircraft · Destroyed NTSB CHI81FEM01Accident · No injuriesClosedCessna 170A · Lowell, MIOct 1, 1980 · N1724D · Substantial damage NTSB CHI80FEM47Accident · Minor injuriesClosedSkybolt Steen · Rose City, MISep 13, 1980 · N25541 · Destroyed NTSB CHI80FEM46Accident · No injuriesClosedBeech A35 · Lincoln, MISep 13, 1980 · N2744V · Destroyed NTSB CHI80FEC36Accident · No injuriesClosedCessna 150 · Detroit, MISep 12, 1980 · N19332 · Substantial damage NTSB CHI80FEC35Accident · Minor injuriesClosedCessna 182A · Richmond, MISep 7, 1980 · N4949Q · Substantial damage NTSB CHI80FEM45Accident · No injuriesClosedCessna 172L · Chesaning, MISep 6, 1980 · N300AW · Substantial damage NTSB CHI80FEC34Accident · No injuriesClosedCessna 152 · North Adams, MISep 6, 1980 · N25266 · Substantial damage NTSB CHI80DEM43Accident · No injuriesClosedCessna 172 · Lansing, MIAug 31, 1980 · N12136 · Substantial damage NTSB CHI80DEM44Accident · No injuriesClosedHughes 500D · Manistee, MIAug 29, 1980 · N500NC · Substantial damage NTSB CHI80FET28Accident · Serious injuriesClosedPiper J3C-65 · Jones, MIAug 28, 1980 · N6334H · Substantial damage NTSB CHI80FEM48Accident · No injuriesClosedPiper PA-28 · Shelby, MIAug 28, 1980 · N6378C · Substantial damage NTSB CHI80FEC32Accident · Minor injuriesClosedPiper PA-28 · Plymouth, MIAug 27, 1980 · N43406 · Destroyed NTSB CHI80FA065Accident · 4 fatalClosedPiper PA-23 · East Tawas, MIAug 27, 1980 · N44EM · Destroyed NTSB CHI80DEC33Accident · No injuriesClosedPiper PA-24 · Detroit, MIAug 27, 1980 · N6741P · Substantial damage NTSB CHI80DAMS3Accident · 1 fatalClosedCessna 182G · Ludington, MIAug 24, 1980 · N2323R · Destroyed NTSB CHI81DEC31Accident · No injuriesClosedCessna 172 · Pontiac, MIAug 20, 1980 · N4967G · Substantial damage NTSB CHI80FEM42Accident · Serious injuriesClosedPiper PA-28 · Harrison, MIAug 19, 1980 · N6839W · Destroyed NTSB CHI80FEM41Accident · No injuriesClosedCessna 152 · Negaunee, MIAug 16, 1980 · N4898H · Substantial damage NTSB CHI80FEC30Accident · No injuriesClosedBeech C23 · Pontiac, MIAug 15, 1980 · N1947L · Substantial damage NTSB CHI80FEM40Accident · No injuriesClosedCessna 172 · Fennville, MIAug 14, 1980 · N7660T · Substantial damage NTSB CHI80FEM39Accident · Serious injuriesClosedCorbin E · Hessel, MIAug 10, 1980 · N74702 · Substantial damage NTSB CHI80FA063Accident · 2 fatalClosedCessna 172 · Bois Blanc Is, MIAug 10, 1980 · N739PP · Destroyed NTSB CHI80DEC29Accident · Serious injuriesClosedPiccard AX-6 · Pontiac, MIAug 9, 1980 · N2482Z · No damage NTSB CHI80DEC28Accident · Minor injuriesClosedCessna 172N · Ubly, MIAug 3, 1980 · N2418E · Substantial damage NTSB CHI80FEM38Accident · No injuriesClosedPiper PA-28 · Kalamazoo, MIAug 1, 1980 · N6838W · Substantial damage NTSB CHI80FEC26Accident · 1 fatalClosedBell 47D1 · Munith, MIJul 30, 1980 · N3656F · Substantial damage NTSB CHI80DEM37Accident · No injuriesClosedBell 47G2 · Greenville, MIJul 28, 1980 · N2866B · Substantial damage NTSB CHI80FA060Accident · 1 fatalClosedPiper PA-28 · Lake City, MIJul 26, 1980 · N15336 · Destroyed NTSB CHI80FEC25Accident · Serious injuriesClosedBell 47D1 · Milan, MIJul 22, 1980 · N74006 · Substantial damage NTSB CHI80FEM35Accident · No injuriesClosedCessna U206B · Charlotte, MIJul 20, 1980 · N3830G · Substantial damage NTSB CHI80FA058Accident · 2 fatalClosedPiper J-3 · Flushing, MIJul 20, 1980 · N42726 · Destroyed NTSB CHI80FEM36Accident · Serious injuriesClosedGrum-Amer AA-1 · Midland, MIJul 17, 1980 · N5621L · Destroyed NTSB CHI80DA057Accident · 2 fatalClosedStinson 108-3 · Grattan, MIJul 17, 1980 · N4110C · Destroyed NTSB CHI80FEC23Accident · Serious injuriesClosedGreat Lakes 2T-1 · Mason, MIJul 13, 1980 · N88SK · Destroyed NTSB CHI80FEC24Accident · No injuriesClosedPiper PA-22 · Troy, MIJul 12, 1980 · N5821D · Substantial damage