Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MKC78DER19Accident · No injuriesClosedCessna 310Q · Rochester, MNDec 29, 1977 · N310JP · Substantial damage NTSB MKC78FER17Accident · No injuriesClosedCessna 150M · St Paul, MNDec 19, 1977 · N8747U · Substantial damage NTSB MKC78FER15Accident · No injuriesClosedCessna 172M · St.Agusta, MNDec 11, 1977 · N1224U · Substantial damage NTSB MKC78FER14Accident · No injuriesClosedCessna 172L · Minneapolis, MNDec 11, 1977 · N9828G · Substantial damage NTSB MKC78FER13Accident · Minor injuriesClosedCessna 175 · Anoka, MNDec 5, 1977 · N7117M · Substantial damage NTSB MKC78FER12Accident · Minor injuriesClosedPiper PA-30 · Ely, MNNov 25, 1977 · N8739Y · Substantial damage NTSB MKC78FER11Accident · Minor injuriesClosedGrumman AA-5 · Caledonia, MNNov 24, 1977 · N1368R · Substantial damage NTSB MKC78DER09Accident · No injuriesClosedBellanca 17-30A · Lakeville, MNNov 16, 1977 · N117L · Destroyed NTSB MKC78DER08Accident · No injuriesClosedHiller UH-12E · Bemidji, MNNov 14, 1977 · N8286 · Substantial damage NTSB MKC78FER07Accident · No injuriesClosedPiper PA-28 · Anoka, MNNov 9, 1977 · N47350 · 2 aircraft · Substantial damage NTSB MKC78FER06Accident · No injuriesClosedBeech C-24R · Camp Ripley, MNOct 26, 1977 · N18874 · Substantial damage NTSB MKC78FER04Accident · No injuriesClosedMooney M20C · Morris, MNOct 23, 1977 · N9459V · Substantial damage NTSB MKC78FER02Accident · No injuriesClosedCessna 172 · Afton, MNOct 16, 1977 · N1390U · Substantial damage NTSB MKC78DER05Accident · No injuriesClosedStinson 108-1 · Alexandria, MNOct 16, 1977 · N97834 · Substantial damage NTSB MKC78FER03Accident · No injuriesClosedCessna 310 · Eden Prairie, MNOct 12, 1977 · N8917Z · Substantial damage NTSB MKC78DER01Accident · No injuriesClosedPiper PA-18 · Belle Plaine, MNOct 3, 1977 · N57753 · Substantial damage NTSB MKC77DER86Accident · No injuriesClosedCessna 172 · Sanborn, MNSep 28, 1977 · N13338 · Substantial damage NTSB MKC79DER01Accident · No injuriesClosedCessna 170B · Hastings, MNSep 26, 1977 · N8004A · Substantial damage NTSB MKC77DER85Accident · No injuriesClosedCessna 150G · Winona, MNSep 26, 1977 · N6231S · Substantial damage NTSB MKC77DER84Accident · No injuriesClosedPiper PA-28 · Starbuck, MNSep 20, 1977 · N8671W · Substantial damage NTSB MKC77FA040Accident · 2 fatalClosedAeronca 7AC · Grand Rapids, MNSep 18, 1977 · N3702E · Substantial damage NTSB MKC77DER83Accident · No injuriesClosedPiper PA-22 · Brandon, MNSep 18, 1977 · N5907D · Substantial damage NTSB MKC77FER82Accident · No injuriesClosedBellanca 7ECA · Belle Plaine, MNSep 10, 1977 · N53745 · Substantial damage NTSB MKC77FER81Accident · No injuriesClosedPiper PA-28 · Madison, MNSep 2, 1977 · N5117W · Substantial damage NTSB MKC77FER80Accident · No injuriesClosedPiper PA-32 · Duluth, MNAug 31, 1977 · N5541J · Substantial damage NTSB MKC77FER79Accident · No injuriesClosedCessna 195 · Bloomington, MNAug 30, 1977 · N2190C · Substantial damage NTSB MKC77FA036Accident · 1 fatalClosedCessna 172M · Henning, MNAug 30, 1977 · N64190 · Destroyed NTSB MKC77FER78Accident · No injuriesClosedCessna 172 · Ostrander, MNAug 27, 1977 · N7769T · Substantial damage NTSB MKC77DER76Accident · No injuriesClosedBeech B19 · Glyndon, MNAug 12, 1977 · N6516R · Substantial damage NTSB MKC77FER75Accident · 1 fatalClosedWendt WH-1 · Lakeville, MNAug 8, 1977 · N3146 · Destroyed NTSB MKC77DER74Accident · No injuriesClosedPietenpol-A Scout · Mankato, MNAug 6, 1977 · N5987 · Substantial damage NTSB MKC77FER73Accident · No injuriesClosedGrumman G-164A · Perham, MNAug 3, 1977 · N6606 · Substantial damage NTSB MKC77FER70Accident · No injuriesClosedTayorcraft BCS-12 · Coon Lake, MNAug 1, 1977 · N94921 · Substantial damage NTSB MKC77FER72Accident · No injuriesClosedPiper PA-22 · Minneapolis, MNJul 31, 1977 · N9314D · Substantial damage NTSB MKC77FER71Accident · No injuriesClosedPiper PA-25 · Springfield, MNJul 30, 1977 · N7634Z · Substantial damage NTSB MKC77FER69Accident · No injuriesClosedRockwell S-2R · Stewartville, MNJul 29, 1977 · N75GS · Substantial damage NTSB MKC77FER68Accident · No injuriesClosedCessna A150 · Osage, MNJul 26, 1977 · N5956J · Substantial damage NTSB MKC77FER66Accident · No injuriesClosedPiper PA-22 · Thief River, MNJul 25, 1977 · N9222D · Substantial damage NTSB MKC77DER77Accident · No injuriesClosedPiper PA-18A · Battle Lake, MNJul 24, 1977 · N1190C · Substantial damage NTSB MKC77FER67Accident · No injuriesClosedBeech D18S · Bemidji, MNJul 22, 1977 · N119L · Substantial damage NTSB MKC77FER63Accident · No injuriesClosedGrumman AA-1B · Lakeville, MNJul 21, 1977 · N6298L · Substantial damage NTSB MKC77DER64Accident · No injuriesClosedCessna 150 · Staples, MNJul 19, 1977 · N10859 · Substantial damage NTSB MKC77DER62Accident · No injuriesClosedBellanca 7GCBC · Grand Lake, MNJul 17, 1977 · N68534 · Substantial damage NTSB MKC77FER61Accident · No injuriesClosedPitts S-1S · Jordan, MNJul 16, 1977 · N2997G · Substantial damage NTSB MKC77DER60Accident · No injuriesClosedCessna 180 · Grand Rapids, MNJul 15, 1977 · N7586K · Destroyed NTSB MKC77FER58Accident · No injuriesClosedBaby GRT LK S-2 · Grand Rapids, MNJul 7, 1977 · N52DS · Substantial damage NTSB MKC77FER57Accident · Minor injuriesClosedPiper PA-28 · Mazeppa, MNJul 4, 1977 · N5634U · Substantial damage NTSB MKC77DER55Accident · No injuriesClosedPiper PA-28 · Minnesota Lake, MNJul 4, 1977 · N9703W · Substantial damage NTSB MKC77FER59Accident · No injuriesClosedPiper PA-18 · Spring Grove, MNJul 3, 1977 · N83536 · Substantial damage NTSB MKC77DER54Accident · Minor injuriesClosedCessna 140 · Monticello, MNJul 1, 1977 · N1867V · Substantial damage