Skip to content

NTSB investigations, 1976, MN

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 MKC77FER12Accident · Minor injuriesClosedCessna 172 · Morris, MNDec 30, 1976 · N7834U · Substantial damage NTSB MKC77FER13Accident · No injuriesClosedCessna 182 · Brainerd, MNDec 29, 1976 · N4GL · Substantial damage NTSB MKC77DER11Accident · No injuriesClosedCessna 150 · Austin, MNDec 24, 1976 · N50313 · Substantial damage NTSB MKC77DER10Accident · No injuriesClosedCessna 180 · White Bear Lk, MNDec 24, 1976 · N9105C · Substantial damage NTSB MKC77FER09Accident · No injuriesClosedAero Comdr 520 · St Paul, MNDec 7, 1976 · N4178B · Substantial damage NTSB MKC77DER08Accident · No injuriesClosedCessna 180H · Vergas, MNDec 5, 1976 · N91394 · Substantial damage NTSB MKC77FER07Accident · No injuriesClosedPiper PA-28R · Eden Prairie, MNNov 23, 1976 · N7487J · Substantial damage NTSB MKC77FA004Accident · 3 fatalClosedPiper PA-18 · Grand Rapids, MNNov 20, 1976 · N8415P · 2 aircraft · Destroyed NTSB MKC77DER06Accident · No injuriesClosedCessna 172 · Monticello, MNNov 11, 1976 · N20181 · Substantial damage NTSB MKC77FER05Accident · No injuriesClosedCessna 150J · Tyler, MNNov 7, 1976 · N60663 · Substantial damage NTSB MKC77FER04Accident · Minor injuriesClosedChampion 7GCB · Chaska, MNOct 24, 1976 · N8992R · Substantial damage NTSB MKC77FER03Accident · Serious injuriesClosedPiper PA-28 · Rochester, MNOct 20, 1976 · N56091 · Substantial damage NTSB MKC77FER02Accident · No injuriesClosedBellanca 17-30 · Lake Elmo, MNOct 11, 1976 · N4705V · Substantial damage NTSB MKC77DER01Accident · No injuriesClosedCessna 180 · Backus, MNOct 7, 1976 · N6559A · Substantial damage NTSB MKC76AK084Accident · 1 fatalClosedBeech P35 · Red Wing, MNSep 26, 1976 · N1584Z · Destroyed NTSB MKC76FES01Accident · No injuriesClosedCessna 421A · Intl Falls, MNSep 12, 1976 · N2235Q · Substantial damage NTSB MKC76FER98Accident · Serious injuriesClosedBellanca 17-30 · South St.Paul, MNSep 11, 1976 · N6579W · Destroyed NTSB MKC76DES02Accident · Minor injuriesClosedCessna 172 · Dodge Center, MNSep 11, 1976 · N12706 · Substantial damage NTSB MKC76DER99Accident · No injuriesClosedCessna 172 · Mahnomen, MNSep 10, 1976 · N13127 · Substantial damage NTSB MKC76FER97Accident · Serious injuriesClosedCessna 305A · Park Rapids, MNSep 7, 1976 · N33454 · Substantial damage NTSB MKC76DER96Accident · No injuriesClosedCessna 150 · Cambridge, MNSep 6, 1976 · N16078 · Substantial damage NTSB MKC76AK079Accident · 2 fatalClosedAeronca 11AC · Hastings, MNSep 5, 1976 · N3488E · Destroyed NTSB MKC76FER95Accident · No injuriesClosedErco 415-C · Lake Elmo, MNSep 4, 1976 · N3469H · Destroyed NTSB MKC76FER94Accident · No injuriesClosedCessna 195 · Mora, MNAug 29, 1976 · N4330V · Substantial damage NTSB MKC76DER93Accident · No injuriesClosedCessna 172 · Crane Lake, MNAug 27, 1976 · N13673 · Substantial damage NTSB MKC76FER92Accident · No injuriesClosedBeech B19 · Hugo, MNAug 24, 1976 · N6579R · Substantial damage NTSB MKC76FER91Accident · No injuriesClosedPiper PA-36 · Delavan, MNAug 24, 1976 · N56167 · Substantial damage NTSB MKC76FER90Accident · No injuriesClosedWeatherly 201C · Hollandale, MNAug 22, 1976 · N1244W · Substantial damage NTSB MKC76FER89Accident · No injuriesClosedAmerican AA1-A · Pine City, MNAug 14, 1976 · N9368L · Substantial damage NTSB MKC76DER87Accident · Minor injuriesClosedGrum Amer AA-1B · Isanti, MNAug 11, 1976 · N9626L · Substantial damage NTSB MKC76FER88Accident · No injuriesClosedPiper PA-24 · Lake Elmo, MNAug 6, 1976 · N9158P · Substantial damage NTSB MKC76FER86Accident · Minor injuriesClosedPiper PA-22 · St Cloud, MNAug 6, 1976 · N2823P · Substantial damage NTSB MKC76DER84Accident · No injuriesClosedGrum Amer AA1-B · Red Wing, MNAug 1, 1976 · N6522L · Substantial damage NTSB MKC76FER85Accident · No injuriesClosedChampion 7ECA · Westbrook, MNJul 30, 1976 · N2593F · Substantial damage NTSB MKC76FER83Accident · Minor injuriesClosedCessna 177 · Minnetonka, MNJul 27, 1976 · N3419T · Substantial damage NTSB MKC76DER82Accident · No injuriesClosedCessna 150J · Anoka, MNJul 25, 1976 · N60030 · Substantial damage NTSB MKC76DER81Accident · No injuriesClosedAeronca 7EC · Olivia, MNJul 19, 1976 · N7592B · Substantial damage NTSB MKC76DER80Accident · No injuriesClosedCessna T210L · Pipestone, MNJul 14, 1976 · N29134 · Substantial damage NTSB MKC76DER79Accident · No injuriesClosedCessna A188B · Angus, MNJul 10, 1976 · N4779Q · Substantial damage NTSB MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MKC76DER76Accident · No injuriesClosedStarduster 2 · Eveleth, MNJul 7, 1976 · N6099 · Substantial damage NTSB MKC76AK065Accident · 1 fatalClosedCessna 150 · Thief Rv Falls, MNJul 7, 1976 · N1728Q · Destroyed NTSB MKC76DER77Accident · Minor injuriesClosedEnstron F-28 · Ortonville, MNJul 4, 1976 · N625H · Substantial damage NTSB MKC76DER75Accident · No injuriesClosedPiper PA-28R · Sauk Centre, MNJul 3, 1976 · N8405C · Substantial damage NTSB MKC76FER74Accident · No injuriesClosedVolmer VJ-22 · Fairmont, MNJul 1, 1976 · N4600 · Substantial damage NTSB MKC76DER73Accident · No injuriesClosedCessna 188 · Clearbrook, MNJun 30, 1976 · N9370R · Substantial damage NTSB CHI76FER72Accident · No injuriesClosedCessna 185 · Warroad, MNJun 22, 1976 · N2678S · Substantial damage NTSB MKC76AK062Accident · 2 fatalClosedPiper PA-18 · Rockville, MNJun 20, 1976 · N7393D · Destroyed NTSB MKC76DER71Accident · No injuriesClosedPiper PA-25 · Herman, MNJun 14, 1976 · N4444Y · Destroyed NTSB MKC76AK063Accident · Serious injuriesClosedBoeing 727 · Minneapolis, MNJun 12, 1976 · N2820W · No damage