# NTSB investigations: Maneuvering

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 218 of 378 · 18,851 cases

## Cases, newest first

- [NTSB ATL84FA045](https://openairdocs.org/ntsb/ATL84FA045.md): Robinson R22 · Gaithersburg, MD · Accident · No injuries · Field investigation · Final report · Nov 5, 1983 · N8414H · Substantial damage
  > During his 2nd solo flt in the Robinson R22, the plt performed 2 low 'g' maneuvers. The 1st maneuver was essentially the same as when he practiced it during a check-out flt. However, the 2nd maneuver produced a rapid right roll to aprx 60 deg of bank. The plt…
- [NTSB LAX84FA047](https://openairdocs.org/ntsb/LAX84FA047.md): Cessna 172N · Elko, NV · Accident · 2 fatal · Field investigation · Final report · Nov 4, 1983 · N739YL · Destroyed
  > The acft crashed in mountainous terrain while on a deer spotting flt. There were no witnesses to the accident. About 8 hours after departure the acft was declared missing. The acft was found the following day at about 0730 hours by air search acft. Ground…
- [NTSB CHI84FA035](https://openairdocs.org/ntsb/CHI84FA035.md): Cessna 150F · Portland, IN · Accident · 1 fatal · Field investigation · Final report · Nov 3, 1983 · N8320G · Destroyed
  > The plt had just purchased the acft & flew a previous co-owner to montpelier, IN, where he landed at about dusk. The previous co-owner deplaned. He said that after the acft took off, he saw it turn to the west & depart toward marion. A short time later, the…
- [NTSB NYC84FGM01](https://openairdocs.org/ntsb/NYC84FGM01.md): Piper PA-28-161 · Marshburg, PA · Accident · Minor injuries · Final report · Nov 2, 1983 · N8163P · Destroyed
  > After refueling at ithaca, NY, the plts of two Piper PA-28 acft departed as a flt of two. They had planned to continue their flt back to cincinnati, oh with another en route stop at columbus, OH. The non-instrument rated plt of N8163P was following the lead…
- [NTSB LAX84LA041](https://openairdocs.org/ntsb/LAX84LA041.md): Continental Copters Tomcat Mark 5A · Castroville, CA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1983 · N9092T · Substantial damage
  > The helicopter landed hard during a forced landing after a power loss. The accident occurred on the last swath run. When the engine stopped the acft was 6 ft AGL. The pilot reported that the engine stopped from fuel starvation. On recommendation for…
- [NTSB SEA84FA015](https://openairdocs.org/ntsb/SEA84FA015.md): Cessna 150K · Near Challis, ID · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1983 · N5631G · Destroyed
  > A witness at the Challis arpt observed the acft takeoff, then turn & depart toward the west. It was found the next day Near Challis creek about 16 mi west of Challis. Impact occurred in a relatively flat area in a narrow wooded valley, at an elevation of…
- [NTSB NYC84LA017](https://openairdocs.org/ntsb/NYC84LA017.md): Cessna 152 · Skaneateles, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 31, 1983 · N89940 · Substantial damage
  > The pilot stated that after returning from a x-ctry flight he was unable to activate the arpt rwy lights. Low on fuel, the engine quit while he searched for a place to land. He executed a forced landing into an open field. The pilot statedhe should not have…
- [NTSB LAX84LA038](https://openairdocs.org/ntsb/LAX84LA038.md): Grumman AA-5B · Quartzsite, AZ · Accident · No injuries · Limited investigation · Final report · Oct 30, 1983 · N28221 · Substantial damage
  > The plt had planned to land at a private arpt, northeast of quartizite, AZ. After arriving in that area, he saw what he thought was the rwy, but when he descended for a closer look, he decided that it was not the rwy. He reported that he climbed to aprx 250…
- [NTSB FTW84LA036](https://openairdocs.org/ntsb/FTW84LA036.md): Robinson R22 · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Oct 30, 1983 · N9074Y · Substantial damage
  > The plt reported that he intended to practice hovering within the arpt boundries. According to him, as the RPM was increased to 100% for lift-off, the right skid came off the ground, but the left skid was 'evidently stuck in the soft ground.' Right cyclic was…
- [NTSB ANC84LA012](https://openairdocs.org/ntsb/ANC84LA012.md): Bell 206-B · Kodiak, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 1983 · N90188 · Destroyed
  > While inspecting a transmission wire tower, the left skid became entangled with the power line guide. This pulled the helicopter out of CG. While the plt was trying to correct the problem, the m/r blade contacted the tower & struck the tail boom separating…
- [NTSB ATL84FKJ02](https://openairdocs.org/ntsb/ATL84FKJ02.md): Cessna A188B · Hazel Green, AL · Accident · 1 fatal · Final report · Oct 29, 1983 · N731JJ · Destroyed
  > The acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…
- [NTSB NYC84FU002](https://openairdocs.org/ntsb/NYC84FU002.md): Highcraft Buccaneer · Mountville, PA · Accident · 1 fatal · Final report · Oct 24, 1983 · UNREG · Substantial damage
  > The amphibian ultralight vehicle was being flown on a series of flt tests after being assembled. At aprx 1615 EDT, the plt took off & was followed by another plt in another ultralight vehicle for observation purposes. No undesirable flt characteristic was…
- [NTSB MIA84FA017](https://openairdocs.org/ntsb/MIA84FA017.md): Hight Smaragd CP-301-S · St Augustine, FL · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1983 · N42RH · Destroyed
  > The owner/builder/plt of the home built acft & a passenger (a foreign visitor) were on a local flt along a beach area. The purpose of the flt was for the visitor to take some video tape footage with the video camera that he took along. Witnesses, including a…
- [NTSB SEA84FA011](https://openairdocs.org/ntsb/SEA84FA011.md): Boeing A75N1 · Brewster, WA · Accident · Serious injuries · Field investigation · Final report · Oct 23, 1983 · N49385 · Destroyed
  > The plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…
- [NTSB LAX84LA027](https://openairdocs.org/ntsb/LAX84LA027.md): Piper PA-28R-200 · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 1983 · N5021S · Destroyed
  > After departing north island nas (naval air station), the plt attempted to change frequencies, but the megahertz (mhz) tuning knob came off at a setting of 122.1 mhz. He could still use the knob for tuning tenths of a mhz, so he contacted San Diego fss on…
- [NTSB FTW84LA029](https://openairdocs.org/ntsb/FTW84LA029.md): Mooney M20D · Ama, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 1983 · N6611U · Destroyed
  > After takeoff the plt made two low passes over the rwy, & was turning to make a third when the acft struck trees.
- [NTSB LAX84LA026](https://openairdocs.org/ntsb/LAX84LA026.md): Robinson R22 · Kailua-Kona, HI · Accident · No injuries · Limited investigation · Final report · Oct 22, 1983 · N9044Q · Substantial damage
  > The plt was transporting a photographer for the purpose of photographing a sports event. While hovering at an unspecified low altitude, the plt became distracted and allowed the rotor RPM to decrease. After the low RPM warning horn sounded, the plt tried to…
- [NTSB LAX84LA022](https://openairdocs.org/ntsb/LAX84LA022.md): Cessna 150M · Anacapa Island, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 20, 1983 · N714PR · Destroyed
  > During flt, the plt established radio contact with a fishing boat & made a low pass near the boat at an estimated altitude of 200 ft. the captain of the boat said he told the plt not to fly like that around his boat again. However, the plt made another low…
- [NTSB NYC84FFJ02](https://openairdocs.org/ntsb/NYC84FFJ02.md): Piper PA-25-235 · Williamson, NY · Accident · No injuries · Final report · Oct 16, 1983 · N82526 · Substantial damage
  > The right wing of N82526 struck a telephone pole guy wire while involved with applying agricultural chemicals.
- [NTSB ATL84LA021](https://openairdocs.org/ntsb/ATL84LA021.md): Aero Commander 100-180 · Bardstown, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1983 · N4006X · Substantial damage
  > The CFI stated that the student preflighted the acft. They climbed to 3,000 ft & were practicing basic instrument maneuvers when a power loss occurred. After maneuvering to clear obstructions, then s-turning to dissipate altitude, thecfi stalled the acft…
- [NTSB LAX84FA011](https://openairdocs.org/ntsb/LAX84FA011.md): Ayres S2R-600 · Westside, CA · Accident · No injuries · Field investigation · Final report · Oct 14, 1983 · N3089K · Substantial damage
  > The eng lost power & the acft's gear collapsed during the subsequent forced landing. No preimpact failure/malfunction of the eng or prop were found.
- [NTSB FTW84FA021](https://openairdocs.org/ntsb/FTW84FA021.md): Piper PA-28-161 · Aubrey, TX · Accident · 1 fatal · Field investigation · Final report · Oct 14, 1983 · N8161S · Destroyed
  > The purpose of the flt was to give a bfr to the private rated plt who had not flown for about 1 year. There were no witnesses to the accident. The plt stated that he could recall doing basic airwork during the flt, but could not recall any details of the flt…
- [NTSB ATL84FKG01](https://openairdocs.org/ntsb/ATL84FKG01.md): Beech 65-A80 · Edison, GA · Accident · Minor injuries · Final report · Oct 13, 1983 · N62TG · Substantial damage
  > At aprx 2130 EDT, the acft collided with a tree while the plt was making a low pass over a wooded area. After hitting the tree, the plane crashed into a pond. Reportedly, the acft had returned from columbia (south america) & the aircrew were preparing to drop…
- [NTSB MIA84FA006](https://openairdocs.org/ntsb/MIA84FA006.md): Piper PA-23-250 · Cornwell, FL · Accident · 2 fatal · Field investigation · Final report · Oct 10, 1983 · N6830Y · Destroyed
  > The acft was found with a large amount of burned marijuna onboard & the cargo door open.
- [NTSB LAX84LA010](https://openairdocs.org/ntsb/LAX84LA010.md): Hiller UH12E · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1983 · N4026G · Substantial damage
  > The plt loaded the helicopter & started a spraying operation. He stated that as he pulled the helicopter up from the 1st spray run, it started shaking & went partially out of control. He was able to regain enough control to get the helicopter in level flt…
- [NTSB SEA84FA007](https://openairdocs.org/ntsb/SEA84FA007.md): Cessna 182Q · Near Challis, ID · Accident · 1 fatal · Field investigation · Final report · Oct 9, 1983 · N97845 · Destroyed
  > The acft collided with trees at an elevation of 8560 ft MSL. The crash site was on the east side of a ridge & aprx 30 to 40 ft below the ridgeline. The ridge ran northeast-southwest & formed the west side of dry canyon. The plt stated that the eng lost power…
- [NTSB CHI84AA016](https://openairdocs.org/ntsb/CHI84AA016.md): Kemmeyer Sonerai II · Battle Creek, MI · Accident · 1 fatal · Final report · Oct 9, 1983 · N22SK · Destroyed
  > The plt flew the home built acft from Battle Creek to marshall, MI to talk to friends. After about 30 min, he took off without refueling. Shortly after the acft departed, a witness on a golf course heard the sound of the eng. He looked up & saw the acft in…
- [NTSB MIA84FA005](https://openairdocs.org/ntsb/MIA84FA005.md): Globe GC-1B · Venice, FL · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1983 · N80682 · Destroyed
  > Immediately after takeoff the plt radioed on UNICOM that his cowling was coming open & that he was returning to the field. Other plts waiting for takeoff reported seeing that acft enter a left turn between 200-300 ft AGL & become very slow. One of the plts…
- [NTSB DEN84LA005](https://openairdocs.org/ntsb/DEN84LA005.md): Cessna R182 · Grovont, WY · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1983 · N7039W · Substantial damage
  > The plt reported that after taking off, the gear warning horn sounded when he retracted the gear. He continued en route while trying to get a safe indication. Subsequently, aprx 20 mi east of the departure point, he elected to entend the gear & return to the…
- [NTSB LAX84LA004](https://openairdocs.org/ntsb/LAX84LA004.md): Cessna 172P · Virginia City, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1983 · N65966 · Substantial damage
  > The acft collided with rising terrain while on a photographic flt for nat'l geographic of mountainous terrain around Virginia City. A witness said the acft flew too low and slow and hit the up-slope terrain with the left landing gear while circling. The acft…
- [NTSB CHI84FA007](https://openairdocs.org/ntsb/CHI84FA007.md): Cessna 320Q · Malinta, OH · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1983 · N7529Q · Destroyed
  > The plt was on a night x-country flt to position the acft at defiance, OH. In the vicinity of Malinta, OH. Several witnesses heard and/or observed the acft circling for aprx 5 to 10 min. About 1/2 of those who heard the eng sounds saidthe engs were sputtering…
- [NTSB SEA84LA002](https://openairdocs.org/ntsb/SEA84LA002.md): Hiller UH12-E · Tenino, WA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1983 · N401HA · Substantial damage
  > The plt visually checked the fuel tanks prior to takeoff & thought he had seen fuel in the tanks. The fuel gauges were inoperative & he was using timing as a method to determine the remaining fuel. Aprx 5 min after takeoff, the eng lost power as he was lining…
- [NTSB ATL84LA007](https://openairdocs.org/ntsb/ATL84LA007.md): Hiller UH-12B · Mccullough, AL · Accident · No injuries · Limited investigation · Final report · Oct 1, 1983 · N67699 · Substantial damage
  > The acft crashed in a cotton field after maneuvering at low alt to check the crop. The pilot said he was at an alt of 4 or 5 ft and forward flt was below transitional lift speed. The rotor RPM began to reduce and also there was a drop in engine RPM. The pilot…
- [NTSB MIA83FA242](https://openairdocs.org/ntsb/MIA83FA242.md): Rockwell 560E · Matacumbe Key, FL · Accident · 1 fatal · Field investigation · Final report · Sep 30, 1983 · N70C · Destroyed
  > The acft crashed in the water in an isolated area of the Florida bay while in a near inverted, left wing low, nose down attitude & at a high rate of descent with slow forward speed. The landing gear were down & locked, & the flaps were extended about 10 degs.…
- [NTSB DEN83FA224](https://openairdocs.org/ntsb/DEN83FA224.md): Hughes 369D (500) · Provo, UT · Accident · No injuries · Field investigation · Final report · Sep 30, 1983 · N8693F · Substantial damage
  > The helicopter was on a test flt to track & balance the main rotor system & to complete a 100 hr inspection. Prior to the flt, an occasional flicker of the fuel filter light was noted, but it was thought to be a wiring problem. After taking off, the fuel…
- [NTSB ATL83FA386](https://openairdocs.org/ntsb/ATL83FA386.md): Cessna A150L · Ringgold, GA · Accident · 1 fatal · Field investigation · Final report · Sep 30, 1983 · N6063J · Substantial damage
  > The acft was observed buzzing a truck stop, partially owned by the plt, at low altitude. The acft then stalled & spun into the ground. Some of the witnesses observed the plt waving & one witness said it appeared that the plt was leaning out the window…
- [NTSB FTW83LA446](https://openairdocs.org/ntsb/FTW83LA446.md): Aero Commander S2R · Napoleonville, LA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1983 · N8890Q · Substantial damage
  > The acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…
- [NTSB SEA83LA205](https://openairdocs.org/ntsb/SEA83LA205.md): Hughes 369B · Cougar, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1983 · N10966 · Destroyed
  > The aircraft collided with trees and terrain during a forced landing attempt following an in-flight power loss. Subsequent engine teardown revealed failure of several components.
- [NTSB DEN83FTE13](https://openairdocs.org/ntsb/DEN83FTE13.md): Eipper Quicksilver MX 11 · Erie, CO · Accident · Minor injuries · Final report · Sep 25, 1983 · N4412L · Substantial damage
  > The plt of the 2 place, ultralight vehicle stated that he was demonstrating a power off glide when a severe sink developed. He applied full power; however, he was unable to arrest the descent prior to ground impact. The plt reported that the wind was variable…
- [NTSB ATL83FA378](https://openairdocs.org/ntsb/ATL83FA378.md): Cessna 172 · Benson, NC · Accident · 3 fatal · Field investigation · Final report · Sep 25, 1983 · N8360B · Destroyed
  > Aprx 3 mi south of the crash site, a witness saw the acft flying northbound along a railroad track. He reported that the acft was flying below tree top level & the eng was running smoothly. A short time later, another witness aprx 1 1/2 mi further north, also…
- [NTSB DEN83LU005](https://openairdocs.org/ntsb/DEN83LU005.md): Eipper Quicksiver E (Modified) · Sioux Falls, SD · Accident · 1 fatal · Final report · Sep 24, 1983 · UNREG · Destroyed
  > After takeoff, the plt of the weight-shift controlled, ultralight vehicle entered a steep climb, then began a series of maneuvers which included past vertical wingovers. Reportedly, on his last maneuver, he performed a whip stall. A ground witness stated that…
- [NTSB DEN83FA222](https://openairdocs.org/ntsb/DEN83FA222.md): Piper PA-18-150 · Encampment, WY · Accident · 2 fatal · Field investigation · Final report · Sep 24, 1983 · N3770P · Destroyed
  > A low pass was made over a fishing pond so the front seat plt could wave at his father. According to the plt's father, the pass was below the level of the tree tops. In attempting to pull up sharply to avoid the trees, the acft was banked steeply and stalled.…
- [NTSB ANC83LA184](https://openairdocs.org/ntsb/ANC83LA184.md): Piper PA-18 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1983 · N3873Z · Substantial damage
  > Reportedly, the plt was looking at an area in mountainous terrain near an off arpt landing area when he encountered windshear & a downdraft while turning. He stated that the alft dropped 400 ft & he applied full power; however, the left wing struck the ground…
- [NTSB LAX83FUJ17](https://openairdocs.org/ntsb/LAX83FUJ17.md): Gulfstream-Schweizer G-164B · Queen Creek, AZ · Accident · No injuries · Final report · Sep 22, 1983 · N8081K · Substantial damage
  > The eng lost power & the acft nosed over in a soft plowed field. The #1 cylinder articulating rod had separated.
- [NTSB ATL83FA376](https://openairdocs.org/ntsb/ATL83FA376.md): Aeronca O-58B · Geiger, AL · Accident · Serious injuries · Field investigation · Final report · Sep 22, 1983 · N46929 · Destroyed
  > The acft impacted the ground in a nose low attitude. A witness saw the acft circle at 300-400 ft AGL and then do a snap roll. The acft then entered a spin and spun about 2 turns before impact. The witness said the engine sounded normal throughout the…
- [NTSB LAX83FA453](https://openairdocs.org/ntsb/LAX83FA453.md): Kecskes DER Jager D-1X · Clearlake Oaks, CA · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1983 · N3727 · Destroyed
  > The acft collided with the ground while performing low alt aerobatics at a private ranch strip. This show had become a regular wed morning event to entertain guest. According to witnesses the acft had done rolls loops and pull-ups. After a low pass the acft…
- [NTSB FTW83LA435](https://openairdocs.org/ntsb/FTW83LA435.md): Pitts S-1T · Haskell, OK · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1983 · N49311 · Destroyed
  > While performing a snaproll at an airshow, the crankshaft failed & the prop separated from the acft. The plt landed on the arpt, but the acft went thru an open hanger before the plt could stop. The wings struck supporting poles under the roof of the hanger.…
- [NTSB LAX83FA446](https://openairdocs.org/ntsb/LAX83FA446.md): Mortensen Lombard DILLEY-68 · Sun Valley, NV · Accident · Minor injuries · Field investigation · Final report · Sep 17, 1983 · N301LS · Destroyed
  > The plt was one of several competing in a pylon air race during the reno national air races. The acft were approaching the first pylon in a steep left bank. According to the plt, another acft pulled in front of him, & while attempting to avoid a collision at…
- [NTSB CHI83FA410](https://openairdocs.org/ntsb/CHI83FA410.md): Piper PA-28-180 · Forestville, WI · Accident · 2 fatal · Field investigation · Final report · Sep 17, 1983 · N15651 · Destroyed
  > The acft was observed making low passes, 150-200 ft AGL, over a wooded area & then strike a radio antenna at the 207-FT level. The acft rolled inverted & impacted the ground. Members of the plt's aero club stated that the plt & pax were probably spotting for…
- [NTSB ATL83LA374](https://openairdocs.org/ntsb/ATL83LA374.md): Ayres S2R-600 · Sledge, MS · Accident · No injuries · Limited investigation · Final report · Sep 17, 1983 · N4011T · Substantial damage
  > The plt stated that a power loss occurred during a pull-up prom a swath run. The acft reportedly touched down hard during a forced landing & was substantially damaged.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=219

## 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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=218

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