Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MKC73DER30Accident · No injuriesClosedChampion 7KCAB · Red Wing, MNDec 28, 1972 · N5167X · Substantial damage NTSB MKC73DER31Accident · No injuriesClosedPiper PA-30 · Morris, MNDec 27, 1972 · N8387Y · Substantial damage NTSB MKC73DER33Accident · No injuriesClosedCessna 182 · Minneapolis, MNDec 26, 1972 · N3120R · Substantial damage NTSB MKC73DER32Accident · No injuriesClosedPiper PA-28 · New Ulm, MNDec 26, 1972 · N1718T · Substantial damage NTSB MKC73DER29Accident · No injuriesClosedCessna 180B · St. Cloud, MNDec 21, 1972 · N5095E · Substantial damage NTSB MKC73AKO43Accident · 5 fatalClosedCessna T210K · Eden Prarie, MNDec 20, 1972 · N8202M · Substantial damage NTSB MKC73FER28Accident · No injuriesClosedPiper PA-24 · T.R.Falls, MNDec 7, 1972 · N6900P · Substantial damage NTSB MKC73AK040Accident · 2 fatalClosedBeech C-45H · St.Paul, MNNov 29, 1972 · N717B · Destroyed NTSB MKC73AK037Accident · 2 fatalClosedCessna 182 · Duluth, MNNov 8, 1972 · N70586 · Destroyed NTSB MKC73DER27Accident · No injuriesClosedPiper PA-22 · Anoka, MNOct 27, 1972 · N8427D · Substantial damage NTSB MKC73FER26Accident · No injuriesClosedCessna 150G · Anoka, MNOct 25, 1972 · N3085S · Substantial damage NTSB MKC73AKO27Accident · Minor injuriesClosedCessna 182B · Cloquet, MNOct 19, 1972 · N2470G · Substantial damage NTSB MKC73FER24Accident · No injuriesClosedAmer Avco AA1A · Eden Prairie, MNOct 11, 1972 · N9217L · Substantial damage NTSB MKC73FER25Accident · No injuriesClosedPiper PA-28 · Duluth, MNOct 7, 1972 · N4486J · Substantial damage NTSB MKC73DER23Accident · No injuriesClosedCessna 195B · Park Rapids, MNOct 6, 1972 · N3082B · Substantial damage NTSB MKC73DER22Accident · Minor injuriesClosedCessna 175 · Duluth, MNOct 4, 1972 · N76MA · Substantial damage NTSB MKC73AK022Accident · 1 fatalClosedForney F-1A · Clearbrook, MNSep 19, 1972 · N3034G · Destroyed NTSB MKC73FER21Accident · No injuriesClosedBeech 95-B55 · Detroit Lks, MNSep 7, 1972 · N7958K · Substantial damage NTSB MKC73FER18Accident · No injuriesClosedCessna 210B · Leonard, MNSep 4, 1972 · N3828Y · Substantial damage NTSB MKC73AK021Accident · 4 fatalClosedPiper PA-22 · Princeton, MNSep 4, 1972 · N3365Z · Destroyed NTSB MKC73FER16Accident · No injuriesClosedCessna 170B · Hibbing, MNAug 27, 1972 · N2555C · Substantial damage NTSB MKC73DER15Accident · No injuriesClosedCessna 180H · Walker, MNAug 25, 1972 · N9059M · Substantial damage NTSB MKC73FER14Accident · No injuriesClosedPiaggio P-136 · Minneapolis, MNAug 24, 1972 · N201NA · Substantial damage NTSB MKC73AK017Accident · 2 fatalClosedCessna 180B · Anoka, MNAug 24, 1972 · N5271E · Destroyed NTSB MKC73DER13Accident · No injuriesClosedPiper PA-25 · Mapleton, MNAug 19, 1972 · N7217Z · Substantial damage NTSB MKC73FER12Accident · No injuriesClosedGrumman G-164A · Hollandale, MNAug 17, 1972 · N7843 · Substantial damage NTSB MKC73DER19Accident · No injuriesClosedPiper PA-28 · Montevideo, MNAug 17, 1972 · N6302R · Substantial damage NTSB MKC73FER11Accident · No injuriesClosedCessna 170 · Rosemount, MNAug 16, 1972 · N3824V · Substantial damage NTSB MKC73AK016Accident · 2 fatalClosedCessna 182 · Eden Prairie, MNAug 10, 1972 · N182TC · 2 aircraft · Destroyed NTSB MKC73FER09Accident · Minor injuriesClosedPiper PA-28 · Perham, MNJul 29, 1972 · N7406W · Substantial damage NTSB MKC73DER20Accident · No injuriesClosedBeech D55 · Thef Riv.Fls, MNJul 24, 1972 · N8470N · Substantial damage NTSB MKC73FER10Accident · No injuriesClosedLuscombe 8A · Marshall, MNJul 22, 1972 · N1459K · Substantial damage NTSB MKC73DER08Accident · No injuriesClosedCessna 310 · Duluth, MNJul 21, 1972 · N169G · Substantial damage NTSB MKC73FER07Accident · No injuriesClosedPiper PA-22 · Eden Prairie, MNJul 19, 1972 · N2331P · Substantial damage NTSB MKC73FER06Accident · No injuriesClosedAeronca 11AC · Two Harbors, MNJul 18, 1972 · N3289E · Substantial damage NTSB MKC73FER03Accident · No injuriesClosedBeech A60 · Coon Rapids, MNJul 15, 1972 · N176D · Substantial damage NTSB MKC73AK005Accident · No injuriesClosedLockheed PV-1 · Lakeville, MNJul 10, 1972 · N5033F · Substantial damage NTSB MKC73FER02Accident · Serious injuriesClosedBeech 19A · Forest Lake, MNJul 7, 1972 · N7649R · Substantial damage NTSB MKC73AK003Accident · 2 fatalClosedN.American SNJ-4 · Thief Rvr Fl, MNJul 6, 1972 · N7056C · Destroyed NTSB MKC73FER04Accident · Minor injuriesClosedEL Tomcat MK6B · Miesville, MNJul 5, 1972 · N7840S · Destroyed NTSB MKC72DER70Accident · No injuriesClosedGrumman G164A · Roland, MNJun 28, 1972 · N5275 · Substantial damage NTSB MKC72DER69Accident · Minor injuriesClosedBensen-Ayer B8MJ · Huntington, MNJun 27, 1972 · N8251 · Substantial damage NTSB MKC72FER68Accident · No injuriesClosedPiper PA-30 · Fergus Fls, MNJun 15, 1972 · N7573Y · Substantial damage NTSB MKC72FER66Accident · No injuriesClosedBeech H35 · Eden Prairie, MNJun 15, 1972 · N5436D · Substantial damage NTSB MKC72FER67Accident · No injuriesClosedCessna 172I · White Bar Lk, MNJun 14, 1972 · N46015 · Substantial damage NTSB MKC72FER64Accident · Serious injuriesClosedLuscombe 8A · Circle Pines, MNJun 10, 1972 · N71782 · Substantial damage NTSB MKC72DER65Accident · No injuriesClosedAmer Avco AA1A · Barnsville, MNJun 10, 1972 · N9250L · Substantial damage NTSB MKC73DER05Accident · No injuriesClosedCessna 140 · Princeton, MNJun 8, 1972 · N3577V · Substantial damage NTSB MKC72FER62Accident · Serious injuriesClosedAero Comdr A-9B · Mt.Lake, MNMay 26, 1972 · N7756V · Destroyed NTSB MKC72FER63Accident · No injuriesClosedN.American NA-265 · Minneapolis, MNMay 25, 1972 · N1903W · Substantial damage