Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MKC68F0404Accident · No injuriesClosedPiper PA-22 · Hot Springs, SDDec 31, 1967 · N9178D · Substantial damage NTSB MKC38D0375Accident · No injuriesClosedBeech K35 · Huron, SDDec 7, 1967 · N646Q · Substantial damage NTSB MKC68D0337Accident · No injuriesClosedPiper PA-28 · Sioux Falls, SDNov 4, 1967 · N4588R · Substantial damage NTSB MKC68D0319Accident · No injuriesClosedPiper PA-32 · Winner, SDOct 16, 1967 · N3821W · Substantial damage NTSB MKC68A0028Accident · No injuriesClosedBeech V35 · Huron, SDOct 13, 1967 · N2047W · Substantial damage NTSB MKC68F0250Accident · No injuriesClosedPiper PA-18 · Spearfish, SDOct 11, 1967 · N1752P · Substantial damage NTSB MKC68F0257Accident · No injuriesClosedBeech E18S · Rapid City, SDSep 11, 1967 · N3400 · Substantial damage NTSB MKC68D0215Accident · No injuriesClosedCessna 172G · Ladner, SDSep 11, 1967 · N6074R · Substantial damage NTSB MKC68A0019Accident · 2 fatalClosedPiper J3F · Estelline, SDSep 4, 1967 · N40907 · Destroyed NTSB MKC68F0172Accident · No injuriesClosedNavion A · Chamberlain, SDAug 26, 1967 · N4312K · Substantial damage NTSB MKC68D0216Accident · No injuriesClosedMooney M20E · Sioux Falls, SDAug 25, 1967 · N7191U · Substantial damage NTSB MKC68A0013Accident · No injuriesClosedBeech D35 · Watertown, SDAug 25, 1967 · N2950B · Substantial damage NTSB MKC68D0023Accident · No injuriesClosedLuscombe 8D · South Shore, SDAug 22, 1967 · N72060 · Substantial damage NTSB MKC68F0173Accident · No injuriesClosedBeech J35 · White River, SDAug 19, 1967 · N8257D · Substantial damage NTSB MKC68F0146Accident · No injuriesClosedPiper PA-25 · Hot Springs, SDAug 15, 1967 · N6364Z · Destroyed NTSB MKC68D0152Accident · No injuriesClosedCessna 150 · Rapid City, SDAug 15, 1967 · N6725F · Substantial damage NTSB MKC68D0129Accident · No injuriesClosedPiper PA-28 · Wakonda, SDAug 6, 1967 · N6136W · Substantial damage NTSB MKC68A0010Accident · 3 fatalClosedPiper PA-24 · Belle Forch, SDAug 3, 1967 · N8064P · Destroyed NTSB MKC68D0174Accident · No injuriesClosedErco 415-C · Doland, SDAug 2, 1967 · N99826 · Substantial damage NTSB MKC68A0007Accident · 1 fatalClosedPiper PA-18 · Murdo, SDJul 29, 1967 · N2896P · Destroyed NTSB MKC68D0149Accident · No injuriesClosedPiper PA-25 · Willow Lake, SDJul 28, 1967 · N6002Z · Substantial damage NTSB MKC68D0182Accident · No injuriesClosedBeech 23 · Rapid City, SDJul 21, 1967 · N5754V · Substantial damage NTSB MKC68D0178Accident · No injuriesClosedCessna 195 · Sioux Falls, SDJul 17, 1967 · N9301A · Substantial damage NTSB MKC68F0148Accident · No injuriesClosedAero Comdr 500 · Watertown, SDJul 6, 1967 · N8437C · Substantial damage NTSB MKC68D0177Accident · No injuriesClosedPiper PA-18 · Lodgepole, SDJul 3, 1967 · N3693P · Substantial damage NTSB MKC68D0193Accident · No injuriesClosedCessna 182K · Clark, SDJul 2, 1967 · N2713Q · Substantial damage NTSB MKC68D0060Accident · No injuriesClosedLuscombe 8A · Sioux Falls, SDJun 29, 1967 · N41929 · Substantial damage NTSB MKC67A0086Accident · 1 fatalClosedPiper J3C-65 · Alexandria, SDJun 25, 1967 · N6662H · Destroyed NTSB MKC68F0045Accident · No injuriesClosedBeech 95B55 · Custer, SDJun 19, 1967 · N127Z · Substantial damage NTSB MKC68D0115Accident · No injuriesClosedPiper PA-18 · Gettysburg, SDJun 17, 1967 · N8082C · Substantial damage NTSB MKC68D0039Accident · Minor injuriesClosedPiper PA-24 · Gettysburg, SDJun 15, 1967 · N5936P · Substantial damage NTSB MKC68D0023Accident · Minor injuriesClosedChampion 7GC · Sturgis, SDJun 13, 1967 · N4892E · Substantial damage NTSB MKC67D0623Accident · No injuriesClosedMooney M20C · Sioux Falls, SDJun 12, 1967 · N6035Q · Substantial damage NTSB MKC68F0015Accident · No injuriesClosedCallair A-9 · Belvidere, SDJun 8, 1967 · N7222V · Destroyed NTSB MKC67F0609Accident · No injuriesClosedErco 415-C · Hot Springs, SDMay 15, 1967 · N3130H · Substantial damage NTSB MKC67A0064Accident · Serious injuriesClosedGrumman G-73 · Huron, SDMay 3, 1967 · N298GB · Substantial damage NTSB MKC67A0059Accident · 1 fatalClosedBeech 35 · Wall, SDApr 21, 1967 · N3099V · Destroyed NTSB MKC67F0616Accident · No injuriesClosedCessna 185 · Gettysburg, SDApr 16, 1967 · N4020Y · Substantial damage NTSB MKC67F0509Accident · Minor injuriesClosedPiper PA-18 · Watertown, SDApr 15, 1967 · N9097D · Substantial damage NTSB MKC67D0463Accident · No injuriesClosedBeech 23 · Sisseton, SDFeb 26, 1967 · N8724M · Substantial damage NTSB MKC67F0464Accident · Serious injuriesClosedStinson 108-2 · Thunderhawk, SDFeb 19, 1967 · N9272K · Destroyed NTSB MKC67F0465Accident · No injuriesClosedMooney M20A · Huron, SDFeb 16, 1967 · N6054X · Substantial damage NTSB MKC67F0435Accident · No injuriesClosedPiper PA-28 · Bell-Fourch, SDFeb 3, 1967 · N5147W · Substantial damage NTSB MKC67D0510Accident · No injuriesClosedPiper PA-12 · Wakpala, SDFeb 3, 1967 · N2998M · Substantial damage NTSB MKC67F0427Accident · No injuriesClosedCessna 180 · Newell, SDJan 24, 1967 · N3141D · Substantial damage NTSB MKC67D0357Accident · No injuriesClosedPiper PA-22 · Nisland, SDJan 3, 1967 · N2344P · Substantial damage