# 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 196 of 412 · 20,559 cases ## Cases, newest first - [NTSB FTW84LA198](https://openairdocs.org/ntsb/FTW84LA198.md): Cessna 150F · Monterey, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 1984 · N8284F · Destroyed > The plt landed at an improved private strip. Later, he took off in winds that he reported were down the rwy at 12 KTS gusting to 14 KTS. After lift-off the acft 'climbed normally' & cleared a power line as well as low trees at the end of the strip. However,… - [NTSB NYC84FA129](https://openairdocs.org/ntsb/NYC84FA129.md): Piper PA-28R-201 · Burlington, CT · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1984 · N9487C · Destroyed > The acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the… - [NTSB MKC84LA125](https://openairdocs.org/ntsb/MKC84LA125.md): Cessna 150K · Paragould, AR · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N6057G · Substantial damage > A student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No… - [NTSB MKC84LA123](https://openairdocs.org/ntsb/MKC84LA123.md): Rockwell S-2R · Monette, AR · Accident · No injuries · Limited investigation · Final report · Apr 13, 1984 · N8522V · Substantial damage > The owner/plt reported that just after lift-off, he heard a loud squeal & the eng lost power. He dumped his load to clear trees then landed hard in a wheat field just beyond the trees. A dissassembly of the eng revealed that a supercharger bearing had failed… - [NTSB DEN84LA127](https://openairdocs.org/ntsb/DEN84LA127.md): Piper PA-28-140 · Monticello, UT · Accident · No injuries · Limited investigation · Final report · Apr 13, 1984 · N4FN · Substantial damage > The pilot departed uphill with a tailwind at near gross weight with a high density altitude. The flight was late gettingstarted & an excessive magneto drop was attributed to a fouled plug. The pilot also stated that he was under mental stress. The acft lifted… - [NTSB NYC84FA137](https://openairdocs.org/ntsb/NYC84FA137.md): Grumman American AA-1C · Marlboro, NJ · Accident · 2 fatal · Field investigation · Final report · Apr 10, 1984 · N9950U · Destroyed > Pilot and pax departing 2170 ft rwy at near max gross weight pax stated it didnt appear as if they were going to clear high tension power lines located about 2400 ft from rwy end. Pilot made left turn and impacted unmarked wires about 600 ft left of extended… - [NTSB NYC84FHM05](https://openairdocs.org/ntsb/NYC84FHM05.md): Cessna 182P · Clarkstown, NY · Accident · 1 fatal · Final report · Apr 7, 1984 · N1516M · Destroyed > Student plt stated he informed the CFI during takeoff that the acft would not continue to climb. The CFI then took control of the acft. Witnesses stated the eng seemed to stop and the acft entered a glide, banking to the left from aprx 150 ft AGL. The left… - [NTSB MKC84LA120](https://openairdocs.org/ntsb/MKC84LA120.md): Cessna 182 · Panama, NE · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 1984 · N893IT · Substantial damage > Shortly after takeoff, the eng lost power & decelerated to idle RPM. The plt attempted to restore power while making a 180 deg turn back to the arpt. During the landing, the acft struck the ground, nose 1st, collapsing the gear. The acft came to rest after… - [NTSB ATL84FMG02](https://openairdocs.org/ntsb/ATL84FMG02.md): Piper PA-28-150 · Apex, NC · Accident · No injuries · Final report · Apr 5, 1984 · N5839W · Substantial damage > According to the plt, the eng lost power during takeoff. He was able to keep the eng running by pumping the throttle but was not able to gain altitude. He made a forced landing on an abandoned railroad bed. Investigation revealed that the resistoflex hose p/n… - [NTSB FTW84LA185](https://openairdocs.org/ntsb/FTW84LA185.md): Grumman G-164A · Eunice, LA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N9936 · Substantial damage > The plt reported that the engine lost power on takeoff and return to the rwy was not possible, so he landed on the edge of a pond. A post accident investigaiton revealed a crack in the #7 cyl head between the spark plug holes. The engine had just gotten a… - [NTSB LAX84LA239](https://openairdocs.org/ntsb/LAX84LA239.md): Cessna 182 · Davis, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1984 · N95603 · Substantial damage > The acft made a forced landing in an open field following a power loss during takeoff. The engine was examined after theaccident and test run. No discrepancies were found. At the time of the accident weather conditions were conducive to carburetor icing. - [NTSB ANC84LA050](https://openairdocs.org/ntsb/ANC84LA050.md): Cessna U206G · Kodiak, AK · Accident · No injuries · Limited investigation · Final report · Apr 3, 1984 · N4726U · Substantial damage > According to the plt, he initiated a takeoff in a northerly direction, but the acft would not climb after lift-off. He chopped the pwr & the acft immediately touched down. Then the acft bounced, yawed left & the rt float hit the water sideways. The acft… - [NTSB CHI84LA145](https://openairdocs.org/ntsb/CHI84LA145.md): Cessna 150F · Davison, MI · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N6659F · Substantial damage > The PIC stated that although he was flying the acft the right seat plt was controlling the flap settings. The right seatplt set 20 deg for takeoff. After takeoff they noticed that they would not be able to clear trees so they right seat pltadded full flaps… - [NTSB LAX84LA237](https://openairdocs.org/ntsb/LAX84LA237.md): Cessna 150M · Happy Camp, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1984 · N9254U · Destroyed > While waiting for fog to 'burn off,' the plt preflighted the acft & then waited for about 45 min at the end of the rwy. He then decided to takeoff while the wx was still IMC. Shortly after lift-off, the acft entered instrument conditions & began turning to… - [NTSB CHI84LA147](https://openairdocs.org/ntsb/CHI84LA147.md): Cessna 177 · Kelleys Island, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1984 · N30204 · Substantial damage > According to the plt, rotation occurred about 3/5 of the way down the gravel strip and the acft climbed to 20-30 ft when the power loss occurred. In an effort to maintain alt the nose attitude was increased and the tail of the acft struck the trees and then… - [NTSB DEN84FA119](https://openairdocs.org/ntsb/DEN84FA119.md): Beech 65-A90 · Rangely, CO · Accident · No injuries · Field investigation · Final report · Mar 28, 1984 · N114CW · Substantial damage > Shortly after takeoff on a left downwind departure, a power loss on both engines occurred. Both main gear collapsed during a forced landing in a muddy sagebrush covered field. The plt had refueled the acft & had failed to drain the fuel storage tank & acft… - [NTSB ATL84FA133](https://openairdocs.org/ntsb/ATL84FA133.md): Beech A36TC · Atlanta, GA · Accident · 2 fatal · Field investigation · Final report · Mar 27, 1984 · N3808N · Substantial damage > During takeoff, the plt radioed that a door had popped open & he needed to return. According to a plt witness, the acft had climbed above treetop level when it started to lose alt. Another witness said the acft leveled off & started to sink, then the nose… - [NTSB FTW84LA177](https://openairdocs.org/ntsb/FTW84LA177.md): Cessna 150F · Pearland, TX · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N8222S · Substantial damage > During takeoff, the engine lost power at about 150 feet AGL while the aircraft was climbing. The pilot made an emergency landing in a field 1/2 mile from the airport. The engine was later test run and no malfunctons noted that would account for the power loss. - [NTSB DEN84FA115](https://openairdocs.org/ntsb/DEN84FA115.md): Cessna 172RG · Greeley, CO · Accident · Serious injuries · Field investigation · Final report · Mar 25, 1984 · N6521R · Destroyed > The acft collided with trees and the ground during a night forced landing. The acft had made some strange sounds and started vibrating after takeoff. A glide was set up for a forced landing. Since the arpt could not be reached a landing was made on a dry… - [NTSB NYC84FA117](https://openairdocs.org/ntsb/NYC84FA117.md): Beech C23 · Champion, PA · Accident · 4 fatal · Field investigation · Final report · Mar 24, 1984 · N23968 · Destroyed > N23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the… - [NTSB ATL84LA130](https://openairdocs.org/ntsb/ATL84LA130.md): Piper J-5A · Forest, VA · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 1984 · N33423 · Substantial damage > The acft was taxied directly to takeoff after being handpropped to start. To the witness who handpropped the acft it appeared to climb at about a 70 degree angle after takeoff and stall before diving nose first into the ground. Engine sounds remained constant… - [NTSB ATL84FMG03](https://openairdocs.org/ntsb/ATL84FMG03.md): Bowers FLY Baby 1A · New Bern, NC · Accident · Minor injuries · Final report · Mar 24, 1984 · N4986E · Substantial damage > The plt stated the acft lost lateral control during takeoff. He reduced power and landed the acft off the side of the rwy while maintaining directional control using the rudder. The acft stalled at about 20 ft AGL and was damaged during the hard landing.… - [NTSB ATL84FA129](https://openairdocs.org/ntsb/ATL84FA129.md): Piper PA-32-260 · Woodstock, GA · Accident · Serious injuries · Field investigation · Final report · Mar 23, 1984 · N4809S · Substantial damage > Shortly after breaking ground during the takeoff, the engine lost power & the acft came back down to the rwy. The engine regained power & the plt continued the takeoff. The engine again lost power. Subsequently, the acft impacted on an uneven, grassy, open… - [NTSB LAX84LA229](https://openairdocs.org/ntsb/LAX84LA229.md): Republic RC-3 · Lakeport, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1984 · N6470K · Substantial damage > The plt reported that on his preflight he found the eng compression & oil level to be low but after servicing the oil to the proper level he departed & on initial climb, after reaching about 100 ft AGL, the eng started popping & losing RPM. The plt made a… - [NTSB FTW84LA172](https://openairdocs.org/ntsb/FTW84LA172.md): Robert Mcdonnell KR-2 · Kerrville, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 1984 · N125RM · Destroyed > According to the plt/builder of the home built acft acceleration was not up to par during the takoff roll. Takeoff was continued and initial climb was poor. A downwind turn was initiated at about 100 ft AGL. During the turn the plt noticeda strip of tape on… - [NTSB CHI84LA134](https://openairdocs.org/ntsb/CHI84LA134.md): Piper PA-28-140 · St. Ignace, MI · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 1984 · N4354J · Substantial damage > The pilot took off into adverse wx conditions & failed to attain sufficient altitude to clear trees. The purpose of the flight was to search for a missing acft. - [NTSB ATL84FA126](https://openairdocs.org/ntsb/ATL84FA126.md): Piper PA-34-200T · Fletcher, NC · Accident · 1 fatal · Field investigation · Final report · Mar 21, 1984 · N8300T · Destroyed > During takeoff the left eng lost power shortly after the landing gear was retracted. The plt stated that he felt the loss of power at about the same time that he turned off the landing lights. With the left eng manifold pressure gauge reading 25 inches hg,… - [NTSB NYC84FA113](https://openairdocs.org/ntsb/NYC84FA113.md): Beech H-18 · Morrisonville, NY · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1984 · N218X · Destroyed > The plt landed on the ice and snow covered rwy after loading 1512 lbs of cargo in freezing drizzle conditions, he taxied for takeoff for an IFR departure shortly after rotation, the right wing dropped and the acft touched down back onthe rwy. Visual exam of… - [NTSB SEA84LA069](https://openairdocs.org/ntsb/SEA84LA069.md): Piper PA 23-1300 · Battleground, WA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N3347P · Substantial damage > The acft had been parked on the ground for 2 yrs. Prior to the flt, it had been run-up several times. There was about 20 gal of fuel in each tank. The plt checked the fuel before takeoff & some water was found. He drained the fuel until no water was found.… - [NTSB NYC84LA112](https://openairdocs.org/ntsb/NYC84LA112.md): Beech 76 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N6697L · Substantial damage > During the takeoff portion of a touch-&-go, the student plt forgot to raise the flaps. The instructor (CFI) yelled at the student '...the flaps', & at the same time, reached for the flaps with his right hand under the control wheel. Subsequently, the left… - [NTSB MKC84LA105](https://openairdocs.org/ntsb/MKC84LA105.md): Beech A36TC · North Platte, NE · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N222HC · Substantial damage > The acft had just departed North Platte airport and retracted the landing gear. The acft door then opened, the pilot elected to land back on the runway and failed to remember to lower the landing gear. - [NTSB MKC84FA103](https://openairdocs.org/ntsb/MKC84FA103.md): Piper PA-24-180 · Springdale, AR · Accident · 4 fatal · Field investigation · Final report · Mar 16, 1984 · N6177P · Destroyed > About 3 minutes after takeoff the acft was observed coming out of the 400-600 ft overcast sky in about a 75 deg nose down, right wing attitude. It impacted a 4-strand high voltage powerline prior to impact with the ground. The plt had received his instrument… - [NTSB MKC84LA101](https://openairdocs.org/ntsb/MKC84LA101.md): Schweizer G-164A · Biscoe, AR · Accident · No injuries · Limited investigation · Final report · Mar 14, 1984 · N8945H · Substantial damage > After spraying operations acft propeller would be pressure sprayed. Water entered propeller pitch change bearings which corroded bearings. Eventually pitch movement was hindered by rust corrosion. The blade counterweight bolt broke allowing the propeller… - [NTSB SEA84LA067](https://openairdocs.org/ntsb/SEA84LA067.md): Piper J3C-65 · Elmira, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 1984 · N68925 · Substantial damage > The acft collided with power lines and trees after a power loss during the takeoff initial climb. The plt stated he attempted a climbing turn to avoid the power lines and trees but the acft entered a departure stall, the acft was using automotive fuel. An FAA… - [NTSB SEA84LA070](https://openairdocs.org/ntsb/SEA84LA070.md): Cessna 150-K · Fallon, NV · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N6410G · Substantial damage > The student plt said he was departing his privately owned strip & had a 7 ft fence to clear at the departure end. He reported that just as he became airborne, the acft encounter a gust of wind which caused the right wing to hit a fence post, then the acft… - [NTSB MIA84FA101](https://openairdocs.org/ntsb/MIA84FA101.md): Piper PA-38 · Jacksonville, FL · Accident · Serious injuries · Field investigation · Final report · Mar 10, 1984 · N25237 · Destroyed > The solo student plt was making a local practice flt. Witnesses observed the acft bank sharply to the left immediately after lift off & maintain a nose high attitude. The acft collided with the ground on the airport separating the left wing prior to coming to… - [NTSB FTW84FU005](https://openairdocs.org/ntsb/FTW84FU005.md): Eipper Quicksilver MXL · Huntington, TX · Accident · Serious injuries · Final report · Mar 8, 1984 · UNREG · Substantial damage > The plt made several touch and go landings in his newly acquired ultra light vehicle. On a subsquent flt at about 75 ft AGL, the outboard portion of the left wing folded upward about 90 degrees. The vehicle started to roll inverted and the plt used full… - [NTSB FTW84LA159](https://openairdocs.org/ntsb/FTW84LA159.md): Piper PA-36 · Lamesa, TX · Accident · No injuries · Limited investigation · Final report · Mar 6, 1984 · N57584 · Substantial damage > Shortly after takeoff for an aerial application flight a partial loss of power occurred. A hard forced landing was made in an open field which resulted in both main gears collapsing. Inspection of the engine revealed both magneto distributor blocks were… - [NTSB FTW84FA156](https://openairdocs.org/ntsb/FTW84FA156.md): Piper PA-23-250 · Fort Worth, TX · Accident · No injuries · Field investigation · Final report · Mar 6, 1984 · N777RG · Destroyed > The acft made a forced landing in an open field near the arpt when the right engine stopped at about 50-100 ft AGL during a touch and go landing. The CFI aboard said he had positioned the fuel tank selector to the inboard tanks prior to the last approach or… - [NTSB MIA84LA097](https://openairdocs.org/ntsb/MIA84LA097.md): Gardner Steen SKY Bont · Milton, FL · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N90534 · Destroyed > This was the initial test flt of the homebuilt acft. During takeoff the eng quit. The right landing gear caught on a guy wire during the emergency landing & the acft flipped. The plt/builder, who is a certified mechanic, attributed the power loss to a… - [NTSB CHI84LA123](https://openairdocs.org/ntsb/CHI84LA123.md): Cessna 150 · Crawfordsville, IN · Accident · No injuries · Limited investigation · Final report · Mar 2, 1984 · N6076K · Substantial damage > After returning to the arpt, the student began practicing touch-&-go landings. While climbing thru about 150 ft AGL, after the 3rd landing, the eng sputtered twice, then quit running. The acft was landed straight ahead on snow covered terrain. When the… - [NTSB FTW84LA152](https://openairdocs.org/ntsb/FTW84LA152.md): Beech E-55 · Longview, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 1984 · N1791W · Substantial damage > Shortly after takeoff the left engine ceased operating. A shallow turn back to the airport was being made when the rightengine ceased operating. A field was chosen for a forced landing and at touchdown a hard landing occurred. Investigationrevealed that the… - [NTSB MKC84LA087](https://openairdocs.org/ntsb/MKC84LA087.md): Piper PA-28-140 · Morrilton, AR · Accident · No injuries · Limited investigation · Final report · Feb 27, 1984 · N56255 · Substantial damage > The acft lost power during initial climb after takeoff at about 75 ft AGL. A forced landing was made in the trees. The acft was examined after the accident and no failures or malfunctions noted. The existing temperature and dewpoint were in carburetor icing… - [NTSB NYC84LA093](https://openairdocs.org/ntsb/NYC84LA093.md): Bell 206B · Tarentum, PA · Accident · No injuries · Limited investigation · Final report · Feb 26, 1984 · N59405 · Substantial damage > During a practice flt the plt tried to lift off but the right skid seemed to stick. The acrt rolled to the right and although the plt stated he took corrective action the acft rolled over onto its right side. - [NTSB LAX84LA199](https://openairdocs.org/ntsb/LAX84LA199.md): Cessna 182P · Redding, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 26, 1984 · N31SR · Substantial damage > The total power loss occurred due to water contamination in the fuel. Water was found in the carburetor assembly after the accident. The pilot reported that he had drained 4 to 5 gals of fuel from each tank finding no water during the month preceding the… - [NTSB SEA84LA061](https://openairdocs.org/ntsb/SEA84LA061.md): Beech A33 · White City, OR · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N9432Y · Substantial damage > The acft crashed into trees after stalling into the ground during an attempted takeoff from a soggy short sod airstrip. The acft was rotated prematurely after which it stalled at about 40 ft AGL. The plt said he should have walked the fieldto determine its… - [NTSB MKC84LA089](https://openairdocs.org/ntsb/MKC84LA089.md): Ercoupe 415C · N. Stillwell, KS · Accident · No injuries · Limited investigation · Final report · Feb 25, 1984 · N3112H · Substantial damage > After an eng power loss during takeoff climb, the plt landed the acft on the remaining runway. The hard landing resultedin a nose gear collapse. Post accident investigation revealed that the acft had only flown once in 7 months. The old automotive fuel had… - [NTSB FTW84LA146](https://openairdocs.org/ntsb/FTW84LA146.md): Chance Vought F4U-5 · Alief, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 1984 · N4903M · Destroyed > Shortly after takeoff the aircraft experienced a power loss. The pilot attempted to land in an area of new residential construction and was forced to dive under power lines, the aircraft impacted the ground in a nose low attitude and slid to a stop in less… - [NTSB CHI84LA120](https://openairdocs.org/ntsb/CHI84LA120.md): Piper PA-32RT-300 · Lima, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1984 · N30026 · Substantial damage > Heavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up… - [NTSB MIA84FA092](https://openairdocs.org/ntsb/MIA84FA092.md): Piper PA-30 · Sarasota, FL · Accident · 3 fatal · Field investigation · Final report · Feb 23, 1984 · N710SC · Destroyed > Shortly after takeoff the acft entered a descending left turn, struck a wire, a car, and a tree before contacting a building and exploding. A passenger reported that the stall warning horn had activated at least twice during the initial takeoff climb prior to… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=197 ## 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=196 --- 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.