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

## Cases, newest first

- [NTSB MIA83LA161](https://openairdocs.org/ntsb/MIA83LA161.md): Cessna 172P · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N64079 · Substantial damage
  > The plt reported that he descended to aprx 50 ft AGL to demonstrate flt at low altitude to his passengers. While flying over a pasture at this altitude, the acft struck a pine tree, damaging the right wing. The plt experienced no control problems & returned…
- [NTSB LAX83LA291](https://openairdocs.org/ntsb/LAX83LA291.md): Bellanca 17-31A · Ducor, CA · Accident · 1 fatal · Limited investigation · Final report · Jun 18, 1983 · N8838V · Destroyed
  > The acft crashed into the side of a hill at 1900 feet MSL while on a photographic mission. The top of the mountain that was struck is 2412 feet MSL. The pilot was fatally injured in the crash and ground fire following impact. According to his secretary he was…
- [NTSB LAX83FVA03](https://openairdocs.org/ntsb/LAX83FVA03.md): Rockwell S2R · Corcoran, CA · Accident · No injuries · Final report · Jun 18, 1983 · N8435V · Substantial damage
  > The pilot reported that during his last spraying run he lost left rudder pedal control. He maintained control of the acft in the air but during landing he lost control due to the loss of the left rudder/brake pedal. The acft veered off the right side of the…
- [NTSB ATL83IA234](https://openairdocs.org/ntsb/ATL83IA234.md): Cessna 177RG · Ozark, AL · Incident · No injuries · Incident investigation · Final report · Jun 18, 1983 · N7515V · Minor damage
  > While in cruise flight the engine failed to respond to throttle movement due to the throttle linkage being loose. Forced landing was made to a pasture.
- [NTSB CHI83LA268](https://openairdocs.org/ntsb/CHI83LA268.md): Homebuilt Baby Great Lakes · Lebanon, IN · Accident · No injuries · Limited investigation · Final report · Jun 17, 1983 · N35JR · Substantial damage
  > The acft landing gear collapsed and the acft nosed over after the engine quit due to fuel starvation. The engine lost power in a steep climb of at least a 45 deg angle and could not be restarted. The fuel flows to the engine by gravity. In a steep climb the…
- [NTSB FTW83FA288](https://openairdocs.org/ntsb/FTW83FA288.md): Rotec Rally III · Seven Points, TX · Accident · Serious injuries · Field investigation · Final report · Jun 16, 1983 · N148RE · Destroyed
  > Reportedly, the plt had previously flown in a Rotec ralley iii ultralight, but handled the controls for only a few minutes. After assembling this ultralight, N148RE, from a kit, he made the necessary ground checks & preflt inspection, then took off on the 1st…
- [NTSB ATL83LA233](https://openairdocs.org/ntsb/ATL83LA233.md): Piper J3-C65 · Toddville, MD · Accident · No injuries · Limited investigation · Final report · Jun 16, 1983 · N28019 · Substantial damage
  > The acft made an emergency landing while skidding after the aileron control jammed. The pilot in the rear seat and the owner in the front seat said that after a couple of steep turns the aileron control could not be moved. The acft was in a left wing down…
- [NTSB MKC83LA129](https://openairdocs.org/ntsb/MKC83LA129.md): Piper PA-25-235 · Puxico, MO · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N4813Y · Destroyed
  > The plt stated that while trimming a rice field he was watching his drift & when he looked forward he saw the transmission line but was too close to avoid the lines.
- [NTSB LAX83FU008](https://openairdocs.org/ntsb/LAX83FU008.md): Eipper Quicksilver MX · Rancho Cordova, CA · Accident · 1 fatal · Final report · Jun 15, 1983 · UNREG · Substantial damage
  > Just prior to the accident, the ultralight vehicle was observed maneuvering in the area. While maneuvering, it entered a nose high attitude, stalled & crashed in a steep dive. The wind was reported as variable at 5 gusting 12 KTS. A toxicological test of the…
- [NTSB CHI83FA258](https://openairdocs.org/ntsb/CHI83FA258.md): Cessna T210L · Porter Township, WI · Accident · 2 fatal · Field investigation · Final report · Jun 15, 1983 · N732CD · Destroyed
  > Both occupants were rated plts. The plt in the right front seat of the acft had applied for membership with the organization that owned the plane. He may have been receiving informal instruction in the operation of the acft. During flt, the acft was observed…
- [NTSB LAX83FUM07](https://openairdocs.org/ntsb/LAX83FUM07.md): Bell 47G-5 · Valley Center, CA · Accident · No injuries · Final report · Jun 14, 1983 · N2252W · Substantial damage
  > The acft was damaged during a forced landing following a power loss while engaged in aerial application. The pilot took off with 25 gallons of fuel which he said was usually enough for spraying 40-50 acres. This job was 19 acres but it was 10-12 miles away at…
- [NTSB LAX83FA287](https://openairdocs.org/ntsb/LAX83FA287.md): Bell 206B · Temecula, CA · Accident · Minor injuries · Field investigation · Final report · Jun 14, 1983 · N5754M · Substantial damage
  > The plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…
- [NTSB FTW83FA276](https://openairdocs.org/ntsb/FTW83FA276.md): Grumman AA1A · Lagrange, TX · Accident · 1 fatal · Field investigation · Final report · Jun 14, 1983 · N6338L · Destroyed
  > Witnesses in six separate locations around the town reported the acft performing low altitude aerobatic maneuvers & buzzing recreational areas prior to the accident. The acft was subsequently observed doing 'roller-coaster' or figure-8 maneuvers, stall & spin…
- [NTSB NYC83FHM02](https://openairdocs.org/ntsb/NYC83FHM02.md): Dial-Thorp T-18 · Morristown, NJ · Accident · 1 fatal · Final report · Jun 12, 1983 · N11BD · Destroyed
  > The plt had been active in organizing an air show, but was not considered a participant. However, his home built acft was on static display. On the 2nd day of the show, the chairman of the event gave him permission to do a fly-by. Subsequently, he initiated a…
- [NTSB MKC83FA128](https://openairdocs.org/ntsb/MKC83FA128.md): Beech J35 · Knoxville, IA · Accident · 4 fatal · Field investigation · Final report · Jun 12, 1983 · N3054C · Destroyed
  > The acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…
- [NTSB CHI83FU004](https://openairdocs.org/ntsb/CHI83FU004.md): Para-Sail Glider · Battle Creek, WI · Accident · Serious injuries · Final report · Jun 12, 1983 · UNREG · Substantial damage
  > The ultralight vehicle was observed flying low over a golf course. As it approached a tall tree, witnesses heard the addition of power. However, a wing hit the tree & the ultralight spiraled down & impacted the ground. The plt did not possess an FAA plt…
- [NTSB CHI83LA250](https://openairdocs.org/ntsb/CHI83LA250.md): Bell 47G5A · Detroit, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1983 · N7995J · Substantial damage
  > The pilot stated that he was assigned a community affairs project to fly a 'ronald mcdonald' clown to a nearby restaurant for a magic show. During the hover in the landing area the rotor blades struck a light pole. The helicopter pitched forward and landed on…
- [NTSB DEN83LA137](https://openairdocs.org/ntsb/DEN83LA137.md): Cessna A188B · Saco, MT · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 1983 · N4812Q · Substantial damage
  > The acft collided with telephone lines during an aerial application run. The pilot's son reported that the acft was pulling up at the end of a spray run when the wires were hit. Most of the wires in this area are underground however thewires at the end of…
- [NTSB ATL83FKG08](https://openairdocs.org/ntsb/ATL83FKG08.md): Cessna A188B · Ashburn, GA · Accident · Minor injuries · Final report · Jun 10, 1983 · N21830 · Destroyed
  > The plt reported that after the 4th pass, he had just completed a turn over a wooded area when the engine power went to idle RPM. He was forced to land in the trees, adjacent to the field that he was spraying. No preimpact, mechanical failure was found. The…
- [NTSB FTW83FA270](https://openairdocs.org/ntsb/FTW83FA270.md): Air Tractor AT-400A · Lane City, TX · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1983 · N31619 · Destroyed
  > The plt was leading a flt of 2 acft on an aerial application mission. The plt of the 2nd acft stated that at the end of a swath run, the lead acft pulled up to an almost vertical attitude & to an alt of between 300 & 400 ft AGL. At that time, the plane…
- [NTSB DEN83LA136](https://openairdocs.org/ntsb/DEN83LA136.md): Air Tractor AT-301 · Conrad, MT · Accident · No injuries · Limited investigation · Final report · Jun 9, 1983 · N23069 · Substantial damage
  > The acft landed hard and collapsed the right main landing gear during a forced landing after fuel exhaustion. During a landing to reload the pilot had handled the herbicide on-loading and a ground crewman was loading the acft fuel. The supply of 80/87 octane…
- [NTSB NYC83FHD01](https://openairdocs.org/ntsb/NYC83FHD01.md): Hiller UH-12D · Bricktown, NJ · Accident · No injuries · Final report · Jun 8, 1983 · N67155 · Substantial damage
  > The plt reported an erratic RPM drop & a partial loss of power during a swath run. This occurred when the helicopter was aprx 10 ft above trees at aprx 40 KTS. The acft began losing airspeed & altitude. During an emergency landing, the tail rotor & main rotor…
- [NTSB MIA83FA158](https://openairdocs.org/ntsb/MIA83FA158.md): Piper PA-23-250 · Fort Lauderdale, FL · Accident · 1 fatal · Field investigation · Final report · Jun 8, 1983 · N619MP · Destroyed
  > During flt, the acft was observed flying from west to east across the beach & out over the ocean. Witnesses reported that over the ocean, the sky was dark & thunderstorms were approaching with heavy lightning. As the acft crossed the beach, a distinct eng…
- [NTSB LAX83FA276](https://openairdocs.org/ntsb/LAX83FA276.md): Piper PA-28-181 · El Cajon, CA · Accident · 2 fatal · Field investigation · Final report · Jun 8, 1983 · N8318T · Destroyed
  > The plt was first wx briefed at 0916 for a flt to catalina island & on to san jose. VFR flt was not recommended. Subsequently the plt called fss four more times, the final call at 1402 during which he requested & received the wx for montgomery & gillespie…
- [NTSB CHI83LA245](https://openairdocs.org/ntsb/CHI83LA245.md): Aeronca 7ECA · Wentworth, WI · Accident · No injuries · Limited investigation · Final report · Jun 8, 1983 · N2563F · Substantial damage
  > The CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…
- [NTSB ATL83LA220](https://openairdocs.org/ntsb/ATL83LA220.md): Texas Helicopter OH-13H/M74A · Ruleville, MS · Accident · No injuries · Limited investigation · Final report · Jun 8, 1983 · N1001G · Substantial damage
  > The plt reported that the engine lost power during a swath run. A run-on landing was made. Prior to stopping, the right skid & right spray boom hit a rice level, and subsequenily, the main rotor blade chopped the tail boom. No preimpact failures were found.
- [NTSB LAX83FA267](https://openairdocs.org/ntsb/LAX83FA267.md): Cessna 152 · Mesa, AZ · Accident · 1 fatal · Field investigation · Final report · Jun 7, 1983 · N89894 · Destroyed
  > Prior to the flt, the plt reported that he was 'going to do some airwork.' About 1.2 hrs after takeoff, witnesses saw the acft flying eastbound at an estimated altitude of between 2000 & 3500 ft AGL. A witness with about 40 hrs of aeronautical experience…
- [NTSB CHI83LA243](https://openairdocs.org/ntsb/CHI83LA243.md): Piper PA-25 · Roseau, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1983 · N7221L · Substantial damage
  > During an aerial application flt, the acft collided with power lines during a pull-up from a swath run. The plt reported no preimpact malfunctions.
- [NTSB SEA83FYK04](https://openairdocs.org/ntsb/SEA83FYK04.md): Homebuilt Christen Eagle II · Bend, OR · Accident · 1 fatal · Final report · Jun 5, 1983 · N4GT · Destroyed
  > Upon completion of his routine during an airshow, the plt stated to the show announcer that he would do a low pass down the rwy followed by a vertical climb to a hammerhead stall & then into a lomcevak aerobatic maneuver. This maneuver is aclimbing outside…
- [NTSB LAX83FUM06](https://openairdocs.org/ntsb/LAX83FUM06.md): Cessna 172RG · San Clemente, CA · Accident · Serious injuries · Final report · Jun 5, 1983 · N4789R · Destroyed
  > The acft crashed on San Clemente island during a fish spotting flt on a dark night. These flts are usually flown at an alt of 1000-2000 ft AGL. A navy witness on the accident island said the ceiling was zero and the visibility about 200 yards at the accident…
- [NTSB NYC83LA132](https://openairdocs.org/ntsb/NYC83LA132.md): Mooney M20B · Lakeville, MA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N74788 · Substantial damage
  > The acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…
- [NTSB FTW83LA266](https://openairdocs.org/ntsb/FTW83LA266.md): Piper PA-36-285 · Anson, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 4, 1983 · N57751 · Destroyed
  > According to the plt, while in flt, the eng was running smooth, but seemed to lack power. He checked the instruments & noted that the manifold pressure & eng RPM were normal. Then while at aprx 60 ft AGL, all power was lost. Subsequently, the acft crashed on…
- [NTSB FTW83FA261](https://openairdocs.org/ntsb/FTW83FA261.md): Piper PA-25-235 · Omega, OK · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1983 · N6551Z · Destroyed
  > The plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…
- [NTSB DEN83FTE09](https://openairdocs.org/ntsb/DEN83FTE09.md): Link-Johnson-Chessman HP-16 · Eldorado Sprgs., CO · Accident · 1 fatal · Final report · Jun 4, 1983 · N9025N · Substantial damage
  > The glider crashed into a mountain while maneuvering during VMC weather. The pilot was fatally injured. The glider impacted the face of bear peak mountain near the 7900 ft. level. The fuselage was crushed the wings separated and the pilot, who had undone his…
- [NTSB CHI83LA238](https://openairdocs.org/ntsb/CHI83LA238.md): Cessna 305A · Park Forrest, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1983 · N5258G · Substantial damage
  > The acft was being flown on a routine flight check after having completed an annual inspection. The plt stated that after takeoff he climbed to 800 ft, turned downwind, extended flaps to 30 deg, slowed to 70-80, & intended to make a pass over the field to…
- [NTSB NYC83FA130](https://openairdocs.org/ntsb/NYC83FA130.md): North American AT-6C · Westfield, MA · Accident · 1 fatal · Field investigation · Final report · Jun 3, 1983 · N5286N · Destroyed
  > The airline transport rated plt was on a low level, aerobatic waiver, competency check flt. He was scheduled to demonstrate a loop, an aileron roll, a split-s, an immelmann, a barrel roll & a 4-point hesitation roll. The minimum alt for these maneuvers was to…
- [NTSB ATL83LA210](https://openairdocs.org/ntsb/ATL83LA210.md): Grumman G-164 · Alligator, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1983 · N701Y · Substantial damage
  > The acft collided with the terrain during an turn to reverse direction on an aerial application flt. The plt said he encountered a wind shear during the turn and was unable to arrest the descent. The acft impacted on the main gear and was substantially…
- [NTSB NYC83FNC04](https://openairdocs.org/ntsb/NYC83FNC04.md): Mcdonald Steen Skybolt · Milan, NH · Accident · Serious injuries · Final report · Jun 2, 1983 · N98JP · Substantial damage
  > The purpose of the flt was preparation of an act for some planned air shows. The pilot maneuvered the acft into an inverted spin at an alt of 2000 AGL. After 3 revolutions of the spin he was unable to recover and the acft impacted the ground inverted.
- [NTSB DEN83LA132](https://openairdocs.org/ntsb/DEN83LA132.md): Bell 47G3-B1 · Devils Tower, WY · Accident · No injuries · Limited investigation · Final report · Jun 1, 1983 · N80711 · Substantial damage
  > The acft crash landed in trees after the engine lost power. The helicopter was being used in aerial application at the time of the accident. The operation was being done in 8 minute segments. Every 8 minutes the helicopter landed for a reload of herbicide. At…
- [NTSB SEA83FU002](https://openairdocs.org/ntsb/SEA83FU002.md): Eipper Quicksilver MX · Sumner, WA · Accident · Serious injuries · Final report · May 29, 1983 · UNREG · Substantial damage
  > The acft collided with a tree and crashed into a parking lot when the engine quit during a low pass maneuver near a memorial day crowd in a park. The ultralight acft was destroyed and the pilot was seriously injured. Witnesses describedthe acft doing…
- [NTSB DEN83LA127](https://openairdocs.org/ntsb/DEN83LA127.md): Piper PA-18A-150 · Hilger, MT · Accident · Serious injuries · Limited investigation · Final report · May 29, 1983 · N3380Z · Substantial damage
  > The pilot stated that he and another pilot were spraying a field in tandem formation at an alt of about 10 feet AGL. He was about 1/2 mile behind the lead acft and slightly to the left. After making a swath run he pulled up to about 100 ft AGL and started…
- [NTSB DEN83FTM04](https://openairdocs.org/ntsb/DEN83FTM04.md): Piper PA-25-235 · Delta, UT · Accident · Minor injuries · Final report · May 29, 1983 · N6651Z · Substantial damage
  > The acft collided with two power lines on a clean up swath run. The acft rolled inverted and struck the ground. The field being sprayed was bordered on the north by highly visible wires. The wires that ran along the east side were not so visible. There was…
- [NTSB FTW83LA256](https://openairdocs.org/ntsb/FTW83LA256.md): Aeronca 7AC · El Reno, OK · Accident · No injuries · Limited investigation · Final report · May 28, 1983 · N81978 · Substantial damage
  > The acft nosed over during a forced landing after the engine quit. The plt stated that when about 4 miles from the arpt at 200 ft the engine began losing power with the dropping from 2000 to 1500 RPM. He also stated that application of carburetor heat did not…
- [NTSB FTW83FA251](https://openairdocs.org/ntsb/FTW83FA251.md): Enstrom 280C · Opelousas, LA · Accident · 1 fatal · Field investigation · Final report · May 28, 1983 · N56932 · Substantial damage
  > The helicopter was observed to lift off to a hover and began an erratic hover. The acft pitched up and spun throwing theplt out and fatally injuring him. Witnesses said they did not know the plt was going to fly the helicopter. The opinion was that it was to…
- [NTSB FTW83FA250](https://openairdocs.org/ntsb/FTW83FA250.md): Evans VP-1 · Friendswood, TX · Accident · Serious injuries · Field investigation · Final report · May 28, 1983 · N2VC · Destroyed
  > The acft collided with the ground during a tight steep turn at low (100 ft) alt. Witnesses reported that the eng was running well and that after flying the length of the rwy at low alt the plt made a steep left turn and crashed. Witnesses said the plt had…
- [NTSB ANC83LA085](https://openairdocs.org/ntsb/ANC83LA085.md): Piper PA-12 · Glennallen, AK · Accident · 1 fatal · Limited investigation · Final report · May 28, 1983 · N3742M · Substantial damage
  > Reportedly, the plt & passenger had worked a long day before going to their respective homes to attend household chores. Later, they met, and reportedly, they consumed food & beer. Eventually, they arrived at the location of where the plt's plane was parked.…
- [NTSB SEA83LA110](https://openairdocs.org/ntsb/SEA83LA110.md): Boeing Stearman A75N1 · Turner, WA · Accident · No injuries · Limited investigation · Final report · May 27, 1983 · N56426 · Substantial damage
  > The acft nosed over during an emergency landing after an engine failure. The pilot stated that he had almost completed his spraying, when during a turn-around, the engine started to backfire. He dumped the remaining load and reduced power. The engine…
- [NTSB MIA83LA147](https://openairdocs.org/ntsb/MIA83LA147.md): Piper PA-25-235 · Jay, FL · Accident · Minor injuries · Limited investigation · Final report · May 26, 1983 · N6770Z · Destroyed
  > The acft collided with a tree while maneuvering in an aerial application operation. The pilot stated that while completing a run,turbulence was encountered which he believes was related to a 20 acre field being burned nearby. The acft descended about 25 feet…
- [NTSB LAX83LA249](https://openairdocs.org/ntsb/LAX83LA249.md): Grumman-Schweizer G-164C · Live Oak, CA · Accident · 1 fatal · Limited investigation · Final report · May 26, 1983 · N6627K · Destroyed
  > The plt was on a flight to seed a rice field with 2 sets of power lines located near its west edge. The plt had seeded the field many times before, & reportedly, was familiar with the area. During the 1st swath run, which was from east to west, the acft…
- [NTSB MKC83FA114](https://openairdocs.org/ntsb/MKC83FA114.md): Hiller UH-12E · Troy, KS · Accident · Serious injuries · Field investigation · Final report · May 24, 1983 · N3GK · Destroyed
  > The acft collided with a powerline while the pilot was locating a field to spray at a later date. The pilot saw telephone lines and flew over them but hit the powerlines which were 20 feet higher. The skids caught the wires and the helicopter nosed down,…

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

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

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