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

## Cases, newest first

- [NTSB LAX84LA149](https://openairdocs.org/ntsb/LAX84LA149.md): Cessna 172M · Kelseyville, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 21, 1984 · N5154H · Destroyed
  > The plt became disoriented while in IMC and could not locate the arpt. The ple stated that due to lights on the ground he thought that he was over the peninsula, which is an area of low terrain. He attempted a 180 deg turn after descendingto 500 ft MSL. The…
- [NTSB LAX84FA152](https://openairdocs.org/ntsb/LAX84FA152.md): Cessna 182Q · Soledad, CA · Accident · 1 fatal · Field investigation · Final report · Jan 21, 1984 · N96956 · Destroyed
  > The acft crashed into the side of a hill at about 1500 ft MSL in a 50 degree nose down attitude. The plt had encounteredweather on a night VFR flt. He was attempted to return the acft for a scheduled club flt the next morning. He had previously planned an…
- [NTSB NYC84FFA01](https://openairdocs.org/ntsb/NYC84FFA01.md): Cessna 150M · Lowville, NY · Accident · No injuries · Final report · Jan 20, 1984 · N3731V · Substantial damage
  > The acft was on a VFR flt from old forge to canastota NY when during cruise flt the engine would only develop partial power. A forced landing was made to a shopping mall and the acft sustained substantial damage. The weather conditions were conducive to…
- [NTSB MIA84IA063](https://openairdocs.org/ntsb/MIA84IA063.md): Boeing 727-225A · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Jan 20, 1984 · N8852E · Minor damage
  > The acft experienced a rapid loss of fuel quanity on the #1 fuel tank during the climb to cruise. Investigation revealed that prior to this flt the water separator access door had been replaced by a fabricated metal plate which separated in flt. The separated…
- [NTSB LAX84LA162](https://openairdocs.org/ntsb/LAX84LA162.md): Beech K35 · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Jan 20, 1984 · N9510R · Substantial damage
  > Cruising at 10,500 ft the number 5 cylinder separated from the engine ass'y causing the loss of power. During the forced ldg roll the acft collided with a snow covered log collapsing the nose gear. The engine was overhauled in 1980. 1,239 hrs of operation had…
- [NTSB LAX84LA148](https://openairdocs.org/ntsb/LAX84LA148.md): Cessna 172 · Oakland, CA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1984 · N54042 · Substantial damage
  > The acft collided with wires during a descent through the clouds. The student plt had found himself on top of an overcast and managed to descend through it but in doing so a power line was hit. The plt climbed back on top and continued to destination without…
- [NTSB LAX84FA144](https://openairdocs.org/ntsb/LAX84FA144.md): Piper PA-32-300 · Oxnard, CA · Accident · Serious injuries · Field investigation · Final report · Jan 19, 1984 · N4012R · Destroyed
  > The acft made a forced landing and collided with irrigation pipes which criss-crossed a freshly plowed field after the engine lost power during a night cruise. After the accident the fuel selector valve was found in the off position and nofuel was in the…
- [NTSB DEN84FA071](https://openairdocs.org/ntsb/DEN84FA071.md): Cessna 310Q · Casper, WY · Accident · No injuries · Field investigation · Final report · Jan 18, 1984 · N628AS · Substantial damage
  > The plt stated he was told, the r aux fuel pump was inop & to prime/start the r eng, he had to position the r fuel selector (sel) to x-feed. On the 1st 2 legs of the flt, he used this procedure, but noted the r fuel sel was hard to move. While starting for…
- [NTSB FTW84FA115](https://openairdocs.org/ntsb/FTW84FA115.md): Bellanca 8KCAB · Davidson, OK · Accident · 1 fatal · Field investigation · Final report · Jan 15, 1984 · N57665 · Destroyed
  > The acft struck high voltage powerlines while conducting aerobatic maneuvers. A witness stated that the acft pulled-up into a nose high maneuver, climbed to about 3000 ft AGL, appeared to slide backwards and enter a nose-down turning maneuver. Full power was…
- [NTSB ATL84LA081](https://openairdocs.org/ntsb/ATL84LA081.md): Cessna 182M · Dalton, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1984 · N91625 · Substantial damage
  > Plt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…
- [NTSB SEA84LA039](https://openairdocs.org/ntsb/SEA84LA039.md): Cessna 150H · Deer Park, WA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1984 · N22796 · Substantial damage
  > The acft was damaged during a forced landing after the engine lost power. Post accident investigation revealed no fuel aboard the acft. The flt lasted 4 hours and 15 minutes. This acft endurance is 4.4 hours.
- [NTSB LAX84FA142](https://openairdocs.org/ntsb/LAX84FA142.md): Cessna 182R · Yorba Linda, CA · Accident · 3 fatal · Field investigation · Final report · Jan 14, 1984 · N9456H · Destroyed
  > The acft was seen to descend in a near-vertical high speed descent out of the clouds and disappear into a canyon. A search party found the acft on the floor of the canyon. The acft had departed an arpt 18 miles away on a VFR x-country flight. Investigation…
- [NTSB FTW84LA116](https://openairdocs.org/ntsb/FTW84LA116.md): Bell 206L-1 · Vencie, LA · Accident · No injuries · Limited investigation · Final report · Jan 13, 1984 · N5759M · Substantial damage
  > According to the plt, he took off from a came site to pick up duck hunters at several locations. During the flt, he encountered fog & turned toward venice, LA to land. He then saw an oil field structure & some land & elected to make a precautionary landing.…
- [NTSB LAX84FA138](https://openairdocs.org/ntsb/LAX84FA138.md): Piper PA-28R-200 · Tracy, CA · Accident · 3 fatal · Field investigation · Final report · Jan 12, 1984 · N5054T · Destroyed
  > The flight departed under instrument meteorological conditions, with visibility restricted to one quarter mile by fog. The ceiling was obscured. After departure witnesses heard the aircraft make what appeared to be a left turn. Next they heard the engine…
- [NTSB ANC84LA030](https://openairdocs.org/ntsb/ANC84LA030.md): Cessna 206 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Jan 12, 1984 · N29142 · Destroyed
  > The acft crashed into a heavely wooded area after encountering IMC weather conditions and losing power on the engine. Heavy icing and freezing rain were reported in the area. The plt stated that he could not maintain VFR conditions on top due to raising cloud…
- [NTSB LAX84FA136](https://openairdocs.org/ntsb/LAX84FA136.md): Cessna 185 · Union City, CA · Accident · 1 fatal · Field investigation · Final report · Jan 11, 1984 · N93086 · Destroyed
  > The acft crashed into hilly terrain in an almost vertical high speed power on descent. A witness about 64 miles north of the accident site had seen an acft that met the description of the accident acft 'scud running', or flying beneath the low cloud bases…
- [NTSB FTW84LA113](https://openairdocs.org/ntsb/FTW84LA113.md): Piper PA-32R-301T · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jan 11, 1984 · N81753 · Substantial damage
  > The pilot made an emergency landing after a total power loss. Prior to the total loss there had been approximately four drops in manifold pressure. The gear collapsed on landing, bending the engine mounts & both wing spars. The subsequent investigation…
- [NTSB FTW84LA416](https://openairdocs.org/ntsb/FTW84LA416.md): Cessna 210N · Plaquemine, LA · Accident · 1 fatal · Limited investigation · Final report · Jan 10, 1984 · N6500Y · Destroyed
  > The acft was found by a hunter crashed in a heavily wooded swamp area aprx 10 months after the acdnt. The sole body fnd was beyond a condition of testing for toxicology or autopsy. The body was identified as a plt who was supposed to meet the owner of the…
- [NTSB FTW84LA111](https://openairdocs.org/ntsb/FTW84LA111.md): Cessna T210N · Waring, TX · Accident · No injuries · Limited investigation · Final report · Jan 9, 1984 · N9515Y · Substantial damage
  > During flt in IMC conditions, the alternator became inoperative. Subsequently, the acft lost electrical power, but the plt had gotten into VMC conditions. He elected to land on a private grass strip. He reported that his apch speed was too fast, he landed…
- [NTSB ANC84LA028](https://openairdocs.org/ntsb/ANC84LA028.md): Piper PA-18 · Talkeetna, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1984 · N1317A · Substantial damage
  > The plt stated that at the time of the accident, he encountered a white out condition. The acft stalled and crashed on ahillside.
- [NTSB FTW84LA109](https://openairdocs.org/ntsb/FTW84LA109.md): Cessna 150M · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Jan 7, 1984 · N9468U · Substantial damage
  > During arrival, the acft lost power after a descent from 3000 to 2000 ft. at that time, the plt noted that the fuel gages indicated each tank was 1/8 full, but he did not apply carb heat until he was in an emergency descent. He elected to land on a boulevard.…
- [NTSB SEA84LA035](https://openairdocs.org/ntsb/SEA84LA035.md): Hughes 269C · Almo, ID · Accident · No injuries · Limited investigation · Final report · Jan 6, 1984 · N300DS · Substantial damage
  > The plt stated, he was attempting to depart with visibility of 1/8 to 1/4 mi in fog. Shortly after departure the visibility dropped to approximately 50 to 100 ft. he attempted a slow runing landing and landed hard.
- [NTSB SEA84FA036](https://openairdocs.org/ntsb/SEA84FA036.md): Cessna C172N · Arco, ID · Accident · 3 fatal · Field investigation · Final report · Jan 6, 1984 · N5216E · Destroyed
  > According to company personnel, the flt was operated as a charter. The plt, also the company director of operations, was not authorized to conduct FAR 135 flights under instrument flight conditions. He was reported to have stated that he was going to 'get a…
- [NTSB LAX84FA134](https://openairdocs.org/ntsb/LAX84FA134.md): Cessna P206 · Redding, CA · Accident · 4 fatal · Field investigation · Final report · Jan 5, 1984 · N2645X · Destroyed
  > While en route, the plt contacted a fss & was advised that the Redding arpt was below minimums due to fog. He then contacted the benton UNICOM (7 mi nw of Redding muni) & reported that he could not see the rwy lights at the benton arpt, but that he would…
- [NTSB SEA84FU001](https://openairdocs.org/ntsb/SEA84FU001.md): Eipper Quicksilver MX · Junction City, OR · Accident · Serious injuries · Final report · Jan 4, 1984 · UNREG · Substantial damage
  > According to the plt, he was operating the ultralight between 50 & 200 ft AGL, when he experienced throttle control difficulties. He reported that while correcting the problem, his attention to the surrounding environment was reduced. When he returned his…
- [NTSB FTW84FA107](https://openairdocs.org/ntsb/FTW84FA107.md): Aerospatiale AS-355F · Morgan City, LA · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1984 · N5792X · Destroyed
  > The plts in a helicopter encountered foggy weather during a positioning flt and crashed into a lake about 4 mi from the departure point, a fisherman who witnessed the accident said the acft descended into the water in a nose low attitude. The acft skipped and…
- [NTSB SEA84FA031](https://openairdocs.org/ntsb/SEA84FA031.md): Piper 601P · Garfield, WA · Accident · No injuries · Field investigation · Final report · Jan 2, 1984 · N6081Q · Destroyed
  > The acft was forced to land on a road due to a fire in the left wing. During the investigation of the accident it was found that the left turbocharger had been removed and reinstalled several times. A clamp on the turbocharger exhaust wasimproperly installed…
- [NTSB NYC84FNE01](https://openairdocs.org/ntsb/NYC84FNE01.md): Piper PA-28-151 · Southwick, MA · Accident · Minor injuries · Final report · Jan 2, 1984 · N44386 · Substantial damage
  > The acft lost power & made an emergency forced landing in a school yard. Investigation revealed that only a few drops offuel remained in the powerplant & 1QT plus 1PT remained in the wing tanks with none in the gasolator. There was no evidence of fuel leakage…
- [NTSB LAX84FA129](https://openairdocs.org/ntsb/LAX84FA129.md): Yaple, Robert G. VARI-EZE · Bowie, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1984 · N1050G · Destroyed
  > Despite 2 wx briefings forecasting marginal VFR conditions with reports of icing, the plt departed on a flt in the non-ifr equipped acft. Just prior to the accident, transmissions between the plt & ATC indicated that the acft was in a snow shower between…
- [NTSB MIA84IA054](https://openairdocs.org/ntsb/MIA84IA054.md): Mcdonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean) · Incident · Minor injuries · Incident investigation · Final report · Jan 1, 1984 · N82NA · 2 aircraft · No damage
  > Acft nearly collided with paa N82NA at FL370 about 200 mi east of miami when acft passed about 300 ft from each other ina nonradar environment. Both acft were at their assigned flight level & were operating on routes approved & issued by miami ARTCC. The D72…
- [NTSB LAX84FA130](https://openairdocs.org/ntsb/LAX84FA130.md): Bell 47J-2 · Kahuku, HI · Accident · 1 fatal · Field investigation · Final report · Jan 1, 1984 · N2097 · Destroyed
  > About 3 min after takeoff, the helicopter was observed descending in a 'gliding fashion' until water impact. A witness reported that it appeared to be flying straight & did not appear to be in trouble. The witness reported that she could hear the eng & it…
- [NTSB NYC84LA064](https://openairdocs.org/ntsb/NYC84LA064.md): Beech 35 · Altamont, NY · Accident · No injuries · Limited investigation · Final report · Dec 31, 1983 · N3034V · Substantial damage
  > The eng started running rough shortly after take off & the plt made a forced landing in a snow covered field.
- [NTSB MKC84LA051](https://openairdocs.org/ntsb/MKC84LA051.md): Beech BE-23 · Grimes, IA · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1983 · N9225S · Substantial damage
  > The acft made a forced landing after engine failure during a night x-country. The landing gear collapsed during the landing. The plt reported that the fuel pressure went to zero and the engine quit as he approached des moines. Attempts to restart the engine…
- [NTSB MKC84IA053](https://openairdocs.org/ntsb/MKC84IA053.md): Piper PA-28RT-201T · Trenton, NE · Incident · No injuries · Incident investigation · Final report · Dec 31, 1983 · N2082Y · Minor damage
  > During a precautionary landing due to a partial power loss the acft nose gear failed after colliding with a snow bank. The no. 6 cylinder wall was found broken.
- [NTSB MKC84LA047](https://openairdocs.org/ntsb/MKC84LA047.md): Cessna 172A · Hospers, IA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1983 · N7229T · Substantial damage
  > The plt said he was on a power line patrol flt & was flying aprx 60 to 80 ft AGL. Reportedly, he applied carburetor heat for about 1 min. When the carburetor heat was turned off, the eng quit. The plt reapplied the heat & the eng restarted for a moment & then…
- [NTSB MIA84LA052](https://openairdocs.org/ntsb/MIA84LA052.md): Boeing 737-201 · Near Tampa, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1983 · N811N · No damage
  > Prior to departure, the captain reviewed available wx reports & was aware of the wx conditions, including current sigmets. He decided to fly a course that was parallel to a frontal sys until he could get to an area where he could continue to his destination.…
- [NTSB LAX84FA118](https://openairdocs.org/ntsb/LAX84FA118.md): Piper PA28-235 · Irwindale, CA · Accident · No injuries · Field investigation · Final report · Dec 28, 1983 · N55665 · Substantial damage
  > According to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…
- [NTSB DEN84LA052](https://openairdocs.org/ntsb/DEN84LA052.md): Lake LA-4-200 · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Dec 28, 1983 · N39451 · Substantial damage
  > The acft was damaged in a forced landing on a highway after the engine seized. The plt said 'the engine made unusual sounds of an engine running bad.' Then it lost compression and seized. He made a forced landing on a highway and damagedthe hull. Examination…
- [NTSB ATL84FA078](https://openairdocs.org/ntsb/ATL84FA078.md): Beech BE-36 · St. Catherines, GA · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1983 · N4829M · Destroyed
  > The plt received a wx briefing at 1037 EST before departing on an IFR x-country. At 1051, a severe thunderstorm warning (#537) was issued by the national wx svc. When the plt requested an IFR clearance at 1107, he was advised of the frontal activity. About 3…
- [NTSB LAX84FA116](https://openairdocs.org/ntsb/LAX84FA116.md): Beech P35 · Mckittrick, CA · Accident · 4 fatal · Field investigation · Final report · Dec 27, 1983 · N258C · Destroyed
  > After departing on an IFR x-country flt, the acft was climbing from 7000 to 11,000 ft, when the plt was asked (at 1126) to increasing her rate of climb because of other traffic. At 1926:13, she was asked to say her alt & she said she was at 9500 ft. at…
- [NTSB FTW84FA104](https://openairdocs.org/ntsb/FTW84FA104.md): Beech 58 · Marquez, NM · Accident · 4 fatal · Field investigation · Final report · Dec 27, 1983 · N9121S · Destroyed
  > The acft was flown at altitudes up to 15000 ft in areas of forecast icing. The acft was not equipped with oxygen. The acft was flown above 14000 ft for about 20 minutes after which it descended into icing conditions. Shortly thereafter, the acft made a climb…
- [NTSB CHI84LA067](https://openairdocs.org/ntsb/CHI84LA067.md): Piper PA-28R-200 · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · Dec 27, 1983 · N44042 · Substantial damage
  > The acft made an off arpt forced landing after the engine quit. According to the plt, the flt departed wichita falls, TX at 1516 with 48 gallons of fuel on board. When about 7 miles south-southeast of Terre Haute, IN, the engine quit. Theplt tried to restart…
- [NTSB DEN84LA051](https://openairdocs.org/ntsb/DEN84LA051.md): Bellanca 7GCBC · Escalante, UT · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1983 · N53846 · Substantial damage
  > About 15 min after takeoff, the plt reduced the power to aprx 40 to 50% & descended to about 300 ft AGL. When he tried to increase power, the eng faltered. He applied carburetor (carb) heat, but was unable to restore power in time to prevent a forced landing.…
- [NTSB ANC84FAG02](https://openairdocs.org/ntsb/ANC84FAG02.md): Cessna 170B · Mcgrath, AK · Accident · No injuries · Final report · Dec 26, 1983 · N2601D · Substantial damage
  > The plt reported that the eng had a partial loss of power & the application of carburetor heat did not improve the situation. He decided to land at the nearest arpt. According to the plt, the rwy was covered with aprx 2 ft of snow, and during the landing, the…
- [NTSB DEN84FA049](https://openairdocs.org/ntsb/DEN84FA049.md): Beech P35 · Near Dove Creek, CO · Accident · 1 fatal · Field investigation · Final report · Dec 25, 1983 · N8675M · Destroyed
  > The acft collided with mountainous terrain about 30 miles northwest of cortez co. the plt was on an IFR flt plan and had been advised before flt of hazardous icing conditions enroute. When the acft iced up the plt reversed course and even though descending…
- [NTSB ATL84LA074](https://openairdocs.org/ntsb/ATL84LA074.md): Cessna R182 · Pennington Gap, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1983 · N736NJ · Substantial damage
  > Enroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…
- [NTSB FTW84FA103](https://openairdocs.org/ntsb/FTW84FA103.md): Beech H35 · Taos, NM · Accident · 1 fatal · Field investigation · Final report · Dec 23, 1983 · N7933D · Substantial damage
  > The plt stated that a new fuel system had just recently been installed in miami, FL & he forgot about the new system while switching tanks & accidently turned it to the off position. When the eng quit he realized what he had done & switched back to a full…
- [NTSB ATL84LA073](https://openairdocs.org/ntsb/ATL84LA073.md): Piper PA-28-140 · Oak Mountain, AL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1983 · N56494 · Substantial damage
  > While en route, the plt arrived at a check point 18 min behind schedule. Aprx 25 min later, he tuned in an incorrect VOR frequency that he had written down on his flt plan. The station that he tuned in was east of the desired station & the geographic features…
- [NTSB LAX84FA114](https://openairdocs.org/ntsb/LAX84FA114.md): Cessna 182E · Humbolt, NV · Accident · 3 fatal · Field investigation · Final report · Dec 22, 1983 · CGCGA · Destroyed
  > While on a x-country flt in a mountainous area, the acft crashed into the side of a snow covered mountain. Impact occurred at the 8200 ft level in prince royal canyon. The canyon sloped upward to the south & terminated at an elevation of about 8900 ft. the…
- [NTSB DEN84LA046](https://openairdocs.org/ntsb/DEN84LA046.md): Gates Learjet 25D · Eagle, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 1983 · N300PL · Substantial damage
  > While en route, the aricrew encountered stronger headwinds than expected. They realized there would not be enough fuel reserved for an IFR flt to aspen, so the elected to divert to Eagle, CO. However, their landing at engle was delayed due to a snowplow (with…

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

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

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