Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 CHI69F0424Accident · 1 fatalClosedAlbar 02 · Mt.Pleasant, MIDec 29, 1968 · N3141 · Destroyed NTSB CHI69F0401Accident · No injuriesClosedCessna 150 · Charlotte, MIDec 15, 1968 · N5844E · Substantial damage NTSB CHI69F0400Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MIDec 11, 1968 · N5281W · Substantial damage NTSB CHI69F0396Accident · No injuriesClosedLake LA-4 · Hickory Crnr, MIDec 11, 1968 · N2030L · Substantial damage NTSB CHI69F0387Accident · No injuriesClosedCessna U206 · Lint, MIDec 11, 1968 · N3935G · Substantial damage NTSB CHI69F0386Accident · Serious injuriesClosedCessna 150G · Nn Arbor, MIDec 11, 1968 · N4716X · Substantial damage NTSB CHI69D0385Accident · Minor injuriesClosedPiper PA-24 · Lapeer, MIDec 1, 1968 · N779RH · Substantial damage NTSB CHI69D0367Accident · No injuriesClosedCessna 180 · Baraga, MINov 30, 1968 · N4572B · Substantial damage NTSB CHI69F0356Accident · No injuriesClosedCessna 177 · Gaylord, MINov 29, 1968 · N2959X · Substantial damage NTSB CHI69F0391Accident · Minor injuriesClosedCessna 172 · Jackson, MINov 28, 1968 · N8216L · Substantial damage NTSB CHI69F0379Accident · No injuriesClosedCessna 150 · Romeo, MINov 24, 1968 · N6688F · Substantial damage NTSB CHI69F0377Accident · No injuriesClosedPiper PA-28 · Tecumseh, MINov 24, 1968 · N7493J · Substantial damage NTSB CHI69F0368Accident · No injuriesClosedErco 415-C · Lawton, MINov 24, 1968 · N86978 · Substantial damage NTSB CHI69D0375Accident · No injuriesClosedJupiter K-2 · Gobles, MINov 24, 1968 · N10442 · Substantial damage NTSB CHI69F0378Accident · No injuriesClosedCessna 175 · Laingsburg, MINov 22, 1968 · N6546E · Destroyed NTSB CHI69F0357Accident · No injuriesClosedPiper PA-24 · Sparta, MINov 21, 1968 · N5031P · Substantial damage NTSB CHI69D0362Accident · No injuriesClosedCessna 177 · Barbeau, MINov 20, 1968 · CF-WUT · Substantial damage NTSB CHI69A0055Accident · Serious injuriesClosedBeech D18S · Inkster, MINov 18, 1968 · N629B · Destroyed NTSB CHI69F0363Accident · No injuriesClosedBeech B90 · Houghton, MINov 17, 1968 · N414GN · Substantial damage NTSB CHI69A0054Accident · 1 fatalClosedCessna 320E · Pontiac, MINov 17, 1968 · N3436Q · Destroyed NTSB CHI69A0052Accident · 1 fatalClosedGlobe GC-1B · Reed City, MINov 17, 1968 · N78061 · Destroyed NTSB CHI69I0051Incident · No injuriesClosedBoeing 727 · Detroit, MINov 16, 1968 · N7027U · No damage NTSB CHI69F0359Accident · No injuriesClosedMaule M-4210 · Clarkston, MINov 15, 1968 · N2014U · Substantial damage NTSB CHI69F0343Accident · No injuriesClosedCessna 150 · Plymouth, MINov 7, 1968 · N50005 · Substantial damage NTSB CHI69F0347Accident · No injuriesClosedBeech C35 · Pontiac, MINov 3, 1968 · N2199K · Substantial damage NTSB CHI69A0046Accident · Minor injuriesClosedCessna 170 · New Hudson, MINov 2, 1968 · N3509D · Substantial damage NTSB CHI69F0350Accident · No injuriesClosedNavion D · Rogers City, MIOct 25, 1968 · N5167K · Substantial damage NTSB CHI69A0044Accident · 3 fatalClosedBeech 65-80 · Houghton, MIOct 23, 1968 · N303D · Destroyed NTSB CHI69F0346Accident · Serious injuriesClosedCessna 177 · Stambaugh, MIOct 20, 1968 · N3145T · Destroyed NTSB CHI69D0319Accident · No injuriesClosedLuscombe 8E · Romeo, MIOct 20, 1968 · N2653K · Substantial damage NTSB CHI69A0042Accident · 4 fatalClosedCessna 172 · Brighton, MIOct 18, 1968 · N8656B · Destroyed NTSB CHI69F0345Accident · Minor injuriesClosedBellanca 17-30 · Watervliet, MIOct 15, 1968 · N4893V · Substantial damage NTSB CHI69D0313Accident · No injuriesClosedCessna 170B · Eureka, MIOct 15, 1968 · N2788D · Substantial damage NTSB CHI69F0311Accident · No injuriesClosedMooney M20A · Inkster, MIOct 12, 1968 · N1093C · Destroyed NTSB CHI69D0314Accident · No injuriesClosedCessna 177 · So.Branch, MIOct 12, 1968 · N2972X · Substantial damage NTSB CHI69F0277Accident · No injuriesClosedBeech E18S · Detroit, MIOct 9, 1968 · N162F · Substantial damage NTSB CHI69F0304Accident · No injuriesClosedAero Comdr 680 · Kalamazoo, MIOct 8, 1968 · N6861S · Substantial damage NTSB CHI69D0268Accident · No injuriesClosedPiper PA-22 · Salem, MIOct 5, 1968 · N2343P · Substantial damage NTSB CHI69F0303Accident · No injuriesClosedCessna 182 · Munising, MISep 30, 1968 · N69995 · Substantial damage NTSB CHI69F0292Accident · No injuriesClosedPiper J-3 · Riverdale, MISep 29, 1968 · N28033 · Substantial damage NTSB CHI69F0252Accident · Serious injuriesClosedAeronca 7AC · Lawton, MISep 28, 1968 · N83128 · Substantial damage NTSB CHI69D0272Accident · Minor injuriesClosedPiper PA-22 · Bellevue, MISep 28, 1968 · N3721P · Substantial damage NTSB CHI69F0263Accident · No injuriesClosedCessna 320E · Cement City, MISep 26, 1968 · N394AJ · Substantial damage NTSB CHI69A0034Accident · 6 fatalClosedBeech 95-B55 · Frankenmuth, MISep 22, 1968 · N6830Q · Destroyed NTSB CHI69F0256Accident · No injuriesClosedCessna 150 · Linden, MISep 21, 1968 · N7890Z · Destroyed NTSB CHI69F0258Accident · Minor injuriesClosedBeech 95-C55 · Port Huron, MISep 19, 1968 · NCF-BQA · Substantial damage NTSB CHI69F0228Accident · No injuriesClosedCessna 140 · Kawkawlin, MISep 17, 1968 · N77353 · Substantial damage NTSB CHI69F0327Accident · Minor injuriesClosedPiper PA-28 · Dowagiac, MISep 16, 1968 · N7371J · Substantial damage NTSB CHI69D0276Accident · Minor injuriesClosedChampion 7ECA · Centreville, MISep 14, 1968 · N6313N · Substantial damage NTSB CHI69A0028Accident · 1 fatalClosedTaylorcraft BF12D · Chapin, MISep 14, 1968 · N43000 · Destroyed