Skip to content

NTSB investigations, 1975, MI

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 CHI76FEC16Accident · 1 fatalClosedCessna 182 · Detroit, MIDec 28, 1975 · N6054B · No damage NTSB CHI76FEC18Accident · Serious injuriesClosedRyan Navion · Jackson, MIDec 27, 1975 · N4216K · Destroyed NTSB CHI76FEC17Accident · No injuriesClosedPiper PA-28 · Detroit, MIDec 26, 1975 · N56889 · Substantial damage NTSB CHI76FEC15Accident · No injuriesClosedPiper PA-34 · Troy, MIDec 18, 1975 · N5297T · Substantial damage NTSB CHI76FEC14Accident · No injuriesClosedPiper PA-24 · Salem, MINov 29, 1975 · N9098P · Destroyed NTSB DCA76AZ012Accident · Serious injuriesClosedDouglas DC-10 · Carleton, MINov 26, 1975 · N124 · Minor damage NTSB CHI76FEM22Accident · Minor injuriesClosedCessna 170B · St James, MINov 14, 1975 · N8288A · Substantial damage NTSB CHI76DEM20Accident · No injuriesClosedCessna 150G · Mikado, MINov 5, 1975 · N3961J · Substantial damage NTSB CHI76FEM18Accident · No injuriesClosedCessna 172 · Kalamazoo, MIOct 26, 1975 · N79527 · 2 aircraft · Substantial damage NTSB CHI76DEM17Accident · No injuriesClosedCessna 150 · Harrison, MIOct 26, 1975 · N6886G · Substantial damage NTSB CHI76AC034Accident · 2 fatalClosedPiper PA-28 · Salem, MIOct 26, 1975 · N5394L · 2 aircraft · Destroyed NTSB CHI76FEC13Accident · Minor injuriesClosedCessna 182N · Flint, MIOct 14, 1975 · N9136G · Substantial damage NTSB CHI76DET17Accident · No injuriesClosedErco 415-C · Watervliet, MIOct 6, 1975 · N2150H · Substantial damage NTSB CHI76FEM16Accident · No injuriesClosedTaylorcraft BC12-D · Big Rapids, MIOct 5, 1975 · N95982 · Substantial damage NTSB CHI76DEM13Accident · Minor injuriesClosedCessna 172 · Crystal Falls, MIOct 3, 1975 · N12647 · Substantial damage NTSB CHI75DEM14Accident · No injuriesClosedBeech E33 · Holland, MIOct 3, 1975 · N7162N · Substantial damage NTSB CHI76FEM12Accident · No injuriesClosedCessna 150J · Atlanta, MISep 27, 1975 · N60536 · Substantial damage NTSB CHI76DEC12Accident · Minor injuriesClosedSchemp Cirrus · Oxford, MISep 27, 1975 · N33607 · Substantial damage NTSB CHI76FEM11Accident · No injuriesClosedBeech 35 · Manistee, MISep 14, 1975 · N62X · Substantial damage NTSB CHI76DEC11Accident · No injuriesClosedHughes 269A · Howell, MISep 14, 1975 · N8823F · Substantial damage NTSB CHI76DEM15Accident · No injuriesClosedCessna 172N · Holland, MISep 11, 1975 · N64299 · Substantial damage NTSB CHI76FEC10Accident · No injuriesClosedPiper PA-28 · Napoleon, MISep 6, 1975 · N56161 · Substantial damage NTSB CHI76AC019Accident · 1 fatalClosedCessna 170 · Bronson, MISep 1, 1975 · N4161V · Substantial damage NTSB CHI76DEM10Accident · Minor injuriesClosedPiper PA-24 · Rapid City, MIAug 30, 1975 · N6830P · Substantial damage NTSB CHI76DEM09Accident · Minor injuriesClosedBeech C35 · Rockford, MIAug 29, 1975 · N1863D · Substantial damage NTSB CHI76DEM08Accident · No injuriesClosedPiper PA-20 · Charlotte, MIAug 24, 1975 · N6993K · Substantial damage NTSB CHI76FEC09Accident · No injuriesClosedPiper J3F-65 · Blissfield, MIAug 20, 1975 · N40782 · Substantial damage NTSB CHI76FEM07Accident · Minor injuriesClosedCessna 150G · Nunica, MIAug 18, 1975 · N2441J · Substantial damage NTSB CHI76FEC08Accident · No injuriesClosedCessna 175 · Lambertville, MIAug 18, 1975 · N6956E · Substantial damage NTSB CHI76AC015Accident · 1 fatalClosedBellanca 14-13 · Alma, MIAug 15, 1975 · N62277 · 2 aircraft · Destroyed NTSB CHI76FEM06Accident · Serious injuriesClosedPiper PA-12 · Midland, MIAug 14, 1975 · N3720M · Destroyed NTSB CHI76FEC07Accident · Serious injuriesClosedCessna 150L · Grosse Isle, MIAug 11, 1975 · N11401 · Substantial damage NTSB CHI76DEC05Accident · No injuriesClosedDehavilland DH-82A · Otisville, MIAug 10, 1975 · N9TM · Substantial damage NTSB CHI76FEC06Accident · No injuriesClosedPiper PA-20 · Tecumseh, MIAug 9, 1975 · N7041K · Substantial damage NTSB CHI76DEM04Accident · No injuriesClosedCessna 182 · Charlotte, MIAug 3, 1975 · N8659T · Substantial damage NTSB CHI76DEC04Accident · No injuriesClosedCessna 180 · Tecumseh, MIAug 2, 1975 · N2902C · Substantial damage NTSB CHI76DEC03Accident · No injuriesClosedCessna 172 · Almont, MIJul 28, 1975 · N6452G · Substantial damage NTSB CHI76DEC02Accident · No injuriesClosedCessna A188 · Gregory, MIJul 28, 1975 · N8156V · Substantial damage NTSB CHI76AC004Accident · 1 fatalClosedCessna 337 · St Johns, MIJul 25, 1975 · N2171X · Substantial damage NTSB CHI76FEC01Accident · No injuriesClosedHughes 269B · Flint, MIJul 24, 1975 · N9431F · Substantial damage NTSB CHI76FEM05Accident · 1 fatalClosedPiper PA-36 · Munger, MIJul 23, 1975 · N9919P · Destroyed NTSB CHI76FEM03Accident · No injuriesClosedGrumman G-164A · Hudsonville, MIJul 21, 1975 · N8609H · Substantial damage NTSB CHI76FEM02Accident · Serious injuriesClosedPiper J3-85C · Acme, MIJul 13, 1975 · N7174H · Substantial damage NTSB CHI76FEM01Accident · Serious injuriesClosedPiper PA-24 · Gobles, MIJul 4, 1975 · N7567P · Substantial damage NTSB CHI75FEC61Accident · No injuriesClosedCessna 170 · Jackson, MIJun 30, 1975 · N5737C · Substantial damage NTSB CHI75FEM49Accident · Minor injuriesClosedGrumman FM-2 · South Haven, MIJun 29, 1975 · N11FE · Substantial damage NTSB CHI75AC096Accident · 4 fatalClosedPiper PA-28 · Detroit, MIJun 26, 1975 · N481P · Destroyed NTSB CHI75FEC60Accident · No injuriesClosedCessna 140 · Grosse Isle, MIJun 23, 1975 · N1970V · Substantial damage NTSB CHI75DEC57Accident · No injuriesClosedPiper PA-28 · Cass City, MIJun 19, 1975 · N5126 · Substantial damage NTSB CHI75FEC59Accident · No injuriesClosedLake LA-4 · E Lansing, MIJun 18, 1975 · N2019L · Substantial damage