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 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 DEN85FTK01Accident · Serious injuriesFinal reportBoeing A75 · Tea, SDThe owner/plt-in-command (PIC) took off on a local flt with another occupant in the front seat. The front seat occupant was a commercial, single-eng, multi-eng plt with an instructor rating, but he had no previous experience in A75 acft. While in flt, the PIC…NTSB DEN85LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Claire City, SDThe acft collided with power lines during an aerial application flt. The power lines were located in the middle of the field being sprayed and during the last spray run, while flying into the sun, the acft contacted the lines.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 DEN85LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Wesbter, SDThe student pilot made a touch and go landing on a grass runway. The airplane bounced 6 feet in the air during landing and a go around was initiated. The airplane was then on a collision course with airport obstacles. The pilot initiated a left turn, the…NTSB DEN85LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, SDPlt said he performed a 'hasty' preflight. During engine pre-start the plt inadvertently left the throttle open. The engine srated and the acft taxied across the ramp and hit a fence post before the plt could regain control of the acft.NTSB DEN85LA073Accident · No injuriesLimited investigationFinal reportCessna 180A · Sioux, SDAcft departed winnepeg at 1035 and landed at grand forks, ND, at 1150. Departed grand forks, ND, at 1305 and the accident occurred at 1524. 4 miles nw of Sioux falls, SD, the plt reported a rough running engine which subsequently quit. A forced landing was…NTSB DEN85LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Alexandria, SDThe acft made a forced landing in a plowed field after the engine failed. The plt reported that during cruise flt he heard a faint knock from the engine compartment. He reduced power and called fss. Almost immediately the engine began to vibrate. The plt…NTSB DEN85FA002Accident · 3 fatalField investigationFinal reportHamburger Flugzeugbau Hansa HFB-320 · Aberdeen, SDThe hansa jet HFB-320 acft crashed on takeoff from the Aberdeen airport after the flt crew selected the incorrect rwy for takeoff. The acft was observed running off the end of rwy 17, which is 3860 ft long, where it struck a fence, ditch, road & another ditch…NTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…NTSB DEN84LA256Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Kennebec, SDThe plt stated that shortly after takeoff when the aircraft was 25 feet in the air a downdraft was encountered near a small hill at the end of the runway. The descent caused by the downdraft could not be arrested and the aircraft collided with the ground. The…NTSB DEN84LA237Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDPlt stated that during loading for aerial application, he failed to note approaching roll cloud which usually signifies localized turbulence and strong, gusting winds. On takeoff roll, wind shift noted and at 100 ft altitude, heavy turbulence was encountered.…NTSB DEN84LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Chamerlain, SDThe pilot experienced an engine failure and executed an emergency landing on a narrow road which resulted in one of the landing gear touching down on the soft shoulder. The landing gear failed and substantial damage resulted. Examination of the engine…NTSB DEN84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Redfield, SDThe pilot reported he exhausted his fuel supply while engaged in aerial application. The power loss occurred as the aircraft was in a turn and ground impact occurred. In an accident report, the plt suggested that he should have had an operable fuel gage &…NTSB DEN84LA233Accident · No injuriesLimited investigationFinal reportCessna A188B · Stratford, SDPlt stated that he was taking off on this flight with 120 gallons of chemical and full fuel tanks. He continued to state that the acft did not accelerate as it had earlier that day. The acft rolled aprx 3 quarters of the 1/2 mile long rwy before it became…NTSB DEN84LA217Accident · No injuriesLimited investigationFinal reportWeatherly 201 · Watertown, SDThe spray boom of the acft caught in the green wheat along the right side of the dirt rwy during takeoff. The acft then ran off the prepared surface into the wheat. It then nosed over onto its back and caught fire. The dirt rwy is 30 ft wide. The wingspan of…NTSB DEN84LA215Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Marion, SDIn cruise flt, oil covered the windscreen and plt elected a precautionary landing on a dirt road. Acft collided with a mailbox on roll out and nosed over. Oil filler cap found loose.NTSB DEN84LA197Accident · No injuriesLimited investigationFinal reportCessna T188C · Philip, SDThe plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.NTSB DEN84LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Murdo, SDThe pilot reported the engine failed while he was in a procedure turn. The pilot made a forced landing in an open field and the acft nosed over. Examination of the engine after the accident revealed the engine 'swallowed an exhaust valve' that caused the…NTSB DEN84LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stratford, SDAcft touched down short of apch end of rwy and collided with a fence which surrounds the private airstrip boundry. The plt stated too much alt was lost at slow speed on final.NTSB DEN84LA186Accident · 1 fatalLimited investigationFinal reportCessna 188 · Groton, SDDuring aerial application flight, the aircraft passed beneath two power lines. The top of the vertical fin and collision avoidance beacon light apparently made contact with the first wire, as they were found separated near that location. After contact, the…NTSB DEN84FU006Accident · 1 fatalFinal reportWeedhopper B · Beresford, SDThe ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were…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 DEN84LA146Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Winner, SDThe plt reported that a gust of wind was encountered during the landing roll. The acft swerved to the right & left rudder did not correct the situation. The acft left the rwy & collided with a ditch. The plt said that he examined the tailwheel after the…NTSB DEN84LA131Accident · No injuriesLimited investigationFinal reportCessna 140 · Miller, SDThe acft ground-looped during the plt's first solo landing & the right main landing gear sheared off. The CFI said the student had made between 30 to 40 landings prior to the solo flt.NTSB DEN84LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Barnard, SDDuring a landing in a soy bean field the acft encountered a soft muddy spot which caused the acft to nose over.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 DEN84LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Custer, SDThe acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy.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 DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…NTSB DEN84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Herreid, SDThe acft ran into a creek bed during an off arpt landing and the landing gear collapsed. The plt was conducting an aerial hunt of coyotes. After shooting one he sought a place to land to pick up the carcass and stated that although he inspected the area from…NTSB DEN84LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Yankton, SDThe plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…NTSB DEN84FA021Accident · Serious injuriesField investigationFinal reportConvair 580 · Sioux Falls, SDThe acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the…NTSB DEN84FTK01Accident · No injuriesFinal reportBaking Duce · Rapid City, SDThe acft ran off the left side of the rwy during landing and the left main landing gear collapsed. When the plt attempted to bring the acft back onto the rwy the gear hit the edge of the rwy. There was a 7 to 10 kt crosswind on rwy 14 at the time of the…NTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…NTSB DEN84FA008Accident · No injuriesField investigationFinal reportConvair 340/440 · Pierre, SDAfter landing at Pierre, SD, 2070 lbs of cargo was off-loaded from the aft section of the aft & a new wt & balance was calculated. The aircrew then prepared to takeoff in conditions of low ceiling & fog. The plt-in-command (PIC) initiated the takeoff roll,…NTSB DEN83LU005Accident · 1 fatalFinal reportEipper Quicksiver E (Modified) · Sioux Falls, SDAfter takeoff, the plt of the weight-shift controlled, ultralight vehicle entered a steep climb, then began a series of maneuvers which included past vertical wingovers. Reportedly, on his last maneuver, he performed a whip stall. A ground witness stated that…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 DEN83LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-25B-235 · Montrose, SDThe pilot stated that he was spraying a field that was divided in half by a 60 foot high powerline. As he made a turn to enter the south side of the field, parallel to the powerlines, flying east into the sun, he struck the unseen guy cables out in the field.…NTSB DEN83FTK04Accident · Serious injuriesFinal reportPiper PA-28-181 · Box Elder, SDBefore reaching his destination, the plt contacted apch control & reported that he was about 40 mi away & was low on fuel. About 10 min later, the acft ran out of fuel. The plt stated that he 'could possibly make ellsworth' but the controller told him that…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 DEN83LA187Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Wagner, SDThe plt reported that the eng began loosing power as he approached his destination. He elected to make an emergency landing on a road to investigate the problem. He stated that he made a stalled landing that caused the tailwheel to unlock & allowed the acft…NTSB DEN83LA165Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Interior, SDWhile on a sight-seeing flt over a park, the plt heard a loud noise & the helicopter shuddered & lost power. At that time, the acft was over a canyon, so the plt looked for the flatest area to land & began an autorotation. During the landing, the helicopter…NTSB DEN83LA164Accident · No injuriesLimited investigationFinal reportCessna T188C · Carthage, SDThe acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…NTSB DEN83LA159Accident · No injuriesLimited investigationFinal reportCessna 188B · Pierre, SDThe plt was making practice swath runs with a load of water. During the third turn, at about 100 ft AGL, the eng stopped, according to the plt. The acft then landed hard & cartwheeled. No eng malfunctions were found.NTSB DEN83LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Brandt, SDThe acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…NTSB DEN83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Red Owl, SDBefore the flt the student pilot had checked the fuel by the gages only and had not drained the fuel sumps. He thought he had enough fuel to fly from the ranch to the training school arpt to refuel. The engine quit at 100 ft AGL after takeoff. About 1-1/2…NTSB DEN83LA141Accident · No injuriesLimited investigationFinal reportCessna A188 · Leola, SDThe plt was using a gravel road, aprx 20 ft wide, for an aerial application operation. During takeoff, the acft swerved to the right, went into the ditch beside the road & was substantially damaged. The plt believed that the right wheel had become locked.…NTSB DEN83LA065Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Madison, SDThe aircraft collided with a snowbank 10 feet beyond the threshold during landing. After the accident the pilot reportedthat during the final approach to a landing on runway 32, the left main landing gear contacted a 2 foot high snowbank just beyond the…NTSB DEN83FTK03Accident · Serious injuriesFinal reportBeech V35A · Sioux Falls, SDDuring an ILS approach to rwy 3 the acft collided with 50 ft powerlines 3 mi sw of the arpt. The acft then collided witha mobile home & pickup truck. Half of the 60 ft mobile home & the truck were destroyed. Minimum altitude at the lim, located 5.2 mi from…