NTSB investigations, SC
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\" = 'SC' 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" = 'SC' 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 ATL85LA166Accident · No injuriesLimited investigationFinal reportSchweizer SGS-233 · Chester, SCThe instructor pilot cut loose from the tow plane at 200 ft AGL during takeoff to simulate a rope break. The acft collided with trees while circling to land. CFI stated that student plt was too slow in returning to land on the rwy.NTSB ATL85LA152Accident · No injuriesLimited investigationFinal reportCessna 305A · No.Myrtle Bch, SCAfter a banner pickup the plt was instructed by company group and crew to release the banner due to a fouled pickup. The banner was released during a steep climb out altitude. As the banner was released the plt lost directional control of the acft & crashed…NTSB ATL85LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Hilton Head, SCThe plt stated that the landing gear selector was placed in the down position while on downwind for ldg & upon touchdown the landing gear collapsed. Post crash examination of the landing gear failed to disclose any mechanical failure or malfunction of the…NTSB ATL85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Columbia, SCThe plt stated that during takeoff the right main gear struck a large dog which ran onto the rwy. The takeoff was continued & the plt circled the arpt for 2 hrs to burn off excess fuel before performing a ldg with the nose gear & the left main ldg gear…NTSB ATL85LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Saluda, SCThe plt attempted a takeoff with the carb heat in the 'on' position. According to the plt, during initial climb the acft lost power and he was unable to maintain altitude. The plt made a forced landing in a pasture about 1 mi. From the airport.NTSB ATL85LA110Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rock Hill, SCDuring a VFR flt, the plt reported a severe vibration in the airframe. Pwr was reduced in an attempt to lessen the vibration and shortly thereafter, a total loss of pwr was experienced and the plt established a glide to the nearest landing area. During the…NTSB ATL85LA100Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Hilton Head, SCAcft stalled & crashed from an altitude of about 300 ft. witnesses stated that the acft entered a steep clumb angle upon lift off and climbed to about 300 ft. then the acft nosed over & fell to the ground.NTSB ATL85LA099Accident · Minor injuriesLimited investigationFinal reportGulfstream AA-5 · Ridgeland, SCApprox 3.75 hours after takeoff the plt contacted savannah approach and requested a straight in approach to land at savannah airport because of low fuel. Moments later the engine lost power and the plt made a forced landing in a field 10 miles NE of savannah…NTSB ATL85LA092Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Charleston, SCPlt making practice coupled ILS apch in VMC. Intercepted localizer outside the outer marker. Held the gear,intending to lower them at om. Continued inbd to dh where he resumed manual control. Observed gear warning lt and heard aural gear warning but failed to…NTSB ATL85MA049Accident · 1 fatalMajor investigationFinal reportBeech 58 · Charleston, SCPlt descended below mda during a night VOR (non-precision) apch to an uncontrolled arpt and collided with trees & groundwhich were obscured by fog. The plt had 'pushed' himself to make the trip according to friends and associates in an attempt to win an…NTSB ATL85LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 500 · Florence, SCThe acft crashed short of the rwy after both engines lost power on the base leg. Th acft hit about 200 ft short of the rwy and slid through the fence onto the rwy destroying about 4 rwy lights. Investigation disclosed that the left fuel strainer drain was…NTSB ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…NTSB ATL85LA033Accident · No injuriesLimited investigationFinal reportCessna 182RG · Charleston, SCPilot landed the aircraft with the landing gear in the up position. Examination of the landing gear after the accident revealed no evidence of mechanical malfunction or failure that would have prevented normal gear operation.NTSB ATL85LA006Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Abbeville, SCRight main tire blew during a hard landing. Plt applied left brake and rudder but acft continued off right side of rwy. Acft skidded across a pile of debris which initiated a flash fire in the underbrush. The right main gear assembly was broken from the acft…NTSB ATL84FA298Accident · 1 fatalField investigationFinal reportBeech V35B · Mc Cormick, SCN6740Z, a Beech V35B acft,separated in flt over mccormick, SC while operating in VFR conditions. The investigation failed to locate witnesses who observed the flt prior to & during the inflight separation. Witnesses on the ground heard the acft & observed…NTSB ATL84LA294Accident · No injuriesLimited investigationFinal reportHughes 269B · Saluda, SCThe acft crashed during an attempted practice autorotation after power was applied to effect a recovery. The CFI, on theflt, stated that he noticed that the student was going to overshoot and instructed him to make a power recovery at 100 ft AGL. He said that…NTSB ATL84LA281Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cheraw, SCAccording to the plt, after 100 to 150 ft of landing roll the right main landing gear collapsed.NTSB ATL84LA279Accident · No injuriesLimited investigationFinal reportBeech 58 · Laurens, SCThe acft ran off the end of the rwy during landing. The plt reported that he started using brakes to stop the acft but it veered to the right. Examination by maintenance revealed that the left brake disc, p/n 164-06100, had failed at the mount flange.NTSB ATL84LA270Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Reidsville, SCThe accident occurred on a low approach to a sloping airstrip with power lines at the uphill end. A go-around was commenced from a low pass, but insufficient climb performance was available, and a pull-up to clear the obstruction resulted in a stall/mush into…NTSB ATL84FA268Accident · 1 fatalField investigationFinal reportCessna A188B · Eastover, SCThe acft collided with the ground during a turn-around. The hopper dump valve on the acft was found closed after the accident. The fuel tanks were reportedly full (54 gallon capacity) and 120 gals of benlate, a non-toxic liquid herbicidehad been loaded aboard…NTSB ATL84LA261Accident · No injuriesLimited investigationFinal reportCessna A188B · Kingstree, SCThe acft ran into high vegatation during a precautionary landing after the plt heard a vibration which began aprx 2 hrs after the initial takeoff. The vibration was caused by a loose wing fairing. Examination of the acft revealed that a screw stripped out of…NTSB ATL84LA259Accident · No injuriesLimited investigationFinal reportCessna 210L · Conway, SCThe acft crashed into trees and after a loss of power during final apch. Plt reported the acft had 70 gallons of avgas onboard at departure from Conway, SC, at 0900 EDT. The proposed flt from Conway to florence, SC, and back to Conway was a distance of 72 NM.…NTSB ATL84LA249Accident · No injuriesLimited investigationFinal reportCessna 150J · Leesville, SCThe pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over.NTSB ATL84LA238Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Hartsfield, SCThe plt said he smelled an electrical fire while spraying. He elected to land but before he could the engine quit. A forced landing was made in a cornfield. The acft burned. The fire origin was not located in the totally burned wreckage.NTSB ATL84LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172F · John'S Island, SCDuring a solo flt, the student flew to a local arpt to practice takeoffs & landings. After his last landing (on rwy 9), he elected to make a x-wind takeoff on rwy 21. During the takeoff, the acft began drifting left at about lift-off speed. The student…NTSB ATL84LA224Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · No.Myrtle Beach, SCWhen the plt extended the gear, the landing gear motor circuit breaker (c/b) popped. He reset the c/b & after a cool down period attempted to extend the gear again, but with the same results. The plt was not able to extend the gear fully down & locked with…NTSB ATL84LA223Accident · No injuriesLimited investigationFinal reportBeech 58 E · Sumter, SCAfter a long work day the pilot forgot to extend his landing gear at his destination airport and landed gear up. The pilot reported he has not slept well on the night before the accident and that his attention was diverted by another acft landing ahead of him.NTSB ATL84FA222Accident · No injuriesField investigationFinal reportPiper PA-32R-300 · Rock Hill, SCThe acft was destroyed in a post flt fire after a forced landing at night in a private yard. The engine had surged and lost power during the descent through 4500 ft prior to landing. The acft had been written up for sluggishness and lack of response to…NTSB ATL84LA213Accident · 1 fatalLimited investigationFinal reportCessna 172N · Summerville, SCA witness observed the aircraft as the pilot attempted a downwind takeoff. The takeoff roll was longer than normal. The aircraft was observed to become airborne about 2000 ft down the rwy. The aircraft never established a positive rate of climb but the nose…NTSB ATL84LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Summerville, SCThe acft touched down 1500 ft past the approach end of the 4000 ft wet sod rwy. 10 degrees of flaps were used. Brakes were applied but at 3000 ft down the rwy the plt realized he would be unable to stop the acft before it collided with a deep ditch at the end…NTSB ATL84LA205Accident · No injuriesLimited investigationFinal reportSikorsky CH-19E · Iva, SCThe helicopter was being operated from sloping terrain. After returning from a spray mission, the plt remained inside the helicopter with the eng & rotor at ground idle while the ground crew refilled the spray tank. After completing the loading operation, the…NTSB ATL84LA204Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Manning, SCThe plt entered a steep turn at the end of a 2nd field that she had selected for a landing. While maneuvering to land, the right wing contacted the ground & the left wing hit a power line. This was the plt's 1st tow & release in this model.NTSB ATL84LA167Accident · No injuriesLimited investigationFinal reportCessna 188B · Paxville, SCThe acft nosed over short of the rwy after the engine failed to respond to the plts attempt to add power to reach the rwy. It was found after the accident that the carb heat control door brackets were worn which allowed the butterfly valve door to separate…NTSB ATL84LA152Accident · No injuriesLimited investigationFinal reportBeech E55 · Charleston, SCAfter the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll.NTSB ATL84LA145Accident · No injuriesLimited investigationFinal reportGrumman G164A · Huger, SCThe aerial application acft was using a gravel surfaced dirt road as a temporary landing strip. During the landing roll the acft drifted to the left & hit a soft spot, a tree, & nosed over in a ditch.NTSB ATL84LA142Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Hilton, SCThe acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…NTSB ATL84LA140Accident · No injuriesLimited investigationFinal reportCessna 172N · Winnsboro, SCThe acft was making a precautionary landing because the fuel guages were indicating 'empty'. Following touchdown the pltsaw a barbed wire fence and attempted a go-around & struck the fence. After making ground contact a second time the acftcontinued through…NTSB ATL84LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Newberry, SCThe plt had executed a go-around from an approach to rwy 4 due to a crosswind & gusty wind conditions. While on downwindhe observed that the wind was favoring rwy 10. He overshot the approach end of rwy 10 & executed another go-around. Upon observing that he…NTSB ATL84LA120Accident · No injuriesLimited investigationFinal reportBeech 99 · Myrtle Beach, SCThe acft was landed with the landing gear up. The plt said that the sun was shining on the instrument panel and he thought he saw 3 green lights. After the acft stopped on the rwy the red light in the gear handle was on and the warninghorn was sounding. He…NTSB ATL84FA115Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Spartanburg, SCThe acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep…NTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…NTSB ATL84LA094Accident · No injuriesLimited investigationFinal reportBeech F33A · Marion, SCThe plt stated he was involved in a discussion with the company president, who was on board, during the landing apch and he failed to use the checklist. The acft was landed gear up. It was later determined the gear up warning horn was inop.NTSB ATL84FA090Accident · 4 fatalField investigationFinal reportBeech 23 · Loris, SCThe estimated time of takeoff was about 1930 EST. The route of flt before 2000 EST was not known. At aprx 2005, the plt reported that he was unsure of his position. Shortly after that, the acft was identified over a military firing range. The plt was vectored…NTSB ATL84FA084Accident · 4 fatalField investigationFinal reportRockwell 690B · Greenville, SCAs the plt was making an ILS approach in IMC weather, the acft descended into trees & crashed about 1-1/2 mi from the rwy threshold. The descision height for this approach was 1316 ft MSL & was located less than a mile from the threshold.a controller said…NTSB ATL84FA075Accident · 4 fatalField investigationFinal reportMooney M20F · Clemson, SCThe acft crashed in a wooded area about 15 miles from its destination but about 16 miles north of a straight line between gainesville, ga and anderson, SC. One witness about 5 miles from the site saw an acft just before the time of the crash flying at about…NTSB ATL84LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Spartanburg, SCThe acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.NTSB ATL84LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student plt reported he picked up a slight crosswind during his descent for landing. The acft touched down on the main landing gear wings level, started to veer left & did not respond to right rudder pressure. The plt applied max braking but the acft ran…NTSB ATL84LA066Accident · No injuriesLimited investigationFinal reportCessna P206A · Charleston, SCThe acft undershot the rwy during landing. The weather was VMC but the landing was made one hour after official sunset. Visibility was reported as 10 miles. There were no problems reported with the arpt or acft except the plt during one radio call saying he…NTSB ATL84FA061Accident · Serious injuriesField investigationFinal reportCessna 210A · Columbia, SCThe acft collided with a wall during a downwind forced landing. The engine had quit at 200 ft after takeoff. The plt turned right with the gear up. He landed on a football field and bounced down a track field into a fence and wall. When the engine was…NTSB DCA84AA008Accident · Serious injuriesFinal reportLockheed L-1011 · Charleston, SCDuring flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of…