Skip to content

NTSB investigations, 1977, SD

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MKC78FTK07Accident · No injuriesClosedPiper PA-18 · Mission Ridge, SDDec 21, 1977 · N8302P · Substantial damage NTSB MKC78FTK06Accident · No injuriesClosedLiable Cougar · Tea, SDDec 11, 1977 · N61292 · Substantial damage NTSB MKC78FA011Accident · 1 fatalClosedBeech C33 · Canton, SDDec 1, 1977 · N9435S · Destroyed NTSB MKC78FA010Accident · 2 fatalClosedPiper PA-28 · Huron, SDNov 30, 1977 · N5288T · Destroyed NTSB MKC78FA009Accident · 1 fatalClosedCessna 182M · Hill City, SDNov 29, 1977 · N71026 · Destroyed NTSB MKC78FTK05Accident · No injuriesClosedTaylorcraft BC12D · Freeman, SDNov 16, 1977 · N44378 · Substantial damage NTSB MKC78FTK04Accident · Serious injuriesClosedCessna 205 · Wolsey, SDOct 24, 1977 · N8313Z · Substantial damage NTSB MKC78FTK02Accident · Minor injuriesClosedPiper PA-18 · Newell, SDOct 3, 1977 · N2156A · Substantial damage NTSB MKC78FTK01Accident · No injuriesClosedPiper PA-24 · Rapid City, SDOct 1, 1977 · N5175P · Substantial damage NTSB MKC77FA037Accident · 3 fatalClosedPiper PA-28 · Eagle Butte, SDSep 3, 1977 · N7731W · Destroyed NTSB MKC77FTK34Accident · No injuriesClosedCessna 150 · Buffalo, SDAug 7, 1977 · N61109 · Substantial damage NTSB MKC77DTK35Accident · No injuriesClosedPiper PA-24 · Firesteel, SDAug 3, 1977 · N5874P · Substantial damage NTSB MKC77FTK33Accident · No injuriesClosedPiper PA-36 · Kennebec, SDJul 26, 1977 · N9947P · Substantial damage NTSB MKC77FTK31Accident · Minor injuriesClosedPiper J5A · Rapid City, SDJul 13, 1977 · N38427 · Destroyed NTSB MKC77DTK32Accident · No injuriesClosedBellanca 7GCBC · Camp Crook, SDJul 12, 1977 · N5132X · Substantial damage NTSB MKC77FTK30Accident · No injuriesClosedPiper PA-28 · Plankinton, SDJul 5, 1977 · N5590W · Substantial damage NTSB MKC77DTK28Accident · Serious injuriesClosedCessna 188B · Turton, SDJun 27, 1977 · N91974 · Substantial damage NTSB MKC77DKT29Accident · No injuriesClosedCessna 172 · Camp Crook, SDJun 27, 1977 · N2763U · Substantial damage NTSB MKC77FTK27Accident · 1 fatalClosedPiper PA-20 · Onida, SDJun 17, 1977 · N1507A · Destroyed NTSB MKC77DTK26Accident · No injuriesClosedPiper PA-24 · Philip, SDJun 15, 1977 · N8916P · Substantial damage NTSB MKC77FA025CaseClosedMooney M20J · Madison, SDJun 13, 1977 NTSB MKC77DTK25Accident · No injuriesClosedStinson 108-2 · Ft Thompson, SDJun 11, 1977 · N392C · Substantial damage NTSB MKC77FTK24Accident · No injuriesClosedPiper PA-36 · Hayes, SDJun 7, 1977 · N40983 · Substantial damage NTSB MKC77FTK23Accident · Serious injuriesClosedCessna 170 · Murdo, SDJun 6, 1977 · N2573C · Substantial damage NTSB MKC77DTK22Accident · No injuriesClosedCessna 172 · Ethan, SDMay 29, 1977 · N4144F · Substantial damage NTSB MKC77DTK21Accident · No injuriesClosedPiper PA-18 · Ft Pierre, SDMay 26, 1977 · N6999V · Substantial damage NTSB MKC77FTK20Accident · Serious injuriesClosedAeronca 7GCB · Northville, SDMay 19, 1977 · N9871Y · Destroyed NTSB MKC77FTK18Accident · No injuriesClosedGrumman G-164A · Martin, SDMay 8, 1977 · N8367 · Substantial damage NTSB MKC77DTK19Accident · No injuriesClosedPiper PA-18 · Pierre, SDMay 8, 1977 · N4582A · Substantial damage NTSB MKC77FTK17Accident · No injuriesClosedPiper PA-28 · Mclaughlin, SDMay 2, 1977 · N5025W · Substantial damage NTSB MKC77FTK16Accident · Minor injuriesClosedCessna 172H · Hot Springs, SDApr 28, 1977 · N3893R · Substantial damage NTSB MKC77FA022Accident · 1 fatalClosedPiper PA-36 · Pierre, SDApr 26, 1977 · N57821 · 2 aircraft · Substantial damage NTSB MKC77FTK15Accident · No injuriesClosedCessna 195A · Sturgis, SDApr 25, 1977 · C-GXAV · Substantial damage NTSB MKC77FA021Accident · 1 fatalClosedCessna 182M · Aberdeen, SDApr 22, 1977 · N91622 · Destroyed NTSB MKC77DTK14Accident · No injuriesClosedPiper PA-18 · Redfield, SDApr 18, 1977 · N40359 · Substantial damage NTSB MKC7MFTK13Accident · No injuriesClosedBellanca 8GCBC · Lemmon, SDMar 23, 1977 · N8635V · Substantial damage NTSB MKC77PTK12Accident · Minor injuriesClosedCessna 172 · Chamberlain, SDMar 17, 1977 · N8237X · Substantial damage NTSB MKC77FTK11Accident · No injuriesClosedGrumann AA-5 · Rapid City, SDMar 13, 1977 · N74878 · Substantial damage NTSB MKC77FTK10Accident · No injuriesClosedPiper PA-18 · Hayes, SDMar 13, 1977 · N3236P · Substantial damage NTSB MKC77DTK09Accident · No injuriesClosedCessna 140 · Philip, SDMar 6, 1977 · N1962N · Substantial damage NTSB MKC77FTK07Accident · No injuriesClosedCessna 170B · Gettysburg, SDFeb 27, 1977 · N1997C · Substantial damage NTSB MKC77DTK08Accident · No injuriesClosedCessna 170A · Lemmon, SDFeb 18, 1977 · N5468C · Substantial damage NTSB MKC77FTK06Accident · Serious injuriesClosedCessna 177 · Kadoka, SDFeb 5, 1977 · N2273Y · Substantial damage NTSB MKC77FTK05Accident · No injuriesClosedCessna 150 · Holabird, SDJan 2, 1977 · N8433G · Substantial damage