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

## Cases, newest first

- [NTSB LAX83LA115](https://openairdocs.org/ntsb/LAX83LA115.md): Grumman G164A · Mendota, CA · Accident · No injuries · Limited investigation · Final report · Feb 22, 1983 · N8679H · Destroyed
  > The acft collided with wires and crashed during and aerial application flight. The acft stalled after hitting the wires with the left wing and was out of control when it hit the ground and nosed over. The pilot said he had 3 miles visibility. He was also…
- [NTSB ATL83LA112](https://openairdocs.org/ntsb/ATL83LA112.md): Cessna T188C · Puckett, MS · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N3239J · Substantial damage
  > The acft was damaged during a forced landing after the engine quit due to fuel exhaustion. The plt stated that he forgotto check the fuel prior to takeoff. He said he was upset and distracted because his employees did not want to work on Saturday. Examination…
- [NTSB FTW83FA121](https://openairdocs.org/ntsb/FTW83FA121.md): Cessna P210 · Alexandria, LA · Accident · Minor injuries · Field investigation · Final report · Feb 15, 1983 · N4880P · Destroyed
  > The acft made excessively steep turns at low altitude and the engine lost power. During the forced landing that followedthe acft struck a tree and rolled inverted. It struck the ground in a near vertical nose down attitude. From the amount of fuel aboard at…
- [NTSB DEN83LA061](https://openairdocs.org/ntsb/DEN83LA061.md): Cessna 172K · Dove Creek, CO · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N84631 · Substantial damage
  > The acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…
- [NTSB MIA83FA073](https://openairdocs.org/ntsb/MIA83FA073.md): Aeronca 7EC · Astatula, FL · Accident · 2 fatal · Field investigation · Final report · Feb 12, 1983 · N4320C · Destroyed
  > The acft made a low pass over witnesses & pulled up steeply. The acft stalled & slid backwards before it became inverted and spun to the ground. There were about 2 rotations in the spin before impact. The plt who is listed as PIC for this flt was employed as…
- [NTSB DEN83FA058](https://openairdocs.org/ntsb/DEN83FA058.md): North American T-28A · N. Winter Park, CO · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1983 · N28TW · Destroyed
  > According to the surviving passenger (the plt's 15 yr old son), they saw some skiers after crossing over a mountain pass. He stated that as they turned, his father said, 'let's buzz them.' He reported that they turned sharply, 'sort of dove down to buzz…
- [NTSB CHI83LA109](https://openairdocs.org/ntsb/CHI83LA109.md): Cessna 150 · Calumetville, WI · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N11454 · Substantial damage
  > Tais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…
- [NTSB CHI83LA107](https://openairdocs.org/ntsb/CHI83LA107.md): Cessna 150 · Mauston, WI · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1983 · N6126T · Substantial damage
  > The acft collided with a frozen lake during a low pass while sight seeing. The pilot stated that he dropped down to 250 feet AGL to see if anyone was fishing and hit a downdraft. The acft descended and made contact with the snow and ice covered lake. The…
- [NTSB MIA83LA071](https://openairdocs.org/ntsb/MIA83LA071.md): Cessna T-210 · Ft. Myers, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1983 · N9561Y · Substantial damage
  > The acft nosed over in a swampy area during a forced landing following an engine failure. The weather was VMC and no fltplan was filed. The two occupants of the acft received minor injuries. The pilot indicated that he believed he had enough fuel for the…
- [NTSB LAX83FA092](https://openairdocs.org/ntsb/LAX83FA092.md): Cessna 182P · Wenden, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1983 · N5943J · Destroyed
  > The acft crashed into a hillsideduring a low altitude turn while surveying sheet. The plt in the right front seat who was flying the acft made a steep right turn to follow a herd of big horn sheep and the acft settled into the rising terrain. No evidence of…
- [NTSB LAX83FA087](https://openairdocs.org/ntsb/LAX83FA087.md): Bell 47G4 · Five Points, CA · Accident · Minor injuries · Field investigation · Final report · Feb 3, 1983 · N4262Y · Destroyed
  > The pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.
- [NTSB SEA83LA049](https://openairdocs.org/ntsb/SEA83LA049.md): Cessna A188B · Medford, OR · Accident · No injuries · Limited investigation · Final report · Feb 2, 1983 · N4784Q · Destroyed
  > The aircraft collided with a tree during aerial application operations. The pilot stated that there was a powerline at one end of the orchard he was spraying and a row of leafless trees at the other. One of the taller boundary trees was overlooked by the…
- [NTSB MIA83LA069](https://openairdocs.org/ntsb/MIA83LA069.md): Bell 47G2 · Riverview, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1983 · N74822 · Substantial damage
  > According to the pilot he lost control of the acft after a bird hit him on the right temple while flying at about 15 feet above the water. The acft was traveling at about 50 mph when the bird flew in through left door opening. The pilot lost control of the…
- [NTSB MIA83FA065](https://openairdocs.org/ntsb/MIA83FA065.md): MBB Scorpion TOO · Tallahassee, FL · Accident · 1 fatal · Field investigation · Final report · Jan 29, 1983 · N5459G · Substantial damage
  > The helicopter collided with trees while on a local personal flight. According to witnesses the acft was flying low overthe trees. Several loud backfires were heard and the helicopter crashed in a wooded area. The acft descended almost vertically with the…
- [NTSB ATL83FA091](https://openairdocs.org/ntsb/ATL83FA091.md): Mooney M-20A · Prattville, AL · Accident · 4 fatal · Field investigation · Final report · Jan 29, 1983 · N8146E · Destroyed
  > The left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…
- [NTSB SEA83FA045](https://openairdocs.org/ntsb/SEA83FA045.md): Cromwell/Pitts S-1S · Athol, ID · Accident · 1 fatal · Field investigation · Final report · Jan 24, 1983 · N56T · Destroyed
  > The plt tookoff with an estimated 7 gal of fuel on board. While performing aerobatic maneuver, he entered a vertical, climbing, power-on maneuver. Witnesses reported that the acft climbed to zero airspeed at about 2500 ft AGL. Reportedly, the acft then slid…
- [NTSB LAX83LA079](https://openairdocs.org/ntsb/LAX83LA079.md): Cessna 140 · Mt. Baldy, CA · Accident · No injuries · Limited investigation · Final report · Jan 23, 1983 · N2180N · Substantial damage
  > The pilot reported that while he was flying toward the crest of mt Baldy, he was blinded by the sun reflecting off of the freshly covered snow peak. As he reached for his sun glasses, the aircraft struck the mountain about 10 ft below the crest.
- [NTSB NYC83FHA03](https://openairdocs.org/ntsb/NYC83FHA03.md): Piper PA-22-135 · New Hope, PA · Accident · Serious injuries · Final report · Jan 16, 1983 · N8604C · Substantial damage
  > The acft collided with a power line while the pilot and a friend in another plane were flying along the deleware river. The plt reported that as he approached a bridge, he climbed to clear over the bridge and some power lines, then started to descend. He…
- [NTSB FTW83LA093](https://openairdocs.org/ntsb/FTW83LA093.md): Douglas DC-3 · Bay City, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1983 · TGSAB · Substantial damage
  > The guatemalan registered acft collided with the ground while airdropping bales of marijuana on a beach. According to a witness, while the acft was making low passes over the beach the propeller struck the beach tearing it off the acft. The acft then…
- [NTSB DEN83FTI03](https://openairdocs.org/ntsb/DEN83FTI03.md): Piper PA-18-150 · Galen, MT · Accident · Serious injuries · Final report · Jan 15, 1983 · N4610Y · Substantial damage
  > According to witnesses, the plt circled around some ranch building, then began a steep climbing turn. The plt stated that he was momentarily distracted by an outside observation, the climb became too steep, and the plane stalled. The pilot initiated a…
- [NTSB SEA83FA042](https://openairdocs.org/ntsb/SEA83FA042.md): Bellanca 8KCAB · Sunriver, OR · Accident · 1 fatal · Field investigation · Final report · Jan 14, 1983 · N29757 · Destroyed
  > The aircraft departed the runway, entered a steep climb and reversed course back over the runway in the opposite direction. At about 200 feet AGL, the aircraft rolled to the left and nosed down into the ground. The pilot had called on UNICOM and said he was…
- [NTSB MIA83LA059](https://openairdocs.org/ntsb/MIA83LA059.md): Enstrom F-28A · New Smyrna Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1983 · N278Q · Substantial damage
  > The newly purchased helicopter was being ferried to Maryland. During arrival to new Smyrna beach, FL, the 1st planned stop, the plt executed a landing approach to rwy 2. After coming to a hover, the helicopter lost rotor RPM during a pedal turn to a downwind…
- [NTSB FTW83FA079](https://openairdocs.org/ntsb/FTW83FA079.md): Mooney M20E · Cushing, OK · Accident · 2 fatal · Field investigation · Final report · Jan 9, 1983 · N7778M · Destroyed
  > The acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…
- [NTSB FTW83LA107](https://openairdocs.org/ntsb/FTW83LA107.md): Grumman G164A-450 · Clyde, TX · Accident · No injuries · Limited investigation · Final report · Jan 8, 1983 · N7843 · Substantial damage
  > The acft collided with a powerline and crashed during a forced landing after a engine failure. The pilot reported that he was pulling out from a swath run when the engine cut out,backfired and started running again. The pilot decided to return to elmdale, on…
- [NTSB FTW83FA078](https://openairdocs.org/ntsb/FTW83FA078.md): Cessna 150K · Romayor, TX · Accident · 2 fatal · Field investigation · Final report · Jan 8, 1983 · N6049G · Destroyed
  > The acft spun into the ground from a relatively low alt. The student pilot was giving rides to relatives and had successfully completed one flt during which the acft was stalled followed by a wing over and a dive. These maneuvers were repeated. Estimates of…
- [NTSB MIA83FA057](https://openairdocs.org/ntsb/MIA83FA057.md): Cessna 152 · La Belle, FL · Accident · 2 fatal · Field investigation · Final report · Jan 6, 1983 · N89225 · Destroyed
  > At about 1720 a commercial plt landed at La Belle arpt & reported that the ceiling was ragged in nature, some 200-300 ftoff the ground, with visibility 2 mi in drizzle. As he was leaving the arpt he noticed 2 men sitting in a blue & while C-152. After…
- [NTSB FTW83FRD02](https://openairdocs.org/ntsb/FTW83FRD02.md): Teal TSC-1A · Port Sulphur, LA · Accident · 1 fatal · Final report · Jan 6, 1983 · N2004T · Destroyed
  > The eng lost power during a pull-up from a low pass over the arpt. The plt made a forced landing in the icy Mississippi river with the gear down. The amphibian struck a submerged object in the river & flipped over. The plt & pax attempted to swim to shore but…
- [NTSB DEN83LA046](https://openairdocs.org/ntsb/DEN83LA046.md): Bell 47G-3B-2 (Soloy) · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Jan 6, 1983 · N7039J · Destroyed
  > While maneuvering at low altitude in search of animals, the pilot experienced a severe vibration through the flight controls. The helicopter began an uncontrolled descent and attempts to stop the descent by using the collective were unsuccessful. The…
- [NTSB DEN83FTE05](https://openairdocs.org/ntsb/DEN83FTE05.md): Schweizer 1-36 · Colo Springs, CO · Accident · No injuries · Final report · Jan 6, 1983 · N36166 · Substantial damage
  > The glider was substantially damaged during a pullup from a dive at altitude. The wing was rippled and beckled and damaged at the attach points. The dihedrial had changed from 6 degrees to 8.5 degrees. There was also unmeasured change in the sweepback. It is…
- [NTSB LAX83FA067](https://openairdocs.org/ntsb/LAX83FA067.md): Javelin Wichawk · Camarillo, CA · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1983 · N6940 · Destroyed
  > The acft impacted the ground 15 degrees nose down 70 degree left bank while performing low level aerobatics. Witnesses had observed the acft performing low altitude aerobatic maneuvers in the area of the accident. The acft was last seen descending at a near…
- [NTSB MIA83LA056](https://openairdocs.org/ntsb/MIA83LA056.md): Piper PA-32-301R · Near Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 3, 1983 · N35590 · Substantial damage
  > The acft collided with tree tops during a night flight but the pilot was able to maintain control and land at a nearby airport. According to the pilot he was on approach to fort pierce airport when the accident occurred. However according to some witnesses…
- [NTSB CHI83FA069](https://openairdocs.org/ntsb/CHI83FA069.md): North American T-6G · Genoa City, WI · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1983 · N3168G · Destroyed
  > Prior to the accident the acft flew over the arpt at tree-top level with the gear retracted. The acft then landed. After spending about 15 min on the ground the plts took off to the west. The gear was retracted immediately after takeoff & the acft remained…
- [NTSB ATL83FIG03](https://openairdocs.org/ntsb/ATL83FIG03.md): Cessna 172F · Hancock, MD · Accident · 1 fatal · Final report · Jan 2, 1983 · N8515U · Substantial damage
  > The aircraft collided with the top two wires of a powerline during a low altitude sight-seeing flight along the potomac river. The pilot stated he was maintaining visual contact with the ground should an emergency landing become necessary. He was staying high…
- [NTSB LAX83FVM06](https://openairdocs.org/ntsb/LAX83FVM06.md): Cessna 152 · King City, CA · Accident · No injuries · Final report · Dec 30, 1982 · N5275H · Substantial damage
  > The acft collided with & broke 3 power lines suspended across a creek. The plt made a precautionary landing at King cityarpt without further incident.
- [NTSB ATL83FLG03](https://openairdocs.org/ntsb/ATL83FLG03.md): Piper PA-28R-200 · Cleveland, SC · Accident · Minor injuries · Final report · Dec 24, 1982 · N9327N · Destroyed
  > The plt stated he was VFR on top of a broken cloud layer & decided to descend through an opening. After descending clear of the clouds he was in a pass with hills on each side & not enough room to turn around. He continued north along the highway hoping the…
- [NTSB ATL83FIG02](https://openairdocs.org/ntsb/ATL83FIG02.md): Grumman AA1B · Delmar, MD · Accident · 2 fatal · Final report · Dec 24, 1982 · N6207L · Destroyed
  > Pilot making steep turns near his home at low altitude stalled and crashed. No malfunctions found. Witnesses said engine sounded normal in flight.
- [NTSB MKC83FA044](https://openairdocs.org/ntsb/MKC83FA044.md): Cessna R182 · 1 1/2 Mi.N. May, KS · Accident · 1 fatal · Field investigation · Final report · Dec 23, 1982 · N756DB · Destroyed
  > The pilot received wx briefings at 1114 & 1220. He was advised against VFR flt due to low ceilings & visibilities in western Missouri, eastern & northeastern Kansas. At 1300 the plt received a special VFR clearance to depart. At 1330 witnesses observed the…
- [NTSB SEA83FYP01](https://openairdocs.org/ntsb/SEA83FYP01.md): Burke-Parker Quickie · Richland, WA · Accident · 1 fatal · Final report · Dec 18, 1982 · N82PB · Destroyed
  > Witnesses first observed the acft proceeding southbound over the departure end of rwy 19 at an altitude of APPROXIMATELY50 ft. the acft then continued southbound at tree-top level for approximately 1 mile in level flt. It then turned eastbound & shortly after…
- [NTSB LAX83FUJ09](https://openairdocs.org/ntsb/LAX83FUJ09.md): Grumman American AA-1B · Cornville, AZ · Accident · 1 fatal · Final report · Dec 18, 1982 · N9692L · Substantial damage
  > The pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…
- [NTSB CHI83LA062](https://openairdocs.org/ntsb/CHI83LA062.md): Scorpion Too · Sandwich, IL · Accident · 1 fatal · Limited investigation · Final report · Dec 18, 1982 · N9354A · Destroyed
  > The rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…
- [NTSB CHI83LA051](https://openairdocs.org/ntsb/CHI83LA051.md): Mitsubishi MU-2B-20 · Muskegon, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1982 · N45EV · Substantial damage
  > The pilot descended below his altitude and struck trees approximately 4.7 miles south of his destination. The aircraft continued to fly and the pilot elected to make an emergency landing. After touchdown the aircraft skidded down the runway for approximately…
- [NTSB LAX83FUJ07](https://openairdocs.org/ntsb/LAX83FUJ07.md): Beech K35 · Tucson, AZ · Accident · 1 fatal · Final report · Dec 14, 1982 · N6085E · Destroyed
  > The acft crashed into rising terrain left wing tip first. The pilot had made a radio call saying he was landing due to smoke in the cockpit at 1517 MST. At 1523 MST the acft crashed off arpt on an upslope with a 30 degree incline. Examination of the wreckage…
- [NTSB LAX83FUG08](https://openairdocs.org/ntsb/LAX83FUG08.md): Rand KR-2 · Norco, CA · Accident · 2 fatal · Final report · Dec 12, 1982 · N5RU · Destroyed
  > Experimental aircraft on demonstration flight spun to the ground from low altitude and was destroyed on impact. Witness saw and heard the aircraft maneuver and crash with the engine at high RPM. Weather was VMC.
- [NTSB SEA83LA030](https://openairdocs.org/ntsb/SEA83LA030.md): Taylorcraft L-2 · Near Gooding, ID · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1982 · N68903 · Destroyed
  > The pilot made a steep turn close to the ground while taking photographs of coyotes. The aircraft stalled and contacted the ground.
- [NTSB ATL83LA061](https://openairdocs.org/ntsb/ATL83LA061.md): Robinson R-22 · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Dec 11, 1982 · N90773 · Substantial damage
  > During an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…
- [NTSB SEA83AA028](https://openairdocs.org/ntsb/SEA83AA028.md): de Havilland DHC-2 · Near Klawock, AK · Accident · 8 fatal · Final report · Dec 9, 1982 · N68081 · Destroyed
  > At 1236 the flt departed ketchikan seaplane base with a special VFR clearance & at 1240 reported clear of the control zone. The next & last transmission by the plt was made to the company via fm radio at about 1340. This report was issuedin the vicinity of…
- [NTSB LAX83LA057](https://openairdocs.org/ntsb/LAX83LA057.md): Grumman G-164B · Westley, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1982 · N6713Q · Substantial damage
  > The acft collided with a dirt berm during a swath run tearing off both main landing gear. The acft continued to fly & an emergency landing was made at crow's landing nas. The plt attributed his inability to maintain sufficient ground clearance to the haze &…
- [NTSB LAX83LA053](https://openairdocs.org/ntsb/LAX83LA053.md): Bell TH-13T · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 1982 · N3001F · Substantial damage
  > After a practice spray turn, the helicopter collided with the ground during recovery from a descent back into the field. No discrepancies were reported with the airframe, engine or weather conditions. The pilot was quoted as saying he refrained from pulling…
- [NTSB ANC83FA022](https://openairdocs.org/ntsb/ANC83FA022.md): Enstrom F-28A · Chugiak, AK · Accident · Minor injuries · Field investigation · Final report · Dec 6, 1982 · N9607 · Substantial damage
  > The aircraft collided with ground and rolled while the pilot was hover taxiing downwind. The winds were described as 15 KTS to gusts as high as 45 KTS. The Enstrom chief engineer reported that a downwind hover tends to decay the main rotor RPM due to…
- [NTSB LAX83FA048](https://openairdocs.org/ntsb/LAX83FA048.md): Varieze Ruatan · Riverside, CA · Accident · 1 fatal · Field investigation · Final report · Dec 5, 1982 · N1182Z · Destroyed
  > Witnesses stated he heard and saw the aircraft flying (rather slow and low) over the canyon. He heard the engine "sputtering" and then observed the aircraft appear to stall followed by a steep descent into the hilly terrain. Investigation revealed the…

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

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

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