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

## Cases, newest first

- [NTSB MIA86LA154](https://openairdocs.org/ntsb/MIA86LA154.md): Piper PA-38-112 · Daytona Beach, FL · Accident · Minor injuries · Limited investigation · Final report · May 11, 1986 · N4374E · Substantial damage
  > Flt experienced engine failure while descending for landing. While approaching a field for a forced landing the aircraft struck electrical power lines and then crashed into the field. The engine was operated to full power after the accident with no evidence…
- [NTSB NYC86FA127](https://openairdocs.org/ntsb/NYC86FA127.md): Robinson R-22A · East Fishkill, NY · Accident · 1 fatal · Field investigation · Final report · May 10, 1986 · N8511Z · Destroyed
  > A loss of control in flight for undetermined reasons.
- [NTSB LAX86LA215](https://openairdocs.org/ntsb/LAX86LA215.md): Boeing A75 · Angels Camp, CA · Accident · Minor injuries · Limited investigation · Final report · May 10, 1986 · N56760 · Destroyed
  > Numerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…
- [NTSB DEN86FA131](https://openairdocs.org/ntsb/DEN86FA131.md): Piper PA-28B-140 · Salt Lake City, UT · Accident · 1 fatal · Field investigation · Final report · May 10, 1986 · N8043N · Destroyed
  > Plt and pax departed slc at 0930 for sightseeing cross country trip to heber city and return. Plt said plan was to fly through lambs canyon and parley's canyon. Acft hit tree and crashed at 8040 ft MSL level in lambs canyon at approximately 0955. Terrain…
- [NTSB NYC86LA122](https://openairdocs.org/ntsb/NYC86LA122.md): Cessna 182P · Otselic, NY · Accident · Minor injuries · Limited investigation · Final report · May 8, 1986 · N7313Q · Substantial damage
  > The Cessna 182P was cruising at 2500 ft when it experienced an engine failure. The pilot made a landing in a plowed field across the furrows. The nose wheel broke off on landing and the aircraft flipped over. The pilot received minor injuries while the…
- [NTSB NYC86LA121](https://openairdocs.org/ntsb/NYC86LA121.md): Cessna T337HPII · Newburg, PA · Accident · Minor injuries · Limited investigation · Final report · May 8, 1986 · N1030V · Substantial damage
  > The Cessna 337P experienced fuel exhaustion and attempted a landing on a road. During the landing the aircraft struck telephone poles and received substantial damage. The pilot did not receive any injuries in the accident which occurred in visual…
- [NTSB MIA86LA150](https://openairdocs.org/ntsb/MIA86LA150.md): Schweizer G-164B · Shelby, MS · Accident · Minor injuries · Limited investigation · Final report · May 8, 1986 · N3632C · Substantial damage
  > After departure while making a turn the pilot reported the engine lost power and the aircraft settled into the trees. There was no evidence of a preexisting mechanical failure/malfunction.
- [NTSB DEN86MA129](https://openairdocs.org/ntsb/DEN86MA129.md): Gulfstream 690D · Price, UT · Accident · 6 fatal · Major investigation · Final report · May 7, 1986 · N200PR · Destroyed
  > At 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…
- [NTSB SEA86LA118](https://openairdocs.org/ntsb/SEA86LA118.md): Luscombe 8E · Juneau, AK · Accident · No injuries · Limited investigation · Final report · May 5, 1986 · N1312B · Substantial damage
  > Acft had history of water in fuel and the system was purged. During winter, the plt did not fly acft but ran the eng periodically. On the day of the accident, the plt refueled the acft, completed a normal pwr run-up and took off. Shortlyafter takeoff, a pwr…
- [NTSB DEN86FA125](https://openairdocs.org/ntsb/DEN86FA125.md): Boeing 737-200 · Almosa, CO · Accident · Serious injuries · Field investigation · Final report · May 5, 1986 · N28SW · No damage
  > A southwest airline company Boeing 737, flt no. 558 en route from denver, Colorado, to albuquerque, new Mexico, at FL 350, encountered severe clear air turbulence. The unexpected wx phenomena caused the acft to 'drop' suddenly resulting in two flt attendants…
- [NTSB MIA86FA146](https://openairdocs.org/ntsb/MIA86FA146.md): Cessna 150F · Pembroke Pines, FL · Accident · 1 fatal · Field investigation · Final report · May 4, 1986 · N8268S · Destroyed
  > A witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…
- [NTSB FTW86FA076](https://openairdocs.org/ntsb/FTW86FA076.md): North American SNJ-5 · Anadarko, OK · Accident · 1 fatal · Field investigation · Final report · May 4, 1986 · N43775 · Destroyed
  > The pilot radioed that he had smoke in the cockpit. He immediately made an emergency landng, down wind, in a farmer's field. Witnesses saw the aircraft's right wing drop before the plane touched down. The resulting impact tore the wings and engine off,…
- [NTSB DEN86LA127](https://openairdocs.org/ntsb/DEN86LA127.md): Glaser-Dirks DG-400 · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · May 4, 1986 · N40Z · Substantial damage
  > This experimental glider has a stowable 2 cycle eng mounted behind the cockpit. When the eng is stowed the glide ratio is about 40:1. When the eng is deployed but not running, the glide ratio is about 10:1. While returning after a 4 hr and 50 min flt the plt…
- [NTSB DEN86LA126](https://openairdocs.org/ntsb/DEN86LA126.md): Cessna 140 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · May 4, 1986 · N1949V · Substantial damage
  > The plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…
- [NTSB CHI86FA137](https://openairdocs.org/ntsb/CHI86FA137.md): Piper PA-23-150 · Warren, MI · Accident · 1 fatal · Field investigation · Final report · May 4, 1986 · N1373P · Destroyed
  > The acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…
- [NTSB ATL86FEK01](https://openairdocs.org/ntsb/ATL86FEK01.md): Cessna 182D · Mt. Gilead, OH · Accident · No injuries · Final report · May 4, 1986 · N8880X · Substantial damage
  > The acft collided with the ground in a plowed field during a forced landing after a power loss. Post acc inspection of the eng revealed 3 pieces of felt like seal material lodged in the carburetor venturi. This felt was identical to the missing seal from the…
- [NTSB MIA86LA145](https://openairdocs.org/ntsb/MIA86LA145.md): Piper 601P · Miami, FL · Accident · No injuries · Limited investigation · Final report · May 3, 1986 · N246G · Substantial damage
  > Nearing completion of an international flt of nearly 5 hrs duration, the flt advised ATC they were low on fuel & would like vectors to the nearest arpt. The flt was unable to make the arpt & a forced ldg was made in the everglades aprx 6 mi from the arpt. An…
- [NTSB LAX86FA207](https://openairdocs.org/ntsb/LAX86FA207.md): Cessna P210N · Long Beach, CA · Accident · Serious injuries · Field investigation · Final report · May 3, 1986 · N55MM · Substantial damage
  > While enroute from cincinnati, oh (luk), to torrance, CA, the airplane experienced a total engine power loss about 10 miles south of Long Beach airport (lgb), Long Beach, CA. The pilot attempted to land at lgb but the acft alt was insufficient. The acft…
- [NTSB LAX86FA206](https://openairdocs.org/ntsb/LAX86FA206.md): Mooney M20F · Morgan Hill, CA · Accident · 3 fatal · Field investigation · Final report · May 3, 1986 · N9309V · Destroyed
  > The pilot requested and received preflight weather briefings, twice, and was advised that VFR flight was not recommended. The flight departed and crashed into mountainous terrain that was obscured by adverse weather conditions. Witnesses reported that the…
- [NTSB FTW86FA073](https://openairdocs.org/ntsb/FTW86FA073.md): Partenavia P68C · Goudeau, LA · Accident · 1 fatal · Field investigation · Final report · May 1, 1986 · N3832E · Destroyed
  > The pilot received a weather briefing indicating IMC conditions existed at the point of departure and at reporting stations near the point of the first intended landing. (There was no reporting stations at the airport of intended landing). Weather conditions…
- [NTSB MIA86LA139](https://openairdocs.org/ntsb/MIA86LA139.md): Wing D-1 · Bunnell, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 1986 · N8601E · Substantial damage
  > The plt stated that his canopy had come open and he was trying to hold it closed and make an emergency landing on runway 29 at flagler co. airport, but being too low and fast the acft struck the ground about 100 ft short of the runway and slid to a stop.
- [NTSB LAX86LA202](https://openairdocs.org/ntsb/LAX86LA202.md): Schweizer SGS 2-32 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1986 · N2750Z · Substantial damage
  > According to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.
- [NTSB DEN86LA121](https://openairdocs.org/ntsb/DEN86LA121.md): Piper PA-25-260C · Lamar, CO · Accident · No injuries · Limited investigation · Final report · Apr 30, 1986 · N76LF · Substantial damage
  > During the initial telephone interview, the plt stated the eng quit due to fuel exhaustion while returning from an ag spraying flt. However, in the plt accident report, the plt states that he could not rule out mechanical problems.
- [NTSB LAX86LA199](https://openairdocs.org/ntsb/LAX86LA199.md): Cessna 177RG · Placerville, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1986 · N34020 · Destroyed
  > While enroute to san francisco, CA the engine began to overspeed & the prop gov control was not effective in arresting/controlling the overspeed condition. Shortly thereafter the engine oil pressure depleted to zero. The pilot elected to land in the ice house…
- [NTSB LAX86LA201](https://openairdocs.org/ntsb/LAX86LA201.md): Cessna 150M · Torrey Pines, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1986 · N704PL · Substantial damage
  > The student plt was on the final leg of a x-country flt when the eng quit. A forced landing was attempted on a beach during which the acft nosed over. The plt stated that he purchased 5.9 gallons of fuel at one of his points of landing. He did not report how…
- [NTSB SEA86LA251](https://openairdocs.org/ntsb/SEA86LA251.md): Stinson 108-1 · Grangeville, ID · Accident · 2 fatal · Limited investigation · Final report · Apr 27, 1986 · N8165K · Destroyed
  > Plt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…
- [NTSB LAX86LA193](https://openairdocs.org/ntsb/LAX86LA193.md): Fairchild Hiller FH-1100 · Keaau, HI · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N5067F · Destroyed
  > A hiller 1100 was destroyed by fire after a forced landing. The plt indicated that the EGT had risen to approximately 800 deg c from 700 deg and then rose to 1100 deg. The heat warning light illuminated. The plt initiated a precautionary landing. The eng…
- [NTSB LAX86FVM05](https://openairdocs.org/ntsb/LAX86FVM05.md): Hiller UH12E · Castroville, CA · Accident · Minor injuries · Final report · Apr 27, 1986 · N5374V · Destroyed
  > The acft landed hard and rolled over after the lndg skid failed in a forced lndg. The plt said he was crusing at 500 ft AGL over an open field when he heard a loud bang. The helicopter began to vibrate severely and spiral to the right. The plt lost ground…
- [NTSB CHI86LA134](https://openairdocs.org/ntsb/CHI86LA134.md): Brantly Helicopter B-2B · Mt Clemens, MI · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1986 · N2194U · Destroyed
  > After aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…
- [NTSB MIA86LA136](https://openairdocs.org/ntsb/MIA86LA136.md): Piper PA-18 · Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1986 · N2411P · Substantial damage
  > While towing a banner near the beach the aircraft's engine failed. The aircraft was ditched in the atlantic ocean and the pilot swam to shore. The pilot stated he became distracted watching the boats and failed to switch fuel tanks causing the right fuel tank…
- [NTSB MIA86FA135](https://openairdocs.org/ntsb/MIA86FA135.md): Cessna 172D · St. Petersburg, FL · Accident · Serious injuries · Field investigation · Final report · Apr 26, 1986 · N2321U · Substantial damage
  > While on second attempt to pick up an aerial advertising banner the flight captured the banner and as it pulled up to climb out the pilot stated the aircraft would not climb. The aircraft then stalled and crashed to the ground in a nose low left wing low…
- [NTSB LAX86LA192](https://openairdocs.org/ntsb/LAX86LA192.md): Piper PA-30 · Coolidge, AZ · Accident · No injuries · Limited investigation · Final report · Apr 26, 1986 · N7280Y · Substantial damage
  > The plt shut down the acft eng when it surged during an encounter with turbulence. The plt initiated a precautionary downwind landing on a nearby airstrip and the acft overran the rwy and collided with a fence.
- [NTSB SEA86LA110](https://openairdocs.org/ntsb/SEA86LA110.md): Robinson R22-A · Portland, OR · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N8536Z · Substantial damage
  > At aprx 500 ft AGL, while on a local traffic watch, a loss of pwr occurred. A 15 kt tail wind was present. Pwr lines had to be cleared and a hard landing resulted. An examination and test run of the eng failed to disclose any failure/ malfunction which would…
- [NTSB MIA86LA133](https://openairdocs.org/ntsb/MIA86LA133.md): Bell 206-L-3 · Miami Shores, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N71FW · Substantial damage
  > The plt stated that he experienced generator failure upon departure from key west & elected to continue his flt to opa-locka, FL, making two stops enroute. He noted that his battery was dead after passing ocean reef, landed at watson island & then took off…
- [NTSB DEN86FA120](https://openairdocs.org/ntsb/DEN86FA120.md): Convair 580 · Denver, CO · Accident · Serious injuries · Field investigation · Final report · Apr 25, 1986 · N73104 · No damage
  > N73104 was operating as aspen airway flt 416, scheduled pax service from aspen to Denver. The flt proceeded uneventfully until light turb was encounterd near Denver. The captain had authorized the flt attendant to perform beverage svc. After completing the…
- [NTSB ATL86LA118](https://openairdocs.org/ntsb/ATL86LA118.md): Taylorcraft BLT-65 · Mount Airy, NC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1986 · N27529 · Substantial damage
  > The pilot stated that the engine lost power to idle RPM followed by a forced landing in trees. Examination of the aircraft determined that a snap ring which held the throttle cable housing in place in the instrument panel came loose. Without the snap ring the…
- [NTSB SEA86LA108](https://openairdocs.org/ntsb/SEA86LA108.md): Piper PA-36 · Mattawa, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1986 · N57608 · Substantial damage
  > Shortly after takeoff a loss of pwr occurred accompanied by an eng vibration. A forced landing was made onto a highway where a x-wind existed. Directional control was lost and the acft veered into a ditch and struck a fence before coming to a stop. No reason…
- [NTSB LAX86LA191](https://openairdocs.org/ntsb/LAX86LA191.md): Cessna 150J · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Apr 24, 1986 · N60126 · Substantial damage
  > The pilot was flying a round-robin flight from cottonwood, AZ to page, AZ, and return. The pilot had landed at page, AZ. While on the return leg of the flight the pilot noted his fuel gauges were 'low' and diverted to Flagstaff, AZ. When the acft was…
- [NTSB SEA86LA109](https://openairdocs.org/ntsb/SEA86LA109.md): Grumman G164-A · Echo, OR · Accident · No injuries · Limited investigation · Final report · Apr 23, 1986 · N25SK · Substantial damage
  > A loss of power occurred shortly after takeoff on a downwind departure. A forced landing was accomplished onto a wheat field downhill. The aircraft nosed over during the landing roll. Post accident inspection of the aircraft disclosed fuel contamination.
- [NTSB LAX86LA187](https://openairdocs.org/ntsb/LAX86LA187.md): Schweizer SGS-2-33A · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1986 · N2032T · Substantial damage
  > A glider struck wires while on final apch to a field. The plt indicated that he was towed to an alt of 5,000 ft MSL (aprx 3,500 ft AGL). On release, he encountered a downdraft of more than 500 ft per minute and was only able to stay airborne 6 to 7 minutes.…
- [NTSB CHI86LA127](https://openairdocs.org/ntsb/CHI86LA127.md): Hughes 269A · Ft. Wayne, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1986 · N8752F · Destroyed
  > Approx 10-15 minutes after takeoff the student pilot lost control of the helicopter and crash landed into trees. Following the accident, the only unusual thing FAA personnel could locate was a failed horizontal stabilizer spar. Post-crash examination of the…
- [NTSB SEA86LA107](https://openairdocs.org/ntsb/SEA86LA107.md): Cessna 172 · Bonners Ferry, ID · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1986 · N70040 · Destroyed
  > The plt utilized updrafts to climb to 7800 ft to clear a mountain ridge which was covered with 'cap clouds'. On the lee side of the ridge a downdraft was experienced and the acft descended into the 'fog'. The plt reported the acft instruments were used to…
- [NTSB MIA86FA126](https://openairdocs.org/ntsb/MIA86FA126.md): Blythe Quickie · Eustis, FL · Accident · Serious injuries · Field investigation · Final report · Apr 20, 1986 · N316Q · Destroyed
  > The student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…
- [NTSB FTW86LA070](https://openairdocs.org/ntsb/FTW86LA070.md): Bellanca 17-300 · El Paso, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1986 · N4881V · Destroyed
  > The eng quit due to fuel starvation. The acft had been flown 2.6 hours on the main tanks. Normal operating time on the main tanks is 2.5 hours according to the owner's manual of the Bellanca viking 300 series. At the crash site the main tanks were found empty…
- [NTSB CHI86FA122](https://openairdocs.org/ntsb/CHI86FA122.md): Piper PA-28-140 · Westville, IN · Accident · 4 fatal · Field investigation · Final report · Apr 18, 1986 · N4491J · Destroyed
  > The plt was taking a friend and two of her acquaintances on a sightseeing ride when the acft crashed into a plowed farm field. The acft's weight was estimated to be 60 lbs under max allowable gross weight at the time of the crash. A witness near the crash…
- [NTSB LAX86LA181](https://openairdocs.org/ntsb/LAX86LA181.md): Piper PA-18-150 · Colusa, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1986 · N82182 · Substantial damage
  > The pilot reported that while on a pipeline aerial observation flight he encountered moderate to severe turbulence, snow showers and freezing rain. When he attempted to depart the area the aircraft began to shudder and vibrate to the extent that any further…
- [NTSB LAX86LA180](https://openairdocs.org/ntsb/LAX86LA180.md): Cessna 150K · Joshua Tree, CA · Accident · No injuries · Limited investigation · Final report · Apr 16, 1986 · N6398G · Substantial damage
  > The plt landed at the yucca valley arpt to refuel, but no fuel was available. The acft fuel gages registered 1/8 & 1/4 full, so the plt took off on a planned 7 min flt to another arpt. About 4 min after departing, fuel exhaustion occurred. During an emergency…
- [NTSB LAX86FA178](https://openairdocs.org/ntsb/LAX86FA178.md): Piper PA-28-181 · Beaumont, CA · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1986 · N28891 · Destroyed
  > When the non-instrument rated plt departed for the flt at about 2110 hrs, the wx conditions were marginal and deteriorating in the area. No record of a wx briefing was found. For unkn reasons, the plt was returning to the arpt after about 1 hr and 20 mns,…
- [NTSB LAX86DVA06](https://openairdocs.org/ntsb/LAX86DVA06.md): Bell UH-1B · Chowchilla, CA · Accident · Minor injuries · Final report · Apr 16, 1986 · N910PD · Destroyed
  > While returning from a spraying operation the plt observed that the main transmission oil pressure gage indicated zero. The plt reported that the engine master caution did not illuminate and that the oil temperature gage was normal. The plt stated that he…
- [NTSB SEA86LA105](https://openairdocs.org/ntsb/SEA86LA105.md): Bell 47G3B1 · Albany, OR · Accident · No injuries · Limited investigation · Final report · Apr 15, 1986 · N9417A · Substantial damage
  > The plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…

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

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

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