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

## Cases, newest first

- [NTSB NYC84FNE04](https://openairdocs.org/ntsb/NYC84FNE04.md): Cessna 150H · Burlington, CT · Accident · Serious injuries · Final report · Aug 4, 1984 · N6901S · Substantial damage
  > The plt reported he 'picked up the acft after annual inspection', performed a preflt, made a standard run-up & took off in calm air conditions. After clmbing about 500 to 600 ft, the eng lost power & subsequently, the acft crash landed in a marsh. The plt was…
- [NTSB LAX84LU030](https://openairdocs.org/ntsb/LAX84LU030.md): Eipper Quicksilver MX · Thousand Oaks, CA · Accident · Serious injuries · Final report · Aug 4, 1984 · UNREG · Substantial damage
  > During a takeoff climb, the ultralight collided with a power line & crashed. The plt stated that he did not see the wires until impact; nor was he aware of their presence.
- [NTSB SEA84LA190](https://openairdocs.org/ntsb/SEA84LA190.md): Cessna 172I · Morton, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 1984 · N8394L · Substantial damage
  > During takeoff at alt of 3 to 5 ft AGL the decision was made to abort the takeoff. Plt stated when throttle was retarded lift improved so full pwr was applied. At 15 ft AGL plt realized trees at end of rwy could not be cleared so plt attempted another aborted…
- [NTSB DCA84AA033](https://openairdocs.org/ntsb/DCA84AA033.md): Britten-Norman BN-2A Islander · Vieques, PR · Accident · 9 fatal · Final report · Aug 2, 1984 · N589SA · Destroyed
  > A witness reported he heard an apparent eng problem after the acft took off & began a left turn for a x-wind departure. Reportedly, the acft oscillated, then after regaining some lost alt, it banked abruptly to the left, nosed down, & subsequently, crashed in…
- [NTSB CHI84LA322](https://openairdocs.org/ntsb/CHI84LA322.md): Piper PA-22-150 · Findlay, OH · Accident · No injuries · Limited investigation · Final report · Aug 2, 1984 · N3743P · Substantial damage
  > During the initial takeoff climb at an alt of aprx 1400 ft MSL the engine quit. Attempts to regain power failed. The acft nosed over during a forced landing in a corn field. Post accident investigation of the engine revealed a broken carburetor heat linkage…
- [NTSB NYC84LA244](https://openairdocs.org/ntsb/NYC84LA244.md): Cessna 152 · Bally, PA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1984 · N93397 · Substantial damage
  > During the initial climb at aprx 10 ft AGL the airspeed dropped to 40 KTS and the stall warning horn came on. The plt pushed the nose down to prevent a stall. The right wing dropped and the acft veered off the rwy on touchdown. The acft then contacted a tree…
- [NTSB LAX84LA424](https://openairdocs.org/ntsb/LAX84LA424.md): Bell 47G-5A · Winterhaven, CA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1984 · N4099G · Substantial damage
  > The acft collided with the ground during a takeoff attempt. According to the plt, after the acft was loaded with 60 gallons of pesticide a takeoff was begun. The acft became airborne and traveled about 300 ft when the plt inadvertantly allowed the rotor RPM…
- [NTSB DEN84LA246](https://openairdocs.org/ntsb/DEN84LA246.md): Stinson 108-1 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Aug 1, 1984 · N8280K · Substantial damage
  > Following an uneventful runup the pilot took off and was climbing through 400 ft AGL when the engine began to lose power. The pilot then turned on the carburetor heat, but it did not alleviate the engine problem. He then made an emergency landing in a field,…
- [NTSB SEA84LA192](https://openairdocs.org/ntsb/SEA84LA192.md): Grumman AA-5 · Klamath Falls, OR · Accident · No injuries · Limited investigation · Final report · Jul 31, 1984 · N6542L · Substantial damage
  > The pilot stated that the run-up and takeoff were normal but during the climbout the engine lost power. A small fire, confined to the engine compartment erupted. Power could not be restored and an emergency landing was accomplished in an open field.…
- [NTSB DEN84IA241](https://openairdocs.org/ntsb/DEN84IA241.md): de Havilland DHC-7-100 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jul 29, 1984 · N9058P · Minor damage
  > The left main landing gear was disassembled & reassembled by company maintenance personnel & the acft was being ferried to another base for permanent landing gear repairs. During takeoff, the left main landing gear and shock strut seperated from the acft. The…
- [NTSB CHI84LA317](https://openairdocs.org/ntsb/CHI84LA317.md): Bell 47-G2 · Jeffersonville, OH · Accident · No injuries · Limited investigation · Final report · Jul 29, 1984 · N59H · Substantial damage
  > The acft started to settle with power during takeoff after the acft was loaded with chemicals. The plt said he had a choice of, going through a fence or over it and decided to go over it. Pulling collective bled off m/r and the acft stopped flying. The tail…
- [NTSB MIA84LA215](https://openairdocs.org/ntsb/MIA84LA215.md): Piper PA-38-112 · Nahunta, GA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N2426P · Substantial damage
  > After the student made a full stop landing on a 3000 ft rwy, he started to turn around & back taxi to the apch end to takeoff; however, the instructor (CFI) told him to make a short field takeoff from where he had stopped. A takeoff was initiated with about…
- [NTSB LAX84LA417](https://openairdocs.org/ntsb/LAX84LA417.md): Grumman G-164B · Delhi, CA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N6711Q · Destroyed
  > The plt took off so early it was described by a witness as still being dark. The elevation of the accident was higher than the takeoff point. The operator said the plt tended to be easy on the equipment and throttled back shortly after takeoff. He stated that…
- [NTSB CHI84FA315](https://openairdocs.org/ntsb/CHI84FA315.md): Piper PA-32RT-300 · Sandwich, IL · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1984 · N36219 · Destroyed
  > Pilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.
- [NTSB ANC84LA126](https://openairdocs.org/ntsb/ANC84LA126.md): Grumman G-44A · Shanin Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 28, 1984 · N9900H · Substantial damage
  > The plt reported that shortly after takeoff the acft encountered severe wind shear. The plt lost directional control of the acft & it collided with a mud bank.
- [NTSB FTW84LA325](https://openairdocs.org/ntsb/FTW84LA325.md): Bell 47J · Grove, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1984 · N2837B · Destroyed
  > The plt stated that yaw control was lost during climb out for a local flt with two passengers onboard. The acft began torotate to the right and the antitorque pedals were ineffective. They were over buildings at the time so the plt held a minimum descent…
- [NTSB NYC84LA255](https://openairdocs.org/ntsb/NYC84LA255.md): Piper PA-22-135 · Canton, PA · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1984 · N3777A · Substantial damage
  > The pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…
- [NTSB MIA84LA212](https://openairdocs.org/ntsb/MIA84LA212.md): Cessna 152 · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1984 · N6104M · Destroyed
  > The plt had experienced an eng failure due to fuel exhaustion & had safely executed a forced landing on a 1,100 ft road in front of condominiums. After having fuel brought from a local arpt, he attempted a takeoff. After lift-off, at an altitude of about 6…
- [NTSB MIA84LA211](https://openairdocs.org/ntsb/MIA84LA211.md): Piper PA-36-285 · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N57593 · Destroyed
  > Shortly after takeoff at about 150 ft AGL the propeller hub failed allowing one propeller blade to separate from the acft. The pilot flew the forced landing straight ahead into trees. Metallurgical examination of the hub revealed evidence of a fatigue…
- [NTSB MIA84LA210](https://openairdocs.org/ntsb/MIA84LA210.md): Piper PA-23-250 · Ponce, PR · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N5464Y · Substantial damage
  > On initial climb, right engine power loss occurred. Plt executed emerg procedures, attempted gradual circuit to land. Unable to maintain sufficient altitude to clear known obstructions on runway approach. Plt elected to make a gear-up landing in cane field.…
- [NTSB DEN84LA237](https://openairdocs.org/ntsb/DEN84LA237.md): Grumman G-164 · Wessington, SD · Accident · No injuries · Limited investigation · Final report · Jul 25, 1984 · N751Y · Substantial damage
  > Plt stated that during loading for aerial application, he failed to note approaching roll cloud which usually signifies localized turbulence and strong, gusting winds. On takeoff roll, wind shift noted and at 100 ft altitude, heavy turbulence was encountered.…
- [NTSB CHI84LA311](https://openairdocs.org/ntsb/CHI84LA311.md): Aerospatiale SA-341G · Plymouth, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1984 · N54PC · Substantial damage
  > The co-plt, who had no experience in this model acft, began a transition from hover to climb and the acft went into a rapid rotation. Both plts were unable to stop the rotation and when the PIC tried to land, the acft struck raised ridgeswith the left skid…
- [NTSB MIA84LA209](https://openairdocs.org/ntsb/MIA84LA209.md): Piper J3C-65 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jul 24, 1984 · N2166Y · Substantial damage
  > The plt stated that at about 100 ft AGL the eng lost power but continued to run at a lower power until ground impact. No eng malfunction was found. A post accident exam of the acft revealed no reason for the loss of power.
- [NTSB CHI84FA308](https://openairdocs.org/ntsb/CHI84FA308.md): Grumman AA-5 · Little Falls, MN · Accident · 4 fatal · Field investigation · Final report · Jul 24, 1984 · N1338R · Destroyed
  > The acft collided with the ground during a takeoff attempt. The low time plt was using a grass rwy for the 1st time without an instructor. The acft was rotated prematurely and assumed a nose high attitude. According to one witness the acft was 'behind the…
- [NTSB NYC84LA254](https://openairdocs.org/ntsb/NYC84LA254.md): Cessna 310I · York, PA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1984 · N14DR · Substantial damage
  > The pilot stated that he was performing touch and go landings and was climbing after his fifth takeoff when the right engine lost power. The pilot continued to state that the landing gear was cycling up when the loss of pwr occured. The aircraft stopped…
- [NTSB DEN84LU009](https://openairdocs.org/ntsb/DEN84LU009.md): Eipper Quicksilver MXL · Erie, CO · Accident · Minor injuries · Final report · Jul 23, 1984 · UNREG · Substantial damage
  > The ultralight was proceeding in a normal takeoff when the engine lost partial power at about 100 ft AGL. The plt turnedthe vehicle to avoid trees and a river. During the hard forced landing, the vehicle was damaged and the plt hurt his leg. Post accident…
- [NTSB LAX84LA411](https://openairdocs.org/ntsb/LAX84LA411.md): Aeronca 60-TF · Gorman, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N27350 · Substantial damage
  > According to the plt a 90 degree crosswind caused a loss of directional control shortly after takeoff. The empennage contacted a fence and trees off the left side of the rwy.
- [NTSB SEA84FA178](https://openairdocs.org/ntsb/SEA84FA178.md): Sperling BD-4 · Henderson, NV · Accident · 2 fatal · Field investigation · Final report · Jul 21, 1984 · N78JC · Destroyed
  > Witnesses reported observing the acft depart to the ssw toward the mountains. The acft made a series of turns and banks to avoid a group of thunderstorm cells (air mass thunderstorms) in a direction of interstate highway 15. The acft was reported to have made…
- [NTSB NYC84FNC06](https://openairdocs.org/ntsb/NYC84FNC06.md): Piper PA-24-180 · Bingham, ME · Accident · Serious injuries · Final report · Jul 21, 1984 · N5732P · Destroyed
  > The acft used, according to various accounts, between 1/2 and 2/3 of the 2300 ft runway on take-off roll. Normal handbook take-off run is 750 ft. passengers stated acft skipped off and touched back down twice before finally becoming airborne. Acft rolled…
- [NTSB MKC84LA227](https://openairdocs.org/ntsb/MKC84LA227.md): Cessna 150 · Troy, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1984 · N2730S · Substantial damage
  > Shortly after takeoff the acft collided with wires and crashed. The plt had tried to fly under the wires because the acft would not climb over them. Investigation revealed that the acft was overloaded and out of balance by having 2 minorpassengers in the…
- [NTSB SEA84LA177](https://openairdocs.org/ntsb/SEA84LA177.md): Cessna 150H · Worley, ID · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N150WA · Substantial damage
  > The pilot was performing a touch-and-go landing on an 80 foot wide, turf and gravel runway. The plt stated that he made a normal lnding but during the takeoff the acft lifted off the gnd then settled back on the rwy. The acft then swerved off the left side of…
- [NTSB FTW84LA318](https://openairdocs.org/ntsb/FTW84LA318.md): Grumman G-164A · Kinder, LA · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N8548H · Destroyed
  > The heavily loaded acft was turned shortly after takeoff and began to settle. The plt started to dump the load but the acft contacted trees during the attempt and crashed. The acft was loaded with fertilizer and nearly full of fuel. The temperature was 90…
- [NTSB ATL84LA227](https://openairdocs.org/ntsb/ATL84LA227.md): Cessna 172F · John'S Island, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1984 · N5110F · Substantial damage
  > During a solo flt, the student flew to a local arpt to practice takeoffs & landings. After his last landing (on rwy 9), he elected to make a x-wind takeoff on rwy 21. During the takeoff, the acft began drifting left at about lift-off speed. The student…
- [NTSB ATL84LA226](https://openairdocs.org/ntsb/ATL84LA226.md): Bell 204 UH 1B · Tams, WV · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N91307 · Destroyed
  > An over gross takeoff was attempted from a 500 ft long zone. Translational lift was not achieved and rotor RPM deteriorated. The helicopter collided with trees, crashed & burned. The plt stated that the wind may have shifted during his takeoff.
- [NTSB DEN84LA227](https://openairdocs.org/ntsb/DEN84LA227.md): Bellanca 8KCAB · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1984 · N57394 · Substantial damage
  > Shortly after lift off from a touch-and-go landing, the engine sputtered and lost power. A forced landing was performed in a field where the aircraft struck a dirt bank and nosed over. No reason was found for the power loss.
- [NTSB ANC84LA118](https://openairdocs.org/ntsb/ANC84LA118.md): Cessna 206 · Cold Foot, AK · Accident · No injuries · Limited investigation · Final report · Jul 19, 1984 · N3948G · Substantial damage
  > The acft was damaged in a forced landing on a road after the engine quit. After the accident the acft fuel system was examined by an FAA inspector. The fuel/air screen was found to be contaminated with dirt. The injector screen and the main fuel strainer was…
- [NTSB LAX84LA401](https://openairdocs.org/ntsb/LAX84LA401.md): Beech H18S · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Jul 17, 1984 · N21S · Destroyed
  > During takeoff at about 50 ft AGL & 4,000 ft down rwy 4R, the right eng lost power. According to the plt, his airspeed was 105 mph & the right eng 'popped' before it lost power. He also stated that power on the left eng deteriorated after the the right prop…
- [NTSB DEN84LA226](https://openairdocs.org/ntsb/DEN84LA226.md): Cessna 172 · W Bountiful, UT · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 1984 · N4044F · Substantial damage
  > The acft was a Cessna 172 that had been converted to a 'Texas taildragger' in accordance with an approved STC. The purpose of the flt was for the plt to obtain a biennial flt review. He stated that immediately after takeoff, the eng began to progressively…
- [NTSB ATL84LA221](https://openairdocs.org/ntsb/ATL84LA221.md): Cessna 172K · Fayetteville, WV · Accident · No injuries · Limited investigation · Final report · Jul 17, 1984 · N46547 · Substantial damage
  > The plt stated that the eng suddenly lost power as he was climbing thru about 150 ft AGL. He continued straight ahead & landed after the acft brushed the top of a small tree then hit another small tree. No reason for the loss of power was found. One of the…
- [NTSB ANC84FA116](https://openairdocs.org/ntsb/ANC84FA116.md): Helio H-250 · Fairbanks, AK · Accident · No injuries · Field investigation · Final report · Jul 17, 1984 · N6321V · Substantial damage
  > The acft nosed up after takeoff to an aprx 75 deg pitch angle in spite of nose down control input. The plt pulled off all power and the acft fell to the ground. Post accident investigation revealed that the acft was about 392 lbs over gross weight and 5.13…
- [NTSB SEA84FA173](https://openairdocs.org/ntsb/SEA84FA173.md): Cessna Wren 182G-460 · Winlock, WA · Accident · 4 fatal · Field investigation · Final report · Jul 16, 1984 · N3156S · Destroyed
  > The Cessna 182 was equipped with a wren conversion for stol operations. The plt took off from an agricultural field toward the southwest with 3 passengers on board. Subsequently, the acft collided with trees beyond the departure end of the takeoff area, after…
- [NTSB CHI84LA296](https://openairdocs.org/ntsb/CHI84LA296.md): Luscombe 8A · Madison, IN · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N1187B · Substantial damage
  > The pilot stated after the accident that he performed a preflight inspection of the acft and did an engine run-up before takeoff. During climbout, at an altitude of 150 feet the plt experienced an engine failure. An emergency landing was made in trees. The…
- [NTSB NYC84LA245](https://openairdocs.org/ntsb/NYC84LA245.md): Piper PA-30 · Manahawkin, NJ · Accident · No injuries · Limited investigation · Final report · Jul 15, 1984 · N68Y · Destroyed
  > The acft descended out of control into trees and slid down an embankment. The plt said everything seemed normal on takeoff until the acft was put into a climb at about 93 mph at 50 ft AGL the acft began vibrating and veered about 90 degrees to the right. An…
- [NTSB LAX84LA393](https://openairdocs.org/ntsb/LAX84LA393.md): Piper PA-28-140 · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1984 · N7445R · Substantial damage
  > The eng lost power after takeoff at about 150 ft AGL & the landing gear collapsed during the forced landing. The nose landing light rubber seal had separated & entered into the carburetor causing air blockage.
- [NTSB CHI84LA297](https://openairdocs.org/ntsb/CHI84LA297.md): Piper PA-28-140 · North Liberty, IN · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1984 · N6762W · Substantial damage
  > The plt had changed departure runway due to shifting winds of 10-15 KTS, electing rwy 18 when wind seemed favorable. On initial climb, aircraft performance was insufficient to clear trees at end of runway. Acft came to rest in trees. Acft manual specifies…
- [NTSB NYC84FNE03](https://openairdocs.org/ntsb/NYC84FNE03.md): Piper J4A · Gardner, MA · Accident · 1 fatal · Final report · Jul 14, 1984 · N33290 · Destroyed
  > During climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…
- [NTSB ATL84LU007](https://openairdocs.org/ntsb/ATL84LU007.md): Teraton TA · Snellville, GA · Accident · Serious injuries · Final report · Jul 13, 1984 · UNREG · Substantial damage
  > After making a touch & go landing, the plt was unable to climb over trees at the departure end of the rwy. Subsequently, the ultralight vehicle lodged in a tree about 40 to 50 ft AGL. The plt said that he was not injured during the impact with the tree.…
- [NTSB DEN84LU008](https://openairdocs.org/ntsb/DEN84LU008.md): Weedhopper Unknown · Spanish Fork, UT · Accident · Serious injuries · Final report · Jul 12, 1984 · UNREG · Substantial damage
  > The ultralight was taking off from a street with obstructions on either side. The plt said that during the climbout, he encountered a x-wind from the north which blew him into a lamp post. The vehicle and pole were damaged and the vehicle crashed to the…
- [NTSB MKC84LA212](https://openairdocs.org/ntsb/MKC84LA212.md): Cessna 172 · Beuamont, KS · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N21AT · Substantial damage
  > The plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…
- [NTSB MKC84LA205](https://openairdocs.org/ntsb/MKC84LA205.md): Hiller H-23D · Neelyville, MO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N48313 · Destroyed
  > The acft rolled over during an emergency landing. The plt claimed that the rotor disengaged at about 30 ft AGL during takeoff. After the accident the upper half of the yoke control was found fractured. A lab report stated that no materialdefects were related…

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

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

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