Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MKC70F0314Accident · Minor injuriesClosedCessna 177 · Newell, SDDec 29, 1969 · N3427T · Substantial damage NTSB MKC70A0037Accident · 2 fatalClosedPiper PA-30 · Vermillion, SDDec 29, 1969 · N7201Y · Destroyed NTSB MKC70F0274Accident · No injuriesClosedPiper PA-22 · Oglala, SDDec 6, 1969 · N8687C · Substantial damage NTSB MKC70F0269Accident · Minor injuriesClosedTaylorcraft BC12-D · Brandon, SDNov 25, 1969 · N43314 · Substantial damage NTSB MKC70F0266Accident · No injuriesClosedPiper J3C-65 · Midland, SDNov 10, 1969 · N87924 · Substantial damage NTSB MKC70F0260Accident · No injuriesClosedPiper PA-18 · Pierre, SDNov 8, 1969 · N3817Z · Substantial damage NTSB MKC70F0248Accident · Minor injuriesClosedLuscombe 8A · Sioux Falls, SDNov 8, 1969 · N9905C · Substantial damage NTSB MKC70F0247Accident · No injuriesClosedPiper PA-24 · Spearfish, SDOct 29, 1969 · N8229P · Destroyed NTSB MKC70F0246Accident · No injuriesClosedBeech A23 · Coleman, SDSep 30, 1969 · N3560R · Substantial damage NTSB MKC70A0009Accident · 3 fatalClosedBell 47G 2 · Keystone, SDSep 4, 1969 · N28208 · Destroyed NTSB MKC70F0225Accident · No injuriesClosedCessna 180 · Rapid City S Dak, SDAug 31, 1969 · N1504C · Substantial damage NTSB MKC70F0182Accident · Minor injuriesClosedPiper PA-28 · Cottonwood, SDAug 31, 1969 · N7875W · Substantial damage NTSB MKC70D0172Accident · No injuriesClosedChampion 7EC · Pierre, SDAug 29, 1969 · N8973R · Substantial damage NTSB MKC70D0154Accident · No injuriesClosedPiper PA-18 · Buffalo Gap, SDAug 23, 1969 · N289T · Substantial damage NTSB MKC70F0103Accident · No injuriesClosedBeech 35 · Sioux Falls, SDAug 5, 1969 · N2795V · Substantial damage NTSB MKC70D0102Accident · No injuriesClosedPiper PA-25 · Doland, SDAug 4, 1969 · N4897Y · Substantial damage NTSB MKC70I0081Incident · No injuriesClosedBell 47G3B1 · Hill City, SDAug 2, 1969 · N7924S · Minor damage NTSB MKC70F0071Accident · Minor injuriesClosedAero Comdr A-9B · Colome, SDJul 22, 1969 · N7687V · Substantial damage NTSB MKC70F0045Accident · No injuriesClosedPiper PA-28 · Rapid City, SDJul 10, 1969 · N8927J · Substantial damage NTSB MKC70F0086Accident · 1 fatalClosedPiper PA-18A · Vermillion, SDJul 4, 1969 · N8153C · Substantial damage NTSB MKC70D0072Accident · No injuriesClosedPiper PA-18 · Camp Crook, SDJul 3, 1969 · N1190A · Substantial damage NTSB MKC70D0047Accident · No injuriesClosedLuscombe 8E · Dempster, SDJun 29, 1969 · N1820K · Substantial damage NTSB MKC70D0053Accident · No injuriesClosedLuscombe 8E · Canton, SDJun 28, 1969 · N1743K · Substantial damage NTSB MKC70D0046Accident · No injuriesClosedPiper PA-25 · Dupree, SDJun 3, 1969 · N6184Z · Substantial damage NTSB MKC69F0459Accident · No injuriesClosedPiper PA-20 · Spearfish, SDJun 3, 1969 · N7099K · Substantial damage NTSB MKC69D0478Accident · No injuriesClosedPiper PA-18 · Onida, SDMay 30, 1969 · N3475Z · Substantial damage NTSB MKC69F0469Accident · Serious injuriesClosedCallair A-9B · Miller, SDMay 29, 1969 · N7259V · Substantial damage NTSB MKC69D0462Accident · No injuriesClosedCessna 170A · Reva, SDMay 26, 1969 · N9765A · Substantial damage NTSB MKC69D0447Accident · No injuriesClosedCessna 182B · Highmore, SDMay 18, 1969 · N2791G · Substantial damage NTSB MKC69D0468Accident · No injuriesClosedCessna 172K · Martin, SDMay 7, 1969 · N46474 · Substantial damage NTSB MKC69F0457Accident · No injuriesClosedMooney M-20C · Lake Andes, SDMay 5, 1969 · N7820V · Substantial damage NTSB MKC69F0446Accident · No injuriesClosedCallair A-9 · Kadoka, SDMay 5, 1969 · N9653Z · Substantial damage NTSB MKC69F0402Accident · No injuriesClosedCessna 150 · Pringle, SDApr 6, 1969 · N6151T · Substantial damage NTSB MKC69F0379Accident · Serious injuriesClosedAeronca 7GCB · Presho, SDMar 1, 1969 · N9825Y · Substantial damage NTSB MKC69D0363Accident · No injuriesClosedCessna 150 · Sioux Falls, SDFeb 19, 1969 · N6402F · Substantial damage