Skip to content

NTSB investigations, 1977, MI

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 CHI78DEM07Accident · No injuriesClosedCessna 150 · Crystal Falls, MIDec 26, 1977 · N7966G · Substantial damage NTSB CHI78FEM06Accident · No injuriesClosedCessna 177 · Birch Run, MIDec 16, 1977 · N30275 · Substantial damage NTSB CHI78DEC09Accident · No injuriesClosedPiper PA-28 · Marine City, MIDec 11, 1977 · N4458T · Substantial damage NTSB CHI78FEC08Accident · Serious injuriesClosedBell 47J2A · Plymouth, MIDec 3, 1977 · N1190W · Destroyed NTSB CHI78FEC07Accident · No injuriesClosedCessna 150G · Fowlerville, MIDec 3, 1977 · N3166X · Substantial damage NTSB CHI78FEM05Accident · No injuriesClosedCessna 310P · Saginaw, MIDec 1, 1977 · N310AW · Substantial damage NTSB CHI78FET02Accident · No injuriesClosedPiper PA-24 · Niles, MINov 24, 1977 · N5047P · Substantial damage NTSB CHI78FEM03Accident · Serious injuriesClosedCessna 172M · Mt Pleasant, MINov 6, 1977 · N4435Q · Substantial damage NTSB CHI78FEM02Accident · No injuriesClosedErco 415-C · Beaverton, MINov 3, 1977 · N87046 · Substantial damage NTSB CHI78FEC05Accident · No injuriesClosedCessna 140 · W.Bloomfield, MINov 3, 1977 · N2229N · Substantial damage NTSB CHI78FEC04Accident · No injuriesClosedAero Comdr 100 · Fraser, MINov 3, 1977 · N3697X · Substantial damage NTSB CHI78FEM04Accident · No injuriesClosedPiper PA-28 · Grand Ledge, MIOct 30, 1977 · N44006 · Substantial damage NTSB CHI78FEM01Accident · Minor injuriesClosedCessna 170B · Bath, MIOct 28, 1977 · N2524C · Substantial damage NTSB CHI78DEC06Accident · No injuriesClosedCessna 182 · Grosse Ile, MIOct 28, 1977 · N2675R · Substantial damage NTSB CHI78DEC03Accident · No injuriesClosedGrum Amer AA-5A · Ann Arbor, MIOct 28, 1977 · N766MF · Substantial damage NTSB CHI78FEC02Accident · Minor injuriesClosedCessna 172H · Romulus, MIOct 27, 1977 · N2791L · Destroyed NTSB CHI78FA002Accident · No injuriesClosedSikorsky S-58E · Flat Rock, MIOct 16, 1977 · N99275 · Destroyed NTSB CHI78DEC01Accident · Minor injuriesClosedPiper PA-28 · Grosse Ile, MIOct 15, 1977 · N7505W · Substantial damage NTSB CHI77FA075Accident · No injuriesClosedN.American 265 · Detroit, MISep 30, 1977 · N8NR · Substantial damage NTSB CHI77FEM43Accident · No injuriesClosedHiller UH-12B · Carrollton, MISep 26, 1977 · N94735 · Destroyed NTSB CHI77FEC48Accident · 1 fatalClosedPiper PA-28 · Romeo, MISep 24, 1977 · N5194S · Destroyed NTSB CHI78FET35Accident · 1 fatalClosedPiper PA-18 · Benton Harbor, MISep 18, 1977 · N82328 · Substantial damage NTSB CHI77FEC47Accident · Minor injuriesClosedBell 47B3 · Lake Orion, MISep 18, 1977 · N1575 · Substantial damage NTSB CHI77FEM42Accident · Serious injuriesClosedBenson Gyro · Montague, MISep 11, 1977 · NONE · Substantial damage NTSB CHI77FEC44Accident · No injuriesClosedWallis 3 · Plymouth, MISep 11, 1977 · N65022 · Substantial damage NTSB CHI77FET36Accident · No injuriesClosedPiper PA-28 · Coldwater, MISep 10, 1977 · N4379X · Substantial damage NTSB CHI77FEC43Accident · Serious injuriesClosedCessna 182 · Gregory, MISep 10, 1977 · N6054B · Substantial damage NTSB CHI77DEC46Accident · No injuriesClosedPiper PA-28 · Fraser, MISep 10, 1977 · N7080F · Substantial damage NTSB CHI77FEM39Accident · 1 fatalClosedCessna 182Q · East Tawas, MISep 4, 1977 · N444SP · No damage NTSB CHI77FEM40Accident · Serious injuriesClosedPiper PA-28 · Kalamazoo, MISep 3, 1977 · N15060 · Substantial damage NTSB CHI77DEM41Accident · No injuriesClosedCessna 172M · Pleasant, MISep 1, 1977 · N30278 · Substantial damage NTSB CHI77FA070Accident · Minor injuriesClosedBeech C-45H · Ypsilanti, MIAug 31, 1977 · N125TF · Destroyed NTSB CHI77FEM38Accident · No injuriesClosedCessna 170A · Cedar Springs, MIAug 29, 1977 · N5137B · Substantial damage NTSB CHI77FEC42Accident · No injuriesClosedErco 415-C · Unionville, MIAug 28, 1977 · N99014 · Substantial damage NTSB CHI77FA068Accident · 1 fatalClosedCessna 172N · Salem, MIAug 22, 1977 · N75810 · Destroyed NTSB CHI78FEC41Accident · Minor injuriesClosedPitts S1C · Clinton, MIAug 20, 1977 · N24144 · Substantial damage NTSB CHI77FA067Accident · 4 fatalClosedFairchild F24 · Cedar, MIAug 18, 1977 · N81225 · Destroyed NTSB CHI77FET32Accident · No injuriesClosedGrumman G-44A · Cassopolis, MIAug 10, 1977 · N1629H · Substantial damage NTSB CHI77FEC36Accident · No injuriesClosedBede BD-4 · Detroit, MIAug 4, 1977 · N375JK · Substantial damage NTSB CHI77FA061Accident · 1 fatalClosedCessna 172F · Grand Rapids, MIJul 30, 1977 · N5606R · Destroyed NTSB CHI77FET30Accident · Minor injuriesClosedBellanca 7FC · Baroda, MIJul 28, 1977 · N4853E · Substantial damage NTSB CHI77FEC40Accident · No injuriesClosedPiper PA28 · Mason, MIJul 26, 1977 · N7963F · Substantial damage NTSB CHI77DEM30Accident · No injuriesClosedBeech 56TC · Traverse City, MIJul 25, 1977 · N570S · Substantial damage NTSB CHI77FEM34Accident · Serious injuriesClosedBell 47D · Byron Center, MIJul 21, 1977 · N64580 · Substantial damage NTSB CHI77FET26Accident · Minor injuriesClosedCessna 188B · Coloma, MIJul 18, 1977 · N4462Q · Destroyed NTSB CHI77FET25Accident · No injuriesClosedErco 415-C · Edwardsburg, MIJul 18, 1977 · N94074 · Substantial damage NTSB CHI77DEM36Accident · No injuriesClosedBellanca 7ECA · Manistique, MIJul 16, 1977 · N6352N · Substantial damage NTSB CHI77FET23Accident · No injuriesClosedPiper PA-25 · Niles, MIJul 13, 1977 · N7278Z · Substantial damage NTSB CHI77DEC38Accident · No injuriesClosedCessna 150 · Pontiac, MIJul 13, 1977 · N1642Q · Substantial damage NTSB CHI77FEM33Accident · Serious injuriesClosedCessna 172 · Stambaugh, MIJul 10, 1977 · N303EE · Substantial damage