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

## Cases, newest first

- [NTSB ATL83LA269](https://openairdocs.org/ntsb/ATL83LA269.md): Piper PA-25-235 · Hopeful, GA · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1983 · N7019Z · Destroyed
  > The acft collided with the ground during a turn around while conducting an aerial application operation. The pilot was spraying soy beans and was performing a turn when he stalled the acft without sufficient alt to recover. The pilot said there was no problem…
- [NTSB MIA83FU005](https://openairdocs.org/ntsb/MIA83FU005.md): Pterodactyl Ascender · Jacksonville, FL · Accident · Serious injuries · Final report · Jul 10, 1983 · UNREG · 2 aircraft · Destroyed
  > The plts of 2 high wing, pterodactle ascender, ultralight vehicles took off & were operating in a designated area for ultralights. One plt (plt-a) was making touch & go landings while the other plt (plt-b) was maneuvering in the vicinity. After plt-a made a…
- [NTSB LAX83FVG13](https://openairdocs.org/ntsb/LAX83FVG13.md): Champion 7ECA · Shingle Springs, CA · Accident · Serious injuries · Final report · Jul 10, 1983 · N1882G · Destroyed
  > The acft collided with an oak tree while maneuvering at low alt. The weather was VMC. The pilot stated that he was flying to maintain a battery charge. He said he climbed to about 1600-1700 ft MSL and flew southeast. The average elevation along this route is…
- [NTSB DEN83LA163](https://openairdocs.org/ntsb/DEN83LA163.md): Cessna 188B · Hooper, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1983 · N4886R · Substantial damage
  > The spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…
- [NTSB ATL83LA268](https://openairdocs.org/ntsb/ATL83LA268.md): Eames Acro Sport · Huntersville, NC · Accident · No injuries · Limited investigation · Final report · Jul 9, 1983 · N16SE · Substantial damage
  > The acft collided with a tree during inverted flt over an arpt. The pilot had made several aerobatic maneuvers over the airfield. On the last pass the acft was inverted at low alt as it proceeded down the rwy it drifted west about 200 ft and hit a tree near…
- [NTSB ATL83FKJ05](https://openairdocs.org/ntsb/ATL83FKJ05.md): Aeronca 7BCM L-16A · Gadsden, AL · Accident · 2 fatal · Final report · Jul 9, 1983 · N2557B · Destroyed
  > The acft collided with the ground in a 70 degree dive while taking part in an air show as a spotter plane. The acft had dropped one smoke grendade and was orbiting to drop another when it turned left and pitched down. According to an inspection guide for this…
- [NTSB FTW83FA323](https://openairdocs.org/ntsb/FTW83FA323.md): Texas Helicopter OH-13-EM-7A · Cedarville, AR · Accident · 1 fatal · Field investigation · Final report · Jul 8, 1983 · N68040 · Destroyed
  > The pilot was using an improvised hydraulic vertical saw to trim limbs & brush from powerlines. The saw blades appear to have malfunctioned while the helicopter was maneuvering. The pilot jettisoned the saw, but the quick disconnect hoses failed to release…
- [NTSB ATL83LA260](https://openairdocs.org/ntsb/ATL83LA260.md): Grumman G164A · Hazlehurst, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1983 · N951X · Destroyed
  > The acft collided with a tree and the ground shortly after takeoff with a heavy load on a hot day. The acft had 1600 lbsof dry fertilizer, 42 gallons of fuel for takeoff. The plt stated he got into 'downdrafts' in the rolling hills and he jettisoned the load…
- [NTSB FTW83LA328](https://openairdocs.org/ntsb/FTW83LA328.md): Bell 206 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 7, 1983 · N352QT · Substantial damage
  > The plt stated he intended to move the helicopter from a dolly platform to a surface parking area when the left skid collided with the dolly and the acft rolled over.
- [NTSB SEA83FA142](https://openairdocs.org/ntsb/SEA83FA142.md): Vans-Rupert RV-4 · Marshall, WA · Accident · 1 fatal · Field investigation · Final report · Jul 6, 1983 · N444RV · Destroyed
  > The flt was to test a newly installed airspeed indicator. A passenger who went on the flt survived the accident and saidthe pilot had done an aileron roll from 4000 ft MSL (about 1700 ft AGL) and had buffeted and lost alt during recovery. After a high speed…
- [NTSB MKC83FU004](https://openairdocs.org/ntsb/MKC83FU004.md): Mattison MAC 300 · Brewster, KS · Accident · Serious injuries · Final report · Jul 6, 1983 · UNREG · Substantial damage
  > The ultralight went out of control and dove in a cockscrew spiral to the ground. The vehicle did not move after impact. The acft was at about 200 ft AGL when witnesses saw it dip the right wing and start a spin which was described as a corkscrew. It made 4 or…
- [NTSB MIA83FA177](https://openairdocs.org/ntsb/MIA83FA177.md): Bell 206B · Miami, FL · Accident · No injuries · Field investigation · Final report · Jul 6, 1983 · N63RC · Substantial damage
  > The plt stated that as he slowed the helicopter to at or near 'effective translational lift' to let paxs obsv some construction he heard the engine make a loud noise and fail. The acft was at abt 300 ft AGL at 30-40 KTS. During lndg flare the t/r and t/boom…
- [NTSB SEA83FU007](https://openairdocs.org/ntsb/SEA83FU007.md): Airmass Sunburst · Tacoma, WA · Accident · 1 fatal · Final report · Jul 5, 1983 · UNREG · Destroyed
  > The ultralight had previously flown to Tacoma with 2 phantom ultralights in preparation for the airshow. During descent the 3 acft had reached speeds of 75-80 mph. After landing, one of phantom plts asked the sunburst plt if he knew how fast he was going and…
- [NTSB FTW83FA313](https://openairdocs.org/ntsb/FTW83FA313.md): Taylorcraft BCS 12-65 · Odessa, TX · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1983 · N1776B · Destroyed
  > The acft collided with wires and the ground during recovery from an aerobatic maneuver. The plt had done what appeared to be a maneuver similiar to a hammerhead stall shortly after first takeoff. The acft appeared to be recovering as it 'bottomed out' at…
- [NTSB SEA83FU006](https://openairdocs.org/ntsb/SEA83FU006.md): American Aerolights Eagle XL · Happy Valley, OR · Accident · Serious injuries · Final report · Jul 4, 1983 · UNREG · Destroyed
  > The ultralight collided with the terrain while maneuvering during an airshow. According to witnesses, the pilot had just executed a touch-and-go landing and commenced a climbing 180 degree left turn to downwind in what was described as a wingover type…
- [NTSB ATL83LA255](https://openairdocs.org/ntsb/ATL83LA255.md): Cessna 172P · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N52471 · Substantial damage
  > The acft nosed over during a forced landing after a stall during a low pass. The plt said he was flying around an islandat 500 ft AGL taking pictures when the acft began to settle. He added power and applied elevator back pressure. Then carburetor heat was…
- [NTSB ATL83LA252](https://openairdocs.org/ntsb/ATL83LA252.md): Sikorsky UH-19D · Thomasville, GA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N37785 · Substantial damage
  > The helicopter was on a swath run at about 5 ft AGL & was approaching hi obstructions when the plt noted that the needles split, the eng RPM increased & the main rotor RPM began decreasing. The plt turned to avoid the obstructions, but was unable to level the…
- [NTSB DEN83LA159](https://openairdocs.org/ntsb/DEN83LA159.md): Cessna 188B · Pierre, SD · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N8965G · Substantial damage
  > The plt was making practice swath runs with a load of water. During the third turn, at about 100 ft AGL, the eng stopped, according to the plt. The acft then landed hard & cartwheeled. No eng malfunctions were found.
- [NTSB DEN83FA156](https://openairdocs.org/ntsb/DEN83FA156.md): Piper PA-18-150 · Wheatland, WY · Accident · 1 fatal · Field investigation · Final report · Jul 2, 1983 · N6850Z · Destroyed
  > During an aerial application maneuver, the acft collided with the ground. An exam of the wreckage indicated that it impacted in a steep nose down attitude while rotating to the left. The flaps were found extended 25 deg & the airspeed gage was found…
- [NTSB ATL83LA250](https://openairdocs.org/ntsb/ATL83LA250.md): Cessna 150 · Tuscaloosa, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1983 · N8876U · Substantial damage
  > The acft collided with a power line spanning a river during a low pass over the water. The pilot said the purpose of thelow pass was to look for his father in a boat. He said he thought he saw the boat and in pulling up the acft hit the power line. Control…
- [NTSB MIA83LA179](https://openairdocs.org/ntsb/MIA83LA179.md): Grumman G-164B · Altha, FL · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N6531K · Substantial damage
  > The plt stated that the eng began losing power during an aerial application mission. Subsequently, he landed in a muddy field & the acft nosed over. He stated that the indupartial loss of power.
- [NTSB MIA83FA173](https://openairdocs.org/ntsb/MIA83FA173.md): Taylorcraft TC-19 · Lorida, FL · Accident · 1 fatal · Field investigation · Final report · Jul 1, 1983 · N20021 · Destroyed
  > Witnesses along a highway observed the acft flying at low altitude. One witness saw the acft hit a powerline, climb a little, then crash nose first.
- [NTSB DEN83LA155](https://openairdocs.org/ntsb/DEN83LA155.md): Piper PA-25-235 · Brandt, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1983 · N7121Z · Substantial damage
  > The acft was damaged in a forced landing after its eng lost power during pull-up from the last (cleanup) swath run. APRX25 min before the acdnt flt, the plt landed to reload with chemicals. The owner stated that when the plt was asked if hewanted fuel, he…
- [NTSB CHI83LA288](https://openairdocs.org/ntsb/CHI83LA288.md): Grumman G-164A · Morris, MN · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N8379 · Substantial damage
  > The plt reported that while he was waiting for the flagman, circling the field to be sprayed, & talking to the flagman, the acft began to sink & struck trees. The load was dumped, but the plane continued to sink to the ground. During the landing, the acft…
- [NTSB CHI83LA287](https://openairdocs.org/ntsb/CHI83LA287.md): Piper PA-25 · Morgan, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1983 · N6002Z · Substantial damage
  > The acft collided with trees while turning during aerial application. The pilot reported that the acft controls felt soft. Thinking he was stalling he reduced bank, lowered the nose and at 85 mph indicated with full power continued levelflt until a wing hit a…
- [NTSB SEA83FA141](https://openairdocs.org/ntsb/SEA83FA141.md): Monnett - Larsen Moni · Albany, OR · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1983 · N83GL · Destroyed
  > The home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…
- [NTSB LAX83LA312](https://openairdocs.org/ntsb/LAX83LA312.md): Bell 204B · Ocotillo, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1983 · N1WA · Destroyed
  > The acft was on an external load operation to airlift loads of cement. The cement was being poured for base pilings for power line towers on rough terrain. While carrying a 3100 lb load of cement on a 40 ft line, the helicopter had just moved to a position to…
- [NTSB SEA83FA139](https://openairdocs.org/ntsb/SEA83FA139.md): Cessna 182Q II · Near Peak, OR · Accident · Serious injuries · Field investigation · Final report · Jun 29, 1983 · N759XP · Destroyed
  > The acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…
- [NTSB FTW83FRG05](https://openairdocs.org/ntsb/FTW83FRG05.md): Aero Commander Callair A-9 · Lytton Springs, TX · Accident · 1 fatal · Final report · Jun 29, 1983 · N7717V · No damage
  > The acft crashed during a turn-around maneuver while conducting an aerial application mission. The acft had completed about 3 spraying patterns after reloading and was turning steeply to line up for another pass when the nose dropped and the acft descended in…
- [NTSB DEN83LA170](https://openairdocs.org/ntsb/DEN83LA170.md): Grumman G-164B · Page, ND · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N6652Q · Substantial damage
  > While spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…
- [NTSB MKC83LA138](https://openairdocs.org/ntsb/MKC83LA138.md): Grumman G-164A · Poplar Bluff, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1983 · N7246 · Destroyed
  > After making 2 swath runs, the acft was in a procedure turn-around over a wooded area when the eng lost power. The plt tried to glide to a suitable area, but the acft hit the tops of trees & crashed. The owner stated the eng had a history of maintenance…
- [NTSB ATL83LA292](https://openairdocs.org/ntsb/ATL83LA292.md): Air Tractor AT-301 · Fairfax, SC · Accident · No injuries · Limited investigation · Final report · Jun 28, 1983 · N4411S · Substantial damage
  > The acft mushed into the ground after the engine quit from negative g forces imposed by the pilot after clearing a fenceduring a swath run. After the engine lost power due to the temporary fuel starvation the pilot managed to clear some trees and mush into…
- [NTSB SEA83LA134](https://openairdocs.org/ntsb/SEA83LA134.md): Enstrom F28A · Lebanon, OR · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N9240 · Substantial damage
  > The helicopter was damaged in a roll-over during a forced landing on a soft plowed field. The pilot stated that he was checking another company pilot and in doing so he abruptly reduced power to simulate engine failure. A total loss of power occurred. The…
- [NTSB LAX83LA311](https://openairdocs.org/ntsb/LAX83LA311.md): Robinson R22 · Buckman Springs, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N9065L · Substantial damage
  > The helicopter experienced a loss of lift and descended into a lake after takeoff. The acft was about 29 lbs below max gross weight and the field elevation for takeoff was 4200 ft; also the calculated hover ceiling out of ground effect. The plt had climbed to…
- [NTSB MKC83LA135](https://openairdocs.org/ntsb/MKC83LA135.md): Cessna 152 · Madrid, IA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1983 · N69026 · Destroyed
  > The acft collided with unmarked wires over a river at about 150 feet AGL. A witness observed the acft low over the river and called an ambulance before the acft collided with the wires.
- [NTSB LAX83LA306](https://openairdocs.org/ntsb/LAX83LA306.md): Cessna C170A · Cajon Pass, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1983 · N1239D · Substantial damage
  > The plt was flying about 40 ft AGL in marginal weather when the acft contacted a power line and crashed. No flt plan wasfiled and there is no record of a weather briefing for the plt. The plt stated he was following a highway up a Pass whenhe encountered…
- [NTSB LAX83FU009](https://openairdocs.org/ntsb/LAX83FU009.md): American Aerolights Eagle XL · Sommerton, AZ · Accident · 1 fatal · Final report · Jun 26, 1983 · UNREG · Destroyed
  > A witness in another ultralight saw the plt of the eagle xl climb to about 800 to 1000 ft AGL after taking off. The witness was aprx 500 ft AGL when he saw the eagle xl start a steep descent from his 8 to 9 o'clock high position and thought the eagle xl plt…
- [NTSB NYC83FNE03](https://openairdocs.org/ntsb/NYC83FNE03.md): Bellanca 8KCAB · Madison, CT · Accident · 1 fatal · Final report · Jun 25, 1983 · N2979T · Destroyed
  > The acft collided with the ground while performing aerobatic maneuvers during an airshow. Witnesses said it appeared that the pilot was having trouble staying in the assigned area for the maneuvers because of high winds. The winds were estimated at 20 KTS…
- [NTSB LAX83LA307](https://openairdocs.org/ntsb/LAX83LA307.md): Cessna A150K · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1983 · N8496M · Destroyed
  > Witnesses observed the acft circling over the housing development at low altitude. The acft banked steeply, pitched up & the nose fell through the horizon. The student plt flying the acft resided four houses away from where the acft crashed.
- [NTSB LAX83FA305](https://openairdocs.org/ntsb/LAX83FA305.md): Prout LONG-EZE · Geyserville, CA · Accident · 2 fatal · Field investigation · Final report · Jun 25, 1983 · N81KP · Destroyed
  > The acft was first observed rounding the bend in the russian river about 1 mi west of the bridge flying in an easterly direction, apparently following the river bed. The acft's altitude was described from 'just over the water' to 'tree-toplevel.' As the acft…
- [NTSB FTW83LA295](https://openairdocs.org/ntsb/FTW83LA295.md): Kate 301 · Nas Kingsville, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1983 · N3239G · Destroyed
  > The home built acft was built from parts of a north American SNJ-4 & BT-13. It was made to resemble a ww-ii japanese Kate bomber & was being used in a confederate air force show to smiulate low level bombing runs. Between passes, the plt made 90-270 deg…
- [NTSB DEN83LA153](https://openairdocs.org/ntsb/DEN83LA153.md): Aero Commander Callair A-9B · Rolla, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1983 · N7642V · Destroyed
  > During a procedure turn-around after the second pass, the acft entered a stall, the left wing dropped & the plane impacted, left wing first, while in a nose down attitude. No preimpact, mechanical malfunction or failure was reported.
- [NTSB SEA83FA133](https://openairdocs.org/ntsb/SEA83FA133.md): Garlick UH-1B/204 · Fossil, OR · Accident · Minor injuries · Field investigation · Final report · Jun 24, 1983 · N5598G · Destroyed
  > The helicopter collided with a dead tree and crashed while conducting a spray run on an aerial application mission. The pilot said that the dawn light conditions made the obtacle hard to see. In the attempt to clear the tree the spray boom made contact and…
- [NTSB LAX83LA301](https://openairdocs.org/ntsb/LAX83LA301.md): Cessna 172N · Marina, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1983 · N733PP · Destroyed
  > The acft collided with the water while circling at low alt at night. During the maneuvering the engine also was reportedas running rough which further distracted the plt. He was already distracted trying to identify an object in the water while circling.…
- [NTSB LAX83FA298](https://openairdocs.org/ntsb/LAX83FA298.md): Cessna 152 · Pacoima, CA · Accident · 1 fatal · Field investigation · Final report · Jun 24, 1983 · N5454B · Destroyed
  > The acft was observed maneuvering in the area of the arpt traffic pattern for about 45 min before the accident. Initial impact occurred with power lines about 1/2 mi southwest of the arpt while the acft was on a heading of about 320 deg. The acft then struck…
- [NTSB MKC83FA133](https://openairdocs.org/ntsb/MKC83FA133.md): Piper PA-24-250 · 3m Se Of Benton, MO · Accident · 3 fatal · Field investigation · Final report · Jun 23, 1983 · N99SP · Destroyed
  > According to the surviving passenger, a boy, the plt was flying the acft from the right seat. The acft was flown to the vicinity of the plt's property where he made a pass over a farm belonging to a relative. The low pass was made near the operator of a…
- [NTSB DEN83FTG01](https://openairdocs.org/ntsb/DEN83FTG01.md): Stolp SA750 · Harwood, ND · Accident · 2 fatal · Final report · Jun 23, 1983 · N25873 · Destroyed
  > The acft impacted the ground in an inverted position in about a 30 degree nose down attitude. The acft was observed doing aerobatics with the last maneuver a spin. The acft spun to an out of sight position behind the trees and a crash was heard. The CFI on…
- [NTSB ATL83FA238](https://openairdocs.org/ntsb/ATL83FA238.md): Cessna 172K · Millhaven, GA · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1983 · N78160 · Substantial damage
  > The plt & his son took off at night to participate in the search for a downed acft. Subsequently, they found the burning wreckage of the downed plane. They saw people moving around the accident scene & made a pass over it by diving with the landing light on.…
- [NTSB CHI83FA267](https://openairdocs.org/ntsb/CHI83FA267.md): Piper PA28-161 · Cambridge, OH · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1983 · N2405U · Destroyed
  > The acft collided with the ground during a night flt after the plt encountered weather according to the radio transmissions to cleveland center. His statements were 'what have you got me into' and 'what are we into here' when asked by cleveland if he was into…
- [NTSB LAX83LUQ03](https://openairdocs.org/ntsb/LAX83LUQ03.md): Mareik-Bensen B-8M · Santa Maria, CA · Accident · 1 fatal · Final report · Jun 19, 1983 · N7045 · Destroyed
  > The gryoplane was observed to depart from controlled flt at or below 800 ft AGL & the plt became separated from the acft. Both impacted the ground in a near vertical descent about 40 ft apart. The plt's blood alcohol content was 0.13%. The clasp ends of the…

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

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

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