Skip to content

NTSB investigations, 1969, MI

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 CHI70F0377Accident · No injuriesClosedPiper J3C-65 · Paw Paw, MIDec 27, 1969 · N5781N · Substantial damage NTSB CHI70D0383Accident · No injuriesClosedLuscombe 8A · Fountain, MIDec 27, 1969 · N25170 · Substantial damage NTSB CHI70F0360Accident · No injuriesClosedCessna 170B · Carleton, MIDec 13, 1969 · N3530C · Destroyed NTSB CHI70A0039Accident · No injuriesClosedBeech 99 · Detroit, MIDec 9, 1969 · N7485N · Substantial damage NTSB CHI70F0391Accident · No injuriesClosedPiper PA-30 · Grand Rapids, MIDec 6, 1969 · N8120Y · Substantial damage NTSB CHI70F0363Accident · No injuriesClosedPiper J3C-65 · Dowagiac, MIDec 6, 1969 · N92348 · Substantial damage NTSB CHI70F0359Accident · No injuriesClosedPiper PA-30 · Harrison, MINov 30, 1969 · N7342Y · Substantial damage NTSB CHI70D0346Accident · No injuriesClosedPiper PA-32 · Pontiac, MINov 30, 1969 · N3688W · Substantial damage NTSB CHI70F0354Accident · Serious injuriesClosedAeronca 7BCM · Harrison, MINov 28, 1969 · N2563E · Substantial damage NTSB CHI70F0361Accident · Serious injuriesClosedCessna 177 · Ypsilanti, MINov 27, 1969 · N3100T · Destroyed NTSB CHI70D0349Accident · No injuriesClosedCessna 150 · Hillsdale, MINov 27, 1969 · N5827G · Substantial damage NTSB CHI70A0037Accident · 3 fatalClosedCessna 182C · Saginaw, MINov 24, 1969 · N8471T · Destroyed NTSB CHI70F0353Accident · No injuriesClosedCessna 120 · Cedar Lake, MINov 23, 1969 · N76778 · Substantial damage NTSB CHI70D0343Accident · No injuriesClosedPiper PA-28 · Holland, MINov 16, 1969 · N9559W · Substantial damage NTSB CHI70D0350Accident · No injuriesClosedAeronca 65-TC · Detroit, MINov 15, 1969 · N23549 · Substantial damage NTSB CHI70F0366Accident · No injuriesClosedPiper PA-24 · Menominee, MINov 14, 1969 · N9390P · Substantial damage NTSB CHI70F0339Accident · No injuriesClosedCessna 150 · Wixom, MINov 12, 1969 · N3693J · Destroyed NTSB CHI70F0392Accident · No injuriesClosedPiper PA-22 · Gwinn, MINov 8, 1969 · N1804P · Substantial damage NTSB CHI70A0029Accident · 1 fatalClosedPiper PA-23 · Charlotte, MINov 8, 1969 · N6095C · Destroyed NTSB CHI70A0028Accident · 1 fatalClosedPiper PA-28 · Card, MINov 7, 1969 · N4477J · Destroyed NTSB CHI70F0314Accident · No injuriesClosedCessna 310D · Plymouth, MINov 4, 1969 · N6879T · Substantial damage NTSB CHI70F0321Accident · No injuriesClosedAmer Avco AA-1 · Birmingham, MINov 2, 1969 · N224Y · Substantial damage NTSB CHI70A0024Accident · 2 fatalClosedCessna A150K · Eaton Rapids, MINov 2, 1969 · N8335M · Destroyed NTSB CHI70D0318Accident · No injuriesClosedPiper PA-32 · Skanee, MIOct 30, 1969 · N3932W · Substantial damage NTSB CHI70F0328Accident · No injuriesClosedCessna 150 · Pontiac, MIOct 29, 1969 · N6101T · Destroyed NTSB CHI70F0326Accident · No injuriesClosedTaylorcraft BC12-D · Gulliver, MIOct 29, 1969 · N96116 · Substantial damage NTSB CHI70F0299Accident · Serious injuriesClosedPiper PA-22 · Grand Haven, MIOct 26, 1969 · N6006D · Destroyed NTSB CHI70F0323Accident · No injuriesClosedCessna 140 · Flint, MIOct 24, 1969 · N89119 · Substantial damage NTSB CHI70I0022Incident · No injuriesClosedSud Avn Falcon · Traverse Cty, MIOct 22, 1969 · N111M · Minor damage NTSB CHI70D0293Accident · No injuriesClosedPiper PA-22 · Cadillac, MIOct 18, 1969 · N5552Z · Substantial damage NTSB CHI70F0306Accident · No injuriesClosedAero Comdr 680 · Detroit, MIOct 15, 1969 · N6883S · Substantial damage NTSB CHI70F0315Accident · No injuriesClosedPiper PA-28 · Lapeer, MIOct 14, 1969 · N9461W · Substantial damage NTSB CHI70D0294Accident · No injuriesClosedCessna 140 · St Ignace, MIOct 10, 1969 · N3591V · Substantial damage NTSB CHI70F0270Accident · No injuriesClosedPiper PA-22 · Tecumseh, MIOct 3, 1969 · N3636A · Destroyed NTSB CHI70D0281Accident · No injuriesClosedPiper PA-28 · Alma, MISep 30, 1969 · N6796W · Substantial damage NTSB CHI70F0263Accident · No injuriesClosedPiper PA-24 · Detroit, MISep 23, 1969 · N6139P · Substantial damage NTSB CHI70A0017Accident · 2 fatalClosedLuscombe 8E · Lakeview, MISep 20, 1969 · N1760K · Destroyed NTSB CHI70F0258Accident · No injuriesClosedCessna 337D · Sparta, MISep 19, 1969 · N86334 · Substantial damage NTSB CHI70F0234Accident · No injuriesClosedCessna 172 · Marlette, MISep 16, 1969 · N7097T · Substantial damage NTSB CHI71F0001Accident · No injuriesClosedCessna 172 · Three Oaks, MISep 14, 1969 · N3941R · Substantial damage NTSB CHI70F0253Accident · No injuriesClosedPiper PA-32 · Mackinaw Cty, MISep 14, 1969 · N3688W · Substantial damage NTSB CHI70F0292Accident · Minor injuriesClosedBellanca 17-30 · Lake City, MISep 13, 1969 · N4849V · Substantial damage NTSB CHI70F0290Accident · No injuriesClosedBeech F35 · Freeland, MISep 13, 1969 · N3357C · Destroyed NTSB CHI70F0232Accident · Minor injuriesClosedCessna 140 · Traverse Cty, MISep 13, 1969 · N2727N · Substantial damage NTSB CHI70F0215Accident · No injuriesClosedMooney M20E · Grand Rapids, MISep 11, 1969 · N5664Q · Substantial damage NTSB CHI70D0229Accident · No injuriesClosedPiper PA-24 · Onstead, MISep 11, 1969 · N9213P · Substantial damage NTSB CHI70D0227Accident · No injuriesClosedLuscombe 8A · Gobles, MISep 6, 1969 · N1160K · Substantial damage NTSB CHI70F0217Accident · Serious injuriesClosedPiper PA-25 · Caro, MISep 1, 1969 · N7020Z · Destroyed NTSB CHI70F0224Accident · No injuriesClosedCessna 172 · Dundee, MIAug 30, 1969 · N8966B · Substantial damage NTSB CHI70D0221Accident · No injuriesClosedCessna 182 · Harbor Sprgs, MIAug 30, 1969 · N2880F · Substantial damage