Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MKC79DER16Accident · Minor injuriesClosedPiper PA-22 · Bricelyn, MNDec 26, 1978 · N7133B · Substantial damage NTSB MKC79FER15Accident · No injuriesClosedBeech F33A · Two Harbor, MNDec 24, 1978 · N9086S · Substantial damage NTSB MKC79DER14Accident · No injuriesClosedCessna 152 · St Cloud, MNDec 22, 1978 · N67338 · Substantial damage NTSB MKC79FA010Accident · Serious injuriesClosedLear Jet 25 · Minneapolis, MNDec 20, 1978 · N40SN · Destroyed NTSB MKC79DER12Accident · Minor injuriesClosedAerospatial SA315B · Hinckley, MNDec 15, 1978 · N49538 · Destroyed NTSB MKC79FER09Accident · No injuriesClosedCessna 402 · Hastings, MNDec 8, 1978 · N3600T · Substantial damage NTSB MKC79DER13Accident · No injuriesClosedCessna 152 · Grand Rapids, MNDec 8, 1978 · N757AP · Substantial damage NTSB MKC79DER17Accident · No injuriesClosedCessna 182J · Faribault, MNDec 5, 1978 · N381LA · Substantial damage NTSB MKC79DER08Accident · No injuriesClosedPiper PA-22 · Sleepy Eye, MNNov 26, 1978 · N8872D · Substantial damage NTSB MKC79DER04Accident · Minor injuriesClosedCessna 150 · Crystal, MNNov 18, 1978 · N7562U · Substantial damage NTSB MKC79FA003Accident · 1 fatalClosedCessna 310Q · Eden Prairie, MNNov 12, 1978 · N8050Q · Destroyed NTSB MKC79DER02Accident · No injuriesClosedBeech C35 · Pipestone, MNNov 2, 1978 · N5877C · Substantial damage NTSB MKC79DER03Accident · No injuriesClosedCessna 182RG · Wolverton, MNOct 21, 1978 · N3277C · Substantial damage NTSB MKC79DER11Accident · No injuriesClosedRyan PT-22 · Webster, MNOct 19, 1978 · N53148 · Substantial damage NTSB MKC78FER95Accident · Minor injuriesClosedCessna 172K · Grygla, MNSep 27, 1978 · N78368 · Substantial damage NTSB MKC78DER94Accident · Minor injuriesClosedGrumman AA-5 · Milaca, MNSep 23, 1978 · N5824L · Substantial damage NTSB MKC78DER98Accident · No injuriesClosedCessna 172 · Warren, MNSep 22, 1978 · N8976B · Substantial damage NTSB MKC78FER93Accident · No injuriesClosedGrumman AA-5A · St Paul, MNSep 20, 1978 · N9580U · Substantial damage NTSB MKC78FER96Accident · Minor injuriesClosedCessna 150 · Belle Plaine, MNSep 17, 1978 · N8241S · Destroyed NTSB MKC78DER92Accident · No injuriesClosedCessna P337H · Jacobsen, MNSep 9, 1978 · N4CZ · Substantial damage NTSB MKC78FER91Accident · Minor injuriesClosedBenson RW-B8M · Winona, MNSep 2, 1978 · N47199 · Substantial damage NTSB MKC78FER90Accident · Minor injuriesClosedCessna A188B · Clements, MNSep 2, 1978 · N70499 · Substantial damage NTSB MKC78FER97Accident · No injuriesClosedCessna 175A · White Bear Lk, MNAug 29, 1978 · N6945E · Substantial damage NTSB MKC78FA067Accident · 2 fatalClosedPiper PA-28 · St George, MNAug 26, 1978 · N43177 · Destroyed NTSB MKC78FA066Accident · 2 fatalClosedCessna 172N · Blaine, MNAug 20, 1978 · N733SD · Destroyed NTSB MKC78DER89Accident · No injuriesClosedCessna 172M · Hibbing, MNAug 20, 1978 · N9296H · Substantial damage NTSB MKC78DER88Accident · No injuriesClosedStoppelman PDQ-2 · Winsted, MNAug 19, 1978 · N83836 · Substantial damage NTSB MKC79DER86Accident · No injuriesClosedCessna 421B · Crystal, MNAug 10, 1978 · N110SW · 2 aircraft · Minor damage NTSB MKC78DA061Accident · No injuriesClosedSikorsky S-64 · Buffalo, MNAug 8, 1978 · N4036S · No damage NTSB MKC79FER85Accident · Minor injuriesClosedPiper PA-28 · Washington Cy, MNAug 7, 1978 · N461FT · Substantial damage NTSB MKC78FER84Accident · No injuriesClosedPiper PA-38 · Eden Prairie, MNAug 5, 1978 · N6291A · Substantial damage NTSB MKC78DER82Accident · No injuriesClosedCessna 172M · Rosemount, MNAug 5, 1978 · N80631 · Substantial damage NTSB MKC78DER83Accident · No injuriesClosedCessna 180B · Eveleth, MNAug 4, 1978 · N5273E · Substantial damage NTSB MKC78DER87Accident · No injuriesClosedCessna 150G · Lester Prairie, MNAug 3, 1978 · N4681X · Substantial damage NTSB MKC78FER81Accident · Serious injuriesClosedHughes 369HS · Sauk Centre, MNJul 28, 1978 · N9199F · Destroyed NTSB MKC78DER80Accident · No injuriesClosedAmer Avco AA-5B · Cook, MNJul 28, 1978 · N28335 · Substantial damage NTSB MKC78FER77Accident · No injuriesClosedCassutt 3-M · Cloquet, MNJul 25, 1978 · N71MM · Substantial damage NTSB MKC78DER78Accident · No injuriesClosedAeronca 7AC · Brandon, MNJul 25, 1978 · N81534 · Substantial damage NTSB MKC78DER76Accident · No injuriesClosedCessna 172 · Wilmar, MNJul 23, 1978 · N19951 · Substantial damage NTSB MKC79FER75Accident · Minor injuriesClosedPiper PA-22 · Jasper, MNJul 16, 1978 · N9749D · Substantial damage NTSB MKC78FER74Accident · 1 fatalClosedJ Lowers T-WIND · Fergus Falls, MNJul 14, 1978 · N195J · Destroyed NTSB MKC78DER73Accident · No injuriesClosedCessna 152 · Anoka, MNJul 14, 1978 · N757CN · Substantial damage NTSB MKC78FA055Accident · 6 fatalClosedBeech 60 · Faribault, MNJul 12, 1978 · N777HH · Substantial damage NTSB MKC78FER68Accident · Serious injuriesClosedLuscombe 8E · Webster, MNJul 9, 1978 · N1715K · Substantial damage NTSB MKC78FER67Accident · Minor injuriesClosedCessna 180J · Goodland, MNJul 8, 1978 · N9993N · Substantial damage NTSB MKC78DER71Accident · No injuriesClosedSchleicher K8B · Stanton, MNJul 8, 1978 · N221L · Substantial damage NTSB MKC78FER69Accident · No injuriesClosedCessna 172 · Ada, MNJul 6, 1978 · N12240 · Substantial damage NTSB MKC78FER70Accident · Minor injuriesClosedCessna T210L · Merrifield, MNJul 1, 1978 · N2090L · Destroyed NTSB MKC78FER66Accident · Serious injuriesClosedPiper PA-25 · Corvuso, MNJun 30, 1978 · N7334Z · Destroyed NTSB MKC78DER64Accident · No injuriesClosedBoeing A-75 · Felton, MNJun 28, 1978 · N5413N · Destroyed