Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MKC72DER33Accident · No injuriesClosedCessna 150L · Wht Br Lake, MNDec 22, 1971 · N1601Q · Substantial damage NTSB MKC72FER34Accident · No injuriesClosedCessna 172E · Walker, MNDec 18, 1971 · N3599S · Substantial damage NTSB MKC72FER31Accident · No injuriesClosedCessna 421 · Crystal, MNDec 7, 1971 · N4018L · Substantial damage NTSB MKC72DER32Accident · No injuriesClosedCessna 150G · Lesueur, MNDec 5, 1971 · N2434J · Substantial damage NTSB MKC72AK033Accident · 1 fatalClosedAero Comdr 100 · Albert Lea, MNDec 2, 1971 · N4176X · Destroyed NTSB MKC72FER29Accident · Minor injuriesClosedCessna 182M · Belview, MNDec 1, 1971 · N91834 · Substantial damage NTSB MKC72FER30Accident · Serious injuriesClosedPiper PA-18 · Gilman, MNNov 21, 1971 · N4316Z · Substantial damage NTSB MKC72FER26Accident · 1 fatalClosedKnutson B8M · St.Paul, MNNov 13, 1971 · N34DK · Destroyed NTSB MKC72DER27Accident · No injuriesClosedAeronca L-16 · Lakeville, MNNov 13, 1971 · N6040V · Substantial damage NTSB MKC72DER28Accident · No injuriesClosedCessna 150H · Preston, MNNov 10, 1971 · N22182 · Substantial damage NTSB CHI83FA225Accident · 3 fatalClosedCessna 185 · Hovland, MNOct 26, 1971 · N9881X · Destroyed NTSB MKC72DER24Accident · No injuriesClosedBeech 19A · Blue Earth, MNOct 9, 1971 · N7682R · Substantial damage NTSB MKC72DER25Accident · No injuriesClosedMooney M20C · Walnut Grove, MNOct 8, 1971 · N6558U · Substantial damage NTSB MKC72FER21Accident · Serious injuriesClosedPiper PA-22 · Isle, MNSep 19, 1971 · N5798Z · Substantial damage NTSB MKC72DER23Accident · No injuriesClosedCessna 140 · Delavan, MNSep 17, 1971 · N2748N · Substantial damage NTSB MKC72DER22Accident · Minor injuriesClosedCessna 150J · Bemidji, MNSep 17, 1971 · N51228 · Substantial damage NTSB MKC72FER20Accident · No injuriesClosedPiper PA-28 · Duluth, MNSep 12, 1971 · N95112 · Destroyed NTSB MKC72DER19Accident · No injuriesClosedCessna 172I · Crosby, MNAug 28, 1971 · N35375 · Substantial damage NTSB MKC72DER18Accident · Minor injuriesClosedBell 47G-5 · Blomkist, MNAug 25, 1971 · N7840S · Destroyed NTSB ANC72AK014Accident · 3 fatalClosedFairchild 24W46 · Lino Lakes, MNAug 15, 1971 · N81344 · Destroyed NTSB MKC72FER17Accident · Minor injuriesClosedPiper PA-25 · E Grnd Forks, MNAug 14, 1971 · N7300Z · Substantial damage NTSB MKC72AK013Accident · 2 fatalClosedEnstrom F-28A · Osseo, MNAug 13, 1971 · N2525M · Destroyed NTSB MKC72FER16Accident · No injuriesClosedBoeing A75N1 · Waseca, MNAug 12, 1971 · N64514 · Destroyed NTSB MKC72FER15Accident · No injuriesClosedBellanca 14-13 · Effie, MNAug 11, 1971 · N86787 · Substantial damage NTSB MKC72FER14Accident · 1 fatalClosedPiper PA-18 · Rosemont, MNAug 8, 1971 · N4187Z · Destroyed NTSB MKC72AK011Accident · 2 fatalClosedAeronca 7BCM · Shakopee, MNAug 7, 1971 · N2772E · Destroyed NTSB MKC72FERI2Accident · Serious injuriesClosedAeronca 15AC · Warroad, MNAug 4, 1971 · N1443H · Destroyed NTSB MKC72DER11Accident · No injuriesClosedChampion 7GC · Hibbing, MNAug 2, 1971 · N8578E · Substantial damage NTSB MKC72FER08Accident · Minor injuriesClosedPiper PA-28 · New Ulm, MNJul 27, 1971 · N7435R · Substantial damage NTSB MKC72FER09Accident · Minor injuriesClosedPiper PA-28 · Ponsford, MNJul 25, 1971 · N9770J · Substantial damage NTSB MKC72DER07Accident · No injuriesClosedCessna 150 · Princeton, MNJul 22, 1971 · N3653J · Substantial damage NTSB MKC72FER10Accident · Minor injuriesClosedCessna 182B · Eden Prairie, MNJul 21, 1971 · N2470G · Substantial damage NTSB MKC72AK007Accident · 2 fatalClosedGlobe GC-1B · St.Paul, MNJul 21, 1971 · N3792K · Destroyed NTSB MKC72DER06Accident · No injuriesClosedGlobe GC-1B · Big Fork, MNJul 8, 1971 · N80613 · Substantial damage NTSB MKC72DER13Accident · No injuriesClosedCessna 170B · Tyler, MNJul 5, 1971 · N2798D · Substantial damage NTSB MKC72FER03Accident · Serious injuriesClosedCessna 150 · Shevlin, MNJul 4, 1971 · N2846S · Substantial damage NTSB MKC72DER04Accident · No injuriesClosedPiper PA-28 · Wheaton, MNJul 4, 1971 · N3826T · Substantial damage NTSB MKC72FER02Accident · 1 fatalClosedBensen B-8M · Anoka, MNJul 3, 1971 · N5680 · Destroyed NTSB MKC72FER05Accident · No injuriesClosedPiper PA-30 · Eden Prairie, MNJul 1, 1971 · N8626Y · Substantial damage NTSB MKC72DER01Accident · No injuriesClosedPiper J3C · Rapidan, MNJul 1, 1971 · N3675K · Substantial damage NTSB MKC71FER77Accident · Minor injuriesClosedCommonwlth 8135 · Royalton, MNJun 27, 1971 · N25552 · Substantial damage NTSB MKC71DER75Accident · No injuriesClosedCessna 172H · Brainerd, MNJun 18, 1971 · N8271L · Substantial damage NTSB MKC71DER74Accident · Minor injuriesClosedBell 47G2 · Franklin, MNJun 15, 1971 · N13298 · Substantial damage NTSB MKC71FER72Accident · Serious injuriesClosedCessna 150 · Browerville, MNJun 13, 1971 · N6922S · Substantial damage NTSB MKC71DER76Accident · No injuriesClosedSchweizer 1-26 · Hayfield, MNJun 13, 1971 · N8603R · Substantial damage NTSB MKC71DER78Accident · Serious injuriesClosedPiper PA-18 · Ortonville, MNJun 12, 1971 · N1667P · Substantial damage NTSB MKC71FER71Accident · 1 fatalClosedPiper PA-18 · Barnesville, MNJun 8, 1971 · N6186D · Destroyed NTSB MKC71FER69Accident · No injuriesClosedHughes 269A · Montevideo, MNJun 6, 1971 · N8925F · Substantial damage NTSB MKC71FER68Accident · No injuriesClosedPiper PA-28S · Roseville, MNJun 5, 1971 · N4974L · Substantial damage NTSB MKC71DER70Accident · No injuriesClosedCessna 170B · Lakeville, MNJun 5, 1971 · N2568C · Substantial damage