Skip to content

NTSB investigations, 1967, MI

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 CHI68F0529Accident · Serious injuriesClosedPiper PA-24 · Manistee, MIDec 31, 1967 · N7636P · Substantial damage NTSB CHI68F0498Accident · No injuriesClosedAero Comdr 200-D · Plymouth, MIDec 29, 1967 · N235M · Substantial damage NTSB CHI68F0516Accident · No injuriesClosedCessna 182 · Adrian, MIDec 27, 1967 · N3714U · Substantial damage NTSB CHI68F0491Accident · No injuriesClosedBeech 65-80 · Midland, MIDec 19, 1967 · N883J · Substantial damage NTSB CHI68F0500Accident · No injuriesClosedBeech C-45 · Waterford, MIDec 16, 1967 · N9800H · Substantial damage NTSB CHI68F0446Accident · No injuriesClosedCessna 150G · Ypsilanti, MIDec 13, 1967 · N2776S · Substantial damage NTSB CHI68A0051Accident · Minor injuriesClosedLear Jet 23 · Detroit, MIDec 9, 1967 · N822LJ · Destroyed NTSB CHI68F0499Accident · 1 fatalClosedPiper PA-30 · Lowell, MIDec 6, 1967 · N8071Y · Destroyed NTSB CHI68F0452Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MIDec 5, 1967 · N6459R · Substantial damage NTSB CHI68F0463Accident · No injuriesClosedCessna 337A · Detroit, MIDec 4, 1967 · N5327S · Substantial damage NTSB CHI68F0464Accident · No injuriesClosedCessna 172 · S.Rockwood, MINov 29, 1967 · N6998A · Substantial damage NTSB CHI68D0444Accident · No injuriesClosedPiper PA-32 · Houghton Lke, MINov 26, 1967 · N493CA · Substantial damage NTSB CHI68A0050Accident · 2 fatalClosedBeech G35 · Cadillac, MINov 26, 1967 · N4445D · Destroyed NTSB CHI68F0467Accident · Minor injuriesClosedTaylorcraft BC12-D · Menominee, MINov 24, 1967 · N43273 · Substantial damage NTSB CHI68F0473Accident · Serious injuriesClosedPiper J3C-65 · Coldwater, MINov 21, 1967 · N42795 · Destroyed NTSB CHI68A0047Accident · 3 fatalClosedPiper PA-24 · Davisburg, MINov 21, 1967 · N7165P · Destroyed NTSB CHI68F0409Accident · No injuriesClosedErco 415-C · Plymouth, MINov 18, 1967 · N94327 · Substantial damage NTSB CHI68A0045Accident · 2 fatalClosedBeech D35 · Richmond, MINov 18, 1967 · N2937B · Destroyed NTSB CHI68F0492Accident · No injuriesClosedPiper PA-32 · Lupton, MINov 17, 1967 · N3444W · Substantial damage NTSB CHI68F0477Accident · No injuriesClosedPiper PA-24 · Charlotte, MINov 14, 1967 · N6240P · Substantial damage NTSB CHI68F0461Accident · No injuriesClosedPiper PA-30 · Traverse Cty, MINov 12, 1967 · N8030Y · Substantial damage NTSB CHI68F0472Accident · Minor injuriesClosedPiper PA-28 · Munising, MINov 11, 1967 · N7160R · Substantial damage NTSB CHI68D0448Accident · Minor injuriesClosedBeech M35 · Houghton Lk, MINov 9, 1967 · N9746R · Substantial damage NTSB CHI68F0453Accident · No injuriesClosedPiper PA-22 · Kalamazoo, MINov 8, 1967 · N2147A · Substantial damage NTSB CHI68F0420Accident · Minor injuriesClosedBeech 95-55 · Prt St.James, MINov 5, 1967 · N8637Q · Destroyed NTSB CHI68D0466Accident · Minor injuriesClosedPiper PA-22 · Gladwin, MIOct 29, 1967 · N1641A · Substantial damage NTSB CHI68A0039Accident · Minor injuriesClosedLear Jet 23 · Muskegon, MIOct 25, 1967 · N432EJ · Destroyed NTSB CHI68F0380Accident · No injuriesClosedBeech K35 · Montague, MIOct 17, 1967 · N106V · Substantial damage NTSB CHI68D0442Accident · No injuriesClosedCessna 182 · East Tawas, MIOct 16, 1967 · N2477X · Substantial damage NTSB CHI68D0381Accident · No injuriesClosedPiper PA-28 · Beaver Is., MIOct 13, 1967 · N9705J · Substantial damage NTSB CHI68A0034Accident · 1 fatalClosedBeech B95 · Detroit, MIOct 13, 1967 · N2045C · Destroyed NTSB CHI68F0303Accident · No injuriesClosedPiper PA-22 · Plymouth, MIOct 11, 1967 · N5100Z · Substantial damage NTSB CHI68A0033Accident · No injuriesClosedDehaviland DH104 · Marquette, MIOct 10, 1967 · N425D · Substantial damage NTSB CHI68F0327Accident · No injuriesClosedErco 415-C · New Hudson, MIOct 5, 1967 · N99008 · Substantial damage NTSB CHI68F0326Accident · No injuriesClosedCessna 150 · Pontiac, MIOct 5, 1967 · N3905U · Substantial damage NTSB CHI68D0406Accident · No injuriesClosedCessna 175 · West Branch, MIOct 5, 1967 · N7134M · Substantial damage NTSB CHI68F0360Accident · No injuriesClosedBeech T-34A · Grand Rapids, MISep 28, 1967 · N638G · Substantial damage NTSB CHI68F0332Accident · No injuriesClosedBeech 95B55 · Detroit, MISep 25, 1967 · N8991M · Substantial damage NTSB CHI68F0307Accident · No injuriesClosedMooney M20C · Flint, MISep 23, 1967 · N5669Q · Substantial damage NTSB CHI68A0027Accident · 3 fatalClosedNavion A · Dansville, MISep 20, 1967 · N4894K · Destroyed NTSB CHI68F0236Accident · No injuriesClosedPiper PA-28 · Ann Arbor, MISep 17, 1967 · N6459R · Substantial damage NTSB CHI68F0341Accident · Minor injuriesClosedN.American P-51 · Hastings, MISep 16, 1967 · N251D · Destroyed NTSB CHI68F0288Accident · No injuriesClosedCessna 150E · Salem, MISep 14, 1967 · N6101T · Substantial damage NTSB CHI68F0329Accident · No injuriesClosedPiper PA-30 · Freeland, MISep 12, 1967 · N7916Y · Substantial damage NTSB CHI68F0291Accident · No injuriesClosedNavion B · Tecumseh, MISep 10, 1967 · N8569H · Substantial damage NTSB CHI68F0252Accident · No injuriesClosedCessna 170B · Reading, MISep 8, 1967 · N2751D · Substantial damage NTSB CHI68F0238Accident · No injuriesClosedCessna 172 · Detroit, MISep 5, 1967 · N3051U · Substantial damage NTSB CHI68F0268Accident · No injuriesClosedBeech B95 · Detroit, MISep 3, 1967 · N9344Y · Substantial damage NTSB CHI68F0316Accident · Minor injuriesClosedCessna U-206B · Boyne Falls, MISep 2, 1967 · N3495L · Substantial damage NTSB CHI68F0289Accident · No injuriesClosedCessna 150 · Orion, MISep 2, 1967 · N7900E · Substantial damage