# 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 189 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI85FA054](https://openairdocs.org/ntsb/CHI85FA054.md): Cessna 172P · Waukegan, IL · Accident · No injuries · Field investigation · Final report · Nov 23, 1984 · N53134 · Substantial damage > The acft collided with the terrain during a forced landing following a loss of power during takeoff. Investigation revealed that two days previously a loss of power had occured during a test flt which was virtually identical to the power loss experienced… - [NTSB FTW85LA053](https://openairdocs.org/ntsb/FTW85LA053.md): Cessna 182H · Basile, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1984 · N1857X · Substantial damage > The acft experienced a nose gear collapse during a forced landing following a loss of power shortly after takeoff. Plt stated the power loss occurred at an alt of 400 ft AGL. The forced landing was made in a soft plowed field. Post accident exam of the acft… - [NTSB CHI85LA056](https://openairdocs.org/ntsb/CHI85LA056.md): Piper PA-32RT-300T · Chambers Island, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1984 · N21596 · Destroyed > The plt reported that during takeoff upon reaching an alt of 8-10 ft AGL a down draft was encountered and the acft contacted the rwy on the rt landing gear which was in the transient position. He reported he was able to remain airborne but the rate of climb… - [NTSB ATL85LA038](https://openairdocs.org/ntsb/ATL85LA038.md): Piper PA-28-180 · Luray Caverns, VA · Accident · No injuries · Limited investigation · Final report · Nov 17, 1984 · N9360J · Substantial damage > The acft was landed on a inadequate field during a simulated forced landing that became a real emergency because the fltinstructor cut the mixture to off. The CFI took over the landing at the last part of the approach and told the student to restart the… - [NTSB FTW85LA051](https://openairdocs.org/ntsb/FTW85LA051.md): Mooney 231 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Nov 14, 1984 · N231JN · Substantial damage > According to the plt, at about 15 ft AGL, simultaneous with gear retraction, the cabin door popped open and the nose of the airplane 'tucked.' The plt attempted to control the nose attitude but as the propeller began striking the runway surface, power was… - [NTSB DEN85LA024](https://openairdocs.org/ntsb/DEN85LA024.md): Cessna 185C · Williston, ND · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N5831T · Substantial damage > The acft collided with a bridge during an aborted takeoff after failing to get airborne. The plt aborted the takeoff butthe acft failed to stop in time to avoid a collision with a railroad bridge abutment made of concrete. The plt stated that the acft had… - [NTSB MKC85LA018](https://openairdocs.org/ntsb/MKC85LA018.md): Piper PA-18-150 · Algona, IA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1984 · N4312Z · Substantial damage > At about 100 ft AGL after takeoff, eng lost pwr. Plt attempted to circle to land on closest runway but eng was developing insufficient pwr to maintain altitude in turn. Acft touched down 150 ft short of threshold. Plt did not level wings prior to touchdown.… - [NTSB MIA85LA025](https://openairdocs.org/ntsb/MIA85LA025.md): Cessna 310C · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Nov 6, 1984 · N1703H · Destroyed > The acft started its ground run and upon encountering a dip in the rwy, the acft became airborne. The engines lost power shortly thereafter and the acft collided that a fence and hay bales. The acft owner stated that the plt (a prospective buyer of the acft)… - [NTSB CHI85LA041](https://openairdocs.org/ntsb/CHI85LA041.md): Cessna 150M · Pillager, MN · Accident · No injuries · Limited investigation · Final report · Nov 6, 1984 · N45574 · Substantial damage > The plt took off uphill on a grass rwy that was dew covered. The field was aprx 1600 ft long bordered by 50-75 ft trees. The plt stated that during takeoff roll the acft lights were flickering. He said that the acft was airborne aprx 300 ft before reaching… - [NTSB SEA85LA014](https://openairdocs.org/ntsb/SEA85LA014.md): Hiller UH-12E · Lakeside, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 1984 · N123ET · Destroyed > The acft collided with power lines during a takeoff from a remote logging camp. The plt reported hearing a loud bang during takeoff. He said that the acft pitched right and nosed down. 'The acft spun to the right without power. The acft came to rest… - [NTSB NYC85FFJ01](https://openairdocs.org/ntsb/NYC85FFJ01.md): Stevens MONNETT-MONI · Endicott, NY · Accident · Serious injuries · Final report · Nov 3, 1984 · N234NS · Substantial damage > The acft collided with the terrain in an uncontrolled descent following a partial loss of power during a takeoff climb. The plt stated the RPM dropped from 5200 to 4600 at which time he attempted to lean the mixture. A severe vibration developed and not… - [NTSB CHI85LA044](https://openairdocs.org/ntsb/CHI85LA044.md): Wells KR-2 · Delaware, OH · Accident · Serious injuries · Limited investigation · Final report · Nov 3, 1984 · N4486V · Destroyed > According to the plt, he made a normal takeoff in his home built acft & started to climb on a flt path that went over a warehouse. He reported that he encountered a thermal & severe turbulence which were created by the warehouse. He stated that this caused… - [NTSB NYC85LA018](https://openairdocs.org/ntsb/NYC85LA018.md): Beech G18S · Laconia, NH · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 1984 · N32809 · Destroyed > According to the plt, shortly after takeoff the acft began to pitch up, decelerate, and roll right. He reduced power and lowered the nose in an unsuccessfull attempt to regain control. There were no mechanical malfunctions reported. - [NTSB ANC85LA019](https://openairdocs.org/ntsb/ANC85LA019.md): Helio H-250 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Nov 1, 1984 · N5450E · Substantial damage > The plt stated during two telephone interviews that he hit trees during takeoff and then continued his two hour flt to to the homer arpt. The left wing was damaged and both left and right sides of the horizontal stabilizer were crushed andbent up about 19… - [NTSB FTW85LA026](https://openairdocs.org/ntsb/FTW85LA026.md): Piper PA-28-140 · Hinton, OK · Accident · No injuries · Limited investigation · Final report · Oct 27, 1984 · N55303 · Substantial damage > During takeoff on an instructional flt with a CFI aboard, the acft struck a grain wagon. The CFI stated that on takeoff, the student lifted off prematurely and the acft struck the parked vehicle. The CFI took no corrective action. - [NTSB CHI85LA028](https://openairdocs.org/ntsb/CHI85LA028.md): Swift GC-1A · Fraser, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1984 · N74A · Substantial damage > According to the plt, he took off on rwy 18 & was climbing thru about 250 ft AGL when the eng lost power & he made a forced landing. However, a co-owner, who was on board, stated that the plt had retarded the throttle, then the acft stopped stopped climbing,… - [NTSB ATL85LA023](https://openairdocs.org/ntsb/ATL85LA023.md): Four Seasons Aviations American Aerolight · Springville, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1984 · N953AA · Substantial damage > At aprx 150 ft the plt heard a noise and observed a fire involving the rear portion of the acft. The plastic fuel tank ruptured and burning fuel was sucked aft through the pusher prop. The ballistic parachute was deployed and opened as the acft hit a 60 ft… - [NTSB CHI85LA025](https://openairdocs.org/ntsb/CHI85LA025.md): Piper PA-38-112 · Minneapolis, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 23, 1984 · N9844T · Destroyed > On initial climb from takeoff, the plt noted the engine cowling was loose and vibratring. Plt initiated a shallow turn back for landing but preoccupation with the cowling caused him to allow the acft to enter a steep bank. During the plt's attempts to reduce… - [NTSB ATL85LA017](https://openairdocs.org/ntsb/ATL85LA017.md): Bell 222 · Pascagoula, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1984 · N38929 · Substantial damage > The acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched… - [NTSB ANC85LA010](https://openairdocs.org/ntsb/ANC85LA010.md): Piper PA-18 · Port Heiden, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 1984 · N4313Y · Substantial damage > According to a state police report, the plt assaulted his wife, then loaded his two children into the acft and flew to a refueling area. He refueled the acft, then tookoff & crashed aprx 1 mile north of the departure rwy. A witness reported that after the… - [NTSB CHI85LA017](https://openairdocs.org/ntsb/CHI85LA017.md): Crosetti Glasair - TD · Ypsilanti, MI · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N278BC · Substantial damage > The acft had just returned from a flt. Engine run-up and pre-flt checks were normal. On initial climb, eng lost pwr to extent continued flight was not possible. Plt executed forced landing in an open field. Inspection revealed a bird feather lodged against… - [NTSB MIA85FA009](https://openairdocs.org/ntsb/MIA85FA009.md): Pitts Special S-1C · Punta Gorda, FL · Accident · Serious injuries · Field investigation · Final report · Oct 15, 1984 · N54JB · Destroyed > The acft was being tested for hi-speed taxi stability. During the 3rd taxi run the acft became airborne and a decision to continue flt around the traffic pattern was made. The plt noticed the oil temp at 220 degrees & increasing. The decision to land on rwy… - [NTSB ATL85LA012](https://openairdocs.org/ntsb/ATL85LA012.md): Cessna 150 · Wirtz, VA · Accident · No injuries · Limited investigation · Final report · Oct 14, 1984 · N6348G · Substantial damage > After a 1 hr 45 min flt, plt decided to initiate another flt. Fuel quantity gages indicated 1/4 full. Eng lost pwr on initial climb. Forced landing executed in open field, wind struck fence post. Post-mishap inspection revealed fuel exhaustion. - [NTSB NYC85FHA01](https://openairdocs.org/ntsb/NYC85FHA01.md): Ercoupe 415-C Aircoupe · Brodheadsville, PA · Accident · Serious injuries · Final report · Oct 13, 1984 · N93907 · Destroyed > The acft stalled (mushed) into 35 ft trees under pwr according to the passenger on board. The pax also said another person recommended a takeoff to the south because of x-wind & terrain. The plt was quoted as saying that 'the plane has plenty of snot' & he… - [NTSB MIA85LA006](https://openairdocs.org/ntsb/MIA85LA006.md): Piper J3C-65 · Miles City, FL · Accident · No injuries · Limited investigation · Final report · Oct 13, 1984 · N35965 · Destroyed > According to the plt the acft became uncontrollable shortly after takeoff when it encountered rotor downwash generated by a departing helicopter. Initial impact occurred with a tree 200 ft left of the rwy. Post crash fire destroyed the wreckage. - [NTSB MIA85LA005](https://openairdocs.org/ntsb/MIA85LA005.md): Cessna 172 · Miles City, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1984 · N8336B · Substantial damage > The acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using… - [NTSB LAX85LA013](https://openairdocs.org/ntsb/LAX85LA013.md): Cessna 206 · Yuba City, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1984 · N5249U · Substantial damage > The acft collided with trees during a forced landing after the eng failed on takeoff from sutter county airport. Post crash examination of the acft did not reveal evidence of an airframe or eng pre-impact failure or malfunction. - [NTSB LAX85MA008](https://openairdocs.org/ntsb/LAX85MA008.md): Gates Learjet 24B · San Francisco, CA · Accident · 3 fatal · Major investigation · Final report · Oct 9, 1984 · N864CL · Destroyed > The acft, a Gates lear jet 24B, modified by a howard/raisebach mark ii conversion, was cleared for takeoff on rwy 28L. Tower psnl estimated that the acft rotated for takeoff at 3200' down the rwy & was at aprx 200' AGL when the plt was instructed to contact… - [NTSB ANC85LA003](https://openairdocs.org/ntsb/ANC85LA003.md): Piper PA-18 · Big Susitna Rvr, AK · Accident · No injuries · Limited investigation · Final report · Oct 9, 1984 · N2583P · Substantial damage > Engine failure occurred shortly after takeoff due to water contamination in the fuel system. The pilot stated that a more thorough pre-flight inspection should have been accomplished. The acft collided with the terrain during the uncontrolled descent. - [NTSB LAX85FA006](https://openairdocs.org/ntsb/LAX85FA006.md): Beech 95-A55 · Newport Beach, CA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1984 · N9572Y · Destroyed > Shortly after takeoff, the propeller separated from the aircraft's left engine. The aircraft continued to climb straight ahead and was then observed in s steep left turn during which it descended and crashed into the roof of a building approximately one… - [NTSB FTW85IA011](https://openairdocs.org/ntsb/FTW85IA011.md): Cessna Citation 550 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Oct 8, 1984 · N107T · 2 aircraft · No damage > N3322L inadvertently crossed the active rwy 04 at the time N107T became airborne on takeoff from that rwy. A near miss occurred as the captain and 1st officer of N107T observed N3322L on the rwy and made a max performance climb over the top of N3322L. N3322L… - [NTSB DEN85LTG01](https://openairdocs.org/ntsb/DEN85LTG01.md): Homebuilt EAA Special · Pembina, ND · Accident · Minor injuries · Final report · Oct 8, 1984 · N4632T · Substantial damage > This was the pilot's first operation in this make and model. During taxi, excessive use of brakes caused the aircraft to weave severely. Power was not reduced but back stick input was made. The aircraft became airborne prematurely in ground effect, stalled at… - [NTSB DEN85LA006](https://openairdocs.org/ntsb/DEN85LA006.md): Piper PA-22 · Rocky Ford, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 1984 · N8759D · Destroyed > According to the plt, at 150 to 200 ft AGL the acft was unable to continue the climb or maintain alt. During the forced landing rollout in a corn field the acft nosed over and came to rest inverted. Engine disassembly revealed no mechanical malfunctions. The… - [NTSB NYC85FFA01](https://openairdocs.org/ntsb/NYC85FFA01.md): Cessna 172I · Essex, NY · Accident · Serious injuries · Final report · Oct 6, 1984 · N215NY · Substantial damage > Witnesses stated acft became airborne near the slight rise in the rwy, aprx 1500 ft down the rwy, and climbed to aprx 60 ft AGL. Acft shuttered and nose of acft pitched up. Left wing and nose then dropped. Acft continued descending to the left across a small… - [NTSB MKC85LA003](https://openairdocs.org/ntsb/MKC85LA003.md): Grumman AA1B · House Springs, MO · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1984 · N8886L · Substantial damage > The acft crashed in a cornfield after takeoff. The takeoff was from a 1550 ft long, wet and soft turf rwy. The acft lifted off near the end and would not climb. The acft stalled and crashed. - [NTSB LAX85LA003](https://openairdocs.org/ntsb/LAX85LA003.md): Schweizer SGS 2-33 · Twentynine Palm, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1984 · N2616H · Destroyed > While being towed at an alt of aprx 200 ft AGL glider was below normal tow position. Glider was put into a nose high attitude for correction and the weak link in the tow line separated. Glider stalled, rt wing dropped and acft contacted the terrain. - [NTSB CHI85LA009](https://openairdocs.org/ntsb/CHI85LA009.md): Mccoy KR-2 · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1984 · N83HL · Substantial damage > The plt reported that during takeoff, the acft was climbing thru about 50 ft AGL when he felt a vibration & noted a loss of power. Subsequently, the acft touched down hard near the departure end of the rwy. The main gear collapsed, then the acft slid into a… - [NTSB SEA85LA002](https://openairdocs.org/ntsb/SEA85LA002.md): Schweizer SGS 2-33A · Hood River, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1984 · N5786S · Substantial damage > At about 150 ft AGL on climb out, the tow plane lost power for an unspecified reason. The glider pilot released the tow and executed a 180 degree course reversal to a downwind (15 KTS) landing. During roll out, the left wing contacted the ground, causing an… - [NTSB MIA85FA002](https://openairdocs.org/ntsb/MIA85FA002.md): Piper PA-38-112 · Wauchula, FL · Accident · Serious injuries · Field investigation · Final report · Oct 4, 1984 · N91353 · Substantial damage > Plt used outdated sectional chart & landed at an old (closed) airport, which was no longer maintained. On departure, using soft field procedures, acft did not accelerate properly & became airborne in ground effect at minimal speed. Plt determined acft would… - [NTSB NYC85LA002](https://openairdocs.org/ntsb/NYC85LA002.md): Piper PA-18-150 · Waterbury, CT · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1984 · N83665 · Destroyed > After liftoff, the plt initiated a turn into the crosswind to maintain runway heading. As he did so, a wind gust tipped the acft in the direction of the turn. Ground contact occurred before corrective control inputs by the plt could take effect. - [NTSB FTW85LA002](https://openairdocs.org/ntsb/FTW85LA002.md): Grumman G-164A · Progreso, TX · Accident · No injuries · Limited investigation · Final report · Oct 1, 1984 · N5255 · Substantial damage > Shortly after takeoff, plt heard explosive report from engine and experienced partial pwr loss. Plt attempted to return for landing but could not maintain sufficient altitude. Load not jettisoned. During forced landing roll out in cane field acft nosed over.… - [NTSB CHI84LA408](https://openairdocs.org/ntsb/CHI84LA408.md): Piper PA-23-150 · Defiance, OH · Accident · No injuries · Limited investigation · Final report · Sep 30, 1984 · N1424P · Substantial damage > During initial takeoff climb at alt of 300 ft AGL, 9 1/4 inches of rt engine prop blade separated. Forced landing was make in field during which time the rt wing contacted a tree. Metallurgical examination revealed progressive fatigue over 75% of the… - [NTSB SEA84LA234](https://openairdocs.org/ntsb/SEA84LA234.md): Piper PA-28-151 · Shady Cove, OR · Accident · No injuries · Limited investigation · Final report · Sep 29, 1984 · N788MS · Substantial damage > The pilot stated after the accident that he stalled the aircraft at an altitude of 50 ft AGL during takeoff and the acftdescended in a nose low attitude into trees and the ground. - [NTSB MIA84LA263](https://openairdocs.org/ntsb/MIA84LA263.md): Cessna 421 · Naples, FL · Accident · No injuries · Limited investigation · Final report · Sep 28, 1984 · N11PM · Substantial damage > During climbout on this FAA check ride the acft experienced a nose gear extension-retraction malfunction of unknown origin. The plt was unable to extend the nose gear for landing. According to the FAA examiner on the flt, the PIC shut down both engines on… - [NTSB SEA84LA200](https://openairdocs.org/ntsb/SEA84LA200.md): Piper PA-28-180 · Boulder City, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1984 · N8482W · Substantial damage > Plt executed a forced landing in a field following a loss of power during initial takeoff climb. Post accidnet investigation revealed a large quantity of water in the fuel system. The acft had been parked at an arpt with 1/2 full fuel tanks. The tie down area… - [NTSB NYC84LA323](https://openairdocs.org/ntsb/NYC84LA323.md): Piper PA-28-140 · Hazleton, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1984 · N8859K · Destroyed > Acft departed with full fuel and passenger load near max gross weight, toward rising terrain. After reaching about 400 ft AGL, plt felt acft was losing climb performance, although no signs of power decrease were noted. Acft seemed to be settling. Plt noted… - [NTSB MIA84LA261](https://openairdocs.org/ntsb/MIA84LA261.md): Cessna 172 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1984 · N777TA · Substantial damage > Plt stated, the acft was lifted off prematurely in ground effect on takeoff. When the acft reached tree top level a gust of wind caused the acft to drift to the right of the rwy where the right wing contacted trees. The acft spun 180 deg in heading before… - [NTSB BFO84FA008](https://openairdocs.org/ntsb/BFO84FA008.md): Piper PA-28-140 · Bayse, VA · Accident · Serious injuries · Field investigation · Final report · Sep 23, 1984 · N75122 · Destroyed > According to witnesses, the acft became airborne after rolling only about 1500 ft. it was described a being 'behind the power curve' for a considerable distance before climbing abruptly. The acft then banked steeply to the left & collided with a ridge at aprx… - [NTSB MKC84LA283](https://openairdocs.org/ntsb/MKC84LA283.md): Enstrom F-28A · Slater, MO · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N30HW · Substantial damage > Plt quickly pulled excessive collective while attempting takeoff from a hover. Rotor RPM decreased and the acft touched down hard on the right skid. A post accident engine run revealed no discrepancies. - [NTSB LAX84LA491](https://openairdocs.org/ntsb/LAX84LA491.md): Ryan-Navion NAV-4-1908 · Milpitas, CA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1984 · N4908K · Substantial damage > The acft made a forced landing immediately after takeoff when the engine quit at about 220 ft AGL. The acft was landed in a garbage dump. Post accident investigation revealed no discrepancies in the acft to account for the engine stoppage. The reported… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=190 ## 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=189 --- 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.