# 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 205 of 412 · 20,559 cases ## Cases, newest first - [NTSB MIA83FA140](https://openairdocs.org/ntsb/MIA83FA140.md): Great Lakes 2T-1A-2 · Pembroke Pines, FL · Accident · 1 fatal · Field investigation · Final report · May 12, 1983 · N3667L · Destroyed > Witnesses reported that during takeoff, the eng began sputtering when the acft was climbing thru about 50 ft AGL, then the eng noise stopped completely as the acft reached about 150 ft AGL. A puff of smoke was observed coming from the eng as the acft veered… - [NTSB FTW83FA226](https://openairdocs.org/ntsb/FTW83FA226.md): Cessna 182R · New Braunfels, TX · Accident · 4 fatal · Field investigation · Final report · May 10, 1983 · N5134E · Destroyed > At 2006 CDT, before departing san antonio, TX, the plt obtained a wx breifing. At that time, he was advised to expect VFR conditions on his flt to san marcos, TX, but IFR conditions were expected when he planned to return at about midnight. The plt flew to… - [NTSB LAX83LA219](https://openairdocs.org/ntsb/LAX83LA219.md): Cessna 182P · Marysville, CA · Accident · Minor injuries · Limited investigation · Final report · May 9, 1983 · N21579 · Substantial damage > During the previous 7 mos, the acft had been flown only about 2.5 hrs & had been parked outdoors when not in use. Anticipating the flt, the student plt & her husband had started the engine to make sure the battery was operational. The instructor plt reported… - [NTSB DEN83LA110](https://openairdocs.org/ntsb/DEN83LA110.md): Cessna 172F · Escalante, UT · Accident · No injuries · Limited investigation · Final report · May 8, 1983 · N5501R · Substantial damage > The acft collided with the terrain and nosed over off the departure end of the runway during takeoff. The runway in use was 12 and the wind was from 180 degrees at 5 KTS gusting to 15 KTS. The runway is 5000 feet long and 60 feet wide. The field elevation is… - [NTSB MIA83LA138](https://openairdocs.org/ntsb/MIA83LA138.md): Enstrom F-28A · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · May 7, 1983 · N9086 · Destroyed > The acft rolled over and crashed during an attempted downwind running takeoff. The acft was destroyed by impact forces and fire. The pilot and 2 passengers were not injured. A witness on the ground and one of the passengers who is an A&P mechanic stated that… - [NTSB MIA83LA139](https://openairdocs.org/ntsb/MIA83LA139.md): Cessna 421C · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · May 6, 1983 · N3237U · Substantial damage > During takeoff, the aircrew heard an unusual 'thud' sound as the gear was retracting, but all gear indications were normal. Prior to landing at the destination, 3 green lights were observed when the landing gear switch was moved to extend the gear. A normal… - [NTSB FTW83LA225](https://openairdocs.org/ntsb/FTW83LA225.md): Cessna 210B · Socorro, NM · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N4796 · Substantial damage > Shortly after liftoff, at about 10 ft AGL & 95 mph in level flt, the plt found the controls 'ineffective.' The acft impacted at full power in a crab & bounced back into the air. The acft still would not climb & the plt lowered the nose to gain airspeed. The… - [NTSB CHI83LA198](https://openairdocs.org/ntsb/CHI83LA198.md): Piper PA-28-161 · Mount Vernon, IL · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N8210V · Substantial damage > After takeoff, the acft was climbing thru about 500 ft AGL when there was a considerable power loss. Subsequently, the acft struck trees while the plt was attempting to return to the rwy. An exam of the eng was made, but the reason for the power loss was not… - [NTSB SEA83FYM05](https://openairdocs.org/ntsb/SEA83FYM05.md): Brantly Helicopter B-2 · Milton Freewtr., OR · Accident · 1 fatal · Final report · May 4, 1983 · N5912X · Substantial damage > The helicopter was observed to climb to about 50-75 ft AGL & then something flew off the acft. One m/r blade was found intact 240 ft from the wreckage. The outer blade was heavily damaged at the tip area. The inboard blade section had the pylon tube attached… - [NTSB CHI83LA197](https://openairdocs.org/ntsb/CHI83LA197.md): Holmes XTC2 · River Falls, MN · Accident · Serious injuries · Limited investigation · Final report · May 4, 1983 · N3885D · Substantial damage > The acft pulled up steeply after takeoff and stalled. The acft crashed back on the rwy. The pilot said he reduced power after takeoff and the acft stalled. He also said if he had not reduced power the accident would not have happened. - [NTSB LAX83FA208](https://openairdocs.org/ntsb/LAX83FA208.md): Schempp-Hirth Nimbus II · California City, CA · Accident · 1 fatal · Field investigation · Final report · May 1, 1983 · N21RB · Destroyed > Witnesses reported that during takeoff, the glider was being towed when it released at aprx 300 ft AGL & entered a left turn. The turn continued, the bank angle increased & the glider subsequently hit the ground aprx 1 mile southwest of the arpt. Impact… - [NTSB MKC83LA101](https://openairdocs.org/ntsb/MKC83LA101.md): Cessna C-140 · Mt. Pleasant, IA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1983 · N77090 · Substantial damage > The pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,… - [NTSB LAX83FA205](https://openairdocs.org/ntsb/LAX83FA205.md): Beech A36 · Hawthorne, CA · Accident · Serious injuries · Field investigation · Final report · Apr 30, 1983 · N7036G · Substantial damage > As the acft was climbing thru about 400 to 500 ft AGL, after takeoff, the eng began losing power. The plt turned on the fuel boost pump & started a turn back toward the arpt. When he realized that he could not reach the rwy, he elected to land on a street.… - [NTSB SEA83FA093](https://openairdocs.org/ntsb/SEA83FA093.md): Beech 77 · Renton, WA · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1983 · N67140 · Destroyed > The acft was taking off for a 1 hour engine run-in following a top overhaul. After liftoff the engine began a gradual power loss and rough running. The pilot was trying turning back to the runway to land when total power loss occurred. The acft had turned 45… - [NTSB LAX83LA206](https://openairdocs.org/ntsb/LAX83LA206.md): Cessna 150C · Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1983 · N2062Z · Substantial damage > The plt was flying in & out of several crop duster strips. During takeoff from the 4th strip the engine quit. The acft nosed over in a plowed field. The plt attributed the engine failure to water in fuel. - [NTSB NYC83LA104](https://openairdocs.org/ntsb/NYC83LA104.md): Cessna 182 · Thomasville, PA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1983 · N21243 · Substantial damage > The acft nosed over during a forced landing after a power loss. Several weeks prior to this accident the acft made a precautionary landing due to a rough running engine. The acft was examined and 1 gallon of water was found in the fuel lines. The water was… - [NTSB NYC83FU003](https://openairdocs.org/ntsb/NYC83FU003.md): Ultralight Flight Phantom · Jaffrey, NH · Accident · Serious injuries · Final report · Apr 28, 1983 · UNREG · Substantial damage > Several days prior to the accident, the plt was advised by others that the eng on his newly assembled Ultralight did not'sound right.' After checking he noted that full power could not be obtained from the eng. However, enough power was available to fly a… - [NTSB MIA83FA133](https://openairdocs.org/ntsb/MIA83FA133.md): Beech D18S · Dania, FL · Accident · Serious injuries · Field investigation · Final report · Apr 28, 1983 · N213S · Destroyed > The acft crashed in a wooded area during a forced landing following a power loss on both of its engines. The acft had been flown to bimini from opa-locka, FL. About 75 gallons of fuel was drained from the acft. Upon the return to ft lauderdale, FL, the… - [NTSB MKC83FA094](https://openairdocs.org/ntsb/MKC83FA094.md): Cessna CE-500 · Witchita, KS · Accident · Minor injuries · Field investigation · Final report · Apr 26, 1983 · N22FM · Substantial damage > The acft collided with the ground during takeoff. The fuel tank in the right wing ruptured and the acft burned while sliding to a stop. The day before the accident the acft was washed and the thrust reverser doors were polished. After the service, the… - [NTSB CHI83LA189](https://openairdocs.org/ntsb/CHI83LA189.md): Stinson 108-2 · Greencastle, IN · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1983 · N9703K · Destroyed > The acft experienced power loss at about 300 feet AGL after takeoff. The pilot landed in a cornfield after attempting a restart of the engine. The pilot had put 5 gallons of fuel in the right tank on the day of the accident in preparation for a test flight.… - [NTSB LAX83LA204](https://openairdocs.org/ntsb/LAX83LA204.md): Varga 2150A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N8269J · Substantial damage > According to the plt, after gaining about 50-75 ft of altitude a strong vertical gust was encountered which increased the acft's pitch attitude to a critical angle whereupon the acft stalled. Recovery was incomplete & the acft impacted the taxiway north of… - [NTSB CHI83FA180](https://openairdocs.org/ntsb/CHI83FA180.md): Cessna 185F · Pillager, MN · Accident · 2 fatal · Field investigation · Final report · Apr 24, 1983 · N29968 · Destroyed > The acft collided with the ground after dragging the right wing in the water 3 times. The acft disappeared from view of witnesses around a point of land in the lake. The acft was heard producing power up to a 'few second' before a 'thud' was heard followed by… - [NTSB NYC83LA100](https://openairdocs.org/ntsb/NYC83LA100.md): Bellanca 8KCAB · Ashley Falls, MA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1983 · N86948 · Substantial damage > The pilot stated that he was about a half mile from the airport when the engine quit. He restarted it but it quit a 2nd time and would not restart. By this time the acft was down to about 200 ft. a right turn was made to land on an island. The acft landed… - [NTSB NYC83FGM02](https://openairdocs.org/ntsb/NYC83FGM02.md): Beech A-23 · West Mifflin, PA · Accident · Serious injuries · Final report · Apr 22, 1983 · N1411L · Substantial damage > The acft lost power during takeoff and a forced landing was made from 400 ft AGL to a slag dump about 1 mile south of the airport. The right wing was substantially damaged by the initial impact as the acft was turning right at touchdown. The nose gear… - [NTSB FTW83LA202](https://openairdocs.org/ntsb/FTW83LA202.md): Cessna 150M · Altus, OK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1983 · N63385 · Substantial damage > The acft collided with a barbed wire fence and a ditch during an aborted takeoff. The acft was pulled off the ground prematurely and when it failed to accelerate the CFI aborted the takeoff. During the rollout the acft went through a fence and into a ditch.… - [NTSB CHI83LA175](https://openairdocs.org/ntsb/CHI83LA175.md): Hughes 300C · Hollandale, MN · Accident · No injuries · Limited investigation · Final report · Apr 21, 1983 · N7418F · Destroyed > The pilot said 'that upon takeoff from truck, pulled too much power so he lost too much RPM, hit somewhat solid ground, slid 10 feet and stuck in the mud, the helicopter stopped immediately and flew apart.' - [NTSB CHI83LA174](https://openairdocs.org/ntsb/CHI83LA174.md): Piper PA-38-112 · Middleton, WI · Accident · No injuries · Limited investigation · Final report · Apr 21, 1983 · N2444N · Substantial damage > According to the instructor pilot the student did not release enough back pressure or use enough right rudder after the acft became airborne. The acft drifted left and was going to stall. The instructor took over and landed the acft. The left main gear came… - [NTSB ANC83LA073](https://openairdocs.org/ntsb/ANC83LA073.md): Cessna C-185F · Nome, AK · Accident · No injuries · Limited investigation · Final report · Apr 21, 1983 · N4757E · Substantial damage > The aircraft stalled at low altitude and crashed during takeoff. The pilot stated that 'during the takeoff roll the leftski stuck in the snow and turned the aircraft 45 degrees to the left. Instead of stopping, I continued on'. The pilot said that the ski had… - [NTSB ATL83LA164](https://openairdocs.org/ntsb/ATL83LA164.md): Cessna 172 · Clinton, MD · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1983 · N7617T · Substantial damage > Witnesses observed that the acft took off from rwy 31, began a left turn, then descend into the trees. One witness, a lineboy, stated that he heard the engine running until the acft contacted the trees. The plt received a head injury and was unable to recall… - [NTSB DEN83LA100](https://openairdocs.org/ntsb/DEN83LA100.md): Cessna 172N · Martinsdale, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1983 · N6322D · Destroyed > Reportedly, the instructor plt was on a personal/business flt with a student plt as a passenger. A landing was made on a road that had been used by crop duster plts. The plt had been informed about the presence of power lines. He saw some power lines & had… - [NTSB ANC83IA072](https://openairdocs.org/ntsb/ANC83IA072.md): Piper PA-28R-201 · Mcgrath, AK · Incident · No injuries · Incident investigation · Final report · Apr 19, 1983 · N38565 · Minor damage > After 3 attempts to takeoff from a muddy airstrip and failing, the pilot off-loaded one passenger and some baggage. On the fourth takeoff attempt the aircraft got airborne but settled back to a snow covered frozen river. The snow slowed the aircraft and the… - [NTSB MIA83LA126](https://openairdocs.org/ntsb/MIA83LA126.md): Beech H35 · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N8225D · Substantial damage > The plt stated that he switched fuel tanks just before the takeoff roll, & shortly after takeoff, the eng lost power. He retracted the gear before making a forced landing in water, beyond the end of the rwy. An exam of the eng revealed no evidence to suggest… - [NTSB ANC83FA070](https://openairdocs.org/ntsb/ANC83FA070.md): Piper PA-18 · Chugiak, AK · Accident · No injuries · Field investigation · Final report · Apr 17, 1983 · N1827A · Substantial damage > The acft collided with a tree during a forced landing and nosed over. The pilot reported that he made the takeoff with the fuel selector in the left tank position. Visual inspection of the left tank revealed no fuel in the tank except for residual fuel. Test… - [NTSB SEA83LA153](https://openairdocs.org/ntsb/SEA83LA153.md): Brantly Helicopter B2 · Rogue River, OR · Accident · No injuries · Limited investigation · Final report · Apr 16, 1983 · N5955X · Substantial damage > The helicopter rolled over during lift off with pilot and one passenger and a full load of fuel. On a previous flt with one passenger and 8 gallons of fuel the pilot had noticed the left skid was about 8 inches lower than the right during lift off. On the day… - [NTSB MIA83LA124](https://openairdocs.org/ntsb/MIA83LA124.md): Beech 76 · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1983 · N3711N · Substantial damage > The acft was landed with the gear retracted after a door opened during takeoff. The pilot stated that at about 100 feet AGL after the gear had been retracted the pilots door came open. According to the pilot the acft became erratic with thedoor banging… - [NTSB NYC83FFJ01](https://openairdocs.org/ntsb/NYC83FFJ01.md): Cessna A188B · Williamson, NY · Accident · No injuries · Final report · Apr 15, 1983 · N731VY · Substantial damage > The acft collided with a tree during a forced landing after a power loss on takeoff. The pilot had a load of 125 gallonsof a fungicide for spraying trees when the engine quit at about 100 ft AGL. The load was dumped and the acft was turned to the right for a… - [NTSB MKC83FA090](https://openairdocs.org/ntsb/MKC83FA090.md): Breezy 01 · Kechi, KS · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1983 · N1019W · Destroyed > The home built acft had been in storage with the wings removed. The wings had been recently re-installed by the owner and this was the first flight after the re-installation. During a takeoff from an open field, witnesses observed the aircraft lift-off, climb… - [NTSB LAX83LA466](https://openairdocs.org/ntsb/LAX83LA466.md): Cessna 188B · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1983 · N9961J · Substantial damage > The acft collided with a fence during takeoff and pulled the tailwheel out of the empennage. The plt said the dump valvefailed to work or 'struck' so he could not jettison the load. He felt the need to 'dump' when the acft hit a 'softspot' in the gravel and… - [NTSB NYC83LA095](https://openairdocs.org/ntsb/NYC83LA095.md): Cessna 150 · Norfolk, MA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1983 · N19435 · Substantial damage > The acft crash landed shortly after takeoff and was destroyed. The student pilot stated that after clearing the runway on his last takeoff of the day the engine hesitated and stopped. He lowered the nose to a glide speed of 70 mph picked aspot to land and… - [NTSB MIA83FA121](https://openairdocs.org/ntsb/MIA83FA121.md): Beech G18S · Hollywood, FL · Accident · Minor injuries · Field investigation · Final report · Apr 14, 1983 · N444PV · Destroyed > The plt stated that start, taxi & takeoff were normal until after he raised the gear handle & the acft was climbing thru aprx 150 to 200 ft AGL. At that time, he noticed that the left eng RPM was decaying. There was insufficient rwy remaining to abort, so he… - [NTSB LAX83FA192](https://openairdocs.org/ntsb/LAX83FA192.md): Cessna 182P · Auburn, CA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1983 · N333LK · Destroyed > Prior to this flt, the acft had not been flown for two months or refueled in five months. During that period, it had been exposed to unusually heavy amounts of rainfall. An annual inspection had been completed on 1/12/82 & 77 hrs had been flown since that… - [NTSB DEN83LA096](https://openairdocs.org/ntsb/DEN83LA096.md): Cessna 182P · Ashland, MT · Accident · No injuries · Limited investigation · Final report · Apr 14, 1983 · N9891E · Substantial damage > The acft lifted off early, stalled, dropped a wing and cartwheeled to a stop. The left main gear was sheared off in the impact. The pilot stated that during the takeoff from his own ranch airstrip a horse ran out on the rwy in front of the acft. He said there… - [NTSB NYC83LA094](https://openairdocs.org/ntsb/NYC83LA094.md): Piper PA-28RT-201 · West Chester, PA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1983 · N2943F · Substantial damage > The plt reported that during the takeoff roll, some oscillation in the controls for the nosewheel steering was noted. At about 45 KTS, he applied back pressure to lighten the load on the nosewheel as he had done in the past. He reported that since he was only… - [NTSB NYC83LA092](https://openairdocs.org/ntsb/NYC83LA092.md): Cessna 150 · Waynesburg, PA · Accident · Serious injuries · Limited investigation · Final report · Apr 12, 1983 · N99ML · Substantial damage > The pilot stated that following a normal takeoff, upon reaching an altitude of about 200 to 250 MSL, all eng power was lost. During an attempt to avoid trees at the end of the runway, for a clear area near a highway, the acft hit the top of a t-hangar. The… - [NTSB DEN83FA092](https://openairdocs.org/ntsb/DEN83FA092.md): Bell 206L-1 · Salt Lake City, UT · Accident · 1 fatal · Field investigation · Final report · Apr 11, 1983 · N1759D · Destroyed > The helicopter collided with the side of a mountain during a turn after departing from a hospital helipad while on an emergency medical flt to pick up a medical team to care for a critically ill child. The plt was notified at 0510 by his dispatcher. After… - [NTSB LAX83LA190](https://openairdocs.org/ntsb/LAX83LA190.md): Rolladen-Schneider LS-4 · La Jolla, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 10, 1983 · N3025R · Destroyed > The plt was qualified for solo winch launches in an SGS-1-26 glider. On his 1st winch launch using a c.g. hook in this glider, he allowed the acft to enter an abnormally high angle of attack, which was observed thru-out the takeoff process. The glide then… - [NTSB CHI83LA163](https://openairdocs.org/ntsb/CHI83LA163.md): Piper PA-28-140E · Lake, MI · Accident · No injuries · Limited investigation · Final report · Apr 10, 1983 · N4395T · Substantial damage > The pilot stated the wind shifted at about 50 ft AGL and the acft stopped climbing and mushed down and collided with a fence. - [NTSB NYC83LA089](https://openairdocs.org/ntsb/NYC83LA089.md): Piper J3C-85 · Spencer, MA · Accident · No injuries · Limited investigation · Final report · Apr 9, 1983 · N26182 · Substantial damage > The pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the… - [NTSB ATL83LA156](https://openairdocs.org/ntsb/ATL83LA156.md): Piper PA-22-150 · Liberty, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 1983 · N3918P · Destroyed > The acft collided with trees during takeoff climb and crashed to the ground in a nose low attitude. The 4 occupants received only minor injuries. This was the beginning of a 10 minute night flight in dark overcast conditions. The pilot lowered the acft nose… - [NTSB SEA83LA077](https://openairdocs.org/ntsb/SEA83LA077.md): Piper PA-23-150 · American Falls, ID · Accident · No injuries · Limited investigation · Final report · Apr 7, 1983 · N3172P · Substantial damage > The acft was damaged in an off airport forced landing due to water in the fuel. The acft took off and at 3OO feet the left engine quit. The pilot was attempting a left turn back to the airport when the right engine started to sputter. Thepilot landed straight… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=206 ## 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=205 --- 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.