# 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 321 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CHI86LA214](https://openairdocs.org/ntsb/CHI86LA214.md): Piper PA-12 · Menominee Falls, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1986 · N3736M · Substantial damage
  > The plt stated that the eng had quit 3 times in the past 2 weeks. The purpose of the flt was to insure that the eng was working properly. During takeoff, it lost power at about 100 ft AGL. The plt tried to turn & land on the sw part of the arpt. However, a…
- [NTSB CHI86FER17](https://openairdocs.org/ntsb/CHI86FER17.md): Eugene Boos VARI-EZE · Rice Lake, WI · Accident · Serious injuries · Final report · Aug 30, 1986 · N41EB · Destroyed
  > During cruise flight the engine of this homebuilt aircraft began running rough. The pilot turned toward an airfield approximately 15 miles away, but was forced to perform a forced landing about 5 miles short of this field because, following a loud metallic…
- [NTSB ATL86LA233](https://openairdocs.org/ntsb/ATL86LA233.md): Beech C35 · Akron, OH · Accident · No injuries · Limited investigation · Final report · Aug 30, 1986 · N5891C · Substantial damage
  > The plt stated that one to two minutes after the fuel selector was changed from the right to left tank, the eng quit. The aux pump was turned on and fuel selector changed back to the right tank. Then to aux tank then back to left tank. The engine would not…
- [NTSB SEA86LA228](https://openairdocs.org/ntsb/SEA86LA228.md): Cessna 152 · Lummi Island, WA · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · GYWR · Destroyed
  > The plt stated he remembers passing arlington, WA, at an alt of aprx 2,000 ft MSL but, remembers nothing else until the acft collided with trees. The plt believes that he fell asleep during the flt.
- [NTSB CHI86FA215](https://openairdocs.org/ntsb/CHI86FA215.md): Cessna 172P · Grayslake, IL · Accident · No injuries · Field investigation · Final report · Aug 29, 1986 · N53700 · Substantial damage
  > Drg cruise flt, there was a loss of eng power (decreasing to 1900 RPM). The plt initiated a precautionary landing on rwy 27, but overran the intended landing area. The acft contd beyond the end of the rwy & subsequently flipped over in a corn field, west of…
- [NTSB ATL86LA232](https://openairdocs.org/ntsb/ATL86LA232.md): Cessna 150H · Rome, GA · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · N22144 · Substantial damage
  > The plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…
- [NTSB MIA86LA244](https://openairdocs.org/ntsb/MIA86LA244.md): Piper PA-28-R · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N4524J · Substantial damage
  > The plt stated that he lost fuel pressure and all attempts to restart the acft were to no avail. He tried to make it to Cedar Key but was unable and ditched in the ocean waters 6 miles northwest of Cedar Key. Post crash examination of the fuel system revealed…
- [NTSB SEA86FA225](https://openairdocs.org/ntsb/SEA86FA225.md): Cessna 340A · Mesquite, NV · Accident · 2 fatal · Field investigation · Final report · Aug 26, 1986 · N340MV · Destroyed
  > While en route, the plt was cleared to deviate 20 deg left of course to avoid thunderstorm (tstm) activity that ARTCC radar showed was rgt of course. The plt rprtd turbc, but demurred descending to a lower alt despite a PIREP of clear wx below. He then rprtd…
- [NTSB MKC86LA175](https://openairdocs.org/ntsb/MKC86LA175.md): Piper PA-32-260 · Wilson, KS · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N3442W · Substantial damage
  > The pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…
- [NTSB LAX86LA331](https://openairdocs.org/ntsb/LAX86LA331.md): Cessna P210N · Salton City, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1986 · N5135A · Substantial damage
  > A total loss of power was experienced during a descent from 17,500' MSL to 10,000' MSL. Attempts to restart the engine failed and the acft was landed gear-up in a rocky field. Post accident inspection disclosed a track of internal electrical arcing in the…
- [NTSB ATL86LA226](https://openairdocs.org/ntsb/ATL86LA226.md): Cessna 150L · Campobello, SC · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N11154 · Substantial damage
  > While on her 2nd solo x-country flt, the student plt became lost/disoriented after the comm/nav radios developed a problem. Subsequently, she made a precautionary landing in an open field. During the landing roll, the acft hit a ditch & nosed over.
- [NTSB SEA86LA234](https://openairdocs.org/ntsb/SEA86LA234.md): Cessna 182 · Ashwood, OR · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N9051T · Substantial damage
  > A loss of power occurred for unknown reason. During landing roll the aircraft's right main gear struck a rock causing part of the gear box to be torn from the aircraft.
- [NTSB MIA86LA242](https://openairdocs.org/ntsb/MIA86LA242.md): Piper PA-28-140 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N6460W · Substantial damage
  > While in cruise flt the acft's eng failed and the acft was ditched in a river. Post crash eng exam revealed the no. 1 and no. 2 connecting rods separated from the crankshaft when both bolts failed on the no. 1 rod and 1 bolt failed on the no. 2 rod.…
- [NTSB LAX86LA343](https://openairdocs.org/ntsb/LAX86LA343.md): Piper PA-32-300 · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N4083R · Substantial damage
  > While en route to hawthorne airport the aircraft experienced a total loss of power. During a circling descent the pilot attempted to restart the engine without success. The aircraft collided with the terrain 500 ft short of rwy 27 at Riverside airport. The…
- [NTSB SEA86LA219](https://openairdocs.org/ntsb/SEA86LA219.md): Brennan Glasair · Mount Vernon, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1986 · N85KB · Substantial damage
  > The pilot arrived at the airport about one hour before fuel was available. He assumed that he had enough fuel remaining on board for the next leg of the flight because the duration would be about 10 minutes. About 5 minutes into the flight the aircraft's…
- [NTSB FTW86FPA26](https://openairdocs.org/ntsb/FTW86FPA26.md): Erickson S-1 · Garland, TX · Accident · No injuries · Final report · Aug 24, 1986 · N22JE · Substantial damage
  > The internal lining in the fuel tank flop tube (fuel pickup tube for inverted flight) deteriorated and blocked the full screen. The eng quit due to fuel starvation. The acft struck a short pole for an underground utility line during the forced landing
- [NTSB DEN86LA237](https://openairdocs.org/ntsb/DEN86LA237.md): Piper PA-38 · Santa Fe, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1986 · N24151 · Destroyed
  > While flying through a mountain pass at an alt of 1,000 ft AGL, the plt encountered downdraft wind currents. The acft entered an uncontrollable descent and impacted in an alpine meadow.
- [NTSB MIA86FA239](https://openairdocs.org/ntsb/MIA86FA239.md): Piper J3C-65 · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Aug 23, 1986 · N23266 · Substantial damage
  > Flight experienced loss of engine power while climbing through 200 feet shortly after takeoff. While attempting to return to the runway the aircraft collided with trees and the ground coming to rest adjacent to the runway. Examination of aircraft records…
- [NTSB NYC86FA214](https://openairdocs.org/ntsb/NYC86FA214.md): Piper PA-24-260 · Ft. Dix, NJ · Accident · 3 fatal · Field investigation · Final report · Aug 22, 1986 · N8734P · Destroyed
  > The acft was headed sw on victor sixteen inbound to coyle VOR when the plt reported the loss of gyro instruments. The acft was at 6000 ft and in 'solid IFR weather.' The plt elected not to declare emergency and land when asked if he wanted to do so by ATC.…
- [NTSB ATL86FA223](https://openairdocs.org/ntsb/ATL86FA223.md): Bellanca 17-30 · West Green, GA · Accident · 2 fatal · Field investigation · Final report · Aug 21, 1986 · N6655V · Destroyed
  > The plt took off at 1259 EDT, & at 1318, he reported level at 10,000'. There was no further comm with the acft. At about 1342, radar contact was lost. Subsequently, the acft wreckage was fnd scattered over a 425 yd area, along a sw azmith, aprx 1/2 mi from…
- [NTSB SEA86LA201](https://openairdocs.org/ntsb/SEA86LA201.md): Cessna 210F · Lages, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 1986 · N1873F · Substantial damage
  > The plt was unable to divert around numerous thunderstorms along in his flight path. Subsequently, he made a precautionary landing on a soft, dry lake bed were the aircraft nosed over.
- [NTSB LAX86FA326](https://openairdocs.org/ntsb/LAX86FA326.md): Cessna 182N · Wilmington, CA · Accident · Serious injuries · Field investigation · Final report · Aug 20, 1986 · N92252 · Destroyed
  > During a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…
- [NTSB FTW86LA152](https://openairdocs.org/ntsb/FTW86LA152.md): Hughes 369-500D · Fort Stockton, TX · Accident · No injuries · Limited investigation · Final report · Aug 20, 1986 · N4493M · Substantial damage
  > The helicopter pilot entered autorotation after experiencing fuel exhaustion. The pilot knew he was low on fuel, but was depending on his warning light to indicate low fuel. The warning light never came on. On touchdown the tail rotor struck the ground…
- [NTSB ANC86FA130](https://openairdocs.org/ntsb/ANC86FA130.md): Cessna 177RG · Hinchinbrook Is, AK · Accident · 3 fatal · Field investigation · Final report · Aug 19, 1986 · N52137 · Substantial damage
  > At 1323 adt, the plt rprtd near Hinchinbrook island & requested clearance for an ndb-a apch to the cordova mile 13 arpt. About 3 min later, cordova fss provided clearance for the apch 'from over Hinchinbrook.' Radar data showed that the acft flew to the…
- [NTSB SEA86LA212](https://openairdocs.org/ntsb/SEA86LA212.md): Mooney M-20-J · Aurora, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1986 · N201PJ · Destroyed
  > At about 9,000 feet MSL the pilot smelled smoke and electrical fumes. He then turned off the master switch and returned to land. He manually lowered the landing gear but it folded upon landing roll. Investigation revealed no mechanical reason for the gear to…
- [NTSB MIA86LA238](https://openairdocs.org/ntsb/MIA86LA238.md): Champion 7KCAB · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Aug 17, 1986 · N1638G · Substantial damage
  > The plt stated that while he was towing a banner the engine lost fuel pressure and the RPM began to deteriorate. He dropped his banner and tried to make it back to the airport but couldn't and landed short of runway 29 in the water. Post crash examination of…
- [NTSB NYC86FA213](https://openairdocs.org/ntsb/NYC86FA213.md): Piper PA-46-310P · West Mifflin, PA · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1986 · N27EE · Destroyed
  > At 2232 EDT, the acft was climbing to 15000 feet when the pilot reported a low oil pressure light. ATC advised jimmy stewart field is about eleven thirty and 15 miles. After the pilot asked, 'is that a tower field?', ATC advised he did not know, westmoreland…
- [NTSB BFO86FIA02](https://openairdocs.org/ntsb/BFO86FIA02.md): Piper PA 28-161 · Stanley, VA · Accident · Serious injuries · Final report · Aug 16, 1986 · N36489 · Destroyed
  > The acft collided with trees and the ground during a x-country flt over mountainous terrain. The plt had crossed the 1st ridge at aprx 800 ft AGL according to the plt. The front seat passenger said later that he complained several times during the flt that…
- [NTSB ATL86FEI09](https://openairdocs.org/ntsb/ATL86FEI09.md): Cessna 182 · Glen Willow, OH · Accident · No injuries · Final report · Aug 15, 1986 · N52494 · Destroyed
  > The acft was damaged during collision with scrub pine trees during a forced lndg on a road after the eng quit in flt. The plt said he was cruising at 3500 ft when the eng began to sputter. The plt stated that he changed the fuel tank selector from left to…
- [NTSB MIA86LA235](https://openairdocs.org/ntsb/MIA86LA235.md): Piper PA-23-250 · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Aug 14, 1986 · N36LS · Substantial damage
  > Flt experienced loss of power in the left engine shortly after takeoff due to corrosion blocking the main jet in the fuel control unit. The pilot feathered the engine and returned for a landing. While on short final he remembered he would have to manually…
- [NTSB FTW86LA148](https://openairdocs.org/ntsb/FTW86LA148.md): Cessna P210N · Altus, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 1986 · N731RR · Destroyed
  > The engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…
- [NTSB LAX86FVM06](https://openairdocs.org/ntsb/LAX86FVM06.md): Hiller UH21E · Salinas, CA · Accident · No injuries · Final report · Aug 12, 1986 · N169HA · Substantial damage
  > The plt experienced a 'ratcheting' to the right and a decrease in rotor RPM during cruise flt at 75-100 ft AGL. The plt made an autorotation but could not cushion the landing due to the low alt and lack of rotor RPM. The helicopter impacted hard and…
- [NTSB LAX86FUJ05](https://openairdocs.org/ntsb/LAX86FUJ05.md): Air Tractor AT301 · Gilbert, AZ · Accident · No injuries · Final report · Aug 12, 1986 · N4410S · Substantial damage
  > During the 'last pull-up' from an aerial application, flt the pilot noticed a low fuel pressure light indication. While returning to the airport the engine quit. The pilot utilized the hand operated wobble pump to restart the engine. The engine restarted then…
- [NTSB MKC86FCJ04](https://openairdocs.org/ntsb/MKC86FCJ04.md): Amateur Built Quickie Q2 · Grand Island, NE · Accident · Minor injuries · Final report · Aug 11, 1986 · N39202 · Destroyed
  > The acft engine developed severe roughness during cruise and the plt decided to make an emergency landing. During approach, the engine quit and the plt attempted a tight turn to the runway. During the turn, the aircraft hit the asphalt ramp in a left wing…
- [NTSB FTW86LQG16](https://openairdocs.org/ntsb/FTW86LQG16.md): Piper PA-36-375 · Plainview, TX · Accident · No injuries · Final report · Aug 11, 1986 · N2370X · Substantial damage
  > The pilot stated that he ran out of fuel as he was returning from an agricultural application flight. While landing in cotton rows, the gear collapsed and the aircraft was substantially damaged.
- [NTSB ATL86FA218](https://openairdocs.org/ntsb/ATL86FA218.md): Hughes 269C · Laurens, SC · Accident · No injuries · Field investigation · Final report · Aug 11, 1986 · N7442F · Destroyed
  > The plt was flying an underground cable patrol at 500-600 ft AGL when the accident occurred. The plt reported pwr was set at 20' hg, 3,000 RPM when a 'very loud pop' was heard. The plt likened the sound to being hit by ground fire. The acft yawed and the eng…
- [NTSB SEA86FA188](https://openairdocs.org/ntsb/SEA86FA188.md): Grumman AA-5 · Cleveland, WA · Accident · 1 fatal · Field investigation · Final report · Aug 10, 1986 · N5481L · Destroyed
  > The low time pilot departed with two relatives aboard for a local flight. The aircraft was observed flying low over omak lake and then commencing a climbing left turn toward higher terrain. During the climbout, the pilot perceived a loss of engine performance…
- [NTSB LAX86LA319](https://openairdocs.org/ntsb/LAX86LA319.md): Piper PA-28-140 · Rancho Mirage, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1986 · N56189 · Substantial damage
  > The aircraft's engine lost power about thirty minutes after take-off and a forced landing was attempted. During the investigation the engine was started and run. It ran rough and would develop only partial power. The carburator was disassembled and a piece of…
- [NTSB LAX86FA320](https://openairdocs.org/ntsb/LAX86FA320.md): Bellanca 7GCBC · Van Nuys, CA · Accident · No injuries · Field investigation · Final report · Aug 9, 1986 · N50443 · 2 aircraft · Substantial damage
  > Two plts, 1 flying Bellanca 7GCBC, N50443, the other flying champion 7KCAB, N443E, took their girl friends on a flt which included formation flying. The champion plt rprtd he flew formation with the Bellanca with aprx a 20' spread. Rprtdly, about half way…
- [NTSB FTW86LA146](https://openairdocs.org/ntsb/FTW86LA146.md): Piper PA-28-R-180 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Aug 9, 1986 · N3930T · Substantial damage
  > Private pilot of a Piper PA-28R-180 departed runway 15 at west Houston airport (iws), Houston, Texas. Pilot stated he had departed runway 15 when engine quit at approximately 600 feet AGL. Pilot executed a forced landing approximately 2 miles off the…
- [NTSB FTW86LA132](https://openairdocs.org/ntsb/FTW86LA132.md): Boeing 727-200 · Dfw Airport, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 1986 · XAMXG · No damage
  > The aircraft was in smooth air and in straight and level flight. The 'fasten seat belt' sign was illuminated. A male passenger went to the forward lavatory and fell, injuring his head and back. The floor was dry and there was no loose or torn carpet ot other…
- [NTSB ATL86LA219](https://openairdocs.org/ntsb/ATL86LA219.md): Piper PA-28-140 · Tiffin, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1986 · N8470R · Substantial damage
  > About four minutes after take-off the engine lost power and the pilot attempted a forced landing in a corn field. Examination of the aircraft showed water and other contamination in the fuel system.
- [NTSB NYC86FA201](https://openairdocs.org/ntsb/NYC86FA201.md): Aero Commander 680FL · Duxsbury, VT · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1986 · N6341U · Destroyed
  > The plt was on a VFR flight from montpelier, VT to burlington, VT; a distance of about 80 mis. A mountain range is between the two location. Shortly after takeoff the plt radioed burlington approach control and requested an IFR clearance to land at…
- [NTSB MIA86LA230](https://openairdocs.org/ntsb/MIA86LA230.md): Mooney M20E · Arcadia, FL · Accident · No injuries · Limited investigation · Final report · Aug 8, 1986 · N1996Y · Substantial damage
  > During cruise, the plt attempted to switch fuel tanks and the fuel selector valve became stuck in the 'off' position. A successful gear-up forced ldg was made in a field. An exam of the valve confirmed that it was stuck due to corrosion and rust, the…
- [NTSB FTW86LA144](https://openairdocs.org/ntsb/FTW86LA144.md): Cessna A185F · Slidell, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1986 · N92BT · Substantial damage
  > The eng lost power during flt, & subsequently, the plt made a forced landing in a wooded area about 4 mi from the destn arpt. During an investigation, insufficient fuel was found remaining in the tanks & lines to permit continued eng operation. The eng…
- [NTSB MKC86LA167](https://openairdocs.org/ntsb/MKC86LA167.md): Aero Commander 500-B · Emporia, KS · Accident · No injuries · Limited investigation · Final report · Aug 7, 1986 · N184KC · Substantial damage
  > The pilot stated that he was cruising at 6,000 feet in IMC with light to moderate rain and turbulence when he heard a bang followed by the left engine losing power. The engine was shut down, the propeller feathered and ATC was notified. ATC cleared, and the…
- [NTSB DEN86LA222](https://openairdocs.org/ntsb/DEN86LA222.md): Boeing E75 · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Aug 7, 1986 · N1387V · Substantial damage
  > The plt rprtd that he encountered a downdraft while crossing a ridgeline in mountainous terrain, aprx 5 mi NE of Tooele,UT. The elev of the acdnt site was about 9,000 ft & the temp was rprtd by the plt to be 80 deg. This would have resultedin a density alt of…
- [NTSB DEN86LA221](https://openairdocs.org/ntsb/DEN86LA221.md): Piper PA-24-250 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 7, 1986 · N7681P · Substantial damage
  > The plt rprtd the acft was refueled to capacity at longmont, CO. Full capacity should have provided at least 3.6 hrs of flying time at normal consumption. After refueling, the acft was flown 1.3 hrs to fowler, CO, where it remained parked for a week. The plt…
- [NTSB LAX86FA314](https://openairdocs.org/ntsb/LAX86FA314.md): Cessna 421C · Callahan, CA · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1986 · N98998 · Destroyed
  > After dropping company executives off at medford, the pilot was to return to santa rosa empty. Witnesses along the 25 NM valley which ends at the accident site reported that the aircraft buzzed their locations at AGL altitudes variously described as '10 feet'…
- [NTSB CHI86FA200](https://openairdocs.org/ntsb/CHI86FA200.md): Piper PA-28-235 · Shelby, IN · Accident · 4 fatal · Field investigation · Final report · Aug 6, 1986 · N4383X · Destroyed
  > The non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…

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

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

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