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

## Cases, newest first

- [NTSB ATL87LA098](https://openairdocs.org/ntsb/ATL87LA098.md): Mooney M20F · Winnsboro, SC · Accident · No injuries · Limited investigation · Final report · Mar 26, 1987 · N6990V · Substantial damage
  > The acft hit a ditch during a forced landing after a power loss on takeoff. The acft had received annual inspection during which no contamination of the fuel system was found. The acft was parked outside, in the rain, to await the owner's pickup. The fuel…
- [NTSB CHI87MA101](https://openairdocs.org/ntsb/CHI87MA101.md): Mcdonnell Douglas DC-10-10 · Chicago, IL · Accident · Serious injuries · Major investigation · Final report · Mar 25, 1987 · N128AA · No damage
  > After arriving at the gate in Chicago, fumes & smoke were noted in zone c of the cabin, then the cabin lgtg went out & the emerg lgtg came on. Maint psnl fnd the #2 APU had an auto-shutdown due to a malfunction. The APU was placarded as inop & the acft was…
- [NTSB LAX87DVD02](https://openairdocs.org/ntsb/LAX87DVD02.md): Culver Cadet LFA · Antioch, CA · Accident · 1 fatal · Final report · Mar 24, 1987 · N37838 · Destroyed
  > During a local pleasure flt, witnesses observed the acft take-off into a headwind. At aprx 1000 ft AGL, the nose of the acft came up then down. The acft entered a spin and collided with the terrain. They also stated that the propeller appeared to be slowing…
- [NTSB MIA87LA116](https://openairdocs.org/ntsb/MIA87LA116.md): Bell 47-D1 · Homosassa, FL · Accident · No injuries · Limited investigation · Final report · Mar 22, 1987 · N88929 · Substantial damage
  > The plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.
- [NTSB MKC87LA063](https://openairdocs.org/ntsb/MKC87LA063.md): Glasair SH2 · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Mar 21, 1987 · N67SH · Destroyed
  > Immediately after takeoff, the engine stopped and the acft collided with trees and then the terrain. Inspection revealed contamination in the fuel tank, the lines and the filter. Contamination was water, dirt, straw and gravel. The fuel being used was regular…
- [NTSB MKC87FA064](https://openairdocs.org/ntsb/MKC87FA064.md): Cessna T337C · Garden City, KS · Accident · No injuries · Field investigation · Final report · Mar 21, 1987 · N2600S · Substantial damage
  > Both of the acft engs had just been overhauled. The plt decided to make a maint test flt & elected to leave the lndg gear in the down & locked psn. Takeoff & initial climb were normal until about 300 to 400 ft AGL. At that time the rear eng lost power. The…
- [NTSB CHI87LA102](https://openairdocs.org/ntsb/CHI87LA102.md): Luscombe 8A · Merrill, WI · Accident · No injuries · Limited investigation · Final report · Mar 21, 1987 · N25333 · Substantial damage
  > Aircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…
- [NTSB LAX87LA145](https://openairdocs.org/ntsb/LAX87LA145.md): Cessna U206A · Williams, AZ · Accident · No injuries · Limited investigation · Final report · Mar 14, 1987 · N8058Z · Substantial damage
  > During a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…
- [NTSB FTW87LA081](https://openairdocs.org/ntsb/FTW87LA081.md): Cessna 185A · Midland, TX · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N3306R · Substantial damage
  > During take off, the aircrafts engine failed due to fuel exhaustion. The pilot made an emergency forced landing in a rough uneven field, causing substantial damage to the left wing spar, left main gear, and left elevator. The pilot did not hold a…
- [NTSB MKC87LA061](https://openairdocs.org/ntsb/MKC87LA061.md): Cessna 182J · Archie, MO · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N3124F · Substantial damage
  > The plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…
- [NTSB LAX87LA141](https://openairdocs.org/ntsb/LAX87LA141.md): Piper PA-23-250 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N62750 · Substantial damage
  > While clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…
- [NTSB MIA87LA104](https://openairdocs.org/ntsb/MIA87LA104.md): Piper PA-24-250 · Navarre, FL · Accident · No injuries · Limited investigation · Final report · Mar 11, 1987 · N7645P · Substantial damage
  > Shortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…
- [NTSB MIA87LA102](https://openairdocs.org/ntsb/MIA87LA102.md): Piper PA-32-300 · St. Thomas · Accident · No injuries · Limited investigation · Final report · Mar 10, 1987 · N55682 · Substantial damage
  > The pilot stated that as he lifted off the aircraft encountered a gust of wind. The pilot lost control of the aircraft and it struck a displaced threshold sign and the ground.
- [NTSB ATL87LA084](https://openairdocs.org/ntsb/ATL87LA084.md): Grumman G-164A · Leslie, GA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1987 · N8721H · Substantial damage
  > The plt reported losing power shortly after takeoff; a forced ldg was subsequently made in a freshly-plowed field where the acft flipped over. Examination of the engine revealed a cracked #7 cyl head. FAA service difficulty reports (sdr's) indicated that…
- [NTSB LAX87LA138](https://openairdocs.org/ntsb/LAX87LA138.md): Piper PA-28RT-201T · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N8162X · Substantial damage
  > Just after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…
- [NTSB LAX87DVA04](https://openairdocs.org/ntsb/LAX87DVA04.md): Hiller OH-23G · Delano, CA · Accident · No injuries · Final report · Mar 8, 1987 · N99232 · Substantial damage
  > During an aerial application flight, the pilot returned to the loading truck for approximately 5 additional gallons of chemical to finish the application. The loader; however, loaded 70 gallons and when the pilot took off the rotor RPM began to bleed off. The…
- [NTSB CHI87LA093](https://openairdocs.org/ntsb/CHI87LA093.md): Piper PA-28-140 · Genoa, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 1987 · N4200J · Substantial damage
  > The aircraft experienced a loss of power on takeoff, for undetermined reasons, and was forced to make an emergency landing. On impact the nose gear and main landing gear sheared off.
- [NTSB CHI87DEE06](https://openairdocs.org/ntsb/CHI87DEE06.md): Schleicher ASK-21 · Plainfield, IL · Accident · No injuries · Final report · Mar 7, 1987 · N694KS · Substantial damage
  > The glider plt rprtd that drg takeoff, the tow plt released the tow rope at aprx 15' AGL. Rprtdly, he released the tow rope due to a perceived lack of takeoff & climb performance. After being released, the glider plt made a right turn to avoid unacceptable…
- [NTSB ATL87LA081](https://openairdocs.org/ntsb/ATL87LA081.md): Piper PA-22-160 · Toronto, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 1987 · N9412D · Substantial damage
  > The plt reported that the engine quit completely after takeoff at about 50-75 ft AGL without any warning. The plt attempted to land back on the rwy and the acft overran the rwy end. Examination of the acft after the accident revealed no malfunctions, defects,…
- [NTSB DEN87LA063](https://openairdocs.org/ntsb/DEN87LA063.md): Champion 7KCAB · Erie, CO · Accident · No injuries · Limited investigation · Final report · Mar 5, 1987 · N2629G · Substantial damage
  > Acft lifted off at slow airspeed and stalled/mushed back to rwy.
- [NTSB ANC87LA044](https://openairdocs.org/ntsb/ANC87LA044.md): Piper PA-11 · Nenana, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 1987 · N4724M · Substantial damage
  > The pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…
- [NTSB ANC87LA049](https://openairdocs.org/ntsb/ANC87LA049.md): Champion &GCBC · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Mar 3, 1987 · N2586G · Substantial damage
  > The pilot stated that during the initial climb out he lost directional control of the aircraft causing the plane to stall and strike a small tree next to the runway. At the time of the accident the wind was 330 degrees at 3 knots.
- [NTSB MKC87LA053](https://openairdocs.org/ntsb/MKC87LA053.md): Beech C23 · Grain Valley, MO · Accident · No injuries · Limited investigation · Final report · Mar 1, 1987 · N6001M · Substantial damage
  > The plt reported that the preflight eng run-up was satisfactory. Shortly after takeoff, the eng faultered briefly and the plt attempted a landing back on the rwy. Upon establishing a point to land, the eng responded and the acft overshot the intended landing…
- [NTSB LAX87MA125](https://openairdocs.org/ntsb/LAX87MA125.md): Boeing 727-224 · Los Angeles, CA · Accident · No injuries · Major investigation · Final report · Feb 26, 1987 · N88704 · 2 aircraft · No damage
  > After a ngt lndg on north side of Los Angeles intl arpt, Cessna 310, N98834, was taxied south (s) to delta cargo area. Bfr rchg s rwys (25L & 25R), the plt stopped short of kilo ramp bhnd another acft (N61C) & contacted s gnd ctlr (GC-1). He was told to hold…
- [NTSB MIA87LA092](https://openairdocs.org/ntsb/MIA87LA092.md): Piper J5A · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Feb 24, 1987 · N41141 · Substantial damage
  > Shortly after take off the eng began to lose power. Unable to maintain alt a forced landing was made in a field, during which, the acft sustained substantial damage. Inspection of the acft revealed that the loss of power was the result of an insufficient fuel…
- [NTSB LAX87DVA03](https://openairdocs.org/ntsb/LAX87DVA03.md): Eagle DW-1 · Modesto, CA · Accident · No injuries · Final report · Feb 24, 1987 · N8808E · Substantial damage
  > During an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…
- [NTSB FTW87LA069](https://openairdocs.org/ntsb/FTW87LA069.md): Bell 47G · Sand Springs, OK · Accident · No injuries · Limited investigation · Final report · Feb 23, 1987 · N6330D · Substantial damage
  > Instructor plt was demonstrating a confined area takeoff to the pvt plt taking advance instruction. As the acft cleared the barriers, the quartering head wind shifted to a tail wind and the acft lost translational lift. Application of full power did not…
- [NTSB LAX87LA118](https://openairdocs.org/ntsb/LAX87LA118.md): Cessna 172RG · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1987 · N4590V · Substantial damage
  > During a local pleasure flight, the pilot returned to the airport to practice touch-and-go landings. On take-off, ascending through 200 feet, the engine began to surge then quit. The pilot made a forced landing on an occupied road where the aircraft collided…
- [NTSB CHI87FA085](https://openairdocs.org/ntsb/CHI87FA085.md): Beech E18S · Quincy, IL · Accident · 2 fatal · Field investigation · Final report · Feb 18, 1987 · N149R · Destroyed
  > The acft, at near gross weight (CG unknown), was on initial climb after takeoff. A witness reported that engines soundednormal. At about 400 ft AGL the acft was reported to pitch up about 10 degrees, then level off and enter a left turn. The acft made another…
- [NTSB NYC87LA086](https://openairdocs.org/ntsb/NYC87LA086.md): Cessna 152 · Old Bridge, NJ · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1987 · N25498 · Substantial damage
  > The Cessna 152 took off and after becoming airborne, experienced a total loss of power. The student pilot who had made the takeoff turned control of the aircraft over to the flight instructor, who made an emergency landing in a drag strip parking lot which…
- [NTSB ATL87DEG03](https://openairdocs.org/ntsb/ATL87DEG03.md): Richard A. Brown Falco F-8L · Mc Arthur, OH · Accident · 2 fatal · Final report · Feb 13, 1987 · N894RB · Destroyed
  > PIC and acft owner landed at a/p and req fuel which was not avail. Acft left to fly to another a/p. during initial climb engine quit at 300-400 feet. PIC turned back toward rwy, acft stalled, impacted ground in 90 degree left wing low attitude. Other pilots…
- [NTSB SEA87LA056](https://openairdocs.org/ntsb/SEA87LA056.md): Cessna 150 · Mountain Home, ID · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N50724 · Substantial damage
  > Acft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…
- [NTSB DEN87LA053](https://openairdocs.org/ntsb/DEN87LA053.md): Mooney M20C · Eureka, SD · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 1987 · N3451X · Substantial damage
  > After normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.
- [NTSB LAX87FA112](https://openairdocs.org/ntsb/LAX87FA112.md): Hughes 369D · Honolulu, HI · Accident · 1 fatal · Field investigation · Final report · Feb 9, 1987 · N1102U · Destroyed
  > Drg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…
- [NTSB LAX87LA110](https://openairdocs.org/ntsb/LAX87LA110.md): Cessna 150L · Ayase, Japan · Accident · 2 fatal · Limited investigation · Final report · Feb 7, 1987 · N6797G · Substantial damage
  > During an instructional flight, just after take-off the instructor was heard to transmit over the radio 'request emergency landing.' At an altitude of approximately 15O feet AGL the aircraft was observed to pitch up then nosed down in a shallow left turn. The…
- [NTSB CHI87LA080](https://openairdocs.org/ntsb/CHI87LA080.md): Aeronca 7EC · Big Fork, MN · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N4715E · Substantial damage
  > After several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…
- [NTSB CHI87LA078](https://openairdocs.org/ntsb/CHI87LA078.md): Cessna 182P · Utica, MI · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N7088Q · Substantial damage
  > The pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…
- [NTSB LAX87DVD01](https://openairdocs.org/ntsb/LAX87DVD01.md): Bell 47G4A · Stockton, CA · Accident · Serious injuries · Final report · Feb 2, 1987 · N28938 · Substantial damage
  > Just after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…
- [NTSB FTW87LA051](https://openairdocs.org/ntsb/FTW87LA051.md): Piper PA-28-161 · Marfa, TX · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N47849 · Substantial damage
  > The pilot stalled the aircraft while attempting to climb too steeply during takeoff from an old abandoned airport. The aircraft veered left, descended, and struck the ground before flying speed could be regained.
- [NTSB CHI87LA073](https://openairdocs.org/ntsb/CHI87LA073.md): Cessna 182M · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N71383 · Substantial damage
  > The aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…
- [NTSB FTW87LA052](https://openairdocs.org/ntsb/FTW87LA052.md): Cessna 172P · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N98816 · Substantial damage
  > Private pilot in Cessna 172P with three passengers aboard attempted to take off with 60 degree, 9 knot cross-wind component. Pilot rotated aircraft prematurely causing stall warning horn to activate and airspeed to dissipate. Pilot lowered nose of aircraft in…
- [NTSB ATL87LA068](https://openairdocs.org/ntsb/ATL87LA068.md): Cessna 150M · Pinson, AL · Accident · 1 fatal · Limited investigation · Final report · Jan 31, 1987 · N704FT · Substantial damage
  > During intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…
- [NTSB CHI87LA068](https://openairdocs.org/ntsb/CHI87LA068.md): Cessna 172N · Madison, IN · Accident · No injuries · Limited investigation · Final report · Jan 27, 1987 · N4688D · Substantial damage
  > At aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…
- [NTSB LAX87LA098](https://openairdocs.org/ntsb/LAX87LA098.md): Grumman AA-1B · Tracy, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1987 · N1408R · Substantial damage
  > Just after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…
- [NTSB FTW87FA047](https://openairdocs.org/ntsb/FTW87FA047.md): Cessna 150F · Rio Vista, TX · Accident · Serious injuries · Field investigation · Final report · Jan 24, 1987 · N8033F · Destroyed
  > Private pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…
- [NTSB CHI87DEC01](https://openairdocs.org/ntsb/CHI87DEC01.md): Cessna 150 · Troy, MI · Accident · Serious injuries · Final report · Jan 24, 1987 · N5634E · Destroyed
  > Outside air temperature was approximately 5 degress f when the aircraft on initial climb experienced a total power loss. The pilot lowered the nose and attempted to make a turn to return to the runway. The aircraft did complete approximately 180 to 190…
- [NTSB ANC87LA026](https://openairdocs.org/ntsb/ANC87LA026.md): Cessna 180J · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1987 · N46362 · Substantial damage
  > After takeoff and during the initial climbout, the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft struck a row of trees at the departure end of the runway. The plts flt time was not reported or available.
- [NTSB LAX87FA088](https://openairdocs.org/ntsb/LAX87FA088.md): Piper PA-24-180 · Oceano, CA · Accident · 3 fatal · Field investigation · Final report · Jan 17, 1987 · N5982P · Substantial damage
  > Shortly after takeoff, the surviving pax (s/p) noticed the acft began losing alt. She heard the plt comment about a 'clicking noise in the left wing' which she also heard & said sounded like metal clicking together. Ground witnesses noticed a change in eng…
- [NTSB FTW87FA045](https://openairdocs.org/ntsb/FTW87FA045.md): Beech 65-80 · Brownsville, TX · Accident · No injuries · Field investigation · Final report · Jan 15, 1987 · N1590S · Substantial damage
  > Commercial pilot departed Brownsville, TX (bro) on special VFR flight plan. During initial climb, at approximately 300 ft AGL both engines quit due to fuel starvation. Forced landing was made to unimproved field. Aircraft sustained substantial damage. Pilot…
- [NTSB LAX87FA085](https://openairdocs.org/ntsb/LAX87FA085.md): Beech F33A · Sacramento, CA · Accident · 4 fatal · Field investigation · Final report · Jan 14, 1987 · N1067W · Destroyed
  > The winds at the airport had been reported as strong and gusting. After his passengers arrived, the pilot requested and received taxi instructions to the active runway which was aprx 3700 ft from his parking space. About 2-1/2 mins after receiving his taxi…

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

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

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