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

## Cases, newest first

- [NTSB CHI86FA102](https://openairdocs.org/ntsb/CHI86FA102.md): Bellanca 17-30A · Frankfort, MI · Accident · 3 fatal · Field investigation · Final report · Mar 14, 1986 · N123RM · Destroyed
  > The plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…
- [NTSB SEA86LA127](https://openairdocs.org/ntsb/SEA86LA127.md): Cessna 150 · Morgan, OR · Accident · No injuries · Limited investigation · Final report · Mar 12, 1986 · N45174 · Substantial damage
  > During takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.
- [NTSB MIA86FA093](https://openairdocs.org/ntsb/MIA86FA093.md): Piper PA-28-140 · Kissimmee, FL · Accident · Serious injuries · Field investigation · Final report · Mar 8, 1986 · N877AP · Substantial damage
  > The flt departed with 18 gals in each fuel tank. After 1.8 hrs of flying, doing takeoffs and landings and a short flt to another arpt, the flt experienced an eng failure during takeoff from a touch and go landing. The plt failed to maintain directional…
- [NTSB FTW86FPA21](https://openairdocs.org/ntsb/FTW86FPA21.md): Cessna 150K · Cresson, TX · Accident · Minor injuries · Final report · Mar 7, 1986 · N6307G · Substantial damage
  > The flt departed with an estimated 8 to 9 gallons of fuel (auto gas) on board with a dual student and a flt instructor. Forty five minutes of touch-and-go landing practice was accomplished. On the sixth takeoff and about 30 feet above the ground the engine…
- [NTSB DEN86LA093](https://openairdocs.org/ntsb/DEN86LA093.md): Piper PA-38-112 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Mar 7, 1986 · N91319 · Substantial damage
  > Acccording to the student plt, touch and go landings were being practiced when the acft stalled on takeoff. Witnesses stated the plt lowered the nose in an attempt to recover from the stall, however, the acft contacted the rwy.
- [NTSB MIA86LA090](https://openairdocs.org/ntsb/MIA86LA090.md): Bellanca 7KCAB · New Smyrna Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1986 · N53805 · Substantial damage
  > The plt stated that just after picking up a banner, the acft stalled and started to roll to the left. The plt was unable to recover before the acft impacted the ground.
- [NTSB DEN86FTI01](https://openairdocs.org/ntsb/DEN86FTI01.md): Miller Sievers Special · Gillette, WY · Accident · Minor injuries · Final report · Mar 4, 1986 · N1175 · Substantial damage
  > On March 3, 1986 at approximately 1715 MST, an experimental Miller, sievers special, struck the ground during takeoff at the Gillette-campbell county airport, Gillette, Wyoming. The pilot stated that just after takeoff on runway 34, the aircraft appeared to…
- [NTSB MIA86LA088](https://openairdocs.org/ntsb/MIA86LA088.md): Beech D-18S · Pascagoula, MS · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N4446K · Substantial damage
  > The plt stated that he sensed a loss of pwr on one eng after takeoff, just prior to gear retraction. He elected to remove all pwr and land straight ahead on the remaining rwy. The acft went off the end of the rwy and entered a wet grass area. The acft could…
- [NTSB DEN86LA091](https://openairdocs.org/ntsb/DEN86LA091.md): Cessna 175 · Kulm, ND · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N7647M · Substantial damage
  > According to the plt, the eng lost partial pwr on takeoff due to carberetor ice. A forced landing was made during which the nose gear collapsed resulting in substantial damage to the acft.
- [NTSB DEN86LA088](https://openairdocs.org/ntsb/DEN86LA088.md): Aeronca 7AC · Santa Rosa, NM · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N85255 · Substantial damage
  > According to the plt, the eng quit during the initial climbout and the acft was substantially damaged during the subsequent forced landing. Post accident inspection disclosed the gascolator was broken which resulted in fuel starvation to the engine.
- [NTSB NYC86FNE02](https://openairdocs.org/ntsb/NYC86FNE02.md): Folsom Sonerai II · Middlebury, CT · Accident · No injuries · Final report · Mar 1, 1986 · N27EF · Substantial damage
  > The plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…
- [NTSB NYC86LA079](https://openairdocs.org/ntsb/NYC86LA079.md): Stinson 108 · Lyndonville, VT · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1986 · N108DT · Substantial damage
  > After the pilot performed a run up and all appeared normal a ground run was commenced. About 700' down the runway trim was set to climb out at about 76IAS. However, the pilot stated that a bad downdraft was encountered. A check of the airspeed was ok. At 200…
- [NTSB DEN86LA094](https://openairdocs.org/ntsb/DEN86LA094.md): Cessna 172M · Quemado, NM · Accident · No injuries · Limited investigation · Final report · Feb 26, 1986 · N8935V · Substantial damage
  > The plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…
- [NTSB ATL86FA081](https://openairdocs.org/ntsb/ATL86FA081.md): Robinson R22 · Greenville, TN · Accident · 1 fatal · Field investigation · Final report · Feb 23, 1986 · N90459 · Destroyed
  > The flt was last seen to depart rwy 23 at the Greenville arpt & enter a low cloud layer at ngt. A witness estimated the helicopter entered the clouds at about 300 to 400 ft AGL. No flt plan was filed. The wreckage was found the next day, located about 1/4 mi…
- [NTSB LAX86LA122](https://openairdocs.org/ntsb/LAX86LA122.md): Henley Aerodrome Fokker DR1 · Santa Ynez, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 1986 · N50CH · Destroyed
  > A homebuilt aerodrome fokker DR1 crashed after takeoff. The acft had been in storage for over 5 yrs and had just completed an annual inspection. The flt was a post annual inspection test flt. The plt had extensive experience maintaining and flying homebuilt…
- [NTSB FTW86LQG10](https://openairdocs.org/ntsb/FTW86LQG10.md): Piper PA-22-150 · Skellytown, TX · Accident · No injuries · Final report · Feb 20, 1986 · N9995D · Substantial damage
  > The pilot stated that his take off roll was longer than expected. Reaching the end of the runway, he rotated & the acft left the ground, but it did not establish a good rate of climb. Subsequently, the acft collided with a pole & crashed. The takeoff was…
- [NTSB ATL86LA076](https://openairdocs.org/ntsb/ATL86LA076.md): Piper J3L-65 · Sevierville, TN · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 1986 · N30233 · Substantial damage
  > During takeoff initial climb the engine lost power and a forced landing was initiated. During the descent the aircraft contacted treetops prior to ground impact. Post-crash examination of the engine disclosed that one of the cylinders had broken away from the…
- [NTSB MIA86FA076](https://openairdocs.org/ntsb/MIA86FA076.md): Cessna 340A · Dania, FL · Accident · 2 fatal · Field investigation · Final report · Feb 14, 1986 · N1923E · Destroyed
  > Shortly after takeoff on a check-out flight the aircraft was observed on crosswind leg to descend until impact. There was an extensive post impact fire. Witnesses heard the aircraft make a 'poof' type of noise just as the pilot radioed the control tower and…
- [NTSB MIA86IA075](https://openairdocs.org/ntsb/MIA86IA075.md): Piper PA-31-1020 · Panama City, FL · Incident · No injuries · Incident investigation · Final report · Feb 13, 1986 · N41703 · Minor damage
  > The plt stated that all attempts to extend the landing gear were to no avail & he elected to land with the nose gear not fully locked down. On landing rollout the nose gear completely collapsed. Post crash examination of the nose landing gear revealed that…
- [NTSB SEA86LA059](https://openairdocs.org/ntsb/SEA86LA059.md): Alon A2 · Woodburn, OR · Accident · No injuries · Limited investigation · Final report · Feb 12, 1986 · N5632F · Substantial damage
  > The pilot was attempting to depart the sod 1300 foot runway and due to poor soft field technique failed to clear a fence.
- [NTSB ATL86FLQ05](https://openairdocs.org/ntsb/ATL86FLQ05.md): Beech H-18 · Louisville, KY · Accident · Serious injuries · Final report · Feb 12, 1986 · N148PA · Substantial damage
  > The acft collided with the ground after stalling during takeoff. Witnesses reported that the acft pitched up in two increments, climbed sharply to about 200 ft AGL, stalled dropped the rt wing and descended, impacting the ground in a flat attitude.
- [NTSB LAX86LA109](https://openairdocs.org/ntsb/LAX86LA109.md): Cessna 172M · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Feb 9, 1986 · N1507V · Substantial damage
  > A Cessna 172 collided with a berm after an aborted takeoff. The pilot indicated after liftoff from the runway, the aircraft climbed to 100 feet AGL and began to sink. The pilot then elected to abort the takeoff. The aircraft landed on the departure end of the…
- [NTSB ATL86LA071](https://openairdocs.org/ntsb/ATL86LA071.md): Great Lakes 2T-1A-2 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Feb 9, 1986 · N3773F · Substantial damage
  > While on crosswind following takeoff the engine lost total power after climbing to 500 feet AGL. The pilot initiated a turn toward a field and collided with trees on the approach end of the field. Post-crash examination of the aircraft revealed that the…
- [NTSB ANC86LA024](https://openairdocs.org/ntsb/ANC86LA024.md): Piper PA-18 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Feb 7, 1986 · N4431Z · Substantial damage
  > The pilot lost control of the airplane while taxiing, inadvertently took off in gusty wind and crashed into adjacent trees.
- [NTSB DEN86FA075](https://openairdocs.org/ntsb/DEN86FA075.md): Piper PA-34-200 · Bismarck, ND · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1986 · N55654 · Destroyed
  > The acft was observed descending out of a low ceiling when it suddenly made an abrupt left turn. Engine noise seemed to increase momentarily and then the nose of the acft dropped to a near vertical position. The twin engine acft crashed into a vacant house…
- [NTSB MKC86IA058](https://openairdocs.org/ntsb/MKC86IA058.md): SAAB-Fairchild SF340 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Feb 5, 1986 · N342AM · No damage
  > On initial climbout fm lambert field, St. Louis, Missouri, the control tower at lambert rptd to the PIC of flt 1163 that one of the main landing gear wheels had fallen off the acft. The acft was returned and landed safely. Initial inspection revealed what…
- [NTSB SEA86IA058](https://openairdocs.org/ntsb/SEA86IA058.md): Cessna T210 · Roche Harbor, WA · Incident · No injuries · Incident investigation · Final report · Feb 4, 1986 · N5205A · No damage
  > On initial climb after takeoff, electrical fire broke out in back of pilot's yoke. Pilot managed to extinguish five- inch flames by hand, climbed to 2000 feet and evaluated situation. Noting no further problems, flight was continued to destination. Enroute,…
- [NTSB ATL86FKG06](https://openairdocs.org/ntsb/ATL86FKG06.md): Bushby Mustang II · Brownsboro, AL · Accident · 2 fatal · Final report · Feb 2, 1986 · N32RH · Destroyed
  > The acft collided with the ground in an inverted attitude during a forced landing after a power loss at 400 ft AGL during takeoff. The acft was observed to turn after the power loss and then the wings leveled. Power was heard to resume at about 100 ft AGL.…
- [NTSB LAX86LA105](https://openairdocs.org/ntsb/LAX86LA105.md): Burkhart Grob 103 · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Feb 1, 1986 · N102BK · Substantial damage
  > On February 1, 1986 at about 1045 PST a grob 103 glider, N103BK, ground looped in mud following an aborted takeoff at sky sailing airport, freemont California. The pilot elected to abort the takeoff because it appeared the tow aircraft was not climbing…
- [NTSB LAX86FVG01](https://openairdocs.org/ntsb/LAX86FVG01.md): Commings Vari EZE · Lower Lake, CA · Accident · No injuries · Final report · Feb 1, 1986 · N82RC · Substantial damage
  > The acft struck a tree during forced landing off the arpt after a reported power loss. Post-accident engine exam showed no reason for a power loss. Plt suspects carb ice.
- [NTSB ATL86LA068](https://openairdocs.org/ntsb/ATL86LA068.md): Cessna 172P · Alexander City, AL · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 1986 · N52238 · Substantial damage
  > The acft was observed to make one takeoff and landing from an umimproved pasture. The second takeoff attempted was unsuccessful and the acft collided with a tree and crashed to the ground. The plt did not report any mechanical problems with the acft. There…
- [NTSB ATL86LA067](https://openairdocs.org/ntsb/ATL86LA067.md): Cessna 152 · Lumberton, NC · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1986 · N25350 · Destroyed
  > The plt was on takeoff from rwy 05 when rwy 13 was being reported by the arpt operator over UNICOM as the active rwy. During climb out the plt spotted another acft lined up with rwy 13 (apparently to land). He entered a steep climb and started looking for the…
- [NTSB CHI86FA079](https://openairdocs.org/ntsb/CHI86FA079.md): Cessna 421C · Birmingham, MI · Accident · 2 fatal · Field investigation · Final report · Jan 29, 1986 · N68653 · Destroyed
  > At rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…
- [NTSB SEA86FA046](https://openairdocs.org/ntsb/SEA86FA046.md): Cessna 401 · S. Lake Tahoe, CA · Accident · 3 fatal · Field investigation · Final report · Jan 27, 1986 · N988JM · Destroyed
  > Acft took off in clear wx but below-freezing temps with heavy frost on acft surfaces. No preflight, run-up or warm-up performed. On initial climb, left eng power loss occurred for undet reason, but probably associated with temp/cold eng operation. Plt turned…
- [NTSB MIA86IA066](https://openairdocs.org/ntsb/MIA86IA066.md): Boeing 747-123 · Miami, FL · Incident · Minor injuries · Incident investigation · Final report · Jan 27, 1986 · N9674 · No damage
  > Shortly after departure the crew noted smoke in the cabin and the cockpit. The captain declared an emergency and landed back at the departure airport. He then directed an emergency evacuation. During the evacuation several emergency slides failed to deploy…
- [NTSB LAX86LA098](https://openairdocs.org/ntsb/LAX86LA098.md): Bell 222UT · La Habra, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1986 · N3177G · Substantial damage
  > On January 26, 1986 a Bell 222UT collided with a 3/8 inch support cable. The pilot saw the lower of two of the three support cables about 75 feet AGL as he was transitioning to forward flight from a vertical max performance t/o. the pilot applied aft cyclic…
- [NTSB LAX86FVD04](https://openairdocs.org/ntsb/LAX86FVD04.md): Vangrunsven RV-3A · Fortuna, CA · Accident · 1 fatal · Final report · Jan 25, 1986 · N661S · Destroyed
  > The acft stalled in a turn during a forced landing after the engine lost power. Post acc investigation revealed an inoperative fuel selector valve. Witnesses said that the acft did not sound like it was developing full pwr during take off roll. Shortly after…
- [NTSB CHI86FEI02](https://openairdocs.org/ntsb/CHI86FEI02.md): Cessna 150H · Strongsville, OH · Accident · Serious injuries · Final report · Jan 24, 1986 · N22755 · Substantial damage
  > During preflight, the student pilot noticed water in the fuel tank when he checked the fuel drain. He notified his instructor, but no further action was taken. Shortly after takeoff the engine quit. An emergency landing was performed in a parking lot and one…
- [NTSB ANC86LA022](https://openairdocs.org/ntsb/ANC86LA022.md): Cessna 180 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N3165D · Substantial damage
  > The pilot stated that during the initial climb out approximately 50 feet above the ground the engine quit. The aircraft crashed into a row of trees and the pilot was not injured. Examination of the aircraft engine revealed no malfunction or mechanical…
- [NTSB MKC86FA053](https://openairdocs.org/ntsb/MKC86FA053.md): Cessna 210H · Fremont, NE · Accident · 4 fatal · Field investigation · Final report · Jan 19, 1986 · N5961F · Destroyed
  > The plt of N5961F received a wx brf about 40 min before the acdt for a VFR flt from Fremont to cheyenne. The 3 reporting stations nearest to Fremont were IFR and local authorities who helped search for the acdt site reported low clouds and haze. There were no…
- [NTSB MIA86LA060](https://openairdocs.org/ntsb/MIA86LA060.md): Beech B24R · Fernandina Bch, FL · Accident · No injuries · Limited investigation · Final report · Jan 19, 1986 · N2520W · Substantial damage
  > The plt stated that just after he rotated, he experienced a loss of power, extended his landed gear & landed hard causing a collapse of the landing gear. Post crash examination of the eng revealed that the right magneto was improperly timed & the left magneto…
- [NTSB SEA86FA041](https://openairdocs.org/ntsb/SEA86FA041.md): Cessna 182 · Juneau, AK · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1986 · N9331G · Destroyed
  > Pilot requested clearance to return to airport after takeoff due to eng power loss. Clearance was given by ATC. Pilot made rt turn from about 100 ft alt. Acft crashed about 1500 foot south of rwy. No shoulder harnesses installed. Pax survived. Ice found on…
- [NTSB NYC86LA065](https://openairdocs.org/ntsb/NYC86LA065.md): Cessna 305-L-19 · Hilltown, PA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N5171G · Substantial damage
  > The Cessna was towing a glider when at an altitude of about 150 feet to about 200 feet, a decrease in RPM was experienced. The glider was detached from the aircraft, the nose was lowered and a left turn made while still over the gliderport. A rapid descent…
- [NTSB LAX86LA094](https://openairdocs.org/ntsb/LAX86LA094.md): Cessna 150L · Cottonwood, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1986 · N21995 · Substantial damage
  > The acft had not been flown for about 4 yrs. The plt intended to fly it to chandler, AZ, for an annual inspn. The pax stated the plt had previously made a test flt, but had a problem starting the eng. Rprtdly, the plt 'cleaned the fuel system and filled the…
- [NTSB LAX86LA093](https://openairdocs.org/ntsb/LAX86LA093.md): Rockwell 112TC · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Jan 17, 1986 · N1317J · Substantial damage
  > The acft experienced a loss of eng pwr at an alt of aprx 400 ft AGL during a takeoff climb. The plt made a forced landing in a muddy fld next to the rwy and the acft nosed over. The plt thought the single drive dual magneto had failed but could not be…
- [NTSB NYC86LA060](https://openairdocs.org/ntsb/NYC86LA060.md): Cessna 152 · Caldwell, NJ · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 1986 · N68214 · Substantial damage
  > The student and instructor (CFI) were performing touch-and-go landings. On the third touch-and-go, the student rotated the acft and initiated his climb. The CFI stated 'I realized the acft was not climbing and that the flaps were not retracted even though the…
- [NTSB MIA86FA059](https://openairdocs.org/ntsb/MIA86FA059.md): Cessna 150M · Summerfield, FL · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1986 · N714AY · Destroyed
  > The private pilot departed the sod airfield and was observed to perform a steep rotation and intital climb. The winds were off the aircrafts left tail and were observed to be gusty. The aircraft was then observed to lose control and enter a spin to the left.…
- [NTSB LAX86LA090](https://openairdocs.org/ntsb/LAX86LA090.md): Cessna 402B · Kalaupapa, HI · Accident · No injuries · Limited investigation · Final report · Jan 13, 1986 · N53SA · Substantial damage
  > The plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…
- [NTSB FTW86FQG05](https://openairdocs.org/ntsb/FTW86FQG05.md): Piper PA-24-260 · Big Spring, TX · Accident · No injuries · Final report · Jan 12, 1986 · N9183P · Substantial damage
  > The aircraft collided with barriers marking a displaced threshold during an emergency landing immediately after departure. The pilot reported that the engine began running rough, then quit completely. The engine ran successfully following the accident. The…
- [NTSB LAX86FA089](https://openairdocs.org/ntsb/LAX86FA089.md): Cessna 172N · Grand Canyon, AZ · Accident · 3 fatal · Field investigation · Final report · Jan 9, 1986 · N2113E · Destroyed
  > The acft deptd runway 03 at Grand Canyon airport, Grand Canyon, AZ on a moonless night. Shortly after departure the aircraft entered into a left turn. The aircraft collided into some trees in about a 45 deg nose down and about a 15 deg left wing down attitude…

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

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

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