Skip to content

NTSB investigations, 1974, MI

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 CHI75FEC31Accident · No injuriesClosedCessna 150 · S Rockwood, MIDec 30, 1974 · N50794 · Substantial damage NTSB CHI75DEM13Accident · No injuriesClosedCessna 150H · Cadillac, MIDec 28, 1974 · N6934S · Substantial damage NTSB CHI75FEC30Accident · No injuriesClosedMaule M4220C · Ann Arbor, MIDec 26, 1974 · N51161 · Substantial damage NTSB CHI75DEC29Accident · No injuriesClosedMcculloch J2 · Otisville, MIDec 25, 1974 · N4384 · Substantial damage NTSB CHI75FEC28Accident · No injuriesClosedPiper PA-28 · Lake Orion, MIDec 18, 1974 · N56497 · Substantial damage NTSB CHI75FEC27Accident · No injuriesClosedPiper PA-28 · Grosse Ile, MIDec 17, 1974 · N5063T · Substantial damage NTSB CHI75DEM09Accident · No injuriesClosedCessna 120 · East Tawas, MIDec 12, 1974 · N89982 · Substantial damage NTSB CHI75AC044Accident · 1 fatalClosedCessna 150J · Utica, MIDec 9, 1974 · N51370 · Destroyed NTSB CHI75FEC26Accident · Minor injuriesClosedLuscombe 8E · Ann Arbor, MIDec 3, 1974 · N2075K · Substantial damage NTSB CHI75FET12Accident · No injuriesClosedCessna 120 · Sodus, MIDec 2, 1974 · N2571N · Substantial damage NTSB CHI75FEM20Accident · No injuriesClosedJupiter J1 · Plainwell, MINov 29, 1974 · N2981C · Substantial damage NTSB CHI75DEM21Accident · Minor injuriesClosedBeech K35 · Gaylord, MINov 28, 1974 · N6068E · Substantial damage NTSB CHI75FEC25Accident · No injuriesClosedBensen B-8M · Grosse Ile, MINov 23, 1974 · N104RJ · Substantial damage NTSB CHI75FEC24Accident · Serious injuriesClosedPiper J3C-65 · Ypsilanti, MINov 22, 1974 · N2472C · Substantial damage NTSB CHI75DEC33Accident · No injuriesClosedCessna 421 · Detroit, MINov 17, 1974 · N99NE · Substantial damage NTSB CHI75FEC23Accident · No injuriesClosedBeech B19 · Pontiac, MINov 16, 1974 · N1924W · Substantial damage NTSB CHI75FEC22Accident · No injuriesClosedPiper PA-28 · Deerfield, MINov 10, 1974 · N44567 · Substantial damage NTSB MIA75AM026Accident · Serious injuriesClosedDouglas DC-8 · Detroit, MINov 6, 1974 · N815E · No damage NTSB CHI75DEM18Accident · No injuriesClosedCessna 120 · Burlington, MIOct 31, 1974 · N2339N · Substantial damage NTSB CHI75DEM19Accident · No injuriesClosedCessna 150 · Boyne City, MIOct 28, 1974 · N22919 · Substantial damage NTSB CHI75DEC21Accident · No injuriesClosedPiper PA-30 · Port Huron, MIOct 28, 1974 · CF-VLE · Substantial damage NTSB CHI75FEC20Accident · Minor injuriesClosedAmer Avco AA1-B · Clio, MIOct 26, 1974 · N8987L · Substantial damage NTSB CHI75FEC19Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MIOct 26, 1974 · N14AA · Substantial damage NTSB CHI75AC034Accident · Serious injuriesClosedBeech 99 · Jackson, MIOct 23, 1974 · N140J · Substantial damage NTSB CHI75FEC18Accident · No injuriesClosedCessna 414 · Jackson, MIOct 20, 1974 · N414HC · Destroyed NTSB CHI75DEM17Accident · No injuriesClosedCessna 210T · Rockford, MIOct 20, 1974 · N381DS · Substantial damage NTSB CHI75AC033Accident · 1 fatalClosedBeech H18 · Iron Mtn, MIOct 17, 1974 · N72FA · Destroyed NTSB CHI75DEM16Accident · No injuriesClosedErco 415-C · Plainwell, MIOct 11, 1974 · N2372H · Substantial damage NTSB CHI75FEM15Accident · No injuriesClosedCessna 150 · Slt St Marie, MIOct 9, 1974 · N6621Y · Substantial damage NTSB CHI75FEC17Accident · No injuriesClosedLuscombe 8A · Napoleon, MIOct 9, 1974 · N72011 · Substantial damage NTSB CHI75FEM14Accident · 1 fatalClosedPiper PA-25 · Wayland, MIOct 1, 1974 · N8922L · Destroyed NTSB CHI75FEC16Accident · No injuriesClosedGates Lear 24 · Detroit, MISep 23, 1974 · N111LJ · Substantial damage NTSB CHI75FEM12Accident · Minor injuriesClosedBell 47G-2 · Paw Paw, MISep 21, 1974 · N7893B · Substantial damage NTSB CHI75FEC15Accident · No injuriesClosedCessna 180 · Springville, MISep 21, 1974 · N7713A · Destroyed NTSB CHI75FEC14Accident · 1 fatalClosedWard-Rand KR-1 · Adrian, MISep 20, 1974 · N6364 · Destroyed NTSB CHI75FEM11Accident · Serious injuriesClosedCessna 172 · Harrison, MISep 19, 1974 · N4155F · Destroyed NTSB CHI75FEC13Accident · No injuriesClosedBellanca 14-19 · Jackson, MISep 15, 1974 · N7624E · Substantial damage NTSB CHI75DEM10Accident · No injuriesClosedCessna 120 · Paw Paw, MISep 14, 1974 · N2948N · Substantial damage NTSB CHI75FEC12Accident · Serious injuriesClosedPitts S-1S · Pontiac, MISep 1, 1974 · N161Y · Substantial damage NTSB CHI75DEM07Accident · No injuriesClosedChampion 7ECA · Linwood, MIAug 24, 1974 · N5164T · Substantial damage NTSB CHI75AC020Accident · 2 fatalClosedMooney M20F · Manistique, MIAug 22, 1974 · N6438Q · Destroyed NTSB CHI75FEC10Accident · No injuriesClosedPiper J3C · Fair Haven, MIAug 20, 1974 · N35670 · Substantial damage NTSB CHI75FEC09Accident · No injuriesClosedCessna 172 · Detroit, MIAug 19, 1974 · N1744F · Substantial damage NTSB CHI75DEM08Accident · Minor injuriesClosedCessna 177A · South Branch, MIAug 19, 1974 · N30563 · Substantial damage NTSB CHI75FEC11Accident · No injuriesClosedTaylorcraft BC12-D · Durand, MIAug 18, 1974 · N96279 · Substantial damage NTSB CHI75FEC08Accident · Minor injuriesClosedBellanca 7GCAA · Clio, MIAug 14, 1974 · N8362V · Destroyed NTSB CHI75DEM05Accident · No injuriesClosedCessna 177 · Dewitt, MIAug 14, 1974 · N3262T · Substantial damage NTSB CHI75FEM04Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 13, 1974 · N4501U · Substantial damage NTSB CHI75DEM06Accident · No injuriesClosedCessna 172M · Harrison, MIAug 10, 1974 · N13387 · Substantial damage NTSB CHI75AC014Accident · No injuriesClosedBeech D18S · Detroit, MIAug 7, 1974 · N35CB · Destroyed