# 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 340 of 718 · 35,889 cases

## Cases, newest first

- [NTSB ATL85FA157](https://openairdocs.org/ntsb/ATL85FA157.md): Mooney M20J · Covington, TN · Accident · 3 fatal · Field investigation · Final report · May 11, 1985 · N5765K · Destroyed
  > After takeoff, the flt progressed normally, except one ARTCC controller had difficulty communicating with the plt during the early part of the flt. After cruising at 11,000 ft for aprx 2 hrs, the plt obtained updated wx info & requested clearance to descend…
- [NTSB SEA85LA109](https://openairdocs.org/ntsb/SEA85LA109.md): Cessna 182 · Rexburg, ID · Accident · No injuries · Limited investigation · Final report · May 10, 1985 · N2024G · Substantial damage
  > While en route, the plt circumnavigated around several storms. When the acft was about 20 mi from the destination arpt, fuel exhaustion ocurred. Subsequently, the acft nosed over during a forced landing on soft uneven terrain.
- [NTSB LAX85FA252](https://openairdocs.org/ntsb/LAX85FA252.md): Piper PA-28-161 · Ocotillo Wells, CA · Accident · 1 fatal · Field investigation · Final report · May 10, 1985 · N81018 · Destroyed
  > According to witnesses on a dune buggy & a honda trx 200, the acft was flying at low alt in strong winds when it seemed to encounter turbulence & go out of control. Some of the witnesses said it temporarily leveled at about 200 ft AGL. All agreed that it was…
- [NTSB MKC85FA100](https://openairdocs.org/ntsb/MKC85FA100.md): Bell 47G · Calwood, MO · Accident · 2 fatal · Field investigation · Final report · May 9, 1985 · N951B · Destroyed
  > N951B crashed in a wooded area during a powerline patrol flt which included photography of the powerline. According to witnesses, the helicopter was flying parallel to the powerline in a westerly direction when the accident occurred. Exam of the wreckage…
- [NTSB DEN85LA130](https://openairdocs.org/ntsb/DEN85LA130.md): Taylorcraft Unknown · Mora, NM · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · CGHJQ · Substantial damage
  > Acft was refueled at las vegas, NM. Plt stated after accident that the eng gradually lost power while in cruise flt. Plt attempted to return to las vegas but could not maintain alt. Acft was damaged during landing on rough terrain. There are no current acft…
- [NTSB ANC85LA079](https://openairdocs.org/ntsb/ANC85LA079.md): Cessna C-206 · Candle, AK · Accident · No injuries · Limited investigation · Final report · May 8, 1985 · N9140M · Substantial damage
  > The acft made a hard landing on ice after eng failure resulted in a forced landing. The plt had shut down the eng after loss of oil pressure and a rise in oil temperature occurred. Post accident investigation showed a failure of a rod bearing.
- [NTSB ANC85FA078](https://openairdocs.org/ntsb/ANC85FA078.md): Cessna 180H · Anchorage, AK · Accident · 3 fatal · Field investigation · Final report · May 8, 1985 · N9042M · Destroyed
  > The acft ran out of fuel after the plt extended his original flt plan route to circumnavigate areas of poor weather. The acft was over water when fuel exhaustion occurred and the acft was ditched under unfavorable conditions.
- [NTSB DEN85LA129](https://openairdocs.org/ntsb/DEN85LA129.md): Piper PA-28-181 · Tucumcari, NM · Accident · No injuries · Limited investigation · Final report · May 6, 1985 · N3067L · Substantial damage
  > The acft contacted a tree and a ditch during a forced landing after a loss of pwr due to fuel exhaustion. The right fuel gage reportedly indicated 6-8 gallons of fuel in the right tank when 50 miles from Tucumcari municipal arpt. The plt reported he was…
- [NTSB LAX85LA248](https://openairdocs.org/ntsb/LAX85LA248.md): Piper PA-32-300 · Baker, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N15259 · Substantial damage
  > Plt became lost on a daylight VFR flt and was unable, because of her low altitude, to receive any nav radio aids or establish radio communications. Because of apch darkness and a low fuel state she elected to perform a precautionary landing on a dirt strip.…
- [NTSB FTW85FRD01](https://openairdocs.org/ntsb/FTW85FRD01.md): Alon A-2 · Bunkie, LA · Accident · Serious injuries · Final report · May 5, 1985 · N5491E · Destroyed
  > The acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…
- [NTSB FTW85FA207](https://openairdocs.org/ntsb/FTW85FA207.md): Robinson R-22 HP · San Angelo, TX · Accident · 2 fatal · Field investigation · Final report · May 5, 1985 · N83745 · Destroyed
  > A loss of control in flight for undetermined reasons.
- [NTSB BFO85FA042](https://openairdocs.org/ntsb/BFO85FA042.md): Cessna 175 · Princefrederick, MD · Accident · Minor injuries · Field investigation · Final report · May 5, 1985 · N7027E · Substantial damage
  > The acft flew 2:15 from cambridge, MD, to smith mountain lake, VA, earlier on the day of the accident and was 2 hrs into the return flt when at 5500 ft over prince frederick, MD, the eng lost pwr due to fuel exhaustion, according to the passenger. The apch to…
- [NTSB MIA85LA164](https://openairdocs.org/ntsb/MIA85LA164.md): Mooney M20C · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · May 4, 1985 · N6850U · Substantial damage
  > While en route, the plt noted a severe eng vibration. He shut down the eng & made an emergency landing. During the roll-out, the acft hit a ditch & was damaged. An investigation revealed that one prop blade had failed from fatigue & the end of the blade had…
- [NTSB FTW85LA214](https://openairdocs.org/ntsb/FTW85LA214.md): Dempsey Quickie · Opelousas, LA · Accident · Minor injuries · Limited investigation · Final report · May 4, 1985 · N79QD · Substantial damage
  > During preflight, the plt estimated that he had about 2.5 hrs of fuel according to the gage. After 1.5 hrs of flt, the eng quit in cruise flt due to fuel exhaustion. The acft nosed over during the subsequent forced landing in a fld.
- [NTSB NYC85LA114](https://openairdocs.org/ntsb/NYC85LA114.md): Piper PA-28R-200 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · May 3, 1985 · N9439N · Substantial damage
  > The acft made a forced landing after the manifold pressure kept dropping. Some adjustment was made by throttle application and finally alt air was used. When the plt decided that the arpt could not be reached he landed on a highway. The left & nose gear…
- [NTSB MIA85LA163](https://openairdocs.org/ntsb/MIA85LA163.md): Cessna R172K · Pembroke Pines, FL · Accident · Minor injuries · Limited investigation · Final report · May 3, 1985 · N758AE · Substantial damage
  > The plt reported that after takeoff, the eng lost power when the acft was about 10 mi west of the arpt. While he was attempting to land, the acft collided with power lines & crashed onto a canal bank. During an exam of the acft, eng continuity was…
- [NTSB MIA85FA162](https://openairdocs.org/ntsb/MIA85FA162.md): Beech 95-C55 · Jacksonville, FL · Accident · Serious injuries · Field investigation · Final report · May 2, 1985 · N9442S · Destroyed
  > The acft was on the last leg of a flt that originated that morning at Jacksonville, then proceeded to daytona beach, then on to crestview, FL. While on the return flt to Jacksonville, the right eng lost power as the acft was approaching its destination. The…
- [NTSB CHI85FA185](https://openairdocs.org/ntsb/CHI85FA185.md): Beech B35 · Sussex, WI · Accident · No injuries · Field investigation · Final report · May 2, 1985 · N5182C · 2 aircraft · Substantial damage
  > A student plt was on his 1st solo x-country flt in a Cessna 152, N6464L. After taking off at the brookfield arpt (elev 850 ft), he had climbed to 2000 ft MSL & was heading 350 deg when he saw a Beech B35 (bonanza), N5182C, converging from his right. The…
- [NTSB FTW85FA203](https://openairdocs.org/ntsb/FTW85FA203.md): Beech B 55 · Brownwood, TX · Accident · 2 fatal · Field investigation · Final report · Apr 30, 1985 · N613MC · Destroyed
  > The professional pilot was familiar with his destination. He had made the same trip many times in the last year. Destination weather information was not available that early in the morning, and although he indicated over the radio that he was aware of the…
- [NTSB SEA85LA099](https://openairdocs.org/ntsb/SEA85LA099.md): Piper PA-32-300 · Funter Pass, AK · Accident · No injuries · Limited investigation · Final report · Apr 29, 1985 · N2897X · Substantial damage
  > Prior to the flt, the plt had obtained a briefing thru the company weather reporting sys & VFR wx had been forecast. While en route, he encountered snow showers in the area of Funter Pass. He reported that he became trapped by two snow showers with the…
- [NTSB FTW85LA206](https://openairdocs.org/ntsb/FTW85LA206.md): Piper PA-32-300 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Apr 29, 1985 · N4050W · Substantial damage
  > The acft contacted trees during a forced landing on a golf course. The plt's company had just completed an overhaul on the eng which quit shortly after takeoff when the plt turned off the electric boost pump. Examination of the eng's fuel system revealed a…
- [NTSB BFO85FA041](https://openairdocs.org/ntsb/BFO85FA041.md): Mooney M20F · Stevensville, MD · Accident · No injuries · Field investigation · Final report · Apr 29, 1985 · N9107V · Destroyed
  > The plt stated that when in normal curise at 3000 ft over castle marina arpt he noticed excessive oil and cylinder head temps. A concurrent small amount of smoke was emanating from the instrument panel which prompted the plt to execute a precautionary lndg at…
- [NTSB LAX85FA230](https://openairdocs.org/ntsb/LAX85FA230.md): Piper PA-28-181 · Garberville, CA · Accident · 4 fatal · Field investigation · Final report · Apr 28, 1985 · N8273L · Destroyed
  > Witnesses reported that the acft departed shelter cove, elevation 69 ft, and headed east toward a 2000 ft high mountain located 1 3/4 miles away. They continued to report the acft was climbing at a slow rate in a nose high attitude. The acft contacted trees…
- [NTSB ATL85LA151](https://openairdocs.org/ntsb/ATL85LA151.md): Piper J3C-65 · Tullahoma, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1985 · N6015H · Substantial damage
  > The plt was giving a 15 yr old passenger a local area flt. While in level flt at about 200 ft AGL, the acft hit an unmarked/guyed antenna tower & crashed. The plt reported that he did not see the tower. Although the tower had been there for many years, it was…
- [NTSB NYC85LA112](https://openairdocs.org/ntsb/NYC85LA112.md): Cessna 172H · Middletown, PA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N8052L · Substantial damage
  > The acft nosed over in a plowed field during a forced landing after a pwr loss during cruise flt. After the pwr loss the plt declared an emergency and set up a slide for the nearby arpt. Strong winds interfered in the planned approach and the acft settled in…
- [NTSB LAX85LA227](https://openairdocs.org/ntsb/LAX85LA227.md): Beech A35 · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N585B · Substantial damage
  > The plt performed a gear-up landing on rocky terrain after the acft windshield became covered with oil and the eng beganvibrating. Post accident investigation revealed a 6 inch crack in the crankcase near where the #4 cylinder should have been located. Half…
- [NTSB CHI85LA178](https://openairdocs.org/ntsb/CHI85LA178.md): Beech H35 · Lima, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1985 · N5544D · Substantial damage
  > The plt was flying the acft back to the home arpt following an annual inspection when he noticed the oil pressure was falling to zero. Aprx 3 min later, the eng seized. Subsequently, an emerg gear-up landing was made in a farm field. An exam revealed the oil…
- [NTSB ATL85LA150](https://openairdocs.org/ntsb/ATL85LA150.md): Cessna 182B · Bayou La Batre, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1985 · N2688G · Destroyed
  > Inadvertant opening of parachute in aircraft during climb to jump altitude pulled jumper from aircraft. Jumper struck right horizontal tail. Control of aircraft was lost and the pilot and the other three jumpers exited the aircraft, deployed their chutes and…
- [NTSB SEA85LA097](https://openairdocs.org/ntsb/SEA85LA097.md): Hiller 12E · Myrtle Point, OR · Accident · No injuries · Limited investigation · Final report · Apr 26, 1985 · N99GM · Substantial damage
  > During a CFR 137 flight a total loss of power occurred with an audible screech coming form the engine area. Autorotation was made and the acft was landed into a hevily treed area with steep terrain. During engine tear down a fractured impeller was found.…
- [NTSB CHI85FA176](https://openairdocs.org/ntsb/CHI85FA176.md): Cessna R182 · Prairie Dusac, WI · Accident · 1 fatal · Field investigation · Final report · Apr 26, 1985 · N4707T · 2 aircraft · Substantial damage
  > This midair collision occurred approx 2 mi NE of sauk-Prairie apt. The pilots of the Cessna were in a climbing right departure turn at approx 1600 ft MSL heading approx 120 deg when a collsion occurred with a Piper heading approx 270 deg and descending. One…
- [NTSB ANC85LA073](https://openairdocs.org/ntsb/ANC85LA073.md): Cessna 206 · Seward, AK · Accident · No injuries · Limited investigation · Final report · Apr 26, 1985 · N4863C · Substantial damage
  > The plt stated the acft was in cruise flt when the engine quit. The plt attempted an emergency landing on the beach but crashed in the water. The acft engine was not located for several days after the accident. According to the operator the engine failure was…
- [NTSB FTW85LA200](https://openairdocs.org/ntsb/FTW85LA200.md): Piper J-3C-65 · Sulphur, LA · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1985 · N3475K · Substantial damage
  > The pilot stated he had taken off to the south into the wind. He made a turn to the west to clear trees. At about 150 feet the aircrafts climb ability deteriorated so he turned back into the wind but the nose dropped stalled and the aircraft entered a spin.…
- [NTSB LAX85FUG03](https://openairdocs.org/ntsb/LAX85FUG03.md): Vickers Slingsby T56A Vega · Hemet, CA · Accident · Serious injuries · Final report · Apr 24, 1985 · N4312B · Substantial damage
  > The sailplane was in level flt when the plt felt flutter and lost pitch control of the acft. After one uncontrolled loop the plt bailed out and received serioud injuries during the parachute landing. Loss of all six elevator hinges had caused the elevator to…
- [NTSB NYC85FFA02](https://openairdocs.org/ntsb/NYC85FFA02.md): Cessna 177 · Claryville, NY · Accident · Serious injuries · Final report · Apr 23, 1985 · N3401T · Substantial damage
  > The acft impacted trees during a precautionary lndg due to the plts EST of a low fuel state. The flt had proceeded r enroute to an intended dest of oxford me from frederick MD without filling a flt plan. After aprx 3 hrs of flying on a 60 degree mag hdg the…
- [NTSB CHI85FA174](https://openairdocs.org/ntsb/CHI85FA174.md): Boeing 727-223 · Little Rock, AR · Accident · Serious injuries · Field investigation · Final report · Apr 23, 1985 · N856AA · No damage
  > The aircraft was paralleling a line of thunderstorms and needed to get on the other side of the line to get to his destination. The center controller suggested that he reverse course to fly around the closer end of the line but the pilot decided to penetrate…
- [NTSB ATL85FA146](https://openairdocs.org/ntsb/ATL85FA146.md): Piper PA-32R-300 · Dundee, MS · Accident · 1 fatal · Field investigation · Final report · Apr 23, 1985 · N8069C · Destroyed
  > Plt obtained three preflight wx briefings then filed IFR using an assumed name. Routine communications until 2117 CST when pilot reported in a cell and said he wanted to make a 180 degree turn. Cleared for right turn. Radar and comm contact with aircraft lost…
- [NTSB SEA85LA095](https://openairdocs.org/ntsb/SEA85LA095.md): Beech 36 · Elko, NV · Accident · 2 fatal · Limited investigation · Final report · Apr 22, 1985 · N7514N · Destroyed
  > Elko DME (located at the arpt, used for the lda/dme apch, 108.5 mhz) was inop. Drg arrival, the plt expressed mistrust of his DME. Aprx 24 mi sse of bullion (bqu) VOR, ARTCC controller (ctlr) clrd N7514N for 'the apch to the Elko arpt.' Seconds later, the plt…
- [NTSB MKC85FA088](https://openairdocs.org/ntsb/MKC85FA088.md): Cessna 310G · Mena, AR · Accident · 2 fatal · Field investigation · Final report · Apr 22, 1985 · N8942Z · Destroyed
  > The acft crashed out of control after an in-flt airframe failure. The plt had entered an area of thunderstorms after being advised that VFR flt was not recommended in that area. The plt was single eng rated and his flt time in this z eng acft was 18 hrs.
- [NTSB LAX85FA214](https://openairdocs.org/ntsb/LAX85FA214.md): Beech A45 · Fallbrook, CA · Accident · 1 fatal · Field investigation · Final report · Apr 22, 1985 · N7GN · Destroyed
  > The plt was flying to his home arpt under visual flight rules (VFR) from his place of employment when he encountered low ceilings & visibilities. He contd at low alt along an interstate highway toward his original destination. A witness reported that the plt…
- [NTSB FTW85LA194](https://openairdocs.org/ntsb/FTW85LA194.md): Piper PA-31-350 · Sallisaw, OK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N3550N · Substantial damage
  > An annual inspn had just been completed (4/22/85) & each eng had about 1 hr of flt time. The plt stated that he took off & climbed to cruise at 9000 ft, then closed the cowl flaps & set the fuel settings for 75% power. While en route, he noted oil trailing…
- [NTSB CHI85LA173](https://openairdocs.org/ntsb/CHI85LA173.md): Cessna 172M · Macedonia, OH · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N12124 · Substantial damage
  > While cruising at 2500 ft MSL, the eng developed a severe vibration accompanied by a partial pwr loss. The plt made a forced landing uphill on an inclined field. He initiated a sharp left turn to avoid a house. At that time, the nose gearcollapsed & the acft…
- [NTSB SEA85LA094](https://openairdocs.org/ntsb/SEA85LA094.md): Helio H-295 · John Day, OR · Accident · No injuries · Limited investigation · Final report · Apr 21, 1985 · N94747 · Substantial damage
  > Reportedly, the acft encountered airframe icing conditions during flt, & subsequently, mushed into trees on wooded terrain. Elevation of the crash site was about 4500 ft. about 95 mi west at redmond, OR, the wx was in part: 800 ft overcast, 3 mi visibility,…
- [NTSB LAX85FA218](https://openairdocs.org/ntsb/LAX85FA218.md): Cessna 152 · Sunland, CA · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1985 · N69118 · Destroyed
  > The plt got his pvt plt cert 6 days prior to the accident & planned a local flt to a neighboring arpt just over a coastal mtn range from the dep aprt. 9 NM north of the deparpt, the accident site is almost on a direct line between the dep & dest arpts. The…
- [NTSB LAX85FA215](https://openairdocs.org/ntsb/LAX85FA215.md): Piper PA-28-235 · Castaic, CA · Accident · 5 fatal · Field investigation · Final report · Apr 21, 1985 · N9406W · Destroyed
  > The pilot requested and received a weather briefing for the cross country flight. VFR flight was not recommended due to multiple cloud layers and mountain obscurement. The wreckage was located the following morning at the 3,500 foot elevation in mountainous…
- [NTSB LAX85FA213](https://openairdocs.org/ntsb/LAX85FA213.md): Beech F33A · Goleta, CA · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1985 · N22BW · Destroyed
  > When the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…
- [NTSB DEN85LA122](https://openairdocs.org/ntsb/DEN85LA122.md): Beech BE36 TC · Silver City, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1985 · N6727V · Substantial damage
  > The acft was substantially damaged during a wx encounter near Silver City, NM. Icing and turbulence in IFR conditions prevailed at the time. The plt initiated a climb from 15,000 ft to 17,000 ft because of rime ice conditions. The autopilot was used during…
- [NTSB ATL85LA144](https://openairdocs.org/ntsb/ATL85LA144.md): Bellanca 7AC · Germantown, KY · Accident · No injuries · Limited investigation · Final report · Apr 21, 1985 · N85652 · Substantial damage
  > During cruise flt over hilly terrain, the plt noted a power loss that he described as the eng 'dying back and then catching again.' He was unable to maintain alt & selected a field for a landing. During the apch, the left main gear & prop hit 2 power lines.…
- [NTSB FTW85LA195](https://openairdocs.org/ntsb/FTW85LA195.md): Cessna T-210-NII · Denton, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1985 · N761SU · Substantial damage
  > The acft was damaged during a forced landing in a construction site following a loss of pwr due to fuel exhaustion. The plt stated sufficient fuel was on board for the x-country from flagstaff, AZ, to plano, TX. Upon reaching the plano area the plt could not…
- [NTSB MIA85LA149](https://openairdocs.org/ntsb/MIA85LA149.md): Piper PA-24-250 · Fellsmere, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 1985 · N5836P · Substantial damage
  > The acft made a forced landing due to fuel exhaustion in an open field. On the landing roll, the nosewheel struck a ditch causing it to fold and the acft came to a stop resting on it's nose. The plt had determined the amount of fuel on board prior to takeoff…
- [NTSB LAX85LA211](https://openairdocs.org/ntsb/LAX85LA211.md): Cessna T210N · White Mountain, AZ · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N2497U · Substantial damage
  > While cruising at 12,000 ft MSL, the acft began picking up ice. The plt continued flying toward his intended destination & climbed to 14,000 ft MSL. The acft's windshield completely iced over. The plt lost control of the acft & it went into an uncontrolled…

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

## 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=340

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.