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 CHI98TA145Accident · Minor injuriesFinal reportPiper PA-18-150 · Artesian, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI98LA120Accident · 2 fatalLimited investigationFinal reportRodgers Raven · Brandt, SDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to this accident was the pilot's lack of experience in the airplane.NTSB CHI98LA117Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Vernillion, SDthe pilot's failure (or inability) to properly compensate for wind conditions, while taxiing. Factors associated with the accident were: the sandy terrain, and the gusty tailwind condition.NTSB CHI98LA118Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDthe pilot failed to abort the takeoff in a timely manner and could not stop on the runway.NTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…NTSB CHI98LA113Accident · No injuriesLimited investigationFinal reportCessna 310R · Sioux Falls, SDthe pilot's failure to extend the landing gear for landing. Factors associated with the accident were: the crosswind, and the pilot not following his normal habit pattern of lowering the landing gear on base leg.NTSB CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.NTSB CHI98LA073Accident · 1 fatalLimited investigationFinal reportCessna 402B · Watertown, SDthe pilot's failure to perform an aircraft preflight and to remove the ice which had accumulated on the airframe. A factor involved in the accident was the icing weather conditions which existed and the ice which accumulated on the airplane.NTSB CHI98LA018Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Rapid City, SDthe windshear, the pilot's inability to maintain the airplane's landing approach speed, and the inadvertent stall.NTSB CHI97LA303Accident · No injuriesLimited investigationFinal reportCessna 172P · Yankton, SDThe pilot's failure to maintain control of the aircraft. A factor contributing to the accident was the wind gusts.NTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB CHI97LA254Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Britton, SDthe pilot's failure to maintain clearance with the terrain during the spray run and his failure to maintain adequate airspeed during the turn after having contacted the terrain. A factor was the pilot's diverted attention.NTSB CHI97FAMS3Accident · 1 fatalMissing aircraftFinal reportGrumman American AA-5 · Lower Brule, SDundetermined due to the accident airplane not being available for examination.NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.NTSB CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.NTSB CHI97LA109Accident · No injuriesLimited investigationFinal reportCessna 421C · Pierre, SDthe pilot's inadvertent activation of the number one throttle/power control. Factors were: the pilot left the cockpit unattended with the engines running and a wet ramp.NTSB CHI97LA108Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Sioux Falls, SDthe ground crewmember failed to maintain visual contact with the balloon, while it was landing. A factor relating to the accident was: the ground crewmember allowed her attention to be diverted while keeping a child out of harms way.NTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.NTSB CHI97IA074Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Rapid City, SDa missing 'C' clip, which resulted in the master link coming apart, allowing the electric elevator trim chain and cable to become entangled in the elevator trim cables.NTSB CHI97FA024Accident · 1 fatalField investigationFinal reportCessna 177B · Chancellor, SDthe pilot's attempted flight with known deficiencies in equipment, his initiating VFR flight into IMC conditions, his spatial disorientation and loss of control of the airplane. Factors were fog, dark night, and inoperative directional gyro.NTSB CHI97LA004Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Nunda, SDfailure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.NTSB CHI96LA295Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Custer, SDloss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.NTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.NTSB CHI96LA274Accident · No injuriesLimited investigationFinal reportBeech 35 · Yankton, SDan improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…NTSB CHI96LA240Accident · Minor injuriesLimited investigationFinal reportSauder Avid Flyer HH · Stoneville, SDloss of engine power for undetermined reason(s). A factor relating to the accident was: rough/uneven terrain in the emergency landing area.NTSB CHI96LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Parker, SDengine compartment fire from accumulated fuel in the carburetor, and failure of the pilot to follow the emergency checklist procedure.NTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.NTSB CHI96LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Custer, SDthe pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.NTSB CHI96LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Letcher, SDthe pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.NTSB CHI96FA133Accident · 1 fatalField investigationFinal reportBeech F-33A · Prairie City, SDthe pilot's failure to maintain control of the airplane. A factor was pilot fatigue.NTSB CHI96LA069Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Winner, SDthe pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB CHI96FA038Accident · 4 fatalField investigationFinal reportPiper PA-28-201T · Belvidere, SDthe pilot's attempted visual flight into instrument meteorological conditions, his failure to maintain control of the airplane, and exceeding the design stress limits of the airplane. Factors in the accident were: the snow and fog, and the aft airplane center…NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB CHI95LA306Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Badger, SDthe pilot's failure to maintain adequate airspeed while making a steep right turn. A contributing factor was the insufficient altitude needed to make a recovery.NTSB CHI95LA262Accident · Serious injuriesLimited investigationFinal reportAerostar S-81-A · Custer, SDthe pilot's inadequate evaluation of the weather conditions.NTSB CHI95LA206Accident · Serious injuriesLimited investigationFinal reportBeech 23A · Spearfish, SDThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.NTSB CHI95LA193Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Rapid City, SDthe pilot's failure to feather the propeller on the left engine during the descent. A factor was the carburetor icing weather condition.NTSB CHI95LA164Accident · No injuriesLimited investigationFinal reportCessna 337B · Lemmon, SDthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Clark, SDthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's excessive braking.NTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.NTSB CHI95DTK01Accident · 1 fatalFinal reportGay RV-4 · Lennox, SDThe pilot's failure to maintain adequate altitude while performing aerobatic maneuvers. The pilot's impairment of judgment and performance due to drugs was a factor.NTSB CHI95LA014Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Aberdeen, SDthe pilot's failure to assure adequate maintenance was performed on the airplane and the resulting intentional flight with known deficiencies. Factors associated with the accident were the pilot's failure to follow the aircraft flight manual and the improper…NTSB CHI94LA287Accident · No injuriesLimited investigationFinal reportHughes 369HS · Custer, SDthe pilot's selection of unsuitable terrain on which to perform an autorotation. A factor in this accident was the hidden obstruction.NTSB CHI94LA261Accident · No injuriesLimited investigationFinal reportCessna 172 · Aberdeen, SDthe pilot's failure to maintain directional control during landing. A related factor is the dark night conditions.NTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.NTSB CHI94DTK02Accident · No injuriesFinal reportAyres S2R · Letcher, SDthe loss of engine power due to the failure of the engine driven fuel pump and shaft.NTSB CHI94DTK01Accident · No injuriesFinal reportWeatherly 620 · Ridgeview, SDfuel starvation due to the pilot's improper fuel tank selection.NTSB CHI94FA155Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Mcintosh, SDVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) from rising terrain. Factors related to the accident were: failure of the pilot to update his weather…NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.