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 ATL83LA011Accident · No injuriesLimited investigationFinal reportTomcat MK68 · Cope, SCBefore starting his takeoff from a trailer, the pilot failed to insure that his helper had released the right rear tiedown chain. During lift-off, the helicopter raised the trailer about 2 to 3 ft before the chain. Broke. Simultaneously, the helicopter was…NTSB ATL83FA009Accident · No injuriesField investigationFinal reportBeech 58 · Allendale, SCAbout 30 min after departure, electrical equipment began to fail. The plt turned off the alternator & reset with no change. He then switched to the #1 regulator which did not correct the problem. While turning on downwind the gear handle was placed down & all…NTSB ATL83FA001Accident · 3 fatalField investigationFinal reportEagle C-7 · Piedmont, SCBalloon was inflated with difficulty because of gusty winds. Balloon did not have a skirt. During the flight which ended in the accident the balloon seemed to have trouble and during the final moments it was in a descent which ended with the envelope as a…NTSB ATL82FLG15Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Lockhart, SCThe aircraft was flown from charlotte, NC to daytona beach, FL, to sanford, FL without en route refueling. The pilot had previously planned to get fuel at sanford, but after landing there, he thought there sufficient fuel to return to charlotte. However, as…NTSB ATL82DA282Accident · No injuriesFinal reportBeech C33 · Walterboro, SCPilot was not aligned with runway and was too low. When power was added and turn made to align, aircraft collided with ground short of runway. No malfunction found.NTSB ATL82DA262Accident · No injuriesFinal reportGrumman AA5B · Darlington, SCWind shifted to tailwind as pilot was landing. He considered a go-around because of speed but thought he could stop. As he went off the end the wing collided with a tree.NTSB ATL82DA257Accident · No injuriesFinal reportBell 206L · Greenville, SCThe pilot reported that he was making an approach to a new helipad that was still under construction when he felt a severe vibration. After landing and shutdown, he discovered that the tail rotor had struck the glass cover of a heliport perimeter light.NTSB ATL82FLG14Accident · Serious injuriesFinal reportCessna 182B · Charleston, SCThe flight departed conway, Arkansas for a non-stop flt to Charleston. Approximately 4 to 5 miles from the airport at Charleston, with the runway in sight, the engine quit. The acft struck trees drg a forced landing on a power line right-of-way 2 miles short…NTSB ATL82DA249Accident · No injuriesFinal reportBeech V35B · Clemson, SCDuring arrival, the wind was reported to be from 070 degrees at 15 gusting 20 KTS. On final approach with full flaps, the speed was bled off for an intended full-stall landing. The pilot reported that just prior to touchdown, the wind shifted about 90 degrees…NTSB ATL82FLG13Accident · 1 fatalFinal reportSmith Miniplane · Swansea, SCThe pilot was on a pleasure flight to practice aerobatic maneuvers. He held a current certificate of waiver which authorized him to practice low level aerobatics below 1500 ft above the surface. Four known witnesses observed the aircraft pull up from a low…NTSB ATL82DA232Accident · No injuriesFinal reportCessna 150 · Horrell Hill, SCPilot making touch and go landings at private airstrip. After takeoff aircraft would not maintain altitude. Pilot made an emergency landing in a bean field. Aircraft flipped over. Pilot forgot to retract full flaps and carb heat was on during takeoff.NTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…NTSB ATL82DA219Accident · No injuriesFinal reportCessna 188 · Bishopville, SCThe pilot reported that as he was entering a field on his third swath, the aircraft collided with a single transmission line. The line was leading to the center of a cotton field. The pilot did not see the line. After contacting the line, the aircraft was…NTSB ATL82DA213Accident · No injuriesFinal reportSchweizer SGS-2-33A · Little River, SCDuring the landing roll, the left wing of the glider struck the left wing of another glider of the same make and model. The other glider, N1211S was being readed for a flight and was positioned with its left wing overlapping the runway. The pilot of N1211S…NTSB ATL82FA184Accident · 1 fatalField investigationFinal reportCessna 152 · Charleston, SCPlt made steep turn after takeoff & stalled. Acft came to rest on the arpt about 1500 ft from the point where the takeoff run was initiated & about 200 ft north of rwy 9. It was necessary for the plt to be airborne by 0700 in order for him to make his first…NTSB ATL82DA189Accident · No injuriesFinal reportBalloon Works Firefly 7 · Greenville, SCThe ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…NTSB ATL82DLG12Accident · No injuriesFinal reportBell-Cont 42G EL TOMCAT-MK5A · Oswego, SCThe purpose of the flight was to study cotton fields that the pilot had been assigned to spray in the near future. He stated that during a landing approach on a farm field road, a wasp landed on his left arm and started stinging. The pilot allowed the rotor…NTSB ATL82DA174Accident · No injuriesFinal reportCessna R182 · Abbeville, SCDuring flight, the pilot encountered adverse weather conditions and elected to make a precautionary landing at a nearby airport. He reported that he landed about 700 ft from the approach end of the runway at 70 knots, hydroplaned, and continued off the…NTSB ATL82DA172Accident · No injuriesFinal reportCessna 402C · North Myrtle Be, SCThe pilot made a VOR approach to runway 05, but was unable to see well enough at the mda to land. He was informed that other aircraft had previously landed on runway 23 and had reported better visibility. The pilot then requested and was vectored for an ILS…NTSB ATL82DA165Accident · Minor injuriesFinal reportBeech A36 · Myrtle Beach, SCAs the pilot approached his destination, he descended from 9000 ft MSL and leveled at 1600 ft MSL. At about the time he leveled, the engine quit abruptly. He stated that he switched the fuel selector to the right tank and tried to start the engine, but was…NTSB ATL82DA149Accident · No injuriesFinal reportCessna T210N · Clemson, SCThe pilot stated that during landing roll he felt the effectiveness of the brakes diminish appreciably. As the end of the runway became visible he attempted to ground loop the aircraft but was unable to establish any significant rate of turn. The aircraft…NTSB ATL82FA140Accident · 2 fatalField investigationFinal reportCessna T210M · Holly Springs, SCPrior to departing new bern at 1837 the plt called his office & stated he had received a wx report for scattered thunderstorms along his route of flt. At 2020 & 2052 he contacted atl flt watch for wx advisories. He was advised that the wx radar was out of…NTSB ATL82DA132Accident · No injuriesFinal reportCessna 310 · Allendale, SCThe pilot reported that before landing, the landing gear indicators showed that all gear were down and locked. However, on the landing roll-out, the left main gear collapsed as the nosewheel was lowered to the runway. Subsequently, the left wing, left…NTSB ATL82DA118Accident · No injuriesFinal reportPiper PA-18A · Timmonsville, SCThe pilot reported that he reduced power at 1000 ft and applied carburetor heat for an extended glide to the sod strip. While on final approach over a wheat field, the airspeed bled off and he moved the throttle to add power. However, he reported that the…NTSB ATL82DA114Accident · No injuriesFinal reportCessna 172E · Society Hill, SCThe engine quit at 4000 feet and the pilot elected to land in trees rather than a road with traffic. The aircraft ended up on small gravel road with the gear collapsed. No fuel was found in the aircraft.NTSB ATL82FLG11Accident · No injuriesFinal reportPiper PA-34-200J · Columbia, SCAfter landing at night, the pilot was cleared to a parking area. A lineman with wands responded to assist. While attempting to follow the signals from the lineman, the pilot taxied into another aircraft.NTSB ATL82DA102Accident · No injuriesFinal reportPiper PA-31 · Clemson, SCDuring the preflight inspection the pilot noticed the hydraulically operated inboard main landing gear doors were open. Although realizing that they should be closed when the landing gear are fully extended, he pumped the doors up and taxied for takeoff.…NTSB ATL82DA084Accident · Minor injuriesFinal reportBeech 58 · Ridgeland, SCThe pilot stated that during landing, the left brake was inoperative. When he realized the problem, there was insufficient runway remaining to stop or go-around. At the end of the runway was a deep drop-off. Therefore the pilot used the right brake, and…NTSB ATL82DA077Accident · No injuriesFinal reportCessna 152 · Allendale, SCDuring a solo three hundred mile cross country flight the student pilot stated that he strayed to the south of his intended course. He subsequently became disoriented and after circling an area for about 30 minutes began to panic and elected to land. The…NTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…NTSB ATL82FA066Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Bradley, SCBefore takeoff, the pilot telephoned his brother in north carolina and asked about the weather. He was told that there was an overcast. The pilot replied that he would "come on and skirt the mountains." No flight plan was filed and there was no FAA record of…NTSB ATL82FA059Accident · 4 fatalField investigationFinal reportCessna 210L · Hilton Head, SCThe aircraft departed dulles international airport at 1630 EST, no flight plan was filed. The next radio contact with the aircraft was by beaufort marine corps air station approach control when the controller transmitted the altimeter setting and the pilot…NTSB ATL82DA056Accident · No injuriesFinal reportPiper PA-28-161 · Ridgeland, SCAfter touching down on the first 1/3RD of the 3100 foot runway the pilot stated that he lost his brakes. The aircraft went off the departure end of the runway down a 25 foot embankment and turned over. Examination of the wheel brake system including pushing…NTSB ATL82FLG10Accident · 1 fatalFinal reportCessna 150 · Darlington, SCWitnesses observed the aircraft performing aerobatic type of manuevers before entering a spin and crashing into a field. Although the pilot was known never to drink alcoholic beverages before flying, the pilot's blood alcohol level was 266MG/DL.NTSB ATL82DLG09Accident · No injuriesFinal reportCessna 152 · Grantiteville, SCThe pilot was unable to find the airport at his intended destination. He saw another airport and elected to land. A no-flap approach was made to rwy 24 with a north wind. The aircraft touched down about 500 feet from the departure end and then became airborne…NTSB ATL82FLG08Accident · No injuriesFinal reportMooney M-20J · Hilton Head, SCDuring takeoff at about 200 to 300 feet the engine malfunctioned and the pilot elected to make a gear up landing. Investigation revealed that the left wing fuel tank contained over a quart of water. Water and a red substance similar in appearance to tank…NTSB ATL82FLG07Accident · No injuriesClosedCessna P206 · Barnwell, SCNTSB ATL82FA025Accident · 1 fatalClosedBeech 24R · Greenville, SCNTSB ATL82FLG06Accident · Serious injuriesClosedPiper PA-23 · Hilton Head, SCNTSB ATL82FLG05Accident · Minor injuriesClosedCessna 152 · Clemson, SCNTSB ATL82FA024Accident · 2 fatalClosedCessna 210N · Rock Hill, SCNTSB ATL82FLG04Accident · No injuriesClosedPiper PA-32 · Columbia, SCNTSB ATL81FLG03Accident · No injuriesClosedCessna 152 · Hilton Head, SCNTSB ATL82FLG02Accident · No injuriesClosedCessna 310Q · Clemson, SCNTSB ATL81FLG01Accident · Minor injuriesClosedPiper PA-23 · Georgetown, SCNTSB ATL82DA010Accident · 1 fatalClosedPiper PA-28 · Myrtle Beach, SCNTSB ATL82FA008Accident · 3 fatalClosedBeech 55 · Rock Hill, SCNTSB ATL81FLG22Accident · Serious injuriesClosedBensen B8M · Lancaster, SCNTSB ATL81FLG21Accident · No injuriesClosedStarduster TWO · Blue Ridge, SCNTSB ATL81DLG20Accident · No injuriesClosedCessna 188 · Quinby, SC