Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MKC70F0313Accident · No injuriesClosedBeech A23A · Lake Elmo, MNDec 27, 1969 · N7414T · Substantial damage NTSB MKC70F0312Accident · No injuriesClosedCessna 172 · Worthington, MNDec 26, 1969 · N84265 · Substantial damage NTSB MKC70F0311Accident · No injuriesClosedBeech K35 · St Paul, MNDec 19, 1969 · N803R · Substantial damage NTSB MKC70D0299Accident · No injuriesClosedCessna 150F · Minneapolis, MNDec 16, 1969 · N8868G · Substantial damage NTSB MKC70A0032Accident · 2 fatalClosedBeech J35 · Barnesville, MNDec 10, 1969 · N8325D · Destroyed NTSB MKC70F0306Accident · No injuriesClosedPiper PA-28 · Park Rapids, MNNov 27, 1969 · N9053J · Substantial damage NTSB MKC70D0305Accident · No injuriesClosedPiper PA-16 · Madison, MNNov 23, 1969 · N5311H · Substantial damage NTSB MKC70D0275Accident · No injuriesClosedCessna 172G · Hibbing, MNNov 23, 1969 · N4246L · Substantial damage NTSB MKC70D0267Accident · No injuriesClosedCessna 140 · Claremont, MNNov 15, 1969 · N77189 · Substantial damage NTSB MKC70D0257Accident · Serious injuriesClosedPiper PA-28 · St.Cloud, MNNov 6, 1969 · N95005 · Destroyed NTSB MKC70D0256Accident · No injuriesClosedLuscombe 8E · Hastings, MNOct 23, 1969 · N1306B · Substantial damage NTSB MKC70A0022Accident · 1 fatalClosedChampion 7KCAB · Bemidji, MNOct 20, 1969 · N5227X · Destroyed NTSB MKC70A0021Accident · 1 fatalClosedBeech B23 · Minneapolis, MNOct 20, 1969 · N741FT · Destroyed NTSB MKC70F0255Accident · No injuriesClosedBellanca 17-30 · Aurora, MNOct 12, 1969 · N8777V · Substantial damage NTSB MKC70D0244Accident · No injuriesClosedBeech D95-A · Buffalo, MNOct 11, 1969 · N8979M · Substantial damage NTSB MKC70A0016Accident · 1 fatalClosedCessna 182A · Duluth, MNOct 4, 1969 · N9924B · Destroyed NTSB MKC70A0015Accident · 2 fatalClosedTaylorcraft BC12-D · Minneapolis, MNOct 4, 1969 · N29526 · Destroyed NTSB MKC70F0210Accident · Serious injuriesClosedLuscombe 8A · Crookston, MNSep 15, 1969 · N25276 · Substantial damage NTSB MKC70D0189Accident · No injuriesClosedCessna 150G · Cannon Falls, MNSep 10, 1969 · N4610X · Substantial damage NTSB MKC70F0228Accident · No injuriesClosedMooney M20E · Eden Prarie, MNSep 8, 1969 · N6764N · Substantial damage NTSB MKC70F0221Accident · No injuriesClosedPiper PA-28 · Blue Earth, MNAug 31, 1969 · N7193R · Substantial damage NTSB MKC70D0220Accident · No injuriesClosedBeech A23 · Mankato, MNAug 26, 1969 · N8891M · Substantial damage NTSB MKC70F0231Accident · No injuriesClosedCessna 177 · Oklee, MNAug 24, 1969 · N2233Y · Substantial damage NTSB MKC70F0164Accident · No injuriesClosedCessna 180 · St Paul, MNAug 24, 1969 · N6052V · Substantial damage NTSB MKC70D0180Accident · Serious injuriesClosedPiper PA-28 · Staples, MNAug 24, 1969 · N4504J · Destroyed NTSB MKC70D0158Accident · No injuriesClosedCessna 180C · Lakeville, MNAug 24, 1969 · N9191T · Substantial damage NTSB MKC70F0214Accident · Serious injuriesClosedPiper PA-23 · Lake Elmo, MNAug 15, 1969 · N2246P · Destroyed NTSB MKC70D0146Accident · No injuriesClosedPiper PA-25 · Big Lake, MNAug 15, 1969 · N7406Z · Substantial damage NTSB MKC70D0181Accident · No injuriesClosedCessna 182 · New Prague, MNAug 14, 1969 · N2655Q · Substantial damage NTSB FTW70D0175Accident · Serious injuriesClosedBeech D45 · Blue Earth, MNAug 12, 1969 · N4824Z · Substantial damage NTSB MKC70D0193Accident · No injuriesClosedBoeing A75 · Faribault, MNAug 11, 1969 · N1155N · Substantial damage NTSB MKC70D0194Accident · No injuriesClosedPiper J3L · Racine, MNAug 10, 1969 · N98759 · Substantial damage NTSB MKC70F0135Accident · No injuriesClosedCessna 180 · Ely, MNAug 9, 1969 · N91261 · Destroyed NTSB MKC70A0005Accident · 1 fatalClosedMooney M20E · Ogema, MNAug 9, 1969 · N6683R · Destroyed NTSB MKC70F0203Accident · No injuriesClosedBell 47J · Redwood Fall, MNAug 8, 1969 · N2863B · Substantial damage NTSB MKC70D0175Accident · Serious injuriesClosedLuscombe 8A · Moose Lake, MNAug 8, 1969 · N2008B · Destroyed NTSB MKC70D0130Accident · No injuriesClosedPiper J3C-65 · Fairfax, MNAug 3, 1969 · N34297 · Substantial damage NTSB CHI70D0144Accident · Serious injuriesClosedCessna 177 · Spooner, MNAug 2, 1969 · N2311Y · Substantial damage NTSB MKC70D0126Accident · No injuriesClosedBeech C35 · Crystal, MNAug 1, 1969 · N8953A · Substantial damage NTSB MKC70D0119Accident · No injuriesClosedYankee AA-1 · Floodwood, MNJul 25, 1969 · N5641L · Substantial damage NTSB MKC70F0113Accident · No injuriesClosedChampion 7GCAA · St.Cloud, MNJul 24, 1969 · N2626G · Substantial damage NTSB MKC70D0099Accident · No injuriesClosedPiper PA-12 · Pipestone, MNJul 20, 1969 · N4009M · Substantial damage NTSB MKC70F0169Accident · Minor injuriesClosedBell 47G-2 · Lakeville, MNJul 19, 1969 · N2490B · Substantial damage NTSB MKC70D0082Accident · No injuriesClosedBeech B23 · Ely, MNJul 19, 1969 · N4016T · Substantial damage NTSB MKC70F0117Accident · Serious injuriesClosedAeronca L-16A · Jasper, MNJul 16, 1969 · N6284C · Destroyed NTSB MKC70D0118Accident · No injuriesClosedPiper PA-30 · Owatonna, MNJul 12, 1969 · N8181Y · Substantial damage NTSB MKC70F0092Accident · Minor injuriesClosedBell P-63C5 · Crystal, MNJul 10, 1969 · N62822 · Substantial damage NTSB MKC70F0087Accident · Minor injuriesClosedPiper PA-18 · Degraff, MNJul 9, 1969 · N5474H · Substantial damage NTSB MKC70F0106Accident · No injuriesClosedAero Comdr A-9B · Mtn Lake, MNJul 5, 1969 · N7682V · Substantial damage NTSB MKC70F0078Accident · Minor injuriesClosedVolmer VJ-22 · Excelsior, MNJul 4, 1969 · N9471 · Destroyed