Skip to content

NTSB investigations, 1966, MN

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

19642026

NTSB investigations, 1966, MN per year, 1964–2026: 3,233 cases
1964	113
1965	115
1966	117
1967	130
1968	95
1969	113
1970	88
1971	80
1972	82
1973	77
1974	83
1975	98
1976	78
1977	92
1978	98
1979	76
1980	66
1981	89
1982	61
1983	68
1984	51
1985	57
1986	43
1987	40
1988	52
1989	50
1990	42
1991	59
1992	25
1993	40
1994	39
1995	37
1996	40
1997	37
1998	36
1999	33
2000	39
2001	40
2002	46
2003	40
2004	32
2005	31
2006	29
2007	25
2008	31
2009	29
2010	32
2011	28
2012	28
2013	33
2014	24
2015	15
2016	26
2017	20
2018	14
2019	16
2020	26
2021	12
2022	24
2023	34
2024	24
2025	22
2026	13

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") = 1966 AND c."eventStateOrRegion" = 'MN' 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\") = 1966
    AND c.\"eventStateOrRegion\" = 'MN' 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") = 1966
  AND c."eventStateOrRegion" = 'MN' 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 MKC67F0383Accident · Minor injuriesClosedAeronca 7CCM · Phelphs, MNDec 31, 1966 · N4642E · Substantial damage NTSB MKC67D0368Accident · No injuriesClosedCessna 182 · Maple Plain, MNDec 28, 1966 · N6384A · Substantial damage NTSB MKC67F0376Accident · Serious injuriesClosedChampion 7AC · Moose Lake, MNDec 26, 1966 · N82838 · Substantial damage NTSB MKC67D0384Accident · No injuriesClosedCessna 120 · Buyek, MNDec 26, 1966 · N72775 · Substantial damage NTSB MKC67D0360Accident · No injuriesClosedPiper PA-28 · Duluth, MNDec 23, 1966 · N7147R · Substantial damage NTSB MKC67F0356Accident · No injuriesClosedNavion F · Hopkins, MNDec 19, 1966 · N5387K · Substantial damage NTSB MKC67D0354Accident · No injuriesClosedCessna 150F · Warren, MNDec 11, 1966 · N7199F · Substantial damage NTSB MKC67A0038Accident · 1 fatalClosedAero Comdr 680E · Minneapolis, MNDec 9, 1966 · N8496C · Destroyed NTSB MKC67D0412Accident · No injuriesClosedBeech P35 · Glenwood, MNDec 5, 1966 · N977Q · Substantial damage NTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNDec 3, 1966 · N9034B · Destroyed NTSB MKC67F0320Accident · No injuriesClosedPiper PA-20 · Paynesville, MNDec 3, 1966 · N7428K · Substantial damage NTSB MKC67F0355Accident · No injuriesClosedCessna 150F · Hopkins, MNNov 26, 1966 · N3520L · Substantial damage NTSB MKC67F0318Accident · No injuriesClosedPiper PA-28 · Fridley, MNNov 18, 1966 · N502UM · Substantial damage NTSB MKC67F0287Accident · Serious injuriesClosedCessna 150 · Crystal, MNNov 15, 1966 · N3698S · Destroyed NTSB MKC67F0337Accident · No injuriesClosedCessna 182 · Alexandria, MNNov 11, 1966 · N2690G · Substantial damage NTSB MKC67F0310Accident · No injuriesClosedRyan PT-22 · Isle, MNNov 6, 1966 · N47843 · Substantial damage NTSB MKC67D0263Accident · No injuriesClosedCessna 180 · So.St.Paul, MNNov 2, 1966 · N9919V · Substantial damage NTSB MKC67F0303Accident · No injuriesClosedAeronca 11CC · Savage, MNOct 28, 1966 · N4132E · Substantial damage NTSB MKC67D0301Accident · No injuriesClosedCessna 140 · Winona, MNOct 27, 1966 · N2181N · Substantial damage NTSB MKC67F0274Accident · No injuriesClosedCessna 120 · Rosemount, MNOct 25, 1966 · N77358 · Substantial damage NTSB MKC67F0302Accident · No injuriesClosedCessna 310 · Rochester, MNOct 22, 1966 · N5248A · Substantial damage NTSB MKC67F0294Accident · No injuriesClosedCessna 180 · Baudette, MNOct 20, 1966 · N2892A · Substantial damage NTSB MKC67A0029Accident · 1 fatalClosedBeech A23 · Fergus Falls, MNOct 16, 1966 · N5692S · Destroyed NTSB MKC67D0265Accident · No injuriesClosedStinson 108-2 · Ely, MNOct 12, 1966 · N9475K · Substantial damage NTSB MKC67F0272Accident · No injuriesClosedCessna 150 · Rosemount, MNSep 27, 1966 · N6684T · 2 aircraft · Substantial damage NTSB MKC67F0243Accident · No injuriesClosedCessna 172 · So.St.Paul, MNSep 26, 1966 · N8746B · Substantial damage NTSB MKC67F0244Accident · No injuriesClosedWittman AM-1 · Bloomington, MNSep 25, 1966 · N319M · Substantial damage NTSB MKC67F0238Accident · Minor injuriesClosedCessna 140 · Franklin, MNSep 17, 1966 · N2237V · Substantial damage NTSB MKC67F0201Accident · No injuriesClosedPiper J-3 · Bagley, MNSep 11, 1966 · N98502 · Substantial damage NTSB MKC67F0215Accident · No injuriesClosedBeech 35 · Crystal, MNSep 8, 1966 · N3151V · Substantial damage NTSB MKC67F0214Accident · No injuriesClosedCessna 150 · Cross Lake, MNSep 3, 1966 · N8834G · Substantial damage NTSB MKC67D0206Accident · No injuriesClosedCessna 310B · Int@L Falls, MNSep 2, 1966 · N5396A · Substantial damage NTSB MKC67D0171Accident · No injuriesClosedBellanca 14-13 · Fountain, MNAug 29, 1966 · N86719 · Substantial damage NTSB MKC67F0185Accident · Minor injuriesClosedCessna 170B · Clarissa, MNAug 28, 1966 · N2714D · Substantial damage NTSB MKC67D0186Accident · No injuriesClosedAlon A-2 · Silver Bay, MNAug 26, 1966 · N6552Q · Substantial damage NTSB MKC67A0017Accident · 1 fatalClosedPiper PA-25 · East Chain, MNAug 25, 1966 · N4443Y · Destroyed NTSB MKC67A0016Accident · 1 fatalClosedPiper PA-18A · East Chain, MNAug 25, 1966 · N9939D · Destroyed NTSB MKC67A0013Accident · Serious injuriesClosedBell 47G-2 · Plainview, MNAug 20, 1966 · N269MV · Substantial damage NTSB MKC67D0169Accident · No injuriesClosedCessna 170B · Aple Lake, MNAug 17, 1966 · N2798D · Substantial damage NTSB MKC67A0012Accident · Minor injuriesClosedCessna 182C · Underwood, MNAug 17, 1966 · N8819T · Substantial damage NTSB MKC67D0159Accident · No injuriesClosedPiper PA-28 · Fairmont, MNAug 11, 1966 · N6675W · Substantial damage NTSB MKC67F0156Accident · No injuriesClosedAlon A-2 · Tanton, MNAug 7, 1966 · N6587Q · Substantial damage NTSB MKC67D0098Accident · No injuriesClosedCessna 140 · Wells, MNAug 7, 1966 · N76346 · Substantial damage NTSB MKC67D0116Accident · No injuriesClosedBeech D18S · Minneapolis, MNAug 4, 1966 · N51021 · Substantial damage NTSB MKC67F0117Accident · No injuriesClosedCessna 175 · Marshall, MNJul 31, 1966 · N9352B · Substantial damage NTSB MKC67D0120Accident · No injuriesClosedBeech D35 · Winona, MNJul 30, 1966 · N4632D · Substantial damage NTSB MKC67D0119Accident · No injuriesClosedPiper PA-22 · Blomkest, MNJul 30, 1966 · N8102C · Substantial damage NTSB MKC67D0107Accident · No injuriesClosedCessna 150 · Norwood, MNJul 30, 1966 · N6988F · Substantial damage NTSB MKC67F0167Accident · No injuriesClosedRepublic RC-3 · Wyoming, MNJul 29, 1966 · N6629K · Substantial damage NTSB MKC67F0145Accident · Minor injuriesClosedCessna 172 · Madison, MNJul 28, 1966 · N6332E · 2 aircraft · Substantial damage