NTSB investigations, 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.
Cases, newest first
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' 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 CEN13LA220Accident · Minor injuriesLimited investigationFinal reportWalker Phil RV-6A · Spearfish, SDThe coil-distributor wire loosening in flight, which rendered the ignition system inoperative and subsequently caused the loss of engine power.NTSB CEN13CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okaton, SDThe pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.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 CEN12LA634Accident · 1 fatalLimited investigationFinal reportNorth Wing Design Apache Sport · Vermillion, SDThe pilot’s failure to maintain control of the weight-shift-control aircraft during initial climb, which resulted in an aerodynamic stall/spin.NTSB CEN12FA579Accident · 1 fatalField investigationFinal reportLee Paul SQ 2000 · Pierre, SDThe airplane's entry into a pilot-induced oscillation and the pilot’s loss of airplane control during the takeoff initial climb. Contributing to the accident was the left entrance door opening in flight for undetermined reasons.NTSB CEN12LA580Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe partial loss of engine power due to debris lodged beneath the throttle body of the carburetor venturi.NTSB CEN12LA557Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Flandreau, SDA malfunction of the helicopter’s throttle system, which resulted in a loss of engine power during cruise flight.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB CEN12LA346Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Clark, SDThe pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.NTSB CEN12LA357Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Howard, SDA fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.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 CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.NTSB CEN12LA242Accident · Minor injuriesLimited investigationFinal reportBell 407 · Aberdeen, SDThe fatigue failure of two turbine engine blades due to vibration.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB CEN12LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rapid City, SDThe loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.NTSB CEN12CA159Accident · No injuriesData collectionFinal reportMaule MX-7-235 · Tea, SDThe pilot did not maintain directional control of the airplane during a crosswind landing.NTSB CEN12LA103Accident · No injuriesLimited investigationFinal reportBeech C23 · Watertown, SDA total loss of engine power during initial climb for undetermined reasons.NTSB CEN12FA100Accident · 4 fatalField investigationFinal reportCessna 421C · Sioux Falls, SDThe pilot’s failure to maintain adequate airspeed after shutting down one engine, which resulted in an inadvertent aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s failure to follow the guidance contained in the pilot’s…NTSB CEN12LA059Accident · 1 fatalLimited investigationFinal reportCessna 172M · Sturgis, SDThe student pilot’s failure to maintain control of the airplane during takeoff with extended flaps.NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.NTSB CEN12FA001Accident · 1 fatalField investigationFinal reportRobinson Helicopter R66 · Philip, SDThe in-flight separation of the main rotor mast following a mast bumping event. The reason for the mast bumping event could not be determined due to postaccident damage.NTSB CEN11LA581Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Whitewood, SDThe pilot's collision with terrain for undetermined reasons.NTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.NTSB CEN11FA437Accident · 3 fatalField investigationFinal reportAmerican Champion 7GCBC · Hayti, SDThe pilot's decision to attempt low-altitude flight and his failure to maintain adequate clearance from power lines.NTSB CEN11LA452Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Estelline, SDThe pilot’s failure to maintain control of the airplane during takeoff for undetermined reasons because the pilot did not recall the accident.NTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.NTSB CEN11LA399Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Highmore, SDThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.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 CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.NTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB CEN10LA430Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Spearfish, SDThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN10LA429Accident · 1 fatalLimited investigationFinal reportWarth Dennis J Classic Sport S-18 · Tea, SDA loss of engine power for undetermined reasons and the pilot's loss of airplane control, which led to an aerodynamic stall.NTSB CEN10CA415Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Bison, SDThe pilot's failure to maintain directional control of the airplane after encountering a gust of wind while taking off with a crosswind.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 CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.NTSB CEN10CA244Accident · No injuriesData collectionFinal reportPiper J3L · Kyle, SDThe pilot's improper touchdown on a soft landing area, resulting in a nose over.NTSB CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.NTSB CEN09CA519Accident · No injuriesData collectionFinal reportCessna 182A · Watertown, SDA loss of engine power due to fuel exhaustion as a result of a fuel tank leak. Contributing to the accident was the reported malfunction of the fuel gauge.NTSB CEN09LA388Accident · Serious injuriesLimited investigationFinal reportBeech B100 · Rapid City, SDThe flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.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 CEN09CA305Accident · No injuriesData collectionFinal reportFlight Design CT2K · Mitchell, SDThe pilot's inadequate compensation for the gusting winds during landing.NTSB CEN09LA206Accident · No injuriesLimited investigationFinal reportCessna 402B · Aberdeen, SDThe pilot's continued flight into adverse weather and icing conditions, and his failure to maintain aircraft control resulting in a hard landing. Contributing to the accident was the accumulation of airframe ice and the strong, gusting crosswinds.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 CHI08CA245Accident · No injuriesData collectionFinal reportAir Tractor 301 · Herreid, SDFailure of one of the tailwheel bolts on landing and the pilot's subsequent inability to maintain directional control.