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

## Cases, newest first

- [NTSB SEA83LA195](https://openairdocs.org/ntsb/SEA83LA195.md): Mooney M20-F · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N3525X · Destroyed
  > The plt stated he experienced a complete power loss while flying over puget sound at 700 ft. the acft sank & was not recovered.
- [NTSB FTW83FA415](https://openairdocs.org/ntsb/FTW83FA415.md): Piper PA-23-250 · Huffman, TX · Accident · 2 fatal · Field investigation · Final report · Sep 3, 1983 · N5551Y · Destroyed
  > The acft collided with the ground in a high speed dive and totally disintegrated. Impact created a 7' crater and material blew out for 100 yards. The engines were recovered at the 14 ft level in the crater. The acft took off at 2215 from baytown TX. At 2334…
- [NTSB FTW83LA411](https://openairdocs.org/ntsb/FTW83LA411.md): Piper PA28R-201T · Anton Chico, NM · Accident · No injuries · Limited investigation · Final report · Sep 2, 1983 · N47402 · Substantial damage
  > During flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…
- [NTSB FTW83LA421](https://openairdocs.org/ntsb/FTW83LA421.md): Hughes 500D · Portales, NM · Accident · No injuries · Limited investigation · Final report · Sep 1, 1983 · N277SP · Substantial damage
  > The plt landed at Portales, NM with about 7 gal of jet fuel remaining in the fuel tank. Since jet fuel was not available, he added 15 gal of 100 low lead avgas, which was an approved alternate fuel. Shortly after taking off, the eng flamed out & the plt was…
- [NTSB MKC83LA207](https://openairdocs.org/ntsb/MKC83LA207.md): Hiller UH-12E · Corwith, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1983 · N173HA · Destroyed
  > While en route, the plt heard a clanking noise behind him which was followed by a severe vibration of the flt controls. He initiated an autorotative descent from 3000 ft. he said the helicopter began to roll left, then righted itself. The helicopter touched…
- [NTSB LAX83FA416](https://openairdocs.org/ntsb/LAX83FA416.md): Hughes 369D · Shandon, CA · Accident · No injuries · Field investigation · Final report · Aug 31, 1983 · N5007G · Substantial damage
  > The helicopter made a hard landing during autorotation after the plt reportedly had an engine failure at about 50 ft aglabout 15 minutes after takeoff. The engine was checked at long beach after the accident and test run in the acft. The engine was also…
- [NTSB FTW83FA406](https://openairdocs.org/ntsb/FTW83FA406.md): Piper PA 28R-200 · Copan, OK · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1983 · N1292T · Destroyed
  > The acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…
- [NTSB MIA83LA215](https://openairdocs.org/ntsb/MIA83LA215.md): Cessna 150H · Dorado, PR · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N6479S · Substantial damage
  > During a dual instructional flt, the instructor plt (CFI) retarded the throttle to simulate a forced landing. He stated that the student did the emergency procedure & headed for the field. Later, when the throttle was advanced, the eng did not respond. The…
- [NTSB MIA83FA216](https://openairdocs.org/ntsb/MIA83FA216.md): Piper PA-28-161 · Marathon, FL · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1983 · N30533 · Destroyed
  > The acft landing gear collapsed during a forced landing due to a cabin fire. The landing occurred just short of the rwy at Marathon arpt, FL. The plt had departed this arpt about 30 minutes earlier on the 2nd leg of a student x-country flt. The departure was…
- [NTSB FTW83LA390](https://openairdocs.org/ntsb/FTW83LA390.md): Piper PA-28-140 · Buffalo, OK · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1983 · N9762W · Destroyed
  > The acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…
- [NTSB CHI83LA398](https://openairdocs.org/ntsb/CHI83LA398.md): Stewart Headwind · New Douglas, IL · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N64MF · Substantial damage
  > During flt, the eng lost power & the plt was unable to get a restart. While making a forced landing in a plowed field, the main gear collapsed & the acft nosed over. Later, after the acft was uprighted, the eng was started & was operated to 1300 RPM. Prop…
- [NTSB ATL83LA345](https://openairdocs.org/ntsb/ATL83LA345.md): Cessna 172E · Middlebourne, WV · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1983 · N5331T · Substantial damage
  > The plt reported that en route, the eng began to run rough. Reportedly, he applied carburetor heat, full rich mixture & full throttle, but was unable to significantly increase the power. He circled for a short time, then made an emergency landing. An exam of…
- [NTSB ANC83LA155](https://openairdocs.org/ntsb/ANC83LA155.md): Bell B-206B · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N87TA · Substantial damage
  > The helicopter made a autorotative forced landing after a loss of power during cruise. The landing was made on a road and the main rotor severed the tailboom. During the post-accident investigation a leak was found in the auto valve(part number 206061634-3)…
- [NTSB LAX83LA412](https://openairdocs.org/ntsb/LAX83LA412.md): Cessna 182A · South Dos Palos, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1983 · N6055B · Substantial damage
  > While descending toward the arpt, after 4 parachute jumpers had egressed, the eng loss all power. There was insufficient alt to glide to the arpt, so the plt elected to land in an area with rice paddies. As the acft touched down, it encountered a dike & nosed…
- [NTSB DEN83LA202](https://openairdocs.org/ntsb/DEN83LA202.md): Piper PA-11-90 · Babb, MT · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · CFGNB · Substantial damage
  > The pilot said that before takeoff, he fueled the left tank of the aircraft. The right tank was reportedly empty. Five or ten minutes after takeoff the pilot put the acft into a 5 degree left forward slip for about 30 seconds. As soon as the pilot returned…
- [NTSB LAX83LA411](https://openairdocs.org/ntsb/LAX83LA411.md): Piper PA-28-161 · Upland, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1983 · N47980 · Substantial damage
  > The plt reported that the acft had an alternator failure in the vicinity of cajon pass. He requested & was provided radar vectors toward the rialto muni arpt. However, the plt saw cable arpt, aprx 14 mi west of rialto, & thought it was rialto muni.…
- [NTSB DEN83FU003](https://openairdocs.org/ntsb/DEN83FU003.md): Weedhopper Unknown · Powell, WY · Accident · 1 fatal · Final report · Aug 28, 1983 · UNREG · Substantial damage
  > The ultralight vehicle crashed in a corn field while on a local pleasure flt. It impacted the soft ground in a nose down, vertical attitude. The engine buried itself to a depth of 18 inches. Examination of the wreckage airframe revealedthat a bolt with a self…
- [NTSB CHI83LA397](https://openairdocs.org/ntsb/CHI83LA397.md): Carter MONNETT-MONI · Port Huron, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1983 · N3944C · Substantial damage
  > While turning crosswind after takeoff the eng quit. The plt was unable to restart the eng & the acft collided with trees. The plt stated the acft's ignition system was the cause of the eng failure.
- [NTSB CHI83LA395](https://openairdocs.org/ntsb/CHI83LA395.md): Cessna 150H · Allegan, MI · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N6996S · Substantial damage
  > The acft collided with a guard rail during a precautionary landing in IMC weather. During the flt wx cond deteriorated and the plt became concerned about collision with structures(towers) in the area and elected to land on a fairground. Braking was poor on…
- [NTSB MIA83LA213](https://openairdocs.org/ntsb/MIA83LA213.md): Piper PA-22 · Okeechobee, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1983 · N1325C · Destroyed
  > The non-rated plt stated that the eng lost power while he was flying over lake Okeechobee. He was unable to restart the eng & subsequently ditched the acft in the lake. After recovery, the eng was inspected, but no preimpact, mechanical failure was evident.
- [NTSB ATL83LA341](https://openairdocs.org/ntsb/ATL83LA341.md): Cessna A188B · Samson, AL · Accident · No injuries · Limited investigation · Final report · Aug 27, 1983 · N9172R · Substantial damage
  > The acft collided with a dirt bank during a forced landing after an inflt power loss. The pilot was enroute to a field at about 500 ft AGL when the power loss occurred. The pilot did not jettison his load of chemicals. He landed on wet grass and was unable to…
- [NTSB ANC83FA154](https://openairdocs.org/ntsb/ANC83FA154.md): Cessna 180 · Fairbanks, AK · Accident · 3 fatal · Field investigation · Final report · Aug 27, 1983 · N2145Z · Destroyed
  > At aprx 1900 adt, the plt & 2 passengers departed north pole, AK on a flt to portage creek strip. During the flt, he contacted flt service to obtain wx information. He asked for & was provided the wx at several locations. Also, he stated that he was really…
- [NTSB FTW83FU003](https://openairdocs.org/ntsb/FTW83FU003.md): Rotec Rally 2B · Keller, TX · Accident · 1 fatal · Final report · Aug 26, 1983 · UNREG · Destroyed
  > After assembling his ultralight, the plt received dual instruction in a 2 place model. After his 2nd dual flt, he told his instructor (CFI) he had soloed his vehicle. The CFI cautioned him against further solo flts until he was qualified &emphasized the need…
- [NTSB FTW83LA393](https://openairdocs.org/ntsb/FTW83LA393.md): Cessna 172N · La Porte, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N192AR · Substantial damage
  > The acft collided with a utility pole after the engine lost power shortly after takeoff. The plt reported he was cruising at 300 ft AGL on a pipeline patrol when the engine began to lose power. The plt made a forced landing and collided with a utility pole.…
- [NTSB ATL83FA340](https://openairdocs.org/ntsb/ATL83FA340.md): Cessna T210L · Pleasant Grove, AL · Accident · Minor injuries · Field investigation · Final report · Aug 25, 1983 · N20MS · Substantial damage
  > The plt reported that the eng lost power as he was approaching his destination with the left main fuel gage indicating 1/2 full. During the emergency landing the left wing tip hit a utility pole prior to touchdown. The acft then collided with a chain link…
- [NTSB MKC83FU005](https://openairdocs.org/ntsb/MKC83FU005.md): Airmass Sunburst · Carthage, MO · Accident · 1 fatal · Final report · Aug 23, 1983 · UNREG · Destroyed
  > After making several takeoffs & landings, the plt circled the arpt, then departed in a northerly direction. One witness stated that the vehicle was flying toward a storm that was approaching from the north. He estimated the ultralight was at aprx 300 ft AGL…
- [NTSB MIA83IA210](https://openairdocs.org/ntsb/MIA83IA210.md): Douglas DC-10-10 · Norfolk, VA · Incident · No injuries · Incident investigation · Final report · Aug 21, 1983 · N69NA · Minor damage
  > Acft experienced severe vibrations in flight & made a precautionary landing after shutting down the number 2 engine. It was determined in a subsequent teardown that the second stage high pressure turbine blade had failed in flight.
- [NTSB DEN83FTK04](https://openairdocs.org/ntsb/DEN83FTK04.md): Piper PA-28-181 · Box Elder, SD · Accident · Serious injuries · Final report · Aug 21, 1983 · N8422U · Destroyed
  > Before reaching his destination, the plt contacted apch control & reported that he was about 40 mi away & was low on fuel. About 10 min later, the acft ran out of fuel. The plt stated that he 'could possibly make ellsworth' but the controller told him that…
- [NTSB CHI83FU009](https://openairdocs.org/ntsb/CHI83FU009.md): Weedhopper B · St. Joseph, IL · Accident · 1 fatal · Final report · Aug 21, 1983 · UNREG · Destroyed
  > The ultralight vehicle collided with the ground after the left wing folded up at about 1000 ft AGL. Witnesses said the ultralight was traveling east when the wing collapsed or folded back. Reportedly, it pitched up & the right wing tip went up. The vehicle…
- [NTSB ATL83LA332](https://openairdocs.org/ntsb/ATL83LA332.md): Starduster II · Wakefield, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1983 · N80FE · Destroyed
  > During flt, the eng lost power & the propeller stopped. The passenger recalled hearing a 'ticking' sound from the eng prior to the power loss. According to the plt & the passenger, the acft stalled & began to spin as the plt tried to turn into a bean field…
- [NTSB MKC83LA197](https://openairdocs.org/ntsb/MKC83LA197.md): Arrow Arrow Sport · Red Oak, IA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N853H · Substantial damage
  > During flt, there was a progressive loss of eng power. The plt was unable to reach the arpt & made a crash landing in a soybean fld. An investigation revealed that the #4 cylinder failed in the area of the exhaust valve rocker box.
- [NTSB LAX83LA425](https://openairdocs.org/ntsb/LAX83LA425.md): Boeing E75 · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N4756V · Destroyed
  > While on a flt to dispense orthene, a fill line began leaking into the cockpit. After dispensing the load & while returning to the landing area at about 30 ft AGL, the plt reached below the seat to check the leak. While he was bending over to locate the leak,…
- [NTSB DEN83FA193](https://openairdocs.org/ntsb/DEN83FA193.md): Cessna 421A · West Jordan, UT · Accident · 1 fatal · Field investigation · Final report · Aug 20, 1983 · N2239Q · Destroyed
  > Investigation revealed that the plt aborted two takeoff attempts due to a 'roughness' in one eng. Not able to duplicate the roughness during subsequent ground checks, the plt departed. At an alt of 300 AGL the left eng began to surge and the right eng,…
- [NTSB DCA83IA035](https://openairdocs.org/ntsb/DCA83IA035.md): Boeing 767 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Aug 20, 1983 · N609UA · No damage
  > The acft was descending from FL 410 with the throttles at idle. As power was added at FL 295 the left eng surged & exceeded max EGT. 18 secs later the right eng surged & exceeded its max EGT. The left & right engs were shut down at FL 200 & 177 respectively.…
- [NTSB NYC83LA216](https://openairdocs.org/ntsb/NYC83LA216.md): Stinson 108-1 · Tully, NY · Accident · No injuries · Limited investigation · Final report · Aug 18, 1983 · N8470K · Destroyed
  > At 2,000 ft near syracuse the plt decided he had enough fuel to continue on to his home base at cortland. He added full power to climb back to 3,000 ft & encountered turbulence. With full power & 80 KTS indicated the acft was losing altitude. The acft…
- [NTSB FTW83FA384](https://openairdocs.org/ntsb/FTW83FA384.md): Piper PA-28-161 · El Paso, TX · Accident · 4 fatal · Field investigation · Final report · Aug 18, 1983 · N8193Q · Destroyed
  > The plt had postponed the flt due to wx conditions. During a flt from deming, NM to waco, TX, the acft subsequently crashed within the boundries of a private arpt, northwest of El Paso, TX. Impact occurred in a steep left bank, nose low attitude. The degree…
- [NTSB ATL83FIG06](https://openairdocs.org/ntsb/ATL83FIG06.md): Cessna 150 · Petersburg, WV · Accident · Serious injuries · Final report · Aug 18, 1983 · N7368G · Substantial damage
  > The acft was unable to maintain altitude while crossing mountain ridges & stalled about 50 ft above a tree line. The pilots had been using automotive fuel during prefueling stop
- [NTSB DCA83AA034](https://openairdocs.org/ntsb/DCA83AA034.md): Piper PA-31-350 · Peach Springs, AZ · Accident · 10 fatal · Final report · Aug 17, 1983 · N88LV · Destroyed
  > The acft departed las vegas, NV as the 2nd of 5 acft on a scheduled grand canyon sight-seeing flt. The 1st portion of the flt was over the las vegas strip area & lake mead & was uneventful. However, wx conditions precluded the plt from continuing over the…
- [NTSB SEA83FA179](https://openairdocs.org/ntsb/SEA83FA179.md): Mooney M20E · Nampa, ID · Accident · No injuries · Field investigation · Final report · Aug 16, 1983 · N79833 · Substantial damage
  > While climbing, aprx 10 miles west of the departure airport, the eng lost power. The plt attempted to glide back to the arpt. When he realized he could not reach the arpt, he selected a grassy field for an emergency landing. During the landing roll, the right…
- [NTSB FTW83LA386](https://openairdocs.org/ntsb/FTW83LA386.md): Rockwell S2-R · Jonesboro, AR · Accident · No injuries · Limited investigation · Final report · Aug 16, 1983 · N110JS · Substantial damage
  > The acft collided with a ditch during a forced landing after the engine quit. Enroute to a farmers field the engine failed very shortly after flame was seen emitting from the exhaust stack. Post accident examination showed that several blades in the 1st stage…
- [NTSB CHI83FA383](https://openairdocs.org/ntsb/CHI83FA383.md): Cessna 421C · Centerto, IN · Accident · Serious injuries · Field investigation · Final report · Aug 16, 1983 · N386G · Destroyed
  > The plt reported that during a climb after takeoff, he engaged the autopilot. While making an entry on a trip sheet, he felt a bump & noted that the acft had started to descend. He disengaged the autopilot & the nose pitched down violently. Reducing power had…
- [NTSB MKC83LA193](https://openairdocs.org/ntsb/MKC83LA193.md): Grumman American AA-5A · Keytesville, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1983 · N9703U · Substantial damage
  > According to the pilot, after departure he climbed to 2000 feet MSL, adjusted the throttle for 2500 RPM and leaned the mixture for cruise flight. The engine slowed to 2000 RPM so he selected the opposite fuel tank, moved the mixture to full rich and applied…
- [NTSB MKC83LA192](https://openairdocs.org/ntsb/MKC83LA192.md): Burnett Sonerai 2 · Oxford, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1983 · N65MB · Substantial damage
  > After takeoff, the plt turned to a x-wind leg of the traffic pattern & then the engine lost power. He made a forced landing in an OAT field, but reported that during the approach, he misjudged his height & did not flare in time. Subsequently, the acft landed…
- [NTSB CHI83LA380](https://openairdocs.org/ntsb/CHI83LA380.md): Cessna C-152 · Hamtramck, MI · Accident · No injuries · Limited investigation · Final report · Aug 15, 1983 · N67374 · Destroyed
  > While en route, the eng lost power & the plt restarted the eng. After flying aprx 4 mi further, the eng lost power again, and again, the plt obtained a restart. After a 3rd loss of power, the plt was making a forced landing when the acft collided with an…
- [NTSB MIA83FA202](https://openairdocs.org/ntsb/MIA83FA202.md): Rockwell 114A · Ebro, FL · Accident · 5 fatal · Field investigation · Final report · Aug 14, 1983 · N215XP · Destroyed
  > Shortly after takeoff the plt advised departure control that he was going around clouds & that there was no activity on his onboard storm scope. Several minutes later radar contact was lost. The acft had broke up in flight. Although VMC prevailed at the…
- [NTSB FTW83LA377](https://openairdocs.org/ntsb/FTW83LA377.md): Cessna 150 · Jones, LA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1983 · N61193 · Substantial damage
  > During a properly endorsed solo flt the student plt became lost in hazy conditions. He was not aware that one of the acft's fuel gauges was inop and had no watch. Eventually he established his location but ran out of gas before reaching his home field. The…
- [NTSB NYC83FNC11](https://openairdocs.org/ntsb/NYC83FNC11.md): Bellanca 7GCBC · Fort Kent, ME · Accident · Minor injuries · Final report · Aug 13, 1983 · N7693S · Substantial damage
  > After aprx 10 min of flt, the eng lost power & the plt made an emergency landing in a potatoe field. During the landing, the float plane was substantially damaged. A large quantity of water was found in the fuel tanks.
- [NTSB LAX83FA397](https://openairdocs.org/ntsb/LAX83FA397.md): Ercoupe 415-C · Kernville, CA · Accident · 1 fatal · Field investigation · Final report · Aug 13, 1983 · N94369 · Destroyed
  > The acft crashed in rising terrain 6 mi west of the departure arpt at 5,000 ft MSL. The alta sierra pass is 6,500 ft mslwith mountain tops at 8,320 ft MSL. The plt was issued a student certificate on 8/22/80 which was not renewed.
- [NTSB DEN83LA189](https://openairdocs.org/ntsb/DEN83LA189.md): Piper PA-22-135 · Parker, CO · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N2183A · Substantial damage
  > The acft nose gear collapsed during a forced landing after the engine quit. Neither the acft owner nor the acft had flown for over 9 months. The owner was on a recheck flt with a CFI for currency. The owner had preflighted the acft and found no water in the…
- [NTSB ATL83LA325](https://openairdocs.org/ntsb/ATL83LA325.md): Piccard AX-6 · Louisvile, KY · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N16JF · Substantial damage
  > The plt received a wx briefing at 0600 EDT & noted nothing significant that would be a hazard to flt. He proceeded to long run park, aprx 20 mi east of louisville, KY, to launch the ballon. There was a 654 foot tower in the vicinity, but the plt believed the…

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

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

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