OpenAirDocs.org

NTSB investigations, 1987

357 cases where the phase of flight was Maneuvering.

Cases per year

19622026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
  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 LAX88DUQ03Accident · Serious injuriesFinal reportRolladen-Schneider LS-3 · Santa Ynez, CADuring a pleasure flight, the left wing of the glider struck a tree and collided with the terrain during a left turn in sinking air. The plt stated that he was looking over his right shoulder at nearby traffic then turned to look forward into the hazy setting…Dec 27, 1987 · N75FE · DestroyedNTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…Dec 24, 1987 · N7005S · DestroyedNTSB NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…Dec 22, 1987 · N5571C · DestroyedNTSB ATL88FA066Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Monroe, NCReptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…Dec 17, 1987 · N9132H · DestroyedNTSB MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…Dec 13, 1987 · N3512A · DestroyedNTSB LAX88DVD01Accident · No injuriesFinal reportTexas Helicopter Wasp/M74L · Petaluma, CADuring an aerial application flight, while on the last pass, the aircraft struck a power line that became entangled in the rotor blades. The pilot was unable to maintain control of the aircraft and collided with the terrain. There were no reported mechanical…Dec 11, 1987 · N51843 · Substantial damageNTSB ATL88LA054Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Sewanee, TNThe plt rprtd that he obtained a wx briefing before takeoff & that the wx at his intended destination was rprtd as marginal. While en route, he encountered wx and climbed above it. Aprx 4 hrs after departure, he became concerned about the remaining fuel…Dec 9, 1987 · N1999L · Substantial damageNTSB 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…Dec 6, 1987 · N2562Z · Substantial damageNTSB BFO88IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Baltimore, MDTwa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…Dec 5, 1987 · N924L · 2 aircraft · No damageNTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…Dec 1, 1987 · N2522L · Substantial damageNTSB BFO88FA009Accident · 1 fatalField investigationFinal reportCessna 182D · South Hill, VAThe plt was on the third leg of a trip between tampa, FL and sussex, NJ. The previous two stops were made because of adverse wx conditions. Before this flight he was advised by fss that VFR flight was not recommended. He filed a VFR flight plan but did not…Nov 30, 1987 · N8886X · DestroyedNTSB LAX88FA061Accident · 2 fatalField investigationFinal reportPiper PA-11 · San Marcos, CAThe 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…Nov 28, 1987 · N4767H · DestroyedNTSB FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…Nov 28, 1987 · N5934S · DestroyedNTSB MIA88FA044Accident · 1 fatalField investigationFinal reportCessna 172N · Palm Coast, FLThe student plt was flying the acft on a solo instructional flt in the north practice area & was assigned to practice landings, takeoffs, stalls & slow flt. Witnesses stated they observed the acft flying at a very low altitude just before it collided with a…Nov 24, 1987 · N246ER · DestroyedNTSB LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNov 22, 1987 · N42CR · DestroyedNTSB ATL88LA041Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Thomson, GAThe airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…Nov 22, 1987 · N7109L · Substantial damageNTSB MIA88FA042Accident · 2 fatalField investigationFinal reportCessna 152 · Okeelanta, FLThe acft crashed into a wildlife management area in a steep nose down attitude with about 20 degs flaps extended. The stated purpose of the flt was to spot deer & a suitable area in which to hunt. Torsional damage to the airframe suggested that the acft was…Nov 19, 1987 · N89741 · DestroyedNTSB DEN88LA026Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Albuquerque, NMWhile attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…Nov 19, 1987 · N1073N · DestroyedNTSB LAX88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.Nov 17, 1987 · N2973V · DestroyedNTSB LAX88FA047Accident · 2 fatalField investigationFinal reportCessna 152 · Bakersfield, CAThe recently rated private pilot and his passenger were flying low and waving to people on the ground. As the aircraft neared electrical service lines across its flight path ground witnesses observed it to enter an abrupt climb, roll left and dive into the…Nov 16, 1987 · N5478L · DestroyedNTSB LAX88FA045Accident · 2 fatalField investigationFinal reportCessna 441 · Mexicali, MexicoA Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…Nov 16, 1987 · N2484B · DestroyedNTSB NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…Nov 14, 1987 · N8318L · DestroyedNTSB LAX88LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Jamestown, CADuring a local sightseeing flight over a lake, the plt reported after circling for some time at a low altitude, the engine lost power. The plt made an emergency landing on the lake where the acft sank. Several days later, the acft was retrieved and the engine…Nov 12, 1987 · N7797X · Substantial damageNTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…Nov 10, 1987 · N65110 · DestroyedNTSB SEA88MA015Accident · 4 fatalMajor investigationFinal reportCessna 310N · Bellingham, WAThe acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did…Nov 5, 1987 · N4178Q · DestroyedNTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…Nov 4, 1987 · N8266U · DestroyedNTSB LAX88FA032Accident · 2 fatalField investigationFinal reportRobinson R22A · Moraga, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area.Nov 3, 1987 · N8475A · DestroyedNTSB NYC88DHA01Accident · 2 fatalFinal reportCouden Skybolt · Mansfield, NJWitnesses observed acft performing multiple aerobatic maneuvers. They said airplane was performing vertical maneuver or nearing top of loop when it entered an inverted flat spin. Rotation was stopped, but recovery incomplete when airplane crashed in a hay…Nov 1, 1987 · N341SB · DestroyedNTSB LAX88LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · San Jose, CAWhile flying 500-600 feet above the terrain on a local pleasure flight, the pilot turned into what he believed to be an open ended canyon. After becoming aware that he had inadvertently turned into a box canyon, the pilot attempted a 'chandelle turn' to exit…Oct 31, 1987 · N4771A · DestroyedNTSB LAX88FA065Accident · 2 fatalField investigationFinal reportBritten-Norman BN2A-26 · Desert Center, CAThe plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he…Oct 31, 1987 · N25MR · DestroyedNTSB DEN88LA017Accident · No injuriesLimited investigationFinal reportPiper J5A · Devils Lake, NDA commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the…Oct 31, 1987 · N32887 · Substantial damageNTSB CHI88FA012Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Lawrenceville, ILWhile performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at…Oct 31, 1987 · N41682 · DestroyedNTSB MIA88FA023Accident · 2 fatalField investigationFinal reportCessna 150E · Aguadilla, PRWitnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of…Oct 30, 1987 · N4081U · DestroyedNTSB LAX88LA025Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 369D · Borrego Springs, CAThe pilot and three passengers were flying at low altitude over mountainous terrain looking for big horn sheep. Thirty minutes into the flight the pilot heard a loud noise and the tail yawed left. The pilot turned away from the mountain to look for a place to…Oct 27, 1987 · N47861 · Substantial damageNTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.Oct 26, 1987 · N9787P · DestroyedNTSB LAX88FA023Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Red Bluff, CAThe pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.…Oct 25, 1987 · N8645V · DestroyedNTSB FTW88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Brownsville, TXWhile circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage.Oct 25, 1987 · N4045M · Substantial damageNTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…Oct 21, 1987 · N2754K · DestroyedNTSB FTW88LA008Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Lapra, TXUpon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly…Oct 20, 1987 · N8403E · Substantial damageNTSB LAX88LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Carpenteria, CAThe pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses…Oct 19, 1987 · N11176 · DestroyedNTSB FTW88DQG02Accident · Serious injuriesFinal reportAir Tractor AT-301 · Lockney, TXAfter completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude.Oct 19, 1987 · N73127 · 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 ANC88FA011Accident · 3 fatalField investigationFinal reportPiper PA-18 · Homer, AKThe weather between Homer and anchorage included marginal conditions along segments of the route. The airline transport rated pilot was encouraged to take advantage of an offer to travel by automobile and still arrive in time for a commitment in anchorage. He…Oct 18, 1987 · N4193Z · Substantial damageNTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…Oct 17, 1987 · N49694 · DestroyedNTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…Oct 17, 1987 · N230WF · DestroyedNTSB LAX88FA016Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Buena Park, CAWhile depg on an IFR flt to VFR conds, the plt failed to provide the correct transponder code per ATC clnc. The local controller (ctlr) reminded him to set the correct code & the plt subsequently replied 'I'm having a problem right now . . . I've got to get…Oct 17, 1987 · N43551 · DestroyedNTSB LAX88DXQ01Accident · Serious injuriesFinal reportPugh LONG-EZ · Newell, CABefore taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at…Oct 17, 1987 · N38EZ · DestroyedNTSB LAX88FA015Accident · 3 fatalField investigationFinal reportDassault-Breguet DA 10 · Rancho Murieta, CAIn flight loss of control by the pilot flying while performing an intentional low level aerobatic maneuver.Oct 15, 1987 · N121FJ · DestroyedNTSB ATL88DKG01Accident · No injuriesFinal reportCessna 188 · Samson, ALThe plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter…Oct 15, 1987 · N731RF · Substantial damageNTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…Oct 14, 1987 · N22553 · Substantial damage