# 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 186 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI85FET01](https://openairdocs.org/ntsb/CHI85FET01.md): Cessna 172 M · Valparaiso, IN · Accident · Minor injuries · Final report · May 3, 1985 · N23388 · Substantial damage > The plt departed the griffith arpt on a local flt & proceeded to two other arpts to practice landings. He flew to the starke county arpt & made 5 or 6 landings, then went to the porter county arpt. After the 5th touch-&-go, he prepared to takeoff by… - [NTSB DEN85LA124](https://openairdocs.org/ntsb/DEN85LA124.md): Cessna 150 · Glenwood Spring, CO · Accident · Serious injuries · Limited investigation · Final report · May 2, 1985 · N18009 · Destroyed > The acft crashed into a basketball court immediately after takeoff from Glenwood springs arpt. The plt made a touch and go landing and turned off the carburetor heat 100 ft above the ground during the takeoff climb. He said the engine began to run rough when… - [NTSB ATL85LA152](https://openairdocs.org/ntsb/ATL85LA152.md): Cessna 305A · No.Myrtle Bch, SC · Accident · No injuries · Limited investigation · Final report · May 1, 1985 · N5292G · Destroyed > After a banner pickup the plt was instructed by company group and crew to release the banner due to a fouled pickup. The banner was released during a steep climb out altitude. As the banner was released the plt lost directional control of the acft & crashed… - [NTSB SEA85FA100](https://openairdocs.org/ntsb/SEA85FA100.md): Piper PA-14 · Bliss, ID · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1985 · N5122H · Destroyed > The acft was observed by witnesses to climb out at a steep angle & slow airspeed after the 3rd touch & go before performing a wingover like maneuver & crashing in the x-wind turn. The pax reported the plt executing a steep left turn before the acft began a… - [NTSB NYC85FNC03](https://openairdocs.org/ntsb/NYC85FNC03.md): Bell 47H-1 · Guilford, VT · Accident · Serious injuries · Final report · Apr 28, 1985 · N2827B · Destroyed > The helicopter crashed after losing rotor RPM during a max performance takeoff from a confined area at a private landing area. The plt had added 10 gals of fuel and he was carrying a passenger. The plt said he ahd taken off from this area before with no… - [NTSB FTW85LA201](https://openairdocs.org/ntsb/FTW85LA201.md): Cessna 170B · Ama, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1985 · N170NX · Destroyed > The aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used… - [NTSB MIA85FA159](https://openairdocs.org/ntsb/MIA85FA159.md): Beech C35 · Tampa, FL · Accident · 4 fatal · Field investigation · Final report · Apr 27, 1985 · N1967D · Destroyed > Witnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred… - [NTSB LAX85FA228](https://openairdocs.org/ntsb/LAX85FA228.md): North American SNJ-6 · El Toro Mcas, CA · Accident · 2 fatal · Field investigation · Final report · Apr 27, 1985 · N2860G · Destroyed > The plt initiated a normal takeoff & climb until the acft was over the departure end of the rwy at about 150 ft AGL with the landing gear & flaps retracted. The acft then rolled rapidly into a steep left bank, turned about 180 deg & climbed to aprx 250 ft… - [NTSB CHI85LA180](https://openairdocs.org/ntsb/CHI85LA180.md): Mitchell Monnett Moni · Athens, MI · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N5625J · Substantial damage > The plt of the home-built/powered glider initiated a touch-&-go landing. However, he did not retract the spoilers when he began the takeoff portion of the touch-&-go. The acft lifted off into ground effect, but the left wing contacted a rwy light at the… - [NTSB ANC85LA075](https://openairdocs.org/ntsb/ANC85LA075.md): Bellanca 7GCBC · Holitna River, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1985 · N31282 · Substantial damage > During takeoff the plt noted a partial loss of power, the plt elected precautionary landing on the remaining frozen lake. During the turn the acft stalled and crashed. The fuel system was found contaminated with ice and water. - [NTSB ANC85LA074](https://openairdocs.org/ntsb/ANC85LA074.md): Cessna 172 · Nightmute, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1985 · N52174 · Substantial damage > The plt stated that shortly after takeoff, he lost control of the acft. Subsequently, the acft crashed & was substantially damaged. The plt reported that the wind was from 290 deg at 25 gusting 35 KTS. - [NTSB MKC85LA090](https://openairdocs.org/ntsb/MKC85LA090.md): Lester F.W. West VP-1 · Taylor, MO · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 1985 · N80LW · Destroyed > The pilot used only half of the available 2900 feet of runway on his first flight in this homebuilt airplane. He lost flying speed climbing over wires at the end of the runway, went around trees and landed hard on a highway median. - [NTSB DCA85AA020](https://openairdocs.org/ntsb/DCA85AA020.md): Aerospatiale SA360C Dauphin · New York, NY · Accident · 1 fatal · Final report · Apr 26, 1985 · N49505 · Substantial damage > At laguardia arpt, wnd was fm 320 deg at 16 gstg 22 KTS. PIC rprtd wnd at heliport (on west bank of east RVR) was fm sw. Obstacles were located along west edge of heliport. PIC rprtd he made pwr check, then bgn rolling takeoff with rgt qtrg hdwnd. As acft was… - [NTSB ATL85FA147](https://openairdocs.org/ntsb/ATL85FA147.md): Piper PA-38-112 · Monroe, NC · Accident · 1 fatal · Field investigation · Final report · Apr 26, 1985 · N2490A · Destroyed > The acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to… - [NTSB LAX85LA222](https://openairdocs.org/ntsb/LAX85LA222.md): Piper PA-28-140 · Felton, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1985 · N511FL · Substantial damage > During the preflight of the acft, the plt said he observed the wind conditions at the airport as from the north at about '5 to 10 KTS, which indicated a left crosswind. The airport is immediately surrounded by pine trees which average about 60 ft in height.… - [NTSB FTW85LA199](https://openairdocs.org/ntsb/FTW85LA199.md): Beech A-36 · Afton, OK · Accident · No injuries · Limited investigation · Final report · Apr 25, 1985 · N77HT · Substantial damage > The acft was ditched in 60 to 80 ft deep water following a loss of pwr shortly after takeoff. The plt was picked up by a bass boat shortly before the acft sank. The acft was recovered more than a month later and an examination of the eng was not performed. - [NTSB LAX85LA220](https://openairdocs.org/ntsb/LAX85LA220.md): Piper PA32-301T · Show Low, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1985 · N8275P · Destroyed > After giving the pilot airport advisories,via UNICOM, the refueler drove the refueling truck across the runway in front of the aircraft during its takeoff roll. The pilot unable to stop before impact, attempted to takeoff before reaching the tanker. The… - [NTSB CHI85LA175](https://openairdocs.org/ntsb/CHI85LA175.md): Piper J-3 · Richfield, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1985 · N87920 · Substantial damage > The plt made a short field takeoff using aprx 1700 ft of the 2200 ft airstrip. Unable to clear trees along the flt path, he turned to the right. However, the acft's wheel pants contacted a tree while the plane was still banked to the right & a slight amount… - [NTSB CHI85LA172](https://openairdocs.org/ntsb/CHI85LA172.md): Ercoupe 415-CD · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Apr 21, 1985 · N94740 · Substantial damage > Shortly after takeoff, while climbing thru aprx 700 ft AGL, the eng developed a severe vibration & a loud 'clanking' sound. These were followed by a partial loss of power. During a subsequent forced landing, the acft's right wing hit a tree & the nose gear… - [NTSB NYC85FGM03](https://openairdocs.org/ntsb/NYC85FGM03.md): Istvanick Zipppy Sport · Connellsville, PA · Accident · Minor injuries · Final report · Apr 20, 1985 · N39322 · Substantial damage > The acft contacted trees following a loss of pwr shortly after takeoff. Plt stated he performed 3 high speed taxi runs during which the acft and eng operated normally. Witnesses stated the acft became airborne on the 4th taxi run, climbed to aprx 75 ft AGL… - [NTSB DEN85LA119](https://openairdocs.org/ntsb/DEN85LA119.md): Cessna 172 · Opheim, MT · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N6495E · Substantial damage > The plt took off on a wet-soft airstrip which made the takeoff run longer than normal. The initial climb was at minimum airspeed when gusty winds caused the acft to stall. The acft impacted the ground and was substantially damaged. - [NTSB ATL85LA145](https://openairdocs.org/ntsb/ATL85LA145.md): Piper PA-32R-301 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N8047P · Substantial damage > The plt stated that during takeoff the right main gear struck a large dog which ran onto the rwy. The takeoff was continued & the plt circled the arpt for 2 hrs to burn off excess fuel before performing a ldg with the nose gear & the left main ldg gear… - [NTSB ANC85LA066](https://openairdocs.org/ntsb/ANC85LA066.md): Cessna U206G · Kodiak, AK · Accident · Serious injuries · Limited investigation · Final report · Apr 20, 1985 · N5442Z · Destroyed > Acft made low alt steep 180 deg turn, stalled & spun into water. Acft had just taken off & was to spot flsh for three fishing vessels. - [NTSB MKC85FA086](https://openairdocs.org/ntsb/MKC85FA086.md): Beech B95 · Mena, AR · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1985 · N95UP · Destroyed > N95UP was making the first flt after both engines were overhauled. The owner of the overhaul facility was the pilot and the passenger was the foreman who was responsible for installing engines. A witness who is employed on the airport heardthe acft takeoff… - [NTSB FTW85LA191](https://openairdocs.org/ntsb/FTW85LA191.md): Wisconsin State Prison Sonerai II · Castroville, TX · Accident · No injuries · Limited investigation · Final report · Apr 19, 1985 · N541DM · Destroyed > According to the plt, after lift-off from the 5,000 ft long rwy, the acft was in ground effect prior to an uncontrolled right roll. The acft impacted the ground right wing first. The plt reported 2 hrs experience in the acft and no mechanical malfunctions. - [NTSB ATL85LA142](https://openairdocs.org/ntsb/ATL85LA142.md): Cessna 150 · Alma, GA · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1985 · N4483U · Substantial damage > The student pilot and passenger changed the engine oil just prior to attempting the takeoff. The oil was drained on the ground on the airport where the aircraft was parked. Examination of the oil, disclosed that metal shavings were present in the drained oil.… - [NTSB ATL85LA141](https://openairdocs.org/ntsb/ATL85LA141.md): Cessna 120 · Saluda, SC · Accident · No injuries · Limited investigation · Final report · Apr 19, 1985 · N1819V · Substantial damage > The plt attempted a takeoff with the carb heat in the 'on' position. According to the plt, during initial climb the acft lost power and he was unable to maintain altitude. The plt made a forced landing in a pasture about 1 mi. From the airport. - [NTSB ATL85LA138](https://openairdocs.org/ntsb/ATL85LA138.md): Cessna 152 · Jacksonville, AL · Accident · No injuries · Limited investigation · Final report · Apr 19, 1985 · N5330B · Substantial damage > Pilot experienced power failure during climbout. A forced landing was made in a plowed fld and the acft nosed over. Examination of the wreckage revealed that the carburetor airbox seal had deteriorated and lodged in the throat of the carburetor. Last annual… - [NTSB MKC85FCQ02](https://openairdocs.org/ntsb/MKC85FCQ02.md): Beech 35-B33 · Lakin, KS · Accident · Serious injuries · Final report · Apr 17, 1985 · N5654K · Substantial damage > The acft attained aprx 200 ft of alt after takeoff before the eng was heard changing sound before the popping & backfiring began, according to witnesses. After all eng sounds ceased the acft descended rapidly to a grassy area of the arpt & landed with the… - [NTSB NYC85LA106](https://openairdocs.org/ntsb/NYC85LA106.md): Cessna 150M · Blue Hill, ME · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1985 · N9445U · Destroyed > The plt reported that shortly after takeoff at an alt of aprx 150 ft AGL, the left wing stalled. The acft then entered a spin and contacted the terrain in an approximate 45 deg nose down attitude. - [NTSB MIA85LA148](https://openairdocs.org/ntsb/MIA85LA148.md): Piper PA-38-112 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1985 · N2428D · Substantial damage > During a student trng flt the instructor pilot stated that he reduced throttle on takeoff at about 75 ft AGL, to simulate an engine failure. The student pilot pitched the nose of the acft up and the instructor pilot took over control of the acft, lowered the… - [NTSB SEA85LA092](https://openairdocs.org/ntsb/SEA85LA092.md): Grumman AA-1B · Hampton, OR · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N9861L · Substantial damage > The student plt made a precautionary landing due to being lost and low on fuel. The airstrips surface was 1000 ft of dirt and sand with a fence at the departure end. Takeoff data based on gross weight, zero wind, 4000 ft elevation at 80 degrees, on a hard… - [NTSB MKC85LA083](https://openairdocs.org/ntsb/MKC85LA083.md): Piper PA-38-112 · Mechanicsville, IA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N2392N · Substantial damage > The plt attempted a takeoff from a short, wet, soft, alfalfa field in an acft loaded with two occurants and aprx a full load of fuel. The acft collided with a fence and a tree after using the available distance in the flt attempt. Plt recommended a more… - [NTSB LAX85LA201](https://openairdocs.org/ntsb/LAX85LA201.md): Sederberg Bensen B-8M · Lower Lake, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 1985 · N4544L · Substantial damage > Following a normal takeoff with the fuel tank one-half full, the acft climbed to 1000 ft AGL at which time engine pwr was gradually lost. A grnd witness reported hearing the eng sputter or miss. The plt attempted to return to the arpt but had insufficient… - [NTSB BFO85LA039](https://openairdocs.org/ntsb/BFO85LA039.md): Rotec Rally 3 · Alta Vista, VA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N316SR · Substantial damage > Each time the pilot applied nose up pitch control after take off, the acft settled but would maintain straight and level flight when the controls were neutralized. Due to the settling effect, obstruction clearance could not be attainedand the acft settled… - [NTSB BFO85LA034](https://openairdocs.org/ntsb/BFO85LA034.md): Cirrus Standard Cirrus · Woodbine, MD · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1985 · N494BZ · Substantial damage > During takeoff, the glider was observed to climb at an unusually steep attitude. Then at about 75 ft AGL (aprx 50 above the tow plane), the glider released from the tow rope. According to one witness, the acft maintained a nose high attitude, then pitched… - [NTSB ATL85LA136](https://openairdocs.org/ntsb/ATL85LA136.md): Cessna 150E · Seale, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1985 · N3080J · Substantial damage > While performing a soft fld takeoff the plt reportedly applied full pwr with the control yoke pulled full aft. The acft became airborne at aprx 35 KTS with the stall warning horn sounding. The acft drifted left of the centerline and the plt over corrected… - [NTSB FTW85LA177](https://openairdocs.org/ntsb/FTW85LA177.md): Fairchild Hiller FH-1100 · Rosston, OK · Accident · No injuries · Limited investigation · Final report · Apr 10, 1985 · N5073F · Destroyed > Pilot stated engine lost power during takeoff climb due to a leak in the air line from the engine bleed valve. He attempted to make a forced landing but upon touchdown, due to his forward movement, the aircraft nosed over. - [NTSB DEN85LA114](https://openairdocs.org/ntsb/DEN85LA114.md): Cessna 172 · Grant, NM · Accident · No injuries · Limited investigation · Final report · Apr 10, 1985 · N738LR · Substantial damage > The acft crashed during takeoff from a dirt strip near Grant, NM, while on a pleasure flt. VMC conditions prevailed and no flt plan was filed. The plt & his 3 occupants were not injured. The plt reported that a dust devil caught the acft at an alt of 35-50 ft… - [NTSB MKC85LA082](https://openairdocs.org/ntsb/MKC85LA082.md): Cessna 152 · Herington, KS · Accident · No injuries · Limited investigation · Final report · Apr 8, 1985 · N757QK · Substantial damage > Acft tookoff from a 1900 ft long, sod, farm strip. Plt said acft became airborne at mid-field but felt mushy and would not climb. Acft collided with fence and bush at end of strip and sustained substantial damage. Acft remained airborne and continued to… - [NTSB NYC85LA101](https://openairdocs.org/ntsb/NYC85LA101.md): Beech B-35 · East Haddam, CT · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N3082V · Substantial damage > The acft stalled and contacted sandy terrain aprx 50 ft from the rwy threshold. The plt reported the cabin door opened during takeoff and he circled the traffic pattern to land and close the door. He stated an airspeed of 100 KTS was observed on a 1 mile… - [NTSB FTW85FRA01](https://openairdocs.org/ntsb/FTW85FRA01.md): Johnson-Rand KR-2 · Laporte, TX · Accident · 1 fatal · Final report · Apr 5, 1985 · N17VE · Destroyed > Witnesses reported that shortly after takeoff at an alt of aprx 30 ft AGL, the acft rolled inverted and descended to ground impact. Post accident examination of the acft failed to disclose any mechanical failure/malfunction which would have resulted in the… - [NTSB CHI85FEE01](https://openairdocs.org/ntsb/CHI85FEE01.md): Piper PA-28-161 · Schaumburg, IL · Accident · Minor injuries · Final report · Apr 5, 1985 · N8243S · Destroyed > The student plt & instructor (CFI) were practicing touch-&-go landings. The CFI reported that after about 1 hr of flt, the eng lost power after a touch-&-go as the acft was climbing thru about 200 to 300 ft AGL. A town & some bldgs were ahead, so the CFI made… - [NTSB NYC85FA098](https://openairdocs.org/ntsb/NYC85FA098.md): Cessna 310H · Ronkonkoma, NY · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1985 · N1022Q · Destroyed > The aircraft deeparted runway 33L and climbed to about 500 feet AGL with the landing gear down. Near the departure end of runway 33L the aircraft banked right and spiraled to the ground and crashed. - [NTSB CHI85LA152](https://openairdocs.org/ntsb/CHI85LA152.md): Piper PA-22-150 · Rush City, MN · Accident · No injuries · Limited investigation · Final report · Apr 3, 1985 · N5995D · Substantial damage > The plt reported that he was taking off on rwy 33 with the wind from 280 deg a 18 gusting 25 KTS. After becoming airborne, the acft weathervaned into the wind. It then traveled to the left of the rwy where it settled back to the ground. Subsequently, the acft… - [NTSB CHI85LA151](https://openairdocs.org/ntsb/CHI85LA151.md): de Havilland DHC-6-200 · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Apr 3, 1985 · N3434 · Substantial damage > The 14 CFR 135 pilot with light load of cargo was taking offof 10000 x 150 ft runway pilot said rt engine lost power he reduced power to ld was 50 ft AGL and bounced on second touchdown acft dept runway at 45 angle nose gear broke off in sod wind was 30 off… - [NTSB NYC85FA092](https://openairdocs.org/ntsb/NYC85FA092.md): Sikorsky S-55B · Port Elizabeth, NJ · Accident · Minor injuries · Field investigation · Final report · Apr 1, 1985 · N90885 · Substantial damage > The helicopter landed hard after a decrease in RPM during initial climb. The acft was being used for a sling operation. Investigation revealed a failed clutch assembly, S1435-2500-1. The clutch had operated only 200 hrs since a major overhaul. - [NTSB ATL85LA125](https://openairdocs.org/ntsb/ATL85LA125.md): Piper J-3C-65 · Blairsville, GA · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N98760 · Substantial damage > The private pilot and his student plt passenger were departing the a/p when the plt made a sharp turn downwind at about 100 ft of alt. The a/c mashed into the ground bounced and landed in small trees. The nearest reported winds were recorded at 19 KTS. The… - [NTSB LAX85LA190](https://openairdocs.org/ntsb/LAX85LA190.md): Piper PA-30 · Death Valley, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1985 · N802Y · Substantial damage > During a flt from reno, NV to phoenix, AZ, there was a partial power loss in the left eng as the acft was climbing thru 15,000 ft with an outside air temp of -15 deg. The fuel selectors could not be moved, so the plt retarded the right eng power & descended.… - [NTSB FTW85IA168](https://openairdocs.org/ntsb/FTW85IA168.md): Boeing 727-200B · Mexico City, Mexico · Incident · No injuries · Incident investigation · Final report · Mar 29, 1985 · N701AA · Minor damage > During the initial climb after takeoff a 27 foot tall light pole was struck by the right main landing gear 1,677 feet from the end of the rwy. Acft gross weight dictated a 5 deg flap takeoff and company performance data authorized departure on either rwy 5R… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=187 ## 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=186 --- 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.