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

## Cases, newest first

- [NTSB LAX85FA123](https://openairdocs.org/ntsb/LAX85FA123.md): Cessna 120 · Irwindale, CA · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1985 · N9058Y · 2 aircraft · Destroyed
  > A Cessna 120, N9058Y, & a Cessna 152, N65599, collided in midair in the practice area for el monte, CA. Arpt. The two aircraft had departed the controlled arpt within three minutes of each other. Both had one instructor & one student aboard. The Cessna 152…
- [NTSB MIA85LA087](https://openairdocs.org/ntsb/MIA85LA087.md): Piper PA-22-150 · Belle Glade, FL · Accident · No injuries · Limited investigation · Final report · Jan 26, 1985 · N5614Z · Substantial damage
  > The acft was damaged landing in a cane field after the eng lost power in cruise. The plt stated in his report that the eng behavior suggested carb ice but 'apparently it was too late.' The owner checked the throttle cable after the accident and reported that…
- [NTSB MIA85IA086](https://openairdocs.org/ntsb/MIA85IA086.md): CASA 212 · Arecibo, PR · Incident · No injuries · Incident investigation · Final report · Jan 25, 1985 · N436CA · Minor damage
  > While on a scheduled international commuter flight during climb the crew noted a fire in the number one engine. The executed the emergency checklist and discharged two firebottles. The flames continued to exit the tailpipe. The crew executed a forced landing…
- [NTSB LAX85FA122](https://openairdocs.org/ntsb/LAX85FA122.md): Piper PA-24-400 · Helendale, CA · Accident · Minor injuries · Field investigation · Final report · Jan 24, 1985 · N3983D · Substantial damage
  > Shortly after initiating an enroute letdown, the acft experienced a catastrophic engine failure at about 4,500 ft MSL. Plt selected a road for an attempted emergency landing, but a car turned onto the road in front of him and forced a diversion to a nearby…
- [NTSB DEN85IA068](https://openairdocs.org/ntsb/DEN85IA068.md): Boeing 737-291 · Steamboat Sprin, CO · Incident · No injuries · Incident investigation · Final report · Jan 23, 1985 · N7343F · No damage
  > Shortly after departure from oakland, capt indicated he did not feel well. During the descent into den, the capt passed out for several minutes. He was revived with oxygen administered by a flt attendant. F/o made landing and capt taxied to the gate. Capt was…
- [NTSB LAX85FA119](https://openairdocs.org/ntsb/LAX85FA119.md): Cessna A185F · Pine Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jan 22, 1985 · N24BC · Destroyed
  > The acft crashed while the plt was returning from a x-country flt at night. Witnesses reported that the acft was flying low in a westerly direction & appeared to be following interstate highway 8. One witness, who was traveling westbound, stated that the acft…
- [NTSB FTW85FA100](https://openairdocs.org/ntsb/FTW85FA100.md): Bell 206L-1 · Lafayette, LA · Accident · No injuries · Field investigation · Final report · Jan 22, 1985 · N2762X · Substantial damage
  > The acft departed at 2040 CST as a flt of 2 on a ferry flt. Shortly after level-off at 700 ft and power stabilized at 72% torque the engine failed and the acft yawed left and right. An autoration was initiated into a soft plowed field with a slight…
- [NTSB LAX85LA117](https://openairdocs.org/ntsb/LAX85LA117.md): Hughes 369E · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Jan 21, 1985 · N121JP · Substantial damage
  > While in flt over water at about 400 ft AGL & 1/2 mi from shore, the plt saw a large flock of white birds. He reported that he flared to a stop, but was unable to avoid the birds. After the helicopter struck bird(s), an extreme vibration developed. The plt…
- [NTSB DEN85FA067](https://openairdocs.org/ntsb/DEN85FA067.md): Bell 206 L-1 · Carson, NM · Accident · 3 fatal · Field investigation · Final report · Jan 21, 1985 · N40TE · Destroyed
  > The helicopter crashed in open terrain during a turn to reverse direction. Witnesses stated the acft was heading north and was on a converging course with high tension lines that were about 80 to 100 ft high and the belly counted spotlight was illuminated…
- [NTSB FTW85LA098](https://openairdocs.org/ntsb/FTW85LA098.md): Cessna 182Q · Abilene, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1985 · N735QN · Destroyed
  > Deteriorating wx was encountered & the plt elected to land short of the original destn. He was provided vectors for an ILS apch to rwy 35R at abiline, TX. During the night apch, he encountered strong gusty winds, severe turbulence & restricted visibility. The…
- [NTSB DEN85LA066](https://openairdocs.org/ntsb/DEN85LA066.md): Cessna 152 · Canon City, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1985 · N4925M · Substantial damage
  > The acft contacted trees on mountainous terrain after encountering IFR wx en route. The plt reported that upon arriving in the Colorado springs area an undercast prevailed. He contacted pueblo apch and denver center and was advised that alamosa, CO, was…
- [NTSB ATL85FA079](https://openairdocs.org/ntsb/ATL85FA079.md): Cessna 340 · Johnson City, TN · Accident · 3 fatal · Field investigation · Final report · Jan 17, 1985 · N4124Q · Destroyed
  > The acft was IFR at 17000 ft flying thru wx SIGMET area for severe icing when the plt requested a descent due to airframe ice and turbulence. During the descent the plt reported shutting down the right eng. On final apch for an off-arpt landing attempt the…
- [NTSB MIA85FA081](https://openairdocs.org/ntsb/MIA85FA081.md): Cessna 210M · Stuart, FL · Accident · No injuries · Field investigation · Final report · Jan 16, 1985 · N6164N · Substantial damage
  > The acft eng failed in flt & the plt made an emergency landing at night in an open field. The field was on sandy terrain that had been contoured to be an orange grove. While landing on the uneven soft terrain, the acft was damaged. An exam of the eng revealed…
- [NTSB MIA85LA079](https://openairdocs.org/ntsb/MIA85LA079.md): Piper PA-32-300 · Floridana, FL · Accident · No injuries · Limited investigation · Final report · Jan 15, 1985 · N1496X · Substantial damage
  > During cruise flight the pilot noted the engine was vibrating severely and spraying oil and then failed. Examination of the engine revealed that the #2 cylinder connecting rod had failed in overload. A small piece of gear tooth was found inside the engine the…
- [NTSB DEN85LA063](https://openairdocs.org/ntsb/DEN85LA063.md): Cessna 150 · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Jan 15, 1985 · N1416Q · Substantial damage
  > On jan 14, 1985, a Cessna 150 nosed over after landing on a highway near Missoula, MT. The pilot stated he lost partial engine power due to carburetor icing conditions encountered enroute from great falls, MT. The pilot and his passenger were not injured. The…
- [NTSB CHI85LA087](https://openairdocs.org/ntsb/CHI85LA087.md): Cessna 150L · Central, IN · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1985 · N10543 · Substantial damage
  > The acft contacted a tree and nosed over during a forced landing following fuel exhaustion. The student plt was observed by several witnesses to to remove the fuel caps during preflight and check the fuel quantity. The plt stated the fuel level was up to the…
- [NTSB ATL85LA078](https://openairdocs.org/ntsb/ATL85LA078.md): Cessna 182C · Batesville, MS · Accident · No injuries · Limited investigation · Final report · Jan 12, 1985 · N9904T · Substantial damage
  > After discharging parachutists at 7500 ft MSL the plt closed the throttle and descended to 1200 ft without clearing the engine. No pwr was available when the throttle was advanced upon reaching 1200 ft. a forced landing was made in a bean fld and the acft…
- [NTSB LAX85LA113](https://openairdocs.org/ntsb/LAX85LA113.md): Fairchild M-62C · Ballico, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1985 · N68444 · Substantial damage
  > At the conclusion of a local aerial application flt, acft experienced a loss of power and collided with trees during the subsequent forced landing. Examinaton of the aircraft revealed a broken fuel feed line aft of the wobble pump and no fuel in the lines or…
- [NTSB ANC85FA036](https://openairdocs.org/ntsb/ANC85FA036.md): Bell 206BIII · Kenai, AK · Accident · 1 fatal · Field investigation · Final report · Jan 10, 1985 · N59619 · Destroyed
  > Flt was being conducted to off shore oil platform. Plt was checked out for off shore operations the day prior to this accident. Plt stated visibility above 500 ft was poor & he maintained 500 ft to stay below a stratus layer. Once over the water the only…
- [NTSB FTW85LA095](https://openairdocs.org/ntsb/FTW85LA095.md): Cessna 172N · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1985 · N73849 · Substantial damage
  > Initially, after a top overhaul, the eng would not run. The mechanic removed the carburetor & found a piece of silicon. After reinstalling the carburetor, the eng operated normally. The plt then took off on a maintenance test flt. As he began a descent back…
- [NTSB LAX85FA101](https://openairdocs.org/ntsb/LAX85FA101.md): Bell 206B · Trimmer, CA · Accident · Minor injuries · Field investigation · Final report · Jan 8, 1985 · N59549 · Substantial damage
  > The plt stated the helicopter lost pwr during cruise when he attempted to add pwr to climb. He stated that N2 decreased along with the activation of visual and audio engine out warnings. An autorotation was performed to a road, however, the helicopter slid…
- [NTSB LAX85FA100](https://openairdocs.org/ntsb/LAX85FA100.md): Beech B-35 · Death Valley, CA · Accident · 4 fatal · Field investigation · Final report · Jan 7, 1985 · N8889A · Destroyed
  > The plt got an extended wx fcst the day prior to departure which indicated bkn to ovc clouds based at about 8,000 ft for the first part of the trip & sct to bkn clouds for the last half. Mountain areas were predicted to be obscured. Plt was encouraged to call…
- [NTSB ATL85FA077](https://openairdocs.org/ntsb/ATL85FA077.md): Cessna R182 · Crossville, TN · Accident · 4 fatal · Field investigation · Final report · Jan 7, 1985 · N4716R · Destroyed
  > The acft collided with wooded, rising terrain at an elevation of about 2800 ft MSL on the west slope of hinch mountain. A passenger, who survived the crash, but died later due to burns, reported that light conditions were dark & she could not see anything…
- [NTSB MIA85LA073](https://openairdocs.org/ntsb/MIA85LA073.md): Piper PA-12 · Miramar, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 6, 1985 · N3362M · Substantial damage
  > An interruption of pwr was experienced as an abrupt steep dive maneuver was entered to release the banner towed by the acft. The plt then attempted a 180 deg turn at an alt of aprx 200 ft AGL to avoid pwr lines. The acft entered a high descent rate and…
- [NTSB LAX85LA098](https://openairdocs.org/ntsb/LAX85LA098.md): Crowder Great Lakes · Sunland, CA · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N13355 · Substantial damage
  > While cruising at 2100 ft AGL, the engine began to vibrate and a ttl loss of pwr occurred. Plt made forced landing into the top of a tree. Inspection revealed that the 4 hold down bolts/studs which hold the #2 cylinder to the case had failed allowing the…
- [NTSB DEN85LA060](https://openairdocs.org/ntsb/DEN85LA060.md): Beech B36TC · Billings, MT · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1985 · N6750C · Substantial damage
  > Plt used cannula connected to portable oxygen system during climb starting at 11,000 ft MSL. At FL 170 plt switched to a mask connected to acft oxygen ststem. At FL 250, plt complained of stomach pains for aprx 1/2 hr. Plt then stated to his son that his…
- [NTSB MKC85IA045](https://openairdocs.org/ntsb/MKC85IA045.md): Swearingen SA226TC · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jan 4, 1985 · N322BA · No damage
  > After departing st Louis and reaching cruise flt the crew experienced a continual trim pitch-up which had to be relieved by a reduced airspeed. No aural indication was noted by the crew. The return to the airport was uneventful. Follow-up inspection of the…
- [NTSB DEN85LA059](https://openairdocs.org/ntsb/DEN85LA059.md): Piper PA-18-150 · Rawlins, WY · Accident · Minor injuries · Limited investigation · Final report · Jan 4, 1985 · N3575Z · Substantial damage
  > The acft lost eng pwr and was substantially damaged during an off arpt energency landing. The purpose of the flt was to look for coyotes. The post accident eng exam revealed that 9 consecutive teeth on the left magneto drive gear were ground off. This allowed…
- [NTSB MKC85LA043](https://openairdocs.org/ntsb/MKC85LA043.md): Cessna 182P · Ellisonore, MO · Accident · No injuries · Limited investigation · Final report · Jan 3, 1985 · N20828 · Substantial damage
  > Plt obtained wx briefing for route from moline, IL, st. louis, MO, memphis, TX, to new orleans, LA. Plt was informed vfrwas not recommended in eastern Iowa but st. louis was VFR and forecast to be 1000 to 2000 ft broken to scattered all morning. VFR was also…
- [NTSB LAX85LA092](https://openairdocs.org/ntsb/LAX85LA092.md): Bell 2061-1 · Santa Barbara, CA · Accident · No injuries · Limited investigation · Final report · Jan 3, 1985 · N2246Q · Substantial damage
  > During takeoff & departure, the helicopter climbed to about 150 ft AGL & started to proceed over water. As it crossed over the shoreline near the end of the rwy, the eng flamed out. The plt turned about 120 deg back toward a Beech area & made an autorotative…
- [NTSB DEN85LA056](https://openairdocs.org/ntsb/DEN85LA056.md): Piper PA-28-181 · Yoder, CO · Accident · No injuries · Limited investigation · Final report · Jan 3, 1985 · N2112K · Substantial damage
  > Engine quit during cruise flight. Pilot made forced landing on dirt road during which the acft veered off the road and collided with a fence post. Fire department officials reported no evidence of fuel either in the fuel tanks or around the acft.
- [NTSB DEN85LA058](https://openairdocs.org/ntsb/DEN85LA058.md): Cessna 210B · Lordsburg, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 1985 · N101PQ · Substantial damage
  > Plt stated that during the flt the rt fuel tank was used until empty at which time the left tank was selected. Aprx 20 minutes after switching tanks and 2 hrs 35 minutes after departure, the engine backfired and subsequently quit. A forced landing was made…
- [NTSB DEN85FA055](https://openairdocs.org/ntsb/DEN85FA055.md): Cessna 310N · Edgewood, NM · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1985 · N5069Q · Destroyed
  > The pvt rated pilot did not hold a multiengine or instrument rating. The pilot and passenger were returning from vacation. A witness near the accident site stated that she saw the aircraft descend out of a low over last at a very steep nose down angle. The…
- [NTSB ATL85LA075](https://openairdocs.org/ntsb/ATL85LA075.md): Cessna 150J · Dublin, NC · Accident · No injuries · Limited investigation · Final report · Jan 1, 1985 · N50913 · Substantial damage
  > The pilot reported that the acft lost power in cruise flight and he attempted to land in an open field. He aborted the approach because of a tailwind and flew along a river for aprx 1 mile before ditching in the water. The acft sank in the river and the plt…
- [NTSB ATL85LA074](https://openairdocs.org/ntsb/ATL85LA074.md): Mooney M20J · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1984 · N201FR · Substantial damage
  > The pilot reported after takeoff from rwy 23 at 400 ft AGL a horn sounded. A student plt passenger stated the marker beacon, and stall warning horn came on. The plt however could not identify the horn. The plt lowered the nose of the acft, began a descent and…
- [NTSB DEN85LA052](https://openairdocs.org/ntsb/DEN85LA052.md): Cessna 172 · Ft. Collins, CO · Accident · No injuries · Limited investigation · Final report · Dec 30, 1984 · N9033H · Substantial damage
  > The plt reported that upon arrival at fort Collins, and while at cruise altitude, the eng suddenly lost power. During the emergency descent maneuvering he lost sight of the airport and landed in a plowed field. Post crash examination of eng revealed the…
- [NTSB ATL85LA073](https://openairdocs.org/ntsb/ATL85LA073.md): Piper PA-30 · Sparta, TN · Accident · No injuries · Limited investigation · Final report · Dec 30, 1984 · N7589Y · Substantial damage
  > Dual engine stoppage. Fuel tanks topped before takeoff. Plt had filed IFR en route but the wind had shifted to a 30 kt headwind. Plt became concerned about fuel remaining and made an instrument apch which was missed because of low clouds. During course to an…
- [NTSB ATL85FA070](https://openairdocs.org/ntsb/ATL85FA070.md): Robinson R22 · Moundsville, WV · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1984 · N9030B · Destroyed
  > The helicopter crashed aprx 1/2 mi from the marshall county arpt while on a personal flt. Investigaton revealed that the plt, a doctor who specialized in emergency room procedures, commuted between hospitals located in three different cities. The plt had been…
- [NTSB MIA85LA070](https://openairdocs.org/ntsb/MIA85LA070.md): Piper PA-31 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Dec 29, 1984 · N801BR · Destroyed
  > About 5 hrs & 10 mins after departure, both engs failed due to fuel exhaustion at 11,000 ft aprx 40 miles from haiti. According to the plt, the acft was using more fuel than normal and the destn was changed accordingly. A short time after initiating the…
- [NTSB MIA85IA069](https://openairdocs.org/ntsb/MIA85IA069.md): Cessna 402B · Sanford, FL · Incident · No injuries · Incident investigation · Final report · Dec 29, 1984 · N402PB · Minor damage
  > During cruise flt, the acft suddenly nosed down & began vibrating. Remedial action was taken & an uneventful emerg landing was made. An exam revealed that the bolt, nut & cotter pin (used to attach the elevator trim control rod to the elevator trim tab) were…
- [NTSB LAX85FA093](https://openairdocs.org/ntsb/LAX85FA093.md): Cessna 182P · Big Bear City, CA · Accident · 5 fatal · Field investigation · Final report · Dec 28, 1984 · N5948J · Destroyed
  > The acft crashed in a mountainous area while on a VFR personal flt to long beach, CA. The non-instrument rated private plt & 4 minor children aboard the acft were killed. By low clouds & there were extensive snow showers in the arearea the plt's log book…
- [NTSB MIA85MA064](https://openairdocs.org/ntsb/MIA85MA064.md): Piper PA-32R-301 · Bradley, FL · Accident · 6 fatal · Major investigation · Final report · Dec 27, 1984 · N8227J · Destroyed
  > The plt completed a 30 min insurance check flt, then loaded the acft with baggage/pax & departed decauter, IL on a flt to naples, FL. A refueling stop was made at columbus, GA. At 1750 the acft departed columbus & cruised uneventfully until sometime after…
- [NTSB MIA85FA066](https://openairdocs.org/ntsb/MIA85FA066.md): Piper PA-32R-300 · Homestead, FL · Accident · 2 fatal · Field investigation · Final report · Dec 27, 1984 · N8920C · Destroyed
  > While cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…
- [NTSB MIA85FA065](https://openairdocs.org/ntsb/MIA85FA065.md): Fairchild Hiller FH-1100 · La Belle, FL · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1984 · N8126H · Destroyed
  > The helicopter was observed flying at a low alt & lost all eng power, banked sharpley to the left, lost complete control & dove into the ground. The acft was destroyed by impact forces along with the post crash fire. No evidence to suggest a malfunction of…
- [NTSB CHI85LA079](https://openairdocs.org/ntsb/CHI85LA079.md): Piper PA-23-250 · New Philadelphi, OH · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N6505Y · Substantial damage
  > Plt felt vibration and reduced power on both engines to idle. Plt heard a 'thud' and discovered the left propeller had separated cutting through the nose of the acft as it departed. The propeller was not located. Two of the six propeller bolts remained with…
- [NTSB ATL85FA068](https://openairdocs.org/ntsb/ATL85FA068.md): Gyrocopter B-8M · Madisonville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1984 · UNREG · Destroyed
  > Student pilot attempting flight in Gyrocopter loss control cusing main rotor system to contact the rudder system. Pilot was not qualified to conduct this flight. A/c was not assigned an identification number.
- [NTSB LAX85FA086](https://openairdocs.org/ntsb/LAX85FA086.md): Cessna 172N · Livermore, CA · Accident · 1 fatal · Field investigation · Final report · Dec 26, 1984 · N5184D · Destroyed
  > The non-instrument rated pilot departed the arpt on a special VFR clearance. Wx at the time was 1,000 overcast, 2.5 miles in light rain and fog. Acft turned eastbound following a highway toward a pass in the hills to the east and collided with the rising…
- [NTSB FTW85FA088](https://openairdocs.org/ntsb/FTW85FA088.md): Mooney M20J · San Antonio, TX · Accident · 4 fatal · Field investigation · Final report · Dec 26, 1984 · N5681K · Destroyed
  > The non-instrument rated plt obtained a wx briefing & filed an IFR flt plan although poor wx conditions existed (200 ft ceiling & one-half mi visibility) at San Antonio. The tower instructions to N5681K were to fly rwy heading (120 deg) after departure,…
- [NTSB CHI85LA078](https://openairdocs.org/ntsb/CHI85LA078.md): Piper PA-24-260 · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Dec 26, 1984 · N8921P · Substantial damage
  > The acft collided with a fence & two parked cars during a forced landing while on a personal flt. The plt reported that after a 40 to 50 min ground delay he made a normal climb to 5000 ft MSL where he trimmed the acft & leaned the mixture to 75 percent power.…
- [NTSB LAX85LA085](https://openairdocs.org/ntsb/LAX85LA085.md): Cessna 170A · Cottonwood, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1984 · N9164A · Substantial damage
  > Witnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wires

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

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

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