Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 MKC76DER44Accident · Minor injuriesClosedPiper PA-28 · Windom, MNDec 29, 1975 · N471XT · Substantial damage NTSB MKC76AK034Accident · 1 fatalClosedCessna 337B · St Paul, MNDec 24, 1975 · N2393S · Substantial damage NTSB MKC76AK032Accident · No injuriesClosedCessna A185F · Oak Island, MNDec 22, 1975 · N2678S · Substantial damage NTSB MKC76DER43Accident · No injuriesClosedCessna 421B · Grand Rapids, MNDec 19, 1975 · N421B · Substantial damage NTSB MKC76FER41Accident · No injuriesClosedBeech 35J · Rochester, MNNov 22, 1975 · N8397D · Substantial damage NTSB MKC76DER42Accident · No injuriesClosedCessna 180 · Bemidji, MNNov 20, 1975 · N9161C · Substantial damage NTSB MKC76DER40Accident · Minor injuriesClosedPiper PA-22 · Browerville, MNNov 18, 1975 · N2450A · Substantial damage NTSB MKC76FER39Accident · Serious injuriesClosedBeech A65 · Hibbing, MNNov 16, 1975 · N9537Q · Destroyed NTSB MKC76FER38Accident · Serious injuriesClosedCessna 150G · Intl Falls, MNNov 13, 1975 · N3314J · Substantial damage NTSB MKC76DER37Accident · No injuriesClosedCessna 210G · St Cloud, MNNov 9, 1975 · N6881R · Substantial damage NTSB MKC76DER36Accident · No injuriesClosedWaco YKS7 · Duluth, MNNov 1, 1975 · N17465 · Substantial damage NTSB MKC76FER35Accident · Minor injuriesClosedCessna 150B · South St Paul, MNOct 31, 1975 · N7329X · Substantial damage NTSB MKC76DER34Accident · No injuriesClosedPiper J-3 · Caledonia, MNOct 9, 1975 · N41112 · Substantial damage NTSB MKC76DER33Accident · No injuriesClosedCessna 140 · Blaine, MNOct 6, 1975 · N89884 · Substantial damage NTSB MKC76DER30Accident · No injuriesClosedPiper PA-28 · Marshall, MNOct 3, 1975 · N6302R · Substantial damage NTSB MKC76AK021Accident · 2 fatalClosedBellanca 7GC · Garrison, MNSep 28, 1975 · N8971R · Destroyed NTSB MKC76FER31Accident · Minor injuriesClosedLuscombe 8A · Lesuer, MNSep 26, 1975 · N45916 · Destroyed NTSB MKC76DER29Accident · No injuriesClosedSikorsky S-55B · Eden Prairie, MNSep 26, 1975 · N17376 · Substantial damage NTSB MKC76DER32Accident · No injuriesClosedPiper PA-28 · Nevis, MNSep 24, 1975 · N6425R · Substantial damage NTSB MKC76FER28Accident · No injuriesClosedVolmer VJ-22 · Minneapolis, MNSep 22, 1975 · N5918 · Substantial damage NTSB MKC76DER27Accident · No injuriesClosedPiper J4 · Two Harbors, MNSep 22, 1975 · N32695 · Substantial damage NTSB MKC76DER26Accident · No injuriesClosedGrum Amer AA5 · Pierz, MNSep 21, 1975 · N6033L · Destroyed NTSB MKC76FER25Accident · Serious injuriesClosedRyan ST3KR · Alexandria, MNSep 13, 1975 · N54428 · Substantial damage NTSB MKC76AER24Accident · No injuriesClosedCessna 170A · Carlos, MNSep 6, 1975 · N5772C · Substantial damage NTSB MKC76FER23Accident · No injuriesClosedBeech H35 · Blaine, MNSep 2, 1975 · N350B · Substantial damage NTSB MKC7LAK016Accident · 3 fatalClosedMooney M20F · Fairmont, MNAug 31, 1975 · N7187V · Destroyed NTSB MKC76AK015Accident · 3 fatalClosedCessna 170 · Mahtowa, MNAug 29, 1975 · N69TT · Destroyed NTSB MKC76FER22Accident · No injuriesClosedPiper PA-28 · Staples, MNAug 25, 1975 · N15359 · Substantial damage NTSB MKC76FER20Accident · Serious injuriesClosedPiper PA-25 · Hutchinson, MNAug 15, 1975 · N6439Z · Substantial damage NTSB MKC76FER21Accident · Minor injuriesClosedPiper PA-23 · Aitkin, MNAug 10, 1975 · N4325P · Destroyed NTSB MKC76FER19Accident · Serious injuriesClosedTemco GC-1B · Lake Elmo, MNAug 10, 1975 · N2446B · Substantial damage NTSB MKC7LFER18Accident · No injuriesClosedCessna 421B · Grand Rapids, MNAug 8, 1975 · N69860 · Substantial damage NTSB MKC76FER17Accident · No injuriesClosedCessna 172D · Eden Prairie, MNAug 7, 1975 · N2656U · Substantial damage NTSB MKC76FER14Accident · Minor injuriesClosedCessna 150M · Eden Prairie, MNAug 4, 1975 · N45332 · Destroyed NTSB MKC76DER15Accident · No injuriesClosedAeronca 7AC · St George, MNAug 3, 1975 · N85705 · Substantial damage NTSB MKC76DER16Accident · No injuriesClosedCessna 170B · Clear Lake, MNAug 2, 1975 · N1636D · Substantial damage NTSB MKC7LFER13Accident · No injuriesClosedBeech 35 · Anoka, MNJul 30, 1975 · N463B · Substantial damage NTSB MKC76IK011Incident · Minor injuriesClosedPiper PA-24 · Houston, MNJul 28, 1975 · N7179P · Minor damage NTSB MKC76DER12Accident · No injuriesClosedBrantley B-2 · Mankato, MNJul 25, 1975 · N5988X · Substantial damage NTSB MKC76FER11Accident · Serious injuriesClosedCessna 188 · Maynard, MNJul 23, 1975 · N9225R · Substantial damage NTSB MKC76DER10Accident · No injuriesClosedBeech A23 · Pine City, MNJul 19, 1975 · N2386Z · Substantial damage NTSB MKC76AK009Accident · 1 fatalClosedCessna U206 · Wht Bear Lake, MNJul 19, 1975 · N9577G · Substantial damage NTSB MKC76FER09Accident · No injuriesClosedPiper PA-25 · Olivia, MNJul 18, 1975 · N7630Z · Substantial damage NTSB MKC76DER08Accident · No injuriesClosedCessna 170 · Preston, MNJul 14, 1975 · N3907V · Substantial damage NTSB MKC76FER05Accident · No injuriesClosedBeech 23 · Alexandria, MNJul 8, 1975 · N2319Q · Substantial damage NTSB MKC76F0R04Accident · No injuriesClosedCessna 305A · Elysian, MNJul 7, 1975 · N5209G · Substantial damage NTSB MKC76DER06Accident · No injuriesClosedLuscombe 8A · St Croix, MNJul 6, 1975 · N1279K · Substantial damage NTSB MKC76FER02Accident · Serious injuriesClosedAeronca O-58B · Jordon, MNJul 4, 1975 · N47336 · Substantial damage NTSB MKC76DER07Accident · No injuriesClosedVolmer V-322 · White Bear Lke, MNJul 3, 1975 · N5133 · Substantial damage NTSB MKC76DER01Accident · No injuriesClosedCessna 150 · Anoka, MNJul 1, 1975 · N6337G · Substantial damage