# 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 224 of 377 · 18,850 cases

## Cases, newest first

- [NTSB SEA83LA105](https://openairdocs.org/ntsb/SEA83LA105.md): Callair A-9B · Winear, ID · Accident · No injuries · Limited investigation · Final report · May 23, 1983 · N7778V · Substantial damage
  > The acft collided with a fence during an off airport forced landing. The pilot was completing an aerial application pass & when the low fuel warning light came on the pilot switched tanks & turned on fuel booster. The engine quit at about 200 feet AGL.…
- [NTSB LAX83FA241](https://openairdocs.org/ntsb/LAX83FA241.md): Mooney M20K · Van Nuys, CA · Accident · 4 fatal · Field investigation · Final report · May 23, 1983 · N1150S · Destroyed
  > The acft was 1 mile out on the final approach when the tower asked the plt to make a right turn to downwind. The requestwas made because a C-130 following had declared an emergency for landing witnesses saw the Mooney M-20 enter a right turn and descend. The…
- [NTSB DEN83FTI04](https://openairdocs.org/ntsb/DEN83FTI04.md): Cessna 152 · Hamilton, MT · Accident · 2 fatal · Final report · May 23, 1983 · N5112Q · Destroyed
  > The acft was flying uphill at low alt when it struck the top of 4 trees and impacted the ground about 40 yards away inverted with power on at low airspeed. The elevation at the crash site was about 6000 ft MSL with the tops of the terrain in the direction of…
- [NTSB MIA83FA144](https://openairdocs.org/ntsb/MIA83FA144.md): Parson Bensen · Tavares, FL · Accident · 1 fatal · Field investigation · Final report · May 22, 1983 · UNREG · Substantial damage
  > The gyrocopter descended to the lake in an uncontrolled maneuver and crashed. The plt was on his 2nd flt in the acft and had been told to limit his climb to 10-15 ft AGL by the builder of the gyrocopter. The plt climbed to about 400 ft AGL and the acft…
- [NTSB FTW83FA245](https://openairdocs.org/ntsb/FTW83FA245.md): Breezy DRAKE-EDGAR · Broken Arrow, OK · Accident · 1 fatal · Field investigation · Final report · May 22, 1983 · N2261K · Destroyed
  > The acft collided with the ground in a flat spin that lasted for about 14 turns with no change in attitude. The plt had just completed an air show and was preparing to join a formation flt to return to the arpt. Just before joining the formation the plt was…
- [NTSB SEA83LA106](https://openairdocs.org/ntsb/SEA83LA106.md): Luscombe 8A · Cle Elum, WA · Accident · No injuries · Limited investigation · Final report · May 21, 1983 · N71836 · Substantial damage
  > The acft collided with a power line while flying low over a river. Reportedly the student pilot was buzzing some rafterson the yakima river when the acft collided with a power line about 25 feet AGL. The powerline was downed by the impact and the acft right…
- [NTSB NYC83FU005](https://openairdocs.org/ntsb/NYC83FU005.md): Robertson B1-RD · Enfield, NY · Accident · 1 fatal · Final report · May 21, 1983 · UNREG · 2 aircraft · Destroyed
  > During flt, the 2 ultralight vehicles were observed flying in close proximity to each other. Later, they were observed approaching the departure field at aprx 300 to 500 ft AGL. The lead vehicle, sn:115, with a non-rated plt, began a left turn. The other…
- [NTSB LAX83FA240](https://openairdocs.org/ntsb/LAX83FA240.md): Ryan PT-22/ST-3KR · Mesa, AZ · Accident · 2 fatal · Field investigation · Final report · May 21, 1983 · N721R · Destroyed
  > The acft departed with another Ryan PT-22 as a flt of two, in formation. Two rated plts were aboard the acft. After breaking formation, the acft was observed to enter a snap roll at aprx 2000 ft AGL. A witness observed the plane before it crashed. His…
- [NTSB ATL83FA194](https://openairdocs.org/ntsb/ATL83FA194.md): Beech A23 · Dublin, VA · Accident · 2 fatal · Field investigation · Final report · May 21, 1983 · N1467L · Destroyed
  > The acft collided with wires and crashed during a training mission. According to one of the cfi's other students the area in which the crash occurred was regularly used by the CFI for airwork. This airwork was normally performed at ABOUT800 ft AGL. On this…
- [NTSB DEN83LA115](https://openairdocs.org/ntsb/DEN83LA115.md): Bell 47G-3B-1 · Montrose, CO · Accident · Minor injuries · Limited investigation · Final report · May 20, 1983 · N1129W · Destroyed
  > Wx at the departure point was VMC but the surrounding mountans were partially obscured. The plt stated that he was following a road up the mountain & landed as the visibility deteriorated. Each time the cloud lifted the plt would lift-off & again land as the…
- [NTSB LAX83LA236](https://openairdocs.org/ntsb/LAX83LA236.md): Hiller UH-12E · Thermal, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N4027L · Substantial damage
  > The plt reported that he was aprx 1/3 of the way thru a procedure turn at about 60 ft AGL, when he experienced a partial power loss. He completed the turn, leveled the helicopter & moumentarily regained complete power, then the engine quit operating. An…
- [NTSB FTW83LA244](https://openairdocs.org/ntsb/FTW83LA244.md): Grumman G-164A · Taft, LA · Accident · Serious injuries · Limited investigation · Final report · May 18, 1983 · N5284 · Substantial damage
  > The acft flew into guy wires of a weather tower after a spray run.
- [NTSB FTW83LA241](https://openairdocs.org/ntsb/FTW83LA241.md): Grumman G-164A · Edna, TX · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N8941H · Substantial damage
  > The acft collided with a dirt bank while spraying due to reduced visibility from spray on the windshield. After the collision the plt regained control of the acft and flew back to jackson county arpt. There he made a dead stick landing on a flat area adjacent…
- [NTSB FTW83LA243](https://openairdocs.org/ntsb/FTW83LA243.md): Weatherly 620 · Cornerstone, AR · Accident · No injuries · Limited investigation · Final report · May 17, 1983 · N4619E · Substantial damage
  > The acft collided with a dirt bank during a forced landing after the engine quit. The plt said he was making a swath runwhen the engine quit. The flagman said he saw black smoke then white smoke as the engine quit. Post crash investigation revealed that the…
- [NTSB FTW83LA236](https://openairdocs.org/ntsb/FTW83LA236.md): Piper J3 · Sherrill, AR · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N42563 · Substantial damage
  > The acft nosed over on an emergency downwind landing in a wet rice field after an eng failure. The plt stated that the eng failed as a result of water in the fuel. The operator services his acft from a private underground fuel storage tank. As a result of…
- [NTSB NYC83FHM01](https://openairdocs.org/ntsb/NYC83FHM01.md): Bell 47G · Plainsboro, NJ · Accident · Minor injuries · Final report · May 15, 1983 · N6597D · Destroyed
  > The acft collided with the ground after a tail rotor drive shaft failed. The plt lost tail rotor control during an aerial application maneuver. The metallurgist report of examination and discovery of fatigue fracture after the accident is a part of the…
- [NTSB LAX83LA232](https://openairdocs.org/ntsb/LAX83LA232.md): Waco UPF7 · Seal Beach, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N29962 · Substantial damage
  > The acft was landed on a Beach highway after the engine quit at 800 feet MSL. The acft damage during the landing was limited to a broken landing strut, bent propeller blade and fractured front and rear spars of the right wing. The flightwas a scenic excursion…
- [NTSB SEA83FA095](https://openairdocs.org/ntsb/SEA83FA095.md): Mooney M20 · Edmonds, WA · Accident · 1 fatal · Field investigation · Final report · May 14, 1983 · N6532B · Destroyed
  > The plt had earlier visited his fiancee. She stated that he was intoxicated & she gave back her engagement ring to him. He was later observed departing the arpt. Shortly thereafter police began receiving complaints of a low flying acft overthe beach area. The…
- [NTSB MIA83LA141](https://openairdocs.org/ntsb/MIA83LA141.md): Cessna 172M · Ocean Way, FL · Accident · No injuries · Limited investigation · Final report · May 13, 1983 · N71409 · Substantial damage
  > The acft collided with the muddy bank of the intercoastal waterway during the 2nd of two low passes and nosed over when the nose gear dug in. Witnesses report seeing the acft pass at a low altitude. The pilot stated that while flying at lowalt he heard a loud…
- [NTSB FTW83LA235](https://openairdocs.org/ntsb/FTW83LA235.md): Grumman G-164A · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · May 13, 1983 · N7497 · Substantial damage
  > After loading the acft with 50 gal of water, the plt took off to conduct aerial applicaiton maneuvers & to calibrate the acft's spray boom. At the end of the 1st swath run on a westerly heading, he pulled up over a power line, turned 90 deg right, reversed…
- [NTSB NYC83FU004](https://openairdocs.org/ntsb/NYC83FU004.md): Vector 610 · Turners Falls, MA · Accident · 1 fatal · Final report · May 11, 1983 · UNREG · Destroyed
  > On 4/18/83, the ultralight vehicle was damaged by high winds. This necessitated the replacement of the front & rear spars as well as the battens which provided curvature to the upper wing surface. Prior to a test flt, a weighted tail wheel was also installed.…
- [NTSB ATL83LA181](https://openairdocs.org/ntsb/ATL83LA181.md): Pitts S1-SP · Wetumpka, AL · Accident · No injuries · Limited investigation · Final report · May 8, 1983 · N44GP · Substantial damage
  > The acft experienced an inflt structural failure of its upper wing during aerobatics in an air show. The acft was landedsafely and the pilot was not injured. The upper wing leading edge ribs reportedly collapsed as the pilot began to pull up at the beginning…
- [NTSB MIA83LA137](https://openairdocs.org/ntsb/MIA83LA137.md): Cessna 150G · Wauchula, FL · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N3307J · Destroyed
  > The acft stalled in a turn and crashed as the pilot was trying to return to the airport shortly after takeoff. The pilotstated that the acft lost power after takeoff and he elected to return and land. He made a steep left turn and the acft stalled at too low…
- [NTSB FTW83FA222](https://openairdocs.org/ntsb/FTW83FA222.md): Cessna 170B · Iraan, TX · Accident · 1 fatal · Field investigation · Final report · May 6, 1983 · N3038A · Destroyed
  > According to a truck driver, he was proceeding northbound on a highway, when he saw the aircraft enter what he described as a loop from aprx 100 ft AGL. The witness then lost sight of the acft, but shortly after that, he saw a large explosion on the ground…
- [NTSB LAX83LA213](https://openairdocs.org/ntsb/LAX83LA213.md): Piper PA-25-235 · Healdsburg, CA · Accident · No injuries · Limited investigation · Final report · May 4, 1983 · N4709Y · Destroyed
  > Before starting his dusting operation, the plt had observed the grape vineyard & made plans to begin on the following day. He reported observing the power lines that were suspended across the vineyard. However, he did not notice the anchor wire that was…
- [NTSB FTW83LA218](https://openairdocs.org/ntsb/FTW83LA218.md): Bell 206B · Thorndale, TX · Accident · No injuries · Limited investigation · Final report · May 4, 1983 · N5747L · Substantial damage
  > The acft approached the field to be surveyed and collided with a wire at about 30 ft AGL. According to the plt during the actual survey the acft is hovered at low alt. When the plt saw the wire ahead the reported airspeed was about 20 ktsthe collective was…
- [NTSB FTW83LA217](https://openairdocs.org/ntsb/FTW83LA217.md): Hiller UH-12E · Quanah, TX · Accident · No injuries · Limited investigation · Final report · May 3, 1983 · N138HA · Substantial damage
  > The helicopter was being used to search for cattle. As the plt was looking down through some bushes for cattle, the m/r blade hit a powerline wire about 25 ft AGL.
- [NTSB MIA83LA135](https://openairdocs.org/ntsb/MIA83LA135.md): Grumman G-164A · Clewiston, FL · Accident · No injuries · Limited investigation · Final report · May 2, 1983 · N8573H · Substantial damage
  > The plt had just washed the acft & went for a short local flt to dry it. He made a low pass at the arpt & the acft stalled during the pull-up.
- [NTSB LAX83FVG11](https://openairdocs.org/ntsb/LAX83FVG11.md): Rietman Widget · Yreke, CA · Accident · 1 fatal · Final report · May 2, 1983 · N3881D · Destroyed
  > After takeoff the acft was observed to climb to about 7,000-8,000 ft MSL & enter a slow flat spin. 8 turns were counted & the acft did not recover. The plt bailed out of the acft at about 500-600 ft but the parachute did not have time to fully deploy. The…
- [NTSB NYC83FA107](https://openairdocs.org/ntsb/NYC83FA107.md): Piper PA-24-250 · Coram, NY · Accident · 1 fatal · Field investigation · Final report · May 1, 1983 · N5738P · Destroyed
  > The acft crashed shortly after declaring an 'emergency.' A witness saw the acft, but heard no eng sound prior to the crash. Examination of eng failed to reveal any discrepancies. However, when the carburetor was examined no fuel was found in the line between…
- [NTSB LAX83LA209](https://openairdocs.org/ntsb/LAX83LA209.md): Schweizer SGS 1-26B · Chula Vista, CA · Accident · Minor injuries · Limited investigation · Final report · May 1, 1983 · N2478W · Substantial damage
  > The plt reported that he was soaring along the west slope of a small mountain when he inadvertently entered an area where the wind was obstructed by terrain features. His airspeed deteriorated & he tried to turn toward an area where he could obtain lift.…
- [NTSB LAX83LA207](https://openairdocs.org/ntsb/LAX83LA207.md): Aero Commander 600 S-2D · Gilroy, CA · Accident · Serious injuries · Limited investigation · Final report · May 1, 1983 · N1785S · Destroyed
  > Prior to takeoff, the acft was fully fueled with 100 gal of aviation gasoline & was loaded with 300 gal of non-toxic fungicidal mix. The plt took off, flew aprx 5 mi to a field, and after circling over the field, made 2 swath runs. During a procedure turn…
- [NTSB NYC83FA105](https://openairdocs.org/ntsb/NYC83FA105.md): Piper PA-38-112 · Farmingdale, NY · Accident · 2 fatal · Field investigation · Final report · Apr 30, 1983 · N2580L · Destroyed
  > Before the acft took off, the tower received a radio call from the plane requesting 'is there anyway we can get a simulated eng failure after takeoff & land downwind.' The aircrew indicated they would climb to 600 ft, then begin the simulated emergency. The…
- [NTSB FTW83LA213](https://openairdocs.org/ntsb/FTW83LA213.md): Grumman G-164A · Weslaco, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 1983 · N8863H · Destroyed
  > According to the plt, as he was lining up for his 3rd pass, he noticed a drop in manifold pressure & loss of power. There was no response to throttle movements. After 2 attempted to start the eng, he dumped his load in an effort to complete a turn to a clear…
- [NTSB MKC83LA097](https://openairdocs.org/ntsb/MKC83LA097.md): Piper PA-25-235 · Grenola, KS · Accident · No injuries · Limited investigation · Final report · Apr 29, 1983 · N8624L · Substantial damage
  > While spraying liquid fertilizer, the plt noticed that the fuel indication was dropping rapidly. He stated that he tried to return to the departure point, but was unable. When the engine lost power, he jettisoned the remainder of his load & landed in a…
- [NTSB ANC83LA076](https://openairdocs.org/ntsb/ANC83LA076.md): Hughes 500D · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Apr 29, 1983 · N58229 · Substantial damage
  > The helicopter skid contacted the ground during a hovering turn for landing and rolled the helicopter over on its right side. The pilot had made an approach for landing to a 10 foot hover and then lost sight of his reference point in fresh snow picked up by…
- [NTSB ATL83FA172](https://openairdocs.org/ntsb/ATL83FA172.md): Grumman G-164A · Albany, GA · Accident · Minor injuries · Field investigation · Final report · Apr 28, 1983 · N406Y · Substantial damage
  > The plt was on an instructional flt in aerial application. After completing a simulated swath run, he entered a turn-around maneuver. During the turn, the engine reportedly quit without any warning & the prop stopped turning. During a forced landing, the plt…
- [NTSB MKC83LA096](https://openairdocs.org/ntsb/MKC83LA096.md): Piper J3C-65 · Minatare, NE · Accident · No injuries · Limited investigation · Final report · Apr 27, 1983 · N23472 · Substantial damage
  > The plt reported that he was making a low pass to look over a possible landing area, when he allowed the acft to inadvertently touch down on soft soil beside the strip. The acft bounced, then landed hard and the main gear collapsed.
- [NTSB CHI83FU001](https://openairdocs.org/ntsb/CHI83FU001.md): Airmass Sunburst B · Norwalk, OH · Accident · 1 fatal · Final report · Apr 27, 1983 · UNREG · Destroyed
  > The ultralight made several low altitude turns over the area and in heading for an open field several 35 ft trees had tobe cleared. Clearance of the trees was estimated by witnesses as 5 ft or less. The acft went out of control in a left turn beyond the trees…
- [NTSB ATL83FA171](https://openairdocs.org/ntsb/ATL83FA171.md): Boeing A75N1 · Kennesaw, GA · Accident · No injuries · Field investigation · Final report · Apr 27, 1983 · N74189 · Substantial damage
  > While over a wooded area at 800 ft AGL the eng failed. The plt was unable to reach a suitable landing site before contacting the ground on an embankment below the elevation of a nearby road. The acft struck a telephone cable prior to touchdown. The #4 conrod…
- [NTSB CHI83LA187](https://openairdocs.org/ntsb/CHI83LA187.md): Tuk Gregory Quickie Q-2 · Ann Arbor, MI · Accident · No injuries · Limited investigation · Final report · Apr 26, 1983 · N128KB · Substantial damage
  > The home built acft was on its 1st test flt. According to the plt, the throttle became bound when he attempted to add power after checking the stall characteristics. Reportedly, the eng lost power at about this time when a rapid throttle movement was made.…
- [NTSB ATL83LA170](https://openairdocs.org/ntsb/ATL83LA170.md): Cessna A-188B · New Hope, AL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1983 · N4874R · Substantial damage
  > The acft struck powerlines and crashed during an emergency landing after a loss of power while spraying on an aerial application mission. The plt stated that while spraying he noticed oil beginning to cover the windshield. He had begun aclimb and dumped the…
- [NTSB SEA83FA089](https://openairdocs.org/ntsb/SEA83FA089.md): Piper PA-28-140 · Lebanon, OR · Accident · 2 fatal · Field investigation · Final report · Apr 24, 1983 · N95341 · Destroyed
  > Several witnesses observed the plt making repeated low passes over the rwy. On the last pass, the acft entered a steep climb, fell off on one wing, then dove toward the ground. The plt started a pull-out, but the acft struck the ground before he recovered.…
- [NTSB ANC83FAA06](https://openairdocs.org/ntsb/ANC83FAA06.md): Piper PA-28-180 · Nome, AK · Accident · 1 fatal · Final report · Apr 24, 1983 · N7346W · Destroyed
  > At 1205 bdt, the plt reported departing rwy 20 on an IFR flt. At that time, the bases of the clouds were reported to be at aprx 600 to 700 ft with the tops at 3500 ft & another cloud layer was above that. At aprx 1207, the acft crashed on the arpt boundry,…
- [NTSB DEN83LA103](https://openairdocs.org/ntsb/DEN83LA103.md): Cessna 172 · Leadville, CO · Accident · No injuries · Limited investigation · Final report · Apr 23, 1983 · N4609J · Substantial damage
  > The acft collided with snow covered rising terrain when flt was attempted through a canyon pass. The plt said he could see that the terrain could not be cleared so he was trying to turn around to fly out. The acft stalled in the turn and mushed into the snow.…
- [NTSB ATL83LA168](https://openairdocs.org/ntsb/ATL83LA168.md): Grumman G-164B · New Hope, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1983 · N6756Q · Substantial damage
  > The acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…
- [NTSB CHI83LA170](https://openairdocs.org/ntsb/CHI83LA170.md): Piper PA-28-180 · Rice Lake, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1983 · N1491T · Substantial damage
  > The acft hit a ditch and nosed over during a forced landing after the engine quit. The plt was on a cross country and had landed enroute 3 times without refueling. With the assistance of eau claire fss he overflew Rice Lake arpt but could not find it. The…
- [NTSB ATL83LA165](https://openairdocs.org/ntsb/ATL83LA165.md): Grumman G-164A · Adams, TN · Accident · No injuries · Limited investigation · Final report · Apr 19, 1983 · N6618 · Substantial damage
  > The acft nosed over during a forced landing after a power loss. The plt stated he made two swath runs when the acft lost power. Unable to maintain altitude, he dumped the load and prepared for a landing. The landing field was newlyplowed, wet and the acft dug…
- [NTSB FTW83FA194](https://openairdocs.org/ntsb/FTW83FA194.md): Logan Steen Skybolt · Greenville, TX · Accident · Serious injuries · Field investigation · Final report · Apr 18, 1983 · N5NL · Destroyed
  > The acft collided with trees after the plt attempted an aerobatic maneuver at low alt. Witnesses said they observed the acft make a low pass over a house just before the accident. Then the acft started an aerobatic maneuver from 200 ft AGL.a corporate plt…
- [NTSB LAX83LA180](https://openairdocs.org/ntsb/LAX83LA180.md): Hughes 269A · Lindsay, CA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N8775F · Substantial damage
  > The plt was rounding up cattle for a bbq. One of the steer in the herd charged the helicopter & struck its skid. The main rotor deflected & severed the tail boom. The plt lost control of the acft which impacted the ground & rolled over.

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

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

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