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

## Cases, newest first

- [NTSB MIA85LA183](https://openairdocs.org/ntsb/MIA85LA183.md): Centrair Pegase 101A · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1985 · N3TE · Substantial damage
  > The plt stated that on initial climb, realizing he had no elevator control, released the tow rope than deployed the spoilers and collided with the ground. Post crash examination of the wreckage revealed the elvator cable was not connected.
- [NTSB FTW85LA242](https://openairdocs.org/ntsb/FTW85LA242.md): Bellanca 17-30A · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N39854 · Substantial damage
  > Shortly after liftoff, the plt first smelled, then observed smoke coming into the cockpit from under the instrument panel. Shortly thereafter, the eng quit completely. The plt made a forced landing in an open area off the rwy. During the landing roll, the…
- [NTSB FTW85FA244](https://openairdocs.org/ntsb/FTW85FA244.md): Cessna 152 · Bogalusa, LA · Accident · 1 fatal · Field investigation · Final report · Jun 2, 1985 · N5097H · Destroyed
  > A few minutes after departure the student plt flew into the ground in an effort to return to the arpt about 1400 ft n of rwy 18 in aprx a 15 deg nose down and 35 deg left angle of bank. The afct slid about 80 ft when it rotated about it's right wing flipping…
- [NTSB DEN85LA150](https://openairdocs.org/ntsb/DEN85LA150.md): Piper PA-18-135 · Cut Bank, MT · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N2491A · Substantial damage
  > The purpose of the flt was to clean the acft spray sys. The plt reported that he initiated a downhill/donwind takeoff in winds that were light, but gusting. At lift-off, the plt lost directional control & the acft mushed & crashed. The plt believed the…
- [NTSB CHI85LA220](https://openairdocs.org/ntsb/CHI85LA220.md): Cessna 150H · Montevideo, MN · Accident · No injuries · Limited investigation · Final report · Jun 2, 1985 · N6458S · Destroyed
  > The purpose of the flt was to demonstrate the acft to a possible buyer. While taking off, the eng lost power shortly after the acft lifted off at about mid-field. The plt attempted to turn the acft & land on a cross-runway. However, due to his low speed & low…
- [NTSB FTW85LA240](https://openairdocs.org/ntsb/FTW85LA240.md): Champion 7GCAA · Hillsboro, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1985 · N7595F · Destroyed
  > The pilot had just taken off on runway 16 at the municipal airport in Hillsboro, TX. This wind, as reported by the pilotwas 220 degrees at 16 knots with gusts to 22 knots and the temperature was 102 degrees. Two persons and 16 gallons of fuel were aboard.…
- [NTSB ATL85MA177](https://openairdocs.org/ntsb/ATL85MA177.md): Gulfstream G-159 · Nashville, TN · Accident · 2 fatal · Major investigation · Final report · Jun 1, 1985 · N181TG · Destroyed
  > The acft was being operated as general aviation flt 115 & was deptg on a routine night flt. Drg takeoff/initial climb, the left eng lost pwr. The flt crew attempted to cont the climb-out, but following the application of water-methanol, the plt lost drctnl…
- [NTSB SEA85LA126](https://openairdocs.org/ntsb/SEA85LA126.md): Hiller UH-12E · Athena, OR · Accident · No injuries · Limited investigation · Final report · May 31, 1985 · N37HS · Destroyed
  > The acft settled back to the ground shortly after takeoff before achieving translatioanal lift. The plt was attempting to test a new spray unit that had been installed. He had put 80 gallons of water in the spray tanks.
- [NTSB NYC85LA137](https://openairdocs.org/ntsb/NYC85LA137.md): Piper PA-28-235 · Batavia, NY · Accident · No injuries · Limited investigation · Final report · May 30, 1985 · N8966W · Substantial damage
  > The acft was substantially damaged during a forced landing following a loss of pwr on initial takeoff climb. The plt reported that at an alt of aprx 100 ft AGL, the eng quit operating. A forced landing was made 100 yrds off the end of rwy 28. Inspection of…
- [NTSB LAX85LA263](https://openairdocs.org/ntsb/LAX85LA263.md): Cessna TR 182 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · May 29, 1985 · N737YN · Destroyed
  > During initial climb on a dual instructional flight a fire erupted behind the instrument panel & the acft was returned for landing. During roll out 6 inch long flames, smoke & noxious fumes filled the cockpit. When the acft slowed to 10 mph the plts exited…
- [NTSB NYC85FA136](https://openairdocs.org/ntsb/NYC85FA136.md): Cessna C172P · Fryeburg, ME · Accident · 4 fatal · Field investigation · Final report · May 28, 1985 · N53809 · Destroyed
  > The acft crashed in an uncontrolled attitude near the rwy from which it had recently departed. There was a 40 degree down swath cut through the trees to a crater in the ground. The engine was removed from the crash site and examined and nothing was found to…
- [NTSB FTW85LA234](https://openairdocs.org/ntsb/FTW85LA234.md): Piper PA-36-400 · Cheneyville, LA · Accident · Minor injuries · Limited investigation · Final report · May 28, 1985 · N9907P · Substantial damage
  > The plt stated he had attempted to take off in a left quartering tailwind with a 1200 lb load of seed rice. Witnesses stated that the acft began a shallow turn and the nose dropped. The plt regained control of the acft, but it contacted the ground in a level…
- [NTSB MKC85LA116](https://openairdocs.org/ntsb/MKC85LA116.md): Eaa Biplane BI-PLANE · Jamestown, MO · Accident · No injuries · Limited investigation · Final report · May 26, 1985 · N30079 · Substantial damage
  > While practicing touch & go landings in a fld which was partially cleared, the main gear became entangled in wheat which bordered the edge of the cleared area. The plt stated he misjudged the distance needed to clear the obstacle.
- [NTSB BFO85FA048](https://openairdocs.org/ntsb/BFO85FA048.md): Rockwell 112B · Woodbridge, VA · Accident · 5 fatal · Field investigation · Final report · May 26, 1985 · N1417J · Destroyed
  > On may 26,1985,at approximately 1240 hrs EDT,a Rockwell international commander 1120,N1417J,collided with trees aft tkof fm Woodbridge arpt in Woodbridge,VA. The acft was destroyed drng the post impact fire and the put plt and 4 pax all suffered fatal…
- [NTSB MKC85LA113](https://openairdocs.org/ntsb/MKC85LA113.md): Beech 65-88 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · May 25, 1985 · N8833B · Substantial damage
  > Plt reported that the rt eng began to run rough and backfire as the flt was climbing thru 400 ft AGL after takeoff. Moments later the rt eng fire warning light illuminated and the plt secured the eng and landed. The fire warning light went out prior to…
- [NTSB DEN85LA143](https://openairdocs.org/ntsb/DEN85LA143.md): Cessna 340A · Englewood, CO · Accident · No injuries · Limited investigation · Final report · May 25, 1985 · N111SC · Substantial damage
  > On may 24, 1985, a Cessna 340, landed gear up off the runway at contennial arpt, Englewood, CO. The single eng ILS apch and 2 eng missed apch was planned. The instructor simulated the loss of the right eng at the outer marker by turning off the fuel supply.…
- [NTSB CHI85FET02](https://openairdocs.org/ntsb/CHI85FET02.md): Piper PA-28-140 · Nappanee, IN · Accident · Minor injuries · Final report · May 25, 1985 · N15074 · Substantial damage
  > The acft nosed over during a forced landing in a field following a loss of pwr on initial climb from a touch & go landing. Post accident inspection revealed the throttle lever could rotate on the throttle shaft despite the attaching bolts being tight and…
- [NTSB SEA85FA122](https://openairdocs.org/ntsb/SEA85FA122.md): Beech V35 · Spokane, WA · Accident · 3 fatal · Field investigation · Final report · May 24, 1985 · N3778Q · Destroyed
  > After what appeared to be a normal takeoff and initial climb, witnesses observed the acft level off at about 200 ft AGL and some heard sounds of power cessation. Acft was oberved to commence a left turn during which the bank increased to an excessive angle.…
- [NTSB NYC85FHJ02](https://openairdocs.org/ntsb/NYC85FHJ02.md): Piper PA-38-112 · Westhampton Bch, NY · Accident · Minor injuries · Final report · May 21, 1985 · N26005 · Substantial damage
  > The acft landed in a fence after hitting a pwr line and trees during a forced lndg after takeoff. The eng lost power after a 10 min delay for ATC clearance due to a military exercise. The plt said he believed that carb ice formed during the ground wait for…
- [NTSB MKC85LA106](https://openairdocs.org/ntsb/MKC85LA106.md): Beech B35 · Harper, KS · Accident · Minor injuries · Limited investigation · Final report · May 20, 1985 · N8788A · Substantial damage
  > Plt stated rt wing dropped when acft was 4 to 5 ft AGL after liftoff. When plt corrected for low right wing, the acft over-corrected to the left. Acft was then completely uncontrollable and it veered left off the runway heading and mushedto the ground. After…
- [NTSB DEN85LA138](https://openairdocs.org/ntsb/DEN85LA138.md): Cessna 150H · Clovis, NM · Accident · Minor injuries · Limited investigation · Final report · May 20, 1985 · N50011 · Substantial damage
  > The owner of the acft had not flown recently, so he got an instructor plt (CFI) to accompany him. The owner preflighted the acft, did a normal run-up & initiated a takeoff. Shortly after lift-off, the eng began to intermittently run rough. It then quit…
- [NTSB ATL85FA170](https://openairdocs.org/ntsb/ATL85FA170.md): Bell 206L · Duluth, GA · Accident · 2 fatal · Field investigation · Final report · May 20, 1985 · N403DC · Destroyed
  > After loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…
- [NTSB MKC85FA105](https://openairdocs.org/ntsb/MKC85FA105.md): Beech E-90 · Pine Bluff, AR · Accident · Minor injuries · Field investigation · Final report · May 19, 1985 · N575HC · Destroyed
  > A simulated eng failure was initiated by the chk airman at 200 AGL. The plt followed the emergency procedures and advanced the pwr levers to bring pwr back to the engine. The plt then noticed the eng failed and had insufficient alt to get an air restart. The…
- [NTSB DEN85LA136](https://openairdocs.org/ntsb/DEN85LA136.md): Cessna 182 · Plankinton, SD · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N5180D · Substantial damage
  > The acft nosed over after a loss of control during takeoff. The plt was using gravel road for takeoff and rotated prematurely to avoid gravel damage. The acft drifted into tall grass and was then pulled into a ditch and fence posts before nosing over.
- [NTSB ATL85LA167](https://openairdocs.org/ntsb/ATL85LA167.md): Piper J3C-65 · Fayetteville, GA · Accident · No injuries · Limited investigation · Final report · May 19, 1985 · N98164 · Substantial damage
  > Shortly after takeoff with a low fuel state, the plt pulled the acft into a steep climb. A pwr loss was experienced and the acft reportedly stalled and spun into a pond on the pvt grass airstrip. Ten pounds of fuel were drained from the acft after the…
- [NTSB NYC85LA207](https://openairdocs.org/ntsb/NYC85LA207.md): Piper PA-18 · Moose River, NY · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N8105D · Destroyed
  > The acft collided with trees during takeoff and crashed. The plt said he encountered turbulence at about 100 ft AGL which' forced' the acft into the trees.
- [NTSB MIA85LA173](https://openairdocs.org/ntsb/MIA85LA173.md): Grumman American AA-5 · High Springs, FL · Accident · No injuries · Limited investigation · Final report · May 17, 1985 · N9541L · Substantial damage
  > The plt stated that he made a normal takeoff with 2200 RPM, but shortly after rotation, the RPM started to decrease & the acft lost altitude & landed in the top of a large oak tree. An investigation revealed that the carburetor inlet finger screen had a 75%…
- [NTSB MIA85LA169](https://openairdocs.org/ntsb/MIA85LA169.md): Cessna 421B · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · May 15, 1985 · N8083Q · Substantial damage
  > During takeoff at Lakeland, FL, the left main wheel assembly separated from the acft & struck the leading edge of the horizontal stabilizer, causing substantial damage. The plt did not know the wheel had come off until he was notified by ATC. He then diverted…
- [NTSB FTW85FA224](https://openairdocs.org/ntsb/FTW85FA224.md): Cessna 310F · Marfa, TX · Accident · 1 fatal · Field investigation · Final report · May 14, 1985 · N5838X · Destroyed
  > The plt experienced a partial pwr loss from the right eng during the takeoff climb and in his haste to circle back and land did not allow the acft to gain alt. He then failed to maintain adequate airspeed and as a result, lost control of the acft and stalled…
- [NTSB DEN85LA133](https://openairdocs.org/ntsb/DEN85LA133.md): Piper PA-36 · Rapelje, MT · Accident · No injuries · Limited investigation · Final report · May 13, 1985 · N44260 · Destroyed
  > The acft settled back to ground contact after reaching an alt (EST by the plt) of 60 ft AGL during takeoff initial climb. The plt stated that he recognized the acft was settling toward the ground & noticed a dissipation of airspeed. The plt said that he then…
- [NTSB FTW85LA219](https://openairdocs.org/ntsb/FTW85LA219.md): Bellanca 17-30A · Corsicana, TX · Accident · No injuries · Limited investigation · Final report · May 12, 1985 · N8203R · Substantial damage
  > The acft received substantial damage during a forced landing following a loss of power as a result of fuel starvation. The plt had selected the left fuel tank for takeoff. The left fuel gage indicated the tank was full when in fact it was empty.
- [NTSB NYC85LA122](https://openairdocs.org/ntsb/NYC85LA122.md): Schweizer SGS-1-26B · Toughkenamon, PA · Accident · No injuries · Limited investigation · Final report · May 11, 1985 · N2401W · Substantial damage
  > The glider was being towed for takeoff & had just become airborne when the canopy came open. The plt tried to latch the canopy, but was unable, so he released the glider from the tow plane. While the plt continued to try to latch the canopy, the glider went…
- [NTSB FTW85LA217](https://openairdocs.org/ntsb/FTW85LA217.md): Champion 7KCAB · Chattanooga, OK · Accident · 1 fatal · Limited investigation · Final report · May 11, 1985 · N5285X · Substantial damage
  > The pilot was tow launching a glider. When about 200 feet above ground level and for unknown reasons the glider suddenly gained unwanted altitude and climbed above the tow plane. This pitched the nose of the tow plane downward before the tow line could be…
- [NTSB FTW85IA221](https://openairdocs.org/ntsb/FTW85IA221.md): Boeing B767-232 · D/Fw Airport, TX · Incident · No injuries · Incident investigation · Final report · May 11, 1985 · N108DL · Minor damage
  > The B767 was on the takeoff roll. The pressure regulator and shutoff valve coupled with the high presure shutoff valve malfunctioned resulting in pressures being developed in the downstream aircraft ducting in excess of 300 psig. A coupling in the air…
- [NTSB DEN85LA132](https://openairdocs.org/ntsb/DEN85LA132.md): Piper PA-28R-180 · Reserve, NM · Accident · No injuries · Limited investigation · Final report · May 11, 1985 · N7439J · Substantial damage
  > Plt stated that shortly after takeoff at an alt of aprx 100 ft AGL, the acft stopped climbing and started descending. Unable to arrest the descent, the plt attempted a forced landing in a field. Prior to touchdown the left main gear contacted the top of a…
- [NTSB CHI85LA196](https://openairdocs.org/ntsb/CHI85LA196.md): Piper J3C-65 · Conneaut, OH · Accident · Minor injuries · Limited investigation · Final report · May 11, 1985 · N42454 · Substantial damage
  > The plt stated that he elected to begin his takeoff roll 300 ft down the rwy due to a mud hole located at that point. During his initial climb, the plt believed the acft might not clear trees at the departure end of the rwy & elected to turn right in an…
- [NTSB LAX85FA251](https://openairdocs.org/ntsb/LAX85FA251.md): Beech A-36 · Hayward, CA · Accident · 1 fatal · Field investigation · Final report · May 10, 1985 · N2022B · Destroyed
  > According to the ATCT tapes, 3 mins elapsed between the time the acft called for taxi from parking to ready for takeoff at the active rwy. Just after liftoff the acft experienced a 'missing' & 'backfiring' engine as reported by witnesses. Plt radioed the…
- [NTSB LAX85LA250](https://openairdocs.org/ntsb/LAX85LA250.md): Rockwell S-2R · Colusa, CA · Accident · No injuries · Limited investigation · Final report · May 9, 1985 · N8929Q · Substantial damage
  > During an ag flight, the eng began to severly backfire & lose power. The plt attempted to make a forced ldg on the nearby duster airstrip but had insufficient altitude to be properly aligned with the rwy. The acft overan the edge of the end disclosed that its…
- [NTSB MKC85LA098](https://openairdocs.org/ntsb/MKC85LA098.md): Hughes 369HS · Malvern, AR · Accident · Minor injuries · Limited investigation · Final report · May 8, 1985 · N9EE · Substantial damage
  > During a powerline construction operation, a ground crew member holding a rope lead line released the rope prematurely as the helicopter became airborne. The nylon rope entangled the main rotor system forcing the plt to lose control of the helicopter. The…
- [NTSB FTW85LA215](https://openairdocs.org/ntsb/FTW85LA215.md): Cessna 210E · Natchitoches, LA · Accident · Serious injuries · Limited investigation · Final report · May 8, 1985 · N2367F · Substantial damage
  > The pilot experienced partial power loss due to ingestion of the alternate air door shaft needle bearing rollers into the engine, and cross firing of the right magneto. He reportedly closed the throttle and made a gear up forced landing. The aircraft slid…
- [NTSB MKC85LA095](https://openairdocs.org/ntsb/MKC85LA095.md): Gulfstream-Schweizer G-164B · Earle, AR · Accident · No injuries · Limited investigation · Final report · May 6, 1985 · N8138K · Substantial damage
  > During takeoff from a farm strip, the eng lost power shortly after lift-off. The plt landed straight ahead; however, during the landing roll, the acft encountered a low, wet area & nosed over. An exam of the eng revealed about a cup of water in the carburetor…
- [NTSB MIA85LA165](https://openairdocs.org/ntsb/MIA85LA165.md): Cessna 310G · Palm City, FL · Accident · No injuries · Limited investigation · Final report · May 6, 1985 · N2903R · Substantial damage
  > The plt reported that shortly after takeoff, the left eng lost power. He was unable to maintain control of the acft, so he reduced power on the right eng & subsequently made an emergency landing in a field. During the landing, the gear collapsed, then the…
- [NTSB MIA85FA166](https://openairdocs.org/ntsb/MIA85FA166.md): Beech E18S · West Palm Bch, FL · Accident · Minor injuries · Field investigation · Final report · May 6, 1985 · N57AE · Substantial damage
  > Drg takeoff from rwy 13, the l eng lost pwr after the acft had climbed to about 200' AGL & accellerated to aprx 125 KTS with the gear & flaps retracted. The plt aborted the takeoff & turned the acft to land on rwy 9. However, it touched dwnin the grass after…
- [NTSB BFO85LA043](https://openairdocs.org/ntsb/BFO85LA043.md): Cessna 140 · Chesapeake, VA · Accident · No injuries · Limited investigation · Final report · May 6, 1985 · N2034V · Substantial damage
  > The student plt was making a takeoff from rwy 20 with an estimated 10 kt right x-wind. After about 800 ft of ground run, the acft lifted off at aprx 65 mph. At an alt of about 30 ft, the acft began to settle in a left drift as it flew abeam trees on the right…
- [NTSB DEN85LA126](https://openairdocs.org/ntsb/DEN85LA126.md): Piper PA-28R-201 · Angle Fire, NM · Accident · Minor injuries · Limited investigation · Final report · May 5, 1985 · N38327 · Substantial damage
  > The plt stated that shortly after takeoff from the 6700 ft long rwy with a density alt of 10400 ft, turbulence was experienced and the airspeed decreased to aprx 70 KTS. Unable to maintain alt, a forced landing was attempted during which the acft contacted a…
- [NTSB CHI85LA189](https://openairdocs.org/ntsb/CHI85LA189.md): Piper PA-38-112 · Tyler, MN · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N2588F · Destroyed
  > Plt stated he was about to abort the takeoff during the long ground run when the acft lifted off. At 30 to 40 ft AGL acft began to sink. Acft contacted a fence post and touched down in a plowed field. Nose gear collapsed and acft nosed over. Plt previously…
- [NTSB CHI85LA188](https://openairdocs.org/ntsb/CHI85LA188.md): Stearman PT 17 · Hamilton, OH · Accident · No injuries · Limited investigation · Final report · May 5, 1985 · N59221 · Substantial damage
  > The pilot was taking off in a 90 degree cross wind of 15 KTS gusts 23 KTS immediatly after liftoff a gust of wind resulted in pilot loss of directional control the acft veered off of the runway struck a ditch and nosed over inverted.
- [NTSB SEA85FA103](https://openairdocs.org/ntsb/SEA85FA103.md): Piper PA-32RT-300T · Seattle, WA · Accident · 3 fatal · Field investigation · Final report · May 4, 1985 · N2173B · Destroyed
  > After liftoff, the plt requested an immediate return for landing stating he, 'smelled smoke/something hot'. Downwind for the precautionary landing was flown at 200 ft AGL, a slow airspeed and close to the runway with a crosswind blowing the acft toward the…
- [NTSB NYC85LA118](https://openairdocs.org/ntsb/NYC85LA118.md): Stinson 108-3 · Erie, PA · Accident · Minor injuries · Limited investigation · Final report · May 3, 1985 · N6114M · Substantial damage
  > The instructor plt (CFI) reported that while he was instructing the student on takeoffs & landing, the eng lost power due to insufficient fuel. Reportedly, the eng lost power shortly after takeoff & the aircrew had to turn to avoid high tension wires during…
- [NTSB LAX85LA231](https://openairdocs.org/ntsb/LAX85LA231.md): Piper PA-23 · Clovis, CA · Accident · Minor injuries · Limited investigation · Final report · May 3, 1985 · N1461P · Substantial damage
  > On initial climb, at 400 ft AGL, the acft's rt engine lost fuel pressure. Then all right engie power was lost. The lt eng continued to operate normally. The plt failed to feather the rt prop & allowed the acft to slow to the point where a mvc roll commenced.…

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

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

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