Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 CHI80FA020Accident · 3 fatalClosedPiper PA-28 · Royal Oak, MIDec 30, 1979 · N4512P · Destroyed NTSB CHI80FEC08Accident · No injuriesClosedCessna 152 · Frasher, MIDec 27, 1979 · N89969 · Substantial damage NTSB CHI80FEM09Accident · No injuriesClosedCessna 150H · Hesperia, MIDec 26, 1979 · N6746S · Substantial damage NTSB CHI80DEM10Accident · Minor injuriesClosedPiper PA-20 · Ithaca, MIDec 24, 1979 · N2807Z · Substantial damage NTSB CHI80FEC07Accident · No injuriesClosedPiper PA-28 · Owosso, MIDec 21, 1979 · N36700 · Substantial damage NTSB CHI80FEM08Accident · Minor injuriesClosedRyan ST-3KR · Holland, MIDec 19, 1979 · N47433 · Substantial damage NTSB CHI80DEM11Accident · No injuriesClosedGrumman AA-1C · Marion, MIDec 15, 1979 · N39008 · Destroyed NTSB CHI80FEC04Accident · No injuriesClosedCessna 172F · Detroit, MIDec 5, 1979 · N8633U · Substantial damage NTSB CHI80DEC05Accident · No injuriesClosedCessna 140 · Romeo, MIDec 3, 1979 · N1788N · Substantial damage NTSB CHI80FEE09Accident · No injuriesClosedCessna 182J · Lansing, MINov 30, 1979 · N3059F · Substantial damage NTSB CHI80FEM07Accident · No injuriesClosedSpezio CB-2 · Marne, MINov 25, 1979 · N18822 · Substantial damage NTSB CHI80DEM05Accident · No injuriesClosedCessna 150D · Niron Mountain, MINov 7, 1979 · CG-CDR · Substantial damage NTSB CHI80FEC02Accident · No injuriesClosedCessna 152 · Jackson, MINov 6, 1979 · N68246 · Substantial damage NTSB CHI80DEC03Accident · No injuriesClosedCessna 150M · Napoleon, MINov 2, 1979 · N6100K · Substantial damage NTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MIOct 29, 1979 · N4437J · 2 aircraft · Destroyed NTSB CHI80FEM04Accident · Serious injuriesClosedPiper PA-12 · Long Rapids, MIOct 21, 1979 · N98967 · Substantial damage NTSB CHI80FEM03Accident · No injuriesClosedPiper PA-32R · Manistee, MIOct 20, 1979 · N39591 · Substantial damage NTSB CHI79FEC59Accident · 1 fatalClosedCessna 120 · Vassar, MIOct 20, 1979 · N2854N · Destroyed NTSB CHI80FEM06Accident · No injuriesClosedCessna 402A · Lansing, MIOct 17, 1979 · N7809Q · Substantial damage NTSB CHI80FAMS1Accident · 1 fatalClosedPiper PA-24 · Ganges, MIOct 10, 1979 · N8437P · Destroyed NTSB CHI80FEM02Accident · No injuriesClosedErco 415-C · Cheboygan, MIOct 9, 1979 · N2150H · Substantial damage NTSB CHI79FEM01Accident · 1 fatalClosedCessna 177 · Baraga, MIOct 9, 1979 · N3331T · Destroyed NTSB CHI80FET01Accident · No injuriesClosedCessna 310G · Benton Harbor, MIOct 2, 1979 · N20PC · Substantial damage NTSB CHI80FEM01Accident · Minor injuriesClosedCessna 172K · Byron Center, MIOct 1, 1979 · N84660 · Substantial damage NTSB CHI79FEM40Accident · Minor injuriesClosedCessna 182F · Gladwin, MISep 28, 1979 · N3564Y · Substantial damage NTSB CHI79FEC58Accident · No injuriesClosedCessna 182K · Sandusky, MISep 28, 1979 · N2615R · Substantial damage NTSB CHI79FEC57Accident · 2 fatalClosedBreezy RLU-1 · Frazer, MISep 22, 1979 · N9369 · Destroyed NTSB CHI80FEC56|CHI79FEC56Accident · No injuriesClosedCessna 182 · Pontiac, MISep 15, 1979 · N1930X · 2 aircraft · Substantial damage NTSB CHI79FA076Accident · 4 fatalClosedBeech C-45H · Hastings, MISep 15, 1979 · N600NA · Destroyed NTSB CHI79DEC54Accident · No injuriesClosedCessna 180 · Dexter, MISep 8, 1979 · N4750U · Substantial damage NTSB CHI79FEC49Accident · No injuriesClosedAeronca 7AC · Deford, MISep 4, 1979 · N85188 · Substantial damage NTSB CHI79FEC51Accident · Minor injuriesClosedHughes 269B · Flint, MISep 3, 1979 · N9310F · Substantial damage NTSB CHI79FEC48Accident · No injuriesClosedBeech 35 · Detroit, MISep 3, 1979 · N3712N · Substantial damage NTSB CHI79FEC50Accident · No injuriesClosedPiper PA-28R · Hudson, MISep 2, 1979 · N54425 · Substantial damage NTSB CHI79FA071Accident · 3 fatalClosedPiper PA-28R · Grayling, MISep 2, 1979 · N4392T · Destroyed NTSB CHI79FEC52Accident · Serious injuriesClosedPiper PA-28 · Marine City, MISep 1, 1979 · N5944V · Destroyed NTSB CHI79DEM39Accident · No injuriesClosedPiper PA-22 · Selkirk, MISep 1, 1979 · N8824D · Substantial damage NTSB CHI79DEC53Accident · No injuriesClosedCessna 152 · Detroit, MISep 1, 1979 · N25800 · Substantial damage NTSB CHI79FEM37Accident · Minor injuriesClosedSikorsky S-55B · Stanton, MIAug 30, 1979 · N6737 · Substantial damage NTSB CHI79CEM38Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 30, 1979 · N68339 · Substantial damage NTSB CHI79DEM36Accident · No injuriesClosedGrumman AA1B · Harrisville, MIAug 26, 1979 · N9942L · Substantial damage NTSB CHI79FA067Accident · 2 fatalClosedBeech 95-B55 · Kinross, MIAug 24, 1979 · N4422W · Destroyed NTSB CHI79FEC47Accident · No injuriesClosedHughes 369H5 · Grosse Ile, MIAug 20, 1979 · N9034F · Substantial damage NTSB CHI79FEC45Accident · No injuriesClosedLark 28B2 · Manchester, MIAug 19, 1979 · N74NS · 2 aircraft · Substantial damage NTSB CHI79FEM35Accident · No injuriesClosedPiper PA-32R · Harbor Springs, MIAug 16, 1979 · N6145J · Substantial damage NTSB CHI79FEM34Accident · No injuriesClosedBell 47G-2 · Hart, MIAug 16, 1979 · N4734S · Substantial damage NTSB CHI79FEC44Accident · 1 fatalClosedStitts SA-3A · Manchester, MIAug 16, 1979 · N19BC · Destroyed NTSB CHI79FEC42Accident · No injuriesClosedCessna 182 · Tecumseh, MIAug 12, 1979 · N3939D · Substantial damage NTSB CHI79FEC41Accident · Serious injuriesClosedMaule M-5 · Owosso, MIAug 12, 1979 · N9177E · Destroyed NTSB CHI79FEC43Accident · No injuriesClosedCessna 150M · New Hudson, MIAug 7, 1979 · N9287U · Substantial damage