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

## Cases, newest first

- [NTSB LAX86FVD06](https://openairdocs.org/ntsb/LAX86FVD06.md): Callair A-9B · Lodi, CA · Accident · Minor injuries · Final report · Mar 8, 1986 · N7688V · Destroyed
  > Pilot was returning to Lodi airport after aerial application when the engine lost oil pressure. The engine seized, and a forced landing was made in a vineyard.
- [NTSB SEA86FA073](https://openairdocs.org/ntsb/SEA86FA073.md): Aerospatiale SE 318C · Siletz, OR · Accident · 1 fatal · Field investigation · Final report · Mar 7, 1986 · N4966 · Destroyed
  > The plt unsuccessfully attempted to lift a 1597 lb load of cedar blocks which would have placed the helicopter aprx 880 lbs over its max gross weight with an external load. The plt was setting the load down for ground personnel to unload some of the blocks…
- [NTSB FTW86LA041](https://openairdocs.org/ntsb/FTW86LA041.md): Hughes 369D · New Boston, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1986 · N58420 · Substantial damage
  > The pilot experienced a tail rotor drive shaft flexible coupling failure when he pulled collective pitch to come to a hover before landing. The helicopter entered an uncontrollable right spin. During his haste to get the helicopter on the ground the pilot…
- [NTSB ATL86MA087](https://openairdocs.org/ntsb/ATL86MA087.md): Piper PA-32-300 · Andalusia, AL · Accident · 1 fatal · Major investigation · Final report · Mar 7, 1986 · N1099X · Destroyed
  > The accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…
- [NTSB LAX86FVD07](https://openairdocs.org/ntsb/LAX86FVD07.md): Bell 47G-2 · Stockton, CA · Accident · No injuries · Final report · Mar 6, 1986 · N6727D · Destroyed
  > The pilot was making a slow pass and dragged one spray boom on the ground. Insufficient airspeed resulted in loss of control. Helicopter crashed.
- [NTSB LAX86FA131](https://openairdocs.org/ntsb/LAX86FA131.md): Piper PA-28-181 · Newport Beach, CA · Accident · 3 fatal · Field investigation · Final report · Mar 3, 1986 · N81918 · Destroyed
  > The acft was rprted to be on a dual, night recurrent, training flt. The student plt's wife rprtd that the flt instructor(CFI) & her husband had been drinking beer before they & the passenger (another student plt) departed on the flt. Ground witnesses observed…
- [NTSB ATL86FA084](https://openairdocs.org/ntsb/ATL86FA084.md): Bell B-214-B-1 · Bullard, GA · Accident · Minor injuries · Field investigation · Final report · Mar 3, 1986 · N114RM · Substantial damage
  > A helicopter involved in a logging operation was in process of lifting a log when crew reported a 'loud explosion' and a loss of power was experienced. An autorotative landing was accomplished and a small engine fire was extinguished. The 1st stage turbine…
- [NTSB LAX86FUG04](https://openairdocs.org/ntsb/LAX86FUG04.md): Rotorway Scorpion 133 · Corona, CA · Accident · No injuries · Final report · Mar 2, 1986 · UNREG · Destroyed
  > The plt stated he was 'running up the engine' after making some adjustments. The helicopter was tied down when the plt lifted off to a 5 to 6 ft hover. The helicopter tipped to the right, the main rotor blades contacted the terrain and the helicopter rolled…
- [NTSB FTW86LQG12](https://openairdocs.org/ntsb/FTW86LQG12.md): Piper PA-36-300 · Muleshoe, TX · Accident · No injuries · Final report · Feb 28, 1986 · N57878 · Substantial damage
  > The ag acft was climbing after a pass to clear power lines at the north end of the field. The main lndg gear contacted the top wire as the acft started leveling off. The wire did not break and the acft descended to ground impact. The lndg gear snapped off and…
- [NTSB LAX86LA231](https://openairdocs.org/ntsb/LAX86LA231.md): Bell 47G-5 · Castaic, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 1986 · N7802S · Substantial damage
  > The helicopter collided with unmarked wires while heading into sun during spraying operation. Plt does not recall seeing or hitting wires.
- [NTSB LAX86FUA01](https://openairdocs.org/ntsb/LAX86FUA01.md): Beech J35 · Long Beach, CA · Accident · No injuries · Final report · Feb 27, 1986 · N7293B · Substantial damage
  > The acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…
- [NTSB MIA86LA084](https://openairdocs.org/ntsb/MIA86LA084.md): Schweizer G-164B · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Feb 24, 1986 · N3629J · Substantial damage
  > The plt stated that she had completed one spray pass with one ton of fertilizer aboard & pulled up in a turn to about 200 ft. at that time the acft 'hit a pocket of dead air.' The acft nosed down and although the plt dumped the chemical load, she could not…
- [NTSB MIA86LA083](https://openairdocs.org/ntsb/MIA86LA083.md): Cessna T188C · Greenwood, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 1986 · N9936J · Substantial damage
  > The plt stated that during an aerial application swath run, he struck a group of power lines & crashed into a field.
- [NTSB FTW86FQG11](https://openairdocs.org/ntsb/FTW86FQG11.md): Cessna 402B · Plainview, TX · Accident · No injuries · Final report · Feb 23, 1986 · N4605N · Substantial damage
  > The acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…
- [NTSB ANC86LA031](https://openairdocs.org/ntsb/ANC86LA031.md): Piper PA-18 · Houston, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 1986 · N1827A · Substantial damage
  > The pilot was buzzing the area less than 200 feet above the ground when the engine started to run rough; the pilot attempted to land near the road when the aircraft struck power lines and a row of trees. Examination of the engine revealed no mechanical…
- [NTSB FTW86LPA19](https://openairdocs.org/ntsb/FTW86LPA19.md): Cessna 182A · Decatur, TX · Accident · No injuries · Final report · Feb 22, 1986 · N4071D · Substantial damage
  > The acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…
- [NTSB SEA86LA062](https://openairdocs.org/ntsb/SEA86LA062.md): Hiller UH-12E · Odessa, WA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1986 · N8542F · Destroyed
  > During an external load operation to remove groundwire off crossarms, the cable splice jammed in the pulley frame. The helicopters forward motion stopped and it then struck the ground. The pilot said the cargo hook release didn't work but no failures were…
- [NTSB ATL86FA079](https://openairdocs.org/ntsb/ATL86FA079.md): Cessna 152 · Wilkesboro, NC · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1986 · N93567 · Destroyed
  > Shortly after midnight the acft was observed flying erratically over the town. IMC existed in the area at the time. The student plt did not have any instrument flight time logged and his pax was not a plt. The acft was in a descending turn when it flew into…
- [NTSB SEA86LA061](https://openairdocs.org/ntsb/SEA86LA061.md): Piper PA-15 · Mount St.Helens, WA · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1986 · N4521H · Destroyed
  > The pilot was attempting to fly inside a volcanic crater around the lava dome above 6000 feet m.s.l.. The aircraft has a 75 horsepower engine. High winds entering the crater from the northeast flowing across the lava dome created a downdraft that the aircraft…
- [NTSB LAX86LUG02](https://openairdocs.org/ntsb/LAX86LUG02.md): Whigham GW4A · Hemet, CA · Accident · 1 fatal · Final report · Feb 20, 1986 · N24GW · Substantial damage
  > During a tow operation, the plt of the tow plane stated that just after takeoff the glider assumed a very low tow position, then swung very high to the right then to the left. At aprx 250 ft AGL the glider plt released from the tow plane and executed a 180…
- [NTSB DEN86LA082](https://openairdocs.org/ntsb/DEN86LA082.md): Aerospatiale SA315B · Meeker, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 1986 · N27387 · Substantial damage
  > During the lift off the right skid toe of the helicopter caught a seismic cable which was covered by aprx 2 ft of snow. The plt stated he brought the acft to a hover after off loading 2 pax & started a right sideward hover. When the slack was out of the…
- [NTSB ATL86FKG07](https://openairdocs.org/ntsb/ATL86FKG07.md): Piper PA-28-180 · Statesboro, GA · Accident · Serious injuries · Final report · Feb 20, 1986 · N8288W · Destroyed
  > The acft collided with the ground after encountering a downdraft over a wooded area at about 500 ft AGL. The plt reported that he flew out to overlook some land from the air. To avoid air traffic in the landing pattern he dropped down to about 550 ft and made…
- [NTSB ANC86LA030](https://openairdocs.org/ntsb/ANC86LA030.md): Cessna 206 · Delta Junction, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 1986 · N116ME · Destroyed
  > The aircraft struck a telephone pole guide wire while maneuvering at a low altitude. The electric company stated that the guide wire was 32 feet above the road surface. The pilot stated that he was low flying less than 50 feet above the ground to review…
- [NTSB DEN86LA079](https://openairdocs.org/ntsb/DEN86LA079.md): Bell 47G3 B-2 · Grand Junction, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1986 · N1424W · Substantial damage
  > The plt stated that while turning to the intended landing area, the helicopter he was piloting encountered both downdrafts & tailwind. The plt indicated the helicopter settled until grnd contact.
- [NTSB MIA86FA080](https://openairdocs.org/ntsb/MIA86FA080.md): Piper PA-31-310 · Moore Haven, FL · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1986 · N7EA · Destroyed
  > On February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…
- [NTSB ANC86LA028](https://openairdocs.org/ntsb/ANC86LA028.md): Cessna 182-A · Merrill Pass, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 1986 · N3813D · Destroyed
  > The pilot stated that he could see the whiteout condition ahead. During the 180 deg turn the aircraft struck the 3000 foot level of the mountian Pass. At the time of the accident the weather was a complete IFR whiteout condition.
- [NTSB FTW86LA044](https://openairdocs.org/ntsb/FTW86LA044.md): Robinson R-22 · Mcalester, OK · Accident · No injuries · Limited investigation · Final report · Feb 8, 1986 · N8557K · Substantial damage
  > The plt was hearding cattle with the helicopter when the accident occurred. He was traveling slow and parallel with a barbed wire fence. He had to turn to the right to avoid a tree which was directly ahead of the acft. Upon making the turn he caught the tail…
- [NTSB LAX86LA113](https://openairdocs.org/ntsb/LAX86LA113.md): Hiller UH-12E · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1986 · N62421 · Substantial damage
  > While on an aerial agricultural spraying flight the acft engine lost total power. The plt executed an immediate autorotation landing. Upon ground contact, the acft skid for about 8 ft until the front skid contacted the ground furrow and nosed over causing the…
- [NTSB ATL86LA069](https://openairdocs.org/ntsb/ATL86LA069.md): Hughes 269B · Council, NC · Accident · Serious injuries · Limited investigation · Final report · Feb 4, 1986 · N9374F · Destroyed
  > During a control burning operation, the plt experienced a complete eng failure. The plt entered an autorotation and collided with trees. The eng examination disclosed that the #4 connecting rod had failed. The failure was determined to have resulted from…
- [NTSB LAX86FA106](https://openairdocs.org/ntsb/LAX86FA106.md): Bell 206B · Young, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1986 · N3193T · Destroyed
  > The plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…
- [NTSB DEN86FA070](https://openairdocs.org/ntsb/DEN86FA070.md): Cessna 152 · Berthoud, CO · Accident · 2 fatal · Field investigation · Final report · Feb 2, 1986 · N46193 · Substantial damage
  > Student plt rented acft from flying club, acft was observed by witnesses to approach the lake from the south end at a low alt. Acft struck water with right main lnd gear and rt wing tip, and nosed over. The water was described as being 'glassy' and the sun…
- [NTSB FTW86FPJ05](https://openairdocs.org/ntsb/FTW86FPJ05.md): Stephenson Teenie TWO · Owasso, OK · Accident · 1 fatal · Final report · Feb 1, 1986 · N106TD · Destroyed
  > The acft descended to ground impact in a steep turn while practicing lazy eight maneuvers. The last turn was very steep at low alt and the acft disappeared behind trees. The plt was reportedly checking the acft's stability for the owner. The ground impact…
- [NTSB DEN86LA072](https://openairdocs.org/ntsb/DEN86LA072.md): Piper PA-18-150 · Afton, WY · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 1986 · N4238Z · Substantial damage
  > The plt stated he had descended to observe wildlife. When he attempted to add pwr he discovered the eng had quit. The plt indicated the acft wheel contacted the deep snow at a moderate rate of horizontal speed while he was trying to restart the eng.
- [NTSB NYC86FA068](https://openairdocs.org/ntsb/NYC86FA068.md): Beech E55 · Sunderland, MA · Accident · 1 fatal · Field investigation · Final report · Jan 31, 1986 · N6641A · Destroyed
  > Witnesses reported seeing the acft descend vertically in a flat spin until impact in open, flat terrain. The accident occurred aprx 45 min after the plt had taken off on a local proficiency flt. After impact, most of the airframe was demolished by fire. The…
- [NTSB FTW86LRA06](https://openairdocs.org/ntsb/FTW86LRA06.md): Aerospatiale AS-350D · Freeport, TX · Accident · Minor injuries · Final report · Jan 24, 1986 · N3599X · Substantial damage
  > While on a maintenance test flt the helicopter experienced an eng failure. An autorotation was entered and a hard landing occurred which resulted in a roll over. The flt originated at oyster creek heliport and returned twice for maintenance adjustments and…
- [NTSB SEA86LA043](https://openairdocs.org/ntsb/SEA86LA043.md): Luscombe 8A · Sloan, NV · Accident · 2 fatal · Limited investigation · Final report · Jan 19, 1986 · N41926 · Destroyed
  > Acft was observed performing low-level aerobatics, failed to complete pull-out from second consecutive overhead maneuver, striking ground in 20-30 degree nose-low attitude. No evidence of pre-impact mechanical failure or malfunction found in acft structure,…
- [NTSB CHI86FA068](https://openairdocs.org/ntsb/CHI86FA068.md): Cessna 177RG · Valley View, IL · Accident · 1 fatal · Field investigation · Final report · Jan 19, 1986 · N52949 · Destroyed
  > The plt was conducting a low pass, 40 ft AGL, on a river and struck a power line crossing his flt path. The strike caused loss of control and the acft impacted on the frozen surface of the river.
- [NTSB SEA86FA039](https://openairdocs.org/ntsb/SEA86FA039.md): Hiller-Soloy UH-12E · Horton, OR · Accident · 1 fatal · Field investigation · Final report · Jan 16, 1986 · N40290 · Destroyed
  > The fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…
- [NTSB NYC86LA061](https://openairdocs.org/ntsb/NYC86LA061.md): Bell 47J2A · Atkinson, NH · Accident · No injuries · Limited investigation · Final report · Jan 13, 1986 · N888EN · Destroyed
  > Pilot stated he was attempting to position the Bell 47 helicopter on a small pad. This pad was too narrow to accommodate this acft and the right skid slipped off the platform. The pilot then requested his passenger to deplane. After the pilot determined that…
- [NTSB FTW86FA034](https://openairdocs.org/ntsb/FTW86FA034.md): Piper PA-28-140 · Deville, LA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1986 · N5655U · Destroyed
  > The student plt had previously flown this acft in flt training. However, the insurance for the acft had lapsed & the owner had secured the acft to a tie-down with a chain & pad lock to prevent it from being flown. After the chain was cut with a hack saw, the…
- [NTSB FTW86LRD05](https://openairdocs.org/ntsb/FTW86LRD05.md): Bell BH206L-1 · Gulf Of Mexico, LA · Accident · Serious injuries · Final report · Jan 9, 1986 · N2653 · Substantial damage
  > The acft descended into the Gulf Of Mexico from a 100 ft AGL hover after the plt lost yaw control downwind of an offshore oil platform in 35 kt winds. As the acft came to a hover it began a turn to the right even though it was headed into the wind. Full left…
- [NTSB ATL86LA053](https://openairdocs.org/ntsb/ATL86LA053.md): Hughes 269A · Brewton, AL · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1986 · N8866F · Substantial damage
  > During low level controlled burning of a small timber forest the helicopter lost power. A forced landing was attempted in a field and the helicopter was substantially damaged. The aircraft owner related that the aircraft ran out of fuel.
- [NTSB LAX86LA078](https://openairdocs.org/ntsb/LAX86LA078.md): Cessna R172K · Kamuela, HI · Accident · 1 fatal · Limited investigation · Final report · Jan 1, 1986 · N7320K · Destroyed
  > The acft collided with terrain while maneuvering to aviod clouds during a local scenic flt. The plt stated that turbulence caused loss of control and the acft was blown into trees. The winds were from 050 degs at 37 KTS with gusts to 45 KTS. SIGMET oscar five…
- [NTSB LAX86FA077](https://openairdocs.org/ntsb/LAX86FA077.md): Cessna T210N · Hyder, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1985 · N4592Y · Destroyed
  > Witnesses observed the acft depart the ranch airstrip, level off at about 200 ft AGL & make a turn back over the ranch house. The acft occupants were seen to wave to the people on the ground as the acft began an abrupt climbing turn. The witnesses then saw…
- [NTSB ANC86FA020](https://openairdocs.org/ntsb/ANC86FA020.md): Cessna 182 · Lake Clark Pass, AK · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1985 · N5009D · Destroyed
  > The acft collided with rising terrain while maneuvering in a mountain Pass. Low ceilings, 40 to 50 kt winds and rain showers were reported in the area at the time of the accident.
- [NTSB FTW86LRG08](https://openairdocs.org/ntsb/FTW86LRG08.md): Robinson R-22HP · Pflugerville, TX · Accident · No injuries · Final report · Dec 21, 1985 · N8358C · Substantial damage
  > The helicopter rolled over when the right skid contacted the ground during a hover. The plt stated he had landed to and opened the door to check the skid position. After takeoff while in a hover at 2 ft AGL, the door popped open. The right skid contacted the…
- [NTSB ATL86LA046](https://openairdocs.org/ntsb/ATL86LA046.md): Cessna 150 · Mendenhall, MS · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1985 · N6712G · Substantial damage
  > The plt stated that the acft collided with a tree while he was making a low pass over his father's home. The plt said his attention was diverted while making a left turn and the acft descended into the tree.
- [NTSB LAX86FVM01](https://openairdocs.org/ntsb/LAX86FVM01.md): Pitts Special G-1 · Salinas, CA · Accident · No injuries · Final report · Dec 19, 1985 · N14JD · Destroyed
  > On December 19, 1985, an experimental Pitts-special, N14JD, owned and operated by the owner crashed under unknown circumstances near Salinas, California. The pilot survived but the aircraft was not recovered. The pilot stated that he had an unknown flight…
- [NTSB DEN86LA049](https://openairdocs.org/ntsb/DEN86LA049.md): Fairchild Hiller FH-1100 · Bountiful, UT · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 1985 · N184FH · Destroyed
  > According to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…
- [NTSB DEN86LA044](https://openairdocs.org/ntsb/DEN86LA044.md): Cessna 172N · Logan, UT · Accident · No injuries · Limited investigation · Final report · Dec 16, 1985 · N739KU · Substantial damage
  > The plt stated that shortly after a night departure, the acft entered a fog bank. The plt said he was turning to reverse direction and descending in order to avoid IMC. Prior to completing the turn, the plt encountered IMC and lost all outside visual…

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

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

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