Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 MKC74DER32Accident · No injuriesClosedCessna U206C · Austin, MNDec 29, 1973 · N29136 · Substantial damage NTSB MKC74DER31Accident · No injuriesClosedCessna 182 · Austin, MNDec 25, 1973 · N9043X · Substantial damage NTSB MKC74FER30Accident · No injuriesClosedBell 47G4A · St Paul, MNDec 21, 1973 · N2247W · Substantial damage NTSB MKC74FER29Accident · No injuriesClosedBrantly B2 · Rosemount, MNDec 21, 1973 · N5920X · Substantial damage NTSB MKC74DER27Accident · No injuriesClosedPiper J-3 · Aitkin, MNDec 20, 1973 · N3322N · Substantial damage NTSB MKC74DER28Accident · No injuriesClosedBeech E58 · T River Fall, MNDec 19, 1973 · N6AC · Substantial damage NTSB MKC74FER26Accident · Serious injuriesClosedPiper PA-28 · Rochester, MNDec 16, 1973 · N1549J · Destroyed NTSB MKC74FER25Accident · Minor injuriesClosedCessna 180J · Crystal, MNDec 6, 1973 · N42936 · Substantial damage NTSB MKC74DER24Accident · No injuriesClosedPiper PA-31 · Grand Marais, MNNov 21, 1973 · N7486L · Substantial damage NTSB MKC74FER22Accident · 1 fatalClosedVolmer VJ-22 · Prior Lake, MNNov 12, 1973 · N1007N · Destroyed NTSB MKC74FER19Accident · No injuriesClosedStinson 108-3 · Blaine, MNNov 8, 1973 · N4028C · Substantial damage NTSB MKC74DER21Accident · No injuriesClosedMooney M20A · Willmar, MNNov 8, 1973 · N1075B · Substantial damage NTSB MKC74DER20Accident · Minor injuriesClosedCessna 175-58 · Lake Elmo, MNOct 24, 1973 · N7099M · Substantial damage NTSB MKC74DER18Accident · No injuriesClosedCessna 170 · Anoka, MNOct 15, 1973 · N2632V · Substantial damage NTSB MKC74DTG09Accident · No injuriesClosedCessna 150H · Angus, MNOct 5, 1973 · N50989 · Substantial damage NTSB MKC74AK014Accident · 1 fatalClosedTaylorcraft BC12-D · Slayton, MNOct 2, 1973 · N96184 · Substantial damage NTSB MKC74DER17Accident · No injuriesClosedPiper J-3 · Blackduck, MNSep 30, 1973 · N88553 · Substantial damage NTSB MKC74DER16Accident · No injuriesClosedCessna 140 · Osage, MNSep 20, 1973 · N3071N · Substantial damage NTSB MKC74DER15Accident · No injuriesClosedBellanca 17-30A · Lake Elmo, MNSep 18, 1973 · N8286R · 2 aircraft · Substantial damage NTSB MKC74FER14Accident · Serious injuriesClosedCessna 120 · Ulen, MNSep 16, 1973 · N72606 · Substantial damage NTSB MKC74FER13Accident · Minor injuriesClosedBeech B23 · Clear Lake, MNSep 12, 1973 · N9123T · Substantial damage NTSB MKC74DER12Accident · No injuriesClosedPiper PA-28 · Elk River, MNSep 8, 1973 · N7254F · Substantial damage NTSB MKC74FER11Accident · No injuriesClosedCessna 150H · St Paul, MNSep 7, 1973 · N562G · Substantial damage NTSB MKC74DER09Accident · Serious injuriesClosedCessna 182A · Lake Elmo, MNSep 5, 1973 · N6332B · Substantial damage NTSB MKC74DER06Accident · Minor injuriesClosedCallair A-9 · Stephen, MNAug 20, 1973 · N8414V · Substantial damage NTSB MKC74DER43Accident · Minor injuriesClosedPiper PA-18 · Intl Falls, MNAug 18, 1973 · N5415H · Substantial damage NTSB MKC74DER05Accident · No injuriesClosedAero Comdr A-9B · Winnebago, MNAug 9, 1973 · N7757V · Substantial damage NTSB MKC74FER03Accident · No injuriesClosedCessna 310J · Owatonna, MNAug 1, 1973 · N3165L · Substantial damage NTSB MKC74DER04Accident · Serious injuriesClosedCallair A-9A · Grygla, MNJul 31, 1973 · N8261H · Destroyed NTSB MKC74AK002Accident · 2 fatalClosedCessna 172E · Lake Park, MNJul 30, 1973 · N3552S · Destroyed NTSB MKC74DER02Accident · No injuriesClosedPiper PA-28 · Eden Prairie, MNJul 20, 1973 · N8378W · Substantial damage NTSB MKC74DER01Accident · No injuriesClosedBell 47G-5 · Bloomington, MNJul 20, 1973 · N4064G · Substantial damage NTSB MKC73DER69Accident · Serious injuriesClosedBellanca 7GCBC · Grand Rapids, MNJun 20, 1973 · N8552 · Substantial damage NTSB MKC73FER68Accident · 1 fatalClosedPiper PA-18A · Beardsley, MNJun 12, 1973 · N8073D · Destroyed NTSB MKC73DER67Accident · Minor injuriesClosedWaco YKS-6 · Deer River, MNJun 9, 1973 · N16241 · Substantial damage NTSB MKC73DER70Accident · No injuriesClosedCessna 172K · Ranier, MNJun 8, 1973 · N79277 · Substantial damage NTSB MKC73DER66Accident · No injuriesClosedBell 47G-2 · Brainerd, MNJun 1, 1973 · N65520 · Substantial damage NTSB MKC73IK072Incident · No injuriesClosedConvair 580 · Minneapolis, MNMay 31, 1973 · N968N · Minor damage NTSB MKC73FER65Accident · Minor injuriesClosedPiper PA-22 · Wadena, MNMay 26, 1973 · N9999D · Substantial damage NTSB MKC73FER64Accident · Minor injuriesClosedGrumman G-164 · Elbow Lake, MNMay 26, 1973 · N985X · Substantial damage NTSB MKC73AK070Accident · 2 fatalClosedPiper PA-23 · Cloquet, MNMay 26, 1973 · N4330Y · Destroyed NTSB MKC73AK068Accident · 5 fatalClosedCessna 411 · Minneapolis, MNMay 25, 1973 · N4932T · Destroyed NTSB MKC73DER63Accident · No injuriesClosedPiper PA-28 · Lake Benton, MNMay 22, 1973 · N6302R · Substantial damage NTSB MKC73DER62Accident · No injuriesClosedCessna 150 · Hallock, MNMay 20, 1973 · N88026 · Substantial damage NTSB MKC73DER60Accident · No injuriesClosedCessna 180 · Circle Pines, MNMay 16, 1973 · N9917V · Substantial damage NTSB MKC73FER58Accident · Minor injuriesClosedCessna 140 · Grand Rapids, MNMay 14, 1973 · N2917N · Substantial damage NTSB MKC73DER59Accident · Minor injuriesClosedPiper PA-18 · Stanton, MNMay 13, 1973 · N1015A · Substantial damage NTSB MKC73DER56Accident · No injuriesClosedAero Comdr 100 · Maple Plain, MNMay 12, 1973 · N4125X · Substantial damage NTSB MKC73FER57Accident · No injuriesClosedCessna 140 · Anoka, MNMay 9, 1973 · N77095 · Substantial damage NTSB MKC73AK065Accident · 2 fatalClosedPiper PA-24 · Granger, MNMay 6, 1973 · N8114P · Destroyed