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

## Cases, newest first

- [NTSB LAX85LA397](https://openairdocs.org/ntsb/LAX85LA397.md): Cessna 182P · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Sep 20, 1985 · N7208N · Substantial damage
  > The plt stated that the afct's throttle stuck in the full power position. He shut the engine down using the mixture control, but misjudged his altitude, stalled the aircraft & crashed short of the runway. The condition of the wreckage precluded determination…
- [NTSB FTW85LA353](https://openairdocs.org/ntsb/FTW85LA353.md): Piper PA-28R-200 · Plainview, TX · Accident · No injuries · Limited investigation · Final report · Sep 20, 1985 · N1994T · Substantial damage
  > The acft was substantially damaged during an emerg landing following an eng failure due to fuel exhaustion. Plt stated that during the 2nd leg of his flt, the ceiling and visibility deteriorated to the point that he was unable to find the arpt at his…
- [NTSB ATL85FLT12](https://openairdocs.org/ntsb/ATL85FLT12.md): Cessna 150L · Tunica, MS · Accident · Serious injuries · Final report · Sep 20, 1985 · N10735 · Substantial damage
  > The acft sustained substantial damage during a forced landing in a cotton fld following fuel exhaustion. Purpose of the flt was to take aerial photographs. Post accident inspection of the acft disclosed 2.5 gallons of fuel remaining in the right fuel tank and…
- [NTSB ATL85FKG10](https://openairdocs.org/ntsb/ATL85FKG10.md): Piper PA 60-700P · Hampton, GA · Accident · No injuries · Final report · Sep 20, 1985 · N6905A · Substantial damage
  > The plt feathered the #2 eng during flt when the oil pressure dropped to zero. #1 alternator failed to produce power and when the landing gear was lowered the battery was depleted to the point that the cockpit instrument lights went out. The acft was landed…
- [NTSB ATL85LA279](https://openairdocs.org/ntsb/ATL85LA279.md): Cessna 177RG · Neola, WV · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N800JH · Substantial damage
  > While leveling at cruise altitude the engine lost power and the pilot attempted a forced landing in a field. During landing roll the aircraft collided with small trees at the end of the field. Post-crash examination of the engine disclosed a 3 inch crack in…
- [NTSB ANC85LA179](https://openairdocs.org/ntsb/ANC85LA179.md): Cessna 207 · Chuathbaluk, AK · Accident · No injuries · Limited investigation · Final report · Sep 18, 1985 · N91157 · Substantial damage
  > The acft made an emergency landing in a river after an eng failure due to fuel exhaustion. The plt stated that he could not determine exact fuel quantity prior to takeoff due to a broken cap on right fuel tank. The operator told the plt to fly the acft…
- [NTSB NYC85FA240](https://openairdocs.org/ntsb/NYC85FA240.md): Piper PA-31-350 · West Mifflin, PA · Accident · Minor injuries · Field investigation · Final report · Sep 17, 1985 · N62994 · Substantial damage
  > During an air taxi flight the pilot transmitted that the airplane was out of fuel and landing on a golf course. Less than one gallon of fuel was drained from the wreckage. The airplane was making an unplanned return trip to pick up passengers after a…
- [NTSB LAX85LA407](https://openairdocs.org/ntsb/LAX85LA407.md): Bell 206B · Pacific Ocean (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 1985 · N2160L · Destroyed
  > The helicopter experienced a loss of pwr within 10 minutes after takeoff from a fishing vessel. The helicopter was ditched in the Ocean at coordinates 11.25'N and 103.37'W. Examination of fuel samples from the fishing vessel revealed both upper and lower fuel…
- [NTSB LAX85LA405](https://openairdocs.org/ntsb/LAX85LA405.md): Piper J3 C-65 · Grand Canyon, AZ · Accident · 2 fatal · Limited investigation · Final report · Sep 17, 1985 · N6566H · Destroyed
  > After departing pierce ferry, AZ the plt and his passenger flew east, up the Colorado river, at a low level towards kanab point. The plt's notes and charts show that the flt was to turn north for aprx 40 NM, with a refueling stop at kanab, UT. The bright…
- [NTSB SEA85LA215](https://openairdocs.org/ntsb/SEA85LA215.md): Varga 2150A · Vale, OR · Accident · No injuries · Limited investigation · Final report · Sep 16, 1985 · N8291J · Substantial damage
  > The acft nosed down after the nose gear collapsed during a forced landing on a dirt road following a loss of pwr. The plt reported that aprx 1 hr into the x-country flt he noted the fuel gages indicated 1/2 full on each tank. A state trooper reported he…
- [NTSB MKC85FA217](https://openairdocs.org/ntsb/MKC85FA217.md): Piper PA-28-181 · What Cheer, IA · Accident · Serious injuries · Field investigation · Final report · Sep 16, 1985 · N8262U · Substantial damage
  > The acft was observed flying through the top of a tree, then through a four strand high voltage pwr line. Final impact was relatively flat in a soy-bean field. The plt later stated that he had become disoriented in flt and hallucinated that he was in a Piper…
- [NTSB LAX85LA391](https://openairdocs.org/ntsb/LAX85LA391.md): Mooney M20K · Rosamond, CA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N5788U · Substantial damage
  > While enroute to van nuys arpt at about 9500 ft, the plt reported to edwards afb apch control that he was experiencing a rough running eng. The plt requested and received a radar vector to wm j. fox arpt, lancaster, CA. Shortly thereafter the eng sustained a…
- [NTSB CHI85LA377](https://openairdocs.org/ntsb/CHI85LA377.md): Wippler Cassut III M · Randall, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1985 · N39684 · Substantial damage
  > The engine lost power when the pilot attempted to add power at the completion of a descent. The pilot did not use carburetor heat in the descent. The relative humidity was approximately 60%.
- [NTSB SEA85FA212](https://openairdocs.org/ntsb/SEA85FA212.md): Luscombe 8A · Renton, WA · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1985 · N2073K · Destroyed
  > The inexperienced, low time student pilot reported a gradual loss of power while operating his luscobe 8A aircraft on a personal, local flight. The aircraft was equipped with a stromberg carburetor whose mixture was permanently wired full open and power was…
- [NTSB MIA85FA254](https://openairdocs.org/ntsb/MIA85FA254.md): Mooney M20F · Aripeka, FL · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1985 · N4797N · Destroyed
  > The student plt stated that after dinner, which included a small amount of wine, he went to the arpt to clean his acft, then elected to go for a short flt. He intended to stay within 25 mi of the arpt, but found himself over lakeland. He landed at a strip to…
- [NTSB FTW85LA349](https://openairdocs.org/ntsb/FTW85LA349.md): Ryan Navion · Midland, TX · Accident · No injuries · Limited investigation · Final report · Sep 14, 1985 · N91460 · Substantial damage
  > The plt experienced eng failure during climbout from sky ranch arpt at Midland, TX. He then turned into the wind and made a forced landing in a pasture. Subsequent investigation revealed a connecting rod had broken, however, the cause of the rod failure was…
- [NTSB FTW85FA346](https://openairdocs.org/ntsb/FTW85FA346.md): Pitts SPL. S-1 · Mclean, TX · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1985 · N74LF · Destroyed
  > The plt had landed the Pitts special on the highway due to low fuel. After the fuel service the acft took off and the plt performed low altitude acrobatics then departed making slow rolls below a low overcast. A witness observed the acft flying low over the…
- [NTSB ANC85LA176](https://openairdocs.org/ntsb/ANC85LA176.md): Piper PA-32-300 · Togiak, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1985 · N8981N · Substantial damage
  > Acft crashed on mountainside after wx worsened. Marginal wx had been forecast & PIREP advised plt that VFR flt was not recommended.
- [NTSB ATL85MA275](https://openairdocs.org/ntsb/ATL85MA275.md): Smith, Ted Aerostar Aerostar 600 · Eva, AL · Accident · 6 fatal · Major investigation · Final report · Sep 13, 1985 · N680CC · Destroyed
  > Drg an IFR arrival/dscnt, the plt stated he 'had to feather 1 eng, I have an oil leak & I'm just trying to dscnd...' He then said he was dscndg thru 5300'. As he contd the apch, he informed the controller he would be unable to go around since the hydr sys…
- [NTSB LAX85IA396](https://openairdocs.org/ntsb/LAX85IA396.md): North American SNJ-4 · Reno, NV · Incident · No injuries · Incident investigation · Final report · Sep 12, 1985 · N86WW · Minor damage
  > The pilot experienced a 'severe vibration' and made an emergency landing during a heat race at the national championship air races. Subsequent examination revealed that a propeller blade pitch change bolt, p/n 53546, had failed, allowing one propeller blade…
- [NTSB DEN85FA240](https://openairdocs.org/ntsb/DEN85FA240.md): Aero Commander 680FL · Fort Collins, CO · Accident · 1 fatal · Field investigation · Final report · Sep 12, 1985 · N45724 · Destroyed
  > The plt was operating his acft under the rules of 14 CFR 135, I.e., a scheduled domestic cargo flt. He made a normal departure and climb en route to salt lake city, Utah. Normal communications and radar flt following was established with denver ARTCC.…
- [NTSB FTW85LA347](https://openairdocs.org/ntsb/FTW85LA347.md): Bell 206L-1 · Angleton, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1985 · N2022G · Substantial damage
  > The plt had descended to very low alt (10-15 feet above ground level) during VFR weather conditions while still several miles from his destination arpt and impacted an electrical power line. He made a precautionary landing and rendered first aid to his…
- [NTSB ATL85LA273](https://openairdocs.org/ntsb/ATL85LA273.md): Cessna 404 · Hayesville, NC · Accident · 1 fatal · Limited investigation · Final report · Sep 11, 1985 · N128SP · Destroyed
  > Fisherman heard an aircraft overhead but did not see any sign of it in the night sky. Shortly thereafter they saw a flash and fire on the side of a mountain, then they heard the explosion. The sheriff was called and an investigation revealed a crashed…
- [NTSB FTW85LA344](https://openairdocs.org/ntsb/FTW85LA344.md): Mooney M20J · Kraemer, LA · Accident · 1 fatal · Limited investigation · Final report · Sep 10, 1985 · N4793H · Destroyed
  > Acft was descending from cruise alt when it entered a radar lvl 3 thunderstorm and control was lost during a night VFR flt. The acft impacted a swamp in a vertical attitude with the rt wing leading slightly. The lft wing was found about 10' south of the main…
- [NTSB SEA85FA211](https://openairdocs.org/ntsb/SEA85FA211.md): Bell 206B · Emmett, ID · Accident · 1 fatal · Field investigation · Final report · Sep 9, 1985 · N14819 · Destroyed
  > Newly-licensed plt departed into mountainous terrain in thunderstrom conditions despite warnings from friends. The acft wreckagewas located two days later in rising terrain below power 11 miles from pt of departure. Investigation revealed high speed vertical…
- [NTSB MIA85FA248](https://openairdocs.org/ntsb/MIA85FA248.md): Aero Commander 100 · Oak Hill, FL · Accident · Minor injuries · Field investigation · Final report · Sep 9, 1985 · N3684X · Destroyed
  > The plt was making his first flt in his recently purchased acft. The plt stated that both fuel tanks were full prior to take-off. Approximately 20 mins after take-off, an attempt was made to switch from the right fuel tank to the left fuel tank. Seconds…
- [NTSB NYC85LA259](https://openairdocs.org/ntsb/NYC85LA259.md): Volksplane VP-1 · Sharpsville, PA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1985 · N4354 · Substantial damage
  > The plt experienced a loss of eng RPM during cruise flt. He applied carb heat and lowered the nose of the acft in an attempt to regain eng RPM however, the eng continued to loose speed. The eng was below 2000 RPM and dropping when the plt elected to make a…
- [NTSB MKC85LA210](https://openairdocs.org/ntsb/MKC85LA210.md): Cessna 150K · Bee Branch, AR · Accident · No injuries · Limited investigation · Final report · Sep 8, 1985 · N5831G · Substantial damage
  > The airplane was on a local flight when the engine failed. During the forced landing, the airplane ran through a fence row of trees. Inspection revelaed that the rocker arm bosses on the number one cylinder had failed. Cylinder had been installed 50 hours…
- [NTSB MKC85LA209](https://openairdocs.org/ntsb/MKC85LA209.md): Cessna 150L · Morrilton, AR · Accident · No injuries · Limited investigation · Final report · Sep 7, 1985 · N6999G · Substantial damage
  > The airplane was on a night flight when the engine failed. During the forced landing, the airplane struck and remained attached to high voltage powerlines. Inspection of the engine revealed number three cylinder cracked and the top compression ring on number…
- [NTSB MKC85LA208](https://openairdocs.org/ntsb/MKC85LA208.md): Piper PA-28-181 · Oxford, IA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1985 · N9557K · Substantial damage
  > The eng quit abruptly while the acft was cruising at 3,500 feet. The acft collided with standing corn during the night forced landing. After the acdt the fuel selector was found on the lt fuel tank, the lt tank was empty and the rt fuel tank was full. The plt…
- [NTSB CHI85FA370](https://openairdocs.org/ntsb/CHI85FA370.md): Globe GC-1B · Romeoville, IL · Accident · 1 fatal · Field investigation · Final report · Sep 7, 1985 · N11HN · Destroyed
  > The pilot was reportly departing on a xcountry flt. During climbout, in the traffic pattern, upon reaching base leg area the acft was observed to turn back towards the arpt descend and strike the ground. Witnesses reported no sound of engine was heard. The…
- [NTSB CHI85FA368](https://openairdocs.org/ntsb/CHI85FA368.md): Piper PA28R-200 · Ravenna, OH · Accident · 2 fatal · Field investigation · Final report · Sep 6, 1985 · N55024 · Destroyed
  > The non-instrument rated pilot continued VMC into IMC. The pilot contracted youngstown ATCT for assistance. Within a few minutes radar contact was lost. Prior to ground impact portions of the aircraft separated. There was no record of a wx briefing being…
- [NTSB ATL85FMG08](https://openairdocs.org/ntsb/ATL85FMG08.md): Piper PA-28R-200 · Shuffletown, NC · Accident · Serious injuries · Final report · Sep 6, 1985 · N6102J · Destroyed
  > The acft contacted a fence during a forced landing following a loss of pwr. The flt orginated at grand ledge, MI, at 1100 EST and an unscheduled landing was made at adrian, MI, because of wx. The flt departed adrian, MI, at 1320 EDT. The plt reported that…
- [NTSB MIA85LA244](https://openairdocs.org/ntsb/MIA85LA244.md): Piper PA-28-161 · Everglades City, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N8015X · Substantial damage
  > The plt stated that while returning to venice from marathon,the acft started to lose power. He switched tanks but the problem continued. He notified fort myers apch he was having problems and when the power deteriorated to 1600 RPM, he elected to ditch the…
- [NTSB MIA85LA243](https://openairdocs.org/ntsb/MIA85LA243.md): Bell 47G-2 · Moore Haven, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N8429E · Substantial damage
  > The plt stated that while flying around his property, he slowed the helicopter up to descend and land, at aprx 40 ft altitude the eng lost power due to carburator ice buildup. He autorotated to a landing & on touchdown his right skid contacted a large boulder…
- [NTSB LAX85LA380](https://openairdocs.org/ntsb/LAX85LA380.md): Piper PA-28-161 · Julian, CA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N421GS · Substantial damage
  > The acft collided with rising terrain on a local flt. The pax indicated that the plt was flying below the clouds and came too close to the mtn to avoid the collision.
- [NTSB MKC85LA207](https://openairdocs.org/ntsb/MKC85LA207.md): Fairchild Hiller FH-1100 · Ashland, KS · Accident · No injuries · Limited investigation · Final report · Sep 3, 1985 · N424FH · Substantial damage
  > The helicopter lost power and made a hard forced landing in a backyard. There were no leaks in the fuel system but the fuel tank was found to be empty. The owner states that even though the fuel tank was found to be empty after the accident, the fuel quantity…
- [NTSB FTW85IA341](https://openairdocs.org/ntsb/FTW85IA341.md): Mcdonnell Douglas DC-10-10 · Abilene, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 3, 1985 · N112AA · Minor damage
  > Aa DC-10 enroute el paso, TX. To dfw arprt TX. Had fire warning #3 eng. Crew performed emerg. Proc. But lite remained on. Crew made emergency landing dyess afb Abilene, TX. Pax emer evac left side of a/c. aft slide L4 deflated during evac 1 pax received minor…
- [NTSB DEN85LA235](https://openairdocs.org/ntsb/DEN85LA235.md): Cessna 182N · Moab, UT · Accident · No injuries · Limited investigation · Final report · Sep 3, 1985 · N9229 · Substantial damage
  > The plt stated after the accident that he experienced a loss of power while cruising at 8500 MSL. He was unable to restore power and executed an emergency landing in an open area covered by sage brush. During the landing roll, the acftnosed over. Examination…
- [NTSB DEN85FA233](https://openairdocs.org/ntsb/DEN85FA233.md): Piper PA-34-200T · Ogden, UT · Accident · 4 fatal · Field investigation · Final report · Sep 2, 1985 · N75015 · Destroyed
  > The plt and his party were en route from minden, NV to casper, WY and had stopped at Ogden, UT to refuel. The plt obtained an updated wx briefing fr fss and field an IFR flt plan. After takeoff the plt was told to climb in the holding pattern to 13000 ft.…
- [NTSB CHI85LA365](https://openairdocs.org/ntsb/CHI85LA365.md): Cessna 177 · Glandorf, OH · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N30654 · Substantial damage
  > The plt reported that during cruise flt the prop pitch began to vary, oil pressure dropped to zero and the eng began to overheat. A forced landing ensued during which the acft contacted a ditch. Post accident examination of the eng disclosed the #3 cylinder…
- [NTSB ANC85LA168](https://openairdocs.org/ntsb/ANC85LA168.md): Piper PA-18-150 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N74924 · Substantial damage
  > While en route & about 15 mi from his destination, the plt noted that both the eng RPM & the oil pressure were decreasing. Subsequently, he made an emerg landing in an area of small trees & brush next to a swamp. An exam of the eng was made, but no mechanical…
- [NTSB NYC85FA227](https://openairdocs.org/ntsb/NYC85FA227.md): Cessna 150M · Danby, VT · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1985 · N66190 · Destroyed
  > The pilot of N66190 received a weather briefing from lebanon flight service station and was advised of low ceilings and also advised that visual flight rules flight was not recommended. At about the time N66190 was departing rutland, Vermont, a helicopter…
- [NTSB MKC85LA203](https://openairdocs.org/ntsb/MKC85LA203.md): Cessna 172G · Deepwater, MO · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N3943L · Substantial damage
  > The acft was crusing at 2,000 ft, 50 min after takeoff when the eng began running rough, lost RPM, and then quit. The plt made a forced landing in a small fld and the collided with trees during the landing roll. The investigation, which included running the…
- [NTSB LAX85LA378](https://openairdocs.org/ntsb/LAX85LA378.md): Stinson 108-2 · Carpinteria, CA · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N9782K · Substantial damage
  > During a x-c pleasure flt all eng pwr was suddenly lost when the plt heard a 'loud bang.' The plt made an emergency ldg on a polo field. During ldg flare the plt stalled the acft. The resulting hard touchdown substantially damaged the acft. Exam of the acft's…
- [NTSB DEN85LA234](https://openairdocs.org/ntsb/DEN85LA234.md): Balloon Works Firefly 7 · Littleton, CO · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1985 · N2259H · No damage
  > The plt attempted to land his Balloon in high winds resulting a hard ldg which threw him out of the basket the Balloon then began an immediate asent until a pax pulled the vent line and the Balloon settled rapidly until it hit the grd. Injuries to passengers…
- [NTSB ATL85FA266](https://openairdocs.org/ntsb/ATL85FA266.md): Piper PA-28-235-B · Rion, SC · Accident · 4 fatal · Field investigation · Final report · Sep 1, 1985 · N9340W · Destroyed
  > The acft had been cruising at 10,500 ft for several min and then informed ATC that they were climbing to 12,500 ft due to VFR. Shortly there after the acft disappeared from the radar scope. Witnesses heard the engine making an unusual sound and looked up and…
- [NTSB LAX85LA377](https://openairdocs.org/ntsb/LAX85LA377.md): Cessna A150K · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N8409M · Destroyed
  > The plt said the operation was about 4 and 1/2 hours into a commercial fish spotting flt when the engine 'began to run rough, then quit altogether.' Attempts to restart the engine were unsuccessful and the plt completed a power-off ditching at sea. He and the…
- [NTSB DEN85FA229](https://openairdocs.org/ntsb/DEN85FA229.md): Piper PA-18-150 · Peyton, CO · Accident · 2 fatal · Field investigation · Final report · Aug 31, 1985 · N14331 · Destroyed
  > The two experienced pilots took off from high alt airstrip under high density alt conditions. Witnesses said acft entered a 60-degree left banking turn. When acft had completed 120-degrees of turn, the nose dropped. Witnesses said the acft side-slipped to the…
- [NTSB CHI85LA364](https://openairdocs.org/ntsb/CHI85LA364.md): Thornhill Replica TS-1 · Marengo, IL · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N4463 · Substantial damage
  > This aircraft is powered by a rotary engine. Thrust is varied by shorting out one magneto and varying the firing order of the cylinders via an electrical cam arrangement. The mixture control is limited to only a few settings. One of which is level flight.…

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

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

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