Skip to content

NTSB investigations, 1978, SD

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

19622026

NTSB investigations, 1978, SD per year, 1962–2026: 1,074 cases
1962	1
1964	40
1965	43
1966	42
1967	46
1968	39
1969	35
1970	37
1971	30
1972	27
1973	20
1974	28
1975	35
1976	21
1977	44
1978	38
1979	27
1980	24
1981	28
1982	18
1983	22
1984	22
1985	15
1986	14
1987	11
1988	11
1989	6
1990	16
1991	12
1992	9
1993	11
1994	10
1995	12
1996	11
1997	12
1998	14
1999	8
2000	12
2001	11
2002	8
2003	16
2004	10
2005	9
2006	5
2007	10
2008	9
2009	8
2010	8
2011	13
2012	15
2013	8
2014	7
2015	9
2016	8
2017	7
2018	9
2019	11
2020	7
2021	2
2022	7
2023	6
2024	5
2025	10
2026	5

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" = 'SD' 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\" = 'SD' 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" = 'SD' 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 MKC79FTK06Accident · Serious injuriesClosedChampion 7ECA · Leola, SDDec 30, 1978 · N5142T · Substantial damage NTSB MKC79FTK05Accident · No injuriesClosedCessna 150 · Parkston, SDDec 8, 1978 · N19513 · Substantial damage NTSB MKC79DTK04Accident · No injuriesClosedPiper PA-24 · Vermillion, SDDec 4, 1978 · N5585P · Substantial damage NTSB MKC79FTK03Accident · Serious injuriesClosedCessna 150M · Rapid City, SDDec 3, 1978 · N63067 · Substantial damage NTSB MKC79DTK02Accident · No injuriesClosedCessna 150 · Sorum, SDNov 30, 1978 · N60068 · Substantial damage NTSB MKC79DTK01Accident · Minor injuriesClosedCessna 150 · Piedmont, SDNov 24, 1978 · N66231 · Substantial damage NTSB MKC79FCJ03Accident · No injuriesClosedBell 47-J2 · Cactus Flats, SDSep 19, 1978 · N63090 · Substantial damage NTSB MKC78FTK40Accident · No injuriesClosedBell 47-J2 · Cactus Flats, SDSep 19, 1978 · N90547 · Substantial damage NTSB MKC78DTK39Accident · No injuriesClosedRockwell IN 112 · Parkston, SDSep 14, 1978 · N1462J · Substantial damage NTSB MKC78FTK37Accident · No injuriesClosedChampion 7ECA · Pierre, SDSep 5, 1978 · N2880G · Substantial damage NTSB MKC78DTK36Accident · Minor injuriesClosedCessna 140 · Webster, SDSep 3, 1978 · N76114 · Substantial damage NTSB MKC78FA068Accident · 2 fatalClosedLuscombe 8A · Porcupine, SDSep 1, 1978 · N2177B · Destroyed NTSB MKC78DTK35Accident · No injuriesClosedPiper PA-28 · Prairie City, SDSep 1, 1978 · N3917K · Substantial damage NTSB MKC78DTK34Accident · No injuriesClosedPiper PA-18 · Milbank, SDAug 23, 1978 · N3353A · Substantial damage NTSB MKC78FTK32Accident · Serious injuriesClosedDavis DA2A · Custer, SDAug 7, 1978 · N3489 · Substantial damage NTSB MKC78FTK31Accident · No injuriesClosedStinson 108-3 · Miller, SDAug 6, 1978 · N6854M · Substantial damage NTSB MKC78FTK30Accident · No injuriesClosedCessna 175A · Mud Butte, SDJul 30, 1978 · N6986E · Substantial damage NTSB MKC78DTK29Accident · No injuriesClosedBell 47G · Elk Point, SDJul 29, 1978 · N128B · Substantial damage NTSB MKC78FTK33Accident · No injuriesClosedCessna A188B · Doland, SDJul 28, 1978 · N731LH · Substantial damage NTSB MKC78DTK28Accident · No injuriesClosedPiper PA-25 · Menno, SDJul 27, 1978 · N4790Y · Substantial damage NTSB MKC78FTK26Accident · No injuriesClosedPiper PA-36 · Fredrick, SDJul 14, 1978 · N9910P · Substantial damage NTSB MKC78FTK25Accident · No injuriesClosedPiper PA-25 · Sisseston, SDJul 9, 1978 · N9882P · Substantial damage NTSB MKC78FTK23Accident · No injuriesClosedPiper PA-36 · Glenham, SDJun 13, 1978 · N56614 · Destroyed NTSB MKC78FTK22Accident · No injuriesClosedGrum Amer AA5 · Brookings, SDJun 11, 1978 · N9610U · Substantial damage NTSB MKC78DTK21Accident · No injuriesClosedCessna 172 · Isabel, SDJun 6, 1978 · N3730L · Substantial damage NTSB MKC78FTK20Accident · 1 fatalClosedPiper PA-18 · Naples, SDJun 5, 1978 · N2799P · Substantial damage NTSB MKC78FTK19Accident · No injuriesClosedPiper PA-36 · Murdo, SDJun 4, 1978 · N59679 · Substantial damage NTSB MKC78FTK17Accident · Serious injuriesClosedCessna 210 · Martin, SDMay 27, 1978 · N9689T · Substantial damage NTSB MKC78FTK16Accident · Serious injuriesClosedCessna 188 · Hayes, SDMay 23, 1978 · N9510G · Substantial damage NTSB MKC78FTK15Accident · Minor injuriesClosedCessna 150 · Sturgis, SDMay 12, 1978 · N6278S · Substantial damage NTSB MKC78FTK14Accident · No injuriesClosedCessna 152 · Yankton, SDMay 9, 1978 · N49924 · Substantial damage NTSB MKC78DTK13Accident · No injuriesClosedCessna 180 · Desmet, SDMar 25, 1978 · N9184C · Substantial damage NTSB MKC78FTK11Accident · No injuriesClosedPiper PA-30 · Rapid City, SDMar 20, 1978 · N8608Y · Substantial damage NTSB MKC78FTK12Accident · No injuriesClosedCessna 150 · Rapid City, SDMar 17, 1978 · N22530 · Substantial damage NTSB MKC78DTK10Accident · No injuriesClosedGrum Amer AA1-C · Edgemont, SDMar 17, 1978 · N9738U · Substantial damage NTSB MKC78FA027Accident · 1 fatalClosedPiper PA-22 · Rapid City, SDMar 12, 1978 · N9820D · Substantial damage NTSB MKC78DTK09Accident · No injuriesClosedCessna 172 · Aberdeen, SDFeb 21, 1978 · N733FS · Substantial damage NTSB MKC78DTK08Accident · No injuriesClosedPiper PA-32R · Aberdeen, SDJan 24, 1978 · N5802V · Substantial damage