Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MKC71FDM40Accident · Serious injuriesClosedCessna 150G · Arden Hills, MNDec 23, 1970 · N3738J · Destroyed NTSB MKC71FDM39Accident · Serious injuriesClosedLuscombe 8A · Pine City, MNDec 20, 1970 · N2121B · Substantial damage NTSB MKC71FDM38Accident · No injuriesClosedSwearingen 2B · Minneapolis, MNDec 17, 1970 · CF-HYX · Substantial damage NTSB MKC71AK034Accident · No injuriesClosedBeech C-45H · Minneapolis, MNDec 12, 1970 · N5043K · Substantial damage NTSB MKC71FDM37Accident · No injuriesClosedPiper PA-20 · Big Fork, MNDec 9, 1970 · N7742K · Substantial damage NTSB MKC71FDM35Accident · Minor injuriesClosedAero Comdr 100 · Lake Elmo, MNDec 6, 1970 · N4050X · Destroyed NTSB MKC71FDM36Accident · No injuriesClosedBensen B-8M · Lake Elmo, MNNov 5, 1970 · N2436 · Substantial damage NTSB MKC71FDM34Accident · No injuriesClosedCessna 172L · Minneapolis, MNNov 3, 1970 · N7737G · Substantial damage NTSB MKC71AK025Accident · 2 fatalClosedPiper PA-32 · Shakopee, MNNov 1, 1970 · N4150R · Destroyed NTSB MKC71FDD15Accident · No injuriesClosedPiper PA-22 · Fergus Falls, MNOct 30, 1970 · N2372P · Substantial damage NTSB MKC71AK023Accident · 3 fatalClosedMooney M20C · St Cloud, MNOct 25, 1970 · N6206U · Destroyed NTSB MKC71FDM32Accident · No injuriesClosedBeech A23A · Lake Elmo, MNOct 21, 1970 · N7414T · Substantial damage NTSB MKC71FDM33Accident · Serious injuriesClosedBeech D95A · Jacobson, MNOct 12, 1970 · N5807S · Destroyed NTSB MKC71AK018Accident · No injuriesClosedCessna 150E · Anoka, MNOct 12, 1970 · N6200R · 2 aircraft · Substantial damage NTSB MKC71FDM31Accident · No injuriesClosedCessna 140 · Burnsville, MNOct 6, 1970 · N3555V · Substantial damage NTSB MKC71FDM30Accident · Minor injuriesClosedCessna 172G · Hastings, MNOct 2, 1970 · N4185L · Substantial damage NTSB MKC71FDM28Accident · No injuriesClosedPiper PA-28 · Springfield, MNSep 26, 1970 · N5612W · Substantial damage NTSB MKC71FDM27Accident · 1 fatalClosedCurtiss Oriole · Minneapolis, MNSep 26, 1970 · N109NG · Destroyed NTSB MKC71FDM26Accident · No injuriesClosedBeech C-45H · Rochester, MNSep 19, 1970 · N5043K · Substantial damage NTSB MKC71FDM24Accident · Minor injuriesClosedCessna 150F · Isabella, MNSep 18, 1970 · N8743G · Substantial damage NTSB MKC71FDD13Accident · No injuriesClosedPiper PA-25 · Humboldt, MNSep 18, 1970 · N7767Z · Substantial damage NTSB MKC71FDM25Incident · No injuriesClosedCessna 150K · Duluth, MNSep 9, 1970 · N6388G · Minor damage NTSB MKC71DDM22Accident · No injuriesClosedCessna U206D · So.St.Paul, MNSep 8, 1970 · N72285 · Substantial damage NTSB MKC71AK011Accident · 1 fatalClosedBeech E50 · Waseca, MNSep 5, 1970 · N4388D · Destroyed NTSB MKC71FDD09Accident · Minor injuriesClosedCessna 180H · Warroad, MNAug 25, 1970 · N7916V · Substantial damage NTSB MKC71FDD08Accident · No injuriesClosedCessna 188 · Climax, MNAug 25, 1970 · N3555Q · Substantial damage NTSB MKC71DDM21Accident · No injuriesClosedPiper J3C-65 · Duluth, MNAug 24, 1970 · N6250H · Substantial damage NTSB MKC71DDD06Accident · No injuriesClosedStinson 108-3 · Detroit Lks, MNAug 15, 1970 · N737C · Substantial damage NTSB MKC71DDM20Accident · No injuriesClosedLuscombe 8B · Northfield, MNAug 2, 1970 · N25147 · Substantial damage NTSB MKC71FDM15Accident · No injuriesClosedCessna 172E · Elysian, MNAug 1, 1970 · N5688T · Substantial damage NTSB MKC71DDM14Accident · No injuriesClosedBell 47G-2 · Morton, MNJul 27, 1970 · N13298 · Substantial damage NTSB MKC71FDD03Accident · No injuriesClosedMooney M20E · Underwood, MNJul 23, 1970 · N6951U · Substantial damage NTSB MKC71FDM12Accident · Serious injuriesClosedPiper J3C-65 · Circle Pines, MNJul 16, 1970 · N28051 · Substantial damage NTSB MKC71DDM13Accident · No injuriesClosedCessna 140 · Rosemount, MNJul 14, 1970 · N77425 · Substantial damage NTSB MKC71AK003Accident · 2 fatalClosedPiper PA-16 · Floodwood, MNJul 14, 1970 · N5691H · Destroyed NTSB MKC71FDD01Accident · Minor injuriesClosedCessna 180C · Bemidji, MNJul 12, 1970 · N9227T · Substantial damage NTSB MKC71FDM04Accident · Minor injuriesClosedCessna U206B · Grand Marais, MNJul 11, 1970 · N3890G · Substantial damage NTSB MKC71DDM17Accident · Minor injuriesClosedCessna 172 · Motley, MNJul 11, 1970 · N7510X · Substantial damage NTSB MKC71FDM11Accident · No injuriesClosedCessna 320 · Sprg Lake Pk, MNJul 9, 1970 · N5783X · Substantial damage NTSB MKC71DDM05Accident · No injuriesClosedCessna 150F · Lincoln, MNJul 8, 1970 · N6485F · Substantial damage NTSB MKC71DDM08Accident · No injuriesClosedPiper PA-28 · Marshall, MNJul 7, 1970 · N6302R · Substantial damage NTSB MKC71FDM06Accident · Minor injuriesClosedPiper PA-22 · Two Harbors, MNJul 5, 1970 · N1305C · Substantial damage NTSB MKC71DDM03Accident · No injuriesClosedCessna C-34 · Pennock, MNJul 5, 1970 · N12599 · 2 aircraft · Substantial damage NTSB MKC71DDM02Accident · No injuriesClosedCessna U206 · Jordan, MNJul 5, 1970 · N3430L · Substantial damage NTSB MKC71FDM07Accident · No injuriesClosedBeech D18S · St.Paul, MNJul 3, 1970 · N8615A · Substantial damage NTSB MKC71DDM09Accident · No injuriesClosedCessna 172H · Pequot Lakes, MNJul 2, 1970 · N3246L · Substantial damage NTSB MKC70FDM37Accident · No injuriesClosedChampion S7EC · Cambridge, MNJun 20, 1970 · N7434B · Substantial damage NTSB MKC70FDM36Accident · No injuriesClosedCessna 150F · Crystal, MNJun 20, 1970 · N7936F · Substantial damage NTSB MKC70DDM35Accident · No injuriesClosedCessna 172G · Lakeville, MNJun 17, 1970 · N4312L · Substantial damage NTSB MKC70FDM34Accident · No injuriesClosedHughes 269A · Vesta, MNJun 16, 1970 · N8867F · Destroyed