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

## Cases, newest first

- [NTSB CHI85IA101](https://openairdocs.org/ntsb/CHI85IA101.md): Mcdonnell Douglas DC-9-31 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jan 31, 1985 · N8959E · No damage
  > The aborted takeoff that began this sequence was due to engine inlet icing. Moisture from the wet ramp was ingested into the engines as the acft taxied to the runway. No engine anti-ice was used because no visible moisture existed. Following the abort the…
- [NTSB ATL85MA083](https://openairdocs.org/ntsb/ATL85MA083.md): Lockheed 188C · Dobbins Afb, GA · Accident · No injuries · Major investigation · Final report · Jan 29, 1985 · N854U · Substantial damage
  > During gear retraction after takeoff, the right main gear became jammed in a partially retracted psn & the respective in-transit gear light would not extinguish. Attempts to recycle the gear were unsuccessful. The flt crew diverted to atlanta, GA; then…
- [NTSB DEN85LA071](https://openairdocs.org/ntsb/DEN85LA071.md): Beech 76 · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 1985 · N1850S · Substantial damage
  > On Sunday 1/27/85 at approximately 0849 MST, a Beech DUCHESSN1850S, on lease to the university of north dakota crashed after takeoff from the Grand Forks airport, Grand Forks, ND.the student pilot and certified flight instructore were not injured. Two…
- [NTSB CHI85FA096](https://openairdocs.org/ntsb/CHI85FA096.md): Cessna 150L · Wheeling, IL · Accident · No injuries · Field investigation · Final report · Jan 23, 1985 · N11413 · Substantial damage
  > At about 400 ft AGL during takeoff, the eng lost all power. The plt was able to regain partial power for aprx 20 sec, by 'milking' the throttle, then the eng stopped again. To avoid power lines & factories ahead, the plt turned back & landed on arpt property.…
- [NTSB DCA85AA010](https://openairdocs.org/ntsb/DCA85AA010.md): Lockheed 188C · Reno, NV · Accident · 70 fatal · Final report · Jan 21, 1985 · N5532 · Destroyed
  > Shortly after galaxy airlines flt 203 lifted off from rwy 16R, the coplt transmitted that they would like to 'make a left downwind, we gotta get back on the ground.' He then rprtd that there was a hvy vibration in the acft. Flt 203 was cleared as requested,…
- [NTSB MIA85LA083](https://openairdocs.org/ntsb/MIA85LA083.md): Bell 206L-1 · Loiza, PR · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N5736K · Substantial damage
  > The helicopter plt had just discharged his passengers following a flt from an off-shore barge to a beach heliport. When he lifted off & started to cross over a fence, the eng lost partial power. The plt tried to avoid the obstruction, but the tail boom hit…
- [NTSB LAX85LA114](https://openairdocs.org/ntsb/LAX85LA114.md): Cessna 172E · San Carlos, AZ · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N3820S · Substantial damage
  > The student plt over rotated the acft while practicing a soft field takeoff. In an attempt to gain airspeed the acft stalled and impacted the rwy.
- [NTSB MIA85LA082](https://openairdocs.org/ntsb/MIA85LA082.md): Piper PA-31-350 · Key West, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1985 · N70CZ · Destroyed
  > The acft crashed into the ocean shortly after takeoff on an unautorized flt. The plt was a student plt who worked as a refueler of acft. The student plt took the unattended parked acft without permission and went for a solo flt at sometime around 0200 hrs.…
- [NTSB DEN85IA065](https://openairdocs.org/ntsb/DEN85IA065.md): Boeing 727-224 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Jan 17, 1985 · N79748 · Minor damage
  > Acft struck a seawall dike immediately after takeoff from runway 13 at la guadia airport, Flushing, NY. Acft continued on to denver, co where uneventful landing was made. Post-flight inspection revealed minor damage to tailskid and number 2 engine thrust…
- [NTSB BFO85FA013](https://openairdocs.org/ntsb/BFO85FA013.md): Aerospatiale SA 360C · Washington, DC · Accident · Minor injuries · Field investigation · Final report · Jan 17, 1985 · N42CP · Substantial damage
  > The flt crew rprtd the eng lost pwr when the helicopter was at aprx 100' with a fwd speed of 50 KTS. Witnesses observed faint gray/white smoke emanating from the vicinity of the tailpipe shortly after lift off which trailed & became profuseimmediately before…
- [NTSB MKC85LA048](https://openairdocs.org/ntsb/MKC85LA048.md): Raven Rally RX7 · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Jan 16, 1985 · N55582 · Substantial damage
  > Balloon encountered gust during initial climb and began drifting toward wires. Plt elected to deflate & balloon collided with wires & building.
- [NTSB SEA85FA043](https://openairdocs.org/ntsb/SEA85FA043.md): Piper PA-28-140D · Kent, WA · Accident · 1 fatal · Field investigation · Final report · Jan 14, 1985 · N679FL · Destroyed
  > The acft contacted trees and the terrain aprx 1/2 mile south of the arpt shortly after takeoff. Witnesses stated the eng was running rough and black smoke was trailing from the exhaust during the takeoff. Examination of the eng revealed the spark plugs were…
- [NTSB CHI85IA091](https://openairdocs.org/ntsb/CHI85IA091.md): Beech H-18 · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Jan 14, 1985 · N135W · Minor damage
  > The acft was rotated prematurely and stalled back onto the rwy. The acft was on rwy 24L and the wind was 240 degrees at 17 KTS gusting to 24 KTS. There was slight damage to the landing gear & flaps
- [NTSB MKC85LA047](https://openairdocs.org/ntsb/MKC85LA047.md): Cessna 172N · Vermillion, KS · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1985 · N5649E · Substantial damage
  > On takeoff roll acft traveled through soft snow resulting in a loss of forward speed. Plt was able to continue lift off but acft settled into a plowed field just past the end of the rwy and subsequently nosed over.
- [NTSB CHI85LA088](https://openairdocs.org/ntsb/CHI85LA088.md): Piper PA-28-161 · Troy, MI · Accident · No injuries · Limited investigation · Final report · Jan 13, 1985 · N8444D · Substantial damage
  > The acft collided with a sign during a forced lndg after a loss of power that occurd during initial climb at an alt of 400 ft AGL. The plt stated that the eng began to run rough and with the application of carb heat the eng quit. A post accident eng run-up…
- [NTSB MIA85FA077](https://openairdocs.org/ntsb/MIA85FA077.md): Beech A36TC · Boca Raton, FL · Accident · 1 fatal · Field investigation · Final report · Jan 11, 1985 · N3872D · Destroyed
  > The acft crashed in a steep uncontrolled descent shortly after the eng lost power during the initial takeoff climb. Witnesses stated that the acft was seen departing on rwy 4 after which it climbed to 200 ft AGL (aprx). The eng was heard sputtering but still…
- [NTSB ANC85LA034](https://openairdocs.org/ntsb/ANC85LA034.md): Cessna 207 · Mt Village, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1985 · N9946M · Substantial damage
  > Takeoff was performed downhill on the ice covered 2200 ft gravel airstrip. Plt stated liftoff was late but given the surrounding terrain, the takeoff was continued rather then aborted. During climb the acft contacted the roof of an abandoned building. Acft…
- [NTSB DEN85FA062](https://openairdocs.org/ntsb/DEN85FA062.md): Cessna 404 · Salt Lake City, UT · Accident · No injuries · Field investigation · Final report · Jan 8, 1985 · N2681B · Substantial damage
  > The plt departed rwy 34L at Salt Lake City international airport in IMC. There was moderate snowfall at the time. The plt said that shortly after lifing off, at an alt of aprx 200 feet AGL, both engines began running rough. All eng instruments were said to be…
- [NTSB MIA85IA074](https://openairdocs.org/ntsb/MIA85IA074.md): Cessna C-402 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jan 7, 1985 · N60SA · Minor damage
  > On 1/7/85 at about 0750 EST, N60SA, a Cessna 402 landed leftmain gear collapsed, on a commuter air taxi, positioning flight at maimi, FL. VMC prevailed at the time an IFR flight plan was filed. The aircraft received minor damage and the pilot, the sole…
- [NTSB LAX85FA097](https://openairdocs.org/ntsb/LAX85FA097.md): Cessna 182P · El Monte, CA · Accident · No injuries · Field investigation · Final report · Jan 5, 1985 · N58816 · Substantial damage
  > Shortly after takeoff at an alt of aprx 300 ft AGL, a ttl loss of pwr was experienced. The plt attempted a forced landing in a residential area but upon realizing the area was too congested, the acft was intentionally landed in a large tree. Post accident…
- [NTSB SEA85LA038](https://openairdocs.org/ntsb/SEA85LA038.md): Cessna 172 · Port Townsend, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 1985 · N4502E · Substantial damage
  > The plt stated that once airborne during takeoff, the left wing dropped. Plt attempted remedial action, however, the acft contacted the left side of the taxiway in a nose down, left wing low attitude.
- [NTSB DEN85LA053](https://openairdocs.org/ntsb/DEN85LA053.md): Bell 206-L3 · Jackson, WY · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1984 · N3898Y · Substantial damage
  > Plt had landed on prepared area (snow packed down by heli ski guide) to embark ski passengers. On departure plt lifted to hover, turned to desired hdg and initiated forward transition. As acft passed boundry of packed snow, rotor wash picked up soft loose…
- [NTSB FTW85FA090](https://openairdocs.org/ntsb/FTW85FA090.md): Cessna 172L · Galveston, TX · Accident · 3 fatal · Field investigation · Final report · Dec 30, 1984 · N2823Q · Destroyed
  > A recently certificated private pilot with no known instrument training was given a 'VFR not recommended' weather briefing for a return trip on a pleasure flight. Weather conditions were predicted to, and did, deteriorate rapidly. He took off and turned on…
- [NTSB LAX85LA089](https://openairdocs.org/ntsb/LAX85LA089.md): Enstrom F-28C · Sausalito, CA · Accident · No injuries · Limited investigation · Final report · Dec 28, 1984 · N51755 · Substantial damage
  > Wx conds were sky obscured, visibility less than 1/16 of a mile in fog. Plt arrived at heliport, went directly to acft and started engine. Another heliport plt went to acft and advised mishap plt against departure due to low visibility. Mishap plt replied he…
- [NTSB FTW85LA089](https://openairdocs.org/ntsb/FTW85LA089.md): Bell 206L-1 · Houma, LA · Accident · No injuries · Limited investigation · Final report · Dec 28, 1984 · N1075Y · Substantial damage
  > The plt departed into known bad wx with low ceilings and poor visibility. Very shortly after takeoff the plt elected to return to the arpt. During a descending right turn the plt broke out of IMC at a very low altitude. He pulledcollective but still landed…
- [NTSB CHI85LA077](https://openairdocs.org/ntsb/CHI85LA077.md): Cessna 402C · Troy, MI · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N115EA · Destroyed
  > The acft collided with trees during the initial takeoff climb from rwy 27 at oakland-Troy airport, Troy,MI, while on a corporate flt. Investigation revealed that approx 3 to 5 inches of snow had fallen at the arpt during the day & the snow had not been…
- [NTSB LAX85FA084](https://openairdocs.org/ntsb/LAX85FA084.md): Cessna 310 · Temecula, CA · Accident · Serious injuries · Field investigation · Final report · Dec 25, 1984 · N5209A · Destroyed
  > The acft experienced a total power loss of the rt eng during takeoff from rancho calif airport & crashed about one half mi northwest. The plt reported that the acft would not climb, nor would it maintain altitude at about 40 ft AGL. He stated that when he…
- [NTSB ANC85FA031](https://openairdocs.org/ntsb/ANC85FA031.md): Piper PA-18 · Girdwood, AK · Accident · Minor injuries · Field investigation · Final report · Dec 24, 1984 · N6767B · Substantial damage
  > The plt reported a loss of elevator control during the takeoff climb portion of a touch-&-go landing. Examination of the wreckage disclosed a broken turnbuckle that was still attached to the upper end of the elevator horn.
- [NTSB DEN85FA048](https://openairdocs.org/ntsb/DEN85FA048.md): Piper PA-32-300 · Billings, MT · Accident · 3 fatal · Field investigation · Final report · Dec 23, 1984 · N2024M · Destroyed
  > On dec 23, 1984, a non instrument rated pvt plt crashed into the ground near the arpt at Billings, MT killing all three occupants onboard. Wx conditions at the time were indefinite ceiling 100 ft sky obscured, 1/2 vis with snow and fog. Theplt received prior…
- [NTSB ATL85FKG01](https://openairdocs.org/ntsb/ATL85FKG01.md): Piper PA-28-140 · Huntsville, AL · Accident · Serious injuries · Final report · Dec 23, 1984 · N7988N · Substantial damage
  > According to the pax very shortly after takeoff the acft 'stall light' illuminated as the acft flew over trees aft the end of the rwy. One pax reported that the acft climbed slightly before it dropped to the ground left wing and nose first. Exam of the eng…
- [NTSB NYC85FA047](https://openairdocs.org/ntsb/NYC85FA047.md): Cessna 402B · Rochester, NY · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1984 · N8064Q · Destroyed
  > Prior to tkf the plt was informed of wind shear as centerfield winds as 270 deg at 25 KTS gust to 46 KTS & nw boundary winds as 280 deg at 13 KTS. During tkf the plt reported an opened door & requested to return to land. The acft turned left and descended to…
- [NTSB LAX85LA081](https://openairdocs.org/ntsb/LAX85LA081.md): Weedhopper Super Nova II · Lakeside, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N4673D · Substantial damage
  > The ultralight acft lost power on takeoff & stalled into the ground. According to the builder/plt the capillary type fuel pump had failed to function properly on the takeoff climb causing fuel starvation. He failed to recover from a nose high attitude in time…
- [NTSB MIA85LA061](https://openairdocs.org/ntsb/MIA85LA061.md): Piper PA-28-161 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Dec 21, 1984 · N22061 · Substantial damage
  > The eng lost pwer at aprx 400 ft AGL in a left climbing turn after takeoff from rwy 09L. The plt continued the left turn in an effort to land on rwy 18L. Easterly winds caused the acft to overshoot and land on grass on the west side of the arpt. During the…
- [NTSB LAX85FA078](https://openairdocs.org/ntsb/LAX85FA078.md): Grumman AA-5B · Corona, CA · Accident · Serious injuries · Field investigation · Final report · Dec 20, 1984 · N74463 · Destroyed
  > During maint of the eng, & just before the annual inspection was signed off, someone partially loosened & then attempted to tighten the bolt securing the crankshaft gear to the crankshaft. The old lockplate was not replaced & was not properly secured about…
- [NTSB FTW85FA081](https://openairdocs.org/ntsb/FTW85FA081.md): Gates Learjet 35 · Waco, TX · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1984 · N95TC · Destroyed
  > No evidence of preimpact mechanical failure or malfunction was noted during wreckage examination. The FAA operations inspector who was on board at the time of the accident stated there were no aircraft problems involved. The PIC, who wasin the process of…
- [NTSB LAX85FA076](https://openairdocs.org/ntsb/LAX85FA076.md): Piper PA-60-601P · Mammoth Lakes, CA · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1984 · N601FP · Destroyed
  > The acft tookoff from an arpt whose rwys had been closed for snow removal. A NOTAM had been filed with the fresno fss by the Mammoth lake arpt mgr at 0900 hrs for taxi and rwy snow removal. The plt was aware of the NOTAM because the mgr and a lineman both…
- [NTSB ANC85LA030](https://openairdocs.org/ntsb/ANC85LA030.md): Cessna U206 · Point Hope, AK · Accident · No injuries · Limited investigation · Final report · Dec 17, 1984 · N735QP · Substantial damage
  > The acft crashed during takeoff while on a schedule air taxi flt. The plt & 5 passengers escaped serious injury. Investigation revealed the takeoff was attempted with suface winds reported as quartering directly across the takeoff rwy from 30 to more than 40…
- [NTSB LAX85LA075](https://openairdocs.org/ntsb/LAX85LA075.md): Beech V35B · Oceano, CA · Accident · No injuries · Limited investigation · Final report · Dec 16, 1984 · N137TW · Substantial damage
  > The plt made a forced landing after a total loss of power during the takeoff climb & the acft sustained substantial damage. In a subsequent conversation the plt stated that the fuel selector was either positioned on the left tip tank, or it was positioned in…
- [NTSB DEN85LA045](https://openairdocs.org/ntsb/DEN85LA045.md): Mooney M20E · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Dec 15, 1984 · N79349 · Substantial damage
  > The acft made an off-arpt forced landing after the engine lost power during takeoff. The flt instructor and the plt receiving instruction had flown this acft for an earlier session of training during the morning. After a break and briefing the acft was…
- [NTSB LAX85FA067](https://openairdocs.org/ntsb/LAX85FA067.md): Beech G35 · Lakeport, CA · Accident · Serious injuries · Field investigation · Final report · Dec 12, 1984 · N430WM · Substantial damage
  > At aprx 150 ft AGL the acft's lost pwr & plt made a tail first hard landing off side of rwy. Acft skidded 60 ft before stopping when it hit a fence. Fuel selector was found in 'aux' position. Plt said he took off on left tank and was moving selector to rt…
- [NTSB SEA85LA027](https://openairdocs.org/ntsb/SEA85LA027.md): Cessna 172C · Creswell, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1984 · N1424Y · Substantial damage
  > At alt of aprx 100 ft AGL engine quit. Witness stated acft turned to the right then to the left before nosing down into the ground. Inspection revealed ice crystals on the left wing where the fuel tank ruptured and fuel was leaking. Witness stated ice…
- [NTSB DCA85AA004](https://openairdocs.org/ntsb/DCA85AA004.md): Embraer EMB-110P1 · Jacksonville, FL · Accident · 13 fatal · Final report · Dec 6, 1984 · N96PB · Destroyed
  > Provincetown-boston airlines flt 1039, an Embraer EMB-110P1, was cleared to takeoff on rwy 31 at 1812 EST. Drg the initial climb nr the departure end of the rwy, the capt routinely acknowledged an instrn to contact dep control (ctl). Shortly thereafter, the…
- [NTSB CHI85LA062](https://openairdocs.org/ntsb/CHI85LA062.md): Cessna 182J · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Dec 4, 1984 · N2910F · Substantial damage
  > N2910F, nosed over in a field after engine failure during initial climb on a biannual flight review. When the acft was examined following the acc, a two inch icicle was found in the bottom of the rt fuel tank located at the fuel line connection. The fuel from…
- [NTSB SEA85LA025](https://openairdocs.org/ntsb/SEA85LA025.md): Cessna 414 · Waterville, WA · Accident · No injuries · Limited investigation · Final report · Dec 2, 1984 · N14DC · Substantial damage
  > Upon arrival at the dest arpt the plt elected to perform a touch & go landing in order to evaluate rwy braking action. During climb out after the touch & go at about 100 ft AGL and 100 to 105 KTS the acft yawed to the right as the nose picthed up. Despite…
- [NTSB FTW85LA062](https://openairdocs.org/ntsb/FTW85LA062.md): Cessna 175 · Bastrop, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1984 · N7327M · Substantial damage
  > Plt stated that on preflight a small amount of water was drained from each wing tank. Also, the main fuel strainer was drained and fuel tanks were topped off (17 gals added). At about 500 ft AGL on initial climb, the engine quit and restart attempts were…
- [NTSB MIA85LA047](https://openairdocs.org/ntsb/MIA85LA047.md): WSK PZL Mielec PZL-M-18 · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Nov 28, 1984 · CCCLR · Substantial damage
  > The plt said that the acft went into an uncommanded uncontrolled abrupt left turn after takeoff. The acft collided with the ground and slid off the north side of the rwy. Post crash inspection showed nothing to suggest pre-crash flt controlmalfunction. This…
- [NTSB FTW85FA061](https://openairdocs.org/ntsb/FTW85FA061.md): Cessna T303 · Seminole, OK · Accident · No injuries · Field investigation · Final report · Nov 28, 1984 · N628SV · Substantial damage
  > Experiencing a power loss on the right engine on takeoff from a touch & go landing. The pilot was forced to land off the runway. The aircraft rolled into a gully sustaining substantial damage. The malfunction could not be reproduced during subsequent…
- [NTSB FTW85LA059](https://openairdocs.org/ntsb/FTW85LA059.md): Cessna 182P · Sanderson, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1984 · N52811 · Substantial damage
  > Due to grass and mud on portions of the 3,600 ft long turf strip the pilot attempted the takeoff on the last 700 to 800 ft of the rwy. The pilot rotated at the strips end to avoid colliding with a fence but was unable to maintain the climb. In the area of…
- [NTSB DEN85LA033](https://openairdocs.org/ntsb/DEN85LA033.md): Bell 206B-III · Mancos, CO · Accident · No injuries · Limited investigation · Final report · Nov 26, 1984 · N5018L · Substantial damage
  > The acft settled during an emer lndg after the plt said the engine failed. Investigation revealed the acft received minor maintenance on the day of the accident, consisting of changing the pitch chain links on the main rotor blades. Theplt made a written…
- [NTSB NYC85FNC01](https://openairdocs.org/ntsb/NYC85FNC01.md): Piper J-3 · Rutland, VT · Accident · Serious injuries · Final report · Nov 25, 1984 · N19AN · Destroyed
  > Witnesses related that as the acft got airborne the wings wobbled and the acft descended out of control to impact. Local law enforcement officers found evidence that the acft struck trees before colliding with the terrain.

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

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

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