# 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 178 of 412 · 20,559 cases ## Cases, newest first - [NTSB NYC86LA119](https://openairdocs.org/ntsb/NYC86LA119.md): Piper PA-28-181 · Madison, CT · Accident · No injuries · Limited investigation · Final report · May 6, 1986 · N2841M · Substantial damage > The acft experienced an engine failure during takeoff and the plt made a forced landing in a river. Post accident inspection did not determine cause of the power loss. It should be noted that the acft was under water for several hours prior to examination. - [NTSB LAX86DVA07](https://openairdocs.org/ntsb/LAX86DVA07.md): Wright BD5B · Merced, CA · Accident · 1 fatal · Final report · May 4, 1986 · N357X · Destroyed > Ground witnesses and the pilot reported the canopy opened shortly after departing runway 30 at Merced airport, Merced, CA. The pilot executed a steep left banking turn. When the airplane turned abt 140 deg it pitched up, rolled inverted and nosed down into… - [NTSB LAX86LA205](https://openairdocs.org/ntsb/LAX86LA205.md): Cessna 172M · Oakland, CA · Accident · Minor injuries · Limited investigation · Final report · May 3, 1986 · N9656V · Substantial damage > Before takeoff, the plt tuned in the hayward ATIS & received information alpha, which rprtd the wx was: 2200' scattered,3000' overcast & visibility 8 mi. After taking off from rwy 28R, the plt climbed to about 650' & made a rgt turn. At about that time, the… - [NTSB DEN86LA124](https://openairdocs.org/ntsb/DEN86LA124.md): Piper J-3 · Britton, SD · Accident · Minor injuries · Limited investigation · Final report · May 2, 1986 · N92283 · Substantial damage > The acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of… - [NTSB CHI86FEX08](https://openairdocs.org/ntsb/CHI86FEX08.md): Conner KR-2 · Hagerstown, IN · Accident · Minor injuries · Final report · May 2, 1986 · N4702Y · Substantial damage > Drg takeoff, the eng sputtered & quit at about 350' AGL. The plt rprtd that he turned on the electrical fuel pump, but did not get the eng started. Subsequently, the acft hit a tree & crashed inverted on the ground. An investigation revealed the push rod for… - [NTSB FTW86FA075](https://openairdocs.org/ntsb/FTW86FA075.md): Rockwell 112A · El Paso, TX · Accident · Serious injuries · Field investigation · Final report · May 1, 1986 · N1356J · Substantial damage > The plt rprtd that the eng quit immediately after takeoff. During an emerg landing on arpt property, the acft collided with a sand dune & nosed over. An exam of the eng revealed no discrepancies. The extent of damage prevented a thorough exam of the fuel sys.… - [NTSB CHI86LA135](https://openairdocs.org/ntsb/CHI86LA135.md): Cessna 182P · Indianapolis, IN · Accident · Serious injuries · Limited investigation · Final report · May 1, 1986 · N21139 · Substantial damage > The acft had sat idle for four days in heavy rains prior to this flt. A loss of power was experienced during takeoff. The plt attempted a 180 deg turn back to the arpt during which the acft stalled and descended to ground impact. Aprx 2.5 ounces of water were… - [NTSB NYC86LA113](https://openairdocs.org/ntsb/NYC86LA113.md): Enstrom F-28C · Ridgefield Park, NJ · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N60PB · Substantial damage > A weight imbalance, then a split needle, caused the plt to abort 2 previous attempts to depart. Conditions were corrected & the helicopter departed the waterfront helipad. As it went over the water, the plt noted a loss of eng power. He tried to return to the… - [NTSB MIA86LA137](https://openairdocs.org/ntsb/MIA86LA137.md): Rockwell 100 · Ft.Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1986 · N3789X · Substantial damage > The acft was stolen by a 17 year old non-pilot rated male. While taxiing on a taxiway the acft was reported to be fish tailing before it ran off the taxiway and became airborne. When the acft touched down it bounced aprx 10 ft into the air and performed a… - [NTSB CHI86LA132](https://openairdocs.org/ntsb/CHI86LA132.md): Piper PA-22 · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Apr 27, 1986 · N3321A · Substantial damage > After takeoff and while climbing through 60 ft AGL the plt could not move the aileron to recover from a 15 deg left bank. The plt reduced power and landed the acft in a left wing low attitude. The acft slid and struck a creek bank with the right wing. Post… - [NTSB CHI86FEV01](https://openairdocs.org/ntsb/CHI86FEV01.md): Cessna 177 · Canton, IL · Accident · Minor injuries · Final report · Apr 26, 1986 · N2285Y · Substantial damage > The acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.… - [NTSB MIA86LA129](https://openairdocs.org/ntsb/MIA86LA129.md): Piper PA-28RT-201 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Apr 22, 1986 · N528FT · Substantial damage > The plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng… - [NTSB NYC86FFJ01](https://openairdocs.org/ntsb/NYC86FFJ01.md): Piper J3C-65 · Bethany, NY · Accident · No injuries · Final report · Apr 20, 1986 · N88379 · Substantial damage > The acft crashed on the arpt after a turn of aprx 120 degrees to avoid 60 ft trees at the departure edge of the arpt. The plt had used the grass beside the airstrip because of standing water at places on the rwy. The takeoff run was started about 500 ft from… - [NTSB MIA86LA125](https://openairdocs.org/ntsb/MIA86LA125.md): Beech B95A · St. Augustine, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1986 · N951Q · Substantial damage > The pilot in command did not assure that the fuel selector for the left engine was selected and in the detent prior to takeoff. On the initial climb the fuel selector moved slightly and the left engine failed due to fuel starvation. The pilot then did not… - [NTSB CHI86LA126](https://openairdocs.org/ntsb/CHI86LA126.md): Cessna 140 · Remington, IN · Accident · No injuries · Limited investigation · Final report · Apr 19, 1986 · N76460 · Substantial damage > The aircraft's engine quit at about 200 feet AGL during takeoff climb. The pilot executed a forced landing into a plowed field and the aircraft nosed over. The pilot stated that he believed the fuel selector was in the incorrect position. Examination revealed… - [NTSB NYC86LA107](https://openairdocs.org/ntsb/NYC86LA107.md): Enstrom F-280C · Ridgefield, NJ · Accident · No injuries · Limited investigation · Final report · Apr 18, 1986 · N51721 · Substantial damage > Seconds after an over-water takeoff from a shoreline helipad the acft impacted the water and sank. The pilot and pax escaped from the submerged acft and were not injured. The pilot claimed that he had a split needle in which the rotor RPM deteriorated. The… - [NTSB LAX86LA126](https://openairdocs.org/ntsb/LAX86LA126.md): Piper PA28-180 · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1986 · N3764R · Substantial damage > The eng cowling opened as the acft took off. The plt slowed the acft to lower the open cowl. The acft descended into unmarked elec wires and received substantial damage. The pilot returned to arpt and landed without further incident. - [NTSB MIA86LA123](https://openairdocs.org/ntsb/MIA86LA123.md): Piper PA-25-235 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1986 · N9592P · Substantial damage > Purpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on… - [NTSB NYC86LA102](https://openairdocs.org/ntsb/NYC86LA102.md): Cessna 150J · Newton, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 1986 · N44DN · Substantial damage > The eng lost power during takeoff at an altitude of aprx 100 ft. subsequently, the acft settled into trees near the departure end of the rwy & was damaged. A post-acdnt exam of the acft revealed the fuel tanks were empty. - [NTSB MKC86FA088](https://openairdocs.org/ntsb/MKC86FA088.md): Piper PA-31 · Norfolk, NE · Accident · 5 fatal · Field investigation · Final report · Apr 14, 1986 · N6700L · Destroyed > The airplane departed on runway 31 with a low ceiling and visibility variable from 1/4 mile to 1/16 mile and winds from 290 degrees at 38 knots, gusting to 47 knots. A witness stated that the airplane was airborne no more than two minutes after the engines… - [NTSB MIA86LA138](https://openairdocs.org/ntsb/MIA86LA138.md): Bell UH-1B · North Port, FL · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N4242T · Substantial damage > The flt experienced an eng failure at an alt of aprx 8 ft AGL shortly after takeoff and the helicopter sustained substantial damage when a hard landing was made. Post accident inspection of the eng revealed the pwr turbine wheel experienced a loss of two… - [NTSB ANC86LA045](https://openairdocs.org/ntsb/ANC86LA045.md): Cessna 180-H · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Apr 14, 1986 · N700HJ · Destroyed > The pilot stated that after lift off from the water, the left wing tip caught the water causing the aircraft to cartwheel and sink. At the time of the accident the wind was reported as 060 degrees at 15 knots gusting 35 knots. - [NTSB LAX86LA182](https://openairdocs.org/ntsb/LAX86LA182.md): Piper PA-38-112 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N24274 · Substantial damage > The acft stalled and collided with the ground shortly after departing rwy 31 at Salinas municipal airport. Neither the certified flight instructor nor the dual student was injured. The instructor reported that she was giving the student plt 'touch and go'… - [NTSB ATL86LA110](https://openairdocs.org/ntsb/ATL86LA110.md): Aeronca L-3B · Harrison, OH · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1986 · N47187 · Substantial damage > During a demonstration flight to a resident who lived near the airport, the acft crashed in a plowed field in a departure stall. The flight was intended to demonstrate the safe maneuverability of the acft and deception of altitude clearances from the… - [NTSB MIA86FA119](https://openairdocs.org/ntsb/MIA86FA119.md): Beagle B206-2 · Pedro, FL · Accident · 2 fatal · Field investigation · Final report · Apr 11, 1986 · N112CS · Destroyed > Immediately after take-off, the left eng seized & the prop stopped due to a connecting rod failure. Witnesses reported that about 200 ft above the ground, the acft rolled to the left and collided with a powerline before crashing to the ground in a near… - [NTSB MKC86LA084](https://openairdocs.org/ntsb/MKC86LA084.md): Piper PA-32R-301T · Perry, IA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N8178N · Substantial damage > Shortly after takeoff the PIC noticed a loss of engine pwr and flames erupting from the engine cowling. The PIC executed a turn back to the arpt as thick black smoke filled the cockpit. The PIC opened the side vent window to maintain sight of the ground and… - [NTSB BFO86FA021](https://openairdocs.org/ntsb/BFO86FA021.md): Piper PA-28-140 · Chesapeake, VA · Accident · 3 fatal · Field investigation · Final report · Apr 7, 1986 · N9636W · Destroyed > Before the flt, the plt was observed drinking in a bar. He & 3 others then drove to the arpt, where rprtdly, the wx was bad & the visibility was restricted by fog. After awhile, the plt stated he was going to taxi the acft around the arpt & invited the others… - [NTSB ANC86LA043](https://openairdocs.org/ntsb/ANC86LA043.md): Bellanca 7ECA · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Apr 6, 1986 · N1042E · Substantial damage > The pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing. - [NTSB SEA86FA092](https://openairdocs.org/ntsb/SEA86FA092.md): Cessna 172P · Seattle, WA · Accident · 4 fatal · Field investigation · Final report · Apr 5, 1986 · N99034 · 2 aircraft · Destroyed > N99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb… - [NTSB LAX86DVA05](https://openairdocs.org/ntsb/LAX86DVA05.md): Grumman G164A · Snelling, CA · Accident · No injuries · Final report · Apr 5, 1986 · N8932H · Destroyed > The plt stated he had just lifted off during takeoff when the eng quit. The acft then stalled, hitting a canal and shearing off the main landing gear. The plt stated that a broken fuel line is suspect due to the sudden stoppage and intense ground fire. The… - [NTSB MKC86FPG02](https://openairdocs.org/ntsb/MKC86FPG02.md): Cessna 150H · Lonoke, AR · Accident · Serious injuries · Final report · Apr 1, 1986 · N22109 · Substantial damage > After the plt changed a tire & performed maintenance on the carb heat control, he elected to reposition the acft to adams field at little rock, AR. Shortly after lifting off from his private strip, the acft crashed. There was virtually no movement after it… - [NTSB LAX86LA157](https://openairdocs.org/ntsb/LAX86LA157.md): Cessna 310D · Yermo, CA · Accident · No injuries · Limited investigation · Final report · Mar 31, 1986 · N6762T · Substantial damage > The acft collided with rough terrain after an eng failure on takeoff from a private dirt airstrip. The plt indicated that the left eng failed just after liftoff. The acft yawed uncontrolled to the left and drifted off the 30 ft wide strip. The plt aborted the… - [NTSB CHI86LA106](https://openairdocs.org/ntsb/CHI86LA106.md): Piper PA-28-140 · Veedersburg, IN · Accident · No injuries · Limited investigation · Final report · Mar 31, 1986 · N9910W · Substantial damage > The pilot was attempting a short field takeoff from a 1080 foot wheat field that he had mistaken for a private airstrip 1 1/2 miles to the northeast. The pilot said the engine had a slight RPM loss and then developed full power but he was unable to clear the… - [NTSB ATL86LA103](https://openairdocs.org/ntsb/ATL86LA103.md): Piper PA-28RT-201T · Fort Rucker, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 31, 1986 · N8140Y · Substantial damage > The x-c flt departed killeen, TX, with an intermediate stop at alexandria, LA. A passenger was disembarked at cairns aaf and during departure for dothan, the aircraft's engine sputtered and lost power. The aircraft collided with trees near the airport. Prior… - [NTSB ATL86FEI04](https://openairdocs.org/ntsb/ATL86FEI04.md): Piper PA-38-112 · Wauseon, OH · Accident · No injuries · Final report · Mar 31, 1986 · N2572C · Substantial damage > The acft landed & nosed over about 770 ft upwind of the rwy it had used for takeoff. The CFI thought that the sod strip was too soft for the student to make the takeoff so he took the controls. The acft was unable to gain proper airspeed or alt and landed in… - [NTSB NYC86LA097](https://openairdocs.org/ntsb/NYC86LA097.md): Mooney M20 · Lockport, NY · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N6433Q · Substantial damage > The cross country flight was departing runway 28 at Lockport, new york in strong quartering wind conditions. At rotation and climb out, the pilot retracted the gears and flps. However as the aircraft flps retracted the aircraft began to drop. The nose was… - [NTSB MKC86LA081](https://openairdocs.org/ntsb/MKC86LA081.md): Piper PA-22-150 · Lytton, IA · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 1986 · N6167D · Substantial damage > The acft was departing from a 2,500 ft long, grass, farm strip. The plt said he noticed after take off that the eng was not developing full power and he could not maintain alt. He attempted to land in an adjacent fld, but the ground was soft and the acft… - [NTSB FTW86FA050](https://openairdocs.org/ntsb/FTW86FA050.md): Lockheed L-402-2 (LASA-60) · Seagoville, TX · Accident · 3 fatal · Field investigation · Final report · Mar 29, 1986 · N3381G · Destroyed > Acft crashed immediately after takeoff on a flt to discharge jumpers over a drop zone located on the arpt. Witnesses stated that shortly after liftoff the acft entered a steep left bank estimated between 45 and 70 degs. After about 120 degs of turn the acft… - [NTSB CHI86FEP01](https://openairdocs.org/ntsb/CHI86FEP01.md): Cessna 177 · Portage, WI · Accident · 2 fatal · Final report · Mar 29, 1986 · N29849 · Destroyed > Several witnesses stated that upon climbout following a low pass, smoke came out of the engine and the engine sputtered. The aircraft was then seen in a steep turn. During this turn the wings reached a vertical position and the aircraft descended to the… - [NTSB LAX86LA155](https://openairdocs.org/ntsb/LAX86LA155.md): Bell 206B · Huntington Bch, CA · Accident · No injuries · Limited investigation · Final report · Mar 23, 1986 · N49643 · Substantial damage > A Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the… - [NTSB LAX86FVM04](https://openairdocs.org/ntsb/LAX86FVM04.md): Quickie II · Watsonville, CA · Accident · Minor injuries · Final report · Mar 23, 1986 · N3921V · Substantial damage > The acft landed in a wet field off the departure end of the takeoff rwy after the engine lost power during takeoff. The acft nosed over during the landing. The owner reported that the carb heat was on at the scene of the accident. The plt does not remember… - [NTSB CHI86LA107](https://openairdocs.org/ntsb/CHI86LA107.md): Navion H · Columbus, IN · Accident · No injuries · Limited investigation · Final report · Mar 23, 1986 · N25342 · Substantial damage > The pilot was practicing a short field takeoff when at 30 to 40 feet the engine lost power and quit, the aircraft subsequently landed hard damaging the right landing gear box and fuselage behind the right wing. The pilot said he may have taken off on the tip… - [NTSB MIA86FA101](https://openairdocs.org/ntsb/MIA86FA101.md): Durkota Thorp T-18 · Lakeland, FL · Accident · 2 fatal · Field investigation · Final report · Mar 19, 1986 · N83GD · Substantial damage > Witnesses observed black smoke trailing from the homebuilt acft during takeoff & initial climb. The acft was observed to climb to an estimated alt of 150 to 200 ft where eng sound ceased & the prop stopped. The acft was then observed to attempt a left turn… - [NTSB LAX86LA147](https://openairdocs.org/ntsb/LAX86LA147.md): Mooney M20F · Burbank, CA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1986 · N9591M · Substantial damage > The acft was landed nose low after flying the pattern with a flt control problem. The plt said he noticed the lack of elevator control during initial climb and came back in for a precautionary landing. The elevator was found to be inoperative due to a broken… - [NTSB LAX86LA144](https://openairdocs.org/ntsb/LAX86LA144.md): Centrair Schleicher ASW-20 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Mar 18, 1986 · N49946 · Substantial damage > The plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5… - [NTSB CHI86LA105](https://openairdocs.org/ntsb/CHI86LA105.md): Cessna 150J · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Mar 18, 1986 · N50851 · Substantial damage > The student pilot flew a four leg round-robin with touch and go landing after each leg. After his return to his point of origin and following his second touch and go there, the engine quit at 100 ft AGL, halfway down the runway. He bounced into the grass at… - [NTSB LAX86LA143](https://openairdocs.org/ntsb/LAX86LA143.md): Aerospatiale AS-350D · Tahoe Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 1986 · N88GT · Destroyed > The helicopter collided with trees and crashed in rough mountainous terrain during takeoff. The acft was shuttling skiers from a landing area located at approximately 8,300 ft mls to a ridgeline at 11,000 ft MSL. The plt reported the EGT (T-4) was at 790 deg… - [NTSB SEA86LA078](https://openairdocs.org/ntsb/SEA86LA078.md): Maule M-4-180C · Orchards, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1986 · N2037U · Destroyed > The pilot inadvertently placed the fuel selector to a non-tank position. During initial climb at about 400 m.s.l. a total loss of power occurred. During forced landing the aircraft struck telephone lines, a patio roof, and a parked unoccupied pickup truck. - [NTSB CHI86LA104](https://openairdocs.org/ntsb/CHI86LA104.md): Cessna 175 · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Mar 16, 1986 · N7191M · Substantial damage > The newly purchased acft was being flown off of the seller's turf strip. After taking off, the acft struck 50 ft trees off of the end of the runway. The seller, who watched the takeoff, stated that the pilot overrotated the acft after lift-off. - [NTSB ANC86FA035](https://openairdocs.org/ntsb/ANC86FA035.md): Cessna A185E · Anchorage, AK · Accident · Serious injuries · Field investigation · Final report · Mar 16, 1986 · N70010 · Substantial damage > Acft hit trees and power lines and crashed on city residential street following engine failure during takeoff climb. Engine driven fuel pump failed due to long term exposure to water in fuel. Over two quarts water was collected from aircraft tanks after… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=179 ## 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=178 --- 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.