# NTSB investigations, 1987: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 13 · 616 cases

## Latest cases

- [NTSB NYC88FA062](https://openairdocs.org/ntsb/NYC88FA062.md): Piper PA-32RT-300 · Burlington, VT · Accident · 4 fatal · Field investigation · Final report · Dec 31, 1987 · N2243J · Destroyed
  > Drg 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…
- [NTSB SEA88FA034](https://openairdocs.org/ntsb/SEA88FA034.md): Cessna 182J · Molalla, OR · Accident · 3 fatal · Field investigation · Final report · Dec 30, 1987 · N2758F · Destroyed
  > The 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…
- [NTSB MIA88LA077](https://openairdocs.org/ntsb/MIA88LA077.md): Cessna 152 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Dec 28, 1987 · N89126 · Substantial damage
  > En 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…
- [NTSB LAX88LA070](https://openairdocs.org/ntsb/LAX88LA070.md): Cessna 172 · Goodyear, AZ · Accident · No injuries · Limited investigation · Final report · Dec 28, 1987 · N4297F · Substantial damage
  > During 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…
- [NTSB FTW88DPA02](https://openairdocs.org/ntsb/FTW88DPA02.md): Cessna 150M · Gainesville, TX · Accident · No injuries · Final report · Dec 27, 1987 · N63385 · Substantial damage
  > The 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…
- [NTSB MKC88LA033](https://openairdocs.org/ntsb/MKC88LA033.md): Piper PA-28R-201T · Hays, KS · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N83BC · Substantial damage
  > During 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…
- [NTSB CHI88LA037](https://openairdocs.org/ntsb/CHI88LA037.md): Cessna 150H · Mt. Pleasant, WI · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1987 · N6468S · Substantial damage
  > The 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…
- [NTSB LAX88LA077](https://openairdocs.org/ntsb/LAX88LA077.md): Cessna 150E · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Dec 24, 1987 · N3009J · Substantial damage
  > During 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…
- [NTSB LAX88FA075](https://openairdocs.org/ntsb/LAX88FA075.md): Piper PA-31-350 · Maunaloa, HI · Accident · 8 fatal · Field investigation · Final report · Dec 24, 1987 · N712AN · Destroyed
  > The 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…
- [NTSB ATL88FA067](https://openairdocs.org/ntsb/ATL88FA067.md): Beech B23 · Crossville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 24, 1987 · N6571R · Destroyed
  > N6571R 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…
- [NTSB MIA88LA069](https://openairdocs.org/ntsb/MIA88LA069.md): Piper PA-23-250 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1987 · N5433Y · Destroyed
  > U.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.
- [NTSB FTW88LA041](https://openairdocs.org/ntsb/FTW88LA041.md): Cessna 172XP · Godley, TX · Accident · No injuries · Limited investigation · Final report · Dec 23, 1987 · N736AN · Substantial damage
  > During 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…
- [NTSB SEA88FA032](https://openairdocs.org/ntsb/SEA88FA032.md): Piper PA-28-140 · Eastsound, WA · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1987 · N4306J · Destroyed
  > The 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…
- [NTSB MIA88LA065](https://openairdocs.org/ntsb/MIA88LA065.md): Cessna 172 · Guvate, PR · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 1987 · N5123G · Destroyed
  > The 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…
- [NTSB LAX88FA071](https://openairdocs.org/ntsb/LAX88FA071.md): Beech A35 · Chino Hills, CA · Accident · 2 fatal · Field investigation · Final report · Dec 19, 1987 · N675B · 2 aircraft · Destroyed
  > Failure of both pilots to see and avoid each other and thus avert the collision.
- [NTSB CHI88FA035](https://openairdocs.org/ntsb/CHI88FA035.md): Beech 58 · Wedron, IL · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1987 · N3702K · Destroyed
  > The 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…
- [NTSB SEA88FA031](https://openairdocs.org/ntsb/SEA88FA031.md): Piper PA-32R-300 · Lakeport, CA · Accident · 1 fatal · Field investigation · Final report · Dec 15, 1987 · N400LA · Destroyed
  > Although 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…
- [NTSB NYC88LA057](https://openairdocs.org/ntsb/NYC88LA057.md): Grumman AA-5A · Rome, NY · Accident · Serious injuries · Limited investigation · Final report · Dec 15, 1987 · N74085 · Destroyed
  > The 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…
- [NTSB DEN88FA037](https://openairdocs.org/ntsb/DEN88FA037.md): Piper PA-28-161 · Draper, UT · Accident · 2 fatal · Field investigation · Final report · Dec 15, 1987 · N2138J · Destroyed
  > Drg 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…
- [NTSB ATL88FA060](https://openairdocs.org/ntsb/ATL88FA060.md): Piper PA-32-260 · Moultrie, GA · Accident · 3 fatal · Field investigation · Final report · Dec 12, 1987 · N3632W · Destroyed
  > The 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…
- [NTSB MIA88LA060](https://openairdocs.org/ntsb/MIA88LA060.md): Mooney M20J · St Theresa, FL · Accident · No injuries · Limited investigation · Final report · Dec 11, 1987 · N4324H · Destroyed
  > While 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…
- [NTSB ANC88FA020](https://openairdocs.org/ntsb/ANC88FA020.md): Cessna 207A · Ambler, AK · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1987 · N9979M · Substantial damage
  > The 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…
- [NTSB MKC88FA026](https://openairdocs.org/ntsb/MKC88FA026.md): Varga 2150A · Conroe, TX · Accident · Serious injuries · Field investigation · Final report · Dec 10, 1987 · N4VK · Destroyed
  > The 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…
- [NTSB DEN88FA128](https://openairdocs.org/ntsb/DEN88FA128.md): Cessna 177RG · Afton, WY · Accident · 2 fatal · Field investigation · Final report · Dec 10, 1987 · N1868Q · Destroyed
  > The 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…
- [NTSB MIA88LA057](https://openairdocs.org/ntsb/MIA88LA057.md): Beech E-18S · Natchez, MS · Accident · No injuries · Limited investigation · Final report · Dec 9, 1987 · N24JE · 2 aircraft · Substantial damage
  > The 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…
- [NTSB ATL88FA056](https://openairdocs.org/ntsb/ATL88FA056.md): Piper PA-28-140 · Anniston, AL · Accident · Serious injuries · Field investigation · Final report · Dec 9, 1987 · N15629 · Substantial damage
  > The 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…
- [NTSB DCA88MA008](https://openairdocs.org/ntsb/DCA88MA008.md): British Aerospace BAE-146-200 · San Luis Obispo, CA · Accident · 43 fatal · Major investigation · Final report · Dec 8, 1987 · N350PS · Destroyed
  > A 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…
- [NTSB SEA88LA029](https://openairdocs.org/ntsb/SEA88LA029.md): de Havilland DHC-2 MK1 · Metlakatla, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1987 · N17597 · Substantial damage
  > On 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,…
- [NTSB NYC88FA051](https://openairdocs.org/ntsb/NYC88FA051.md): Cessna 310R · Hector, NY · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1987 · N5052J · Destroyed
  > The 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…
- [NTSB SEA88IA028](https://openairdocs.org/ntsb/SEA88IA028.md): Canadair CL600-2A12 · Twentynine Plms, CA · Incident · No injuries · Incident investigation · Final report · Dec 6, 1987 · N125PS · No damage
  > The 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…
- [NTSB MKC88FA023](https://openairdocs.org/ntsb/MKC88FA023.md): Cessna 180 · Springfield, NE · Accident · 2 fatal · Field investigation · Final report · Dec 6, 1987 · N46TD · Destroyed
  > According 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…
- [NTSB ATL88FA055](https://openairdocs.org/ntsb/ATL88FA055.md): Piper PA-32-260 · Lagrange, GA · Accident · 4 fatal · Field investigation · Final report · Dec 6, 1987 · N5587J · Destroyed
  > Plt 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…
- [NTSB NYC88FA050](https://openairdocs.org/ntsb/NYC88FA050.md): Boeing 737-2B7 · Deptford, NJ · Accident · No injuries · Field investigation · Final report · Dec 5, 1987 · N319AU · Substantial damage
  > Drg 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…
- [NTSB LAX88LA066](https://openairdocs.org/ntsb/LAX88LA066.md): Piper PA-38-112 · Dunsmuir, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1987 · N123JY · Destroyed
  > A 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…
- [NTSB CHI88DEV01](https://openairdocs.org/ntsb/CHI88DEV01.md): Cessna 150L · Marion, IL · Accident · 1 fatal · Final report · Dec 5, 1987 · N7533G · Substantial damage
  > Pilot 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.
- [NTSB ATL88MA053](https://openairdocs.org/ntsb/ATL88MA053.md): Hawker Siddeley HS-125-400A · Lexington, KY · Accident · 2 fatal · Major investigation · Final report · Dec 5, 1987 · N400PH · Destroyed
  > While 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…
- [NTSB NYC88LA053](https://openairdocs.org/ntsb/NYC88LA053.md): Piper PA-28RT · Houlton, ME · Accident · No injuries · Limited investigation · Final report · Dec 4, 1987 · CGRQU · Destroyed
  > During 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…
- [NTSB FTW88DPA01](https://openairdocs.org/ntsb/FTW88DPA01.md): Bell 206B · Dallas, TX · Accident · No injuries · Final report · Dec 4, 1987 · N206DW · Substantial damage
  > The 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…
- [NTSB ATL88FA052](https://openairdocs.org/ntsb/ATL88FA052.md): Piper PA-60-600 · Mansfield, OH · Accident · Serious injuries · Field investigation · Final report · Dec 4, 1987 · N500TS · Destroyed
  > The 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…
- [NTSB MIA88LA051](https://openairdocs.org/ntsb/MIA88LA051.md): Piper PA-38-112 · San Antonio, FL · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N2405F · Substantial damage
  > The 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…
- [NTSB LAX88DVG02](https://openairdocs.org/ntsb/LAX88DVG02.md): Grumman G-164A · Williams, CA · Accident · No injuries · Final report · Dec 2, 1987 · N673U · Substantial damage
  > Shortly 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…
- [NTSB FTW88LA034](https://openairdocs.org/ntsb/FTW88LA034.md): Cessna 150 · Mangum, OK · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N3888V · Substantial damage
  > According 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…
- [NTSB LAX88FA060](https://openairdocs.org/ntsb/LAX88FA060.md): Piper PA-46 · Long Beach, CA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 1987 · N4369V · Destroyed
  > Pilot'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.
- [NTSB ATL88MA048](https://openairdocs.org/ntsb/ATL88MA048.md): Beech C90 · Beaufort, SC · Accident · 2 fatal · Major investigation · Final report · Nov 30, 1987 · N4463W · Destroyed
  > At 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…
- [NTSB NYC88LA047](https://openairdocs.org/ntsb/NYC88LA047.md): Piper PA-28-180 · E.Harwich Port, MA · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N9714J · Destroyed
  > The 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…
- [NTSB MKC88LA022](https://openairdocs.org/ntsb/MKC88LA022.md): Mooney M20J · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N201CQ · Substantial damage
  > Drg 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…
- [NTSB CHI88LA031](https://openairdocs.org/ntsb/CHI88LA031.md): Piper PA-24-180 · Danville, IL · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N5611P · Substantial damage
  > Earlier 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…
- [NTSB LAX88LA062](https://openairdocs.org/ntsb/LAX88LA062.md): Beech P35 · Maricopa, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1987 · N413EE · Substantial damage
  > During 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…
- [NTSB BFO88FA008](https://openairdocs.org/ntsb/BFO88FA008.md): Piper PA-32-260B · Willis, VA · Accident · 3 fatal · Field investigation · Final report · Nov 27, 1987 · N4832S · Destroyed
  > The 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.…
- [NTSB ANC88FA021](https://openairdocs.org/ntsb/ANC88FA021.md): Cessna 185 · Fairbanks, AK · Accident · 3 fatal · Field investigation · Final report · Nov 27, 1987 · N4056Y · Destroyed
  > The 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…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?year=1987&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?year=1987

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.