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

## Cases, newest first

- [NTSB LAX86LA292](https://openairdocs.org/ntsb/LAX86LA292.md): Piper PA-28-180 · Hyampom, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1986 · N6430J · Substantial damage
  > The aircraft's engine quit when the flight was 25 miles short of its intended destination and an emergency landing was attempted in a river. The pilot stated that according to his calculations, the aircraft should have had a no reserve endurance of 6 hours…
- [NTSB ATL86FEK03](https://openairdocs.org/ntsb/ATL86FEK03.md): Hiller UH-12E · Pataskala, OH · Accident · No injuries · Final report · Jul 15, 1986 · N136HA · Substantial damage
  > The acft autorotated to a forced landing after the eng quit at 600 ft AGL. The landing was made in a corn field. The plt told a FAA inspector at the scene that he had 8 gals of fuel remaining. When the fuel tank was drained it contained aprx 6 oz total. The…
- [NTSB MIA86LA209](https://openairdocs.org/ntsb/MIA86LA209.md): Piper PA-28R-200 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N9306N · Substantial damage
  > Flight experienced loss of engine oil and subsequent seizing of the engine at which time the aircraft was ditched in the gulf of Mexico. Post crash examination of the engine revealed the oil line from the propeller govenor to the engine nose case had failed…
- [NTSB MIA86FA208](https://openairdocs.org/ntsb/MIA86FA208.md): Airbus Industrie A300B4-2C · West Palm Bch, FL · Accident · Serious injuries · Field investigation · Final report · Jul 13, 1986 · N206EA · No damage
  > The captain stated that an announcement had been made that they were starting their descent into the miami area and turned the seatbelt sign on and the passengers had been instructed to return to their seats. Approximately 5 minutes later, turbulence was…
- [NTSB LAX86FA289](https://openairdocs.org/ntsb/LAX86FA289.md): American AA-1A · Santa Paula, CA · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1986 · N6339L · Destroyed
  > After working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…
- [NTSB FTW86LA126](https://openairdocs.org/ntsb/FTW86LA126.md): Piper PA-23-150 · Georgetown, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1986 · N2155P · Substantial damage
  > The instructor pilot was instructing his student pilot in an engine shutdown for a multi-engine instructor rating, after which the engine would not restart. The instructor decided to land at the closest airport. While on final approach another aircraft landed…
- [NTSB ATL86FEG02](https://openairdocs.org/ntsb/ATL86FEG02.md): Smith Miniplane · Miamisburg, OH · Accident · Serious injuries · Final report · Jul 13, 1986 · N26Z · Substantial damage
  > The acft crashed into a tree and the ground during a forced landing after a pwr loss from fuel exhaustion. The plt said that he had 10 gals of fuel at takeoff and after 20 mintues of flt the gauge indicated 5 gals. During the attempt to return to the arpt the…
- [NTSB LAX86LA287](https://openairdocs.org/ntsb/LAX86LA287.md): Cessna 150M · Sunnymead, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1986 · N704GW · Substantial damage
  > The newly certificated flight instructor departed on a local dual instructional flight with a first hour primary student. The CFI said that 'due to numerous distractions' he 'forgot to check the fuel level and departed on the flight without an adequate fuel…
- [NTSB FTW86LRD21](https://openairdocs.org/ntsb/FTW86LRD21.md): Grumman G-164A · Abbeville, LA · Accident · No injuries · Final report · Jul 11, 1986 · N4842B · Substantial damage
  > The pilot stated he experienced a loss of engine power and made a forced landing in a wet pasture where the aircraft flipped inverted before coming to a stop. Subsequent engine examination failed to reveal a reason for the power loss. The owner reported that…
- [NTSB ATL86LA195](https://openairdocs.org/ntsb/ATL86LA195.md): Cessna 150L · Shelbyville, KY · Accident · No injuries · Limited investigation · Final report · Jul 10, 1986 · N10949 · Substantial damage
  > The plt rented the acft without verifying the actual fuel onboard. He then flew to his pvt strip, 26 NM away, and gave 'several' pax hops. About 5 mins after takeoff for the flt to return the acft to the owner's field, the engine started running rough and…
- [NTSB DEN86LA186](https://openairdocs.org/ntsb/DEN86LA186.md): Luscombe 8A · Salida, CO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1986 · N1272K · Substantial damage
  > According to the plt, upon entering the mountain pass, the acft he was piloting encountered downdrafts from which he was unable to recover. The plt stated he bled off airspeed until contact with the trees. A local flt instructor who witnessed the accident…
- [NTSB NYC86LA174](https://openairdocs.org/ntsb/NYC86LA174.md): Hughes 500A · Fall River, MA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N4237D · Substantial damage
  > The flight encountered fog and haze during return flight to new bedford, Massachusetts. The pilot failed to maintain direction control of the helicopter and crashed into the north watuppa pond.
- [NTSB MKC86LA145](https://openairdocs.org/ntsb/MKC86LA145.md): Cessna 182A · Davis City, IA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N4773D · Substantial damage
  > Statements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…
- [NTSB FTW86LA124](https://openairdocs.org/ntsb/FTW86LA124.md): Cessna P-210N · Zachery, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1986 · N4UD · Substantial damage
  > The plt experienced a total loss of power due to fuel exhaustion during cruise flight. Approach control vectored him to a closer airport but the aircraft was beyond gliding distance and it collided with a house which was under construction. Inspection of the…
- [NTSB FTW86LA123](https://openairdocs.org/ntsb/FTW86LA123.md): Cessna 152 · Porum, OK · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N47802 · Substantial damage
  > The student pilot became disoriented during a cross-country flight. He was unable to find an airport and had to land in a field due to fuel exhaustion. During the attempted landing he had to maneuver to avoid a herd of cows and collided with a concrete fence…
- [NTSB CHI86FEX10](https://openairdocs.org/ntsb/CHI86FEX10.md): Bell 206L-II · Kokomo, IN · Accident · Minor injuries · Final report · Jul 7, 1986 · N1084L · Destroyed
  > The helicopter experienced a loss of power during cruise, for undetermined reasons, and was forced to make an emergency landing. Prior to touchdown the helicopter experienced a loss of directional control, due to a failed hydraulic pump, and collided with the…
- [NTSB CHI86FER13](https://openairdocs.org/ntsb/CHI86FER13.md): Bell 47G-5 · Elrosa, MN · Accident · 1 fatal · Final report · Jul 7, 1986 · N94458 · Destroyed
  > The helicopter was seen flying at a low altitude by witnesses and appeared to be flying straight and level and sounded normal. The helicopter impacted the ground in a northeasterly direction, 180 degrees from it's observed flight path. There were no witnesses…
- [NTSB ANC86LA103](https://openairdocs.org/ntsb/ANC86LA103.md): Cessna 170B · Tekanika River, AK · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N3162B · Substantial damage
  > The acft nosed over during the forced landing which followed a total loss of pwr. The plt reported he noted a decrease in oil pressure during cruise flt just prior to the pwr loss. Examination of the acft eng revealed that the #6 cylinder push rod had failed.
- [NTSB NYC86FA176](https://openairdocs.org/ntsb/NYC86FA176.md): Piper PA-28-180 · Seven Valleys, PA · Accident · 2 fatal · Field investigation · Final report · Jul 6, 1986 · N7562W · Destroyed
  > Aircraft departed york airport and crashed 5 min later. The engine sump oil quick drain had disconnected and was not found. Engine oil was exhausted and the engine seized. A tree and utility pole were found damaged. The ramp and runway at york airport did not…
- [NTSB LAX86LA281](https://openairdocs.org/ntsb/LAX86LA281.md): Cessna 175 · Atwater, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1986 · N7108M · Substantial damage
  > A Cessna 175 collided with a tree after a total loss of power during a VFR x-country flt. The plt indicated he experienced an eng failure at 2,000 ft MSL, while on descent, aprx 15 mi from his dest. He reported that the eng began to vibrate slightly. The…
- [NTSB CHI86FER12](https://openairdocs.org/ntsb/CHI86FER12.md): Piper PA-25-235 · New Richland, MN · Accident · Minor injuries · Final report · Jul 6, 1986 · N9824P · Substantial damage
  > The aircraft performed a forced landing which resulted in substantial damage. Water was found in the fuel system. Water was also found in the underground fuel supply used to refuel the crop duster.
- [NTSB NYC86LA175](https://openairdocs.org/ntsb/NYC86LA175.md): Cessna T210C · Manville, NJ · Accident · No injuries · Limited investigation · Final report · Jul 5, 1986 · N2320S · Substantial damage
  > During flight from princeton to kupper airport, aircraft suffered engine power loss for undetermined reasons. Aircraft crashed in an open field, causing substantial damage.
- [NTSB MIA86FA200](https://openairdocs.org/ntsb/MIA86FA200.md): Grumman G-164B · Vega Baja, PR · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1986 · N6915K · No damage
  > The plt of the Grumman ag cat allowed 2 parachutists to board the resticted catagory acft for a parachute jumping flt. Each parachutist was positioned on a wing with his arm crooked around the respective wing center strut. After takeoff, the parachutist on…
- [NTSB LAX86LA312](https://openairdocs.org/ntsb/LAX86LA312.md): Mooney M20F · Cloverdale, CA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1986 · N6762V · Substantial damage
  > The acft collided with wires following a loss of control. The plt indicated that he was following a river at 1,500 ft MSL at a slow airspeed when the stall warning sounded. The plt stated that he lowered the nose in a downdraft and recovered close to the…
- [NTSB CHI86LA166](https://openairdocs.org/ntsb/CHI86LA166.md): Piper PA-38-112 · Fraser, MI · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N9499T · Substantial damage
  > Aircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.
- [NTSB CHI86FEE05](https://openairdocs.org/ntsb/CHI86FEE05.md): Eipper Mxii · Aurora, IL · Accident · Serious injuries · Final report · Jul 4, 1986 · N4976X · Substantial damage
  > During cruise flight the ultralight experienced an inadvertent deployment of the drag chute accompanied by a failure of the drag chute to inflate. This resulted in an uncontrolled descent and subsequent impact with the terrain.
- [NTSB ATL86LA191](https://openairdocs.org/ntsb/ATL86LA191.md): Cessna 337F · Cherry Point, NC · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N1770M · Substantial damage
  > When the gear selector handle was placed in the up position the gear unsafe warning horn sounded. The plt reported a stall warning horn to ATC and returned to the airport and landed. Finding nothing wrong with the aircraft the plt. Took-off again. Whenthe…
- [NTSB ANC86LA099](https://openairdocs.org/ntsb/ANC86LA099.md): Piper PA-31-350 · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N4109E · Substantial damage
  > The plt stated there were mechanical problems with the acft but it was decided to fly it back to another arpt for repairs. Enroute the plt shut down the right eng because of an oil leak. While attempting to crossfeed fuel, the plt accidently pushed the left…
- [NTSB MIA86LA198](https://openairdocs.org/ntsb/MIA86LA198.md): Grumman G-164A · Okolona, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1986 · N6603 · Substantial damage
  > While in cruise flt at 100 feet en route to the spraying area the engine 'spit' twice and quit completely. During a forced landing in a field the aircraft encountered mud and nosed over coming to rest inverted. The engine had 100 hours before it was to be…
- [NTSB LAX86LA277](https://openairdocs.org/ntsb/LAX86LA277.md): Hiller UH-12C · Garberville, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N26186 · Substantial damage
  > The student plt had just taken off on a training x-country flt when the main rotor tachometer needle decreased below the engine tachometer needle. He turned the helicopter to return to the arpt but was unable to maintain altitude and landed hard in rough…
- [NTSB BFO86FID09](https://openairdocs.org/ntsb/BFO86FID09.md): Piper PA-28R-200 · Montpelier Sta., VA · Accident · No injuries · Final report · Jun 30, 1986 · N75006 · Substantial damage
  > The acft collided with 2 fences during an off arpt forced landing after a pwr loss. Post acc eng inspection showed internal failure of the eng. #2 connecting rod bolt failed in fatigue through 40 percent of the diameter. The remainder failed in tension. The…
- [NTSB NYC86LA160](https://openairdocs.org/ntsb/NYC86LA160.md): Hiller 12C · Lehighton, PA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N1042C · Substantial damage
  > The pilot of the Hiller 12C reported an overheated engine followed by an engine failure. During the forced landing the main rotor flexed and cut the tail boom off the the aircraft. The aircraft was examined. 10 oz. Of a liquid was found in the fuel system. 7…
- [NTSB LAX86LA272](https://openairdocs.org/ntsb/LAX86LA272.md): Cessna 150 · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N8729S · Substantial damage
  > The student pilot and passenger departed carble airport (ccb), upland, CA, on a visual flight rules personal flight to bullhead city, Arizona. The student plt reported while approaching Hesperia, CA at about 7,500 ft m.s.l. the engine began to experience an…
- [NTSB DEN86FA181](https://openairdocs.org/ntsb/DEN86FA181.md): Piper PA-28-236 · Townsend, MT · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1986 · N100WX · Destroyed
  > On 6/26/86, the plt & his wife had flown from helena, MT. To powell, WY, to visit family & relatives. On the day of the acdnt, he had consumed alcoholic beverages. Despite pleas fm his wife not to return to helena that evening, he elected to fly back. While…
- [NTSB SEA86LA156](https://openairdocs.org/ntsb/SEA86LA156.md): Cessna 188 · Durkee, OR · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N4835Q · Substantial damage
  > While crossing a mountain ridge at low altitude, the aircraft encountered downdrafts. The pilot was forced to land as he was unable to arrest the descent rate. The landing was accomplished onto very rough terrain.
- [NTSB NYC86LA168](https://openairdocs.org/ntsb/NYC86LA168.md): Bell 206B III · Moultonboro, NH · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N1068Y · Substantial damage
  > The Bell jet ranger had just dropped off an external load and was returning downhill when the pilot reported hearing a growling noise in the aft portion of the aircraft. He autorotated to landing as control was lost. When the wreckage was examined after it…
- [NTSB MKC86FA139](https://openairdocs.org/ntsb/MKC86FA139.md): Cessna 182J · Hartford, AR · Accident · 4 fatal · Field investigation · Final report · Jun 28, 1986 · N3328F · Destroyed
  > When the acft did not arrive at its destn, a search was initiated. The wreckage was located 4 days later where the acft crashed in mountainous terrain. An investigation revealed there was severe thunderstorm activity in the area at the time of the accident.…
- [NTSB DEN86LA179](https://openairdocs.org/ntsb/DEN86LA179.md): Cessna 152 · Fort Lupton, CO · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N757KB · Destroyed
  > The plt took off on a local flt with approximately 1/4 tank of fuel (6 gal). He flew the acft until the engine quit from fuel exhaustion at 1.2 hours flt time. The acft impacted in an open feild, nosed over, and came to rest in an inverted position. The plt…
- [NTSB ATL86LA183](https://openairdocs.org/ntsb/ATL86LA183.md): Cessna 152 · Memphis, TN · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1986 · N24847 · Substantial damage
  > While returning from an instrument training flight, the aircraft lost total power and the CFI attempted an emergency landing on a road. During the attempted landing the aircraft collided with a road sign and was substantially damaged. The pilot related that…
- [NTSB MKC86LA135](https://openairdocs.org/ntsb/MKC86LA135.md): Piper PA-28R-200 · Mammoth Spring, AR · Accident · No injuries · Limited investigation · Final report · Jun 26, 1986 · N44767 · Substantial damage
  > The pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…
- [NTSB MKC86LA133](https://openairdocs.org/ntsb/MKC86LA133.md): Piper PA-28RT-201T · Wathena, KS · Accident · No injuries · Limited investigation · Final report · Jun 26, 1986 · CGSMS · Substantial damage
  > The plt stated that according to the acft manual, he had enough fuel to fly to his destination in the usa. As such, he felt that no refueling was necessary when he landed at his designated airport-of-entry to clear customs. The acft ran out of fuel two miles…
- [NTSB ATL86FA182](https://openairdocs.org/ntsb/ATL86FA182.md): Cessna P210N · Lawrenceville, GA · Accident · Minor injuries · Field investigation · Final report · Jun 25, 1986 · N4825P · Substantial damage
  > The acft was damaged during a forced lndg on a hiway after the engine quit. The flt was nearing its destination on a VFR x-country when the engine lost power. The acft fuel tank selector was on the rt tank for 2 hrs before and during the emergency. After the…
- [NTSB LAX86MA275](https://openairdocs.org/ntsb/LAX86MA275.md): Boeing 747-122 · Pacific Ocean (Pacific Ocean) · Incident · No injuries · Major investigation · Final report · Jun 24, 1986 · N4718U · No damage
  > While ual flt 1 was cruising at FL 310, aprx 1.8 hr after takeoff, a flt attendant (f/a) rprtd a headache & lightheaded-ness. The flt climbed to FL 350, then another f/a & svrl pax rprtd similar symptoms. At that time, the tropopause was AT40,000'. As the flt…
- [NTSB NYC86LA156](https://openairdocs.org/ntsb/NYC86LA156.md): Beech B-60 · Toms River, NJ · Accident · No injuries · Limited investigation · Final report · Jun 23, 1986 · N6006S · Substantial damage
  > An inflight fire occurred shortly after takeoff. Smoke was observed trailing from the right eng & it was shut down. The plt returned & landed at the arpt. After landing, the fire was extinguished by linemen, a fireman & plts who were standing by. An…
- [NTSB NYC86FA158](https://openairdocs.org/ntsb/NYC86FA158.md): Beech V35B · Bradford, PA · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1986 · N4445D · Destroyed
  > The private, instrument rated pilot flying a Beechcraft V35 collided with the ground, in an inverted attitude 1.5 miles from the approach end of the runway while on an ILS approach during IFR conditions. Heavy rainshowers fog and lightning were observed in…
- [NTSB LAX86LA266](https://openairdocs.org/ntsb/LAX86LA266.md): Ercoupe 415-C · Planada, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1986 · N3220H · Substantial damage
  > The plt reported the eng coughed during cruise flt at an alt of 2000 ft AGL. He applied carburetor heat and the eng coughed again and lost power. The plt made a forced landing in a plowed field. The landing gear dug into the terrain and the acft nosed over.…
- [NTSB SEA86LA150](https://openairdocs.org/ntsb/SEA86LA150.md): Piper J3C · Kent, WA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N3667K · Substantial damage
  > A forced landing was made after a total loss of power. Landing was accomplished onto very rough rising terrain. During landing roll the left main gear collapsed. Investigation revealed a broken crankshaft. A top overhaul had been done less than 30 hours prior…
- [NTSB NYC86LA155](https://openairdocs.org/ntsb/NYC86LA155.md): Maule MX7-235 · Ardara, PA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N5661N · Substantial damage
  > The aircraft made a forced landing in a field after the pilot claimed control malfunction. However there was nothing found during the wreckage examination to substantiate this statement and the cause of this accident is undetermined.
- [NTSB MKC86LA131](https://openairdocs.org/ntsb/MKC86LA131.md): Charles S.Hatchette Quickie Q2 · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N162P · Substantial damage
  > The pilot experienced a gradual loss of engine power during cruise and made a forced landing to a field. During the landing roll, the plane hit a hole and nosed over. Examination found that a fuel vent line had melted closed in the vicinity of the exhaust…
- [NTSB DEN86LA173](https://openairdocs.org/ntsb/DEN86LA173.md): Beech K35 · Kim, CO · Accident · No injuries · Limited investigation · Final report · Jun 22, 1986 · N9544R · Substantial damage
  > The plt reports that he was cruising at 9,500 ft MSL when he encountered low broken clouds. He decided to descend below the clouds to assure remaining VFR. The plt said he retarded the throttle and descended to 7,000 ft MSL (1,000 ft AGL). When the throttle…

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

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

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