Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 MKC67F0364Accident · No injuriesClosedMooney M20A · Vermillion, SDDec 26, 1966 · N6054X · Substantial damage NTSB MKC67D0347Accident · No injuriesClosedPiper PA-20 · Philip, SDDec 8, 1966 · N1510A · Substantial damage NTSB MKC67D0345Accident · No injuriesClosedPiper PA-18 · Kadoka, SDDec 4, 1966 · N9884D · Substantial damage NTSB MKC67D0314Accident · No injuriesClosedCessna 172 · Rapid City, SDNov 29, 1966 · N7004A · Substantial damage NTSB MKC67D0293Accident · No injuriesClosedPiper PA-22 · Spearfish, SDNov 16, 1966 · N4966Z · Substantial damage NTSB MKC67F0306Accident · 1 fatalClosedCessna 182 · Plankinton, SDOct 27, 1966 · N8829T · Destroyed NTSB MKC67F0237Accident · No injuriesClosedBellanca 14-19 · New Underwood, SDSep 28, 1966 · N8537R · Substantial damage NTSB MKC67A0022Accident · 5 fatalClosedAero Comdr 1121 · Nplatte, SDSep 26, 1966 · N500JR · Destroyed NTSB MKC67D0226Accident · No injuriesClosedMooney M20C · Pickstown, SDSep 24, 1966 · N6430U · Substantial damage NTSB MKC67A0026Accident · Serious injuriesClosedDouglas DC-3 · Rapid City, SDSep 23, 1966 · N4996E · No damage NTSB MKC67A0025Accident · 2 fatalClosedCessna 172E · Wakpala, SDSep 20, 1966 · N3751S · Destroyed NTSB MKC67A0023Accident · 1 fatalClosedPiper J3C-65 · Faith, SDSep 14, 1966 · N87964 · Destroyed NTSB MKC67F0179Accident · No injuriesClosedPiper PA-18 · Hermosa, SDSep 4, 1966 · N6098D · Substantial damage NTSB MKC67F0234Accident · No injuriesClosedAeronca 7AC · Tuthill, SDAug 28, 1966 · N82894 · Substantial damage NTSB MKC67F0182Accident · No injuriesClosedMooney M20A · Ellsworth Afb, SDAug 28, 1966 · N8168E · Substantial damage NTSB MKC67D0256Accident · No injuriesClosedPiper PA-22 · Ft.Thompson, SDAug 3, 1966 · N1790P · Substantial damage NTSB MKC67D0101Accident · No injuriesClosedBeech 95-B55 · Yankton, SDJul 30, 1966 · N192Q · Substantial damage NTSB MKC67D0100Accident · No injuriesClosedPiper PA-22 · Milesville, SDJul 28, 1966 · N2639P · Substantial damage NTSB MKC67F0136Accident · No injuriesClosedHelio H-250 · Hot Springs, SDJul 22, 1966 · N6318V · Substantial damage NTSB MKC67D0143Accident · No injuriesClosedPiper PA-28 · Redig, SDJul 15, 1966 · N6340R · Substantial damage NTSB MKC67F0129Accident · Serious injuriesClosedMooney M20C · Murdo, SDJul 7, 1966 · N6095Q · Destroyed NTSB MKC67F0080Accident · No injuriesClosedPiper PA-28 · Maurine, SDJul 2, 1966 · N5187W · Substantial damage NTSB MKC67F0081Accident · Serious injuriesClosedPiper J-3 · Bonilla, SDJun 14, 1966 · N98098 · Destroyed NTSB MKC67F0038Accident · Minor injuriesClosedPiper J3C · Parkston, SDJun 14, 1966 · N6318H · Destroyed NTSB MKC67D0041Accident · No injuriesClosedAeronca 15AC · Barnard, SDJun 10, 1966 · N1233H · Substantial damage NTSB MKC66F0590Accident · No injuriesClosedPiper PA-25 · Groton, SDJun 6, 1966 · N6132Z · Substantial damage NTSB MKC67F0009Accident · Minor injuriesClosedCessna 182 · Rapid City, SDMay 28, 1966 · N6381B · Substantial damage NTSB MKC66F0591Accident · No injuriesClosedCessna 172 · Pierre, SDMay 28, 1966 · N8239X · Substantial damage NTSB MKC66F0554Accident · No injuriesClosedBeech P35 · Brookings, SDMay 25, 1966 · N9773Y · Substantial damage NTSB MKC66F0551Accident · Minor injuriesClosedPiper PA-18 · Martin, SDMay 7, 1966 · N3794Z · Substantial damage NTSB MKC66F0540Accident · No injuriesClosedBeech V35 · Watertown, SDMay 2, 1966 · N9518Q · Substantial damage NTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damage NTSB MKC66D0504Accident · No injuriesClosedPiper PA-20 · Mitchell, SDMar 19, 1966 · N1591A · Substantial damage NTSB MKC66D0520Accident · No injuriesClosedEroupe 415-C · Murdo, SDMar 12, 1966 · N94330 · Substantial damage NTSB MKC66F0503Accident · Serious injuriesClosedAeronca 7AC · Alcester, SDMar 1, 1966 · N2261E · Destroyed NTSB MKC66F0443Accident · No injuriesClosedPiper J-3 · Sturgis, SDFeb 26, 1966 · N88392 · Substantial damage NTSB MKC66D0432Accident · No injuriesClosedPiper PA-18 · Summit, SDFeb 18, 1966 · N6980D · Substantial damage NTSB MKC66F0434Accident · No injuriesClosedBellanca 14-19 · Huron, SDFeb 13, 1966 · N7666B · Substantial damage NTSB MKC66D0433Accident · No injuriesClosedPiper J-3 · Bijou Hills, SDFeb 13, 1966 · N70542 · Substantial damage NTSB MKC66F0454Accident · No injuriesClosedPiper PA-28 · Sioux Falls, SDFeb 10, 1966 · N6102W · Substantial damage NTSB MKC66D0459Accident · No injuriesClosedMooney M20C · Chamberlain, SDJan 28, 1966 · N60359 · Substantial damage NTSB MKC66F0454Accident · Serious injuriesClosedPiper PA-11 · Tolstoy, SDJan 25, 1966 · N78820 · Substantial damage