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

## Cases, newest first

- [NTSB LAX83LA415](https://openairdocs.org/ntsb/LAX83LA415.md): Piper PA-22 · Arden, NV · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 1983 · N628A · Substantial damage
  > Between 50-100 ft AGL after takeoff the eng quit. Examination revealed that the fuel supply line between the left wing fuel tank & the fuselage had failed.
- [NTSB FTW83LA394](https://openairdocs.org/ntsb/FTW83LA394.md): Air Tractor AT301 · El Campo, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1983 · N4369S · Substantial damage
  > The acft collided with a berm dam during takeoff and cartwheeled into a rice field. The acft carried heavier fertilizer on this particular takeoff and with increasing Air temperatures, the plt knew he was not going to make it and dumped the load. The dump…
- [NTSB SEA83LA180](https://openairdocs.org/ntsb/SEA83LA180.md): Cessna 185 Skywagon · Petersburg, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1983 · N8700Z · Substantial damage
  > The acft made a forced landing in a marshy area and nosed over after the engine quit during takeoff. The pilot stated that after takeoff at about 100 ft AGL during a right turn the engine sputtered. He made a slight adjustment to the throttle and the engine…
- [NTSB DEN83LA196](https://openairdocs.org/ntsb/DEN83LA196.md): Beech C23 · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Aug 23, 1983 · N6004V · Substantial damage
  > The student plt, a foreign national, and the instructor plt (CFI) took off from broomfield, CO & flew to Longmont, CO where they began practicing touch & go landings. After the 3rd touch & go landing, the acft was climbing at about 300 ft AGL when the student…
- [NTSB ATL83FA337](https://openairdocs.org/ntsb/ATL83FA337.md): Cessna 414A · Marion, NC · Accident · Minor injuries · Field investigation · Final report · Aug 23, 1983 · N5ER · Destroyed
  > During the takeoff run, at 85 KTS, the acft hit a bump & the plt stated his forward vision was obstructed by water on the windshield. He instinctively pulled back on the controls & become airborne. He lost sight of the right side set of rwy lights & was…
- [NTSB LAX83LA402](https://openairdocs.org/ntsb/LAX83LA402.md): Cessna 152 · Douglas, AZ · Accident · No injuries · Limited investigation · Final report · Aug 22, 1983 · N25593 · Substantial damage
  > The acft crashed during takeoff. The acft was observed in a nose high attitude estimated to be 65 degrees before it stalled at about 30 ft AGL. The right wing dropped and the acft contacted the ground about 250 ft west of the rwy skidded across a taxiway and…
- [NTSB LAX83FA400](https://openairdocs.org/ntsb/LAX83FA400.md): Bell 206-B · Battle Mountain, NV · Accident · Minor injuries · Field investigation · Final report · Aug 22, 1983 · N17355 · Destroyed
  > The helicopter lost power during takeoff,touched down on the left skid,bounced and rolled over. The flt had originated at 1315 at a local field and proceeded to pick up a passenger at another location. The acft had just landed, picked up the passenger and was…
- [NTSB MKC83LA194](https://openairdocs.org/ntsb/MKC83LA194.md): Leonard Spiezo Sport · Mt. Vernon, MO · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N24840 · Substantial damage
  > The acft collided with the rwy during takeoff. The wind was gusty and the temperature was high at 100 degrees f. the arpt elevation is 1240 ft MSL. The pilot stated that after takeoff he was climbing at about 200 ft AGL when a gust of wind dropped the right…
- [NTSB LAX83LU012](https://openairdocs.org/ntsb/LAX83LU012.md): Manta Products Fledge 2B-FOXBAT · Penn Valley, CA · Accident · Serious injuries · Final report · Aug 21, 1983 · UNREG · Substantial damage
  > The ultralight vehicle collided with a tree after a power loss during takeoff climb. The pilot stated that he accomplished a normal preflt and walked over the field before his first takeoff. After takeoff, all went well for about 1 minute then a power loss…
- [NTSB FTW83FA387](https://openairdocs.org/ntsb/FTW83FA387.md): Beech V35 · Conchas, NM · Accident · 4 fatal · Field investigation · Final report · Aug 21, 1983 · N5429U · Destroyed
  > It was reported that the plt had been giving rides to various family members & the acft was observed flying in the area of Conchas lake on several occasions. It was also reported that the acft had 'buzzed' boats on the lake several times during the day. The…
- [NTSB CHI83LA391](https://openairdocs.org/ntsb/CHI83LA391.md): Demeter Hummer B · Linden, MI · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N77DE · Substantial damage
  > The ultralight acft crashed after takeoff when the engine failed at about 100 ft AGL. The acft climbed to about 100 ft AGL at a distance of about 240 ft from the end of the rwy. At this point the engine quit and the pilot started a 180 degree turn toward an…
- [NTSB CHI83LA390](https://openairdocs.org/ntsb/CHI83LA390.md): Cessna 177 · Cadiz, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1983 · N2835X · Destroyed
  > The plt elected to takeoff on an upsloping rwy since the wind was favorable for its direction. However, the temp was 84 degs, the elevation was 1174 ft & there was a hill beyond the end of the rwy. Additionally, the acft was loaded to near its maximum gross…
- [NTSB ATL83LA333](https://openairdocs.org/ntsb/ATL83LA333.md): Cessna C-182J · Savannah, GA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1983 · N2670F · Substantial damage
  > The acft crashed right after takeoff when the it went into an uncommanded uncontrolled turn to the right. The acft was slightly over max gross takeoff weight but the CG was within limits. This acft was equipped with an autopilot. Post accident investigation…
- [NTSB SEA83LA181](https://openairdocs.org/ntsb/SEA83LA181.md): Beech 35 · Decatur Island, WA · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N3038V · Substantial damage
  > The acft collided with the ground during a short field takeoff attempt. According to the pilot he was using 10 degree of flaps during a short field takeoff. The acft yawed to the left & the pilot lowered the nose to regain control. Directional control was…
- [NTSB NYC83LA218](https://openairdocs.org/ntsb/NYC83LA218.md): Cessna 150L · Farmingdale, NJ · Accident · No injuries · Limited investigation · Final report · Aug 20, 1983 · N19049 · Substantial damage
  > Student plt was on first solo, acft operated by army flying club. During initial climb eng quit due to fuel exhaustion. Acft landed in gravel pit & flipped over.
- [NTSB CHI83LA388](https://openairdocs.org/ntsb/CHI83LA388.md): Great Lakes 2T-1A-2 · Bloomington, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 1983 · N2XG · Substantial damage
  > The plt reported that during takeoff, there was a loss of power at appx 100 ft AGL. He had lifted off before reaching the midpoint of the rwy. However, due to the climb attitude & configuration of the acft, he could not see the rwy below & thought he was at…
- [NTSB ANC83IA150](https://openairdocs.org/ntsb/ANC83IA150.md): Piper PA-31-350 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Aug 20, 1983 · N200VF · Minor damage
  > During takeoff at kodiak, AK, the wheel & lower shaft of the left strut assy separated from the acft. The plt stated that when he was retracting the gear, he felt a bump & got an unsafe gear light. He immeditaely extended the gear & flew by the tower & was…
- [NTSB ATL83LA331](https://openairdocs.org/ntsb/ATL83LA331.md): Piper PA-28-180 · Mt. Airy, NC · Accident · No injuries · Limited investigation · Final report · Aug 19, 1983 · N6439J · Substantial damage
  > A loss of engine power during takeoff for undetermined reasons. A contributing factor was unsuitable terrain for a forced landing.
- [NTSB NYC83FA214](https://openairdocs.org/ntsb/NYC83FA214.md): Gates Learjet 25B · Wilmington, DE · Accident · No injuries · Field investigation · Final report · Aug 17, 1983 · N108PA · Substantial damage
  > After lift-off a flock of birds approached from left to right at about 400 ft. the plt maneuvered the acft behind & above the birds in an attempt to avoid them. Both engs flamed out & the acft mde a forced landing on a road. Ground witnesses described the…
- [NTSB MIA83FA207](https://openairdocs.org/ntsb/MIA83FA207.md): Beech A100 · Vieques, PR · Accident · No injuries · Field investigation · Final report · Aug 17, 1983 · N129D · Substantial damage
  > The acft crash landed during a touch and go landing. The plt said that the acft was caught in a windshear or violent downdraft and would not climb. He did not say why he was doing a touch and go landing with 9 passengers on board. The plts account of the…
- [NTSB MIA83FA203](https://openairdocs.org/ntsb/MIA83FA203.md): Scarboro COUGAR-1 · Lantana, FL · Accident · Serious injuries · Field investigation · Final report · Aug 17, 1983 · N3538 · Destroyed
  > During a touch & go takeoff the engine quit. The pilot entered a steep turn to return to the airport and crashed into trees. Post accident investigation revealed only 1/2 pt of automotive fuel was in the acft.
- [NTSB ANC83FA146](https://openairdocs.org/ntsb/ANC83FA146.md): Cessna C-206 · Anchorage, AK · Accident · 2 fatal · Field investigation · Final report · Aug 15, 1983 · N70531 · Destroyed
  > Prior to the flight N70531 was noted to have the entire cabin area full of cardboard fish packing boxes and empty 5 gal buckets stuffed one inside the other. The acft was noted to be heavier than normal during repositioning operations. The plt stated during a…
- [NTSB NYC83FNA05](https://openairdocs.org/ntsb/NYC83FNA05.md): Lake LA-4-200 · Stow, MA · Accident · Serious injuries · Final report · Aug 14, 1983 · N80044 · Substantial damage
  > During takeoff, the plt encountered a noticeable loss of power & lowered the nose to maintain airspeed. The acft continued to lose altitude, so he selected an open field for an emergency landing. While landing on uneven terrain, the left wing struck the…
- [NTSB LAX83LA385](https://openairdocs.org/ntsb/LAX83LA385.md): Grumman G-164A · Mohave Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1983 · N6TF · Substantial damage
  > During takeoff after reaching about 15 ft AGL, the plt heard a 'loud bang' & the acft shuddered. Immediately thereafter a substantial loss of power occurred. The plt stated he decreased the acft's pitch attitude to avoid stalling. Seconds later the left wing…
- [NTSB CHI83LER02](https://openairdocs.org/ntsb/CHI83LER02.md): Cessna T188C · Olivia, MN · Accident · No injuries · Final report · Aug 14, 1983 · N2060J · Substantial damage
  > During takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…
- [NTSB NYC83LA211](https://openairdocs.org/ntsb/NYC83LA211.md): Cessna 182P · West Milford, NJ · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N91389 · Substantial damage
  > The acft had attained an alt of 300 ft AGL when the engine lost power. The pilot turned back 180 degrees toward a clearing near the arpt. The acft went through some trees and made a hard landing which collapsed the nose gear. An annual inspectin had just been…
- [NTSB MKC83LA191](https://openairdocs.org/ntsb/MKC83LA191.md): Cessna 177B · East Amana, IA · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N1347C · Substantial damage
  > The plt stated that he had flown into & out of the arpt numerous times. He said that during a takeoff, the acft normally became airborne after about 900 ft of ground roll. Also, he said that on this flt with 4 passengers, the acft lifted off at about the same…
- [NTSB DEN83LA197](https://openairdocs.org/ntsb/DEN83LA197.md): Piper PA-28RT-201T · Vernal, UT · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N29649 · Substantial damage
  > During takeoff initial climb, as the gear was retracted, the turbo charger overboost light flashed once & the eng coughed & quit. The plt stated all gages were normal until the eng quit. The acft was still over the rwy, & the plt maintained 75 KTS with 1…
- [NTSB CHI83FET02](https://openairdocs.org/ntsb/CHI83FET02.md): Cessna 120 · Fort Wayne, IN · Accident · No injuries · Final report · Aug 13, 1983 · N77372 · Substantial damage
  > The engine quit at about 50 ft AGL during the second takeoff near mid rwy. The pilot tried to restart the engine and lost the opportunity to try to land on the remaining rwy. The acft landed in an adjoining soybean field. The left fuel tank was empty. The…
- [NTSB MIA83LA201](https://openairdocs.org/ntsb/MIA83LA201.md): Cessna 206 · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · Aug 12, 1983 · N5140U · Substantial damage
  > During the previous week the acft had been outside & several heavy rainshowers occurred. Both the plt & the plt-rated passenger stated they drained the fuel tanks using a one-pound coffee can & did not notice any appreciable amount of water. After takeoff…
- [NTSB CHI83FA381](https://openairdocs.org/ntsb/CHI83FA381.md): Beech G18S · Evart, MI · Accident · 2 fatal · Field investigation · Final report · Aug 11, 1983 · N400NA · Destroyed
  > The acft collided with a utility pole and a large tree during a forced landing after a power loss on takeoff. Witnesses heard the acft backfiring and the ground run was excessively long. Immediately after takeoff the acft went through the tops of pine trees.…
- [NTSB FTW83LA370](https://openairdocs.org/ntsb/FTW83LA370.md): Cessna 182Q · Portland, TX · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N771SB · Substantial damage
  > The plt stated that shortly after takeoff, he heard a 'loud bang' which was followed by a rattling sound & a loss of eng power. He had taken off over water & elected to make a 180 deg turn to land downwind on the arpt. The acft touched down at about the…
- [NTSB ATL83LA321](https://openairdocs.org/ntsb/ATL83LA321.md): Piper PA-28-140 · Jamestown, TN · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N4552T · Substantial damage
  > The acft crashed in trees during a forced landing after takeoff. The pilot said that during climbout the engine failed to develop full power. The pilot reported that the carburetor heat control was in the cold position. The pilot elected to land straight…
- [NTSB ATL83LA320](https://openairdocs.org/ntsb/ATL83LA320.md): Cessna 172 · Folkstone, NC · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N4245F · Substantial damage
  > The plt reported that during takeoff, his seat slid all the way aft. When this occurred, he pulled the yoke aft & the acf entered a power on stall & crashed. Reportedly, the plt did not secure the seat before taking off.
- [NTSB MKC83FA184](https://openairdocs.org/ntsb/MKC83FA184.md): Cessna 172M · Minden, NE · Accident · Serious injuries · Field investigation · Final report · Aug 9, 1983 · N30545 · Substantial damage
  > A student plt in left seat made the takeoff using 10 deg flaps. At about 50 ft AGL passing over the departure end of therwy, the PIC noticed the acft was sinking & took the controls. The acft impacted trees as the PIC was avoiding power lines. The flaps were…
- [NTSB MIA83FA197](https://openairdocs.org/ntsb/MIA83FA197.md): Piper PA-28-150 · Brandon, FL · Accident · Serious injuries · Field investigation · Final report · Aug 8, 1983 · N5888W · Destroyed
  > The acft collided with trees and the ground after the engine lost power during takeoff. The CFI noted the RPM dropping to 2000 with full throttle and at about 75 AGL and tried to arrest the descent with flaps but was unsuccessful. One takeoff had been aborted…
- [NTSB CHI83LA369](https://openairdocs.org/ntsb/CHI83LA369.md): Cessna C-172 · Lowell, OH · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N12640 · Substantial damage
  > The acft collided with the ground during an attempted short field takeoff. While initiating a short field takeoff, the acft become airborne prematurely, veered to the left, struck corn stalks in a field along side the runway. The acft ground looped nose first…
- [NTSB SEA83LA169](https://openairdocs.org/ntsb/SEA83LA169.md): Cessna 150J · Grants Pass, OR · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N60754 · Substantial damage
  > The acft ran off the departure end of the rwy during a forced landing following engine failure during a touch and go landing. The nosewheel struck a mound of dirt and the acft nosed over. The acft had reached 40 ft AGL and 70 mph when the engine lost power…
- [NTSB SEA83FU008](https://openairdocs.org/ntsb/SEA83FU008.md): Pterodactyl Ptravler · Grants Pass, OR · Accident · Serious injuries · Final report · Aug 7, 1983 · UNREG · Substantial damage
  > The ultralight collided with the terrain in an uncontrolled descent after a takeoff during air taxi practice. The two prospective buyers were taking turns taxiing the vehicle while being instructed by the owner. One of the prospects during his 2nd taxi run…
- [NTSB FTW83FA362](https://openairdocs.org/ntsb/FTW83FA362.md): Cessna 172F · El Paso, TX · Accident · 3 fatal · Field investigation · Final report · Aug 7, 1983 · N5259F · Destroyed
  > Two plts & 2 passengers departed san angelo, TX, on a x-country flt, one of the plts, who had 95 hrs of flying time, was the pilot-in-command (PIC) for the 1st leg of the x-country to El Paso, TX. On the next leg, the other plt assumed duties as PIC & signed…
- [NTSB DEN83LA184](https://openairdocs.org/ntsb/DEN83LA184.md): Piper PA-28-140 · Erie, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1983 · N2893T · Substantial damage
  > The acft crashed shortly after takeoff in VMC wx conditions with an arpt elevation of 5145 ft MSL and tempertaure 86 degrees f. density alt was 7468 ft. in the pilots operating handbook the takeoff distance vs density alt chart goes to amax alt of 7000 ft. a…
- [NTSB ATL83FA313](https://openairdocs.org/ntsb/ATL83FA313.md): Cessna 177RGII · Atlanta, GA · Accident · Serious injuries · Field investigation · Final report · Aug 7, 1983 · N7507V · Substantial damage
  > Just before rotation & during climbout from rwy 26L the eng started surging. The acft made a left turn, into the wind, & the student plt attempted to land on rwy 8R. The acft became misaligned, overshot the rwy, & made a hard landing in the grass about 200 ft…
- [NTSB FTW83LA366](https://openairdocs.org/ntsb/FTW83LA366.md): Grumman G-164A · Jennings, LA · Accident · No injuries · Limited investigation · Final report · Aug 6, 1983 · N7396 · Substantial damage
  > The acft nosed over during a forced landing after the engine quit shortly after takeoff. The main landing gear mired in soft plowed earth and the acft nosed over during landing. The takeoff gross weight was 5290 lbs. After the accident the engine tear down…
- [NTSB ATL83FA312](https://openairdocs.org/ntsb/ATL83FA312.md): Sikorsky S-58D · Gatlingurg, TN · Accident · No injuries · Field investigation · Final report · Aug 6, 1983 · N6488 · Substantial damage
  > The helicopter collided with terrain on a wooded mountainside after liftoff. The plt said a power loss occurred after itwas to late to abort. Takeoff was made from a lot that was 5200 ft MSL. The plt hover-checked at 2500 RPM and 39.5 inches of manifold…
- [NTSB LAX83LVG16](https://openairdocs.org/ntsb/LAX83LVG16.md): Naval Aircraft Factory N3N-3-2939 · Lincoln, CA · Accident · Serious injuries · Final report · Aug 5, 1983 · N87697 · No damage
  > The pilot was performing touch and go landings to runway 15 and 33 at Lincoln municipal airport. Witnesses observed the pilot make a steep climb following a touch and go landing to runway 15. The aircraft crashed on the airport property.
- [NTSB CHI83FA370](https://openairdocs.org/ntsb/CHI83FA370.md): Zenair Cricket MC12 · Oshkosh, WI · Accident · Minor injuries · Field investigation · Final report · Aug 5, 1983 · CGAYW · Substantial damage
  > During a formation takeoff, the plt was flying in a left wingman position & the flt entered a relatively steep climb. The plt stated that the airspeed was slightly above the stall speed at about 100 to 150 ft AGL when the left eng lost power & the acft began…
- [NTSB CHI83FA359](https://openairdocs.org/ntsb/CHI83FA359.md): Piper PA-28-180D · Bay City, MI · Accident · 2 fatal · Field investigation · Final report · Aug 5, 1983 · CFWQV · Destroyed
  > After an overshoot landing attempt the pilot initiated a go-around the acft overan the end of the runway, traveled for about 330 ft and colided with a auto mobile. The roof ofthe auto was sheared off causing 2 fatal and 4 serious injuries.
- [NTSB LAX83FUG20](https://openairdocs.org/ntsb/LAX83FUG20.md): Grumman American AA-5A · Chino, CA · Accident · No injuries · Final report · Aug 3, 1983 · N26798 · Substantial damage
  > The pilot stated that on takeoff from a touch and go landing the acft lost power. The fuel boost pumps were on and the mixture was full rich. He switched fuel tanks but the engine did not regain power. The acft was landed in a hay field. A post accident run…
- [NTSB NYC83FHD04](https://openairdocs.org/ntsb/NYC83FHD04.md): Cessna 172L · Atlantic City, NJ · Accident · No injuries · Final report · Aug 2, 1983 · N9862G · Substantial damage
  > The plt made 2 attempts to takeoff. On the second attempt, the acft lifted off to about 30 ft. the plt stated that the eng lost RPM (from 2450 to 1700 RPM), so he aborted the takeoff. The acft porpoised about 3 times & continued off the end of the rwy & came…
- [NTSB CHI83LU006](https://openairdocs.org/ntsb/CHI83LU006.md): Fisher 101 · Grover Hill, OH · Accident · Serious injuries · Final report · Aug 2, 1983 · UNREG · Destroyed
  > The plt reported that after takeoff, he started a left turn. While climbing thru aprx 300 ft AGL, he lost aileron control. Reportedly, the ultralight vehicle was destroyed during a forced landing in a soybean field. The plt reported that the aileron cables…

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

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

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