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

## Cases, newest first

- [NTSB ANC84LA076](https://openairdocs.org/ntsb/ANC84LA076.md): Piper PA-32 · Nunavachak, AK · Accident · No injuries · Limited investigation · Final report · May 24, 1984 · N4143W · 2 aircraft · Substantial damage
  > The plt of a Piper PA-32, N4143W, was taking off toward the west-northwest on a tidal beach at the same time that another plt was taxiing west onto the beach. The other plt was taxiing a high wing, Bellanca 7GCBC, N2677Z. The Bellanca was angling down onto…
- [NTSB NYC84FGT01](https://openairdocs.org/ntsb/NYC84FGT01.md): Mooney M20C · Slate Run, PA · Accident · Serious injuries · Final report · May 22, 1984 · N5818Q · Destroyed
  > The acft crashed shortly after takeoff from the black forestairport. Investigation revealed that the acft traveled approx 2/3RDS of the rwy distance, became airborne, settled back on the rwy & became airborne again. At the time of takeoff the acft was loaded…
- [NTSB CHI84LA203](https://openairdocs.org/ntsb/CHI84LA203.md): Hughes 269B · Toulon, IL · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N9471F · Substantial damage
  > The plt landed the helicopter in a grassy area to talk to a friend. During departure, he flew over a corn field, & at that time, an empty paper/plastic corn seed sack was drawn up into the main rotor & a severe vibration began. He then landed in the field &…
- [NTSB LAX84FA300](https://openairdocs.org/ntsb/LAX84FA300.md): Piper PA-28-151 · Corona, CA · Accident · Serious injuries · Field investigation · Final report · May 19, 1984 · N5387F · Substantial damage
  > The acft experienced an eng power failure during takeoff & collided with the ground while maneuvering to return to the airport. The plt stated that he 'turned right trying to return to the runway,' & at the same time, 'maintain 80 (KTS IAS), but it (the acft)…
- [NTSB LAX84FA299](https://openairdocs.org/ntsb/LAX84FA299.md): Cessna TR182 · Big Bear City, CA · Accident · Serious injuries · Field investigation · Final report · May 19, 1984 · N756BS · Destroyed
  > Just after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…
- [NTSB CHI84LA199](https://openairdocs.org/ntsb/CHI84LA199.md): Meyers LIL Toot · White Bear Lake, MN · Accident · Serious injuries · Limited investigation · Final report · May 19, 1984 · N12G · Substantial damage
  > Plt reported power loss while on initial climb. The left wing contacted the ground and the acft cartwheeled. Examinationof aircraft by FAA disclosed no malfunction of aircraft or of powerplant.
- [NTSB NYC84LA177](https://openairdocs.org/ntsb/NYC84LA177.md): Cessna 152 · West Milford, NJ · Accident · Minor injuries · Limited investigation · Final report · May 18, 1984 · N67809 · Substantial damage
  > The plt stated that during the initial climb of a max performance takeoff the best angle rate of climb could not be maintained. The acft contacted trees and subsequently crashed in an abandoned parking lot.
- [NTSB ATL84LA174](https://openairdocs.org/ntsb/ATL84LA174.md): Eiriavion PIK 20E · Thomasville, NC · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N35LP · Substantial damage
  > The plt reported that the acft suffered a partial power loss at 150 ft AGL while on initial climb. The plt attempted to return to the airport to land and the eng lost total power. The pilot made a forced landing in a mature wheat field. Examination of the eng…
- [NTSB FTW84LA235](https://openairdocs.org/ntsb/FTW84LA235.md): Bellanca 17-30 · Plainview, TX · Accident · Minor injuries · Limited investigation · Final report · May 17, 1984 · N7393V · Substantial damage
  > A tlt loss of power occurred during the initial takeoff climb. The landing gear collapsed when a forced landing was made in an open field. The acft just came out of an annual inspection. After the accident a fuel leak was found where the main inlet fuel line…
- [NTSB DEN84IA152](https://openairdocs.org/ntsb/DEN84IA152.md): Cessna U206G · Dulce, NM · Incident · No injuries · Incident investigation · Final report · May 17, 1984 · N756SS · Minor damage
  > The plt reported that the arpt was in a valley surrounded by mountains & the elevation was about 6800 ft. with the wind out of the northwest, rwy 33 was the most favorable for the takeoff. There was a ridge about 1/2 mi north of the arpt making it necessary…
- [NTSB ATL84FA172](https://openairdocs.org/ntsb/ATL84FA172.md): Beech 35 · Chesapeake, VA · Accident · 2 fatal · Field investigation · Final report · May 17, 1984 · N934 · Destroyed
  > The acft was being flown on a test flt after a new fuel pump had been installed. While taxiing for takeoff, the eng stopped. The plt restarted the eng & subsequently performed a takeoff. Witnesses saw the acft climb to about 500 ft AGL & begin a turn onto the…
- [NTSB FTW84LA233](https://openairdocs.org/ntsb/FTW84LA233.md): Luscombe 8A · Colcord, OK · Accident · No injuries · Limited investigation · Final report · May 16, 1984 · N45906 · Substantial damage
  > The flight departed downwind from an unimproved field to avoid power lines at the upwind end of the field. During the takeoff roll sufficient speed could not be attained to lift off and clear a fence at the departure end of the runway. The pilot attempted to…
- [NTSB CHI84LA189](https://openairdocs.org/ntsb/CHI84LA189.md): Cessna 190 · St. Anne, IL · Accident · No injuries · Limited investigation · Final report · May 14, 1984 · N9854A · Substantial damage
  > The plt stated that during his 2nd takeoff from a restricted landing area, the eng hesitated at an alt of about 10 ft AGL. He then aborted the takeoff & tried to land on the remaining rwy. However, the acft touched down in a plowed field where it nosed over.…
- [NTSB ANC84FA068](https://openairdocs.org/ntsb/ANC84FA068.md): Cessna 182N · Fairbanks, AK · Accident · Minor injuries · Field investigation · Final report · May 14, 1984 · N9096G · Substantial damage
  > During takeoff, the acft lifted off at about mid-field, then it touched down & became airborne again before it crashed. It came to rest in an inverted position, 1017 ft beyond the end of the rwy. No abnormalities of the eng were found other than impact…
- [NTSB FTW84LA230](https://openairdocs.org/ntsb/FTW84LA230.md): Cessna 172H · Many, LA · Accident · Serious injuries · Limited investigation · Final report · May 13, 1984 · N2434L · Substantial damage
  > The acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…
- [NTSB DEN84FA148](https://openairdocs.org/ntsb/DEN84FA148.md): Piper PA-23-150 · Parker, CO · Accident · Serious injuries · Field investigation · Final report · May 13, 1984 · N1425P · Substantial damage
  > According to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…
- [NTSB CHI84LA188](https://openairdocs.org/ntsb/CHI84LA188.md): Ayres S2R · Vincennes, IN · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N4006U · Substantial damage
  > The plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…
- [NTSB NYC84LA169](https://openairdocs.org/ntsb/NYC84LA169.md): Cessna C150 · So.Bethlehem, NY · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N4024U · Destroyed
  > The student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…
- [NTSB LAX84LA295](https://openairdocs.org/ntsb/LAX84LA295.md): Cessna A150K · Trona, CA · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N8376M · Substantial damage
  > The acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…
- [NTSB DEN84LA147](https://openairdocs.org/ntsb/DEN84LA147.md): Cessna TU206F · Strasburg, CO · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N222LS · Substantial damage
  > During the takeoff phase of a touch-&-go, the eng quit about 100 ft AGL. The plt landed back on the rwy but the acft ran-off the end collapsing the nose gear. Evidence of water contamination was found throughout the fuel system. 1/2 of liquid drained from…
- [NTSB DCA84IA026](https://openairdocs.org/ntsb/DCA84IA026.md): Boeing 747 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · May 12, 1984 · FBPVS · Minor damage
  > During rotation the #2 eng sustained an explosive rupture of its compressor rear frame(crf). The crew observed a rapid drop in the #2 eng performance parameters & the illumination of the #2 eng thrust reversers 'unlock and in transit' lites. The crew…
- [NTSB SEA84LA103](https://openairdocs.org/ntsb/SEA84LA103.md): Piper PA-28-235 · Touchet, WA · Accident · No injuries · Limited investigation · Final report · May 8, 1984 · N8624W · Substantial damage
  > The acft was departing a pvt airstrip. During takeoff initial climb the eng failed. The pilot attempted to restart the engine but it would not start. During the forced landing the acft struck a fence. The pilot stated that he selected the left tip tank, which…
- [NTSB NYC84FA165](https://openairdocs.org/ntsb/NYC84FA165.md): Beech B19 · College Park, MD · Accident · Serious injuries · Field investigation · Final report · May 8, 1984 · N18786 · Destroyed
  > The flt had arrived at the arpt between 1600 & 1615, & had landed on rwy 15. Winds generally were out of the sw at ABOUT10 KTS. The plt stated that during the flt he had observed a thunderstorm west of andrews afb (10 mi south.) After loading an ATC simulator…
- [NTSB CHI84FA179](https://openairdocs.org/ntsb/CHI84FA179.md): Mooney M20J · Highland Hgts, OH · Accident · 2 fatal · Field investigation · Final report · May 8, 1984 · N3833H · Destroyed
  > Two mins after takeoff, acft impacted terrain left wing down, measured 63 degrees nose down, well left of designated departure course. Investigation revealed no malfunction or failure in the acft structure, power plant or systems. Plt's actual instrument…
- [NTSB NYC84LA162](https://openairdocs.org/ntsb/NYC84LA162.md): Piper PA-28 · Muskeget Island, MA · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N15520 · Substantial damage
  > The acft was unable to clear trees during the initial takeoff climb. The plt raised the nose of the acft and the acft stalled contacted the trees.
- [NTSB NYC84FA158](https://openairdocs.org/ntsb/NYC84FA158.md): Piper PA-18-150 · Shirley, NY · Accident · 1 fatal · Field investigation · Final report · May 6, 1984 · N4410Z · Destroyed
  > While climbing with a glider in tow, the tow acft pitched nose up. The glider & tow plts released the tow rope & the glider plt landed safely. The tow acft maintained a nose high attitude, stalled, then entered an uncontrolled descent & crashed. An…
- [NTSB FTW84LA223](https://openairdocs.org/ntsb/FTW84LA223.md): Cessna 172 · Allen, OK · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N5173A · Destroyed
  > The pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…
- [NTSB CHI84LA181](https://openairdocs.org/ntsb/CHI84LA181.md): Bell 47D-1 · Ridge Farm, IL · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N13012 · Substantial damage
  > The helicopter rolled over after a hard landing following loss of rotor RPM. The plt reported that during initial climb at about 300 ft AGL the rotor decreased about 500 RPM. He tried to regain rotor RPM until about 100 ft AGL and then tried an autorotation.…
- [NTSB MKC84LA138](https://openairdocs.org/ntsb/MKC84LA138.md): Soneria II · Kansas City, KS · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N1355K · Substantial damage
  > The plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…
- [NTSB LAX84LA281](https://openairdocs.org/ntsb/LAX84LA281.md): Cessna 180K · San Miguel Is, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N66597 · Substantial damage
  > The plt was taking off in a 35 kt wind with the flaps extended. The acft became airborne in a 3 point attitude, & when 2 to 3 ft in the air, it began a left turn. Subsequently, the wing dragged the ground & the acft nosed over. The plt said he should have…
- [NTSB CHI84LA174](https://openairdocs.org/ntsb/CHI84LA174.md): Gable Sonerai II · Berlin, WI · Accident · Serious injuries · Limited investigation · Final report · May 5, 1984 · N3994G · Substantial damage
  > This homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…
- [NTSB DEN84FA144](https://openairdocs.org/ntsb/DEN84FA144.md): Beech B23 · Ruidoso, NM · Accident · 1 fatal · Field investigation · Final report · May 4, 1984 · N9137T · Destroyed
  > The pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…
- [NTSB CHI84LA176](https://openairdocs.org/ntsb/CHI84LA176.md): Cessna 152 · Ft Atkinson, WI · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N25583 · Substantial damage
  > The acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.
- [NTSB LAX84FA280](https://openairdocs.org/ntsb/LAX84FA280.md): Grumman American AA-5B · Placerville, CA · Accident · 1 fatal · Field investigation · Final report · May 3, 1984 · N28867 · Destroyed
  > The plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…
- [NTSB FTW84FA218](https://openairdocs.org/ntsb/FTW84FA218.md): de Havilland Tiger Moth DH 82A · San Antonio, TX · Accident · 2 fatal · Field investigation · Final report · May 3, 1984 · N82DS · Destroyed
  > The acft crashed in an open pasture with trees on the western perimeter. The acft attitude at impact was nose down at a 30 to 50 degree angle in a right spiral. The main fuel tank mounted on the top wing over and behind the engine broke from its mount on…
- [NTSB SEA84LA098](https://openairdocs.org/ntsb/SEA84LA098.md): Eagle DW-1 · Spangle, WA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1984 · N8813J · Substantial damage
  > According to FAA inspectors, the plt polished the lower leading edges of wings before departing, as they were covered with frost. The plt stated that during climb out the acft entered an inadvertent stall, followed by a three point landing onto soft field.…
- [NTSB NYC84LA155](https://openairdocs.org/ntsb/NYC84LA155.md): Bell 206 · Boston, MA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1984 · N3913W · Substantial damage
  > After takeoff, the helicopter was climbing thru 200 to 300 ft AGL, at 50 to 60 KTS, when a partial loss of power occurred. This was followed immediately by a complete loss of power. The plt initiated an autorotation & landed in a railroad switching area where…
- [NTSB DEN84LA140](https://openairdocs.org/ntsb/DEN84LA140.md): Beech F35 · Moab, UT · Accident · No injuries · Limited investigation · Final report · Apr 30, 1984 · N3366C · Substantial damage
  > During takeoff, the eng lost power at about 100 ft AGL. The plt decided to land the acft back on the rwy to avoid rough terrain beyond the end. The acft was landed with the gear up. During an investigation, fuel was found in the main tanks & the right…
- [NTSB NYC84FNE02](https://openairdocs.org/ntsb/NYC84FNE02.md): Benson B8M · Willimantic, CT · Accident · Serious injuries · Final report · Apr 29, 1984 · N196JB · Substantial damage
  > The gyrocopter crashed after the plt lost control of the acft in a windy condition, during takeoff. A 20 degree x-wind velocity of 10 KTS gusting to 35 KTS existed at the time of the accident. The plt told his wife (who wrote the report on the 6120.1 NTSB…
- [NTSB CHI84LA168](https://openairdocs.org/ntsb/CHI84LA168.md): Cessna 182P · Cinncinati, OH · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N1233M · Substantial damage
  > The acft made a forced landing after a total power loss. On the landing flare the right main gear caught the edge of a sand trap & sheared off. Approximately 8 ounces of water were drained from the sumps & carburetor. The engine was subsequently started & ran…
- [NTSB ATL84LA153](https://openairdocs.org/ntsb/ATL84LA153.md): Piper PA-34-200 · Smyrna, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1984 · N1027U · Substantial damage
  > The CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…
- [NTSB ATL84FA150](https://openairdocs.org/ntsb/ATL84FA150.md): Piper PA-32R-300 · Suffolk, VA · Accident · Serious injuries · Field investigation · Final report · Apr 27, 1984 · N37MA · Destroyed
  > During the initial takeoff climb the acft contacted power lines located 584 ft from the end of the rwy. This was an initial test flt of the acft after having the engine overhauled. The plt stated at an alt of aprx 50 ft AGL the engine began to lose power and…
- [NTSB CHI84LA161](https://openairdocs.org/ntsb/CHI84LA161.md): Piper PA-28-140 · Genoa City, WI · Accident · Serious injuries · Limited investigation · Final report · Apr 26, 1984 · N6737W · Substantial damage
  > After takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…
- [NTSB FTW84FA209](https://openairdocs.org/ntsb/FTW84FA209.md): Grumman American AA-5A · Pryor, OK · Accident · 1 fatal · Field investigation · Final report · Apr 25, 1984 · N27165 · Destroyed
  > The student plt taxied upwind & took off downwind. Witnesses reported that the acft lifted off at the departure end & never left ground effect. After about 1/2 mi, the acft stalled as the plt attempted to clear electric lines. The acft then crashed, hitting a…
- [NTSB NYC84FA148](https://openairdocs.org/ntsb/NYC84FA148.md): Piper PA-32RT-300 · Hopwood, PA · Accident · 1 fatal · Field investigation · Final report · Apr 24, 1984 · N2209A · Destroyed
  > The ATP rated pilot obtained a complete wx briefing including forecasts of occasional moderate icing, a cleveland center wx advisory, winds aloft with temps at the flt planned alt of 6000 ft ranging from -1 to -4 deg c and pireps of moderate icing from 5000…
- [NTSB DEN84FA137](https://openairdocs.org/ntsb/DEN84FA137.md): Piper PA-28-140 · Reserve, NM · Accident · Serious injuries · Field investigation · Final report · Apr 24, 1984 · N9769W · Destroyed
  > The acft collided with trees shortly after takeoff. The acft, according to the plt, reached about 500 ft AGL when the airspeed dropped and the acft stalled into trees. Later the density alt was figured to be 9091 ft. this was over 2000 fthigher than the…
- [NTSB MIA84FA149](https://openairdocs.org/ntsb/MIA84FA149.md): Piper PA-28-140 · Panacea, FL · Accident · 1 fatal · Field investigation · Final report · Apr 23, 1984 · N1734J · Destroyed
  > Acft crashed in water shortly after takeoff. One witness stated the acft entered the water in a steep left bank at a high rate of descent. Witnesses also stated that at the time of the accident, the ceiling was about 50 to 200 ft MSL, visibility was less than…
- [NTSB DEN84LA132](https://openairdocs.org/ntsb/DEN84LA132.md): Piper PA-12 · Jackson, WY · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N2577M · Substantial damage
  > The acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…
- [NTSB SEA84LA087](https://openairdocs.org/ntsb/SEA84LA087.md): PZL-Mielec PZL-M-18 · Rockford, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1984 · N28951 · Substantial damage
  > The plt said the acft was a 'little heavier' than it should have been. The acft bounced settled after takeoff and the right wing hit a fence post. The collision jammed the right aileron down and the acft became uncontrollable and crashed.
- [NTSB FTW84LA201](https://openairdocs.org/ntsb/FTW84LA201.md): Cessna A185F · Grand Isle, LA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N2177Q · Substantial damage
  > The plt estimated that the wind was from the northeast at 15 KTS gusting to 25 KTS. During an easterly takeoff from a private strip, the acft encountered a gust which lifted the left wing causing the plane to drift right & lift off. The acft climbed to an alt…

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

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

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