Skip to content

NTSB investigations, 1964, 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, 1964, 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1181Accident · Minor injuriesClosedPiper PA17 · Strandburg, SDDec 29, 1964 · N5548H · Substantial damage NTSB UNK65X1147Accident · No injuriesClosedCessna 210 · Winner, SDDec 26, 1964 · N9456T · Substantial damage NTSB UNK65X1122Accident · 2 fatalClosedPiper PA-24 · Philip, SDDec 24, 1964 · N8489P · Destroyed NTSB UNK65X1106Accident · No injuriesClosedMaule M4 · Rosholt, SDDec 23, 1964 · N4734T · Substantial damage NTSB UNK65X1087Accident · No injuriesClosedBeechraft 35B33 · Gregory, SDDec 22, 1964 · N1548Z · Substantial damage NTSB UNK65X0836Accident · No injuriesClosedCessna 170 · Freeman, SDNov 25, 1964 · N3947V · Destroyed NTSB UNK65X0579Accident · No injuriesClosedBeechcraft 65 · Sioux Falls, SDNov 6, 1964 · N956B · Substantial damage NTSB UNK65X0275Accident · No injuriesClosedMooney M20A · Rapid City, SDOct 14, 1964 · N8108E · Substantial damage NTSB UNK64X4114Accident · No injuriesClosedChampion 7FC · Sioux Falls, SDSep 23, 1964 · N9866B · Substantial damage NTSB UNK64X4113Accident · No injuriesClosedPiper PA22 · Watertown, SDSep 23, 1964 · N2464A · Substantial damage NTSB UNK64X4049Accident · No injuriesClosedCessna 170 · Clear Lake, SDSep 19, 1964 · N2232D · Substantial damage NTSB UNK64X4018Accident · No injuriesClosedCessna 182 · Eureka, SDSep 17, 1964 · N5931B · Substantial damage NTSB UNK64X3966Accident · No injuriesClosedCessna 170 · Hot Springs, SDSep 13, 1964 · N3828V · Substantial damage NTSB UNK64X3802Accident · Serious injuriesClosedMooney M20 · Huron, SDSep 5, 1964 · N6534B · Destroyed NTSB UNK64X3790Accident · Minor injuriesClosedStits SA3B · Mobridge, SDSep 5, 1964 · N4985E · Destroyed NTSB UNK64X3708Accident · No injuriesClosedPiper PA28 · Pine Ridge, SDAug 31, 1964 · N8699W · Substantial damage NTSB UNK64X3706Accident · No injuriesClosedCessna 120 · White River, SDAug 31, 1964 · N3044N · Substantial damage NTSB UNK64X3294Accident · No injuriesClosedStinson 108-2 · Martin, SDAug 9, 1964 · N150C · Substantial damage NTSB UNK64X3286Accident · No injuriesClosedPiper PA22 · Winner, SDAug 9, 1964 · N4451A · Substantial damage NTSB UNK64X3229Accident · No injuriesClosedPiper J3C · Hot Springs, SDAug 5, 1964 · N3477N · Substantial damage NTSB UNK64X3083Accident · No injuriesClosedBeechcraft D18S · Aberdeen, SDJul 28, 1964 · N1209 · Substantial damage NTSB UNK64X3074Accident · No injuriesClosedCessna 170 · Wessington, SDJul 27, 1964 · N4073V · Substantial damage NTSB UNK64X2849Accident · No injuriesClosedBell 47G · White River, SDJul 15, 1964 · N208B · Substantial damage NTSB UNK64X2778Accident · 1 fatalClosedBellanca 14132 · Belle Fourche, SDJul 12, 1964 · N74350 · Substantial damage NTSB UNK64X2757Accident · No injuriesClosedBell 47G2 · 30 Mi Se Wall, SDJul 11, 1964 · N2820B · Substantial damage NTSB UNK64X2753Accident · No injuriesClosedCessna 182 · Chamberlain, SDJul 10, 1964 · N3698U · Substantial damage NTSB UNK64X2558Accident · 1 fatalClosedPiper PA18 · Vivian, SDJun 29, 1964 · N3396B · Destroyed NTSB UNK64X2241Accident · Minor injuriesClosedCessna 210 · Sioux Falls, SDJun 12, 1964 · N9428T · Substantial damage NTSB UNK64X2215Accident · No injuriesClosedPiper PA18 · Karinen, SDJun 10, 1964 · N4053Z · Substantial damage NTSB UNK64X1992Accident · No injuriesClosedLuscombe 8F · Sioux Falls, SDMay 28, 1964 · N9905C · Substantial damage NTSB UNK64X1969Accident · Serious injuriesClosedPiper J3 · Doland, SDMay 27, 1964 · N3602N · Destroyed NTSB UNK64X1939Accident · No injuriesClosedPiper J3 · Mansfield, SDMay 24, 1964 · N70294 · Substantial damage NTSB UNK64X1872Accident · No injuriesClosedPiper PA18 · Nisland, SDMay 21, 1964 · N6794B · Substantial damage NTSB UNK64X1508Accident · No injuriesClosedPiper PA12 · Sioux Falls, SDApr 29, 1964 · N3356N · Substantial damage NTSB UNK64X1506Accident · No injuriesClosedBeechcraft P35 · Sioux Falls, SDApr 29, 1964 · N8906M · Substantial damage NTSB UNK64X1452Accident · No injuriesClosedAeronca 7AC · Clark, SDApr 25, 1964 · N83780 · Substantial damage NTSB UNK64X1402Accident · No injuriesClosedCessna 180 · Ipswich, SDApr 21, 1964 · N6477X · Substantial damage NTSB UNK64X0816Accident · No injuriesClosedCessna 140 · Gregory, SDMar 6, 1964 · N3537V · Substantial damage NTSB UNK64X0692Accident · No injuriesClosedCessna 140 · Brookings, SDFeb 26, 1964 · CFPFV · Substantial damage NTSB UNK64X0424Accident · No injuriesClosedPiper PA28 · Bowdle, SDFeb 1, 1964 · N7500W · Substantial damage