NTSB investigations, SD
34 cases where NTSB found Physical environment.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 3 |
| 2024 | 2 |
| 2025 | 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\", '0302'))
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", '0302')) 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 CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB CEN25LA069Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Spearfish, SDThe pilot’s failure to land on the centerline of the snow-covered runway at night, which resulted in the left wing impacting a snowbank, a subsequent loss of directional control, and runway excursion.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 GAA19CA217Accident · Minor injuriesData collectionFinal reportVans Vans RV-12 · Wall, SDThe pilot's improper decision to depart from a slush-covered runway, which resulted in a loss of directional control, a runway excursion, and a subsequent nose-over.NTSB GAA19CA147Accident · Minor injuriesData collectionFinal reportPorterfield CP 65 · Aberdeen, SDThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB CEN18LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, SDA stuck No. 3 cylinder exhaust valve, which resulted in failure of the associated rocker arm, a partial loss of engine power, and the subsequent forced landing into tall vegetation.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 GAA18CA173Accident · No injuriesData collectionFinal reportCessna 182 · Rapid City, SDThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and runway excursion.NTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.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 CEN13LA431Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Gary, SDThe failure of the engine connecting rod due to fatigue.NTSB CEN13LA228Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Buffalo, SDThe pilot’s failure to maintain adequate main rotor rpm while maneuvering at a low altitude in gusting wind conditions, which resulted in an emergency landing on uneven terrain.NTSB CEN12CA658Accident · No injuriesData collectionFinal reportCessna 175A · Spearfish, SDThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.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 CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.NTSB CEN10CA305Accident · No injuriesData collectionFinal reportCessna 337 · Custer, SDA partial loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel mismanagement.NTSB CEN10CA244Accident · No injuriesData collectionFinal reportPiper J3L · Kyle, SDThe pilot's improper touchdown on a soft landing area, resulting in a nose over.NTSB CEN09CA616Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Clark, SDThe pilot's inadequate visual lookout and failure to maintain clearance from a levy.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 CEN09CA112Accident · No injuriesData collectionFinal reportCessna 140 · Highmore, SDThe pilot's failure to maintain directional control during the flare while landing in deep snow.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.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.NTSB CHI08CA246Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Turton, SDThe failure of the starter generator which resulted in the subsequent loss of engine power. Contributing to the accident were the low altitude at which the airplane was operating, the tall grass, and the ditch.NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB CHI08CA111Accident · No injuriesData collectionFinal reportVeldhuizen Highlander · Onida, SDThe separation of the right main wheel from the landing gear during takeoff for an undetermined reason.. Contributing to the accident were rough/uneven terrain and that directional control was not possible.