Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDDec 22, 1965 · N7880V · Destroyed NTSB MKC66F0372Accident · No injuriesClosedCessna 150 · Springfield, SDDec 4, 1965 · N8225S · Substantial damage NTSB MKC66F0355Accident · No injuriesClosedMooney M20A · Rapid City, SDNov 23, 1965 · N1045B · Substantial damage NTSB MKC66A0031Accident · 2 fatalClosedCessna 150 · Mitchell, SDNov 7, 1965 · N7956E · Destroyed NTSB MKC66D0327Accident · No injuriesClosedCessna 170B · Pierre, SDOct 24, 1965 · N2484D · Substantial damage NTSB MKC66A0027Accident · 5 fatalClosedCessna 310C · Highmore S, SDOct 18, 1965 · N1802H · Destroyed NTSB MKC66F0270Accident · No injuriesClosedPiper PA-24 · Wagner, SDOct 16, 1965 · N7440P · Substantial damage NTSB MKC66F0297Accident · No injuriesClosedMooney M20B · Mission, SDOct 15, 1965 · N74747 · Substantial damage NTSB MKC66D0387Accident · No injuriesClosedPiper PA-28 · Sioux Falls, SDOct 15, 1965 · N8963W · Substantial damage NTSB MKC66F0260Accident · No injuriesClosedMooney M21 · Mitchell, SDSep 14, 1965 · N5544Q · Substantial damage NTSB MKC66D0225Accident · No injuriesClosedStinson 108-2 · Huron, SDSep 1, 1965 · N9532K · Substantial damage NTSB MKC66D0198Accident · No injuriesClosedCessna 172 · Kaylor, SDAug 22, 1965 · N7499X · Substantial damage NTSB MKC66F0176Accident · Minor injuriesClosedCessna 170B · Skyranch, SDAug 14, 1965 · N3405C · Substantial damage NTSB MKC66D0265Accident · No injuriesClosedMooney M20C · Iona, SDAug 11, 1965 · N79334 · Substantial damage NTSB MKC66D0234Accident · Serious injuriesClosedCessna 172D · Lak Preston, SDAug 11, 1965 · N8585X · Substantial damage NTSB MKC66D0272Accident · No injuriesClosedLuscombe 8A · Wessingtn Sps, SDAug 9, 1965 · N71922 · Substantial damage NTSB MKC66F0151Accident · Serious injuriesClosedPiper J3C · Pukwana, SDAug 5, 1965 · N88647 · Destroyed NTSB MKC66F0150Accident · Minor injuriesClosedCessna 172 · Aberdeen, SDAug 4, 1965 · N3617S · Substantial damage NTSB MKC66F0162Accident · No injuriesClosedBellanca 14-19 · Bison, SDJul 30, 1965 · N7676B · Substantial damage NTSB MKC66D0199Accident · No injuriesClosedPiper PA-18A · Redfield, SDJul 30, 1965 · N9774D · Substantial damage NTSB MKC66A0005Accident · No injuriesClosedBell 47G2 · Keystone, SDJul 22, 1965 · N262MV · Substantial damage NTSB MKC66F0100Accident · No injuriesClosedMooney M20E · No Sioux City, SDJul 13, 1965 · N79369 · Substantial damage NTSB MKC66F0132Accident · No injuriesClosedAeronca 15AC · Ft Pierre, SDJul 12, 1965 · N1127H · Substantial damage NTSB MKC66F0036Accident · No injuriesClosedCessna 210 · Sioux Falls, SDJun 16, 1965 · N9599T · Substantial damage NTSB MKC66F0067Accident · No injuriesClosedCessna 140 · Columbia, SDJun 10, 1965 · N2341N · Substantial damage NTSB MKC65A0073Accident · 2 fatalClosedAeronca 7AC · Winner, SDJun 10, 1965 · N2042E · Destroyed NTSB MKC66F0104Accident · Minor injuriesClosedPiper PA-18 · Tulare, SDJun 8, 1965 · N1011A · Destroyed NTSB MKC66F0105Accident · No injuriesClosedCessna 195 · Aberdeen, SDJun 6, 1965 · N1561D · Substantial damage NTSB MKC66F0047Accident · No injuriesClosedMooney 721 · Pierre, SDJun 3, 1965 · N79369 · Substantial damage NTSB MKC66F0115Accident · No injuriesClosedPiper J3C · Viewfield, SDMay 29, 1965 · N70927 · Substantial damage NTSB MKC66F0049Accident · Minor injuriesClosedPiper PA-11 · Frankfort, SDMay 28, 1965 · N4777H · Substantial damage NTSB MKC65F0136Accident · Minor injuriesClosedCessna 172 · Sioux Falls, SDMay 9, 1965 · N2758U · Substantial damage NTSB MKC65F0141Accident · No injuriesClosedPiper PA-15 · Rapid City, SDMay 4, 1965 · N4481H · Substantial damage NTSB MKC65F0110Accident · No injuriesClosedCessna 172 · Sioux Falls, SDMay 2, 1965 · N3898S · Substantial damage NTSB MKC65D0096Accident · No injuriesClosedCessna 182 · Yankton, SDMay 1, 1965 · N5558B · Substantial damage NTSB MKC65A0062Accident · 2 fatalClosedBeechcraft T-34 · Hermosa, SDApr 22, 1965 · N4988E · Destroyed NTSB MKC65D0103Accident · No injuriesClosedCessna 182 · Huron, SDApr 15, 1965 · N9333X · Substantial damage NTSB MKC65F0076Accident · No injuriesClosedPiper PA-30 · Huron, SDApr 8, 1965 · N7150Y · Substantial damage NTSB MKC65F0066Accident · No injuriesClosedCessna 140 · Rapid City, SDMar 20, 1965 · N2335V · Substantial damage NTSB MKC65F0067Accident · No injuriesClosedCessna 195A · Aberdeen, SDMar 19, 1965 · N1540D · Substantial damage NTSB MKC65F0111Accident · No injuriesClosedPiper PA-23 · Huron, SDFeb 5, 1965 · N3008P · Substantial damage NTSB MKC65F0010Accident · No injuriesClosedMooney M20 · Pierre, SDJan 10, 1965 · N5206B · Substantial damage NTSB MKC65F0011Accident · No injuriesClosedCessna 182 · Fort Thompson, SDJan 6, 1965 · N5306B · Substantial damage