Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 CHI79DEC08Accident · No injuriesClosedPiper PA-28R · Napoleon, MIDec 25, 1978 · N33867 · Substantial damage NTSB CHI79FET09Accident · Minor injuriesClosedCessna 150 · Three Oaks, MIDec 15, 1978 · N45597 · Substantial damage NTSB CHI79FEM07Accident · No injuriesClosedCessna 152 · Mt Pleasant, MIDec 12, 1978 · N65472 · Substantial damage NTSB CHI79FEC07Accident · No injuriesClosedBeech B23 · Brighton, MIDec 12, 1978 · N7615R · Substantial damage NTSB CHI79FEM06Accident · No injuriesClosedCessna 150M · Big Rapids, MIDec 10, 1978 · N63276 · Substantial damage NTSB CHI79FEC06Accident · Minor injuriesClosedScorpion II · Romulus, MINov 26, 1978 · N92086 · Substantial damage NTSB CHI79DEC04Accident · Serious injuriesClosedBede BD-4 · Romeo, MINov 18, 1978 · N37RH · Substantial damage NTSB CHI79FEM04Accident · No injuriesClosedMooney M20J · Marshall, MINov 11, 1978 · N201RP · Substantial damage NTSB CHI79FA017Accident · 2 fatalClosedGrumman AA-5 · Norway, MINov 10, 1978 · N7170L · Destroyed NTSB CHI79FEC05Accident · No injuriesClosedBeechcraft D-18S · Flint, MINov 3, 1978 · N80369 · Destroyed NTSB CHI79FEC02Accident · No injuriesClosedMitsubishi MU2B20 · Ypsilanti, MIOct 31, 1978 · N13EW · Substantial damage NTSB CHI79FEC03Accident · Serious injuriesClosedPiccard AX6 · Rochester, MIOct 29, 1978 · N24402 · No damage NTSB CHI79FEC01Accident · 2 fatalClosedNord Stampe SV4C · Wixom, MIOct 21, 1978 · N671SV · Destroyed NTSB CHI78FEM03Accident · No injuriesClosedHiller UH12A · Muskegon, MIOct 8, 1978 · N330M · Substantial damage NTSB CHI79FEM05Accident · No injuriesClosedPiper PA-22 · Grand Rapids, MIOct 2, 1978 · N4859A · Substantial damage NTSB CHI79DEM02Accident · No injuriesClosedBell 47G · Saginaw, MIOct 1, 1978 · N7762 · Substantial damage NTSB CHI78FEC56Accident · Minor injuriesClosedCessna 150L · Pontiac, MISep 25, 1978 · N5237Q · Substantial damage NTSB CHI78FEM42Accident · Minor injuriesClosedPiper PA-22 · Kalamazoo, MISep 20, 1978 · N2852Z · Substantial damage NTSB CHI78FEC55Accident · No injuriesClosedCessna 152 · Plymouth, MISep 16, 1978 · N69037 · Substantial damage NTSB CHI78FEC54Accident · No injuriesClosedPiper PA-24 · Flint, MISep 16, 1978 · N2SV · Substantial damage NTSB CHI78DEM43Accident · No injuriesClosedCessna 152 · Beal City, MISep 15, 1978 · N24552 · Substantial damage NTSB CHI78FA065Accident · 3 fatalClosedCessna 172K · Mackinaw City, MISep 10, 1978 · N84380 · Destroyed NTSB CHI78FEC52Accident · No injuriesClosedBeech BE35 · Pontiac, MISep 8, 1978 · N2834V · Substantial damage NTSB CHI78FEM41Accident · No injuriesClosedCessna 182 · Charlotte, MISep 7, 1978 · N8659T · Substantial damage NTSB CHI78DET37Accident · No injuriesClosedBeech A55 · Benton Harbor, MISep 4, 1978 · N511JL · Destroyed NTSB CHI78DEC53Accident · No injuriesClosedBalloon WKS 7 · Northville, MISep 4, 1978 · N2027F · Substantial damage NTSB CHI78FEC51Accident · No injuriesClosedCessna 152 · Clawson, MISep 3, 1978 · N757RP · Substantial damage NTSB CHI78FEM38Accident · No injuriesClosedCessna 182 · Hubbard Lake, MISep 2, 1978 · N21477 · Substantial damage NTSB CHI78FEC50Accident · No injuriesClosedSikorsky S55B · Pontiac, MISep 2, 1978 · N90885 · Destroyed NTSB CHI78FEM36Accident · No injuriesClosedCessna 180 · Nunica, MIAug 30, 1978 · N5133E · Substantial damage NTSB CHI78DEM37Accident · Serious injuriesClosedLake LA4200 · Foster City, MIAug 30, 1978 · N2738P · Destroyed NTSB CHI78FEC49Accident · No injuriesClosedCessna 172M · South Rockwood, MIAug 26, 1978 · N73606 · Substantial damage NTSB CHI78FEM39Accident · No injuriesClosedCessna 177 · Moorestown, MIAug 25, 1978 · N30242 · Substantial damage NTSB CHI78FA063Accident · No injuriesClosedCessna 337 · Escanaba, MIAug 23, 1978 · N75BB · Substantial damage NTSB CHI78FEC48Accident · Minor injuriesClosedAeronca 7AC · Imlay City, MIAug 20, 1978 · N85108 · Destroyed NTSB CHI78FEM34Accident · No injuriesClosedBell 47G · Chippewa, MIAug 19, 1978 · N5237A · Substantial damage NTSB CHI78FEM35Accident · Minor injuriesClosedTaylorcraft BL-65 · Grand Haven, MIAug 17, 1978 · N27427 · Substantial damage NTSB CHI78FEM32Accident · Minor injuriesClosedCessna 150L · Lansing, MIAug 17, 1978 · N18686 · Substantial damage NTSB CHI78FEC47Accident · Serious injuriesClosedPiper PA-38 · Romeo, MIAug 17, 1978 · N9304T · Destroyed NTSB CHI78DA062Accident · No injuriesClosedPitts Spcl 1 · Flat Rock, MIAug 13, 1978 · N28K · Substantial damage NTSB CHI78FEM33Accident · Minor injuriesClosedPiper PA-28 · Holland, MIAug 9, 1978 · N187SP · Substantial damage NTSB CHI78FEC46Accident · Minor injuriesClosedCessna 150M · Westland, MIAug 9, 1978 · N704HH · Substantial damage NTSB CHI78FEC45Accident · Serious injuriesClosedGrum Amer AA1-B · Milford, MIAug 4, 1978 · N1SU · Destroyed NTSB DCA78AA019Accident · Serious injuriesClosedConvair 580 · Kalamazoo, MIJul 25, 1978 · N4825C · Substantial damage NTSB CHI78FEM31Accident · No injuriesClosedPiper PA-22 · Evart, MIJul 25, 1978 · N9807D · Substantial damage NTSB CHI78FEM30Accident · No injuriesClosedPiper PA-28 · Ludington, MIJul 24, 1978 · N7936W · Substantial damage NTSB CHI78DEC42Accident · No injuriesClosedCessna 152 · Adrian, MIJul 24, 1978 · N24896 · Substantial damage NTSB CHI78FEC44Accident · No injuriesClosedPiper PA-25 · Cass City, MIJul 21, 1978 · N54902 · Destroyed NTSB CHI78FEC43Accident · No injuriesClosedCessna 402 · Salem, MIJul 20, 1978 · N4014Q · Substantial damage NTSB CHI78FEM29Accident · No injuriesClosedCessna 180 · Otsego Lake, MIJul 15, 1978 · N1608C · Substantial damage