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 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 CHI08CA232Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Wall, SDThe pilot not maintaining airplane control during the landing. Contributing to the accident was the reported wind shear.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.NTSB CHI08CA029Accident · No injuriesData collectionFinal reportCessna 172R · Brookings, SDThe student pilot's failure to maintain directional control during takeoff roll. Contributing to the accident was the student pilot's lack of solo flight experience and the runway sign.NTSB CHI07TA241Accident · Minor injuriesFinal reportChristen Industries A-1 · Elm Springs, SDThe pilot not maintaining clearance from the rising terrain. A factor contributing to the accident was the rising terrain.NTSB CHI07LA317Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Custer, SDThe high wind during landing. Contributing to the accident was the encounter with adverse weather during the flight.NTSB CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.NTSB CHI07TA201Accident · Minor injuriesFinal reportWSK PZL Mielec PZL M18B · Kyle, SDThe pilot's failure to maintain clearance from terrain during an aerial application maneuver. Contributing to the accident were wind gusts, low altitude, and the reported downdraft.NTSB CHI07CA155Accident · No injuriesData collectionFinal reportChampion 7EC · Sioux Falls, SDThe pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB CHI07CA148Accident · No injuriesData collectionFinal reportCessna A188 · Scotland, SDThe pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.NTSB CHI07CA122Accident · No injuriesData collectionFinal reportCessna 140 · Winner, SDThe pilot's excessive use of braking during the landing roll, causing the aircraft to nose over.NTSB CHI07CA061Accident · No injuriesData collectionFinal reportPiper J3C-65 · White Lake, SDThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and a nose over. A factor associated with the accident was the crosswind.NTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.NTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.NTSB CHI06LA078Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Wagner, SDThe pilot not maintaining airplane control and the inadvertent stall encountered during the climb. A factor was the instrument meteorological conditions.NTSB CHI06FA067Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Pierre, SDThe loss of engine power during takeoff-initial climb due to the pilot's failure to correctly position the fuel selector, which resulted in fuel starvation and a forced landing.NTSB CHI06CA042Accident · No injuriesData collectionFinal reportCessna 310Q · Pierre, SDThe pilot's failure to maintain control of the airplane during the landing roll due to the icy runway. Factors were the compacted snow and ice along the edges of the runway and at the taxiway intersection, and the snow banks adjacent to the runway and taxiway.NTSB CHI06CA002Accident · No injuriesData collectionFinal reportCreed RV-4 · Mitchell, SDThe mechanic's improper installation of the air filter assembly which resulted in foreign debris inside the carburetor. A factor associated with the accident was the rough terrain on which the airplane was landed.NTSB CHI06CA018Accident · No injuriesData collectionFinal reportStinson 108-1 · Tea, SDThe pilot's failure to maintain directional control during the landing rollout which resulted in the encountered ground loop.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB CHI05LA261Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Faulkton, SDThe pilot's failure to maintain control of the airplane due to spatial disorientation during initial climb after takeoff into night instrument meteorological conditions. Factors were the fog and the dark night.NTSB CHI05LA225Accident · No injuriesLimited investigationFinal reportCessna 210 · Rapid City, SDThe landing gear extension not possible and inoperative flap system due to fatigue failure of a hydraulic system tube during approach. An additional cause was the improper rebuild/remanufacture of the hydraulic tube. Contributing factors were the dependency…NTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.NTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB CHI05CA117Accident · Serious injuriesData collectionFinal reportAviat A-1B · Lodgepole, SDThe poor inflight planning and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the low altitude at which the airplane encoutnered its own wake.NTSB CHI05CA040Accident · Minor injuriesData collectionFinal reportCessna 182P · Belle Fourche, SDThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were the gusting crosswind, the pilot's lack of night flying of experience, the inoperative instrument lights, and the night…NTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB CHI04CA289Accident · No injuriesData collectionFinal reportArganbright Vans RV-4 · Custer, SDThe pilot's failure to maintain directional control during the landing. Factors were the sudden wind shift and the embankment.NTSB CHI04LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Custer, SDThe pilot's poor preflight planning/preparation and the pilot used improper aborted takeoff procedures by not reducing the throttle. Factors associated with the accident were the high density altitude and the tailwind.NTSB CHI04TA193Accident · No injuriesFinal reportPZL-Mielec M-18T · Pine Ridge, SDThe propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.NTSB CHI04LA204Accident · No injuriesLimited investigationFinal reportAerostar S53H · Sioux Falls, SDThe pilot's selection of an unsuitable landing area for the balloon and his failure to maintain clearance with the transmission line. A contributing factor was the presence of the transmission line.NTSB CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.NTSB CHI04LA145Accident · Minor injuriesLimited investigationFinal reportBetchan KR II · Rapid City, SDFailure of the engine rocker arm installation resulting in a loss of engine power. A contributing factor was the power lines.NTSB CHI04CA091Accident · No injuriesData collectionFinal reportCessna C-180 · Aberdeen, SDThe pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…NTSB CHI04IA056Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Rapid City, SDThe copilot's failure to maintain control of the airplane during the landing and the captain's delay in initiating remedial action. Factors contributing to the accident were the low ceiling and low visibility due to fog, and the aircraft's deviation from…NTSB CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.NTSB CHI03LA299Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · South Shore, SDA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.NTSB CHI03IA300Incident · No injuriesIncident investigationFinal reportCessna 650 · Rapid City, SDThe in-flight failure of the right wing aileron cable during cruise.NTSB CHI03LA271Accident · No injuriesLimited investigationFinal reportCessna 188A · Freeman, SDThe pilot's failure to maintain directional control and clearance during landing roll. Additional factors included the pilot's improper recovery from a bounced landing, the crosswind and the corn crop.NTSB CHI03LA254Accident · No injuriesLimited investigationFinal reportWeatherly 620A · Doland, SDThe pilot's failure to maintain clearance from the wires and directional control not being possible due to the failure of the brake system. Factors contributing to the accident were the wires, the trees, and the failure of the brake system.NTSB CHI03LA249Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Brookings, SDThe inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.NTSB CHI03LA199Accident · No injuriesLimited investigationFinal reportAviat A-1B · Okobojo, SDThe failure of the float strut during a water landing.NTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.NTSB CHI03LA154Accident · Minor injuriesLimited investigationFinal reportBraunschmidt RV-6A · Tea, SDThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.