Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MKC80DER16Accident · Minor injuriesClosedBellanca 7ECA · Paynesville, MNDec 27, 1979 · N3086H · Destroyed NTSB MKC80DER15Accident · No injuriesClosedAeronca 11AC · Sacred Heart, MNDec 6, 1979 · N86113 · Substantial damage NTSB MKC80DER14Accident · No injuriesClosedCessna 152 · Jackson, MNDec 4, 1979 · N24374 · Substantial damage NTSB MKC80DER13Accident · No injuriesClosedBellanca 7ECA · St James, MNNov 25, 1979 · N41689 · Substantial damage NTSB MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB MKC80DER11Accident · No injuriesClosedPiper PA-22 · Middle River, MNNov 20, 1979 · N5035Z · Substantial damage NTSB MKC80DER10Accident · No injuriesClosedCessna 421A · Crystal, MNNov 9, 1979 · N4025L · Substantial damage NTSB MKC80DER09Accident · No injuriesClosedCessna 340A · Grand Rapids, MNNov 7, 1979 · N1389G · Substantial damage NTSB MKC80IA003Incident · No injuriesClosedConvair 580 · Thief Riv Fls, MNOct 31, 1979 · N4822C · Minor damage NTSB MKC80DER08Accident · Minor injuriesClosedAeronca 7AC · Alexandria, MNOct 28, 1979 · N85121 · Substantial damage NTSB MKC80DER07Accident · No injuriesClosedCessna 182 · Taopi, MNOct 28, 1979 · N1824A · Substantial damage NTSB MKC80IA001Incident · No injuriesClosedBeech 99 · Minneapolis, MNOct 24, 1979 · N652EX · Minor damage NTSB MKC80DER06Accident · No injuriesClosedPiper PA-23 · Cold Springs, MNOct 23, 1979 · N62818 · Substantial damage NTSB MKC80FER04Accident · No injuriesClosedCessna 177 · Wheaton, MNOct 19, 1979 · N29486 · Substantial damage NTSB MKC80DER02Accident · No injuriesClosedPiper PA-28 · Eveleth, MNOct 14, 1979 · N6616W · Substantial damage NTSB MKC80DER01Accident · No injuriesClosedPiper PA-32 · Aitkin, MNOct 13, 1979 · N36815 · Substantial damage NTSB MKC79FER73Accident · No injuriesClosedCessna 140 · Thief Riv Fls, MNSep 24, 1979 · N3073N · Substantial damage NTSB MKC79DER74Accident · Minor injuriesClosedPietenpol Aircmp · Minneapolis, MNSep 21, 1979 · N25157 · Substantial damage NTSB MKC79FA055Accident · 2 fatalClosedCessna 172XP · Intl Falls, MNSep 16, 1979 · N736QH · Destroyed NTSB MKC79FER72Accident · No injuriesClosedCessna 150J · Monticello, MNSep 8, 1979 · N60321 · Substantial damage NTSB MKC79FER71Accident · Serious injuriesClosedAeronca 11AC · Lake Park, MNSep 5, 1979 · N85964 · Substantial damage NTSB MKC79DER70Accident · No injuriesClosedBell 47G-2 · St.Peter, MNSep 2, 1979 · N59H · Substantial damage NTSB MKC79DER66Accident · No injuriesClosedPiper PA-25 · Walker, MNAug 25, 1979 · N9732P · Substantial damage NTSB MKC79DER69Accident · No injuriesClosedPiper PA-32 · Minneapolis, MNAug 18, 1979 · N3641W · Substantial damage NTSB MKC80DER05Accident · No injuriesClosedGrumman G-164 · Campbell, MNAug 15, 1979 · N10214 · Substantial damage NTSB MKC79FA047Accident · 1 fatalClosedCessna 195 · Ely, MNAug 14, 1979 · N9320A · Substantial damage NTSB MKC80DER68Accident · No injuriesClosedCessna T182RG · Winsted, MNAug 11, 1979 · N737PS · Substantial damage NTSB MKC79FER62Accident · Serious injuriesClosedBoeing A75 · Austin, MNAug 11, 1979 · N62559 · Destroyed NTSB MKC79DER61Accident · No injuriesClosedBellanca 8GCBC · Federal Dam, MNAug 5, 1979 · N7695S · Substantial damage NTSB MKC79DER60Accident · No injuriesClosedPiper PA-32 · Wheaton, MNAug 3, 1979 · N9636C · Substantial damage NTSB MKC80DER65Accident · No injuriesClosedGrumman G-164A · Red Lake Falls, MNAug 2, 1979 · N8768H · Substantial damage NTSB MKC79DER58Accident · Minor injuriesClosedPiper PA-25 · Warroad, MNJul 29, 1979 · N7298Z · Substantial damage NTSB MKC79DER59Accident · No injuriesClosedCessna 152 · Brainerd, MNJul 28, 1979 · N757ZV · Substantial damage NTSB MKC79DER57Accident · Minor injuriesClosedCessna 188T · Belview, MNJul 24, 1979 · N2070J · Substantial damage NTSB MKC79DER56Accident · Minor injuriesClosedBellanca 7GCAA · Mankato, MNJul 21, 1979 · N9186L · Substantial damage NTSB MKC79DER55Accident · No injuriesClosedPiper PA-25 · Roseau, MNJul 17, 1979 · N9750P · Substantial damage NTSB MKC79DER54Accident · No injuriesClosedCessna 150 · St Cloud, MNJul 17, 1979 · N714MP · Substantial damage NTSB MKC79FA040Accident · 1 fatalClosedCessna 177 · Le Sueur, MNJul 13, 1979 · N3162T · Destroyed NTSB MKC79FER53Accident · No injuriesClosedPiper PA-31T · Eveleth, MNJul 12, 1979 · N6192A · Substantial damage NTSB MKC79FER52Accident · Serious injuriesClosedPiper PA-38 · St.Paul, MNJul 7, 1979 · N4324E · Destroyed NTSB MKC79FA038Accident · 2 fatalClosedAeronca 7AC · Eveleth, MNJul 4, 1979 · N84906 · Destroyed NTSB MKC79FER63Accident · No injuriesClosedHughes 269C · Willmar, MNJul 2, 1979 · N7448F · Substantial damage NTSB MKC79FER51Accident · Serious injuriesClosedCessna A188B · Donaldson, MNJun 28, 1979 · N8239G · Substantial damage NTSB MKC79FER50Accident · No injuriesClosedPiper PA-25 · Hutchinson, MNJun 27, 1979 · N7634 · Substantial damage NTSB MKC79FA036Accident · 1 fatalClosedGrumman AA-1B · Clearwater, MNJun 17, 1979 · N1459R · Destroyed NTSB MKC79DER49Accident · No injuriesClosedScorpion II · St.Paul, MNJun 11, 1979 · N711RJ · Substantial damage NTSB MKC79FER48Accident · Minor injuriesClosedCessna 177 · Longville, MNJun 10, 1979 · N34471 · Substantial damage NTSB MKC79FER47Accident · No injuriesClosedCessna 185 · Eden Prairie, MNJun 9, 1979 · N4328R · Substantial damage NTSB MKC79DER46Accident · Minor injuriesClosedCessna 175 · Fosston, MNJun 8, 1979 · N26LM · Substantial damage NTSB MKC79DER45Accident · No injuriesClosedLuscombe 8A · Rush City, MNJun 3, 1979 · N45813 · Destroyed