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

## Cases, newest first

- [NTSB MKC84LA098](https://openairdocs.org/ntsb/MKC84LA098.md): Piper PA-31P · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Mar 9, 1984 · N3TB · Substantial damage
  > At FL240, a fire broke out in the rgt eng compartment. The plt indicated that the eng turbo-charger was malfunctioning. The plt shut down the eng & asked for radar vectors to johnson county executive arpt. The fire went out at 21,000 ft & the acft landed…
- [NTSB MKC84FA097](https://openairdocs.org/ntsb/MKC84FA097.md): Teratorn Acft Tierra II · Lexington, NE · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1984 · UNK · Substantial damage
  > The plt had flown from callaway to Lexington, NE, earlier in the day. After a short visit, he departed on a return flt. A search was initiated when the acft did not return. About 5 hrs after the estimated time of the accident, the acft was found where it had…
- [NTSB MIA84FA099](https://openairdocs.org/ntsb/MIA84FA099.md): Cessna 182J · Everglades City, FL · Accident · Serious injuries · Field investigation · Final report · Mar 9, 1984 · N2830F · Destroyed
  > The plt stated that when the flt originated in Everglades City the left fuel tank was empty & the right fuel tank indicated 1/2 full. The flt to naples took 15 minutes. He initiated the return flt at 1047 & the eng quit at 1100. A forced landing was made in a…
- [NTSB DEN84FA307](https://openairdocs.org/ntsb/DEN84FA307.md): Rockwell 112TCA · Missoula, MT · Accident · 4 fatal · Field investigation · Final report · Mar 9, 1984 · N4699W · Destroyed
  > The pilot had filed an IFR clearance. While taxiing to takeoff, he requested and received a clearance to climb VFR on course, via victor airway 2, with instructions to report when reaching 10,000' MSL. This was the last communication received from the pilot.…
- [NTSB NYC84FA104](https://openairdocs.org/ntsb/NYC84FA104.md): Cessna 172Q · Meadville, PA · Accident · 1 fatal · Field investigation · Final report · Mar 8, 1984 · N96286 · Destroyed
  > Plts were briefed on snowstorm advancing toward destination, departed in hope of arriving ahead of wx. Encounting IMC conditions (snow) enroute, plt filed IFR and continued. Communications transcript indicates that when eng began to lose power, plt used carb…
- [NTSB MIA84LA098](https://openairdocs.org/ntsb/MIA84LA098.md): Cessna 206 · Guayama, PR · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N2610X · Destroyed
  > The plt had purchased the acft about 2 wks prior to the accident. After climbing on top for a x-country flt, he lost radio communication. He elected to continue on the flt & make position reports in the blind. The plt reported that he encountered headwinds.…
- [NTSB MIA84FU002](https://openairdocs.org/ntsb/MIA84FU002.md): Sigers Ritz Model A · Macclenny, FL · Accident · 1 fatal · Final report · Mar 8, 1984 · UNREG · No damage
  > The ultralight nosed down and dove into the ground from cruise flt. Engine sound increased during the dive. From 200 ft AGL to the ground impact. No malfunctions in equipment were found during the investigation. The plt had a history of dizziness from a head…
- [NTSB DEN84FA108](https://openairdocs.org/ntsb/DEN84FA108.md): Piper PA-24-400 · Saratoga, WY · Accident · 1 fatal · Field investigation · Final report · Mar 8, 1984 · N400SB · Substantial damage
  > During a night x-country after a 16 hour day the airline captain flying his own acft home collided with a mountain at the 10000 ft level. The weather was VMC but the winds aloft were strong and would have blown the acft towardthe mountain had no wind…
- [NTSB ATL84FA119](https://openairdocs.org/ntsb/ATL84FA119.md): Piper PA-31T · Benson, NC · Accident · No injuries · Field investigation · Final report · Mar 7, 1984 · N9162Y · 2 aircraft · Substantial damage
  > A Piper PA-31T, N9162Y, and a Beech 200C, N390AC, were involved in a midair collision while both were cruising at 17,500 ft in unlimited visibility. The Piper was tracking inbound on the 210 deg radial of the richmond VOR. The Beech was tracking inbound on…
- [NTSB NYC84LA103](https://openairdocs.org/ntsb/NYC84LA103.md): Britten-Norman BN-2A-8 · Tobyhanna, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 1984 · N19WA · Substantial damage
  > The acft made a precautionary landing on a highway after both engines lost oil pressure. The plt feathered the right propeller because it gave abnormal indications before the left engine. The left engine was still operating at touchdown post accident…
- [NTSB ANC84LA040](https://openairdocs.org/ntsb/ANC84LA040.md): Cessna 170B · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Mar 6, 1984 · N2715D · Substantial damage
  > The acft cowling came unfastened during cruise and the plt elected to make a precautionary landing. During the landing, the plt lost directional control and collided with a snowbank.
- [NTSB NYC84LA097](https://openairdocs.org/ntsb/NYC84LA097.md): Piper PA-28-180 · Elmira, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1984 · N9617J · Substantial damage
  > The acft was descending to land when the engine quit. The pilot attempted to restart the engine with negative results and made a forced landing into a plowed field. The weather conditions were conducive to carburetor ice.
- [NTSB MKC84FA091](https://openairdocs.org/ntsb/MKC84FA091.md): Piper PA-34-200T · Harrison, AR · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1984 · N5857F · Destroyed
  > The plt encountered a thunderstorm during a night x-country. The plt was being vectored by the controller to avoid the worst of the storm. After about 2 minutes memphis center heard the acfts call sign shouted over the radio. Further attempts at radio…
- [NTSB FTW84FA153](https://openairdocs.org/ntsb/FTW84FA153.md): Boeing 727-200 · Lampasas, TX · Accident · Serious injuries · Field investigation · Final report · Mar 4, 1984 · N471BN · Minor damage
  > The captain received a company briefing prior to the flt. A convective SIGMET was in effect & turbulence was forcast for the area. During flt, the acft was manuevered to avoid turbulence. The acft was clear of clouds & in a thin haze layer when the crew felt…
- [NTSB ANC84LA039](https://openairdocs.org/ntsb/ANC84LA039.md): Fairchild Hiller FH-100 · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N5051F · Substantial damage
  > The plt experienced a downdraft, while approaching a glacier at 5500 ft MSL. In turning downgrade to try to affect a descent of the acft, control was lost and the helicopter collided with the ground. The acft rolled inverted after ground contact.
- [NTSB SEA84FA065](https://openairdocs.org/ntsb/SEA84FA065.md): Piper PA-28-181 · Lewiston, ID · Accident · 5 fatal · Field investigation · Final report · Mar 3, 1984 · N2868D · Destroyed
  > The acft crashed in mountainous terrain while the non-instrument rated plt was on a flt in marginal wx conditions. An investigation revealed that the acft had impacted in a steep nose down, high speed descent. No preimpact/mechanical problem was found. About…
- [NTSB NYC84LA329](https://openairdocs.org/ntsb/NYC84LA329.md): Cessna U206A · North Hudson, NY · Accident · 2 fatal · Limited investigation · Final report · Mar 3, 1984 · CFUQW · Destroyed
  > An inflight collision with trees in an area of high terrain. Factors related to the accident were: the pilot's decision to takeoff after he received a briefing advising, 'VFR flight not recommended', the dark night conditions, and snow showers.
- [NTSB MKC84FA092](https://openairdocs.org/ntsb/MKC84FA092.md): Piper PA-28-236 · Oconto, NE · Accident · 2 fatal · Field investigation · Final report · Mar 3, 1984 · N8054E · Destroyed
  > After attending a business conference at muncie, IN, the plt received a wx briefing & took off at 2026 CST on a flt to des moines, IA, where he refueled. In a phone call to his wife at their home in north platte, NE, he indicated the wx was such that he would…
- [NTSB ATL84LLT05](https://openairdocs.org/ntsb/ATL84LLT05.md): Cessna C-172F · Pascagoula, MS · Accident · Minor injuries · Final report · Mar 3, 1984 · N8662U · Substantial damage
  > The plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.
- [NTSB ATL84LA112](https://openairdocs.org/ntsb/ATL84LA112.md): Cessna P210N · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N6320W · Substantial damage
  > The acft crashed during a forced landing after a power loss. The plt stated during a post accident interview that he didnot switch tanks during the power loss sequence. Investigation revealed that the right fuel tank was empty. About 1/2 oz of fuel was…
- [NTSB ATL84FA111](https://openairdocs.org/ntsb/ATL84FA111.md): Piper PA-32RT-301T · Goodway, AL · Accident · 2 fatal · Field investigation · Final report · Mar 3, 1984 · N8427A · Destroyed
  > Plt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…
- [NTSB SEA84FA064](https://openairdocs.org/ntsb/SEA84FA064.md): Cessna U206 · Stevenson, WA · Accident · 2 fatal · Field investigation · Final report · Mar 1, 1984 · N735KE · Destroyed
  > The plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…
- [NTSB ATL84FLT06](https://openairdocs.org/ntsb/ATL84FLT06.md): Cessna 182 · Maryville, TN · Accident · Serious injuries · Final report · Mar 1, 1984 · N6114B · Substantial damage
  > The acft crashed during a forced landing after running out of fuel. The plt said he did not visually check the fuel prior to takeoff. After the accident the acft contained 2 gallons in each tank and had about an ounce of fuel in the carburetor which normally…
- [NTSB SEA84FA063](https://openairdocs.org/ntsb/SEA84FA063.md): Enstrom 280C · Middleton, ID · Accident · 2 fatal · Field investigation · Final report · Feb 29, 1984 · N51715 · Destroyed
  > The acft collided with the terrain during a test flt. Witnesses observed the acft rotate about 180 degrees about its vertical axis go nose low and descend vertically to the ground. A noise change described as a 'sputter' or tone change' was heard during this…
- [NTSB DEN84LA103](https://openairdocs.org/ntsb/DEN84LA103.md): Piper PA-23-160 · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 1984 · N3253P · Substantial damage
  > The plt took off with full fuel tanks & used fuel from the main tanks until they were aprx 1/2 full. He then switched to the tip tanks & used fuel from them until they emptied. Judging from a previous flt, he knew the l tip tank would empty aprx 8 min before…
- [NTSB MIA84FA095](https://openairdocs.org/ntsb/MIA84FA095.md): Monnett Moni · Indiantown, FL · Accident · Serious injuries · Field investigation · Final report · Feb 26, 1984 · N87RB · Destroyed
  > The acft crashed in pieces after the airframe failed while the plt was performing aerobatics. The plt used his parachutewhile still belted to the tail section of the acft which was lowered by the chute. The wreckage consisted or six main pieces of separated…
- [NTSB FTW84LA150](https://openairdocs.org/ntsb/FTW84LA150.md): Bell UH-1B · Amarillo, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 26, 1984 · N31213 · Substantial damage
  > Plt was advised by fss that Amarillo had snow flurries, visibility 4 miles and wind from 350 degs at 28 KTS gusting to 34 KTS, tucumcari, NM was reporting 2 miles visibility with light snow and areas further west were clearing. The plt departed Amarillo under…
- [NTSB MKC84LA083](https://openairdocs.org/ntsb/MKC84LA083.md): Cessna C-150K · Hot Springs, AR · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N6063G · Substantial damage
  > The acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…
- [NTSB ATL84FA107](https://openairdocs.org/ntsb/ATL84FA107.md): Piper PA-23 · Bluefield, WV · Accident · 2 fatal · Field investigation · Final report · Feb 25, 1984 · N2160P · Destroyed
  > While cruising on an IFR flt at 10,000 ft, the plt informed atlanta center that he had an eng problem & was declaring an emergency. He was provided a heading to the Bluefield arpt which was nearby. When asked about the problem, he said the left eng was…
- [NTSB LAX84LA197](https://openairdocs.org/ntsb/LAX84LA197.md): Grumman American AA-1A · Chandler, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 1984 · N9452L · Destroyed
  > The plt had just completed a power-off spiral to about 200 ft AGL. Power was applied & the acft climbed to about 500 ft AGL when the eng quit. Subsequently, the acft was damaged during a forced landing. All fuel lines & the fuel boost pump were found dry.…
- [NTSB DEN84LA100](https://openairdocs.org/ntsb/DEN84LA100.md): Cessna 152 · Carlsbad, NM · Accident · No injuries · Limited investigation · Final report · Feb 24, 1984 · N46723 · Substantial damage
  > The student plt made a forced landing and the acft nosed over on soft terrain after the engine quit during the last leg of a x-country. The plt said he had not visually checked the fuel tanks during pre-flight. An examination of the acft after the accident…
- [NTSB DEN84LA098](https://openairdocs.org/ntsb/DEN84LA098.md): Cessna 185C · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Feb 23, 1984 · N2691Z · Substantial damage
  > The acft nosed over during a forced landing in snow after the engine quit. The plt said that he ran out of fuel. The pltsaid he departed on the 90 mile x-country with about 15 gallons of fuel aboard the acft. The acft was landed just short of the destination…
- [NTSB ATL84FA106](https://openairdocs.org/ntsb/ATL84FA106.md): Beech A36 · Hamilton, AL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1984 · N1034W · Destroyed
  > The acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…
- [NTSB LAX84FA193](https://openairdocs.org/ntsb/LAX84FA193.md): Robinson R22 · Thousand Oaks, CA · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1984 · N8404S · Destroyed
  > The helicopter collided with 2 cables supported by 150 ft tall twin towers. It then went out of control & crashed into a 15 ft deep drainage ditch & burned. The plt had been cited on 2/20/84 for 'careless & reckless operation of an acft.' Another person who…
- [NTSB CHI84LA116](https://openairdocs.org/ntsb/CHI84LA116.md): Navion A · Newport, MN · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1984 · N4893K · Substantial damage
  > The acft engine failed when the plt applied carburator heat to try to 'cure' a rough running engine. Post accident investigation revealed a hole in the left muffler and shroud allowing burnt exhaust gases to enter the carburetor when carburetor heat was…
- [NTSB FTW84LA143](https://openairdocs.org/ntsb/FTW84LA143.md): Air Tractor AT-400A · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1984 · N3159C · Substantial damage
  > The aircraft suffered a loss of power while returning from an ag flight and made an emergency landing in a ditch next toa rice field. The engine was test run with no discrepancies noted. It was determined that the loss of power was due to fuel exhaustion.
- [NTSB NYC84FFA02](https://openairdocs.org/ntsb/NYC84FFA02.md): Piper PA-28-180 · Lexington, NY · Accident · Serious injuries · Final report · Feb 20, 1984 · N9335J · Substantial damage
  > Weather briefing forecast low ceilings, mountains obscured and lgt to mod turbulence. VFR not recommended. Plt filed no flt plan. Plt reported that an encounter with turbulence caused a loss of control and collision with terrain during the recovery. Witness…
- [NTSB MIA84LA088](https://openairdocs.org/ntsb/MIA84LA088.md): Mooney M-20F · Defuniak Spring, FL · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N3455X · Substantial damage
  > While flying at 3000 ft, the eng sputtered & quit running. The plt stated that he tried all emergency procedures, which included changing the fuel selector position. He extended the gear to land on an interstate highway, but saw an overpass ahead, so he…
- [NTSB LAX84LA187](https://openairdocs.org/ntsb/LAX84LA187.md): Cessna 177B · Lucerne, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1984 · N34849 · Destroyed
  > Upon reaching his destination, the plt was unable to see the arpt because of the presence of a solid lower layer of clouds. While looking for a break in the cloud layer for a VFR descent, the plt 'inadvertently flew into IFR conditions,' & impacted trees.…
- [NTSB LAX84FA189](https://openairdocs.org/ntsb/LAX84FA189.md): Cessna 182P · Livermore, CA · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1984 · N91227 · Destroyed
  > While on a night x-country flt, the acft collided with the ground near the top of hilly terrain at an elevation of about 1840 ft. the time of the accident was not known, but the acft had departed groveland, CA at sometime between 1900 & 1930 PST. Witnesses in…
- [NTSB FTW84LA141](https://openairdocs.org/ntsb/FTW84LA141.md): Piper PA-28-140 · Bastrop, TX · Accident · No injuries · Limited investigation · Final report · Feb 20, 1984 · N15043 · Substantial damage
  > The engine lost power and the plt noticed smoke coming from the defrost vent. An emergency landing was made on a local highway. Examination revealed that the exhaust pipe was disconnected from the muffler and the hot gases melted a rocker box oil drain line.…
- [NTSB ATL84FLT04](https://openairdocs.org/ntsb/ATL84FLT04.md): Aero Commander 680F · Charleston, TN · Accident · Serious injuries · Final report · Feb 20, 1984 · N6000F · Substantial damage
  > The acft crashed during a ferry flight and the plt could not recall the circumstances of the flight. Investigation revealed that the acft had been parked on the service ramp for nearly two years without being used. The last annual inspection was recorded on…
- [NTSB LAX84LA184](https://openairdocs.org/ntsb/LAX84LA184.md): Beech M35 · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1984 · N280AA · Substantial damage
  > The plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…
- [NTSB FTW84FU003](https://openairdocs.org/ntsb/FTW84FU003.md): Ultraclassics Bearcat 150 · Abita Springs, LA · Accident · 1 fatal · Final report · Feb 19, 1984 · UNREG · Substantial damage
  > The airman tookoff for a personal flt, and after circling, made a desending high speed pass over the arpt. He then pulled the vehicle into a climb and began a roll. About 2/3 through the roll, the vehicle's nose dropped and it dove into the ground. The nose…
- [NTSB CHI84LA113](https://openairdocs.org/ntsb/CHI84LA113.md): Cessna 150 · Menominee, MI · Accident · No injuries · Limited investigation · Final report · Feb 18, 1984 · N5828E · Substantial damage
  > The acft landed in a swamp and nosed over after the engine lost power. Weather conditions were conducive to carburetor icing. The plt reported that he experienced carburetor icing and a power loss two miles short of the arpt of intended landing.
- [NTSB CHI84FA112](https://openairdocs.org/ntsb/CHI84FA112.md): Beech A23A · Oaktown, IN · Accident · 2 fatal · Field investigation · Final report · Feb 18, 1984 · N3639Q · Destroyed
  > Acft stalled & crashed after a pwr loss during night x-country flt. Plt radioed a 'mayday' call after reporting 3 mins earlier he had 30-45 mins of fuel remaining. Indianapolis ARTCC was giving flt assistance to N3639Q & advised the flt ofan arpt at 'your two…
- [NTSB SEA84LA054](https://openairdocs.org/ntsb/SEA84LA054.md): Aerospatiale AS-341G · Alma, OR · Accident · No injuries · Limited investigation · Final report · Feb 17, 1984 · N633B · Substantial damage
  > The plt stated he lost partial power on a x-country flt, during cruise, and initiated an autorotation. At about 200 to 300 ft AGL he reduced the throttle to idle. During flare the rotor RPM decayed and the acft landed hard and rolled over. The pilot stated…
- [NTSB LAX84LA171](https://openairdocs.org/ntsb/LAX84LA171.md): Cessna 150F · Folsom Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N8242S · Substantial damage
  > About 10 min after departure a total power loss was experienced due to fuel exhaustion. Due to rough unsuitable terrain the plt elected to ditch in a nearby lake. Upon recovery of the acft about 1 gal of fuel and 5 gals of water were found in each fuel tank.…
- [NTSB LAX84IA195](https://openairdocs.org/ntsb/LAX84IA195.md): Mcdonnell Douglas DC-9-82 · Santa Ana, CA · Incident · No injuries · Incident investigation · Final report · Feb 17, 1984 · N203AA · No damage
  > Shortly after takeoff a ttl pwr loss was experienced on the number 1 engine. Examination of the engine revealed substantial damage occurred in the compressor section from stage 6 rearward. 40 stage 8 compressor blades were forced completely out of their disk…
- [NTSB NYC84LA087](https://openairdocs.org/ntsb/NYC84LA087.md): Mooney M20J · Bristol, PA · Accident · No injuries · Limited investigation · Final report · Feb 16, 1984 · N201LU · Substantial damage
  > The acft encountered weather and head winds on a x-country flt. Nearing his destination after a long flt the plt was trying to let down VFR through breaks on the clouds when he realized the critical nature of his fuel level. A search foran arpt produced the…

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

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

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