Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MKC69D0299Accident · No injuriesClosedCessna 150F · Spearfish, SDDec 21, 1968 · N6418F · Substantial damage NTSB MKC69D0320Accident · No injuriesClosedPiper J3C-65 · Ferney, SDDec 14, 1968 · N3242N · Substantial damage NTSB MKC69F0289Accident · Minor injuriesClosedPiper PA-28 · Spearfish, SDDec 9, 1968 · N7164W · Substantial damage NTSB MKC69D0275Accident · No injuriesClosedCessna 210 · Watertown, SDDec 4, 1968 · N9684X · Substantial damage NTSB MKC69A0033Accident · 2 fatalClosedCessna 175B · Custer, SDNov 19, 1968 · N8290T · Destroyed NTSB MKC69F0263Accident · Minor injuriesClosedCessna 150F · Mobridge, SDOct 31, 1968 · N8225S · Substantial damage NTSB MKC69F0264Accident · Serious injuriesClosedCessna 310 · Faith, SDOct 12, 1968 · N5347A · Substantial damage NTSB MKC69D0322Accident · No injuriesClosedBeech T-34 · Belle Frche, SDOct 11, 1968 · N34291 · Substantial damage NTSB MKC69A0020Accident · 4 fatalClosedBeech N35 · Hetland, SDOct 8, 1968 · N957T · Destroyed NTSB MKC69A0017Accident · 2 fatalClosedLuscombe 8F · Dell Rapids, SDSep 30, 1968 · N1496B · Destroyed NTSB MKC69F0174Accident · Minor injuriesClosedBell 47G3B1 · Custer, SDAug 18, 1968 · N6214N · Destroyed NTSB MKC69F0099Accident · No injuriesClosedPiper PA-24 · Madison, SDAug 13, 1968 · N8317P · Substantial damage NTSB MKC69F0131Accident · Minor injuriesClosedLuscombe 8E · Wagner, SDAug 12, 1968 · N2745K · Substantial damage NTSB MKC69F0129Accident · No injuriesClosedBell 47G-2 · Keystone, SDAug 7, 1968 · N5163B · Substantial damage NTSB MKC69F0086Accident · Minor injuriesClosedBell 47G-2 · Interior, SDAug 1, 1968 · N2813B · Substantial damage NTSB MKC69D0064Accident · No injuriesClosedMooney M20D · Chamberlain, SDJul 28, 1968 · N1972Y · Substantial damage NTSB MKC69F0041Accident · No injuriesClosedPiper PA-22 · Madison, SDJul 7, 1968 · N3846P · Substantial damage NTSB MKC68A0073Accident · No injuriesClosedConvair 580 · Sioux Falls, SDJun 24, 1968 · N4824C · Substantial damage NTSB MKC69D0036Accident · Minor injuriesClosedPiper PA-22 · Lemmon, SDJun 16, 1968 · N1489C · Substantial damage NTSB MKC69F0044Accident · No injuriesClosedCessna 150 · Hot Springs, SDJun 13, 1968 · N22053 · Substantial damage NTSB MKC69F0033Accident · No injuriesClosedPiper PA-18 · Manchester, SDJun 3, 1968 · N3692P · Destroyed NTSB MKC69D0034Accident · No injuriesClosedPiper PA-25 · Platte, SDMay 29, 1968 · N6568Z · Substantial damage NTSB MKC69D0014Accident · No injuriesClosedCessna 172 · Grenville, SDMay 25, 1968 · N7606X · Substantial damage NTSB MKC69F0035Accident · Minor injuriesClosedAero Comdr 100 · Glad Valley, SDMay 18, 1968 · N4150X · Substantial damage NTSB MKC68F0545Accident · No injuriesClosedPiper J3L-65 · Northville, SDMay 14, 1968 · N24686 · Substantial damage NTSB MKC68F0575Accident · Serious injuriesClosedAeronca 11CC · Reliance, SDMay 11, 1968 · N4512E · Substantial damage NTSB MKC68D0576Accident · No injuriesClosedCessna 182 · Mitchell, SDMay 10, 1968 · N461VY · Substantial damage NTSB MKC68F0527Accident · No injuriesClosedBeech 95-A55 · Sioux Falls, SDApr 11, 1968 · N717T · Substantial damage NTSB MKC68D0513Accident · No injuriesClosedAeronca 15AC · Pierre, SDApr 10, 1968 · N1127H · Substantial damage NTSB MKC68A0058Accident · 1 fatalClosedMooney M20C · Wessgtn Spg, SDApr 4, 1968 · N3437X · Destroyed NTSB MKC68F0491Accident · No injuriesClosedCessna 150G · Rapid City, SDMar 30, 1968 · N3613J · Substantial damage NTSB MKC68A0056Accident · 9 fatalClosedBeech E18S · Rapid City, SDMar 17, 1968 · N3400 · Destroyed NTSB NYC68F0462Accident · Minor injuriesClosedPiper PA-15 · Rapid City, SDMar 3, 1968 · N4481H · Substantial damage NTSB MKC68D0498Accident · No injuriesClosedAeronca 11AC · Pollock, SDFeb 29, 1968 · N9779E · Substantial damage NTSB MKC68F0446Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDFeb 1, 1968 · N6968P · Substantial damage NTSB MKC68D0434Accident · No injuriesClosedCessna 170 · Harding, SDJan 18, 1968 · N8057A · Substantial damage NTSB MKC68F0423Accident · No injuriesClosedBeech V-35 · Dell Rapids, SDJan 17, 1968 · N7895L · Substantial damage NTSB MKC68A0046Accident · 2 fatalClosedPiper J-3 · Viborg, SDJan 14, 1968 · N42979 · Destroyed NTSB MKC68A0043Accident · 2 fatalClosedCessna 150E · Hermosa, SDJan 6, 1968 · N4099U · Destroyed