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

## Cases, newest first

- [NTSB MIA84LA205](https://openairdocs.org/ntsb/MIA84LA205.md): Piper PA-25-235 · Bonifay, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N9860P · Destroyed
  > While turning after a swath run the control stick came loose and the acft impacted the ground. Inspection revealed the bolt used to secure the control stick failed due to corrosion.
- [NTSB FTW84LA314](https://openairdocs.org/ntsb/FTW84LA314.md): Aerospatiale AS-355F · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N240US · Substantial damage
  > The helicopter encountered turbulence and downdrafts during landing. The acft impacted the asphalt ramp slightly nose low and bounced 2-3 ft into the air. The nose dipped more and full aft cyclic was applied. The main rotor blades hit the ground and the acft…
- [NTSB ATL84FA225](https://openairdocs.org/ntsb/ATL84FA225.md): de Havilland DHC-1B · Greenwood, MS · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1984 · N27JD · Destroyed
  > Witnesses observed the acft become airborne and accelerate low over the rwy. At the end of the private strip the acft entered a 30 to 40 deg nose high attitude climbing to aprx 1,000 ft. the acft then rolled right as the nose dropped and continued to roll…
- [NTSB MKC84LA223](https://openairdocs.org/ntsb/MKC84LA223.md): Piper PA-25-235 · Pollard, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1984 · N8815L · Destroyed
  > The plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.
- [NTSB MKC84LA222](https://openairdocs.org/ntsb/MKC84LA222.md): Grumman G-164A · Stanford, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1984 · N8914H · Substantial damage
  > When the pilot made his first swath run he flew over a set of wires, on the return run he went under the wires. The pilot said he hit his own prop wash and rolled enough for the wing tip to contact the wire.
- [NTSB MKC84FCD01](https://openairdocs.org/ntsb/MKC84FCD01.md): Cessna A188B · Hesper, IA · Accident · Serious injuries · Final report · Jul 18, 1984 · N84494 · Destroyed
  > The acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…
- [NTSB MKC84LA211](https://openairdocs.org/ntsb/MKC84LA211.md): Grumman G-164B · Roe, AR · Accident · No injuries · Limited investigation · Final report · Jul 17, 1984 · N8365K · Substantial damage
  > As a result of a supercharger failure, a partial power loss was experienced during a swath run. During the landing roll after a forced landing, the acft nosed over & came to rest inverted. An eng teardown revealed that both supercharger bearings had failed…
- [NTSB LAX84LA399](https://openairdocs.org/ntsb/LAX84LA399.md): Piper PA-24-250 · Folsom, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1984 · N5752P · Substantial damage
  > The acft was observed flying down a river at a low altitude toward the main body of a lake. The acft impacted a 12 kv power line. The plt stated that he did not see the wires until an instant before impact.
- [NTSB SEA84LA174](https://openairdocs.org/ntsb/SEA84LA174.md): Hiller UH-12E · Redmond, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1984 · N1043L · Substantial damage
  > The acft collided with the ground after a in-flt main rotor blade separation during an aerial application flt. Inspection of the fracture surface of the failed blade revealed characteristics consistant with the high stress, low cycle fatigue. Lab findings…
- [NTSB MKC84LA219](https://openairdocs.org/ntsb/MKC84LA219.md): Piper PA-25-235 · Chadron, NE · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N6765Z · Substantial damage
  > Plt stated that while manuvering to avoid transmission wires on a small incline, his rolling pull-up was excessive, causing airspeed decay and a stall/mush. The empennage failed to clear the power lines during the mush. Acft then collided with terrain.
- [NTSB MKC84FA218](https://openairdocs.org/ntsb/MKC84FA218.md): Eagle DW1 · Kimball, NE · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1984 · N8815S · Destroyed
  > The acft collided with a microwave tower 158 ft AGL while the plt was making a smoke trail to test the wind. As the plt was seen to look back along his smoke path, the acft collided with the tower. The cables supporting the twr & the twr destroyed the acft…
- [NTSB LAX84FA396](https://openairdocs.org/ntsb/LAX84FA396.md): Travel Air 4000 · San Miguel, CA · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1984 · N8719 · Destroyed
  > Ground witnesses reported that this & another acft were engaged in a mock 'dogfight'; both acft were circling the accident area between 500-800 ft AGL & neither acft was negotiating any aerobatic maneuvers. The plt stated that during a descending 30 deg right…
- [NTSB MKC84LA215](https://openairdocs.org/ntsb/MKC84LA215.md): Cessna 172H · Marvell, AR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1984 · N8820Z · Substantial damage
  > The acft collided with telephone lines as the plt was making a low pass over the passengers place of business. The plt said he did not know the lines were there when his passenger asked for the low pass. The acft stalled and contacted the ground on the…
- [NTSB LAX84LA394](https://openairdocs.org/ntsb/LAX84LA394.md): Experimental Amateur Built OWL Racer · Oroville, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1984 · N711BS · Substantial damage
  > The Experimental/amateur built aircraft had just turned inbound for an exhibition race run when it experienced severe vibrations as the pilot applied full power. He headed for the runway and found that he could not control the engine with the throttle. He was…
- [NTSB LAX84FA395](https://openairdocs.org/ntsb/LAX84FA395.md): Hiller UH-12E · Orcutt, CA · Accident · No injuries · Field investigation · Final report · Jul 15, 1984 · N4030A · Substantial damage
  > Maintenance had just been performed & the crew were beginning a test flt to check the tracking of the main rotor blades. While the plt was hover taxiing, he lost collective control & rotor RPM decreased. However, he was able to make a roll-on landing, but the…
- [NTSB DEN84FA222](https://openairdocs.org/ntsb/DEN84FA222.md): North American P-51D · Carbondale, CO · Accident · 2 fatal · Field investigation · Final report · Jul 15, 1984 · N5449V · Destroyed
  > The plt was performing aerobatic maneuvers in a P-51D that had been modified for racing & exhibition. Witnesses near the accident site stated that the acft had just completed several aerobatic maneuvers before it began a vertical climb. The climb was…
- [NTSB MKC84LA217](https://openairdocs.org/ntsb/MKC84LA217.md): Grumman G-164A · Osceola, AR · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N7928 · Substantial damage
  > The acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.
- [NTSB MKC84LA214](https://openairdocs.org/ntsb/MKC84LA214.md): Grumman G-164B · Brule, NE · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N6825K · Substantial damage
  > According to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.
- [NTSB LAX84FA390](https://openairdocs.org/ntsb/LAX84FA390.md): Cessna T188C · Brawley, CA · Accident · Serious injuries · Field investigation · Final report · Jul 13, 1984 · N9951J · Destroyed
  > The acft crashed shortly after takeoff from a dirt strip. The plt said the acft was 'over-gross' and that it would not climb. The plt had used full flaps for takeoff and when the acft would not climb he reached for the dump or load jettison handle and grabbed…
- [NTSB CHI84FA290](https://openairdocs.org/ntsb/CHI84FA290.md): Jerry D. Fish Drifter · Columbus, IN · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1984 · N5150J · Destroyed
  > During flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…
- [NTSB CHI84FA289](https://openairdocs.org/ntsb/CHI84FA289.md): Aero Commander Callair A-9 · Pullman, MI · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1984 · N7714V · Destroyed
  > The acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…
- [NTSB SEA84FA172](https://openairdocs.org/ntsb/SEA84FA172.md): Schempp-Hirth Ventus A · Ephrata, WA · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1984 · N17KS · 2 aircraft · Minor damage
  > A 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of…
- [NTSB MKC84LA213](https://openairdocs.org/ntsb/MKC84LA213.md): Grumman G-164A · Gillette, AR · Accident · No injuries · Limited investigation · Final report · Jul 12, 1984 · N9785 · Substantial damage
  > During swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…
- [NTSB DEN84FA219](https://openairdocs.org/ntsb/DEN84FA219.md): Piper PA-25-235 · Peetz, CO · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1984 · N6484Z · Destroyed
  > Plt had completed spraying around farm buildings for insect control. On first pass in crop area, the acft was observed to pull up over pwr lines at end of swath run but collided with overhead ground wire at top of multi- wire array. Acft then collided with…
- [NTSB MKC84LA209](https://openairdocs.org/ntsb/MKC84LA209.md): Grumman G-164B · West Memphis, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1984 · N8109K · Destroyed
  > The acft nosed over during an off arpt forced landing following an engine failure. During post accident examination the acft was found to have a cracked #7 cylinder.
- [NTSB LAX84FU029](https://openairdocs.org/ntsb/LAX84FU029.md): Ultralight Soaring Wizard J-3B · Lake Elsinore, CA · Accident · 1 fatal · Final report · Jul 11, 1984 · UNREG · Destroyed
  > The Ultralight was observed by witnesses to be circling, then performed what was described as a 'barrel-type' maneuver. During the maneuver, the right wing collapsed and the acft spiraled to the ground in an uncontrolled descent. During theinvestigation of…
- [NTSB CHI84LA288](https://openairdocs.org/ntsb/CHI84LA288.md): Rotorway Executive · Cambridge, WI · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N2993P · Destroyed
  > The fixed wing plt who was not qualified to fly rotorcraft tried to hover his homebuilt acft. After failing the 1st timehe tried again and this time the acft rolled over and burned. The plt said the roll over occurred so fast he did not have time to act.
- [NTSB DEN84LA216](https://openairdocs.org/ntsb/DEN84LA216.md): Bell 206B · Salina, UT · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N878LC · Substantial damage
  > The acft crashed during takeoff. The plt said he was hovering after takeoff at about 20 ft AGL when he noticed a long line draped over the rt skid. He said he thought he could dislodge it. While maneuvring to attempt this, the helicopter rolled to the rt and…
- [NTSB MKC84LA210](https://openairdocs.org/ntsb/MKC84LA210.md): Grumman G164B · Mc Gehee, AR · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N8222K · Substantial damage
  > The acft was engaged in an aerial application flt when the eng lost power. The plt made a forced landing in a bean field. During the landing roll, the acft struck a levee that was obscured by high vegetation & nosed over. A post-accident investigation…
- [NTSB DEN84LA214](https://openairdocs.org/ntsb/DEN84LA214.md): Piper PA-28 · Empire, CO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N9638W · Substantial damage
  > Plt stated, 'departed arapahoe, planning on selecting best mountain pass versus altitude achieved. At 10,500, decided pass I was entering would be too difficult & began maneuvering for 180 turn. Severe downdraft occurred & altitude & airspeed lost precluded a…
- [NTSB MKC84LA206](https://openairdocs.org/ntsb/MKC84LA206.md): Brantly Helicopter B-2 · Bennington, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1984 · N4999C · Substantial damage
  > The student plt stated that after lifting to a hover on her first solo flt, she made two 180 degree hovering turns. She said that the helicopter entered a violent lateral vibration and descended to the ground. Examination of the wreckage did not disclose any…
- [NTSB CHI84FA282](https://openairdocs.org/ntsb/CHI84FA282.md): Cessna 205 · Oak Brook, IL · Accident · Serious injuries · Field investigation · Final report · Jul 8, 1984 · N8377Z · Destroyed
  > Pilot and passengers here circling over a golf tournanent taking photographs when the engine quit. The pilot made an emergency landing on an adjacent golf course and the aircraft struck a tree during the rollout. Post accident exam of the eng revealed no…
- [NTSB ATL84FA216](https://openairdocs.org/ntsb/ATL84FA216.md): Cessna 150J · Terry Town, GA · Accident · 1 fatal · Field investigation · Final report · Jul 8, 1984 · N50776 · Substantial damage
  > Witnesses observed the aircraft manuvering in the vicinity of the accident site at about 100 ft AGL. A second low pass was executed, terminating with a sharp pull up to a near vertical attitude. The acft climbed to about 300 ft AGL, the nose tucked under and…
- [NTSB MKC84LU005](https://openairdocs.org/ntsb/MKC84LU005.md): UFM Easy Riser · Des Moines, IA · Accident · Serious injuries · Final report · Jul 7, 1984 · UNREG · Substantial damage
  > The ultralight was making turns at low alt when it stalled and spun into the ground. The plt was unable to recover before ground impact.
- [NTSB FTW84FA302](https://openairdocs.org/ntsb/FTW84FA302.md): Mooney M-18LA · New Iberia, LA · Accident · 1 fatal · Field investigation · Final report · Jul 7, 1984 · N4090 · Destroyed
  > A plt witness observed the acft in a 20 to 30 deg dive at high speed just prior to the accident. He reported that at an alt of about 1200 to 1300 ft, the acft began a pull-up. As the pull-up was started, the outboard portion of the acft's left wing folded…
- [NTSB DEN84LU007](https://openairdocs.org/ntsb/DEN84LU007.md): Eipper Quicksilver MXL · Granby, CO · Accident · 1 fatal · Final report · Jul 7, 1984 · UNREG · Destroyed
  > Reportedly, the plt was flying at low altitude over a lake & had to pull up to cross over a dam. After crossing the dam, he began to descend, but the ultralight vehicle collided with power lines on the down river side of the dam. The power lines were about…
- [NTSB ATL84LA217](https://openairdocs.org/ntsb/ATL84LA217.md): Cessna T188C · Glen Allen, MS · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1984 · N2803J · Destroyed
  > The plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.
- [NTSB NYC84FA233](https://openairdocs.org/ntsb/NYC84FA233.md): Grumman AA-5 · Woodstock, NY · Accident · 1 fatal · Field investigation · Final report · Jul 6, 1984 · N9519L · Destroyed
  > Acft was on a VFR personal flight. Witness on mountain slope heard sounds of approaching acft, observed brief glimpse of acft wheel and wing through cloud and fog about 100 ft away, at tree-top level. A few seconds later. Witness heard eng sound cease.…
- [NTSB FTW84LA301](https://openairdocs.org/ntsb/FTW84LA301.md): Piper PA-28-140 · Killian, LA · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 1984 · N33074 · Destroyed
  > The acft crashed while in a steep bank at low alt in VMC wx.a witness who knew the plt said he heard the acft approaching, went outside his house and saw the acft at about 200 ft AGL. The acft went into a turn and became almost inverted before colliding with…
- [NTSB MKC84FU004](https://openairdocs.org/ntsb/MKC84FU004.md): Amer. Aerolight Eagle 2 PLC · Millard, NE · Accident · Serious injuries · Final report · Jul 5, 1984 · UNREG · Substantial damage
  > The plt reported that after exchanging the canard elevator & readjusting the spoiler control teleflex cable rod end at the spoiler bellcrank, he took off on a test flt. After about 5 min of flt, the right spoiler failed to retract after it was used during a…
- [NTSB MIA84FA200](https://openairdocs.org/ntsb/MIA84FA200.md): Peter A. Yarger Skybolt · St. Augustine, FL · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1984 · N9722A · Substantial damage
  > During a turn after takeoff the plt reported the control stick suddenly 'snapped back' to the full nose up position. The acft was at about 300 ft AGL when it stalled. The pilot who was in the back seat was unable to recover before ground impact. After the…
- [NTSB NYC84LA230](https://openairdocs.org/ntsb/NYC84LA230.md): Piper PA-22-160 · Bargaintown, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1984 · N3040Z · Destroyed
  > The acft was on a banner tow mission. Plt dropped banner and initiated a pull-up manuever to go-around and return for a landing. As the plt pulled up, a downdraft was encountered at the end of the field. Plt initiated a right turn and acft continued sinking…
- [NTSB NYC84FGM05](https://openairdocs.org/ntsb/NYC84FGM05.md): Bell 47G-5 · Penn Run, PA · Accident · No injuries · Final report · Jul 4, 1984 · N1477W · Substantial damage
  > The plt was spraying a potatoe field with a lightly loaded helicopter when the eng failed. At that time, the helicopter was about 10 ft AGL in a slight right turn & at aprx 35 mph. The plt flared to stop the forward movement & landed, but the tail rotor…
- [NTSB CHI84LA279](https://openairdocs.org/ntsb/CHI84LA279.md): Bell 47G2 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1984 · CFISH · Destroyed
  > The acft landed in the Detroit river after the engine sputtered and the acft vibrated. The plt reduced pwr & collective and pushed the cyclic forward. The RPM reduced from 3000 to 2500 but the rotor and engine RPM remained married. The plt adjusted descent…
- [NTSB BFO84FU001](https://openairdocs.org/ntsb/BFO84FU001.md): Eipper Quicksilver MX · Elkton, MD · Accident · 1 fatal · Final report · Jul 4, 1984 · UNREG · Substantial damage
  > The ultralight pilot had been practicing maneuvers that weredescribed as whip stalls which were not taught or authorizedbecause of the excessive 'g' forces imposed. An instructor checked his machine and warned him of the dangers on the day of the accident.…
- [NTSB SEA84LA159](https://openairdocs.org/ntsb/SEA84LA159.md): Applebay Sailplanes Zuni II · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N22HL · 2 aircraft · Substantial damage
  > The two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail.
- [NTSB MKC84LA200](https://openairdocs.org/ntsb/MKC84LA200.md): Grumman G164A · Bernie, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1984 · N4796 · Substantial damage
  > Descending out of the procedure turn into a swath run the plt was unable to level the acft in time to avoid flying into the bean field. The acft nosed over on impact and caught fire. Density altitude was about 2,800 ft. acft gross weight was aprx 5,500…
- [NTSB MKC84FA197](https://openairdocs.org/ntsb/MKC84FA197.md): Piper PA-18-150 · Wright, AR · Accident · 1 fatal · Field investigation · Final report · Jul 3, 1984 · N4025 · Destroyed
  > During aerial application, the plt was making a left turn over high voltage power lines when the acft hit the cables, crashed & burned in a rice field. An exam revealed 2 wire marks & 2 electrical arc marks on the left wing along with wire marks on one of the…
- [NTSB CHI84LA274](https://openairdocs.org/ntsb/CHI84LA274.md): Hughes 269B · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N9487F · Substantial damage
  > The CFI stated that while practicing a pedal turn the student pilot suddenly applied back cylic causing the tail rotor to contact the ground. The main rotor then contacted the ground and the helicopter rolled over.
- [NTSB CHI84IA294](https://openairdocs.org/ntsb/CHI84IA294.md): Enstrom F-28A · Muncie, IN · Incident · No injuries · Incident investigation · Final report · Jul 3, 1984 · N13CM · Minor damage
  > According to the plt, he was in a 20 deg left bank with an airspeed of about 40 KTS when the helicopter began rotation to the right. He entered an autorotation & landed with a forward speed of about 5 KTS. An exam revealed that the tail rotor drive shaft had…

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

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

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