OpenAirDocs.org

NTSB investigations, 1987

616 cases where the phase of flight was Enroute.

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 = 400)
  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 NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…Dec 31, 1987 · N2243J · DestroyedNTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…Dec 30, 1987 · N2758F · DestroyedNTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…Dec 28, 1987 · N89126 · Substantial damageNTSB LAX88LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZDuring a cross country flt while cruising at 7500 ft MSL, the acft began to vibrate severely. The plt shut the engine down and landed without further incident. Inspection of the acft revealed that a section of one of the propeller blades had separated. The…Dec 28, 1987 · N4297F · Substantial damageNTSB FTW88DPA02Accident · No injuriesFinal reportCessna 150M · Gainesville, TXThe pilot lost engine power due to a throttle cable which failed during flight. He then made a 360 degree turn to lose altitude before initiating an emergency landing on an airport. He lost excessive altitude during the turn which resulted in an off-airport…Dec 27, 1987 · N63385 · Substantial damageNTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…Dec 26, 1987 · N83BC · Substantial damageNTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…Dec 25, 1987 · N6468S · Substantial damageNTSB LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…Dec 24, 1987 · N3009J · Substantial damageNTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…Dec 24, 1987 · N712AN · DestroyedNTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…Dec 24, 1987 · N6571R · DestroyedNTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.Dec 23, 1987 · N5433Y · DestroyedNTSB FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…Dec 23, 1987 · N736AN · Substantial damageNTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…Dec 20, 1987 · N4306J · DestroyedNTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…Dec 19, 1987 · N5123G · DestroyedNTSB LAX88FA071Accident · 2 fatalField investigationFinal reportBeech A35 · Chino Hills, CAFailure of both pilots to see and avoid each other and thus avert the collision.Dec 19, 1987 · N675B · 2 aircraft · DestroyedNTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…Dec 18, 1987 · N3702K · DestroyedNTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…Dec 15, 1987 · N400LA · DestroyedNTSB NYC88LA057Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Rome, NYThe flight was enroute from watertown to glens falls, new york when snow squalls of varying intensity and gusty wind conditions were encountered. The pilot stated that forward visibility was marginal. The engine failed shortly after changing heading towards…Dec 15, 1987 · N74085 · DestroyedNTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…Dec 15, 1987 · N2138J · DestroyedNTSB ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…Dec 12, 1987 · N3632W · DestroyedNTSB MIA88LA060Accident · No injuriesLimited investigationFinal reportMooney M20J · St Theresa, FLWhile in cruise flt at 3000 ft south-southeast of st. Theresa, FL over the gulf of Mexico, the plt reported a total loss of power. Attempts to restart were unsuccessful. The acft was then ditched aprx 11 nautical miles & 146 degrees from st. Theresa, FL, near…Dec 11, 1987 · N4324H · DestroyedNTSB ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…Dec 11, 1987 · N9979M · Substantial damageNTSB MKC88FA026Accident · Serious injuriesField investigationFinal reportVarga 2150A · Conroe, TXThe pilot took off for a short flight without being sure of his fuel quantity. He was not able to locate his destination which was 32 NM from his departure airport. The engine stopped and the pilot attempted a forced landing. During the forced landing, the…Dec 10, 1987 · N4VK · DestroyedNTSB DEN88FA128Accident · 2 fatalField investigationFinal reportCessna 177RG · Afton, WYThe acft was not certified nor equipped for flt into icing conditions. The plt elected to depart even though he was advised by the crew of a C-182 that had just lndd to stay below the clouds because of icing. After tkof the acft cleared an 11000 ft mtn range…Dec 10, 1987 · N1868Q · DestroyedNTSB MIA88LA057Accident · No injuriesLimited investigationFinal reportBeech E-18S · Natchez, MSThe two acft were registered to the same person & the pilots were friends of each other. The acft departed from the same airport at about the same time & were bound for the same destination on an IFR flt plan, N24JE at 8000 ft, N492DM at 4000 ft. later both…Dec 9, 1987 · N24JE · 2 aircraft · Substantial damageNTSB ATL88FA056Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Anniston, ALThe VFR pilot continued the flight into deteriorating weather conditions and attempted to descend below the lowering clouds until the aircraft was too low to turn around safely and return to VFR flight conditions. The aircraft collided with trees and struck…Dec 9, 1987 · N15629 · Substantial damageNTSB DCA88MA008Accident · 43 fatalMajor investigationFinal reportBritish Aerospace BAE-146-200 · San Luis Obispo, CAA recently discharged usair employee boarded psa flt 1771 after having left a goodbye message with friends. He bypassed security and carried abd a borrowed 44 caliber pistol. A note written by this psgr, found in the wreckage, threatened his former supervisor…Dec 8, 1987 · N350PS · DestroyedNTSB SEA88LA029Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 MK1 · Metlakatla, AKOn final approach for landing the aircraft encountered high gusting winds. The aircraft then stalled and entered a nose down attitude. Accordng to one passenger the pilot was holding full aft elevator during the descent. The aircraft struck the water hard,…Dec 7, 1987 · N17597 · Substantial damageNTSB NYC88FA051Accident · 1 fatalField investigationFinal reportCessna 310R · Hector, NYThe pilot made a routine IFR position report 12 minutes prior to the accident. Witnesses observed an 'orange ball' before the crash. Evidence at the crash site showed inflight jettison of the pilot's emergency window, positive aerodydnamic overload separation…Dec 7, 1987 · N5052J · DestroyedNTSB SEA88IA028Incident · No injuriesIncident investigationFinal reportCanadair CL600-2A12 · Twentynine Plms, CAThe water filter housing lower seal was mis-installed which allowed water to seep out and run down the housing case. Over time the water dropped onto a lavatory drain line, followed the line to a low point & collected on the stab aug computer box. The fluid…Dec 6, 1987 · N125PS · No damageNTSB MKC88FA023Accident · 2 fatalField investigationFinal reportCessna 180 · Springfield, NEAccording to witnesses on the ground, the aircraft was flying low, under the overcast, when the left wing struck the guy wires of a tv tower and the plane crashed out of control. It was destroyed by impact forces and a post-crash fire. Weather stations in the…Dec 6, 1987 · N46TD · DestroyedNTSB ATL88FA055Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Lagrange, GAPlt lost power in cruise, in day, VMC. Made apch to interstate hwy I85. Hit overpass support column at 15 feet AGL. Engine overhauled 51 hours before accident. Overhaul records indicated magneto repair. Annual insp records indicated compliance with AD…Dec 6, 1987 · N5587J · DestroyedNTSB NYC88FA050Accident · No injuriesField investigationFinal reportBoeing 737-2B7 · Deptford, NJDrg tkof, as usair flt 224 was clbg thru 4000', the acft yawed/rolled rgt. Simultaneously, the crew noticed the #2 throttle slam/lock to the idle psn & a continuous airframe buffet began. Soon thereafter, the #2 eng sepd fm the acft & the buffet stopped. The…Dec 5, 1987 · N319AU · Substantial damageNTSB LAX88LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Dunsmuir, CAA Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather…Dec 5, 1987 · N123JY · DestroyedNTSB CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.Dec 5, 1987 · N7533G · Substantial damageNTSB ATL88MA053Accident · 2 fatalMajor investigationFinal reportHawker Siddeley HS-125-400A · Lexington, KYWhile en route at FL 370, the plts declared an emerg, rprtd a fire in the rgt eng & reqd vectors to the nearest suitablearpt. They were vectored twd the Lexington bluegrass arpt & clrd to dscnd. Shortly after declaring an emerg, the plts rprtd they secured…Dec 5, 1987 · N400PH · DestroyedNTSB NYC88LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Houlton, MEDuring a personal transportation flight to quebec city in Canada and while cruising at about 6500 feet, the aircraft experienced an oil pressure light illumination, 43 nautical miles nnw of Houlton VOR on a 306 degree heading. The engine then started to run…Dec 4, 1987 · CGRQU · DestroyedNTSB FTW88DPA01Accident · No injuriesFinal reportBell 206B · Dallas, TXThe fuel pump warning light came on and the pilot headed for a local airport. Enroute, the engine surged and flamed out. During the landing, the rotor blades hit trees, and the helicopter made a hard landing. The fuel gage indicated 11 gallons. Later the gage…Dec 4, 1987 · N206DW · Substantial damageNTSB ATL88FA052Accident · Serious injuriesField investigationFinal reportPiper PA-60-600 · Mansfield, OHThe pilot departed louisville, KY reportedly with a known oil leak in the right engine and was on the second leg of an on-demand air taxi cargo flight. About 14 minutes after entering Mansfield approach control airspace, the pilot requested and received an…Dec 4, 1987 · N500TS · DestroyedNTSB MIA88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Antonio, FLThe student plt became lost while on a solo x-c training flt. He attempted to contact his non control tower destination airport via UNICOM. He stated that he flew around for 20 or 25 mins attempting to make UNICOM contact & was unsuccessful in doing so. He…Dec 2, 1987 · N2405F · Substantial damageNTSB LAX88DVG02Accident · No injuriesFinal reportGrumman G-164A · Williams, CAShortly after takeoff, the engine experienced a loss of engine power. The pilot made a forced landing and collided with a fence on hilly terrain during the landing roll. The engine was inspected with no reported mechanical failures or malfunctions. Wx…Dec 2, 1987 · N673U · Substantial damageNTSB FTW88LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Mangum, OKAccording to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that…Dec 2, 1987 · N3888V · Substantial damageNTSB LAX88FA060Accident · 1 fatalField investigationFinal reportPiper PA-46 · Long Beach, CAPilot's failure to land the aircraft after experiencing the pilot's faulty decision was his previous experience with a gear up landing a couple of years before.Nov 30, 1987 · N4369V · 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 NYC88LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · E.Harwich Port, MAThe pilot departed chatham airport for a local pleasure flight. Shortly after takeoff and while turning left in the pattern, the engine suffered a power loss. The pilot prepared for an emergency landing and transmitted a 'may day'. The aircraft crashed in a…Nov 28, 1987 · N9714J · DestroyedNTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…Nov 28, 1987 · N201CQ · Substantial damageNTSB CHI88LA031Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, ILEarlier in the day, the acft was flown from Danville to rochelle, IL. While on a return flt without refueling, the eng began losing power, so the plt moved the fuel selector to the rgt tank (which indcd 1/4 full) & power was restored. However, about 2 min…Nov 28, 1987 · N5611P · Substantial damageNTSB LAX88LA062Accident · No injuriesLimited investigationFinal reportBeech P35 · Maricopa, CADuring a pleasure cross country flt, a precautionary landing was made due to smoke in the cockpit and a low oil pressure indication. After landing, it was found that the oil line to the oil pressure gauge was broken. After repairs, the plt took off and 10…Nov 27, 1987 · N413EE · Substantial damageNTSB BFO88FA008Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Willis, VAThe acft was on a night IFR flight at 7000 ft MSL in IMC when the plt reported the directional gyro was inoperative. The acft was outbound from the pulaski VOR on V45 headed southeast. The plt further reported the turn&bank and the mag compass were operative.…Nov 27, 1987 · N4832S · DestroyedNTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…Nov 27, 1987 · N4056Y · Destroyed