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

## Cases, newest first

- [NTSB MKC85FCD02](https://openairdocs.org/ntsb/MKC85FCD02.md): Cessna 172 M · Emmetsburg, IA · Accident · Serious injuries · Final report · Sep 8, 1985 · N20517 · Substantial damage
  > The acft crashed in a turkey farm field after losing alt during takeoff. A witness said the acft settled as though the plt was raising the flaps after takeoff. The acft lost alt in a rt turn, and landed 1 mile south of the arpt post acc investigation showed…
- [NTSB LAX85LA383](https://openairdocs.org/ntsb/LAX85LA383.md): Cessna 150K · Huntington Beac, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1985 · N6436G · Destroyed
  > Acft lost power on takeoff from Huntington beach, CA, and crashed landed on the arpt. The acft was destroyed and the plt was not hurt. Examination of the fuel system revealed only 1.6 gals of fuel present.
- [NTSB LAX85FA384](https://openairdocs.org/ntsb/LAX85FA384.md): Beech A36TC · Carson, CA · Accident · No injuries · Field investigation · Final report · Sep 6, 1985 · N3801Z · Substantial damage
  > The acft lost pwr at 1500 ft shortly after departure from compton, CA. The plt performed an emergency landing on a dirt road and the acft contacted a concrete curb. The eng had a Beech mandatory service bulletin no. 2033 completed the day before the accident…
- [NTSB DEN85FTK03](https://openairdocs.org/ntsb/DEN85FTK03.md): Cessna 152 · Tea, SD · Accident · No injuries · Final report · Sep 6, 1985 · N69125 · Substantial damage
  > The student & instructor plt (CFI) were practicing landings. After making 3 touch-&-go landings, the eng lost power at aprx 200 ft AGL as they were on their 4th takeoff. The CFI reported that he turned the acft about 25 deg in an attempt to glide to a bean…
- [NTSB DCA85AA036](https://openairdocs.org/ntsb/DCA85AA036.md): Douglas DC-9-14 · Milwaukee, WI · Accident · 31 fatal · Final report · Sep 6, 1985 · N100ME · Destroyed
  > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…
- [NTSB CHI85LA372](https://openairdocs.org/ntsb/CHI85LA372.md): Piper PA-24-250 · Washington, IL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1985 · N7767P · Substantial damage
  > The plt attempted to takeoff on the 1800 ft long grass airstrip with 3 passengers on board. A 90 deg, 12 kt x-wind was present and the OAT was 91 deg f. after liftoff, the acft settled back on the airstrip and continued off the end into a bean fld where the…
- [NTSB CHI85FEM02](https://openairdocs.org/ntsb/CHI85FEM02.md): Cessna 170A · Fruitport, MI · Accident · Minor injuries · Final report · Sep 6, 1985 · N4169U · Destroyed
  > The acft was destroyed during a precautionary landing after the left side of the eng cowling opened shortly after takeoff. The plt reported the cowling opened at an alt of aprx 50 ft AGL. A climb to 300 ft was made and the acft was turned onto downwind. The…
- [NTSB ANC85IA172](https://openairdocs.org/ntsb/ANC85IA172.md): Cessna C-172P · Scammon Bay, AK · Incident · No injuries · Incident investigation · Final report · Sep 6, 1985 · N65798 · Minor damage
  > The pilot elected to takeoff from the taxiway because it aligned into the wind. After takeoff and accelerating to climb airspeed, the airplane's controls felt mushy and the pilot elected to land on the road/taxiway. Prior to touchdown, a gust of wind forced…
- [NTSB ANC85LA170](https://openairdocs.org/ntsb/ANC85LA170.md): Cessna 180F · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N25722 · Substantial damage
  > The plt reported that immediately after taking off, he seemed to lose aileron control. He decided to abort the takeoff & land on the remaining rwy. After touching down near the departure end, he elected to turn the acft to the left toward an access road…
- [NTSB SEA85LA206](https://openairdocs.org/ntsb/SEA85LA206.md): Cessna 152 · Langley, WA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N24867 · Substantial damage
  > An aborted takeoff from a 2600 foot sod runway as done at about 40 feet AGL. The airstrip is surrounded by high trees. The pilot stated that the aircraft was not developing full power. The engine was run up to full power by an a & p mechanic three days after…
- [NTSB ANC85LA169](https://openairdocs.org/ntsb/ANC85LA169.md): Maule M-5 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N51369 · Substantial damage
  > During takeoff, the eng lost power as the acft was climbing thru aprx 400 ft. the plt made a 180 deg turn to land back on the arpt. However, he then realized that the acft would not reach the rwy, so he turned & landed in a swamp area. An exam of the eng…
- [NTSB MKC85LA205](https://openairdocs.org/ntsb/MKC85LA205.md): Cessna 150-L · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N18604 · Substantial damage
  > The pilot stated that just after takeoff, he lost engine power and when the airplane was landed in a rough soy-bean field, it nosed over to the inverted position. The engine and fuel systems were inspected by an FAA inspector. No reason for the power loss…
- [NTSB MKC85LA206](https://openairdocs.org/ntsb/MKC85LA206.md): Grumman American AA-1C · Montgomery City, MO · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N39061 · Destroyed
  > N39061 collided with trees at the edge of the arpt after takeoff from a 2,380 ft long, turf & gravel rwy. There was on 80' left crosswind at 10 KTS and the density alt was 3,000 ft. the arpt operator said the acft became airborne at a slower than normal speed…
- [NTSB MIA85IA242](https://openairdocs.org/ntsb/MIA85IA242.md): Smith, Ted Aerostar PA-600 · Sarasota, FL · Incident · No injuries · Incident investigation · Final report · Aug 30, 1985 · N47GP · Minor damage
  > While on takeoff initial climb the right engine hydraulic pump shaft failed and the pilot did not receive a positive uplock. The pilot then selected gear down and did obtain a gear down indication. On landing the nose gear collapsed. Nose gear down locks were…
- [NTSB MKC85LA196](https://openairdocs.org/ntsb/MKC85LA196.md): Cessna 172 M · Gravois Mills, MO · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N6982H · Substantial damage
  > The plt reports that he began his takeoff on rwy 07 which is 2550 ft long, has an asphalt surface and a downhill slope. Plt said the rwy is rough. He said the acft did not achieve the speed desired and he reduced power to abort. He then decided to attempt the…
- [NTSB SEA85LA204](https://openairdocs.org/ntsb/SEA85LA204.md): Welch Avid Flyer · Bonner'S Ferry, ID · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N64LW · Substantial damage
  > The plt reported that during takeoff, the eng seized as the acft was climbing thru about 350 ft AGL over the end of the rwy. He stated that the acft was in a maximum climb when the eng seized & immediately went into a power off stall. He recovered from the…
- [NTSB NYC85LA224](https://openairdocs.org/ntsb/NYC85LA224.md): Piper PA-28-140 · Central Square, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1985 · N4252J · Destroyed
  > The plt stated the acft would not climb out of ground effect during takeoff. He flew the acft between trees at the end of the rwy and severed the wings from the fuselage. The acft was found to be 317 lbs over gross weight.
- [NTSB NYC85FA222](https://openairdocs.org/ntsb/NYC85FA222.md): Ercoupe 415-C · Carlisle, PA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 1985 · N3064H · Destroyed
  > During the second takeoff attempt from a pvt grass strip witnesses heard the eng sputter then quit soon after liftoff. The acft then descended to ground impact and burned. The acft had not been flown adn was kept out of doors for several months while the…
- [NTSB LAX85LA371](https://openairdocs.org/ntsb/LAX85LA371.md): Aeronca 7AC · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1985 · N2877E · Substantial damage
  > Witnesses stated that the acft was observed in a nose high attitude followed by an apparent stall and subsequent impact into a river bed.
- [NTSB FTW85LRD04](https://openairdocs.org/ntsb/FTW85LRD04.md): Cessna A188B · Rayville, LA · Accident · No injuries · Final report · Aug 27, 1985 · N731LX · Destroyed
  > The acft contacted the terrain in a cotton fld during an uncontrolled descent which occurred on takeoff. The plt was test flying the acft in anticipation of possibly purchasing it. The plt reported that when aprx 1/2 the way down the rwy the acft did not…
- [NTSB CHI85FEE04](https://openairdocs.org/ntsb/CHI85FEE04.md): Jauch Coot/Amphib · Mendota, IL · Accident · Minor injuries · Final report · Aug 26, 1985 · N81KX · Destroyed
  > The acft touched down in a bean fld during a forced landing following a loss of pwr on takeoff. The plt reported the acft had low pwr during the takeoff run, however, he elected to continue the takeoff and make a 180 deg turn back to the airstrip. Once…
- [NTSB FTW85FQG02](https://openairdocs.org/ntsb/FTW85FQG02.md): Piper PA-28-140 · Big Spring, TX · Accident · No injuries · Final report · Aug 24, 1985 · N7401R · Destroyed
  > The acft cockpit/cabin filled with smoke after takeoff. The plt & passg smelled an odor of electrical wiring burning and saw fire at the firewall near the rudder pedals. The acft was turned 180 degrees and landed on rwy 35. The 2 occupants immediately…
- [NTSB LAX85IA370](https://openairdocs.org/ntsb/LAX85IA370.md): Beech B19 · Van Nuys, CA · Incident · No injuries · Incident investigation · Final report · Aug 23, 1985 · N9718L · Minor damage
  > After departure, at about 800 feet, the right airleron became disconnected. The pilot was able to make a left turn, fly a left hand traffic pattern and land successfully. Examination of the aircraft revealed that the right inboard aileron control push rod had…
- [NTSB FTW85LPJ03](https://openairdocs.org/ntsb/FTW85LPJ03.md): James/Viking Dragonfly · Okmulgee, OK · Accident · No injuries · Final report · Aug 23, 1985 · N45CJ · Substantial damage
  > The acft bounced 3 times during a landing after the engine failed to preduce full power for takeoff. After the 3rd bounce the rt canard broke off at the fuselage. The plt stated that the fuel filter was found to be blocked by some type of residue.
- [NTSB DEN85FTM06](https://openairdocs.org/ntsb/DEN85FTM06.md): Mitchell/Bede BD-4 · Woods Cross, UT · Accident · Minor injuries · Final report · Aug 23, 1985 · N711JK · Substantial damage
  > The acft crashed after the eng quit during takeoff. The acft hit the ground off the arpt in a left descending bank which collapsed the left lndg gear. Investigation revealed corrosion of the carburetor float bowl. The plt was using auto fuel. The fuel tanks…
- [NTSB MIA85LA237](https://openairdocs.org/ntsb/MIA85LA237.md): Bell 47D1 · Panama City Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1985 · N4253A · Substantial damage
  > The helicopter contacted a fence and slid nose down into a ravine during a forced landing. The plt reported that after takeoff at an alt of 35 to 40 ft AGL, a load bang was heard and gray/white smoke was emitted from the transmission/eng area. The throttle…
- [NTSB CHI85FEM01](https://openairdocs.org/ntsb/CHI85FEM01.md): Skyranger Silver Cloud · Bellaire, MI · Accident · Serious injuries · Final report · Aug 22, 1985 · N210JT · Substantial damage
  > The acft crashed after colliding with wires during a forced landing after a power loss during climbout. The plt. Builder had rigged a temporary plastic fuel container on the cockpit floor because the main wing tanks had not been installed. This floor tank was…
- [NTSB NYC85LA218](https://openairdocs.org/ntsb/NYC85LA218.md): Piper PA-18-95 · Millinocket, ME · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · N3287Z · Substantial damage
  > The plt reported that he was departing from south twin lake in winds that were from 270 deg at 12 gusting 20 KTS. After the acft lifted off the water, he started a slight turn. He stated that at about that time, a gust of wind simultaneously lifted the nose &…
- [NTSB FTW85LA329](https://openairdocs.org/ntsb/FTW85LA329.md): Bellanca 17-30A · Coushatta, LA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1985 · N4026B · Substantial damage
  > Acft experienced a complete engine failure shortly after takeoff while at an altitude of approx 500' AGL. It was substantially damaged when it ran thru 2 fences during the ensuing forced landing. Investigation revealed that the eng fuel pump ejector nozzle…
- [NTSB FTW85FRD03](https://openairdocs.org/ntsb/FTW85FRD03.md): Advanced Technology Predator 480 · Welsh, LA · Accident · Minor injuries · Final report · Aug 21, 1985 · N480AG · Destroyed
  > The acft impacted the terrain in an uncontrolled descent during the initial takeoff climb. The plt reported that after takeoff at an alt of aprx 20 ft AGL, the acft rolled 20 to 25 degs to the right. After correcting for the roll, the plt stated, the acft…
- [NTSB FTW85LA326](https://openairdocs.org/ntsb/FTW85LA326.md): Piper PA-24-250 · Farmerville, LA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1985 · N8050P · Substantial damage
  > The plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…
- [NTSB BFO85LA069](https://openairdocs.org/ntsb/BFO85LA069.md): Cessna 182P · Holly Grove, VA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1985 · N69814 · Substantial damage
  > After takeoff, the acft lost pwr approximately 150 feet AGL. The plt added carburetor heat and turned the acft back towards gvm spring airport, gum spring, Virginia, but an emergency landing was executed in a short pasture, approximately 100 yards short of…
- [NTSB NYC85LA216](https://openairdocs.org/ntsb/NYC85LA216.md): Piper PA-32-300 · Provincetown, MA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N15805 · Substantial damage
  > Plt experience eng pwr loss during tke climb at a height of about 350 ft. the plt headed toward a beach and ditched about 50 yards offshore in order to avoid crowd. The acft submerged underwater afterwards. Examination of the acft disclosed leadlike…
- [NTSB NYC85LA215](https://openairdocs.org/ntsb/NYC85LA215.md): Bell BH206L-1 · Hawley, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1985 · N100FH · Substantial damage
  > The helicopter arrived at a private residence to transport race car drivers to the pocono raceway. During departure the pilot failed to see powerlines in the flight path that contacted the main rotor system. The main rotor system failed and the helicopter…
- [NTSB LAX85LA354](https://openairdocs.org/ntsb/LAX85LA354.md): Cessna 182Q · Safford, AZ · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N735TQ · Substantial damage
  > The aircraft experienced a partial engine power loss after departing Safford municipal airport on a VFR personal flt to sky harbor arpt, phoenix, AZ. The plt negotiated an emerg lndg in a flt brush area. Prior to touchdown the acft struck a mesquite tree and…
- [NTSB ANC85LA153](https://openairdocs.org/ntsb/ANC85LA153.md): Stinson 10A · Wasilla, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1985 · N34656 · Substantial damage
  > The acft contacted trees during a forced landing following a loss of pwr which resulted from fuel exhaustion during an initial takeoff climb. The plt attempted to land on a road, however, when a car pulled onto the road, the plt flew the acft into trees. Only…
- [NTSB MKC85LA190](https://openairdocs.org/ntsb/MKC85LA190.md): Pezetel M18 Dromader · Wilmot, AR · Accident · No injuries · Limited investigation · Final report · Aug 17, 1985 · N2620N · Substantial damage
  > At lift-off fm a private ag-strip the plt experienced an abrupt right yaw. The plt stated he compensated with left pedal to maintain straight and level flt. The plt stated he was unable to maintain altitude and dropped his load of chemical during which the…
- [NTSB FTW85LA324](https://openairdocs.org/ntsb/FTW85LA324.md): Douglas TB-26B · Pattonville, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1985 · N190M · Destroyed
  > The acft had not flown for two years and was being checked out for a ferry flt to the U.S. Air force air museum in fargo, ND. During initial climb from cox field at paris, TX, the left eng lost total pwr and the right eng lost partial pwr. An off arpt forced…
- [NTSB ANC85LA152](https://openairdocs.org/ntsb/ANC85LA152.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 17, 1985 · N3365M · Substantial damage
  > The plt reported sufficient alt could not be obtained to clear trees during takeoff. The acft stalled and the right wing contacted the water resulting in the acft cartwheeling. Investigation revealed the acft was over gross weight and CG was beyond the aft…
- [NTSB CHI85LA349](https://openairdocs.org/ntsb/CHI85LA349.md): Piper PA-20 · Bay City, MI · Accident · No injuries · Limited investigation · Final report · Aug 16, 1985 · N7665K · Substantial damage
  > The acft was damaged during a hard forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 250 ft AGL, the eng quit. Post accident inspection revealed the fuel selector was positioned on the right tank which…
- [NTSB FTW85LA322](https://openairdocs.org/ntsb/FTW85LA322.md): Cessna A188B · Cushing, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1985 · N21814 · Destroyed
  > The plt was test flying the acft after a major eng overhaul.a left turn was made away from the arpt after takeoff and immediately thereafter the eng lost pwr. With no suitable landing area within gliding distance, the acft was manuevered straight ahead where…
- [NTSB DEN85LA219](https://openairdocs.org/ntsb/DEN85LA219.md): Cessna C-172 · Killdeer, ND · Accident · No injuries · Limited investigation · Final report · Aug 15, 1985 · N7202A · Substantial damage
  > The plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…
- [NTSB CHI85LA345](https://openairdocs.org/ntsb/CHI85LA345.md): Cessna 140 · Almont, MI · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N76465 · Destroyed
  > After takeoff and about 300 ft AGL the plt said his eng stopped briefly restarted then stopped. He landed in a cow pasture and to avoid hitting the cows landed hard on the left gear and engine. The acft then nosed over inverted.
- [NTSB ATL85LA247](https://openairdocs.org/ntsb/ATL85LA247.md): Cessna 188 · Dyersburg, TN · Accident · No injuries · Limited investigation · Final report · Aug 14, 1985 · N8295G · Substantial damage
  > During the third takeoff the pilot failed to obtain and maintain flying speed and crashed in a field off the departure end of the ag strip.
- [NTSB BFO85FA068](https://openairdocs.org/ntsb/BFO85FA068.md): Piper PA-20-125 · Culpeper, VA · Accident · 4 fatal · Field investigation · Final report · Aug 13, 1985 · N7372K · Destroyed
  > Witnesses stated that the takeoff roll began about 2000 ft from the departure end of the 2300 ft sod rwy. The a/c lifted off from a 3-point attitude and climbed at a high angle of attack, 'mushing along' until it fell off on the rt wing and struck the ground…
- [NTSB SEA85LA195](https://openairdocs.org/ntsb/SEA85LA195.md): Stinson 108-3 · Vashon, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1985 · N6162M · Destroyed
  > Plt reported a loss of power on initial climb from takeoff; stalled acft while manuvering for best lndg place in orchard. Fire broke out as occupants evacuated the act. Consuming most of the cabin/fuselage. Investigation failed to reveal cause of power loss.
- [NTSB DEN85FA214](https://openairdocs.org/ntsb/DEN85FA214.md): Piper PA-60-600 · Denver, CO · Accident · Serious injuries · Field investigation · Final report · Aug 11, 1985 · N3643R · Destroyed
  > Pilot in command stated that he waited aprx 90 seconds after a B-727 departed on rwy 8R due to possible wake turbulence. Plt continued to state that he used a short field takeoff procedure to climb above the flt path of the B-727. He stated that during…
- [NTSB ATL85FA243](https://openairdocs.org/ntsb/ATL85FA243.md): Cessna 150G · Selma, AL · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1985 · N4608X · Destroyed
  > Acft took off from sod strip on hot humid day near max weight. PIC said he used 10 degrees flaps and was airborne. At about runway mid point. When over first tree line after passing threshold acft descended. When over brown terrain acft climbed. When over…
- [NTSB FTW85LA311](https://openairdocs.org/ntsb/FTW85LA311.md): Cessna 172M · Pearland, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1985 · N1518V · Destroyed
  > The acft contacted a ditch during a forced landing. According to the plt, the takeoff and climb were normal until the acft reached aprx 120 ft AGL when the eng quit as if the ignition key was turned off. The arpt elevation is 51 ft MSL. The rwy is asphalt…
- [NTSB DEN85LA216](https://openairdocs.org/ntsb/DEN85LA216.md): Schempp-Hirth Ventus B · Colorado Sprgs, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1985 · N25RN · Substantial damage
  > During takeoff the glider left wing touched the ground. The glider then cartwheeled sustaining substantial damage.

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

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

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