# 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 190 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI84FA396](https://openairdocs.org/ntsb/CHI84FA396.md): Robert Eggebrecht Sonerai 2L · Plato Center, IL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1984 · N199B · Destroyed > The acft stalled & spun to the ground from about 200 ft AGL after an abrupt pull-up to aprx 45 degree deck angle during a premature liftoff. The plt had been observed making high speed taxi runs 'to get the feel of the acft'. After a run resulted in a… - [NTSB ANC84LA187](https://openairdocs.org/ntsb/ANC84LA187.md): Stinson 108-2 · Cairn Mountain, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1984 · N8028K · Substantial damage > The acft crashed during a takeoff from a remote airstrip. The plt stated that he walked the strip prior to starting the takeoff. He said that immediately after liftoff the acft began to drift left. Before he was able to make a correction the tail of the acft… - [NTSB ANC84FA189](https://openairdocs.org/ntsb/ANC84FA189.md): Cessna 188 · Chugiak, AK · Accident · No injuries · Field investigation · Final report · Sep 22, 1984 · N84490 · Substantial damage > The plt stated the acft was covered with ice but he removed the majority of it before taking off. The acft contained a 200 gal load of fuel in the hopper. The plt stated the acft accelerated slower than normal and the takeoff ground run was long. He stated… - [NTSB DEN84LA297](https://openairdocs.org/ntsb/DEN84LA297.md): Windecker Research Eagel AC7 · Deming, NM · Accident · No injuries · Limited investigation · Final report · Sep 21, 1984 · N4198G · Substantial damage > The acft collided with the rwy gear up after takeoff. The plt said he encountered a microburst which forced the acft to the rwy. There were reported thunderstorms in the area. The plt also said he is going to alter his takeoff proceduresto raising the landing… - [NTSB NYC84LA317](https://openairdocs.org/ntsb/NYC84LA317.md): Piper PA-28-140 · Medford, NJ · Accident · No injuries · Limited investigation · Final report · Sep 19, 1984 · N33396 · Substantial damage > During engine run-up, right magneto had excessive RPM drop. Plt leaned mixture for burn-out and inavvertently shut down engine. After restart, plt ran engine with lean mixture; subsequent magneto check was within limits. At 300 ft AGL on initial climb, engine… - [NTSB NYC84FNE07](https://openairdocs.org/ntsb/NYC84FNE07.md): Fuller/Findlay Varieze · Worcester, MA · Accident · 1 fatal · Final report · Sep 19, 1984 · N67TR · Destroyed > Witnesses stated, after what appeared to be a longer then normal takeoff roll, acft rotated to a very steep climb angle. Estimates regarding climb angle vary from 'slightly nose up' to vertical. Acft climbed to 100-150 ft AGL and rotated to an extremely nose… - [NTSB ATL84LA291](https://openairdocs.org/ntsb/ATL84LA291.md): Cessna 150L · Vine Grove, KY · Accident · No injuries · Limited investigation · Final report · Sep 18, 1984 · N5447Q · Substantial damage > During landing roll on an 1800 ft sod airstrip, nose wheel began to shimmy and the plt initiated an aborted landing. Plt added full power and raised flaps to 10 deg. As acft approached power lines near departure end of the rwy plt made a slight left turn and… - [NTSB ANC84LA181](https://openairdocs.org/ntsb/ANC84LA181.md): Cessna 152 II · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1984 · N94505 · Substantial damage > FBO had been experiencing difficulties with spark plugs and magnetos in this acft. The plt had flown this acft before with recurrent rough running and diminished power symptoms. Eng began to run rough on this flt and plt landed on a sand bar (marked for acft… - [NTSB CHI84LU011](https://openairdocs.org/ntsb/CHI84LU011.md): Reicher FP-101 · Mankato, MN · Accident · Serious injuries · Final report · Sep 16, 1984 · UNREG · Destroyed > The pilot of the ultra-light stated that he made a take-off and climbed to about 30 ft then attempted a right turn. He said the aircraft stalled and crashed into the soybean field field. The pilot reported 12 previous flights but no pilots certificate. - [NTSB ANC84LA177](https://openairdocs.org/ntsb/ANC84LA177.md): Cessna P210N · Point Hope, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 1984 · N731FT · Substantial damage > The acft crashed during an attempted night takeoff with the plt controlled rwy lights turned off. The plt stated he had consumed a couple of alchoholic beverages earlier in the evening; and although approached by several people to fly, he stated he refused… - [NTSB FTW84LA398](https://openairdocs.org/ntsb/FTW84LA398.md): Cessna 172P · Seguin, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1984 · N51250 · Destroyed > The acft crashed during the takeoff phase of a touch-&-go landing. The student plt stated that the wind direction and speed had changed at lift-off causing the acft to become airborne then to descend and hit the ground before coming to a stop inverted. - [NTSB ATL84LA289](https://openairdocs.org/ntsb/ATL84LA289.md): William T. Hodges Goldwing · Americus, GA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N132GW · Substantial damage > During the initial takeoff climb at an alt of 150 ft AGL, a ttl loss of power occurred. A forced landing was made in a soybean filed at which time the acft was substantially damaged. The plt stated the loss of power resulted from the installation of a… - [NTSB ANC84FA176](https://openairdocs.org/ntsb/ANC84FA176.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Sep 15, 1984 · N3010A · Substantial damage > Plt stated takeoff was slow and acft could not clear on-coming rising terrain and obstacles. Left wing contacted 100 ft tall tree tops aprx 2500 ft from departure end of rwy yawing acft 180 degrees from direction of flt. Plt failed to perform weight and… - [NTSB MKC84LA277](https://openairdocs.org/ntsb/MKC84LA277.md): Piper PA-22-150 · Vilonia, AR · Accident · No injuries · Limited investigation · Final report · Sep 13, 1984 · N1629P · Destroyed > The acft was forced to land after takeoff when the engine lost power. The plt said he had refueled from the automotive pump at his grocery store. The plt suspected water contaminaion in the fuel. - [NTSB MKC84LA275](https://openairdocs.org/ntsb/MKC84LA275.md): Republic RC-3 · Little Rock, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1984 · N6516K · Substantial damage > The antique acft was purchased and a ferry flt to California attempted with very limited dual instruction and minimal knowledge of the acft. The propeller installed on the acft was not in accordance with FAA specifications. An STC was available for the… - [NTSB NYC84FIG04](https://openairdocs.org/ntsb/NYC84FIG04.md): Jett Shoestring · Gaithersburg, MD · Accident · 1 fatal · Final report · Sep 10, 1984 · N53J · Destroyed > According to witnesses, the acft experienced an engine power loss during the initial climb after takeoff. The acft was observed to descend near vertically to ground impact. Teardown of the engine revealed discrepancies in the carburetor assembly. The plt had… - [NTSB CHI84LA389](https://openairdocs.org/ntsb/CHI84LA389.md): Denil Sonera II · De Pere, WI · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1984 · N2265N · Substantial damage > Plt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy. - [NTSB ANC84LA180](https://openairdocs.org/ntsb/ANC84LA180.md): Cessna U206 · Hartman River, AK · Accident · No injuries · Limited investigation · Final report · Sep 10, 1984 · N5015U · Substantial damage > The pilot stated that after takeoff the right gear collided with brush slowing the aircraft. The aircraft then touched down in rough terrain and nosed over. - [NTSB MKC84LA273](https://openairdocs.org/ntsb/MKC84LA273.md): American AA-1A · Pleasant Hill, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1984 · N7262L · Destroyed > The acft settled into 10-15 ft tall trees during takeoff. The rwy was 1200 ft long and the wind was 2 KTS. The plt said the trees should be cut as a preventive measure. The plt also said there were no problems with the acft. - [NTSB ATL84FA282](https://openairdocs.org/ntsb/ATL84FA282.md): Piper PA-31-325 · Lynchburg, VA · Accident · Serious injuries · Field investigation · Final report · Sep 9, 1984 · N29RH · Destroyed > Shortly after takeoff the plt reported to the tower that the left eng had failed. The prop was feathered and a left turn to downwind initiated. In the turn the right eng failed and the acft flew into trees in a residential area about 1 mile from the arpt. No… - [NTSB ANC84LA146](https://openairdocs.org/ntsb/ANC84LA146.md): Piper PA-18 · Circle City, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N3816Z · Substantial damage > After tkf the plt made a rt turn. The plt was unable to rollout from the turn. The acft pitched down slightly. The plt applied full power and lowered the flaps full down. The plt was unable to stop the descent. The acft collided with the ground in a rt… - [NTSB LAX84LA476](https://openairdocs.org/ntsb/LAX84LA476.md): Cessna 152 · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N4959H · Substantial damage > The plt stated that this was the first flt after the eng had been overhauled. During the takeoff climb at an alt of 500 ft the eng lost pwr. The plt made a hard landing adjacent to the rwy. Exam of the eng after the accident revealed the exhaust rocker arm… - [NTSB LAX84FA472](https://openairdocs.org/ntsb/LAX84FA472.md): Cessna 310 · Redlands, CA · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1984 · N381LS · Destroyed > Gnd witnesses obsvd an initial erratic takeoff gnd roll. After the acft reached 200 ft it experienced a power loss on the left engine. The acft stalled as it turned left, entered into an uncontrolled descent and crashed. The post impact fire consumed the… - [NTSB ANC84LA167](https://openairdocs.org/ntsb/ANC84LA167.md): Piper PA-18 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N5127Y · Substantial damage > According to the plt, he was taking off from a hay field to the east toward trees that were up to 80 ft tall. He estimated a right quartering head wind at 15 KTS gusting to 25 KTS. He stated that he encountered a downdraft just before reaching the area of the… - [NTSB SEA84LA222](https://openairdocs.org/ntsb/SEA84LA222.md): Cessna 150 · Spanaway, WA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1984 · N5701G · Substantial damage > Acft lost power during takeoff. Plt made forced landing straight ahead in open field. - [NTSB CHI84LA386](https://openairdocs.org/ntsb/CHI84LA386.md): Piper PA25 · Sheboygan, WI · Accident · No injuries · Limited investigation · Final report · Sep 7, 1984 · N4571Y · Substantial damage > Plt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground. - [NTSB ATL84FKG12](https://openairdocs.org/ntsb/ATL84FKG12.md): Cessna 411 · Hazlehurst, GA · Accident · No injuries · Final report · Sep 7, 1984 · N666CS · Substantial damage > Upon takeoff at alt of 300 ft AGL, plt stated, rt engine failed. Plt feathered rt engine. Acft began to turn to rt so plt reduced pwr on left engine and made a forced landing straight ahead in a field. Acft contacted a small pine tree, slid sideways and gear… - [NTSB FTW84LA380](https://openairdocs.org/ntsb/FTW84LA380.md): Beech A36 · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1984 · N3675T · Substantial damage > Failure to complete both the takeoff and landing check-lists resulted in taking off with the elevator trim improperly set and the gear-up landing. According to the plt, as the acft was cleaned-up after takeoff from rwy 17R the nose became very heavy. The… - [NTSB FTW84LA379](https://openairdocs.org/ntsb/FTW84LA379.md): Piper PA-28-140 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N6842J · Substantial damage > The acft did not climb above 25 to 50 ft AGL after takeoff. The plt said 'the engine felt loaded down.' The stall warning horn sounded and the plt told everyone to 'hang on' as he lowered the nose of the acft. The acft touched down about 555 ft beyond the… - [NTSB DEN84LA285](https://openairdocs.org/ntsb/DEN84LA285.md): Grumman G-164A · Berlin, ND · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N6887Q · Substantial damage > The acft collided with the ground in a soft field and nosed over. The plt reported that the engine lost power and he could not dump his load because the dump handle came off. The plt said 100 gallons of liquid fertilizer was loaded on the acft. The plt did… - [NTSB CHI84LA378](https://openairdocs.org/ntsb/CHI84LA378.md): Cessna 320B · Clear Lake, MN · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N32ORD · Substantial damage > Following maint on an air vent the mechanic failed to secure the map compartment. The ass'y interfered with the rearward movement of the control yoke on rotation for takeoff limiting the climb rate and resulting in a collision with the trees. The flt… - [NTSB ANC84FA157](https://openairdocs.org/ntsb/ANC84FA157.md): Artic S-1B2 · Clam Gulch, AK · Accident · No injuries · Field investigation · Final report · Sep 4, 1984 · N62AT · Substantial damage > Plt stated that on takeoff from a 600 ft long gravel bar, the acft hit a clump of brush with the rt main landing gear. He stated that the acft turn into the path of taller brush, so he reduced the pwr and landed, turn 180 degrees after impact. The plt aslo… - [NTSB NYC84LA302](https://openairdocs.org/ntsb/NYC84LA302.md): Cessna 305A · Madison, CT · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N11SU · Substantial damage > Purpose of flt was fam in this make/model for front seat plt by rear seat check-out plt. Preflight fuel quantity was checked by ref to gages only. Left tank read 1/2 full. Neither plt recalled rt tank reading. After takeoff, at about 150 ft, complete pwr loss… - [NTSB LAX84LA470](https://openairdocs.org/ntsb/LAX84LA470.md): Piper PA-28-161 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N29484 · Substantial damage > At 100 to 150 ft AGL eng RPM decreased to about 1,500. A turn back to the arpt was initiated. On short final the left wingtip struck a fence causing the acft to cartwheel to a stop on arpt property. Eng exam revealed that the #2 cyl was developing no… - [NTSB LAX84FA467](https://openairdocs.org/ntsb/LAX84FA467.md): Piper PA-23-235 · Rubidoux, CA · Accident · 2 fatal · Field investigation · Final report · Sep 3, 1984 · N4967P · Destroyed > The plt failed to remove the control lock during his preflt inspection; thus, the elevator control was locked & no pitch control was available during the takeoff. Rotation occurred when the acft reach flying speed. The acft became airborne & its pitch angle… - [NTSB CHI84LA380](https://openairdocs.org/ntsb/CHI84LA380.md): Piper PA-24-260 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N499LG · Substantial damage > During a takeoff climb at 400 ft AGL the eng lost pwr. The plt stated that he failed to switch fuel tanks. The right fuel tank was found empty. - [NTSB MKC84LU008](https://openairdocs.org/ntsb/MKC84LU008.md): Eipper Quicksilver MX · North Platte, NE · Accident · Serious injuries · Final report · Sep 1, 1984 · UNREG · Substantial damage > The ultralight operator said he turned off the selector valve after a previous landing. During a later takeoff, he failed to use a checklist and did not reset the selector. The engine quit at about 30 ft AGL. Ground witnesses heard theengine sputter and… - [NTSB MIA84LA245](https://openairdocs.org/ntsb/MIA84LA245.md): Champion 7FC · Fort Drum, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1984 · N7580E · Substantial damage > The acft collided with a power line and the ground after a loss of power during takeoff. The plt was not certificated. The passenger said that the plt attributed the power loss to water in the fuel. The acft was being operated on automobile fuel. Attempts to… - [NTSB LAX84LA477](https://openairdocs.org/ntsb/LAX84LA477.md): Piper PA-22-135 · Byron, CA · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N77G · Substantial damage > During takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board. - [NTSB ANC84LA159](https://openairdocs.org/ntsb/ANC84LA159.md): Cessna 172E · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N5425T · Substantial damage > The acft was taking off from an airport which was an unimproved field site. According to the plt the acft would not accelerate and climb out so he stalled into the brush along a creek bed. The plt said the acft had departed this field before but both times… - [NTSB BFO84IA004](https://openairdocs.org/ntsb/BFO84IA004.md): Beech 58 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Aug 31, 1984 · N72TM · Minor damage > The plt made an emergency landing on rwy 18 following a loss of power in the rt eng & a subsequent in-flight fire. Investigation revealed a crack in the #1 cyl that originated at the exhaust port, downstream of the valve. The crack propagated through fatique… - [NTSB FTW84LA364](https://openairdocs.org/ntsb/FTW84LA364.md): Grumman G-164A · Schriever, LA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1984 · N5469 · Substantial damage > The plt stated that he had full fuel & a full load of spray when the eng exploded. The nature & cause of the pwr failurewas not determined & external examination of the eng revealed no evidence of a mechanical failure. - [NTSB LAX84LA461](https://openairdocs.org/ntsb/LAX84LA461.md): Beech A36 · Livermore, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1984 · N2876W · Destroyed > The plt visually checked the fuel tanks during his pre-flt & estimated 10-20 gals of fuel remaining in both the left & right tanks. He said that the start, taxi & run-up were performed while using the right rank. He reported that the right fuel gage reading… - [NTSB LAX84FA463](https://openairdocs.org/ntsb/LAX84FA463.md): Piper PA-28-180 · Bakersfield, CA · Accident · No injuries · Field investigation · Final report · Aug 29, 1984 · N7916W · Substantial damage > The student plt landed long on an intended touch and go landing and therefore, rolled out to a full stop on rwy 31. A 180 deg turn was made at the end in order to takeoff on rwy 13. Prior to initiating the takeoff, according to the student plt, he placed the… - [NTSB CHI84LA370](https://openairdocs.org/ntsb/CHI84LA370.md): Piper PA-22-150 · Lake City, MI · Accident · No injuries · Limited investigation · Final report · Aug 29, 1984 · N7335D · Substantial damage > According to the plt, at about 30 ft AGL after takeoff the eng RPM began to decrease. The acft flew into a tree adjacent to a road near the end of the rwy. A visual inspection of the engine revealed no mechanical malfunctions. The property owner reported that… - [NTSB CHI84IA373](https://openairdocs.org/ntsb/CHI84IA373.md): Boeing 737-291 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Aug 29, 1984 · N7351F · No damage > Shortly after lift-off & while climbing thru about 150 ft AGL, there was a loud noise from the left eng when it failed. The aircrew secured the left eng, returned to the arpt & made a single eng landing without further incident. An investigation revealed that… - [NTSB CHI84FA369](https://openairdocs.org/ntsb/CHI84FA369.md): Piper PA-28RT-201 · Muncie, IN · Accident · 3 fatal · Field investigation · Final report · Aug 29, 1984 · N4355N · Destroyed > Witnesses reported that when the acft was taking off, the eng sounded 'rough & was backfiring.' They observed the acft cross the departure end of the rwy at a lower alt & slower speed than what they considered as normal. They saw the acft's wings rock, then… - [NTSB NYC84FFA05](https://openairdocs.org/ntsb/NYC84FFA05.md): Russell ST. Arnold RLU-1 · Oneonta, NY · Accident · Serious injuries · Final report · Aug 28, 1984 · N2B · Substantial damage > The acft was observed making taxi runs up & down rwy 13. On the last run the acft became airborne, climbed to aprx 75 ft, made a steep left bank & impacted the ground. The plt stated he has no recollection of making the takeoff. - [NTSB MKC84FCA02](https://openairdocs.org/ntsb/MKC84FCA02.md): Mooney M20E · Chesterfield, MO · Accident · Serious injuries · Final report · Aug 28, 1984 · N9373M · Destroyed > The acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to… - [NTSB DEN84LA270](https://openairdocs.org/ntsb/DEN84LA270.md): Weatherly 201B · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Aug 27, 1984 · N1268W · Substantial damage > During initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=191 ## 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=190 --- 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.