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

## Cases, newest first

- [NTSB MKC85FPG02](https://openairdocs.org/ntsb/MKC85FPG02.md): Cessna 210L · Newport, AR · Accident · Minor injuries · Final report · Dec 24, 1984 · N94257 · Destroyed
  > The acft collided with trees during an emergency landing following a loss of pwr en route. The eng and prop separated during the accident and were submerged in water which prevented an examination to determine cause of the pwr loss.
- [NTSB LAX85LA082](https://openairdocs.org/ntsb/LAX85LA082.md): Rawdon Bros. T1 · Phoenix, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1984 · N51FM · Substantial damage
  > The plt planned to fly from santa ana, CA. To scottsdale, AZ. The plt reported that the acft had enough fuel for 4 hrs of flying time. The acft's fuel gages are located on the wings & a flashlight is required to see them at night. The plt stated that he was…
- [NTSB FTW85LA083](https://openairdocs.org/ntsb/FTW85LA083.md): Piper PA-28-140 · Grapeland, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1984 · N5743F · Destroyed
  > The pilot stated after the accident that he was in level flight at 1400 feet MSL when he applied carburator heat as a precautionary measure due to favorable carb icing conditions. The engine began running rough and quit within 2 to 3 seconds. Attempts to…
- [NTSB CHI85LA076](https://openairdocs.org/ntsb/CHI85LA076.md): Piper PA-38-112 · Byron Township, WI · Accident · Serious injuries · Limited investigation · Final report · Dec 24, 1984 · N26055 · Destroyed
  > The low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…
- [NTSB LAX85LA083](https://openairdocs.org/ntsb/LAX85LA083.md): Beech 77 · San Martin, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 23, 1984 · N67216 · Substantial damage
  > On a night pleasure flt the afct's alternator went off line. The plt elected to make an immediate landing at the arpt he was overflying rather than flying to a fld which had operating rwy lights. The fld he was over had a plt-controlled lighting system, but…
- [NTSB ATL85LA064](https://openairdocs.org/ntsb/ATL85LA064.md): Cessna 150 · Moundsville, WV · Accident · No injuries · Limited investigation · Final report · Dec 23, 1984 · N60209 · Substantial damage
  > The solo student pilot departed with both fuel tanks indicating slightly over 1/4 full. 2.3 hrs later the power loss occurred in a descent to the dest arpt. The operator drained about 15 ounces of fuel from the acft and observed no fuel spillage at the site.…
- [NTSB NYC85FA048](https://openairdocs.org/ntsb/NYC85FA048.md): Robinson R-22-A · Ellington, CT · Accident · 2 fatal · Field investigation · Final report · Dec 22, 1984 · N84958 · Destroyed
  > The non-inst rated plt continued flt into IMC conditions in a helicopter which was not equipped for flt on instruments. There is no record or witnesses of the plt having received a formal wx briefing but it is reported that the plt was informed of fog moving…
- [NTSB ATL85LA063](https://openairdocs.org/ntsb/ATL85LA063.md): Cessna 150G · Rockingham, NC · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N3010S · Substantial damage
  > While on x-country flt, plt was unable to obtain fuel at en route aprt. Plt filed new flt plan to alternate fuel stop. On arrival, plt decided he had sufficient fuel to fly on to arpt nearer destination and overflew planned stop. Shortly thereafter, due to…
- [NTSB MKC85FPG01](https://openairdocs.org/ntsb/MKC85FPG01.md): Piper PA-28-151 · Pine Bluff, AR · Accident · Serious injuries · Final report · Dec 21, 1984 · N203AT · Substantial damage
  > While on a x-country personal flight, the plt became disoriented near Pine Bluff, AR. He flew for several minutes before contacting air traffic control for assistance. While being vectured to the Pine Bluff airport by ATC, the acft ran out of fuel and…
- [NTSB ATL85LA062](https://openairdocs.org/ntsb/ATL85LA062.md): Piper PA28-151 · Tuxedo, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1984 · N32029 · Substantial damage
  > The recently certified private plt was under a VFR flt plan and continued the flt into known adverse wx conditions. While attempting to maneuver the acft out of the low ceiling, it was flown into the high terrain.
- [NTSB MKC85FA036](https://openairdocs.org/ntsb/MKC85FA036.md): Cessna 310L · Kaiser, MO · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N3325X · Destroyed
  > The acft was observed departing the airport to the south climbing. IFR flt conditions prevailed in the area. The plt rptd VFR at 2000 ft. the acft was noted by passengers of an earlier flight to have malfunctioning autopilot altitude andguidance…
- [NTSB ATL85FA060](https://openairdocs.org/ntsb/ATL85FA060.md): Cessna 172 · Hamilton, AL · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N4093F · Destroyed
  > Initiated night flt into area of forecast and observed marginal VFR conditions. Expected to encounter 1200 ft ceiling. Plt stated to fss briefer he would go as FAR as he could. Encountered area of patchy grnd fog, reduced visibility, no horizon ahead. Elected…
- [NTSB SEA85LA032](https://openairdocs.org/ntsb/SEA85LA032.md): Cessna 402B TS · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Dec 19, 1984 · N51SA · Substantial damage
  > While cruising at 1600 ft MSL on top of clouds, a loss of power in the left eng occurred. The plt attempted to restart the eng, but was unable. He feather the eng while diverting to tonopath, NV. The acft would not maintain alt using 1 eng. The last reported…
- [NTSB SEA85LA031](https://openairdocs.org/ntsb/SEA85LA031.md): Hiller UH-12ET · Hoquiam, WA · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1984 · N100LM · Substantial damage
  > Plt reported that while in normal cruise flight, a total loss of power occurred. Autorotation was effected in mountainous, wooded terrain. Examination of the engine showed continuity and freedom of rotation. Examination of the fuel system disclosed no…
- [NTSB FTW85FA078](https://openairdocs.org/ntsb/FTW85FA078.md): Beech V35A · Midlothian, TX · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1984 · N7460N · Destroyed
  > N7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…
- [NTSB DEN85LA046](https://openairdocs.org/ntsb/DEN85LA046.md): Cessna 401A · Raton, NM · Accident · No injuries · Limited investigation · Final report · Dec 17, 1984 · N365AA · Destroyed
  > About 2 hrs after departure, at 13,000 ft, the right eng fuel flow went to zero. The eng continued to operate INDICATING24 inches of manifold pressure. All other instruments were normal but what looked like a brown stain developed on top of the right wing…
- [NTSB ATL85FA058](https://openairdocs.org/ntsb/ATL85FA058.md): Cessna 337 · Butler, KY · Accident · Serious injuries · Field investigation · Final report · Dec 17, 1984 · N53648 · Destroyed
  > Pilot reported rear eng failure followed by front engine. Examination of wreckage disclosed that fuel was in right fuel system, no fuel was located in left inboard system. Water was found in both engine fuel flow dividers. It was not determined if the pilot…
- [NTSB LAX85FA073](https://openairdocs.org/ntsb/LAX85FA073.md): Mooney M20J · Grand Canyon, AZ · Accident · 4 fatal · Field investigation · Final report · Dec 16, 1984 · N4812H · Destroyed
  > The plt received a wx briefing and was advised of moderate rime and mixed icing in clouds. He filed an IFR flt plan and departed. While at 12000 ft, he reported encountering severe rime ice and requested a lower altitude. He stated thathe was trying to fling…
- [NTSB DCA85AA006](https://openairdocs.org/ntsb/DCA85AA006.md): Convair 440 · Jasper, AL · Accident · Serious injuries · Final report · Dec 16, 1984 · N44828 · Destroyed
  > Shortly after climbing & leveling at 6000 ft, the r eng bmep gage indicated a rapid power loss & the r eng RPM 'increased out of control' to about 3100 RPM. The aircrew retarded the r throttle & reduced the r eng to 2100 prm by using the prop…
- [NTSB DEN85FA043](https://openairdocs.org/ntsb/DEN85FA043.md): Piper PA-30-160 · Albuquerque, NM · Accident · 3 fatal · Field investigation · Final report · Dec 15, 1984 · N7329Y · Destroyed
  > The flt was en route from forth worth, TX, to santa fe, new Mexico, when the plt decided to divert to Albuquerque. The a/c crashed while being vectored for an ILS approach to rwy 8. The plt received his instrument rating slightly more than 6 mos before the…
- [NTSB MIA85LA060](https://openairdocs.org/ntsb/MIA85LA060.md): Piper PA-30 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 14, 1984 · N8678Y · Substantial damage
  > Electrical malfunctions caused the loss of air to ground communications and acft navigational equipment. The plt became lost about 70 mi east of Jacksonville, FL. With the help of another acft the plt located the arpt and radio communications were temporarily…
- [NTSB LAX85FA070](https://openairdocs.org/ntsb/LAX85FA070.md): Cessna R172K · Desert Center, CA · Accident · 3 fatal · Field investigation · Final report · Dec 14, 1984 · N7310K · Destroyed
  > The flight departed on an IFR flight after receiving a weather briefing which included flight precautions for light to moderate icing in clouds and in precipitation from 7,000 ft to 20,000 ft. the pilot reported picking up ice and that he was unable to climb…
- [NTSB FTW85LA077](https://openairdocs.org/ntsb/FTW85LA077.md): Cessna 340 · Odessa, TX · Accident · No injuries · Limited investigation · Final report · Dec 14, 1984 · N69477 · Substantial damage
  > An experienced professional pilot encountered forecast icing conditions on approach that obscurred forward visibility. On go-around, anti-icing equipment cleared small area of windshield, pilot decided to land. He failed to maintain sufficient airspeed to…
- [NTSB FTW85LA075](https://openairdocs.org/ntsb/FTW85LA075.md): Cessna 210G · Temple, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1984 · N5901F · Destroyed
  > During the flt in IMC, plt reported low oil pressure to ATC and declared an emergency. Aprx 4 mins later an engine failure was experienced. Plt stated he broke out of the overcast at aprx 250 ft AGL and the acft impacted a power line during the attempted…
- [NTSB SEA85FA035](https://openairdocs.org/ntsb/SEA85FA035.md): Smith, Ted Aerostar Aerostar 601A · Genoa, NV · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1984 · N9781Q · Destroyed
  > The plt had flown from carson city, NV to shreveport, la on 12/10/84 for business. At 1530 on 12/12/84, he departed on aflt to corona,CA with refueling stops at albuquerque, NM & phoenix, AZ. He departed phoenix at 2100, but encountered wx & returned to…
- [NTSB LAX85FA071](https://openairdocs.org/ntsb/LAX85FA071.md): Grumman American AA-5A · Gorman, CA · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1984 · N26131 · Destroyed
  > The plt was on a night x-country flt. When the acft did not arrive at its destination, a search was initiated. On 12/12/84, the plane was found where it had impacted an area of rising terrain while approaching the tehachapi mountains. Impact occurred on a…
- [NTSB LAX85FA069](https://openairdocs.org/ntsb/LAX85FA069.md): Cessna 152 · Rosamond, CA · Accident · 2 fatal · Field investigation · Final report · Dec 13, 1984 · N49806 · Destroyed
  > Acft crashed in mountainous area while on a VFR flight. No record of the plt obtaining a wx briefing was found. Local residents 3-4 miles from accident site reported clouds, fog, rain, snow and hail obscured the mountains on the afternoon of 12/12/84 on…
- [NTSB LAX85FA068](https://openairdocs.org/ntsb/LAX85FA068.md): Hart-Thorp T-18 Tiger · Tulare, CA · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1984 · N3WB · Destroyed
  > Acft departed arpt & about 5 mins later was seen 'descending vertically' out of 'dark rain cloud' at about 1,000 ft AGL. During attempted recovery at about 300 ft AGL, acft broke up & crashed in a field. Plt did not obtain wx briefing prior to flt and did not…
- [NTSB NYC85LA042](https://openairdocs.org/ntsb/NYC85LA042.md): Cessna T337G · Lawrence, MA · Accident · Minor injuries · Limited investigation · Final report · Dec 12, 1984 · N8CF · Destroyed
  > N8CF made an emergency landing in a wooded are after experiencing a dual engine failure aprx 50 minutes after takeoff./ the fuel pressure gage for the front engine displayed erratic elevated readings. The pilot then decided to return to the departure airport…
- [NTSB DEN85LTE03](https://openairdocs.org/ntsb/DEN85LTE03.md): Kenneth Roebuck Varieze · Antonio, CO · Accident · 1 fatal · Final report · Dec 12, 1984 · N572KE · Destroyed
  > Plt had filed a VFR flt plan from espanola, NM, to durango, CO, with a proposed departure time of 1500 MST and as en route flt time of 1 hr 10 mins. The flt plan was not activated. A search for the acft began on 12/13/84 and ended on 12/24/84. On 6/10/85 the…
- [NTSB SEA85FA030](https://openairdocs.org/ntsb/SEA85FA030.md): Cessna C-152 · Port Orchard, WA · Accident · 2 fatal · Field investigation · Final report · Dec 11, 1984 · N80061 · Destroyed
  > Low ceilings, rain, fog were reported in area pt the time of the accident. The student pilot was on a solo x-c, flt plan was filed with help of instru. Wx VFR nr. Acft dep 1104 PST acft crashed abt 1317 no rcrd of des reached or where acft was for 2 hrs. Acft…
- [NTSB MKC85LA035](https://openairdocs.org/ntsb/MKC85LA035.md): Piper PA-28R-201T · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Dec 11, 1984 · N3664M · Substantial damage
  > The plt confirmed an alternator failure a short time after departing fairmont, cancelled his IFR clearance and continued to Norfolk for landing. Upon reaching his destination the plt was unable to extend the landing gear due to the electrical failure and no…
- [NTSB LAX85LA090](https://openairdocs.org/ntsb/LAX85LA090.md): Beech C45H · Littlefield, AZ · Accident · No injuries · Limited investigation · Final report · Dec 11, 1984 · N636CF · Substantial damage
  > The plt stated that he encountered low ceilings & fog in the mountain passes. After several unsuccessful attempts to cross the mountains he believed he did not have sufficient fuel on board to reach any airports to the south so he selected a flat mesa &…
- [NTSB MIA85FA057](https://openairdocs.org/ntsb/MIA85FA057.md): Beech 65 · Marathon, FL · Accident · No injuries · Field investigation · Final report · Dec 10, 1984 · N101V · Substantial damage
  > According to the plt, aprx 20 min after departure at 4,000 to 5,000 ft the left eng failed followed 10 min later by a power loss in the right eng. During the desc the right eng restarted momentarily but only ran for about 1 min. The plt ditched near a…
- [NTSB FTW85LA073](https://openairdocs.org/ntsb/FTW85LA073.md): Beech C23 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Dec 10, 1984 · N2077L · Substantial damage
  > The acft experienced a power failure while in cruise flight at 1100 ft AGL. He stated that after switching tanks, the 'engine started twice bit failed to continue'. Investigation revealed that the left fuel tank was empty and the right tank had an…
- [NTSB ATL85LA052](https://openairdocs.org/ntsb/ATL85LA052.md): Lake LA-4-200 · Griffin, GA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1984 · N1046L · Substantial damage
  > The acft crashed during an emergency landing while on a personal x-counry flight. Inspection of the acft at the accident site revealed empty fuel sumps and fuel tanks.
- [NTSB DEN85FA037](https://openairdocs.org/ntsb/DEN85FA037.md): Cessna T-210G · Meeker, CO · Accident · 1 fatal · Field investigation · Final report · Dec 9, 1984 · N6805R · Destroyed
  > The a/c dept larami, WY on an IFR flt to grand junction, CO.in the vicinity of Meeker, CO, the plt experienced an apparent instrument gyro problem. He flew off course once but with the help of ARTCC he was vectored back on course, only to again go off crse,…
- [NTSB CHI85FA067](https://openairdocs.org/ntsb/CHI85FA067.md): Taylorcraft BC12-D · Albion, IN · Accident · 1 fatal · Field investigation · Final report · Dec 9, 1984 · N5219M · Destroyed
  > Carburetor icing conditions existed on the day of the accident. The plt stated that after takeoff, he stayed in the traffic pattern to ensure he would not experience carburetor icing problems. He then departed the traffic pattern & overflew a wooded area…
- [NTSB BFO85FA008](https://openairdocs.org/ntsb/BFO85FA008.md): Beech C23 · Clifton, VA · Accident · No injuries · Field investigation · Final report · Dec 9, 1984 · N6536R · Substantial damage
  > Shortly after leveling at the cruise altitude of 2500 ft, the pilot noted a gradual RPM decrease and resultant loss of power. Altitude could not be maintained and the pilot selected a rolling open field in which to land when he realized that reaching an…
- [NTSB MKC85LA033](https://openairdocs.org/ntsb/MKC85LA033.md): Rockwell S-2R · West Helena, AR · Accident · No injuries · Limited investigation · Final report · Dec 8, 1984 · N8503V · Substantial damage
  > On departing West Helena arpt the plt reduced pwr to a cruise pwr setting. The engine responded to the pwr reduction but then the torque dropped to zero. The acft descended striking the ground. Inspection and testing of the engine and fuel control unit did…
- [NTSB FTW85LA071](https://openairdocs.org/ntsb/FTW85LA071.md): Cessna 152 · Slidell, LA · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 1984 · N24780 · Substantial damage
  > When the renter plt arrived at the fixed base operator, he was informed that his acft had been flown 1.6 hrs and had not been refueled. Further, he was told that the acft was booked by another plt in one hr. Plt elected to take the acft with partial fuel…
- [NTSB DEN85LA038](https://openairdocs.org/ntsb/DEN85LA038.md): Hughes 369D · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Dec 8, 1984 · N5124X · Substantial damage
  > Shortly after takeoff plt felt shutter in acft and noticed a rise in the turbine outlet temp. Plt heard low whine of high pitch noise in engine. Engine chip detector light came on followed by the engine out light and horn and oil pressure warning light.…
- [NTSB CHI85LA066](https://openairdocs.org/ntsb/CHI85LA066.md): Cessna 177 · Cadiz, OH · Accident · No injuries · Limited investigation · Final report · Dec 8, 1984 · N2835X · Substantial damage
  > The acft was damaged during a forced landing after the eng failed inflight. The plt stated that about 10 miles west of harrison airport the eng began sputtering & running rough. When unable to regain full power the plt attempted to glide to tapan airpark, a…
- [NTSB LAX85FUG02](https://openairdocs.org/ntsb/LAX85FUG02.md): Corlett-Beahm KR-2 · Riverside, CA · Accident · No injuries · Final report · Dec 7, 1984 · N90233 · Destroyed
  > The acft nosed over in a field during a forced landing following a loss of power which occurred for unknown reason(s).
- [NTSB DEN85FA040](https://openairdocs.org/ntsb/DEN85FA040.md): Mcdonnell Douglas DC-9-30 · Denver, CO · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1984 · N942 · No damage
  > While en route from las vegas, NV to minneapolis, MN at FL330, the acft had been in smooth air for at least 30 min when clear air turbulence (cat) was encountered. The flt crew turned on the 'fasten seat belt' sign. A flt attendant, attempting to buckle into…
- [NTSB ATL85IA047](https://openairdocs.org/ntsb/ATL85IA047.md): Boeing 727-251 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Dec 4, 1984 · N264US · Minor damage
  > During cruise flt electrical fire erupted in the circuit board and electrical components of the temp control unit for the rear galley oven. Associated circuit breaker opened, electrical power to galley was turned off and within minutes the unit was cool to…
- [NTSB MIA85LA051](https://openairdocs.org/ntsb/MIA85LA051.md): Beech V35B · St. Petersburg, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1984 · N6737L · Substantial damage
  > Plt received special VFR clearance to enter traffic pattern for landing and was advised to descend to 1600 ft and contact tower for landing. Plt initiated descent, lowering gear to increase descent rate and received landing clearance while manuvering to…
- [NTSB LAX85LA057](https://openairdocs.org/ntsb/LAX85LA057.md): Beech C24R · Rialto, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 1984 · N60102 · Destroyed
  > At about 0730 PST, witnesses near the lytle creek ranger station, located northwest of Rialto, CA, heard an acft circling low in the area, then heard the sound of impact nearby. The wx at the time was described as overcast with zero visibility in fog & light…
- [NTSB FTW85FA065](https://openairdocs.org/ntsb/FTW85FA065.md): Cessna 182B · Brownsville, TX · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1984 · N2406G · Destroyed
  > The acft hit the stabilization wires on a 300 ft fm radio transmission tower followed by a collision with power- lines. Investigation revealed the plt & passg were enroute to the Brownsville, TX, airport to fly a DC-3 cargo acft to Mexico. At 1453 CST,…
- [NTSB LAX85LA054](https://openairdocs.org/ntsb/LAX85LA054.md): Champion 7ECA · Pt Mugu, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 1984 · N5236X · Destroyed
  > The pilot stated that the engine quit once, started running again, then quit a second time and he ditched in the ocean. He reported that he departed with full fuel tanks and that he flew for 3 hours 45 minutes before the engine quit. The wreckage was not…

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

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

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