NTSB investigations, 1987, SC

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 per year

19642026
NTSB investigations, 1987, SC per year, 1964–2026: 1,853 cases
196446
196541
196658
196749
196862
196939
197051
197142
197258
197343
197449
197551
197639
197744
197856
197928
198029
198132
198252
198340
198435
198536
198625
198735
198841
198927
199023
199120
199231
199324
199430
199532
199619
199728
199828
199926
200019
200113
200221
200322
200420
200522
200617
200715
200820
200929
201019
201121
201221
201313
201413
201512
201615
201712
201821
201918
202013
202122
202221
202321
202410
202519
202615

Latest cases

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 year(c.\"eventDate\") = 1987
    AND 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.

NTSB 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 ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…Nov 30, 1987 · N4463W · DestroyedNTSB ATL88LA028Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Beaufort, SCThe airplane engine lost pwr at cruise and the plt made a forced lng in a salt-water marsh. Investigation revealed that the plt was ferrying the acft to another arpt to have maintenance performed on the fuel selector valve, which was stuck in the aux tank…Nov 5, 1987 · N78169 · Substantial damageNTSB ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…Oct 21, 1987 · N94126 · Substantial damageNTSB 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 ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.Oct 14, 1987 · N5117B · Substantial damageNTSB ATL88FA010Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, SCThe plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted…Oct 12, 1987 · N84430 · DestroyedNTSB ATL88DMG01Accident · 1 fatalFinal reportRogers-Gibson 1 · Bennettsville, SCThe homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near…Oct 11, 1987 · N111MJ · DestroyedNTSB ATL88LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Cordesville, SCThe airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…Oct 6, 1987 · N11838 · Substantial damageNTSB ATL88IA074Incident · No injuriesIncident investigationFinal reportMooney M-20E · Columbia, SCDuring takeoff the propeller studs failed and the propeller departed the acft. FAA incident rpt stated that propeller had been overhauled and replaced 32 hours prior to the separation. Metallurgical exam of the propeller studs revealed fatigue failure of the…Oct 6, 1987 · N1936Y · Minor damageNTSB ATL88LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Hilton Head, SCThe student plt was performing a crosswind landing which resulted in a hard landing. The acft drifted to the side of the rwy and one wheel was off the paved surface upon the next touchdown. The student plt attempted to hold the acft straight in the direction…Oct 3, 1987 · N66090 · DestroyedNTSB ATL87FA257Accident · 2 fatalField investigationFinal reportBeech V-35B · Hilton Head, SCPIC said he had wx brief. Noted tstms ovr atlantic & fog at arpt. Stated he would hold ovr ocean until arpt clr. Acft track on radar was into area of tstms ovr ocean followed by mode c altitude deviations and loss of radar contact. Acft recovered from ocean.…Sep 1, 1987 · N6591S · DestroyedNTSB ATL87LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCAfter about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage…Aug 30, 1987 · N6094Z · Substantial damageNTSB ATL87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Edmund, SCThe CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…Jul 22, 1987 · N45648 · Substantial damageNTSB ATL87LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Greenville, SCBalloon dtpted launch site about six miles sw of landing airport for a key grab during a Balloon ralley. Wind was about seven KTS according to PIC. Approaching field to land basket was dragged through tree tops to slow Balloon. Power line hidden by the trees…Jul 3, 1987 · N7420U · Minor 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 ATL87LA192Accident · No injuriesLimited investigationFinal reportNavion H · New Ellenton, SCPreviously, the acft had been involved in a gear-up lndg & was out of svc while it was being repaired. Drg that time the annual inspn expired. A special airworthiness certificate was obtained to ferry the acft to the sizemore arpt for the annual inspn. Drg…Jun 28, 1987 · N2525T · Substantial damageNTSB ATL87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Belton, SCThe pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface…Jun 22, 1987 · N8105X · Substantial damageNTSB ATL87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft encountered a strong downdraft in a thunderstorm and impacted the water during a beachside banner towing operation. The plt reported that he had observed thunderstorms developing inland about 1/2 hr prior to the accident and that his acft was…Jun 19, 1987 · N6078Z · Substantial damageNTSB ATL87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCEngine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on…Jun 6, 1987 · N2846N · Substantial damageNTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…Jun 3, 1987 · N1859A · Substantial damageNTSB ATL87FA147Accident · 1 fatalField investigationFinal reportHiller UH-12D (H23) · Spartanburg, SCDuring a local pleasure flight above the treetops, the passenger reported that they heard a loud 'pop' over the sound of the engine. The plt told her that they were going down and she noticed the main rotor blades began to turn slower than usual before the…May 24, 1987 · N6408 · DestroyedNTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…May 16, 1987 · N739QF · DestroyedNTSB ATL87LA133Accident · No injuriesLimited investigationFinal reportBeech E-55 · Spartanburg, SCThe plt reported that he lowered the ldg gear and observed a down-and-locked indication on the ldg gear position light on final appch. During rollout, he felt a severe vibration in the nose gear and pulled back on the yoke in an attempt to reduce it. He then…May 6, 1987 · N713DM · Substantial damageNTSB ATL87LA129Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe aircraft landed with the landing gear in the up position when the pilot inadvertently failed to extend the gear. He had disarmed the landing gear warning system by pulling the system circuit breaker because it was activating at normal power settings. He…Apr 29, 1987 · N3240Y · Substantial damageNTSB ATL87LA128Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Greenville, SCThe pilot was doing touch and go's to become familiar with his new aircraft. On the fifth landing the aircraft started a groundloop and he recovered by adding full power. On the next landing the aircraft again started a groundloop to the right, he added full…Apr 28, 1987 · N5670C · Substantial damageNTSB ATL87LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Greenville, SCThe plt reported he forgot to put the ldg gear down. He stated that he was practiciing a short field ldg with the power set at about 15 in. Hg map. He noted that the gear warning system does not function unless the power is at 12 in. Hg map or below. The plt…Apr 27, 1987 · N5824S · Substantial damageNTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damageNTSB ATL87IA114Incident · No injuriesIncident investigationFinal reportCessna 340 · Myrtle Beach, SCPlt initiated autoplt climb from 12000 to 16000 ft. plt heard a loud snapping noise. Acft pitched up and efforts of both front seat occupants were reqd to keep nose down. Plt stated trim stuck in full nose up position. Plt stated that when the acft approached…Apr 17, 1987 · N25RF · Minor damageNTSB ATL87LA113Accident · No injuriesLimited investigationFinal reportCessna 172 M · Ridgeland, SCThe plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was…Apr 12, 1987 · N9563V · DestroyedNTSB ATL87LA098Accident · No injuriesLimited investigationFinal reportMooney M20F · Winnsboro, SCThe acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…Mar 26, 1987 · N6990V · Substantial damageNTSB BFO87DIG02Accident · Serious injuriesFinal reportBoeing 727-200 · Charleston, SCThe flight encountered clear air turbulence at FL 350 during cruise flight. The pilot said he was aware beforehand of existing turbulent conditions. According to the plt the seat belt sign was on, the flight attendant and passengers were asked to be seated.…Mar 19, 1987 · XAHOH · No damageNTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…Feb 6, 1987 · N1013G · Substantial damageNTSB 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 ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…Jan 4, 1987 · N70493 · Destroyed