Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 CHI76AC041Accident · 5 fatalClosedBeech P35 · Ft Pierre, SDDec 25, 1975 · N1480G · Destroyed NTSB MKC76FTK18Accident · Minor injuriesClosedCessna 210 · Brookings, SDDec 12, 1975 · N9677X · Substantial damage NTSB MKC76DTK14Accident · No injuriesClosedAeronca 11AC · Oelrichs, SDNov 30, 1975 · N86333 · Substantial damage NTSB MKC76FTK15Accident · Serious injuriesClosedAeronca 7BCM · Watertown, SDNov 28, 1975 · N4293E · Substantial damage NTSB MKC76DTK17Accident · No injuriesClosedCessna 185 · Hot Springs, SDNov 12, 1975 · N9832X · Substantial damage NTSB MKC76DTK12Accident · No injuriesClosedCessna 180 · Chelsea, SDOct 20, 1975 · N101A · Substantial damage NTSB MKC76AK028Accident · 1 fatalClosedPiper PA-28 · Yankton, SDOct 17, 1975 · N8303R · Destroyed NTSB MKC76DTK10Accident · No injuriesClosedPiper PA-32 · Flandreau, SDOct 14, 1975 · N5216S · Substantial damage NTSB MKC76FTK11Accident · Serious injuriesClosedSchreder HP-16 · Lennox, SDOct 12, 1975 · N16DH · Destroyed NTSB MKC76FTK08Accident · No injuriesClosedCessna 182A · Spearfish, SDOct 4, 1975 · N4826D · Substantial damage NTSB MKC76FTK07Accident · No injuriesClosedCessna 180 · Rapid City, SDSep 23, 1975 · N4707B · Substantial damage NTSB MKC76FTK06Accident · No injuriesClosedCessna 172M · Rapid City, SDSep 19, 1975 · N6782H · Substantial damage NTSB MKC76FTK05Accident · Minor injuriesClosedPiper PA-22 · Rapid City, SDSep 6, 1975 · N9169D · Substantial damage NTSB MKC76AK019Accident · 2 fatalClosedPiper PA-18 · Hayes, SDSep 5, 1975 · N5487H · Destroyed NTSB MKC76DTK04Accident · No injuriesClosedWaco UPF-7 · N Sioux City, SDAug 30, 1975 · N29974 · Substantial damage NTSB MKC76AK014Accident · 1 fatalClosedCessna 210J · Summit, SDAug 29, 1975 · N3392S · Destroyed NTSB MKC76FTK03Accident · Serious injuriesClosedLuscombe 8E · Watertown, SDAug 5, 1975 · N1820K · Destroyed NTSB MKC76AK012Accident · 3 fatalClosedBell 47G-5 · Keystone, SDAug 5, 1975 · N4753R · Substantial damage NTSB MKC76FTK02Accident · Minor injuriesClosedBell 47-G2A · Keystone, SDJul 25, 1975 · N7578 · Substantial damage NTSB MKC76DTK01Accident · No injuriesClosedCessna 180 · Buffalo, SDJul 23, 1975 · N6453X · Substantial damage NTSB MKC76AK007Accident · 1 fatalClosedCessna 150F · Plankinton, SDJul 9, 1975 · N5643G · Destroyed NTSB MKC76AK003Accident · Minor injuriesClosedSikorsky S-55B · Pine Ridge, SDJul 4, 1975 · N111RS · Substantial damage NTSB MKC75AK061Accident · Serious injuriesClosedN.American NA-265 · Watertown, SDJun 14, 1975 · N67KM · Substantial damage NTSB MKC75DTK21Accident · No injuriesClosedLuscombe 8A · Hoven, SDJun 6, 1975 · N77859 · Substantial damage NTSB MKC75DTK20Accident · No injuriesClosedPiper J3C-65 · Scenic, SDJun 6, 1975 · N3400N · Substantial damage NTSB MKC75DTK19Accident · No injuriesClosedCessna 140 · Wall, SDJun 4, 1975 · N2335V · Substantial damage NTSB MKC75DTF17Accident · No injuriesClosedPiper PA-18 · Hayes, SDMay 27, 1975 · N3941Z · Substantial damage NTSB MKC75DTK18Accident · Minor injuriesClosedAeronca 7AC · Canton, SDMay 18, 1975 · N85133 · Substantial damage NTSB MKC75FTK16Accident · No injuriesClosedCessna 188T · Freeman, SDMay 1, 1975 · N9246G · Substantial damage NTSB MKC75DTK15Accident · No injuriesClosedMaule M5-210 · Wood, SDApr 27, 1975 · N51590 · Substantial damage NTSB MKC75DTK14Accident · No injuriesClosedBellanca 7ACA · Madison, SDMar 4, 1975 · N9156L · Substantial damage NTSB MKC75DTK13Accident · No injuriesClosedPiper PA-18A · Quinn, SDFeb 22, 1975 · N6886B · Substantial damage NTSB MKC75DTK12Accident · No injuriesClosedPiper PA-18 · Milbank, SDFeb 2, 1975 · N6980D · Substantial damage NTSB MKC75DTK11Accident · No injuriesClosedPiper PA-28 · Iroquis, SDJan 17, 1975 · N5141W · Substantial damage NTSB MKC75DTK10Accident · Minor injuriesClosedCessna 172 · Herreid, SDJan 14, 1975 · N7054G · Destroyed