# 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 198 of 412 · 20,559 cases ## Cases, newest first - [NTSB NYC84FA057](https://openairdocs.org/ntsb/NYC84FA057.md): Piper J3C-65 · North Hampton, NH · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1983 · N70779 · Destroyed > The acft stalled at about 100 ft of alt after takeoff during an instructional flt. One witness said the acft turned through 180 degrees before it collided with the ground in a nose low and right bank attitude. Another witness said he thought the acft was… - [NTSB LAX84FA106](https://openairdocs.org/ntsb/LAX84FA106.md): Hiller UH-12A · Van Nuys, CA · Accident · No injuries · Field investigation · Final report · Dec 16, 1983 · N8108H · Substantial damage > The instructor plt (CFI) stated that the eng quit 2 times after he refueled the helicopter. He then drained a quantity of water from the fuel gascolator & restarted the helicopter. After that he air taxied the helicopter to the flt school where, without… - [NTSB LAX84LA104](https://openairdocs.org/ntsb/LAX84LA104.md): Bell 47H-1 · Paradise, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 1983 · N42403 · Destroyed > According to witnesses, the helicopter lifted off near the north end of rwy 17 while on an eastenly heading. After lift-off, it turned right, as if to proceed down the rwy. After rising to about 5 ft AGL, it settled & contacted the rwy, rose again, then… - [NTSB FTW84LA095](https://openairdocs.org/ntsb/FTW84LA095.md): Piper PA-22-150 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Dec 12, 1983 · N3957P · Substantial damage > The plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing. - [NTSB MIA84FA043](https://openairdocs.org/ntsb/MIA84FA043.md): Temco Raley D-16A · Everglades City, FL · Accident · Serious injuries · Field investigation · Final report · Dec 11, 1983 · N704T · Destroyed > Power was lost on both engs shortly after takeoff. The plt attempted to turn towards the shoreline & land in an open field but was unable to do so. The acft collided with the water while in a left bank & cartwheeled. The fuel line between the main fuel tank… - [NTSB CHI84LA057](https://openairdocs.org/ntsb/CHI84LA057.md): Piper PA-22-150 · Owosso, MI · Accident · No injuries · Limited investigation · Final report · Dec 10, 1983 · N7234D · Substantial damage > The acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2… - [NTSB LAX84FA095](https://openairdocs.org/ntsb/LAX84FA095.md): Aerospatiale AS 355F · Black Mountain, NV · Accident · 3 fatal · Field investigation · Final report · Dec 7, 1983 · N57901 · Destroyed > The helicopter tookoff on an air ambulance flt at about 1219 PST. According to tower personnel, the departure appeared normal. Radar service was terminated at 1227 & there was no further radio contact with the helicopter. Later, the helicopter was found where… - [NTSB MIA84FA040](https://openairdocs.org/ntsb/MIA84FA040.md): Piper PA-31-350 · Lakeland, FL · Accident · 2 fatal · Field investigation · Final report · Dec 4, 1983 · N4115K · Destroyed > The acft was on its first production flt test. Shortly after lift-off it was observed to enter an abrupt right bank, followed by a steep left bank before crashing. Examination of the left wing revealed that its aileron cables were connected to their… - [NTSB ATL84FA061](https://openairdocs.org/ntsb/ATL84FA061.md): Cessna 210A · Columbia, SC · Accident · Serious injuries · Field investigation · Final report · Dec 4, 1983 · N9491X · Destroyed > The acft collided with a wall during a downwind forced landing. The engine had quit at 200 ft after takeoff. The plt turned right with the gear up. He landed on a football field and bounced down a track field into a fence and wall. When the engine was… - [NTSB LAX84FU023](https://openairdocs.org/ntsb/LAX84FU023.md): Motorized Gliders Tierra · Bullhead City, AZ · Accident · Serious injuries · Final report · Dec 3, 1983 · UNREG · Substantial damage > According to the plt, he had no previous flt time in ultralight acft. Before taking off, he taxied the ultralight several times to get the feel of the vehicle. During departure, the plt took off from a taxi strip west of rwy 17. The strip was used by… - [NTSB SEA84LA025](https://openairdocs.org/ntsb/SEA84LA025.md): Bell 206-BIII · Kooskia, ID · Accident · No injuries · Limited investigation · Final report · Dec 2, 1983 · N49584 · Substantial damage > The helicopter landed hard and rolled over to the right. The events started when the pilot heard the end of a seat belt banging against the outside of the acft where it had been caught in the door. The pilot decided to land and secure the belt. During landing… - [NTSB LAX84LA086](https://openairdocs.org/ntsb/LAX84LA086.md): Cessna 152 · Fairfield, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1983 · N48886 · Substantial damage > After taking off & while climbing thru about 100 to 300 ft, the eng lost power. During a forced landing, the acft impacted a fence & a berm, and went over railroad tracks, then came to rest inverted in a ditch. An exam of the acft revealed corrosion in the… - [NTSB LAX84LA085](https://openairdocs.org/ntsb/LAX84LA085.md): Aero Commander S2R · Firebaugh, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1983 · N8837Q · Substantial damage > The plt reported that he forgot to remove the aileron blocks before the flight. When he was taking off, the acft began to roll to the left. He was unable to control the bank attitude with rudder control, so he 'cut' the power. Seconds later the acft crash… - [NTSB ATL84LA060](https://openairdocs.org/ntsb/ATL84LA060.md): Cessna 150K · Georgetown, KY · Accident · No injuries · Limited investigation · Final report · Dec 1, 1983 · N6185G · Substantial damage > Earlier in the day, an annual inspection had been completed. There were no refueling facilities on the arpt, so the plt/mechanic drove to another location & purchased a can of gasoline (6 gals) which he added to the tanks. He then started the eng &… - [NTSB DEN84FA039](https://openairdocs.org/ntsb/DEN84FA039.md): Bellanca 17-31ATC · Moose, WY · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1983 · N107CB · Destroyed > The acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake… - [NTSB LAX84LA078](https://openairdocs.org/ntsb/LAX84LA078.md): Hughes 369D · Caliente, CA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1983 · N1112B · Destroyed > Reportly, the plt had instructed the ground crew to place the external cable\slings in the cargo area of the helicopter. However, they connected the cable to the external hook. The plt was not aware of this & took off. After takeoff, the cable hit the tail… - [NTSB ANC84LA019](https://openairdocs.org/ntsb/ANC84LA019.md): Taylorcraft BC-12D · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 27, 1983 · N95666 · Destroyed > The eng quit after takeoff. The plt was able to return to the arpt but landed on a Piper super cub. Water was found in the carburetor & main fuel tank. - [NTSB CHI84FA051](https://openairdocs.org/ntsb/CHI84FA051.md): Beech V35B · Cairo, IL · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1983 · N9002Q · Destroyed > The acft dove into the ground nose first from a 90 degree bank shortly after takeoff. The acft was observed by witnessesto take off slowly 'with about 1/2 power' being used. The climb was slow and at 300-400 ft the acft turned left with thelanding gear still… - [NTSB ATL84FA050](https://openairdocs.org/ntsb/ATL84FA050.md): Cessna 182Q · Baltimore, MD · Accident · Minor injuries · Field investigation · Final report · Nov 26, 1983 · N7473S · Substantial damage > The acft crashed shortly after takeoff when the engine lost power during initial climb. This acft had not been flown forabout one month. The pilot was aware of water accumulation in C-182 bladder equipped acft, so he drained the gascolator for an added length… - [NTSB FTW84FA074](https://openairdocs.org/ntsb/FTW84FA074.md): Piper PA-23 · Comfort, TX · Accident · 4 fatal · Field investigation · Final report · Nov 25, 1983 · N215EC · Destroyed > Witnesses stated that the acft barely cleared trees at the end of the arpt & that smoke was seen trailing from the righteng. The acft entered a right turn, stalled & impacted a ridge in a steep, near vertically banked dive. Teardowns of both engs & both props… - [NTSB MIA84LA034](https://openairdocs.org/ntsb/MIA84LA034.md): Cessna 402 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 23, 1983 · N24097 · Substantial damage > The plt in command related that he had no experience in the Cessna 402 acft. He reported that while on a local test flt with the second plt, who was experienced flying the acft, the right eng malfunctioned. The co-plt climbed the acft to 500 ft AGL and the… - [NTSB ATL84FIA01](https://openairdocs.org/ntsb/ATL84FIA01.md): Cessna 150K · Newburg, MD · Accident · No injuries · Final report · Nov 23, 1983 · N6385G · Substantial damage > The plt reported that during takeoff at aprx 200 ft AGL, the eng began to sputter & run rough. He elected to make a 180 deg turn in an attempt to reach a clear area. However, the acft struck a tree & impacted in a wooded area. Reportedly, the acft had been… - [NTSB NYC84LA044](https://openairdocs.org/ntsb/NYC84LA044.md): Cessna 177 · Bayport, NY · Accident · No injuries · Limited investigation · Final report · Nov 19, 1983 · N692MA · Substantial damage > The acft dragged a wing tip after encountered a gusty crosswind and aborted his takeoff. According to the plt, as the acft became airborne it seemed to be pushed down and he initiated a landing. The takeoff was aborted by reducing power and the acft touched… - [NTSB LAX84LA066](https://openairdocs.org/ntsb/LAX84LA066.md): Piper PA-32R-301T · Peach Springs, AZ · Accident · No injuries · Limited investigation · Final report · Nov 19, 1983 · N8178W · Substantial damage > Reportedly, the wind was variable & gusty when the acft took off from the hualapai arpt, Peach Springs, AZ. The plt reported that after rotating for takeoff, the acft moved laterally to the left, and as he was correcting for the movement, the left main gear… - [NTSB SEA84LA022](https://openairdocs.org/ntsb/SEA84LA022.md): Cessna 150K · Oregon City, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 18, 1983 · N6054G · Substantial damage > The plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The… - [NTSB CHI84LA047](https://openairdocs.org/ntsb/CHI84LA047.md): Piper PA-24-260 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Nov 18, 1983 · N8921P · Substantial damage > The plt stated that during the preflt, he visually checked the fuel & estemated that the left tank was aprx 1/4 full & the right tank was about 1/2 full. He made his pretakeoff checks, but stayed on the ground longer than normal to allow the oil to warm up.… - [NTSB NYC84LA043](https://openairdocs.org/ntsb/NYC84LA043.md): Gulfstream American AA-5B · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Nov 16, 1983 · N28271 · Substantial damage > Earlier in the evening, the plt had taken off with 3 passengers on board. Shortly after takeoff, he advised the tower that the eng was not developing full power. He remained in the traffic pattern & landed, then taxied to the ramp. Later, the plt made a 2nd… - [NTSB SEA84LA021](https://openairdocs.org/ntsb/SEA84LA021.md): Enstrom F28F · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1983 · N8622U · Substantial damage > The acft did a hard landing during autorotation after the engine ran rough and quit at 250 ft AGL during takeoff. The pilot had leaned the mixture, he said, prior to takeoff and he was not sure if he pushed the mixture to full rich when the engine started to… - [NTSB NYC84LA029](https://openairdocs.org/ntsb/NYC84LA029.md): Cessna 150 · Eliot, ME · Accident · No injuries · Limited investigation · Final report · Nov 14, 1983 · N704UG · Destroyed > The acft nosed over during a forced landing in soft earth after the engine quit during takeoff. This acft had been scheduled for a flt on 11/13 but due to water in the fuel it was not used. The acft fuel was drained and replaced and the acft was test flown.… - [NTSB FTW84FA058](https://openairdocs.org/ntsb/FTW84FA058.md): Bell 206L-1 · Houston, TX · Accident · No injuries · Field investigation · Final report · Nov 14, 1983 · N908S · Substantial damage > The acft lost power during the takeoff climb. During the forced autorotation landing the tail was severed by the main rotor. The engine was still running at 70 percent N-1. No discrepancies were noted in the engine during post-accident examination and run-up.… - [NTSB NYC84LA027](https://openairdocs.org/ntsb/NYC84LA027.md): Grumman AA-5A · Fitchburg, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1983 · N26445 · Substantial damage > The aircraft's engine lost power on takeoff and the pilot elected to make an emergency landing in a residental area. The pilot maneuvered the aircraft between two homes and crashed into a tree. The aircraft rolled to the left and fell tothe ground.… - [NTSB MIA84LA029](https://openairdocs.org/ntsb/MIA84LA029.md): Gary Wilson Quickie · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Nov 13, 1983 · N114GW · Destroyed > According to the plt, he had only 2 hrs flt time in quickie acft & this was his 1st flt in N114GW. He reported that after taking off, the acft tried to roll left. He used all available aileron to counteract the roll, but it was not effective. When impact was… - [NTSB FTW84LA051](https://openairdocs.org/ntsb/FTW84LA051.md): Bellanca 17-30 · Moore, OK · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1983 · N7337V · Substantial damage > The acft crashed during a forced landing after the engine quit. The acft had a prior forced landing and the fuel pump was suspect. Post accident investigation showed that only one safety pin was installed in the fuel selector shaft allowing excessive free… - [NTSB LAX84FU021](https://openairdocs.org/ntsb/LAX84FU021.md): Teman MONO-FLY · Congress, AZ · Accident · Serious injuries · Final report · Nov 10, 1983 · UNREG · Substantial damage > Reportedly, the plt was on his 1st flt in the ultralight vehicle after he had been taxiing it during the previous week. During takeoff from a ranch, the vehicle collided with the ground. According to the deputy sheriff, who responded to the scene, the plt… - [NTSB NYC84FA024](https://openairdocs.org/ntsb/NYC84FA024.md): Piper PA-23-250 · West Seneca, NY · Accident · 1 fatal · Field investigation · Final report · Nov 9, 1983 · N4708P · Destroyed > The acft was being repositioned by the owner from a maintenance facility at buffalo intl arpt to buffalo airpark. Maintenance personnel at both locations who had dealt with the owner indicated he had attempted to cut costs by performing unauthorized repairs… - [NTSB NYC84FA022](https://openairdocs.org/ntsb/NYC84FA022.md): Cessna 210L · Rhinebeck, NY · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1983 · N1177Q · Destroyed > The above reported basic wx data was the 2050 observation at poughkeepsie, NY located about 20 NM south of the accident site. However, a witness who was 1,000 ft north of the accident site stated the wx consisted of a low overcast & that the visibility was… - [NTSB DEN84LA022](https://openairdocs.org/ntsb/DEN84LA022.md): Beech V35B · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Nov 6, 1983 · N6TH · Substantial damage > The plt reported that immediately prior to rotation speed he saw a deer running towards the acft at a 90 deg collision angle. He 'hauled back' on the control wheel & the acft 'mushed off the ground.' The deer impacted the bottom of the fuselage & the wing… - [NTSB LAX84LA053](https://openairdocs.org/ntsb/LAX84LA053.md): Schreder HP-18 · New River, AZ · Accident · No injuries · Limited investigation · Final report · Nov 5, 1983 · N17DW · Substantial damage > The plt had just purchased the home built, single place, glider & was on his 1st tow. He reported that during takeoff, the glider became airborne prior to the tow plane, he felt a slight tug at the elevator control, had climbed too high behind the tow plane,… - [NTSB LAX84FA048](https://openairdocs.org/ntsb/LAX84FA048.md): Beech B35 · Long Beach, CA · Accident · No injuries · Field investigation · Final report · Nov 5, 1983 · N5254C · Destroyed > The plt reported that as he raised the landing gear during takeoff, the eng simultaneously lost power. He initiated an emergency landing on the remaining portion of the rwy. Acccording to him, the acft stalled while he was holding it in a nose high attitude &… - [NTSB LAX84FA046](https://openairdocs.org/ntsb/LAX84FA046.md): Piper PA38-112 · Corona, CA · Accident · No injuries · Field investigation · Final report · Nov 5, 1983 · N2556D · Substantial damage > The acft landing gear collapsed during an off rwy but on arpt forced landing. The pilot had just completed the annual inspection and was testing the acft. At 150 ft AGL during takeoff the engine quit. The plt landed on rough terrain ABOUT1/4 mile west of the… - [NTSB ATL84FA038](https://openairdocs.org/ntsb/ATL84FA038.md): Cessna T210M · Banner Elk, NC · Accident · 5 fatal · Field investigation · Final report · Nov 5, 1983 · N761VK · No damage > Before takeoff, the plt obtained wx for ashville & hickory, NC & for the tri-city arpt, all of which were 30 to 54 mi from Banner Elk, NC. At that time, he told the briefer that there were clouds at Banner Elk, but he thought he could get out all right. The… - [NTSB LAX84FA045](https://openairdocs.org/ntsb/LAX84FA045.md): Piper PA-32-260 · Riverside, CA · Accident · 2 fatal · Field investigation · Final report · Nov 4, 1983 · N15039 · Destroyed > Shortly after departure the plt radioed in that he had blown a rod 'or something' and was about two miles out on a right base leg. He then informed the tower that he was not going to make the runway after which the left wing contacted a power pole and the… - [NTSB CHI84LA036](https://openairdocs.org/ntsb/CHI84LA036.md): Jordan Acey Deucy · Chesaning, MI · Accident · No injuries · Limited investigation · Final report · Nov 3, 1983 · N597HJ · Substantial damage > This was the first flight of the homebuilt. Shortly after takeoff the eng quit due to inadequate grounding. The plt returned to the field & made a smooth landing. At the end of the roll out the anchor plate for the landing gear truss failed causing the left… - [NTSB DEN84LA020](https://openairdocs.org/ntsb/DEN84LA020.md): Cessna 150M · Hillsboro, ND · Accident · No injuries · Limited investigation · Final report · Nov 2, 1983 · N6141K · Destroyed > The student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the… - [NTSB FTW84FA038](https://openairdocs.org/ntsb/FTW84FA038.md): Douglas DC-3-3C · Laredo, TX · Accident · No injuries · Field investigation · Final report · Nov 1, 1983 · N44896 · Destroyed > The original flt was aborted due to a magneto problem. The defect was corrected, but due to the delayed takeoff, the plt elected to fly to mcallen, TX, for further repairs. During the takeoff roll, the aircrew noted sparks/flares on the left side of the… - [NTSB FTW84FU002](https://openairdocs.org/ntsb/FTW84FU002.md): Waspair Tomcat H.M. 81 · Ozark, AR · Accident · Serious injuries · Final report · Oct 30, 1983 · UNREG · Substantial damage > The plt was a paraplegic. He had previously purchased a Cessna 172 & had it modified for hand control. However, he had discontinued instruction in the plane when he was denied a medical waiver on the grounds that he had to take valium as a muscle relaxant.… - [NTSB SEA84FA013](https://openairdocs.org/ntsb/SEA84FA013.md): Cessna C-152-II · Belfair, WA · Accident · 2 fatal · Field investigation · Final report · Oct 29, 1983 · N94282 · Destroyed > The flight originated at aprx 2100 hrs. The pilot said his intention were to remain in the traffic pattern and practice touch and go landings. The aircraft crashed 1 mile south of the airport. - [NTSB MIA84LA021](https://openairdocs.org/ntsb/MIA84LA021.md): Champion 7HC · Ft. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Oct 29, 1983 · N8918R · 2 aircraft · Substantial damage > The plt of Champion 7HC, N8918R, stated that he taxied over a rough field to rwy 13. While crossing the field, something struck the bottom of the fusellage & broke the ailron bellcrank which connected the control stick to the aileron pushrods. Subsequently,… - [NTSB MIA84LA020](https://openairdocs.org/ntsb/MIA84LA020.md): Schweizer G-164B · Ormond Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1983 · N8459K · Destroyed > The acft is a twin-engine conversion of the Grumman G-164B. The plt was on a local test flt with the hopper filled with water to simulate flt conditions near the operating gross weight of the acft. After lift-off a partial power loss was experienced on the #2… - [NTSB DEN84LA018](https://openairdocs.org/ntsb/DEN84LA018.md): Piper J3C-65 · Parker, CO · Accident · No injuries · Limited investigation · Final report · Oct 27, 1983 · N29037 · Substantial damage > During the takeoff portion of a touch & go, the eng went to idle 15 ft AGL. The plt made a left turn & landed in a fieldcollapsing the landing gear. Investigation of the wreckage revealed that the carburetor was hanging in place by the throttle & mixture… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=199 ## 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=198 --- 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.