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

## Cases, newest first

- [NTSB NYC84LA238](https://openairdocs.org/ntsb/NYC84LA238.md): Scheibe Flugzeugbau SF-27M · Grove City, PA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N100LH · Substantial damage
  > The motorglider lost power after takeoff. According to the plt the takeoff seemed long but he did not abort because thiswas his first self-launch and he was unsure of the operation. About 200 ft AGL a turn was made to the east to return to the arpt and the…
- [NTSB NYC84LA235](https://openairdocs.org/ntsb/NYC84LA235.md): Piper PA-23 · No. Andover, MA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N1257P · Substantial damage
  > The acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…
- [NTSB NYC84FGM06](https://openairdocs.org/ntsb/NYC84FGM06.md): Teratorn II · Brownsville, PA · Accident · Serious injuries · Final report · Jul 8, 1984 · N4475V · Substantial damage
  > The owner/plt had previous flown the home built acft which was constructed similar to an ultralight. An optional pilot enclosure (canvas covering over the plt compartment) had just been installed. On 7/7/84, the owner/plt taxi checked the acft for about 30…
- [NTSB SEA84LA165](https://openairdocs.org/ntsb/SEA84LA165.md): Champion 7ECA · Juneau, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1984 · N6332N · Destroyed
  > The cowling of the acft came loose and the plt reduced power because of the vibration. An emergency was declared and theplt attempted a 180 degree turn at an alt of 400 ft AGL. A stall was entered and the acft hit a channel where the water was about 10 ft…
- [NTSB CHI84LU006](https://openairdocs.org/ntsb/CHI84LU006.md): Pterodactyl Fledgling · Hartford, WI · Accident · Serious injuries · Final report · Jul 7, 1984 · UNREG · Minor damage
  > The ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…
- [NTSB CHI84LA286](https://openairdocs.org/ntsb/CHI84LA286.md): Gillmore Moni · Joliet, IL · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N157LG · Substantial damage
  > The prop separated from the acft at aprx 500 ft AGL during the initial takeoff climb. A forced landing was made in a corn field. The prop was attached by means of 4 5/16 inch bolts and retaining nuts. Two of the four bolt portions remaining after the accident…
- [NTSB SEA84FA164](https://openairdocs.org/ntsb/SEA84FA164.md): Bellanca 7GCBC · Gorst, WA · Accident · Serious injuries · Field investigation · Final report · Jul 6, 1984 · N57396 · Destroyed
  > According to witnesses the acft departed rwy 19 & initiated a climbing left turn. The acft was then observed to increase angle of bank to the left and climb rate. At about 50 to 75 ft, the acft entered a steep uncontrolled descent & collide with the ground.…
- [NTSB MKC84LA201](https://openairdocs.org/ntsb/MKC84LA201.md): Cessna 172 · Cuba, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1984 · N21249 · Substantial damage
  > The acft nosed over during a forced landing immediately after takeoff. The acft had been parked outdoors and not flown for six months and according to witnesses the plt did nothing except add 10 gallons of fuel to the acft tanks. The acft engine quit when the…
- [NTSB LAX84LA384](https://openairdocs.org/ntsb/LAX84LA384.md): Cessna 172N · Chester, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1984 · N6301E · Substantial damage
  > The plt reported that he attempted to takeoff on rwy 15 with a wind from the west at 15 gusting to 25 KTS. Also, the outside air temp was 94 deg & the density altitude was about 7800 ft. the plt stated that about halfway down the rwy, the acft lifted off in…
- [NTSB FTW84LA306](https://openairdocs.org/ntsb/FTW84LA306.md): Piper PA-25-235 · Lamesa, TX · Accident · No injuries · Limited investigation · Final report · Jul 6, 1984 · N7521Z · Substantial damage
  > The acft collided with the ground after takeoff and the left main gear was knocked off. The plt did not dump the chemical load when the acft started to settle. According to the plt, the acft was too heavy and density alt was a factor.
- [NTSB FTW84FA300](https://openairdocs.org/ntsb/FTW84FA300.md): Piper PA-38-112 · Georgetown, TX · Accident · Serious injuries · Field investigation · Final report · Jul 5, 1984 · N25466 · Substantial damage
  > The acft crashed into trees during takeoff following a reported loss of power. The engine by observation was running at impact. Investigation showed a worn magneto and fouled spark plugs; #3 bottom plug was coated with unburned oil and foreign matter. The…
- [NTSB NYC84FA228](https://openairdocs.org/ntsb/NYC84FA228.md): Beech B55 · N. Haverhill, NH · Accident · 1 fatal · Field investigation · Final report · Jul 3, 1984 · N8101R · Destroyed
  > A friend who observed the plt preflighting the acft saw him drain fuel from the sumps to check for water. However, he did not see the plt check the fuel level in the tanks. The plt taxied to the rwy, performed an eng run-up & took off. Shortly after lift-off,…
- [NTSB NYC84FU006](https://openairdocs.org/ntsb/NYC84FU006.md): Pterodactyl Pfledgling · Canandaigua, NY · Accident · 1 fatal · Final report · Jul 2, 1984 · UNREG · Destroyed
  > During takeoff, the ultralight vehicle was observed to enter a steep climb. A witness stated that when it was climbing over the midpoint of the rwy, it entered a steep dive. The plt recovered from the descent & began another steep climb. After reaching about…
- [NTSB MKC84FA195](https://openairdocs.org/ntsb/MKC84FA195.md): Piper PA-24-180 · Osage Beach, MO · Accident · Serious injuries · Field investigation · Final report · Jul 2, 1984 · N5019P · Destroyed
  > Witness stated acft touched down midfield and bounced several times on the rwy. Two witnesses heard power applied and the acft lifted off 300 ft from the end of the rwy. They stated flaps were fully extended for the total transition and the gear was retracted…
- [NTSB SEA84LA150](https://openairdocs.org/ntsb/SEA84LA150.md): Cessna 172 · Bend, OR · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N8467U · Substantial damage
  > The plt was taking off from a cinder road. He stated that the acft used about 2,300 ft of ground run & he rotated at about 66 mph. At about 15 ft AGL the nose dropped & the acft struck the ground. Both wing tips were damaged. Density altitude was 6400 ft.
- [NTSB MKC84LA193](https://openairdocs.org/ntsb/MKC84LA193.md): Cessna 188 · Dyersville, IA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N9857V · Substantial damage
  > The acft was over max gross wt by aprx 147 lbs and exceeded the fwd CG limit with a 1200 lb chemical load. During the initial climb at 50-100 ft AGL the acft could not maintain flying speed, stalled, and entered an uncontrolled descent. The acft impacted…
- [NTSB CHI84LA276](https://openairdocs.org/ntsb/CHI84LA276.md): Cessna 150G · Williamston, MI · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N3495J · Substantial damage
  > Some cows ran into the path of the acft during takeoff. The plt turned as soon as airborne to avoid the animals and had to turn again to avoid powerlines. In this maneuvering the acfts left wing hit a tree and the acft cartwheeled.
- [NTSB ATL84LA214](https://openairdocs.org/ntsb/ATL84LA214.md): Mooney M-20F · Red Bay, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1984 · N3207F · Substantial damage
  > The acft landed gear up short of the rwy in an attempt to return to the rwy after a power loss at low alt. During takeoff the arpt manager said the engine sound change was consistent with power loss from fuel starvation. FAA did a post accident engine test…
- [NTSB NYC84FFA03](https://openairdocs.org/ntsb/NYC84FFA03.md): Aeronca 11AC · Glens Falls, NY · Accident · 1 fatal · Final report · Jun 30, 1984 · N3283E · Destroyed
  > A witness noted that, on takeoff, the acft appeared to be out of control. It entered a nose high attitude, then 'fell.' The plt recovered before the acft hit the ground, but the airplane 'oscillated in altitude until out of line of sight.' Subsequently, the…
- [NTSB DEN84LA203](https://openairdocs.org/ntsb/DEN84LA203.md): Cessna 210L · Recluse, WY · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 1984 · N1790X · Substantial damage
  > The plt stated that while taking off from a grass strip the acft drifted to the left. He could not then define the strip from the remaining area of the field due to the tall grass. He applied full right rudder but the acft continued to swerve to the left &…
- [NTSB DEN84FTE02](https://openairdocs.org/ntsb/DEN84FTE02.md): John R Jones PDQ2VW · Aurora, CO · Accident · No injuries · Final report · Jun 30, 1984 · N44222 · Substantial damage
  > The homebuilt acft was being tested for flt even though previous tests had proven that the engine would not support flt. The plt said the carburetor had been improved prior to this test. The acft tookoff and climbed to about 15 ft AGL and stayed at that alt…
- [NTSB DEN84FA202](https://openairdocs.org/ntsb/DEN84FA202.md): Beech 35 · Albuquerque, NM · Accident · 2 fatal · Field investigation · Final report · Jun 30, 1984 · N3267V · Destroyed
  > According to arpt personnel the plt was known to perform maintenance on his acft. The plt was not a licensed A&P. According to witnesses, the acft tookoff and climbed to aprx 200 to 250 ft and the eng quit. The acft climbed 'a little more', then made a left…
- [NTSB CHI84LA272](https://openairdocs.org/ntsb/CHI84LA272.md): Howard E. Lee Rutan Long EZ · Minneapolis, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1984 · N373JH · Substantial damage
  > The plt claimed a loss of power during takeoff. He turned and attempted a landing on the arpt. The rwy was overrun and the acft stopped in a wheat field. Post accident examination of the engine revealed no discrepancies.
- [NTSB ATL84LA213](https://openairdocs.org/ntsb/ATL84LA213.md): Cessna 172N · Summerville, SC · Accident · 1 fatal · Limited investigation · Final report · Jun 30, 1984 · N3JR · Substantial damage
  > A witness observed the aircraft as the pilot attempted a downwind takeoff. The takeoff roll was longer than normal. The aircraft was observed to become airborne about 2000 ft down the rwy. The aircraft never established a positive rate of climb but the nose…
- [NTSB MKC84LA189](https://openairdocs.org/ntsb/MKC84LA189.md): Cessna T210M · Kirksville, MO · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N761YR · Substantial damage
  > After taking off, the plt noted a malfunction of the landing gear sys. He then tried to lower the gear, but the nose gear would not extend. All attempts to extend the nose gear were unsuccessful, so the plt elected to make a wheels-up landing. After the…
- [NTSB DEN84LA204](https://openairdocs.org/ntsb/DEN84LA204.md): Grumman G-164A · Page, ND · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N5332 · Substantial damage
  > Engine siezed during takeoff climb at alt of aprx 100 ft AGL. Acft contacted trees during the forced landing. Examination of engine turbo section revealed the blower section had separated as a result of bearing failure. According to a mechanic who…
- [NTSB NYC84FA224](https://openairdocs.org/ntsb/NYC84FA224.md): Piper PA-28-180 · Lincoln Park, NJ · Accident · 4 fatal · Field investigation · Final report · Jun 28, 1984 · N4342T · Destroyed
  > The acft collided with the ground shortly after takeoff. A following acft plt said the acft was slow and long on takeoffroll and stayed low after takeoff. The acft made a 90 degree right turn and then a 270 degree left turn and was about lined up to land…
- [NTSB DEN84FA199](https://openairdocs.org/ntsb/DEN84FA199.md): Mooney M20J · Broomfield, CO · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1984 · N3713H · Destroyed
  > The aircraft had been idle for 40 days and was refueled to capacity with 30 gals the night before the flight. Plt and pass were departed at 0819 for a scheduled 0830 meeting 150 miles away. On initial climb, plt reported a power loss. Acft observed to…
- [NTSB ATL84FU005](https://openairdocs.org/ntsb/ATL84FU005.md): Humer Unknown · Carrollton, KY · Accident · 1 fatal · Final report · Jun 28, 1984 · UNREG · Destroyed
  > The ultralight took off from an airstrip and climbed to about 100 ft AGL. At this point the operator turned to the left and a witness noticed the wings rocking until a right turn was established. This turn continued until the vehicle hit the ground. The…
- [NTSB LAX84LA373](https://openairdocs.org/ntsb/LAX84LA373.md): Hiller UH-12E · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1984 · N530HA · Substantial damage
  > After dispensing 8 loads, the plt refueled & took off with the 9th load. About 4 to 6 seconds into the flt, while approaching transitional lift at aprx 6 ft AGL, the helicopter began a vibration & immediately lost rotor RPM. The plt initiated a landing…
- [NTSB ANC84LA105](https://openairdocs.org/ntsb/ANC84LA105.md): Piper PA-32-300 · Ekuk, AK · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1984 · N8941N · Substantial damage
  > The acft collided with a water pipe about 6 ft AGL during takeoff. Witnesses said that the plt did not use all availablerwy. Witnesses also said that he drifted off the rwy centerline after a premature takeoff. The plts employer said that he had warned him at…
- [NTSB SEA84LA145](https://openairdocs.org/ntsb/SEA84LA145.md): Lake LA-4-200 · Levenworth, WA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N65627 · Substantial damage
  > The amphibious acft started to 'porpoise' in the air after takeoff and stalled aprx 25 ft above water level. The acft dragged a wing, crashed and sank. The plt said that water in the hull had caused the unstable condition.
- [NTSB DEN84FA196](https://openairdocs.org/ntsb/DEN84FA196.md): Cessna 172RG · Red Feather Lak, CO · Accident · 3 fatal · Field investigation · Final report · Jun 26, 1984 · N5096R · Destroyed
  > Acft departed downwind into rising terrain with density altitude calculated to be 10,935 ft. acft was observed to mush into rising terrain 300 ft higher than and 3 mi west of the rwy.
- [NTSB CHI84LA262](https://openairdocs.org/ntsb/CHI84LA262.md): Grumman G-164A · Mahnomen, MN · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N6584 · Substantial damage
  > Shortly after taking off, the eng lost power. The plt stated that the eng stopped completely 'like fuel starvation.' He dumped his load of chemicals & made an emergency landing. During the landing, the acft hit a ditch & nosed over. An investigation revealed…
- [NTSB NYC84LA223](https://openairdocs.org/ntsb/NYC84LA223.md): Piper PA-28-140 · Marlboro, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1984 · N40921 · Substantial damage
  > On initial climb after takeoff, plt noted a loss of climb performance, executed steep 180 degree turn to avoid high voltage lines on rising terrain ahead. This maneuver, coupled with reduced power resulted in an airspeed decrease to near stall speed. Plt…
- [NTSB FTW84FA287](https://openairdocs.org/ntsb/FTW84FA287.md): Bell 212 · Galveston, TX · Accident · Minor injuries · Field investigation · Final report · Jun 25, 1984 · N2180J · Substantial damage
  > During takeoff, the helicopter lifted off in an 80% power check & the plt began a northerly departure. Before achieving translational lift, the rotor RPM dropped to aprx 85%. The torque meter indicated a split with the #1 eng indicating about 55% & the #2 eng…
- [NTSB CHI84LA265](https://openairdocs.org/ntsb/CHI84LA265.md): Piper PA-32-260 · Kankakee, IL · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N40712 · Substantial damage
  > The eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.
- [NTSB ATL84LA209](https://openairdocs.org/ntsb/ATL84LA209.md): Cessna T210N · Williamsport, TN · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1984 · N6418N · Destroyed
  > Pilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…
- [NTSB SEA84LA143](https://openairdocs.org/ntsb/SEA84LA143.md): Eipper Quicksilver Mark II · Salem, OR · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N4451T · Substantial damage
  > Plt attempted takeoff on short grass field at gross wt with a OAT of aprx 80 deg f. once airborne the acft drifted to the left of the airstrip. Plt pulled up to clear a fence. After clearing the fence the acft stalled striking the ground with the left wing…
- [NTSB MKC84LA182](https://openairdocs.org/ntsb/MKC84LA182.md): Balloon Works Firefly 7 · Overland Park, KS · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1984 · N4070W · Substantial damage
  > Prior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…
- [NTSB CHI84LA258](https://openairdocs.org/ntsb/CHI84LA258.md): Lake LA-4-200 · Mears, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1984 · N8003H · Substantial damage
  > The pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.
- [NTSB ATL84LA211](https://openairdocs.org/ntsb/ATL84LA211.md): Sikorsky S-55B · Gilbertsville, KY · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 1984 · N90414 · Substantial damage
  > The acft was used for public rides at an amusement park. During the takeoff to ferry the acft back to an overnight parking space the engine quit at 100 ft AGL. The plt said he started the acft and hovered using fuel from the aft fuel tank. When the engine…
- [NTSB NYC84FA218](https://openairdocs.org/ntsb/NYC84FA218.md): Cessna 150M · Keymar, MD · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1984 · N704GV · Destroyed
  > Witness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…
- [NTSB ATL84FKG08](https://openairdocs.org/ntsb/ATL84FKG08.md): Cessna 177RG · Pell City, AL · Accident · No injuries · Final report · Jun 23, 1984 · N7554V · Substantial damage
  > During the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…
- [NTSB ANC84LA098](https://openairdocs.org/ntsb/ANC84LA098.md): Aeronca 15AC · Healy, AK · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N1210H · Substantial damage
  > Shortly after lifting off from an airstrip, the eng lost power. The plt tried to make an emergency landing on a highway, but was unable to reach it. The acft was damaged when he landed in the tops of trees. The reason for the power loss was not found.
- [NTSB FTW84LA281](https://openairdocs.org/ntsb/FTW84LA281.md): Cessna 150G · Ennis, TX · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N2204J · Substantial damage
  > After the plt experienced a rough running eng while doing touch & go landings he executed a precautionary ldg. Upon rollout the acft nosed over in a ditch & came to rest inverted. Post crash examination of the eng revealed no evidence of a mechanical failure…
- [NTSB SEA84FA139](https://openairdocs.org/ntsb/SEA84FA139.md): Piper PA-28-181 · Burley, WA · Accident · 1 fatal · Field investigation · Final report · Jun 21, 1984 · N6950J · Destroyed
  > The non-rated plt was employed as an acft cleaner & had access to the ignition keys of several acft, including N6950J. Earlier during the evening, he was seen consuming beer. At about 0024 PDT, he took off from rwy 18. About 1 min later, the acft collided…
- [NTSB MIA84FA190](https://openairdocs.org/ntsb/MIA84FA190.md): Cessna 182P · Chattahoochee, FL · Accident · Serious injuries · Field investigation · Final report · Jun 21, 1984 · N21335 · Destroyed
  > During the takeoff climb at an altitude of aprx 100 AGL, the acft entered a right diving turn. It impacted the ground and came to rest in a wooded area to the right of the rwy departure end. The plt stated the engine was operating normally. The acft is equipt…
- [NTSB ANC84LA096](https://openairdocs.org/ntsb/ANC84LA096.md): Taylorcraft F19 · Rainbow Lake, AK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N3694T · Destroyed
  > The plt stated that the acft 'was sluggish getting on the step. After lift-off it still performed under par. We cleared the hills and trees. On the downside of the hill we hit a downdraft. We hit the trees nose high; climb power.' The reported wind was calm.…
- [NTSB LAX84FA361](https://openairdocs.org/ntsb/LAX84FA361.md): Cessna 404 · San Francisco, CA · Accident · No injuries · Field investigation · Final report · Jun 20, 1984 · N5340J · Substantial damage
  > The nose baggage door of the acft came open right after the gear was raised during takeoff. The plt said the acft began to pitch up & roll right. He felt that control of the acft was in doubt, so he aborted the intersection takeoff & landed gear-up on the…

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

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

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