NTSB investigations, SD
14 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2024 | 2 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030220'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030220')) 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 CEN24FA295Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Irene, SDThe pilot’s poor decision to continue the flight into deteriorating weather conditions and his failure to maintain a safe altitude, which resulted in controlled flight into trees and terrain.NTSB CEN24LA229Accident · Minor injuriesClass 4 · LimitedFinal reportAero Commander S2R · White, SDA low-level collision and engine ingestion with ducks, which resulted in a total loss of engine power, a forced landing, and a subsequent nose over.NTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.NTSB GAA18CA429Accident · No injuriesData collectionFinal reportCessna 170 · Spearfish, SDThe pilot’s improper decision to take off in tailwind conditions, which resulted in an aborted takeoff with insufficient runway remaining.NTSB GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.NTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.NTSB GAA15CA196Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Forest City, SDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.NTSB CEN15CA160Accident · Serious injuriesData collectionFinal reportZenith Acft Stol CH 701 · Marion, SDThe pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…NTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.NTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.NTSB CHI08CA296Accident · No injuriesData collectionFinal reportPiper PA28 · Gann Valley, SDThe pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.