Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MKC69D0333Accident · No injuriesClosedCessna 150 · Eden Prairie, MNDec 29, 1968 · N6825F · Substantial damage NTSB MKC69D0348Accident · No injuriesClosedTaylorcraft BC-12D · Shevlin, MNDec 21, 1968 · N43612 · Substantial damage NTSB MKC69D0310Accident · No injuriesClosedCessna 170B · Mound, MNDec 20, 1968 · N8004A · Substantial damage NTSB MKC69A0038Accident · 2 fatalClosedPiper PA-22 · Morris, MNDec 14, 1968 · N9533D · Destroyed NTSB MKC69D0291Accident · No injuriesClosedCessna 150 · Eden Prairie, MNDec 4, 1968 · N23371 · Substantial damage NTSB MKC69A0035Accident · 4 fatalClosedMooney M20E · Rochester, MNNov 24, 1968 · N5965Q · Destroyed NTSB MKC69A0032Accident · No injuriesClosedLockheed 188 · Minneapolis, MNNov 19, 1968 · N1284S · No damage NTSB MKC69D0273Accident · No injuriesClosedBeech A23-19 · Lake Elmo, MNNov 14, 1968 · N4769J · Substantial damage NTSB MKC69D0265Accident · No injuriesClosedCessna 150 · Anoka, MNNov 8, 1968 · N8523J · Substantial damage NTSB MKC69A0028Accident · No injuriesClosedBeech D18S · Alexandria, MNNov 4, 1968 · N203W · Substantial damage NTSB MKC69F0278Accident · Minor injuriesClosedCessna 206 · Albert Lea, MNNov 3, 1968 · N2617X · 2 aircraft · Substantial damage NTSB MKC69D0294Accident · No injuriesClosedCessna 180A · Waverly, MNOct 29, 1968 · N7819A · Substantial damage NTSB MKC69F0237Accident · No injuriesClosedBensen B8-M · Anoka, MNOct 21, 1968 · N1802 · Substantial damage NTSB MKC69D0246Accident · No injuriesClosedCessna 170 · Almelund, MNOct 19, 1968 · N2632V · Substantial damage NTSB MKC6.A0026Accident · 2 fatalClosedBeech T-34A · Glencoe, MNOct 16, 1968 · N10586 · Destroyed NTSB MKC69F0218Accident · Serious injuriesClosedTaylorcraft BC12-D · Starbuck, MNOct 13, 1968 · N96035 · Minor damage NTSB MKC69F0244Accident · Minor injuriesClosedCessna 177 · Whte Bear Lk, MNOct 12, 1968 · N2210Y · Substantial damage NTSB MKC69D0378Accident · No injuriesClosedCessna 150 · Avon, MNOct 10, 1968 · N3877J · Substantial damage NTSB CHI69A0039Accident · 1 fatalClosedTaylorcraft BC12-D · Ogilvie, MNOct 10, 1968 · N96557 · Destroyed NTSB MKC69F0277Accident · No injuriesClosedPiper PA-12 · Bagley, MNOct 6, 1968 · N2995M · Substantial damage NTSB MKC68F0242Accident · Minor injuriesClosedPiper PA-28 · Mabel, MNSep 24, 1968 · N1577J · Destroyed NTSB MKC69D0190Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNSep 20, 1968 · N3007M · Substantial damage NTSB MKC69A0014Accident · 1 fatalClosedPiper PA-24 · Stewartville, MNSep 20, 1968 · N8425P · Destroyed NTSB MKC69D0318Accident · No injuriesClosedCessna 170 · Bemidji, MNSep 11, 1968 · N5410C · Substantial damage NTSB MKC69D0176Accident · No injuriesClosedCessna 172 · Walker, MNSep 8, 1968 · N35519 · Substantial damage NTSB MKC68A0013Accident · 1 fatalClosedPiper PA-22 · Lake Benton, MNSep 8, 1968 · N6827B · Destroyed NTSB MKC69D0196Accident · No injuriesClosedPiper PA-28 · Ely, MNSep 7, 1968 · N9725J · Substantial damage NTSB MKC69D0192Accident · No injuriesClosedPiper PA-22 · Holdingford, MNSep 2, 1968 · N1335C · Substantial damage NTSB MKC69F0227Accident · No injuriesClosedBeech B23 · Pequot Lakes, MNAug 31, 1968 · N2388Q · Substantial damage NTSB MKC69F0134Accident · No injuriesClosedCurtiss MR-1 · Eden Prairie, MNAug 29, 1968 · N91258 · Substantial damage NTSB MKC69F0135Accident · No injuriesClosedAero Comdr 680T · Minneapolis, MNAug 27, 1968 · N7610U · Substantial damage NTSB MKC69F0078Accident · No injuriesClosedBell 47G-5 · Glencoe, MNAug 26, 1968 · N7870S · Substantial damage NTSB MKC69D0226Accident · No injuriesClosedBeech A23-19 · Stanton, MNAug 25, 1968 · N6971Q · Substantial damage NTSB MKC69F0090Accident · No injuriesClosedPiper PA-22 · Pequot Lakes, MNAug 20, 1968 · N806A · Substantial damage NTSB MKC69F0066Accident · No injuriesClosedCessna 177 · Minneapolis, MNAug 19, 1968 · N2233Y · Substantial damage NTSB MKC69D0183Accident · No injuriesClosedPiper PA-18 · New Ulm, MNAug 19, 1968 · N3695P · Substantial damage NTSB MKC69D0125Accident · No injuriesClosedChampion 7GCAA · St.James, MNAug 16, 1968 · N9607S · Substantial damage NTSB MKC69D0113Accident · No injuriesClosedPiper PA-16 · Rush City, MNAug 14, 1968 · N5705H · Substantial damage NTSB MKC69F0088Accident · Minor injuriesClosedCessna TU206B · Anoka, MNAug 10, 1968 · N4963F · Substantial damage NTSB MKC69D0115Accident · No injuriesClosedBoeing A75 · New Richland, MNAug 8, 1968 · N54027 · Substantial damage NTSB MKC69A0009Accident · 2 fatalClosedCessna 170 · Howard Lake, MNAug 7, 1968 · N3901V · Destroyed NTSB MKC69D0103Accident · No injuriesClosedCessna 172 · Isle, MNAug 4, 1968 · N8522B · Substantial damage NTSB MKC69F0066Accident · No injuriesClosedBeech D35 · St.Paul, MNJul 30, 1968 · N3471B · Substantial damage NTSB MKC69D0059Accident · No injuriesClosedCessna 177 · Eden Prairie, MNJul 27, 1968 · N3419T · Substantial damage NTSB MKC69F0106Accident · No injuriesClosedPiper PA-25 · Ada, MNJul 26, 1968 · N7015Z · Substantial damage NTSB MKC69D0203Accident · No injuriesClosedPiper PA-14 · Pelican Rpds, MNJul 23, 1968 · N5188H · Substantial damage NTSB MKC69F0058Accident · No injuriesClosedBeech A23A · Austin, MNJul 21, 1968 · N1000J · Substantial damage NTSB MKC69F0095Accident · Minor injuriesClosedPiper J3C · Austin, MNJul 19, 1968 · N6535H · Destroyed NTSB MKC69F0061Accident · No injuriesClosedStinson 108 · Osseo, MNJul 19, 1968 · N40110 · Substantial damage NTSB MKC69F0063Accident · No injuriesClosedPiper PA-28 · Breckenridge, MNJul 15, 1968 · N4928J · Substantial damage