# NTSB investigations: 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 312 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CHI87LA138](https://openairdocs.org/ntsb/CHI87LA138.md): Aeronca 11CC · Inver Grove Hts, MN · Accident · No injuries · Limited investigation · Final report · Jun 5, 1987 · N4231E · Substantial damage
  > After a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.
- [NTSB MKC87LA116](https://openairdocs.org/ntsb/MKC87LA116.md): Cessna 188-B · Sigourney, IA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N21711 · Substantial damage
  > During an unloaded re-positioning flt to begin an aerial application operation, the PIC experienced a total engine failure. A forced ldg was attempted and acft hit a ditch and was substantially damaged.
- [NTSB FTW87MA133](https://openairdocs.org/ntsb/FTW87MA133.md): Cessna P210R · Arnett, OK · Accident · 1 fatal · Major investigation · Final report · Jun 3, 1987 · N5488A · Destroyed
  > The flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…
- [NTSB CHI87FA139](https://openairdocs.org/ntsb/CHI87FA139.md): Bell 47G · Dayton, MN · Accident · 2 fatal · Field investigation · Final report · Jun 3, 1987 · N128B · Destroyed
  > Aircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…
- [NTSB ATL87LA157](https://openairdocs.org/ntsb/ATL87LA157.md): Beech A36 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N1859A · Substantial damage
  > The 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…
- [NTSB MKC87LA115](https://openairdocs.org/ntsb/MKC87LA115.md): Ayres S2R600 · Lepanto, AR · Accident · No injuries · Limited investigation · Final report · Jun 2, 1987 · N4943X · Substantial damage
  > The PIC had taken off for a LCL aerial operation. Enroute PIC had an engine failure and made a forced ldg in a muddy field. PIC applied brakes and acft nosed over. The exhaust rocker arm box on no. 3 cylinder was found to be cracked keeping exhaust valve in…
- [NTSB LAX87LA222](https://openairdocs.org/ntsb/LAX87LA222.md): Bell 47G-3B-1 · Payson, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 1987 · N73916 · Destroyed
  > A Bell 47G-3B-1 collided with trees and was subsequently destroyed by fire after a loss of power in a remote wilderness area. The pilot reported the engine went to idle during flight. He was unable to regain engine RPM by manipulation of the throttle. The…
- [NTSB DEN87IA145](https://openairdocs.org/ntsb/DEN87IA145.md): Boeing 727-251 · Casper, WY · Incident · No injuries · Incident investigation · Final report · Jun 2, 1987 · N297US · 2 aircraft · No damage
  > Boeing 727 (northwest flt 354) & USAF EC-135 (slum 51) were involved in a nr collision at FL 330. The mishap occurred asflt 354 was ene bnd on J-158 & slum 51 was flying on a radial-distance (r/d) flt pln, flying btn r/d pts south of J-158.as slum 51 apchd…
- [NTSB ATL87LA156](https://openairdocs.org/ntsb/ATL87LA156.md): Cessna C-152 · Bunn, NC · Accident · No injuries · Limited investigation · Final report · Jun 2, 1987 · N46411 · Substantial damage
  > The airplane nosed over during a precautionary ldg in a soft, dirt field. The plt and a mechanic had been ferrying the airplane back to its base after replacing the starter and battery solenoids, and the battery. The pre-flt run-up had revealed no problems…
- [NTSB SEA87LA107](https://openairdocs.org/ntsb/SEA87LA107.md): Aerodynamics. Hawk Mkii · Ellensburg, WA · Accident · No injuries · Limited investigation · Final report · Jun 1, 1987 · N5832M · Substantial damage
  > Despite warnings from the flight service station about turbulence, high winds aloft, severe low level wind shear, and low ceilings along the pilots intended route of flight, the pilot elected to depart the airport for his destination. Standing lenticular…
- [NTSB DEN87LA140](https://openairdocs.org/ntsb/DEN87LA140.md): Cessna TU206D · Garrison, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1987 · N72415 · Substantial damage
  > The plt and a photographer were photo-mapping at 3,000 feet MSL. The plt reported that the engine quit at cruise. The plt selected a gravel road for the forced landing. The aircraft landed short of the intended touchdown pointin a plowed field and on…
- [NTSB DEN87LA138](https://openairdocs.org/ntsb/DEN87LA138.md): Piper PA-24-250 · Monticello, UT · Accident · Minor injuries · Limited investigation · Final report · May 31, 1987 · N7744P · Substantial damage
  > The plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…
- [NTSB CHI87DEX06](https://openairdocs.org/ntsb/CHI87DEX06.md): Cessna 172E · Huntingburg, IN · Accident · Minor injuries · Final report · May 31, 1987 · N5514T · Substantial damage
  > While on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…
- [NTSB SEA87LA105](https://openairdocs.org/ntsb/SEA87LA105.md): Beech BE18 · Glenns Ferry, ID · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N503CW · Substantial damage
  > While at crz, plt encountered turbulence. Shortly thereafter, experienced elevator control difficulties and yoke vibrations. Plt declared emerg, requested vector to closest airport. Mtn home afb rapcon gave vector to Glenns Ferry airport. On approach, plt…
- [NTSB NYC87LA156](https://openairdocs.org/ntsb/NYC87LA156.md): Piper PA-31-350 · Cooperstown, NY · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N59728 · Substantial damage
  > The pilot stated he departed farmingdale with two plus hours of fuel on board. After approximately 40-50 minutes of flight, the right low fuel pressure light and right fuel pump light flashed steady red. The pilot rechecked his calculations and determined he…
- [NTSB LAX87LA221](https://openairdocs.org/ntsb/LAX87LA221.md): Cessna 182G · Avenal, CA · Accident · Minor injuries · Limited investigation · Final report · May 30, 1987 · N3274S · Substantial damage
  > A Cessna 182G collided with trees during landing rollout on a dirt road. The pilot indicated during a telephone interview that the manifold pressure gradually dropped to 18 pounds. The aircraft was unable to maintain altitude and the pilot landed the aircraft…
- [NTSB CHI87IA135](https://openairdocs.org/ntsb/CHI87IA135.md): Mcdonnell Douglas DC-9-82 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 30, 1987 · N224AA · No damage
  > American flt 637 was on departure from Chicago-o'hare intl arpt (ord), climbing thru 7300' MSL, when it passed American flt 393 with aprx 500' vertical sepn & 1/4 mi horizontal sepn. This occurred after an air traffic assistant, who was working the clnc…
- [NTSB BFO87DID03](https://openairdocs.org/ntsb/BFO87DID03.md): Ham Wizard · Chesapeake, VA · Accident · No injuries · Final report · May 30, 1987 · N39583 · Substantial damage
  > Drg flt, a portion of the exhaust stack broke off & struck the wooden prop. Aprx 1/3 of the prop separated & a severe vibration started. The plt shut down the eng & headed for an open field. Due to lack of altitude, he was barely able to clear nearby trees.…
- [NTSB ATL87LA154](https://openairdocs.org/ntsb/ATL87LA154.md): Cessna T210N · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N4965Y · Substantial damage
  > While climbing thru 6,000 ft, the plt heard & felt a 'thud' & then realized the eng had failed. Drg a subsequent emerg landing in a muddy corn field, the nose gear mired in soft terrain & the acft nosed over. A teardown of the eng revealed the crankshaft was…
- [NTSB SEA87LA104](https://openairdocs.org/ntsb/SEA87LA104.md): Cessna 172 · Prospect, OR · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N4173F · Substantial damage
  > The acft lost pwr during cruise flt due to loss of oil pressure because of multiple oil leaks. The recommended t.b.o. is 1800 hrs and this eng had a total of 2344 hrs. A top overhaul had been accomplished 140 flt hrs prior to the acc. The acft had only been…
- [NTSB MKC87LA113](https://openairdocs.org/ntsb/MKC87LA113.md): Ayres S2R600 · Paragould, AR · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N4197X · Substantial damage
  > En route to a local aerial application operation PIC experienced a total engien failure. During subsequent emergency landing in a farm field the acft was substantially damaged. No reason could be determined for the engine failure.
- [NTSB SEA87FA106](https://openairdocs.org/ntsb/SEA87FA106.md): Hiller UH-12E · Shelton, WA · Accident · 1 fatal · Field investigation · Final report · May 28, 1987 · N28875 · Destroyed
  > The pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…
- [NTSB FTW87FA130](https://openairdocs.org/ntsb/FTW87FA130.md): Grumman AA5A · Malakoff, TX · Accident · No injuries · Field investigation · Final report · May 27, 1987 · N26378 · Substantial damage
  > The acft impacted the terrain near Malakoff, Texas. Following an engine failure the pilot attempted to execute a forced landing to a road crossing a dam. The aircraft touched down and bounced into the lake. Examination of the engine revealed that the exhaust…
- [NTSB FTW87FA129](https://openairdocs.org/ntsb/FTW87FA129.md): Beech B-60 · Wall, TX · Accident · Serious injuries · Field investigation · Final report · May 27, 1987 · N4314W · Destroyed
  > Acft was destroyed during an attempted off airport emergency landing following a dual eng failure while leveling off at crz flt. Plt stated that left eng, then right eng surged and quit as he was leveling off at 9000' MSL. At the time of the eng failures the…
- [NTSB ATL87LA151](https://openairdocs.org/ntsb/ATL87LA151.md): Beech A36-TC · Winder, GA · Accident · No injuries · Limited investigation · Final report · May 27, 1987 · N18HB · Substantial damage
  > The plt reported experiencing a complete electrical failure shortly after takeoff. All systems were shut down and the plt declared an emergency. The flight descended to visual conditions for a landing at Winder. The plt shut down the engine and attempted a no…
- [NTSB SEA87FA102](https://openairdocs.org/ntsb/SEA87FA102.md): Socata TB10 · Battle Mountain, NV · Accident · 3 fatal · Field investigation · Final report · May 26, 1987 · N20FU · Destroyed
  > After receiving a weather briefing calling for mountains occasionally obscured, occasional moderate icing from 18000 ft & below, and ceilings across north & central Nevada, the noninstrument rated pilot filed a VFR flight plan and departed salt lake city for…
- [NTSB LAX87LA215](https://openairdocs.org/ntsb/LAX87LA215.md): Cessna 150F · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N8978S · Substantial damage
  > The flt encountered strong head winds while cruising x-country at 6000 ft MSL. The engine lost power aprx 14 miles east of the intended destination and during descent toward the destination the power returned several times but could not be maintained. The…
- [NTSB LAX87FA212](https://openairdocs.org/ntsb/LAX87FA212.md): Rockwell 114 · Los Gatos, CA · Accident · 1 fatal · Field investigation · Final report · May 25, 1987 · N114CH · Destroyed
  > Drg a preflt wx briefing, the plt was adzd the forecast for oakland (19 mi nnw of his destn) was for a 3000' broken ceiling with occasional 3000' scattered, 5000' broken & a chance of light rain showers. He filed a VFR flt plan & depd. At 1347 PDT, the plt…
- [NTSB DEN87FA134](https://openairdocs.org/ntsb/DEN87FA134.md): Piper PA-28RT-201T · Ogden, UT · Accident · Serious injuries · Field investigation · Final report · May 25, 1987 · N2888B · Destroyed
  > Acft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…
- [NTSB SEA87FA100](https://openairdocs.org/ntsb/SEA87FA100.md): Cessna 172 · Ritzville, WA · Accident · 3 fatal · Field investigation · Final report · May 24, 1987 · N5711A · 2 aircraft · Destroyed
  > Occupants of both acft were family members traveling in company for holiday. Takeoff was about one min apart with N44726 in trail. Due higher norm crz performance, N44726 overtook N5711A. Plt of N44726 reduced speed and established position about 1/2 mile to…
- [NTSB ATL87FA147](https://openairdocs.org/ntsb/ATL87FA147.md): Hiller UH-12D (H23) · Spartanburg, SC · Accident · 1 fatal · Field investigation · Final report · May 24, 1987 · N6408 · Destroyed
  > During 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…
- [NTSB NYC87DNC10](https://openairdocs.org/ntsb/NYC87DNC10.md): Huffman Quickie Q2 · Peterborough, NH · Accident · 1 fatal · Final report · May 23, 1987 · N22QT · Destroyed
  > At 0939 EDT, the acft departed syracuse, NY, on a flt to nashua, NH. Subsequently, it was rprtd missing. A search was initiated, but the acft was not found until it was discovered by a hiker aprx 2 months later. The acft had crashed below a mtn top near…
- [NTSB FTW87FA123](https://openairdocs.org/ntsb/FTW87FA123.md): Piper PA-32R-301 · Porter, OK · Accident · 2 fatal · Field investigation · Final report · May 23, 1987 · N81796 · Destroyed
  > Acft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…
- [NTSB ATL87DEI04](https://openairdocs.org/ntsb/ATL87DEI04.md): Butler EAA Biplane 1 · Orrville, OH · Accident · Minor injuries · Final report · May 23, 1987 · N11TB · Substantial damage
  > Acft lost power and was landed in a corn field. Left main gear collapsed and acft flipped onto its back. Mixture cable set screw on carburetor was found loose allowing mixture to vibrate to lean position. Earlier in the day the PIC had replaced the carburetor.
- [NTSB MKC87LA109](https://openairdocs.org/ntsb/MKC87LA109.md): Cessna 152 · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · May 22, 1987 · N6136Q · Substantial damage
  > The pilot stated that he departed St. Louis downtown-parks airport (cps) on a round-robin flight with planned stops at st. clair memorial airport (K39), Missouri, and richland municipal airport (M034), Missouri. The return flight to cps included another stop…
- [NTSB LAX87LA214](https://openairdocs.org/ntsb/LAX87LA214.md): Boeing A75N1 · San Ardo, CA · Accident · Serious injuries · Limited investigation · Final report · May 22, 1987 · N90840 · Substantial damage
  > During a pleasure cross country flight, the engine experienced a partial loss of engine power. The plt made a forced landing where prior to touchdown the acft collided with power lines then contacted the terrain in aprx three ft of water. The acft has history…
- [NTSB LAX87FA213](https://openairdocs.org/ntsb/LAX87FA213.md): Cessna P206 · Tehachapi, CA · Accident · 4 fatal · Field investigation · Final report · May 22, 1987 · N2520X · 2 aircraft · Destroyed
  > An USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government…
- [NTSB DEN87LA131](https://openairdocs.org/ntsb/DEN87LA131.md): Piper PA-24-180 · Emerado, ND · Accident · No injuries · Limited investigation · Final report · May 22, 1987 · N8088P · Substantial damage
  > The commercial plt was en route on a personal flt. Thirteen miles from his destination, he smelled oil fumes and the cabin filled with oil smoke. The engine oil pressure dropped to zero. The plt shut down the engine, ventilated the cabin, and declared an…
- [NTSB MKC87FA106](https://openairdocs.org/ntsb/MKC87FA106.md): Piper PA-28R-180 · Sioux City, IA · Accident · 3 fatal · Field investigation · Final report · May 21, 1987 · N4982J · Destroyed
  > The PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…
- [NTSB MKC87LA112](https://openairdocs.org/ntsb/MKC87LA112.md): Cessna 150G · Forest City, IA · Accident · No injuries · Limited investigation · Final report · May 19, 1987 · N3767J · Substantial damage
  > After reaching a cruise alt of 1000 ft AGL, the plt noticed a lack of oil pressure. He elected to make a precautionary landing in an unplowed soft field. The plt then reduced pwr to idle and set up for the landing. During the landing roll the acft nosed over.…
- [NTSB ATL87FA142](https://openairdocs.org/ntsb/ATL87FA142.md): Cessna T337G · Oxford, OH · Accident · 4 fatal · Field investigation · Final report · May 18, 1987 · N436 · Destroyed
  > The pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…
- [NTSB NYC87LA150](https://openairdocs.org/ntsb/NYC87LA150.md): Piper PA-28R-201 · Falmouth, MA · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N30694 · Substantial damage
  > About 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…
- [NTSB NYC87DGM02](https://openairdocs.org/ntsb/NYC87DGM02.md): Noonan VARI-EZE · Ebensburg, PA · Accident · No injuries · Final report · May 17, 1987 · N785 · Substantial damage
  > The vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…
- [NTSB LAX87LA208](https://openairdocs.org/ntsb/LAX87LA208.md): Piper PA-28-161 · Turlock, CA · Accident · Minor injuries · Limited investigation · Final report · May 17, 1987 · N38458 · Substantial damage
  > Approximately 15 minutes into a pleasure flight, the engine experienced a partial loss of power. The pilot made an emergency landing at a nearby airport, where upon landing the aircraft ran off the runway and collided with a bush. Inspection of the engine…
- [NTSB DEN87LA125](https://openairdocs.org/ntsb/DEN87LA125.md): Cessna 170B · Big Sky, MT · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N1979C · Substantial damage
  > The private plt was flying cross country in deteriorating weather conditions. Fog was forecast and light rain was in progress. The flt encountered less than VFR conditions in a mountainous area and reversed course. Weather was below VFR on the reverse course…
- [NTSB NYC87LA145](https://openairdocs.org/ntsb/NYC87LA145.md): Cessna 150 · Stanford, NY · Accident · No injuries · Limited investigation · Final report · May 12, 1987 · N50682 · Substantial damage
  > During enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…
- [NTSB DEN87LA120](https://openairdocs.org/ntsb/DEN87LA120.md): Bell 47G3B2A · Brigham City, UT · Accident · No injuries · Limited investigation · Final report · May 8, 1987 · N58131 · Substantial damage
  > An ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…
- [NTSB ANC87FA067](https://openairdocs.org/ntsb/ANC87FA067.md): Piper PA-31-350 · Nightmute, AK · Accident · 1 fatal · Field investigation · Final report · May 7, 1987 · N54265 · Destroyed
  > The aircraft was destroyed when the aircraft struck a 350 foot high hill along its route. This flight was a part 135 on-demand air taxi cargo flight. Several other air taxi operators and company aircraft elected to cancel their flights. Both ground reports…
- [NTSB ATL87FA132](https://openairdocs.org/ntsb/ATL87FA132.md): Aeronca 7BCM · Georgiana, AL · Accident · 2 fatal · Field investigation · Final report · May 3, 1987 · N10521 · Destroyed
  > The plts & pax of 2 acft were returning from an annual pleasure trip. Neither acft had a good comm radio. Shortly after takeoff, they enctrd fog. They flew above the wx until they were near their 1st refueling stop (greenville, AL). Both plts dscndd beneath…
- [NTSB MIA87LA154](https://openairdocs.org/ntsb/MIA87LA154.md): Cessna T210N · Apalachicola, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N4612C · Substantial damage
  > The plt stated that he departed panama city en route to tampa, FL, when the manifold pressure and oil pressure started to drop. He then turned towards Apalachicola to try to make it to the airport but was unable and made a forced landing in a swampy area aprx…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=313

## 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 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?page=312

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