Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 CHI73FEC20Accident · Minor injuriesClosedLuscombe 8A · Belleville, MIDec 31, 1972 · N1468K · Substantial damage NTSB CHI73FEC19Accident · Minor injuriesClosedLash A-65 · Lakeville, MIDec 26, 1972 · N6389T · Substantial damage NTSB NYC73AN086Accident · 2 fatalClosedPiper PA-23 · New Boston, MIDec 20, 1972 · N6303Y · Destroyed NTSB CHI73FEC18Accident · No injuriesClosedStinson 108-3 · Brighton, MIDec 17, 1972 · N6769M · Substantial damage NTSB CHI73AC058Accident · 2 fatalClosedLear 23 · Romulus, MIDec 15, 1972 · N20M · Destroyed NTSB NYC73AN082Accident · 1 fatalClosedCessna 320D · Benton Hrbr, MIDec 14, 1972 · N9212U · Destroyed NTSB CHI73DEM32Accident · No injuriesClosedCessna 150 · Traverse Cty, MIDec 14, 1972 · N22120 · Substantial damage NTSB CHI73AC055Accident · No injuriesClosedLear Jet 23 · Ypsilanti, MIDec 12, 1972 · N613W · Substantial damage NTSB CHI73FEM31Accident · No injuriesClosedPiper PA-23 · Gwinn, MIDec 11, 1972 · N3048P · Substantial damage NTSB CHI73AC053Accident · No injuriesClosedBell 47J-2A · Richmond, MIDec 5, 1972 · N8525F · Substantial damage NTSB CHI73FEM30Accident · No injuriesClosedAeronca 7AC · Charlotte, MIDec 3, 1972 · N2757E · Substantial damage NTSB CHI73FEC17Accident · Minor injuriesClosedAmer Avco AA1A · Detroit, MINov 23, 1972 · N9204L · Substantial damage NTSB CHI73FEC16Accident · Minor injuriesClosedMooney M20C · Salem, MINov 16, 1972 · N6532U · Substantial damage NTSB CHI73FEC15Accident · Serious injuriesClosedPiper PA-22 · Stockbridge, MINov 16, 1972 · N5358Z · Substantial damage NTSB CHI73AC046Accident · No injuriesClosedLear Jet 25 · Kalamazoo, MINov 7, 1972 · N741E · Substantial damage NTSB CHI73FEC14Accident · Minor injuriesClosedHughes 269B · Flint, MIOct 31, 1972 · N9552F · Substantial damage NTSB CHI73DEM29Accident · No injuriesClosedPiper PA-18 · Pullman, MIOct 31, 1972 · N7509K · Substantial damage NTSB CHI73FEC13Accident · No injuriesClosedPiper PA-28 · Flushing, MIOct 29, 1972 · N1648J · Substantial damage NTSB CHI73FEM24Accident · Minor injuriesClosedBell 47G · Mt Pleasant, MIOct 26, 1972 · N141B · Substantial damage NTSB CHI73FEM23Accident · No injuriesClosedBeech D50 · Marshall, MIOct 25, 1972 · N236BW · Substantial damage NTSB CHI73FEM20Accident · Minor injuriesClosedPiper PA-28 · Big Rapids, MIOct 20, 1972 · N3657R · Substantial damage NTSB CHI73FET08Accident · Serious injuriesClosedGenie Teene · Watervliet, MIOct 15, 1972 · N4027 · Substantial damage NTSB CHI73DEM22Accident · No injuriesClosedCessna 190 · Luzerne, MIOct 15, 1972 · N9896A · Substantial damage NTSB CHI73FEM21Accident · Minor injuriesClosedChampion 7ECA · Plainwell, MIOct 14, 1972 · N2671G · Substantial damage NTSB CHI73AC041Accident · 3 fatalClosedCessna 172L · Grayling, MIOct 14, 1972 · N3835Q · Destroyed NTSB CHI73FEM28Accident · No injuriesClosedCessna 150 · Antrim, MIOct 9, 1972 · N60161 · Substantial damage NTSB CHI73DEM27Accident · No injuriesClosedPiper PA-32 · Lake City, MIOct 7, 1972 · N4727S · Substantial damage NTSB CHI73AC036Accident · 1 fatalClosedSchleicher AS-K13 · Oxford, MIOct 4, 1972 · N3105 · Destroyed NTSB CHI73FEM19Accident · No injuriesClosedAero Comdr 100 · Greenville, MIOct 2, 1972 · N3898X · Substantial damage NTSB CHI73FEC10Accident · No injuriesClosedPiper PA-22 · Sebewaing, MISep 30, 1972 · N3338Z · Substantial damage NTSB CHI73FEC11Accident · Minor injuriesClosedCessna 172 · Clinton, MISep 29, 1972 · N46567 · Substantial damage NTSB CHI73FEC09Accident · No injuriesClosedAero Comdr 100 · Laingsburg, MISep 28, 1972 · N2951T · Substantial damage NTSB CHI73FEM18Accident · No injuriesClosedBeech H35 · Gaylord, MISep 23, 1972 · N5524D · Substantial damage NTSB CHI73ACO34Accident · 3 fatalClosedPiper PA-23 · Hubbard Lk, MISep 18, 1972 · N5695Y · Destroyed NTSB CHI73FEM25Accident · No injuriesClosedBeech V35A · Barryton, MISep 16, 1972 · N7444S · Substantial damage NTSB CHI73FEM17Accident · No injuriesClosedCessna 177 · Grand Rapids, MISep 15, 1972 · N2396Y · Substantial damage NTSB CHI73FEC06Accident · No injuriesClosedBeech 56TC · Clarkston, MISep 10, 1972 · N3EF · Substantial damage NTSB CHI73AC031Accident · 1 fatalClosedBeech V35B · Newberry, MISep 9, 1972 · N81RB · Destroyed NTSB CHI73FEM15Accident · No injuriesClosedTaylorcraft BC12 · Pinconning, MISep 4, 1972 · N33956 · Substantial damage NTSB CHI73FEM16Accident · Minor injuriesClosedCessna 172L · Newberry, MISep 2, 1972 · N19636 · Destroyed NTSB CHI73FEC07Accident · No injuriesClosedPiper PA-32 · Onsted, MISep 2, 1972 · N3802W · Substantial damage NTSB CHI73AC028Accident · No injuriesClosedCessna 310N · Grand Rapids, MISep 1, 1972 · N174K · 2 aircraft · Substantial damage NTSB CHI73FEC05Accident · No injuriesClosedStampe SV4-C · Pontiac, MIAug 31, 1972 · N14428 · 2 aircraft · Substantial damage NTSB CHI73FEC08Accident · No injuriesClosedBell 47G-5A · Blissfield, MIAug 28, 1972 · N2988W · Substantial damage NTSB CHI73DEC04Accident · No injuriesClosedHughes 269A · Troy, MIAug 26, 1972 · N8889F · Destroyed NTSB CHI73AC026Accident · 2 fatalClosedCessna 414 · Sturgis, MIAug 25, 1972 · N8168Q · Destroyed NTSB CHI73ACO24Accident · 3 fatalClosedMooney M20B · Lansing, MIAug 24, 1972 · N74709 · Destroyed NTSB CHI73DEM14Accident · No injuriesClosedCessna 182A · Charlevoix, MIAug 23, 1972 · N5187D · Substantial damage NTSB CHI73FEM12Accident · No injuriesClosedErco 415-C · Wayland, MIAug 19, 1972 · N94876 · Substantial damage NTSB CHI73FET05Accident · Minor injuriesClosedPiper PA-24 · Watervliet, MIAug 18, 1972 · N6092P · Substantial damage