Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MKC71FDQ22Accident · Serious injuriesClosedAeronca 7AC · Edgemont, SDDec 25, 1970 · N2968E · Substantial damage NTSB MKC71DDQ21Accident · No injuriesClosedCessna 310D · Mitchell, SDDec 18, 1970 · N6977T · Substantial damage NTSB MKC71DDQ20Accident · No injuriesClosedAeronca 7GC-3 · Tea, SDDec 13, 1970 · N7523E · Substantial damage NTSB MKC71DDQ19Accident · No injuriesClosedPiper PA-18 · Onida, SDDec 12, 1970 · N4220Z · Substantial damage NTSB MKC71AK032Accident · 1 fatalClosedPiper PA-22 · Rapid City, SDDec 9, 1970 · N6920B · Destroyed NTSB MKC71AK031Accident · Minor injuriesClosedPiper PA-28 · Rapid City, SDDec 1, 1970 · N8569W · Substantial damage NTSB MKC71DDQ18Accident · No injuriesClosedCessna 310 · Mission, SDOct 28, 1970 · N5292A · Substantial damage NTSB MKC71DDQ17Accident · Minor injuriesClosedCessna 170 · Hartford, SDOct 10, 1970 · N6848D · Substantial damage NTSB MKC71FDQ16Accident · No injuriesClosedBeech 95-B55 · Sturgis, SDOct 7, 1970 · N8685Q · Substantial damage NTSB MKC71DDQ15Accident · No injuriesClosedPiper PA-28 · Winner, SDOct 4, 1970 · N9156J · Substantial damage NTSB MKC71FDQ13Accident · No injuriesClosedPiper PA-18 · Pierre, SDSep 30, 1970 · N9454D · Substantial damage NTSB MKC71FDQ11Accident · Minor injuriesClosedAeronca 7AC · Rapid City, SDSep 19, 1970 · N82576 · Substantial damage NTSB MKC71DDQ12Accident · No injuriesClosedCessna 120 · Harrold, SDSep 19, 1970 · N3141N · Substantial damage NTSB MKC71FDQ10Accident · No injuriesClosedBell 47G-2 · Keystone, SDAug 18, 1970 · N5163B · Substantial damage NTSB MKC71FDQ09Accident · No injuriesClosedAeronca 7GCB · Sturgis, SDAug 17, 1970 · N9939Y · Substantial damage NTSB MKC71DDQ08Accident · No injuriesClosedPiper PA-22 · Chamberlain, SDAug 16, 1970 · N4545Z · Substantial damage NTSB MKC71DDQ07Accident · No injuriesClosedPiper PA-11 · Hayes, SDAug 16, 1970 · N5567H · Substantial damage NTSB MKC71DDQ06Accident · No injuriesClosedCessna 170B · Wilmot, SDAug 15, 1970 · N4383B · Substantial damage NTSB MKC71DDQ05Accident · No injuriesClosedPiper PA-18 · Opal, SDAug 7, 1970 · N7113K · Substantial damage NTSB MKC71DDQ04Accident · No injuriesClosedCessna 150 · Warner, SDAug 5, 1970 · N50376 · Substantial damage NTSB MKC71FDQ03Accident · No injuriesClosedPiper PA-22 · Murdo, SDJul 25, 1970 · N3933P · Substantial damage NTSB MKC71DDQ02Accident · No injuriesClosedPiper PA-18 · Ludlow, SDJul 6, 1970 · N1637A · Substantial damage NTSB MKC71DDQ01Accident · No injuriesClosedPiper PA-18A · White Lake, SDJul 2, 1970 · N7072B · Substantial damage NTSB MKC70DDQ11Accident · No injuriesClosedCessna 182 · Willow Lake, SDJun 19, 1970 · N2426R · Substantial damage NTSB MKC70FDQ10Accident · Serious injuriesClosedAeronca 7CCM · Hayes, SDJun 17, 1970 · N82616 · Substantial damage NTSB MKC70FDQ09Accident · 1 fatalClosedCallair A-9 · Madison, SDJun 11, 1970 · N9653Z · Destroyed NTSB MKC70FDQ08Accident · No injuriesClosedMooney M20C · Miller, SDMay 30, 1970 · N2937L · Substantial damage NTSB MKC70DDQ07Accident · Minor injuriesClosedBeech 35 · Milbank, SDApr 26, 1970 · N2740V · Substantial damage NTSB MKC70DDQ06Accident · No injuriesClosedCessna 180 · Watertown, SDApr 25, 1970 · N9033C · Substantial damage NTSB MKC70AK058Accident · 2 fatalClosedMooney M20E · Winner, SDApr 22, 1970 · N5949Q · Destroyed NTSB MKC70AK056Accident · 2 fatalClosedMooney M20C · Rosholt, SDApr 14, 1970 · N6759U · Destroyed NTSB MKC70DDQ05Accident · No injuriesClosedCessna 172K · Isabel, SDFeb 22, 1970 · N79445 · Substantial damage NTSB MKC70DDQ04Accident · Minor injuriesClosedPiper PA-24 · Onida, SDJan 29, 1970 · N6616P · Substantial damage NTSB MKC70DDQ12Accident · No injuriesClosedPiper PA-18 · Altamont, SDJan 25, 1970 · N1256A · Substantial damage NTSB MKC70DDQ03Accident · No injuriesClosedPiper PA-12 · Kennebec, SDJan 22, 1970 · N2998M · Substantial damage NTSB MKC70DDQ02Accident · No injuriesClosedPiper PA-18 · Mobridge, SDJan 15, 1970 · N8176D · Substantial damage NTSB MKC70DDQ01Accident · No injuriesClosedCessna 150 · Miller, SDJan 13, 1970 · N2870S · Substantial damage