NTSB investigations, SD
49 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 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 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 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 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 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 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 CHI03LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pierre, SDThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the collapse of the main landing gear.NTSB CHI03LA109Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Red Owl, SDThe pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.NTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…NTSB CHI01LA254Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Wall, SDThe student pilot failed to maintain a proper glidepath, failed to obtain proper climb rate, and executed the go-around improperly. Additional factors included the pilot's lack of experience, the crop, and the soft, wet ground.NTSB CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.NTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.NTSB CHI01LA082Accident · Serious injuriesLimited investigationFinal reportBeech 65-B80 · Sioux Falls, SDThe pilot initiated the flight into known icing conditions which resulted in his ability to maintain control of the airplane. Factors associated with the accident were the ice accumulation and the company induced pressure for the pilot to make the flight into…NTSB CHI00FA123Accident · 1 fatalField investigationFinal reportCessna 177RG · Watertown, SDthe pilot failed to maintain aircraft control due to spatial disorientation. Factors relating to the accident were the dark night, clouds, and rain.NTSB CHI99LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Veblen, SDwas the pilot not maintaining clearance from terrain. A factor was the pilot not performing a load jettison.NTSB MIA98FA219Accident · 4 fatalField investigationFinal reportSocata TBM-700 · Spearfish, SDThe pilot's failure to maintain control of the airplane while turning to base leg. Contributing factors were low ceilings, clouds, and the pilot's failure to adhere to both the published approach procedures and the published minimum decent altitude.NTSB CHI98LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ipswich, SDthe pilot's inadequate evaluation of the weather conditions and his failure to maintain aircraft control which resulted in a stall/mush. Factors associated with the accident were the tailwind condition and the soft terrain.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 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 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 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 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 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 CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.NTSB CHI93DTK02Accident · Minor injuriesFinal reportHiller UH-12E · Milbank, SDUndeterminedNTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.NTSB CHI91LA210Accident · 2 fatalLimited investigationFinal reportCessna 150F · Faulkton, SDAn inadvertent stall. A factor related to the accident was the pilot's failure to maintain airspeed.NTSB CHI91DTK01Accident · 2 fatalFinal reportPiper PA-18-125 · Newell, SDAn inadvertent stall/spin during maneuvering flight and inadequate remedial action by the pilot. Factors associated with the accident are the pilot's disregard for procedures and directives and inadequate initial training.NTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.NTSB DEN90LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Sturgis, SDPilot inadvertently stalling the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB DEN90LA070Accident · 1 fatalLimited investigationFinal reportChampion 7EC · Pine Ridge, SDThe failure of the pilot to maintain an adequate airspeed, after diverting his attention, which resulted in an inadvertent stall.NTSB DEN88LA153Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Spearfish, SDThe accident involved a tri-pacer with four persons and about 150 pounds of baggage on board who were from Canada and vacationing in the U.S. The pilot said the acft became airborne and climbed to about 100 ft above the rwy, but would not maintain altitude…NTSB DEN87LA194Accident · No injuriesLimited investigationFinal reportCessna 172D · Custer, SDThe plt and his plt-rated pax were landing on rwy 7 (4700 ft x 50 ft) at Custer county arpt (5602 ft MSL), Custer, SD. The plt estimated the winds to be from 180 deg at 15 KTS. Another plt at the arpt estimated the winds to be out of the se at 20 to 25 KTS…NTSB DEN86LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Estelline, SDAccording to the student plt, during the landing roll on a public road, the acft he was piloting encountered a crosswind which tipped the left wing up. The student plt indicated the acft nosed over onto its back. The plt had purchased the acft aprx 1 hr prior…NTSB DEN85FA189Accident · 1 fatalField investigationFinal reportCessna 320F · Rapid City, SDThe acft crashed during an attempted VFR go-around. The plt said he didn't recall touching down and he thought he was 'floating.' When the acft began drifting left of rwy centerline, the plt initiated a go-aroung. He said he applied full power and rotated. He…NTSB DEN85LA144Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat Mark 5A/OH13H · Freeman, SDThe plt said he had completed 4 to 5 swath runs (crop spraying mission). During a turning manuever with a left quatering tail wind, full left pedal,full pwr,the helicopter had a high sink rate until grd impact.NTSB DEN85LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Plankinton, SDThe acft nosed over after a loss of control during takeoff. The plt was using gravel road for takeoff and rotated prematurely to avoid gravel damage. The acft drifted into tall grass and was then pulled into a ditch and fence posts before nosing over.NTSB DEN84FA159Accident · Serious injuriesField investigationFinal reportGrumman American AA-1C · Rapid City, SDThe acft collided with rolling terrain while on a dual training flt. The CFI stated that the student plt was in the process of doing a simulated engine out forced landing when he raised the nose too high. The CFI and student were discussing the terrain when…NTSB DEN84LA099Accident · No injuriesLimited investigationFinal reportChampion 7EC · Wall, SDThe acft crashed during a flight for the purpose of observing the plt's cattle. The plt stated he was 'making a steep left turn at about 75 feet and the bottom (left) wing flew into a wind shear on the downward side of a hill. The airplane slid to the left…NTSB DEN84FA064Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Elm Springs, SDThe pilot was flying along a river bottom looking for stray cattle when the acft crashed into the ground. He received a serious head injury & could not recall details of the accident, but he believed that he was flying at about 100 ft AGL. An exam of the…NTSB DEN83FTK05Accident · Serious injuriesFinal reportPiper PA28-180C · Sturgis Muni., SDThe acft crashed on the approach end to runway 11 during an aborted landing. The plt stated the acft was high so he applied full power and retracted the flaps. He said he retracted the flaps too fast and lost control of the acft. The nose gear was broken off,…NTSB DEN83LA195Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Tea, SDThe acft swerved off the rwy, collided with a ditch and nosed over. The pilot was a student on his 1st solo after over 42 hours of dual instruction. He flew over 28 hours of dual instruction and made about 60 landings during the last 90 days. On the day of…NTSB DEN83FTK02Accident · 5 fatalFinal reportCessna 182Q · Bryant, SDThe aircraft crashed in an open, flat, stubble field just south of Bryant SD. The angle of impact was 45 degrees nose down, with wings level. Fire after impact consumed most of the wreckage and the 5 occupants received fatal injuries. Theweather was IFR with…NTSB DEN83LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Camp Crook, SDPilot making low altutude turns found controls jammed and collided left wing low in descent with bales of hay. Fuselage was found to contain spent and live shotgun shells under the floor. Aileron had a firing pin from a shotgun lodged in a pulley. The pilot…NTSB DEN82FTK06Accident · 1 fatalFinal reportPiper PA-18 · Watertown, SDThe pilot was spraying a sunflower field next to an alfalfa field that was being irrigated. As he pulled up from his third swath run, he began a procedure turn-around over the alfalfa field. During the turn, the plane rolled to an inverted attitude, then…