# NTSB investigations: Initial climb

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 177 of 412 · 20,559 cases

## Cases, newest first

- [NTSB MKC86FCA03](https://openairdocs.org/ntsb/MKC86FCA03.md): Robbins ACRO-DUSTER II SA750 · Fenton, MO · Accident · 2 fatal · Final report · Jun 14, 1986 · N111TR · Destroyed
  > The aircraft was observed to go into a steep climb after departure from the runway. At 300 to 500 feet AGL, it nosed over and started a steep vertical dive into the ground. Examination of wreckage found no malfunction or failure of the aircraft. The pilot had…
- [NTSB DEN86FA160](https://openairdocs.org/ntsb/DEN86FA160.md): Beech C23 · Lamar, CO · Accident · Serious injuries · Field investigation · Final report · Jun 14, 1986 · N6337U · Destroyed
  > During the takeoff climb, the plt's door came open. The pvt plt with 2 hours flying experience in C-23 acft made a close in traffic pattern to return for landing. During the turn from base leg to final the nose of the acft suddenly dropped and the acft…
- [NTSB ATL86LA168](https://openairdocs.org/ntsb/ATL86LA168.md): Anderson Tierra II 1984 · Smith Station, AL · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N5291Y · Substantial damage
  > The acft's engine lost pwr shortly after t/o and a forced ldg was made in some saplings. The plt reported that he neglected to use the electric fuel boost pump during the t/o and subsequent pwr loss. He had previously installed the pump on the home-built acft…
- [NTSB FTW86LA106](https://openairdocs.org/ntsb/FTW86LA106.md): Cessna 150H · Mesquite, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1986 · N23039 · Destroyed
  > The pilot was making touch and go landings when, during the climb-out, the aircraft stalled and entered a spin. There was no recovery and the aircraft collided with the ground. The pilot stated that the engine quit; however, an engine teardown failed to…
- [NTSB ANC86LA072](https://openairdocs.org/ntsb/ANC86LA072.md): Piper PA-18 · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1986 · N8597D · 2 aircraft · Substantial damage
  > The pilots of each acft stated they thought that the left float and prop of the Taylorcraft had come in contact with the rt wing and rt landing gear of the Piper. The plts failed to see the other acft in time to avoid the collision. Both acft nosed over…
- [NTSB MIA86LA174](https://openairdocs.org/ntsb/MIA86LA174.md): Randy Tredo Mustang II · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N78RT · Substantial damage
  > The plt stated that just after takeoff he lost all engine power and upon landing in an open field the gear collapsed. Examination of the eng revealed that the butterfly valve in the carburetor heat box broke off and slid back into the carburetor opening and…
- [NTSB LAX86FA243](https://openairdocs.org/ntsb/LAX86FA243.md): Bell 206B · Hanalei, HI · Accident · Serious injuries · Field investigation · Final report · Jun 8, 1986 · N29906 · Destroyed
  > The helicopter had just departed runway 05. Ground witnesses and several occupants in the helicopter reported that when it was about 150 ft AGL it sustained a total engine power loss. The pilot immediately entered into an abrupt right turn autorotation. The…
- [NTSB ATL86LA161](https://openairdocs.org/ntsb/ATL86LA161.md): Aero Commander 500-B · Guntersville, AL · Accident · No injuries · Limited investigation · Final report · Jun 8, 1986 · N326JR · Substantial damage
  > The plt allowed the aircraft to settle back onto the runway shortly after liftoff from the runway after having already retracted the landing gear. The aircraft landed with the landing gear retracted.
- [NTSB ATL86FA160](https://openairdocs.org/ntsb/ATL86FA160.md): Beech D45(T34B) · Rome, GA · Accident · Serious injuries · Field investigation · Final report · Jun 8, 1986 · N544E · Destroyed
  > Just before takeoff, a rain shower was observed approaching the arpt. The plt elected to make a maximum performance takeoff. Rprtdly, after lift-off. She initiated a climb at 70 KTS & raised the flaps. The plt reported beginning a shallow turn at aprx 200 ft…
- [NTSB LAX86LA253](https://openairdocs.org/ntsb/LAX86LA253.md): Hall Christen Eagle II · Long Beach, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1986 · N41SH · Substantial damage
  > While practicing touch & go takeoffs and landings on runway 25R at Long Beach international arpt, Long Beach, CA, the acft experienced a total engine power loss. The PIC was flying from the rear seat and reptd the acft altitude was insufficient to return to…
- [NTSB DEN86LA154](https://openairdocs.org/ntsb/DEN86LA154.md): Piper PA-25-260 · Harve, MT · Accident · No injuries · Limited investigation · Final report · Jun 6, 1986 · N4768Y · Substantial damage
  > According to the plt, shortly after takeoff the eng lost partial pwr as a result of carb ice, & a forced landing was made.
- [NTSB DEN86LA153](https://openairdocs.org/ntsb/DEN86LA153.md): Cessna 172G · Charlson, ND · Accident · No injuries · Limited investigation · Final report · Jun 6, 1986 · N1136F · Substantial damage
  > According to the plt, he lndd in an off arpt field to make a rest stop. He stated that bfr taking off again, he checked for wind & fnd none. He then initiated a soft field takeoff twd the NE with 20 deg of flaps. He stated that after lift-off, he 'took some…
- [NTSB CHI86FER10](https://openairdocs.org/ntsb/CHI86FER10.md): Aeronca 65-TAC · White Bear Lake, MN · Accident · 2 fatal · Final report · Jun 6, 1986 · N36937 · Destroyed
  > The acft stalled & crashed following the initial takeoff. Witnesses stated that the plt aborted the 1st takeoff attempt. During the 2nd takeoff witnesses said that the acft nose was never lowered from a nose high position. After the acc the elevator trim was…
- [NTSB DEN86LA152](https://openairdocs.org/ntsb/DEN86LA152.md): Aeronca 7AC · Sisseton, SD · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1986 · N84693 · Destroyed
  > The front seat plt, on his first flt in the acft, was flying the acft. After takeoff the acft entered a nose high attitude because the elevator trim was improperly set. The nose high attitude was corrected but the right door on the engine cowling came open…
- [NTSB BFO86FID06](https://openairdocs.org/ntsb/BFO86FID06.md): Ayres S2R · Virginia Beach, VA · Accident · Minor injuries · Final report · Jun 5, 1986 · N7797V · Substantial damage
  > The acft was ditched after a loss of power during takeoff. Plt was unable to maintain alt & dumped liquid fertilizer load prior to landing. After ditching in a shallow canal the acft nosed over. Post accident investigation revealed a cracked cylinder in the…
- [NTSB LAX86FA240](https://openairdocs.org/ntsb/LAX86FA240.md): Cessna 177B · Fullerton, CA · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1986 · N35252 · Destroyed
  > The plt took off on a flt to provide traffic reports to a local broadcasting station. Witnesses rprtd that shortly aftertakeoff, the eng began to misfire. The acft entered a steep left bank angle, then plummeted toward the gnd. While still in a steep nose…
- [NTSB DEN86FA149](https://openairdocs.org/ntsb/DEN86FA149.md): American AA-1 Yankee · Cheyenne, WY · Accident · Serious injuries · Field investigation · Final report · Jun 4, 1986 · N5935L · Substantial damage
  > During takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…
- [NTSB NYC86LA144](https://openairdocs.org/ntsb/NYC86LA144.md): Beech A-23 · Charlotte, VT · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1986 · N23983 · Substantial damage
  > Pilot stated that on takeoff roll it seemed longer than usual and about 1500 to 1600 feet of the runway before the aircraft began to rotate. The aircraft had climbed about 15 to 20 feet before coming to the end of the runway and over water. At about 30 feet…
- [NTSB ATL86LA158](https://openairdocs.org/ntsb/ATL86LA158.md): Cessna T188 · Tyler, AL · Accident · No injuries · Limited investigation · Final report · Jun 3, 1986 · N4927J · Substantial damage
  > During a takeoff from a field strip the plt experienced a complete eng failure. The plt made a forced landing in a pecan orchard which resulted in airframe damage. Powerplant exam disclosed that the eng drive fuel pump had failed.
- [NTSB CHI86FEM08](https://openairdocs.org/ntsb/CHI86FEM08.md): Beech B35 · Paw Paw, MI · Accident · Serious injuries · Final report · Jun 1, 1986 · N5152C · Destroyed
  > On takeoff at approx 100' the engine began to falter. The pilot did a 180 deg turn and landed about 1/2 way down the runway. After bouncing twice and seeing that he would probably run off the end, he performed a go-around. At a point near the end of the…
- [NTSB ATL86LA149](https://openairdocs.org/ntsb/ATL86LA149.md): Cessna 152 · Mocksville, NC · Accident · No injuries · Limited investigation · Final report · May 31, 1986 · N49037 · Substantial damage
  > During a landing attempt at a private grass airstrip, the acft bounced several times and the student plt initiated a go-around before the plt instructor was prepared. The acft cleared departure threshold powerlines in a nose high attitude at low airspeed and…
- [NTSB ATL86FEK02](https://openairdocs.org/ntsb/ATL86FEK02.md): Green Pietenpol · Mt. Vernon, OH · Accident · Serious injuries · Final report · May 31, 1986 · N899MG · Substantial damage
  > The acft stalled and entered a spin to ground impact during the initial takeoff climb. The plt reported that during the takeoff and climb the airspeed indicator did not exceed 40 mph. He also stated the acft did not appear to be traveling very fast. He then…
- [NTSB ATL86FEI06](https://openairdocs.org/ntsb/ATL86FEI06.md): Bernard Darmstadt Daphne/Sdia · Akron, OH · Accident · 1 fatal · Final report · May 31, 1986 · N961Z · Destroyed
  > The acft was observed spiraling to the left from 500 ft AGL after takeoff. The spiral continued until the acft collided with a commercial bldg. Based on the autopsy report the plt died of natural causes declared to be cardiovascular collapse. The acft…
- [NTSB CHI86FA146](https://openairdocs.org/ntsb/CHI86FA146.md): Bellanca 7GCBC · E. Grand Forks, MN · Accident · 3 fatal · Field investigation · Final report · May 30, 1986 · N5026H · Destroyed
  > Witnesses rprtd the acft had just left the restricted lndg area (rla) when it entered a climbing maneuver, then dscndd &impacted the gnd & burned. Two witnesses said it went straight up, then straight down, before it crashed. Another 2 wit-nesses noted a pwr…
- [NTSB ATL86FA148](https://openairdocs.org/ntsb/ATL86FA148.md): Aeronca 7AC · Stone Mountain, GA · Accident · Serious injuries · Field investigation · Final report · May 30, 1986 · N3675E · Substantial damage
  > While on a bfr flt, the owner/plt was considered to be the plt-in-command. Drg departure, he took off on rwy 35 with a x-wind from the left. According to the instructor (CFI) & a witness, the takeoff was normal until shortly after lift-off, then the acft…
- [NTSB MKC86FCD01](https://openairdocs.org/ntsb/MKC86FCD01.md): Piper PA-25-235 · Lenox, IA · Accident · 1 fatal · Final report · May 29, 1986 · N7029Z · Destroyed
  > The acft collided with a fence during a takeoff with a full load of chemical pesticide. Collision with the ground resulted in a fire. The plt, who was seriously burned and later died, stated on his way to the hospital that he attempted to dump the acft load…
- [NTSB BFO86LA028](https://openairdocs.org/ntsb/BFO86LA028.md): Bellanca 7KCAB · Berlin, MD · Accident · No injuries · Limited investigation · Final report · May 29, 1986 · N12AP · Substantial damage
  > While climbing out after picking up an advertising banner the pilot of the Bellanca 7KCAB noticed that the aircraft yawed excessively to the right. After verifying that the engine was at full power. The pilot elected to drop the banner and make a…
- [NTSB ATL86FA147](https://openairdocs.org/ntsb/ATL86FA147.md): Smith, Ted Aerostar Aerostar 600 · Dickson, TN · Accident · 2 fatal · Field investigation · Final report · May 29, 1986 · N260A · Destroyed
  > The acft contacted electrical wires and trees shortly after takeoff. The acft then descended to impact with the terrain. Examination of the wreckage revealed the elevator trim actuator rod was extended 2.5 inches which correlates with a full nose down…
- [NTSB SEA86LA132](https://openairdocs.org/ntsb/SEA86LA132.md): Morris B. Stephens Variviggen · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · May 28, 1986 · N586MS · Destroyed
  > An excessively long takeoff run was made due to high density altitude. During intital climb the pilot over rotated causing a low airspeed. The pilot noticed this, lowered the nose and then flew into the ground. The pilot also failed to retract the landing…
- [NTSB SEA86LA131](https://openairdocs.org/ntsb/SEA86LA131.md): Arbaugh Evans Evans VP-1 · Kelso, WA · Accident · Minor injuries · Limited investigation · Final report · May 27, 1986 · N3764A · Destroyed
  > A forced landing was made due to a loss of power at about 150 AGL during initial climb. The acft was landed on railroad tracks where it was destroyed by impact. The reason for the power loss has not been determined.
- [NTSB NYC86LA136](https://openairdocs.org/ntsb/NYC86LA136.md): Fly Baby 1-A · Mt. Pleasant, PA · Accident · No injuries · Limited investigation · Final report · May 26, 1986 · N4762 · Substantial damage
  > On second takeoff, an abrupt loss of power was experienced. On flare for the emergency, off airport landing, the aircraft landed hard on rising terrain, bounced and came to rest inverted.
- [NTSB NYC86FA138](https://openairdocs.org/ntsb/NYC86FA138.md): Cessna 172M · Cairo, NY · Accident · 4 fatal · Field investigation · Final report · May 26, 1986 · N13650 · Destroyed
  > Witnesses saw black smoke trailing the acft shortly after it became airborne about 50 ft above the rwy. Shortly afterward, a loss of power loss occurred. The acft descended and collided with the ground in a nose low attitude. The rwy is 2,700 ft long and…
- [NTSB MKC86FA117](https://openairdocs.org/ntsb/MKC86FA117.md): Balloon Works Firefly 7-B · Lee'S Summit, MO · Accident · Serious injuries · Field investigation · Final report · May 25, 1986 · N15369 · Substantial damage
  > The PIC stated that prior to liftoff, the Balloon was gyrating and instructed the gnd crew member to steady the Balloon by holding the rope. Just as the Balloon became steady the PIC initiated his takeoff. The PIC was aware of turbulence in the takeoff site…
- [NTSB LAX86LA228](https://openairdocs.org/ntsb/LAX86LA228.md): Beech A19 · Taylor, AZ · Accident · Minor injuries · Limited investigation · Final report · May 24, 1986 · N6585T · Substantial damage
  > The acft collided with wires after a loss of alt during the initial climb while on a night VFR flt. The plt indicated that it took 3/4 of the rwy to get airborne and the acft did not seem to climb with full pwr applied. The plt decided to return to the arpt…
- [NTSB ANC86LA061](https://openairdocs.org/ntsb/ANC86LA061.md): Bellanca 7GCBC · Valdez, AK · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N8671V · Substantial damage
  > Examination of the aircraft fuel system revealed that water was found in the fuel lines.
- [NTSB LAX86LA226](https://openairdocs.org/ntsb/LAX86LA226.md): Bell 206B · Los Angeles, CA · Accident · Minor injuries · Limited investigation · Final report · May 21, 1986 · N1411W · Substantial damage
  > During a x-wind takeoff the downwind skid contacted the landing pad and the helicopter rolled over to the right. One person on the ground was injured by flying debris.
- [NTSB ATL86FA137](https://openairdocs.org/ntsb/ATL86FA137.md): Piper PA-34-200T · Valdosta, GA · Accident · Serious injuries · Field investigation · Final report · May 21, 1986 · N2850S · Substantial damage
  > The left engine lost power shortly after takeoff and the pilot did not feather the propeller. A traffic pattern was flown with the aircraft in a continuous descent. Insufficient altitude remained to maneuver the aircraft to the runway, so the pilot elected to…
- [NTSB DEN86FTM02](https://openairdocs.org/ntsb/DEN86FTM02.md): Denney Aerocraft Kitfox · Ogden, UT · Accident · Serious injuries · Final report · May 20, 1986 · N85LA · Substantial damage
  > Shortly after takeoff, the acft had a partial power loss. The left wing then dipped sharply & the acft entered a steep nose low descent & crashed on the nw corner of the arpt. An investigation revealed a noise suppressor was installed on one of 2 spark plug…
- [NTSB MKC86LA112](https://openairdocs.org/ntsb/MKC86LA112.md): Collin Campbell Zippy Sport · Bolivar, MO · Accident · Minor injuries · Limited investigation · Final report · May 19, 1986 · N118CC · Substantial damage
  > While performing a high speed taxi run on a turf rwy the plt stated the acft hit a bump in the rwy where a drainage pipe runs beneath the surface and inadvertently became airborne. The plt did not reduce throttle to abort the takeoff and the acft stalled…
- [NTSB CHI86FER08](https://openairdocs.org/ntsb/CHI86FER08.md): Cessna A188B · Montevideo, MN · Accident · No injuries · Final report · May 19, 1986 · N9496G · Substantial damage
  > During takeoff roll from a roadway the wind shifted from a headwind to a tailwind. The pilot of this crop duster turned to avoid a stop sign on the roadway and allowed his landing gear to touch down on a crossing roadway. The aircraft then flipped over onto…
- [NTSB NYC86FGM03](https://openairdocs.org/ntsb/NYC86FGM03.md): Eipper Quicksilver MX2 · Mars, PA · Accident · Serious injuries · Final report · May 18, 1986 · UNREG · Substantial damage
  > Pilot, once airborne, passing a tree line, encountered a sudden gust of wind. The quicksilver ultra-lite, with one pax, was forced from its flight path into power lines causing the aircraft to crash. Both pilot and pax sustained serious injuries. Aircraft was…
- [NTSB CHI86FER07](https://openairdocs.org/ntsb/CHI86FER07.md): Cessna 172P · Webster, WI · Accident · No injuries · Final report · May 17, 1986 · N99583 · Substantial damage
  > Shortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…
- [NTSB ANC86FA057](https://openairdocs.org/ntsb/ANC86FA057.md): WSK PZL-M-18 · Palmer, AK · Accident · Serious injuries · Field investigation · Final report · May 16, 1986 · N27301 · Substantial damage
  > Aircraft executed steep left 180 degree turn about 50 feet above runway just after takeoff. Pilot lost control and crashed. Turbulence and windshear had been reported. Wind speed and direction was variable.
- [NTSB FTW86LRD14](https://openairdocs.org/ntsb/FTW86LRD14.md): Grumman G-164A · Guedan, LA · Accident · No injuries · Final report · May 15, 1986 · N7371 · Destroyed
  > The pilot lost engine power at an altitude of about 150 feet AGL following takeoff. He impacted a raised roadbed during the forced landing, flipped inverted, slid to a stop, and burned. The fire damage prevented determination of the cause of engine failure.
- [NTSB MIA86LA155](https://openairdocs.org/ntsb/MIA86LA155.md): Piper PA-22-150 · Brooksville, FL · Accident · Minor injuries · Limited investigation · Final report · May 12, 1986 · N2425P · Substantial damage
  > The plt stated that the acft lost power on initial climb while practicing touch & go landings. The acft crashed.2 miles from the end of the rwy due to the fuel selector being positioned to the right tank, which did not contain enough fuel to return to the…
- [NTSB MKC86FA103](https://openairdocs.org/ntsb/MKC86FA103.md): Taylorcraft BL-65 · Independence, MO · Accident · Serious injuries · Field investigation · Final report · May 11, 1986 · N24491 · Destroyed
  > The pilot stated that they took off to the north with an intended southwest bound departure. After a left turn, while on the crosswind leg, and climbing through 800 feet, a blast of cold air and wind shear hit the aircraft, and the bottom fell out, according…
- [NTSB LAX86LA214](https://openairdocs.org/ntsb/LAX86LA214.md): MBB BO-105S · La Jolla, CA · Accident · Serious injuries · Limited investigation · Final report · May 9, 1986 · N2784N · Substantial damage
  > The pilot lost control of the helicopter's rotor system during the initial climb phase of the flight. The aircraft spun out of control and crashed on an interstate highway. Company maint applied AD-85-26-02 to detect or prevent jamming of rotorcraft controls…
- [NTSB MIA86LA151](https://openairdocs.org/ntsb/MIA86LA151.md): Cessna T188C · Shaw, MS · Accident · No injuries · Limited investigation · Final report · May 8, 1986 · N3041J · Substantial damage
  > The plt stated that shortly after takeoff he noticed the fuel cap was loose. He then turned downwind to land, at which time the aircraft stalled, resulting in the right wing colliding with trees.
- [NTSB FTW86FA079](https://openairdocs.org/ntsb/FTW86FA079.md): Cessna 411A · Bossier City, LA · Accident · 6 fatal · Field investigation · Final report · May 8, 1986 · N49DD · Destroyed
  > The pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…
- [NTSB LAX86FVG04](https://openairdocs.org/ntsb/LAX86FVG04.md): Grumman G-164 · Butte City, CA · Accident · No injuries · Final report · May 7, 1986 · N10219 · Substantial damage
  > The acft made a forced landing off arpt after a power loss during takeoff. The operator stated that water was found in the fuel system.

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=178

## 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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=177

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.