Skip to content

NTSB investigations, 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, newest first

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 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 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 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 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 NTSB MKC69D0299Accident · No injuriesClosedCessna 150F · Spearfish, SDDec 21, 1968 · N6418F · Substantial damage NTSB MKC69D0320Accident · No injuriesClosedPiper J3C-65 · Ferney, SDDec 14, 1968 · N3242N · Substantial damage NTSB MKC69F0289Accident · Minor injuriesClosedPiper PA-28 · Spearfish, SDDec 9, 1968 · N7164W · Substantial damage NTSB MKC69D0275Accident · No injuriesClosedCessna 210 · Watertown, SDDec 4, 1968 · N9684X · Substantial damage NTSB MKC69A0033Accident · 2 fatalClosedCessna 175B · Custer, SDNov 19, 1968 · N8290T · Destroyed NTSB MKC69F0263Accident · Minor injuriesClosedCessna 150F · Mobridge, SDOct 31, 1968 · N8225S · Substantial damage NTSB MKC69F0264Accident · Serious injuriesClosedCessna 310 · Faith, SDOct 12, 1968 · N5347A · Substantial damage NTSB MKC69D0322Accident · No injuriesClosedBeech T-34 · Belle Frche, SDOct 11, 1968 · N34291 · Substantial damage NTSB MKC69A0020Accident · 4 fatalClosedBeech N35 · Hetland, SDOct 8, 1968 · N957T · Destroyed NTSB MKC69A0017Accident · 2 fatalClosedLuscombe 8F · Dell Rapids, SDSep 30, 1968 · N1496B · Destroyed NTSB MKC69F0174Accident · Minor injuriesClosedBell 47G3B1 · Custer, SDAug 18, 1968 · N6214N · Destroyed NTSB MKC69F0099Accident · No injuriesClosedPiper PA-24 · Madison, SDAug 13, 1968 · N8317P · Substantial damage NTSB MKC69F0131Accident · Minor injuriesClosedLuscombe 8E · Wagner, SDAug 12, 1968 · N2745K · Substantial damage NTSB MKC69F0129Accident · No injuriesClosedBell 47G-2 · Keystone, SDAug 7, 1968 · N5163B · Substantial damage NTSB MKC69F0086Accident · Minor injuriesClosedBell 47G-2 · Interior, SDAug 1, 1968 · N2813B · Substantial damage NTSB MKC69D0064Accident · No injuriesClosedMooney M20D · Chamberlain, SDJul 28, 1968 · N1972Y · Substantial damage NTSB MKC69F0041Accident · No injuriesClosedPiper PA-22 · Madison, SDJul 7, 1968 · N3846P · Substantial damage NTSB MKC68A0073Accident · No injuriesClosedConvair 580 · Sioux Falls, SDJun 24, 1968 · N4824C · Substantial damage NTSB MKC69D0036Accident · Minor injuriesClosedPiper PA-22 · Lemmon, SDJun 16, 1968 · N1489C · Substantial damage NTSB MKC69F0044Accident · No injuriesClosedCessna 150 · Hot Springs, SDJun 13, 1968 · N22053 · Substantial damage NTSB MKC69F0033Accident · No injuriesClosedPiper PA-18 · Manchester, SDJun 3, 1968 · N3692P · Destroyed NTSB MKC69D0034Accident · No injuriesClosedPiper PA-25 · Platte, SDMay 29, 1968 · N6568Z · Substantial damage NTSB MKC69D0014Accident · No injuriesClosedCessna 172 · Grenville, SDMay 25, 1968 · N7606X · Substantial damage NTSB MKC69F0035Accident · Minor injuriesClosedAero Comdr 100 · Glad Valley, SDMay 18, 1968 · N4150X · Substantial damage NTSB MKC68F0545Accident · No injuriesClosedPiper J3L-65 · Northville, SDMay 14, 1968 · N24686 · Substantial damage NTSB MKC68F0575Accident · Serious injuriesClosedAeronca 11CC · Reliance, SDMay 11, 1968 · N4512E · Substantial damage NTSB MKC68D0576Accident · No injuriesClosedCessna 182 · Mitchell, SDMay 10, 1968 · N461VY · Substantial damage NTSB MKC68F0527Accident · No injuriesClosedBeech 95-A55 · Sioux Falls, SDApr 11, 1968 · N717T · Substantial damage NTSB MKC68D0513Accident · No injuriesClosedAeronca 15AC · Pierre, SDApr 10, 1968 · N1127H · Substantial damage NTSB MKC68A0058Accident · 1 fatalClosedMooney M20C · Wessgtn Spg, SDApr 4, 1968 · N3437X · Destroyed NTSB MKC68F0491Accident · No injuriesClosedCessna 150G · Rapid City, SDMar 30, 1968 · N3613J · Substantial damage NTSB MKC68A0056Accident · 9 fatalClosedBeech E18S · Rapid City, SDMar 17, 1968 · N3400 · Destroyed NTSB NYC68F0462Accident · Minor injuriesClosedPiper PA-15 · Rapid City, SDMar 3, 1968 · N4481H · Substantial damage NTSB MKC68D0498Accident · No injuriesClosedAeronca 11AC · Pollock, SDFeb 29, 1968 · N9779E · Substantial damage NTSB MKC68F0446Accident · No injuriesClosedPiper PA-24 · Mud Butte, SDFeb 1, 1968 · N6968P · Substantial damage NTSB MKC68D0434Accident · No injuriesClosedCessna 170 · Harding, SDJan 18, 1968 · N8057A · Substantial damage NTSB MKC68F0423Accident · No injuriesClosedBeech V-35 · Dell Rapids, SDJan 17, 1968 · N7895L · Substantial damage