Skip to content

NTSB investigations, 1981, MN

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1981, 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") = 1981 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\") = 1981
    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") = 1981
  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 CHI82FER16Accident · 1 fatalClosedRutan EZ · Hackensack, MNDec 7, 1981 · N42DR · Substantial damage NTSB CHI82FA017Accident · 1 fatalClosedPiper PA-28 · Preston, MNDec 5, 1981 · N6958T · Destroyed NTSB CHI82DER17Accident · No injuriesClosedPiper PA-38 · Albert Lea, MNDec 4, 1981 · N2393G · Substantial damage NTSB CHI82FER15Accident · Minor injuriesClosedMooney M20K · Buffalo, MNNov 30, 1981 · N96446 · Substantial damage NTSB CHI82DER14Accident · No injuriesClosedBell 47G2 · Kerrick, MNNov 28, 1981 · N13298 · Substantial damage NTSB CHI82FER13Accident · No injuriesClosedCessna 182B · Eden Prairie, MNNov 27, 1981 · N7261E · Substantial damage NTSB CHI82IA015Incident · No injuriesClosedDouglas DC-10 · Minneapolis, MNNov 17, 1981 · N156US · Minor damage NTSB CHI82FA014Accident · 3 fatalClosedCessna 172 · Wolf Lake, MNNov 15, 1981 · N733BJ · Destroyed NTSB CHI82FA013Accident · 1 fatalClosedCessna 170B · Onamia, MNNov 15, 1981 · N3502C · Destroyed NTSB CHI82FER12Accident · Minor injuriesClosedPiper PA-38 · Blaine, MNNov 12, 1981 · N2560K · Substantial damage NTSB CHI82DER11Accident · No injuriesClosedPiper PA-22 · Hastings, MNNov 11, 1981 · N8707D · Substantial damage NTSB CHI82FER10Accident · No injuriesClosedCessna 150 · Crystal, MNNov 8, 1981 · N6145K · Destroyed NTSB CHI82FER08Accident · Minor injuriesClosedCessna 150 · Long Prairie, MNOct 31, 1981 · N19023 · Substantial damage NTSB CHI82FA009Accident · 3 fatalClosedPiper PA-24 · Kerrick, MNOct 30, 1981 · N8898P · Destroyed NTSB CHI82DER09Accident · No injuriesClosedPiper PA-20 · Lakeville, MNOct 27, 1981 · N7027K · Substantial damage NTSB CHI82FER07Accident · No injuriesClosedCessna 150 · Menahga, MNOct 26, 1981 · N7925U · Substantial damage NTSB CHI82DER05Accident · No injuriesClosedPiper PA-28 · New York Mills, MNOct 20, 1981 · N9714W · Substantial damage NTSB CHI82DER03Accident · No injuriesClosedPiper PA-11 · Duluth, MNOct 19, 1981 · N5042H · Substantial damage NTSB CHI82DER04Accident · No injuriesClosedBeech 58 · Owatonna, MNOct 11, 1981 · N6651X · Substantial damage NTSB CHI82DER02Accident · No injuriesClosedPiper PA-22 · Austin, MNOct 9, 1981 · N4533A · Substantial damage NTSB CHI82FER06Accident · Minor injuriesClosedPiper PA-28R · Lynd, MNOct 6, 1981 · N6923J · Substantial damage NTSB CHI82FER01Accident · Minor injuriesClosedVolksplane UP-1 · East Bethal, MNOct 2, 1981 · N1211H · Substantial damage NTSB CHI81FER72Accident · Minor injuriesClosedCessna 180 · Corcoran, MNSep 27, 1981 · N3205D · Substantial damage NTSB CHI81FER71Accident · No injuriesClosedPiper PA-28 · Edgerton, MNSep 24, 1981 · N105WC · Substantial damage NTSB CHI81FA102Accident · No injuriesClosedPiper PA-28 · Laporte, MNSep 14, 1981 · N9311K · Destroyed NTSB CHI81FER68Accident · No injuriesClosedBeech B19 · Eden Prairie, MNSep 9, 1981 · N6971R · Substantial damage NTSB CHI81DA097Accident · 1 fatalClosedCessna 152 · Bemidji, MNSep 7, 1981 · N25774 · Destroyed NTSB CHI81DER69Accident · No injuriesClosedBeech B19 · Hibbing, MNSep 6, 1981 · N18907 · Substantial damage NTSB CHI81DER66Accident · Minor injuriesClosedAeronca 15AC · Lake Crystal, MNSep 6, 1981 · N1331H · Substantial damage NTSB CHI81FER67Accident · No injuriesClosedBeech P35 · Stephen, MNSep 5, 1981 · N1501S · Substantial damage NTSB CHI81FER73Accident · No injuriesClosedHiller UH-12E · Wannaska, MNSep 4, 1981 · N1847 · Substantial damage NTSB CHI81FER70Accident · Minor injuriesClosedCessna 140 · Oklee, MNSep 2, 1981 · N3739V · Substantial damage NTSB CHI81FER64Accident · Serious injuriesClosedCessna U206 · Lake Benson, MNAug 29, 1981 · N51301 · Minor damage NTSB CHI81FER62Accident · No injuriesClosedStinson 108-1 · Wells, MNAug 18, 1981 · N9068K · Substantial damage NTSB CHI81FER61Accident · Serious injuriesClosedPiper PA-25 · Fairmont, MNAug 17, 1981 · N6643Z · Substantial damage NTSB CHI81FER60Accident · No injuriesClosedBell 47G3B1 · Stewart, MNAug 12, 1981 · N96671 · Substantial damage NTSB CHI81FER58Accident · No injuriesClosedPiper PA-25 · Blue Earth, MNAug 12, 1981 · N6991Z · Substantial damage NTSB CHI81FER57Accident · No injuriesClosedCessna 188B · Pelican Lake, MNAug 9, 1981 · N5273E · Substantial damage NTSB CHI81FER56Accident · Minor injuriesClosedPiper PA-22 · Intl Falls, MNAug 4, 1981 · CGZVP · Substantial damage NTSB CHI81FER55Accident · Minor injuriesClosedSchilling KR-2 · Lake Elmo, MNAug 2, 1981 · N37691 · Destroyed NTSB CHI81LA106Accident · 4 fatalLimited investigationClosedCessna 180 · Cotton, MNThe pilot-in-command's failure to maintain altitude and aircraft control after an encounter with instrument meteorological conditions.Aug 1, 1981 · N4988E · Destroyed NTSB CHI81FA081Accident · 1 fatalClosedCessna 152 · Minneapolis, MNJul 28, 1981 · N5391M · Destroyed NTSB CHI81FER59Accident · No injuriesClosedHiller Acft UH-12E · Glyndon, MNJul 20, 1981 · N5594N · Substantial damage NTSB CHI81IA074Incident · No injuriesClosedBoeing 747 · Minneapolis, MNJul 9, 1981 · N602US · Minor damage NTSB CHI81FER51Accident · Minor injuriesClosedBoeing A75N1 · Cottage Grove, MNJul 9, 1981 · N108P · Destroyed NTSB CHI81FER52Accident · No injuriesClosedCessna 152 · White Bear Lk, MNJul 7, 1981 · N757EY · Substantial damage NTSB CHI81FER50Accident · No injuriesClosedPiper J4A · Elgin, MNJul 6, 1981 · N32880 · Substantial damage NTSB CHI81FER49Accident · No injuriesClosedCessna A188A · Crookston, MNJul 6, 1981 · N9915G · Substantial damage NTSB CHI81FA072Accident · 1 fatalClosedTaylorcraft F19 · Delevan, MNJul 4, 1981 · N3581T · Destroyed NTSB CHI81FA071Accident · 2 fatalClosedBellanca 7GCB · Viking, MNJul 4, 1981 · N8992R · Destroyed