Skip to content

NTSB investigations, 1974, MN

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1974, MN per year, 1964–2026: 3,234 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	14

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") = 1974 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\") = 1974
    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") = 1974
  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 MKC75FER34Accident · No injuriesClosedBeech V35 · St Paul, MNDec 20, 1974 · N2798T · Substantial damage NTSB MKC75IK032Incident · No injuriesClosedDouglas DC-9 · Minneapolis, MNDec 19, 1974 · N8910E · Minor damage NTSB MKC75FER35Accident · No injuriesClosedBeech 35 · Mankato, MNDec 16, 1974 · N2790V · Substantial damage NTSB MKC75FER33Accident · No injuriesClosedPiper PA-28R · Eden Prairie, MNDec 5, 1974 · N55610 · Substantial damage NTSB MKC75DER32Accident · No injuriesClosedPiper PA-22 · Marshall, MNDec 2, 1974 · N7222D · Substantial damage NTSB MKC75FER31Accident · No injuriesClosedPiper PA-20 · Cloquet, MNDec 1, 1974 · N690K · Substantial damage NTSB MKC75FER30Accident · No injuriesClosedCessna 150L · Green Isle, MNNov 17, 1974 · N569GS · Substantial damage NTSB MKC75FER28Accident · No injuriesClosedBeech 95-55 · Minneapolis, MNNov 7, 1974 · N1233Z · Substantial damage NTSB MKC75DER29Accident · No injuriesClosedAero Comdr 100 · Milan, MNOct 27, 1974 · N5553M · Substantial damage NTSB MKC75DER27Accident · No injuriesClosedAmer Avco AA1-B · Northome, MNOct 27, 1974 · N9606L · Substantial damage NTSB MKC75AK024Accident · 3 fatalClosedBell 47G-5 · Moorhead, MNOct 15, 1974 · N4064G · Destroyed NTSB MKC75FER25Accident · 1 fatalClosedRand KR-1 · Baudette, MNSep 28, 1974 · N8443 · Destroyed NTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNSep 24, 1974 · N14223 · Substantial damage NTSB MKC75DER23Accident · No injuriesClosedPiper PA-24 · Fairmont, MNSep 19, 1974 · N11CG · Substantial damage NTSB MKC75AK020Accident · 1 fatalClosedMaule M4-220 · Grand Marias, MNSep 12, 1974 · N40648 · Substantial damage NTSB MKC75AK019Accident · 6 fatalClosedPiper PA-23 · Austin, MNSep 11, 1974 · N6168Y · Destroyed NTSB MKC75DER22Accident · No injuriesClosedAeronca 7CCM · Alexandria, MNSep 3, 1974 · N4642E · Substantial damage NTSB MKC74DER20Accident · No injuriesClosedPiper PA-24 · S St Paul, MNSep 1, 1974 · N6146P · Substantial damage NTSB MKC75DER19Accident · No injuriesClosedCessna 206 · Ely, MNAug 29, 1974 · N9658G · Substantial damage NTSB MKC75DER21Accident · No injuriesClosedLuscombe 8A · Fergus Falls, MNAug 28, 1974 · N71620 · Substantial damage NTSB MKC75DER18Accident · No injuriesClosedPiper PA-12 · Olivia, MNAug 28, 1974 · N7680H · Substantial damage NTSB MKC74AK017Accident · 1 fatalClosedPiper PA-24 · La Crescent, MNAug 21, 1974 · N6371P · Destroyed NTSB MKC75FER16Accident · Serious injuriesClosedZimmerman S-1C · Waseca, MNAug 18, 1974 · N5191 · Substantial damage NTSB MKC75DER17Accident · No injuriesClosedAeronca 15AC · Forest Lake, MNAug 17, 1974 · N1203H · 2 aircraft · Substantial damage NTSB MKC75DER15Accident · No injuriesClosedPiper PA-30 · Glenwood, MNAug 14, 1974 · N7810Y · Substantial damage NTSB MKC75DER26Accident · No injuriesClosedPiper PA-24 · Faribault, MNAug 12, 1974 · N6900P · Substantial damage NTSB MKC75FER13Accident · Serious injuriesClosedPiper PA-22 · Lake Wilson, MNAug 11, 1974 · N1769A · Substantial damage NTSB MKC75AK012Accident · 8 fatalClosedPiper PA-23 · Fergus Falls, MNAug 10, 1974 · N5278Y · Destroyed NTSB MKC75FER14Accident · No injuriesClosedCessna 411 · Baudette, MNAug 9, 1974 · N173U · Substantial damage NTSB MKC75AK011Accident · 6 fatalClosedPiper PA-30 · Jackson, MNAug 9, 1974 · N8129Y · Destroyed NTSB MKC75AK018Accident · Minor injuriesClosedMooney M20C · Stewartville, MNAug 6, 1974 · N3911N · Substantial damage NTSB MKC75DER12Accident · No injuriesClosedBell 47G-2 · Meridan, MNAug 5, 1974 · N2870B · Substantial damage NTSB MKC75DER10Accident · No injuriesClosedPiper PA-28 · Farmington, MNAug 4, 1974 · N491FT · Substantial damage NTSB MKC75DER11Accident · No injuriesClosedCessna 310J · Austin, MNAug 2, 1974 · N3199L · Substantial damage NTSB MKC75FTG09Accident · No injuriesClosedCessna 210D · Wahpeton, MNJul 31, 1974 · N3858Y · Substantial damage NTSB MKC75FER07Accident · No injuriesClosedCessna 150 · Blaine, MNJul 31, 1974 · N5903G · Substantial damage NTSB MKC75DER09Accident · No injuriesClosedCessna 150L · Crystal, MNJul 31, 1974 · N568GS · Substantial damage NTSB MKC75FER08Accident · No injuriesClosedBeech 65 · Minneapolis, MNJul 30, 1974 · N1090K · Substantial damage NTSB MKC75AK009Accident · Minor injuriesClosedCessna 182N · Sartell, MNJul 30, 1974 · N9263G · Substantial damage NTSB MKC75DER06Accident · No injuriesClosedPiper PA-25 · Moorhead, MNJul 27, 1974 · N8600L · Substantial damage NTSB MKC75DER05Accident · No injuriesClosedMooney M20C · Winona, MNJul 26, 1974 · N3411X · Substantial damage NTSB MKC75DER04Accident · Minor injuriesClosedAeronca 11AC · Glenwood, MNJul 22, 1974 · N1028H · Substantial damage NTSB MKC75DER03Accident · Minor injuriesClosedCessna 140 · Albert Lea, MNJul 15, 1974 · N2314V · Substantial damage NTSB MKC75FER02Accident · No injuriesClosedLuscombe 11A · Anoka, MNJul 14, 1974 · N1634B · Substantial damage NTSB MKC75FER01Accident · No injuriesClosedPiper PA-24 · Rockford, MNJul 4, 1974 · N9137P · Substantial damage NTSB MKC74FER65Accident · No injuriesClosedAeronca 7EC · Silver Bay, MNJun 29, 1974 · N2139E · Substantial damage NTSB MKC74FER63Accident · No injuriesClosedMooney M20C · Crystal, MNJun 29, 1974 · N6898U · Substantial damage NTSB MKC74DER64Accident · No injuriesClosedBeech A36 · Warroad, MNJun 28, 1974 · N1715A · Substantial damage NTSB MKC74DER62Accident · No injuriesClosedBeech N35 · Trimont, MNJun 25, 1974 · N1289Z · Substantial damage NTSB MKC74FER59Accident · Serious injuriesClosedCallair A-9 · Stephen, MNJun 20, 1974 · N7238V · Substantial damage