NTSB investigations, SC

90 cases where the first occurrence was “Loss of control - in flight”.

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'
    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.

NTSB ATL92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150E · N.Myrtle Beach, SCThe ostentatious display of the Piper cub's pilot caused the accident airplane's pilot to loose control and crash.May 23, 1992 · N6209R · DestroyedNTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.Sep 13, 1991 · N4184L · Substantial damageNTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).Jun 21, 1991 · N36743 · DestroyedNTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.May 31, 1991 · N731EP · Substantial damageNTSB ATL91LA096Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Rock Hill, SCThe pilot diverted his attention to a poisonous snake in the cockpit and failed to maintain control of the aircraft.May 20, 1991 · N7507J · DestroyedNTSB ATL90LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Saluda, SCPilot's failure to properly plan for high density altitude operations, which resulted in settling with power to the ground.Jun 22, 1990 · N7448F · Substantial damageNTSB ATL90LA098Accident · 1 fatalLimited investigationFinal reportCessna 150H · N. Myrtle Beach, SCThe pilot's improper course reversal procedure which resulted in a stall at a low altitude precluding a recovery before water impact.Apr 16, 1990 · N22953 · Substantial damageNTSB CHI89FA157Accident · 1 fatalField investigationFinal reportCessna 152 · York, SCFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: excessive workload (task overload) and diverted attention.Aug 3, 1989 · N5292M · DestroyedNTSB ATL89FA182Accident · 3 fatalField investigationFinal reportCessna 172G · Ridgeland, SCImproper planning/decision by the pilot-in-command (PIC), which resulted in an inadvertent stall during takeoff. Factors related to the accident were: the excessive gross weight and improper lift-off by the PIC, the pilot/passenger's improper crew…Jul 20, 1989 · N4254L · DestroyedNTSB BFO89FA048Accident · 4 fatalField investigationFinal reportCessna 172P · Caesars Head, SCFailure of the pilot to maintain sufficient airspeed while flying over rising terrain, which resulted in an inadvertent stall and collision with wooded terrain. Factors related to the accident were: the terrain conditions and failure of the pilot to maintain…Jun 25, 1989 · N53667 · DestroyedNTSB ATL89FA157Accident · 1 fatalField investigationFinal reportCessna 150K · N. Myrtle Beach, SCThe pilot's confusion and diverted attention regarding the multiple banner release system in the cockpit resulting in an inadvertent stall/spin into the terrain from a low altitude. Also causal was the pilot attempting the abrupt maneuver at the low airspeed…Jun 3, 1989 · N6367G · DestroyedNTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…May 6, 1989 · N4985D · Substantial damageNTSB ATL88LA197Accident · Serious injuriesLimited investigationFinal reportAeronca 0-58B · Newberry, SCThe pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and…Jun 21, 1988 · N47190 · DestroyedNTSB ATL88FA150Accident · Minor injuriesField investigationFinal reportCessna 152 · Moncks Corner, SCApr 22, 1988 · N94251 · Substantial damageNTSB ATL88FA059Accident · 2 fatalField investigationFinal reportCessna 421A · Hilton Head Isl, SCAcft depted coastal arpt at night with 400 ft partial obscuration in patchy fog. Ground witnesses who heard acft depicted a circling flt path to the right after takeoff. Eng, prop & turbo teardowns demonstrated both engs were operating at high power & no…Dec 11, 1987 · N777RC · DestroyedNTSB ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…Oct 18, 1987 · N98806 · Substantial damageNTSB ATL87FA194Accident · Serious injuriesField investigationFinal reportPiper PA-18A-150 · No.Myrtle Beach, SCThe airplane was maneuvering at 350 ft AGL in preparation for a banner pick-up when it entered a spin and subsequently impacted trees and the terrain. The plt stated that he 'failed to fly the airplane' while attempting to deploy a banner tow line, and that…Jun 30, 1987 · N74815 · DestroyedNTSB ATL87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student plt was unable to recall anything about the acdt. A plt/a&p observing the t.o. stated that the acft lifted off and climbed to 50-60 ft. when a flock of black birds flew up into the path of the acft. The acft pitchedup, yawed slightly, turned about…Jan 13, 1987 · N757XP · Substantial damageNTSB ATL86LA184Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Little River, SCThe plt reported that the glider was violently rolled into a 90 left bank by strong crosswinds at about 250 ft AGL, while it was being towed aloft. The plt's cockpit canopy came open, and the plt attempted to close and secure it. The canopy came open again…Jun 26, 1986 · N302BG · DestroyedNTSB ATL86LMG06Accident · No injuriesFinal reportRussell Acro MR3 · Clio, SCThe plt reported that the home-built acft experienced a loss of aileron control during lndg. He continued the lndg, using the rudder and throttle to control the acft. The acft hit a tree-top adjacent to the rwy and crashed into a plowed field next to the…Apr 26, 1986 · N3MR · DestroyedNTSB ATL86LA112Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Orangeburg, SCDuring landing the student pilot lost directional control of the aircraft in a crosswind and ran off the side of the runway and into a drainage ditch.Apr 13, 1986 · N714DC · Substantial damageNTSB ATL86LA035Accident · No injuriesLimited investigationFinal reportCessna 182J · Bishopville, SCDuring an attempt to make a direct crosswind landing at a private grass airstrip, the plt allowed the acft to drift off the left side of the rwy where it nosed over in a plowed fld.Dec 6, 1985 · N2650F · Substantial damageNTSB ATL85FA242Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Abbeville, SCThe acft crashed into trees & the ground after going into a left turn during a go-around initiated after a bouncy landing. After power was added for the go-around the acft seemed to be uncontrolled so that the CFI on the ground, who had just exited the acft…Aug 9, 1985 · N7475W · DestroyedNTSB ATL85LA238Accident · No injuriesLimited investigationFinal reportEipper MX-2 · Greenville, SCWhile climbing altitude the parachute , which was secured to the right seat, was inadvertently deployed and became tangled in the propeller. The acft descended to the ground while inverted at a slow rate.Aug 3, 1985 · N3986K · Substantial damageNTSB 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…Aug 25, 1984 · N6771M · Substantial damageNTSB 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…Aug 22, 1984 · N9270R · DestroyedNTSB 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…Jul 20, 1984 · N5110F · Substantial damageNTSB 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…Jun 30, 1984 · N3JR · Substantial damageNTSB 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…Feb 2, 1984 · N6141N · DestroyedNTSB 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…Dec 25, 1983 · N7076V · DestroyedNTSB ATL84LA039Accident · 1 fatalLimited investigationFinal reportRand KR-2 · Greer, SCAccording to a witness, the plt began an apch to rwy 9, but made a go-around, then maneuvered to land on rwy 27. The witness stated that during the turn to final apch for rwy 27, the acft descended rapidly in a nose down attitude until it disappeared behind…Nov 6, 1983 · N25134 · DestroyedNTSB ATL83LA273Accident · Minor injuriesLimited investigationFinal reportCessna 305A · N. Myrtle Beach, SCThe acft stalled into an inland waterway shortly after takeoff for a banner towing flt. The pilot reported he had just refueled and made a takeoff. He was on the crosswind leg of the traffic pattern when the accident happened. He stated that he encountered…Jul 12, 1983 · N5172G · Substantial damageNTSB ATL83LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, SCThe acft nosed over during a forced landing after a stall during a low pass. The plt said he was flying around an islandat 500 ft AGL taking pictures when the acft began to settle. He added power and applied elevator back pressure. Then carburetor heat was…Jul 4, 1983 · N52471 · Substantial damageNTSB ATL83FU002Accident · 1 fatalFinal reportWizard J3 · Dovesville, SCReportedly, the owner/plt had purchased the ultralight acft on 4/21/83. His instructor stated that he (the plt) had received aprx 1 1/2 hrs of supervised taxi time, but had not flown the vehicle prior to the accident flt. On the day of the accident, the plt…Apr 7, 1983 · UNREG · DestroyedNTSB 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…Oct 15, 1982 · N9080T · DestroyedNTSB 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…Oct 3, 1982 · N70014 · DestroyedNTSB 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…Aug 19, 1982 · N1CJ · DestroyedNTSB 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…Jul 13, 1982 · N6234L · DestroyedNTSB 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…Feb 26, 1982 · CGMYL · DestroyedNTSB 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.Jan 29, 1982 · N1434Q · Destroyed