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

## Cases, newest first

- [NTSB LAX84LA438](https://openairdocs.org/ntsb/LAX84LA438.md): Cessna 152 · Cressey, CA · Accident · No injuries · Limited investigation · Final report · Aug 12, 1984 · N6321M · Substantial damage
  > Witnesses observed two acft making multiple low passes down the river. Each acft was seen flying under 3 electrical power lines at least 3 times. On the last pass, according to local law enforcement officers, one acft struck and severed all 3 power lines.…
- [NTSB DEN84FA259](https://openairdocs.org/ntsb/DEN84FA259.md): Cessna 172 · Lyons, CO · Accident · 1 fatal · Field investigation · Final report · Aug 12, 1984 · N7064G · Destroyed
  > The acft plunged to the ground after being seen doing a series of stall/spin maneuvers at a low alt. One witness saw thefinal maneuver and after seeing the acft disappear behind trees he went in search of it and found it about 100 yds southof the position he…
- [NTSB CHI84FA343](https://openairdocs.org/ntsb/CHI84FA343.md): Piper PA-12 · Alpena, MI · Accident · 2 fatal · Field investigation · Final report · Aug 12, 1984 · N98967 · Destroyed
  > Witnesses stated that the acft flew at a very low altitude over the lake performing what appeared to be a series of stalls and recoveries with the acft climbing steeply to aprx 150 ft above the lake and then dropping sharply back down within a few feet of the…
- [NTSB ATL84FLT12](https://openairdocs.org/ntsb/ATL84FLT12.md): Fred Williams KR-2 · Russellville, KY · Accident · Serious injuries · Final report · Aug 12, 1984 · N507FJ · Destroyed
  > The only witness the plts wife, said that the acft dropped out of the sky and burst into flames when it hit the ground. The plt was seriously injured and does not recall anything about the accident. The acft was a home built which was builtby the plt. The…
- [NTSB MIA84LA226](https://openairdocs.org/ntsb/MIA84LA226.md): Ayres Thrush S2R-T15 · Quitman, GA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1984 · N40241 · Destroyed
  > At the end of swath run the acft struck a piece of farm equipment during the pull-up. After the collision the plt noticed liquid trailing behind the acft as he returned to his departure airport. Upon ldg when the left wing settledclose to the rwy, the plt…
- [NTSB SEA84LA197](https://openairdocs.org/ntsb/SEA84LA197.md): Aeronca 7AC · Prineville, OR · Accident · No injuries · Limited investigation · Final report · Aug 9, 1984 · N83233 · Substantial damage
  > While maneuvering plt heard a loud chatter coming from the engine accompanied by a loss of power. Plt reduced remaining power and initiated a forced landing in a rough barley field. Post accident investigation revealed the crankshaft broke near the number two…
- [NTSB FTW84LA349](https://openairdocs.org/ntsb/FTW84LA349.md): Grumman G-164B · Tallulah, LA · Accident · No injuries · Limited investigation · Final report · Aug 9, 1984 · N8961H · Destroyed
  > After applying seven (7) loads of chemicals the pilot landed and loaded both fuel and chemicals. After takeoff he completed one swath run and was just starting the second run when he allowed the wheels to contact the crop. The load was not jettisoned and the…
- [NTSB CHI84LA344](https://openairdocs.org/ntsb/CHI84LA344.md): Cessna 177 · Sidney, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1984 · N3221T · Substantial damage
  > The acft collided with the ground in a corn field during a simulated forced landing after the power failed to respond to full throttle. The acft had been descended from 3000 ft AGL with throttle at idle, full flaps and carburetor heat on. In turning 180…
- [NTSB MKC84LA242](https://openairdocs.org/ntsb/MKC84LA242.md): Ayres S2R · Rohwer, AR · Accident · No injuries · Limited investigation · Final report · Aug 7, 1984 · N4002P · Substantial damage
  > The plt was unable to maintain alt after the engine failed. A forced landing was made in a field covered with 4 to 6 ft tall weeds. The acft traveled sideways during the landing. After the accident, the plt observed a broken rod which had penetrated the…
- [NTSB DEN84FA251](https://openairdocs.org/ntsb/DEN84FA251.md): Cessna R172E · Farmington, NM · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1984 · N601SP · Destroyed
  > After being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…
- [NTSB MKC84FA240](https://openairdocs.org/ntsb/MKC84FA240.md): Cessna A188B · Stonewall, AR · Accident · Minor injuries · Field investigation · Final report · Aug 5, 1984 · N8145G · 2 aircraft · Substantial damage
  > While engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications.
- [NTSB ATL84LA243](https://openairdocs.org/ntsb/ATL84LA243.md): Cessna 152 · Franklin, NC · Accident · No injuries · Limited investigation · Final report · Aug 5, 1984 · N5406B · Substantial damage
  > Plt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…
- [NTSB ATL84LA242](https://openairdocs.org/ntsb/ATL84LA242.md): Cessna A188B · Prattville, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1984 · N2514 · Destroyed
  > The pilot stated that while approaching a field in preparation for agricultural sraying, the engine failed. The aircraftwas pulled up into a climbing left turn and turned back toward the field for a forced landing. The aircrafts glide was extended to clear…
- [NTSB NYC84LA267](https://openairdocs.org/ntsb/NYC84LA267.md): Cessna C305A · Oceanport, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1984 · N73ED · Destroyed
  > Acft was involved in banner tow pick-up. On engaging tow, plt had executed full power pull-up to about 150 ft AGL when power loss occurred. Plt performed a forced landing on sandy terrain. Fire broke out on lndg roll. Plt evacuated acft successfully but acft…
- [NTSB LAX84LA428](https://openairdocs.org/ntsb/LAX84LA428.md): Hiller UH-12ET · Delano, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 1984 · N5359V · Substantial damage
  > The Hiller UH-12 helicopter (with a soloy conversion) was on a spray run when the eng began losing power. The plt headed for an 'open spot in the trees', but all power was lost the acft collided with almond trees. Only 15 to 18 ozs of fuel were remaining in…
- [NTSB FTW84LA337](https://openairdocs.org/ntsb/FTW84LA337.md): Cessna A188B · Batesville, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 1984 · N731LQ · Destroyed
  > There were no known acft or eng problems involved in the accident. A witness stated the acft started its pullup from the first swath run of the day on an agricultural operation, collided with an electrical transmission line & fell to the ground, fatally…
- [NTSB ANC84FA132](https://openairdocs.org/ntsb/ANC84FA132.md): Aeronca 7CCM · Kotzebue, AK · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1984 · N83138 · Destroyed
  > The plt & one pax departed on a pleasure flt from kiana, AK on 8/1/84. Four days later, the plt's mother traveled to Kotzebue, AK, to look for her son. She was unable to locate him & notified the FAA. A search was initiated, & on 8/6/84,the acft was located…
- [NTSB NYC84FFA04](https://openairdocs.org/ntsb/NYC84FFA04.md): Piper PA-25-150 · Lennox, NY · Accident · Serious injuries · Final report · Aug 1, 1984 · N6349Z · Destroyed
  > During the pullup after a swath run the acft collided with a tree causing it to crash out of control into the ground. The wreckage was burned in a post crash fire.
- [NTSB LAX84FA422](https://openairdocs.org/ntsb/LAX84FA422.md): Piper PA-23-250 · Honeydew, CA · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1984 · N14266 · Destroyed
  > Flt 101, a domestic cargo operation crashed at about 2400 MSL in a steep forested mountain valley. The acft & its cargo,consisting of bank documents & photographs, were destroyed. The plt sustained fatal injuries & no suitable specimens were available for…
- [NTSB FTW84FA329](https://openairdocs.org/ntsb/FTW84FA329.md): Piper PA-28-161 · Lake Charles, LA · Accident · 2 fatal · Field investigation · Final report · Jul 30, 1984 · N4314D · Destroyed
  > At aprx 250 ft ag., according to witnesses, eng sounds indicated that power was reduced to idle. The acft rolled into a steep left descending turn followed by the application of power just prior to impact. The CFI was known to have given other students…
- [NTSB ATL84LA238](https://openairdocs.org/ntsb/ATL84LA238.md): Cessna A188 · Hartsfield, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1984 · N9156G · Destroyed
  > The plt said he smelled an electrical fire while spraying. He elected to land but before he could the engine quit. A forced landing was made in a cornfield. The acft burned. The fire origin was not located in the totally burned wreckage.
- [NTSB NYC84LA258](https://openairdocs.org/ntsb/NYC84LA258.md): Piper J58 · Gilead, ME · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1984 · N38402 · Substantial damage
  > The acft was forced to land according to the plt, after a downdraft at low alt & airspeed created a trap. The plt said that he & a friend were looking for a fishing spot, when he realized that he could not make it over the top of rising terrain ahead & could…
- [NTSB NYC84FHD06](https://openairdocs.org/ntsb/NYC84FHD06.md): Bell 206L-1 · Tuckerton, NJ · Accident · No injuries · Final report · Jul 29, 1984 · N1072G · Substantial damage
  > According to the plt at 8 to 10 ft in a hover the cyclic snapped rearward 3 to 4 in with a noise from the rear. The tailboom was found bent aprx 45 degrees down and 15 degrees right with no evidence of ground contact on the tail skid shoe. Metallurgical…
- [NTSB LAX84FA420](https://openairdocs.org/ntsb/LAX84FA420.md): Piper PA-11 · Willows, CA · Accident · 2 fatal · Field investigation · Final report · Jul 29, 1984 · N80AH · Destroyed
  > The acft was observed to pitch up from a level flight attitude from about 300 ft AGL. The acft then pitched down & impacted the ground in a near vertical attitude.
- [NTSB CHI84FA321](https://openairdocs.org/ntsb/CHI84FA321.md): S.I. Briggs Varieze · Pickett, WI · Accident · No injuries · Field investigation · Final report · Jul 29, 1984 · N15EZ · Destroyed
  > The acft contacted a 25 ft AGL 2 strand 14000 v power line. After contacting the lines, the acft touched down in a corn field and traveled for aprx 210 ft. the acft then crossed a 2 lane road, struck a ditch separating the canard/gear and traveled an…
- [NTSB ANC84FA124](https://openairdocs.org/ntsb/ANC84FA124.md): Cessna 140 · Talkeetna, AK · Accident · No injuries · Field investigation · Final report · Jul 29, 1984 · N2233N · Substantial damage
  > Plt was conducting a search and rescue mission when his attention was diverted to an object on the ground. When plt redirected his attention to the flt path, rapidly rising terrain was viewed directly in front of the acft with insufficient room to turn. The…
- [NTSB MKC84LA236](https://openairdocs.org/ntsb/MKC84LA236.md): Piper PA-25-235 · Arapahoe, NE · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 1984 · N8640L · Substantial damage
  > While on a swath run to apply insecticide, the acft collided with electrical transmission lines that were crossing the field. After the initial impact, the acft angled to the left & hit another transmission line, then impacted the ground.
- [NTSB LAX84FA447](https://openairdocs.org/ntsb/LAX84FA447.md): Piper PA-23-160 · Garberville, CA · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1984 · N4291P · Destroyed
  > The acft collided with trees & ground during climb after takeoff on a dark night in mountainous terrain. The wx is not considered to be a factor since the wx was VMC at the time & place of the accident. It was a moonless night and the areaof the crash…
- [NTSB LAX84FA418](https://openairdocs.org/ntsb/LAX84FA418.md): Bell 206B · Point Loma, CA · Accident · No injuries · Field investigation · Final report · Jul 28, 1984 · N100TH · Substantial damage
  > The helicopter was ditched near pt Loma, CA, after the eng quit. The plt said there was no low fuel warning light or chip light. After salvage the fuel lines were found empty of fuel and the tank contained mostly sea water. The wires to the annuniciator panel…
- [NTSB FTW84LA327](https://openairdocs.org/ntsb/FTW84LA327.md): Piper J3C-65 · Denton, TX · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N38279 · Destroyed
  > The pilot stated that after takeoff he did 3 touch and go landing then started a series of stalls. After entry into a cross-control spin to the left, he found that he could not apply enough right pedal to recover. Examination of the aircraft revealed that the…
- [NTSB SEA84LA186](https://openairdocs.org/ntsb/SEA84LA186.md): Cessna A188B · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1984 · N70296 · Substantial damage
  > The acft was loaded with 1500 lbs of dry chemical (fertilizer). The air temp at the time of the accident was 95 deg f, resulting in a high density alt. Rising terrain existed at the point where the plt attempted a turnaround. In an attempt to turn away from…
- [NTSB LAX84FVM01](https://openairdocs.org/ntsb/LAX84FVM01.md): E.L. Griggs Q2 · Hollister, CA · Accident · 1 fatal · Final report · Jul 27, 1984 · N1180A · Substantial damage
  > The acft passed over the arpt twice after departure with the engine popping and backfiring. A witness who heard this radioed the plt to warn him. The plt replied that he was trying to correct it with the mixture control. The plt was also advised that his…
- [NTSB CHI84FA313](https://openairdocs.org/ntsb/CHI84FA313.md): Intermountain Mfg. Callair A-7 · Newfolden, MN · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1984 · N8240H · Destroyed
  > The acft crashed after completing two passes over the field being sprayed. Before takeoff the acft was loaded with 80 gals of liquid insecticide. The plts brother, who was acting as a flagman, said that the acft 'started to spiral to the ground' after…
- [NTSB SEA84FA185](https://openairdocs.org/ntsb/SEA84FA185.md): de Havilland Beaver DHC-2 · Ketchikan, AK · Accident · 2 fatal · Field investigation · Final report · Jul 26, 1984 · N4787C · Destroyed
  > The plt flew into a canyon with a climb-out gradient in excess of the acft capability and collided with the upsloping terrain. The plt said he had hit a downdraft and turned away from the rising terrain just as collision occurred. Surviving passengers do not…
- [NTSB FTW84LA324](https://openairdocs.org/ntsb/FTW84LA324.md): Air Tractor AT-301 · Abernathy, TX · Accident · No injuries · Limited investigation · Final report · Jul 26, 1984 · N2344T · Substantial damage
  > The acft collided with the bank of a drainage ditch in a field during a spray operation at which time the left main gearwas knocked off the acft. A precautionary landing was made during which the acft ground looped and the right main gear collapsed.
- [NTSB DEN84LA235](https://openairdocs.org/ntsb/DEN84LA235.md): Grumman G-164A · Chamerlain, SD · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N4593 · Substantial damage
  > The pilot experienced an engine failure and executed an emergency landing on a narrow road which resulted in one of the landing gear touching down on the soft shoulder. The landing gear failed and substantial damage resulted. Examination of the engine…
- [NTSB MKC84LA231](https://openairdocs.org/ntsb/MKC84LA231.md): Aero Commander S2R · Garden City, KS · Accident · No injuries · Limited investigation · Final report · Jul 24, 1984 · N3669X · Substantial damage
  > The plt stated that after the acft was fueled he failed to visually check the fuel tanks and just assumed both tanks were full. He stated the left fuel gage had been inoperative above 1/2 tank of fuel. During a spray run, when the right tank reached 1/4, he…
- [NTSB FTW84FA321](https://openairdocs.org/ntsb/FTW84FA321.md): Bell 206B · Dallas, TX · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1984 · N16981 · Destroyed
  > Witnesses observed the helicopter circling a 523 ft, free standing, communications tower. After circling several times, helicopter passed close to the tower & a main rotor blade struck it at the 451 ft level. The outboard portion of the rotor blade separated…
- [NTSB DEN84LA236](https://openairdocs.org/ntsb/DEN84LA236.md): Piper PA-25-235 · Webster, ND · Accident · No injuries · Limited investigation · Final report · Jul 24, 1984 · N6749Z · Substantial damage
  > Plt stated the engine began to sputter during an ag flt. A forced landing was made in a wheat field during which the left main gear collapsed and the left wing contacted the ground. Investigation revealed the acft was fueled from an unfiltered 5 gallon can…
- [NTSB MKC84FCA01](https://openairdocs.org/ntsb/MKC84FCA01.md): Grumman-Schweizer G-164A · Neelyville, MO · Accident · Serious injuries · Final report · Jul 23, 1984 · N5307 · No damage
  > The plt stated that after takeoff & two miles from the destination airport, the plt started a 180 deg turn to the rt to return to the takeoff strip. Approx halfway through the turn at 45 deg of bank, the rt wing pitched downward & he was unable to correct by…
- [NTSB MKC84FA229](https://openairdocs.org/ntsb/MKC84FA229.md): Piper PA 36-375 · Bertrand, NE · Accident · 1 fatal · Field investigation · Final report · Jul 23, 1984 · N3930E · 2 aircraft · Substantial damage
  > N3930E and N3968E had departed as a flight of two for aerial application. There was no record of preflight briefing or coordination planning. At completion of operations on the object field, N3930E advised N3968E by radio that he was making a final cleanup…
- [NTSB MKC84FCD02](https://openairdocs.org/ntsb/MKC84FCD02.md): Callair A-9 · Oakland, IA · Accident · Serious injuries · Final report · Jul 22, 1984 · N8287H · Destroyed
  > The pilot was practicing aerial application maneuvers using water as the spray load. He stated that about half way thru his turn to reverse direction, he felt the a/c give a very slight stall warning. He said that he released some back pressure and attempted…
- [NTSB DEN84LA234](https://openairdocs.org/ntsb/DEN84LA234.md): Piper PA-36 · Redfield, SD · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N44162 · Destroyed
  > The pilot reported he exhausted his fuel supply while engaged in aerial application. The power loss occurred as the aircraft was in a turn and ground impact occurred. In an accident report, the plt suggested that he should have had an operable fuel gage &…
- [NTSB MKC84FA225](https://openairdocs.org/ntsb/MKC84FA225.md): Bobby Wayne Watkins Mini Coupe · Nashville, AR · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1984 · N937BW · Destroyed
  > The builder/owner/plt had flown the home built acft for about 10 mins on its 1st test flt which was made a few days prior to the accident. On third flt, he took off on rwy 01, climbed straight-out for awhile, made a left turn to x-wind leg & started a…
- [NTSB FTW84LA319](https://openairdocs.org/ntsb/FTW84LA319.md): Rockwell S2R · Bryan, TX · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N4936X · Destroyed
  > The acft collided with trees and the ground after stalling during a pull-up while maneuvering for aerial application. It was a hot day and the acft had recently been loaded. The plt advised to 'beware of density altitude and turning hard over trees.' This…
- [NTSB FTW84LA315](https://openairdocs.org/ntsb/FTW84LA315.md): Hughes 369HS · El Paso, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 1984 · N9183F · Destroyed
  > The helicopter crashed into a field during an aerial application flight. There were no eyewitnesses to the crash. The pilot was pulled from the wreckage by a farm worker who heard the crash. The pilot would not state to investigators what occurred.
- [NTSB DEN84LA232](https://openairdocs.org/ntsb/DEN84LA232.md): Bell 206B · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N5754K · Substantial damage
  > The acft engine quit as the plt maneuvered over a ridge line after operating over 1 hour without refueling even though fuel was available at the last stop. The plt said the fuel gages indicated 6 gallons of fuel remaining. Of this about 2 are unusable in…
- [NTSB ATL84LA234](https://openairdocs.org/ntsb/ATL84LA234.md): Beech V35B · Marion, NC · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N4063S · Substantial damage
  > The acft collided with light gauge power lines which broke but acft control was not lost. The plt and a passenger were flying low over a lake looking for another friend who was skiing there. The flt was proceeding at about 25 ft AGL when the wires were…
- [NTSB ATL84LA231](https://openairdocs.org/ntsb/ATL84LA231.md): Beech C23 · Gainesboro, TN · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N18355 · Substantial damage
  > The acft collided with a static wire while flying along a river. The collision occurred at 350 ft AGL about 5 miles NE of the arpt. The left wing hit the wire which cut into the wing and penetrated a fuel cell. Fuel escaped from this cell and when the acft…
- [NTSB ATL84LA230](https://openairdocs.org/ntsb/ATL84LA230.md): Cessna A188B · Georgetown, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1984 · N731GV · Substantial damage
  > The plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…

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

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

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