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 DEN90IA016Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Rapid City, SDThe inflight failure of the recirculating fan unit and several air duct temperature limiting sensors.NTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.NTSB DEN89LA176Accident · No injuriesLimited investigationFinal reportCessna 170B · Kyle, SDThe pilot used poor preflight planning & decision-making in selecting a road on which to land during gusty wind conditions which resulted in the failure to maintain direction control.NTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.NTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.NTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.NTSB DEN88LA208Accident · No injuriesLimited investigationFinal reportCessna 421B · Winner, SDThe private plt and 4 pax were attempting takeoff on rwy 13, a 3,900 x 30 ft asphalt rwy. The plt said the acft accelerated to 100 knots but he could not raise the nose for lift off. The plt said he aborted the takeoff and intentionally ground looped to the…NTSB DEN88FA186Accident · 2 fatalField investigationFinal reportLuscombe 8A · Dimock, SDThe plt was giving airplane rides to some neighbors from his private airstrip. He had just taken off with a new pax. A witness reported observing the acft skimming close to the ground after liftoff, and then the acft climbed quickly. The acft then banked…NTSB DEN88LA183Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hoven, SDThe private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which…NTSB DEN88LA180Accident · No injuriesLimited investigationFinal reportBell 206B · Sturgis, SDThe plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump…NTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…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 DEN88LA145Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58J · Sioux Falls, SDN62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…NTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…NTSB DEN88LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Gettysburg, SDThe commercial plt and two passengers were flying to a fishing camp. During landing roll the plt applied brakes to turn off the runway. The nose got too FAR around and directional control was lost. The airplane ground looped to the left. The right wing, right…NTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…NTSB DEN88LA094Accident · No injuriesLimited investigationFinal reportAgusta A109A · Sioux Falls, SDNTSB DEN88LA035Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Newell, SDThe plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…NTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…NTSB DEN88FA016Accident · 3 fatalField investigationFinal reportBeech A-36 · Mitchell, SDThe acft had been cleared for the VOR approach at Mitchell municipal arpt at approx 1915 CST. The acft collided with the ground in a slight nose down attitude about 12 miles northwest of the arpt at the point where the procedure turn intersected the inbound…NTSB DEN87DTK01Accident · 1 fatalFinal reportBushby Mustang II · Aberdeen, SDWitnesses reported that they observed the acft perform two snap rolls. During the second snap roll something came off the aircraft and fell to the ground. The acft then became inverted and descended until impact with the ground. The acft impacted in a near…NTSB DEN87LA195Accident · No injuriesLimited investigationFinal reportCessna 182L · Aberdeen, SDThe plt was taking off on rwy 13 at Aberdeen, SD, muni arpt. He said when he reached 55 mph he rotated the acft and the stall warning horn sounded. He said he allowed the nosewheel to settle back on the rwy. The acft then veered right and left, then departed…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 DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.NTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…NTSB DEN87LA100Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9B · Wood, SDA commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.NTSB DEN87FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Stugis, SDThe plt agreed to ferry the acft for another plt who was not IFR rated & who had been forced to land at kadoka on the previous evening due to low fuel & apchg darkness. IMC prevailed thru-out the area. The commercial/ifr rated plt did not obtain a wx briefing…NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…NTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…NTSB DEN86LA176Accident · No injuriesLimited investigationFinal reportCessna T188 · Kimball, SDAccording to the plt, the acft he was piloting encountered unfavorable winds during the aerial application maneuver and stalled. The plt indicated that during the touchdown, the main gear collapsed and the acft was substantially damaged.NTSB DEN86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Onida, SDThe plt reported a partial loss of pwr occurred momentarily before liftoff. The takeoff was continued and once airborne the pwr loss reoccurred. The load was dumped, however, the acft impacted trees aprx 1 mile from the arpt as sufficient alt could not be…NTSB DEN86FTK03Accident · 1 fatalFinal reportPiper PA-25 · Badger, SDThe acft nosed over during a forced landing after takeoff. The acft was landed straight ahead and rolled out into a standing pool of water 8-10 inches deep where it flipped over crushing the canopy and trapping the plts body. During post acc invest sediment…NTSB DEN86LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDAccording to the plt, during maneuvering on a swath run, the acft he was piloting encountered a downdraft, forcing the acft down until contact with the ground.NTSB DEN86LA152Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sisseton, SDThe front seat plt, on his first flt in the acft, was flying the acft. After takeoff the acft entered a nose high attitude because the elevator trim was improperly set. The nose high attitude was corrected but the right door on the engine cowling came open…NTSB DEN86FTK02Accident · No injuriesFinal reportAero Commander Callair A-9B · Dell Rapids, SDThe plt stated that during the takeoff roll, he lost rudder effectiveness after accelerating to about 60 KTS. He applied brakes to stop, but the acft veered off the left side of the rwy & struck a fence. No preimpact part failure or malfunction was reported.…NTSB DEN86LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Pierre, SDPlt said that while in cruise flt eng loss power. Plt made forced landing on road and lost directional control. Acft struck ditch, fence, then overturned. Acft last refueled two days before and was flown for one hour. Plt did not service acft prior to…NTSB DEN86FTK01Accident · Serious injuriesFinal reportBellanca 7GCBC · Huron, SDThe acft contacted powerlines and descended uncontrolled to ground impact. The plt reported that he was checking fields when the accident occurred. The acft was traveling to the west into the setting sun when accident occurred.NTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…NTSB DEN86LA116Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Wall, SDAccording to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in…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 DEN86LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hayes, SDThe plt stated that during the uphill ldg on snow covered terrain, the acft crested the hill, then started downhill on the opposite side. According to the plt he was unable to stop the acft before reaching a cliff. The plt egressed the acft prior to it going…NTSB DEN86LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Buffalo, SDAccording to officials, the plt was searching for hunters when the acft he was flying contacted the ground. Witnesses stated that blowing snow, low overcast clouds & visibility of less than 1/2 mi prevailed at the time of the acdnt. A blood sample was taken…NTSB DEN86FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Chamberlain, SDThe plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact.NTSB DEN85FTK03Accident · No injuriesFinal reportCessna 152 · Tea, SDThe student & instructor plt (CFI) were practicing landings. After making 3 touch-&-go landings, the eng lost power at aprx 200 ft AGL as they were on their 4th takeoff. The CFI reported that he turned the acft about 25 deg in an attempt to glide to a bean…NTSB DEN85LTK02Accident · Minor injuriesFinal reportPiper PA-25-235 · Yankton, SDThe acft descended uncontrolled into the terrain after it contacted a power line during an aerial application flt. Witnesses reported the acft appeared to pull up at the west end of the 40 acre fld, however, it did not clear the lines and it nosed over into…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 DEN85FA180Accident · 4 fatalField investigationFinal reportHughes 369HS · Keystone, SDMain rotor hub was overhauled by a repair station that was not authroized by Hughes helicopters for hub overhauls. The main rotor hub and blades separated in-flt 279 hrs after overhaul. The acft crashed in a densily wooded area. Post accident exam of the main…NTSB DEN85LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Platte, SDWhile the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed.