# NTSB investigations: Approach 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 194 of 420 · 20,996 cases ## Cases, newest first - [NTSB LAX85LA236](https://openairdocs.org/ntsb/LAX85LA236.md): Fairchild SA226T · Livermore, CA · Accident · No injuries · Limited investigation · Final report · May 4, 1985 · N444LM · Destroyed > The acft landed hard and short of the runway. The impact collapsed the right main landing gear and the acft was destroyed by the post crash fire. The plt reported that on short final a muffled 'pop' was heard and the acft yawed to the right. Directional… - [NTSB LAX85FA239](https://openairdocs.org/ntsb/LAX85FA239.md): Earnst Skybolt · Paso Robles, CA · Accident · No injuries · Field investigation · Final report · May 4, 1985 · N10DE · 2 aircraft · Substantial damage > A Cessna 150 and a home built skybolt acft collided while on a downwind leg of a traffic pattern to land. The skybolt was a competitor in a local aerobatic competition east of the arpt. The C-150 was returning from a student plt training x-country flt. Both… - [NTSB SEA85LA101](https://openairdocs.org/ntsb/SEA85LA101.md): Piper PA-24-250 · Bandon, OR · Accident · Serious injuries · Limited investigation · Final report · May 3, 1985 · N5543 · Substantial damage > The plt was ferrying the acft to Bandon to have the landing gear repaired. The flt was made with the gear secured in the down position. The acft had locking fuel caps & the plt did not visually check the fuel level before taking off; instead, he relied of the… - [NTSB MIA85IA161](https://openairdocs.org/ntsb/MIA85IA161.md): Britten-Norman BN-2A-27 · Miami, FL · Incident · No injuries · Incident investigation · Final report · May 2, 1985 · N48VM · Minor damage > The acft had a total of 75 gals of fuel on board for the round trip from Miami to orlando & return. The plt stated that the flight normally required 3 flt hrs & fuel consumption was 25 gph. The acft was returning to Miami when both engs quit. The plt made a… - [NTSB LAX85LA234](https://openairdocs.org/ntsb/LAX85LA234.md): Cessna 182 · Parker, AZ · Accident · No injuries · Limited investigation · Final report · Apr 30, 1985 · N2444R · Substantial damage > The pilot stated that he encountered shifting winds on landing at his destination airport and that turbulence was severe. There is no record of a weather briefing prior to departure. - [NTSB LAX85FA232](https://openairdocs.org/ntsb/LAX85FA232.md): Aero Commander Callair A-9A · Fremont, CA · Accident · Serious injuries · Field investigation · Final report · Apr 30, 1985 · N7713V · Destroyed > The purpose of the local flight was to tow a glider aloft to a launch point. The pilot said he had no memory of the accident flight. Witnesses saw the aircraft make a go around form short final as a pedestrian walked across the runway approach end, and then… - [NTSB FTW85FA204](https://openairdocs.org/ntsb/FTW85FA204.md): Holder Midget Mustang I · Yukon, OK · Accident · 1 fatal · Field investigation · Final report · Apr 30, 1985 · N66H · Destroyed > The relatively low time pilot (99 total hours) had no recorded experience in high performance aircraft. He had just purchased the midget mustang and had practiced both low and high speed taxi runs on two occasions in the aircraft. He was observed to make one… - [NTSB NYC85LA113](https://openairdocs.org/ntsb/NYC85LA113.md): Cessna 182 · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1985 · N5685B · Substantial damage > The plt reported that he preflighted the acft & decided there was sufficient fuel to haul skydivers on 2 more flts. On the 2nd flt, he had to make three passes instead of one. During the apch to the arpt, the eng lost power from fuel exhaustion. The plt tried… - [NTSB MKC85LA092](https://openairdocs.org/ntsb/MKC85LA092.md): Cessna 172K · Kingman, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1985 · N79011 · Destroyed > During a landing attempt, the acft was high and fast and subsequently touched down long. The plt attempted a go around with 40 degrees of flaps. The acft stalled and contacted the terrain one fourth mile past the end of the rwy, right wing first. - [NTSB LAX85FA229](https://openairdocs.org/ntsb/LAX85FA229.md): Greer Sidewinder "S" · Tracy, CA · Accident · 2 fatal · Field investigation · Final report · Apr 28, 1985 · N9008X · Destroyed > The acft crashed short of rwy 25 at Tracy, CA, while on a night apch for landing. A ground witness observed the acfts lights descending straight down into a gravel pit. The acft impacted the ground in a 20 deg nose down, 15 deg left roll attitude. The rwy… - [NTSB DEN85FTM01](https://openairdocs.org/ntsb/DEN85FTM01.md): Gamble Sonerai II · Salt Lake City, UT · Accident · Minor injuries · Final report · Apr 28, 1985 · N922GG · Substantial damage > The acft nosed over during a forced landing short of the rwy following a loss of pwr. The plt stated that after takeoff he noticed a rise in the cylinder head temperature. He attempted a landing and overshot the rwy. During the plt's second landing attempt,… - [NTSB LAX85LA224](https://openairdocs.org/ntsb/LAX85LA224.md): Jack Boldt BD-5A · Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1985 · N831SP · Substantial damage > On base leg, the acft's honda eng lost power. Unable to glide to the arpt, the plt made an emergency landing on an underlying alfalfa field. During the landing, he stalled the acft & landed hard. No preimpact part failure or malfunction was found. - [NTSB CHI85LA177](https://openairdocs.org/ntsb/CHI85LA177.md): Cessna T210L · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N29134 · Substantial damage > After lowering the landing gear, the pilot heard a loud 'thump'. A gear down & locked indication was not obtained, however, the main gear appeared to be down to the pilot. Upon landing the acft swerved off the side of the runway. Only the right main gear was… - [NTSB LAX85LA221](https://openairdocs.org/ntsb/LAX85LA221.md): Cessna TU-206G · Pinon, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 1985 · N4877U · Substantial damage > At the conclusion of a cross country business flt, plt initiated a straight in approach after monitoring the wind conditions by observing a flag, which he reported as 'limp.' Plt reported that touchdown occurred at '50 knots' following a full flap approach at… - [NTSB BFO85LA040](https://openairdocs.org/ntsb/BFO85LA040.md): Beech E18S · Fishersville, VA · Accident · No injuries · Limited investigation · Final report · Apr 25, 1985 · N67A · Substantial damage > Weather conditions in charlottesville, Virginia, the intended destination, resulted in a missed approach and diversion to shenandoah valley airport, where two more missed approaches were executed. On the climb out from the second missed approach, the left… - [NTSB ANC85FA070](https://openairdocs.org/ntsb/ANC85FA070.md): Cessna 336 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Apr 25, 1985 · N1716Z · Substantial damage > Witness near the crash site stated that both aircraft engines were stopped prior to the accident. The plt reported that before taking off, the fuel quantity gages indicated there was sufficient fuel for the flight, the plt did not preflightthe aircraft.… - [NTSB MIA85FLD01](https://openairdocs.org/ntsb/MIA85FLD01.md): Cessna 172B · Brooksville, FL · Accident · Serious injuries · Final report · Apr 24, 1985 · N7846X · Substantial damage > According to a plt statement, he entered the traffic pattern at about 800 ft & held 70 mph with 10 deg of flaps & the carb heat on. After turning onto final apch, he advanced the throttle for a power adjustment, but the eng did not respond. Subsequently, the… - [NTSB ANC85LA071](https://openairdocs.org/ntsb/ANC85LA071.md): Cessna 180 · Willow, AK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N5206E · Substantial damage > The plt stated that the acft encountered a downdraft while he was on final apch for a touch-&-go landing. Subsequently, the acft touched down in wet snow about 30 yards short of the rwy & nosed over. The plt estimated the wind was from 010 deg at 5 KTS. - [NTSB NYC85FA110](https://openairdocs.org/ntsb/NYC85FA110.md): Cessna R182 · Hamilton Twnshp, NJ · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1985 · N4972S · Destroyed > The plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared… - [NTSB NYC85FA109](https://openairdocs.org/ntsb/NYC85FA109.md): Piper PA-28-140 · No. Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1985 · N95043 · Destroyed > On April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300… - [NTSB FTW85LA189](https://openairdocs.org/ntsb/FTW85LA189.md): Cessna A185F · Slidell, LA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N93485 · Substantial damage > The plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the… - [NTSB CHI85MA169](https://openairdocs.org/ntsb/CHI85MA169.md): Cessna 310R · St James, MI · Accident · 7 fatal · Major investigation · Final report · Apr 20, 1985 · N1334G · Destroyed > During a night arrival, the plt reported that he had the arpt in sight & canceled his IFR flt plan. A witness saw the lights of the acft as it circled the destination arpt. He reported the acft had turned left to a southerly heading, & shortly thereafter, he… - [NTSB CHI85LA168](https://openairdocs.org/ntsb/CHI85LA168.md): Wheat Pitts S-1-S · Marlette, MI · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N3FW · Substantial damage > 100 Yards from end of rwy on final apch plt lost rudder control. During landing roll as airspeed and aileron control effectiveness decreased the acft veered off the side of the rwy. The lower left wing contacted a VASI light. Inspection revealed right side… - [NTSB CHI85FEI02](https://openairdocs.org/ntsb/CHI85FEI02.md): Cessna 172F · Akron, OH · Accident · Serious injuries · Final report · Apr 20, 1985 · N5608R · Substantial damage > The acft contacted trees during a night forced landing following a loss of pwr. State patrol personnel reported there was no sign of fuel on board the acft at the accident site. The eng was test run after the accident, during which time it functioned normally. - [NTSB BFO85LA037](https://openairdocs.org/ntsb/BFO85LA037.md): Slingsby Type 43 Series 3F · Lovettsville, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1985 · N5563V · Substantial damage > The plt stated that he normally avoided landing on the rwy since the glider landed on a skid & it took a few minutes to remount it on a ground handling dolly. On this flt, he planned to land on the grass beside the apch end of the rwy. However, he allowed an… - [NTSB FTW85LA193](https://openairdocs.org/ntsb/FTW85LA193.md): Cessna 210L · Midland, TX · Accident · No injuries · Limited investigation · Final report · Apr 19, 1985 · N93V · Substantial damage > The plt estimated that the duration of flt would be about 5 to 5-1/2 hrs & that he had aprx 7 hrs of fuel on board. However, the acft encountered head winds during the flt, & as it was approaching the destination, the eng lost power after aprx 6 hrs of flt.… - [NTSB DEN85IA117](https://openairdocs.org/ntsb/DEN85IA117.md): Hiller UH-12E · Broomfield, CO · Incident · No injuries · Incident investigation · Final report · Apr 17, 1985 · N7411N · Minor damage > Pilot was taking FAA checkride for atp-rotocraft. Examiner requested autorotation demonstration with power recovery due to high gusty winds. Pilot said autorotation was normal until 75-100 ft AGL when rate of descent became excessive. Pilot said before he… - [NTSB ATL85LA137](https://openairdocs.org/ntsb/ATL85LA137.md): Cessna 172P · Southern Pines, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1985 · N52778 · Destroyed > The acft stalled during a practice go-around attempt at a private airstrip. The plt stated that he applied full throttel after descending to about 20 ft above the rwy during the practice go-around. He stated that he then tried to push the carb heat control… - [NTSB FTW85LA185](https://openairdocs.org/ntsb/FTW85LA185.md): Globe GC-1B · Liberty, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 1985 · N80577 · Substantial damage > The plt experienced an inflight partial loss of pwr after which he shut off the master switch, and the fuel valve and attempted to make a forced landing on a nearby arpt. However, there was insufficient alt to clear a powerline. A steep turn was made and the… - [NTSB NYC85LA095](https://openairdocs.org/ntsb/NYC85LA095.md): Let L-13 · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N90862 · Substantial damage > The plt reported that he turned onto final apch at about 500 ft AGL & the pattern was normal until he was about 1/3 mi from the rwy threshold. The glider then began to sink rapidly. The plt realized that he would be unable to glide to the rwy, so he decided… - [NTSB LAX85LA204](https://openairdocs.org/ntsb/LAX85LA204.md): Cessna 172 · Page, AZ · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N7245Q · Substantial damage > This was the return leg of a student plt solo x-country flt. On landing the acft stalled 15 ft above the rwy and the left wing contacted the rwy. The plt stated he was perhaps over confident in his flying ability. - [NTSB CHI85LA164](https://openairdocs.org/ntsb/CHI85LA164.md): Cessna 172P · Phillipsburg, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1985 · N55211 · Substantial damage > During a night VFR approach to a strange airport the acft struck power lines located one-half mile from the end of the rwy. The plt stated that she was unaware of the wires & was not aware that her acft had collided with them until her forward progress was… - [NTSB CHI85FA158](https://openairdocs.org/ntsb/CHI85FA158.md): Cessna T210N · Ravenna, OH · Accident · 1 fatal · Field investigation · Final report · Apr 11, 1985 · N9596Y · Destroyed > The plt departed port columbus uneventfully, flew for aprx 40 mins then shot a VOR apch to the mda at portage county. This fld does not have a wx reporting facility. The plt then performed a missed apch upon reaching mda. During the missed apch and after… - [NTSB NYC85FA104](https://openairdocs.org/ntsb/NYC85FA104.md): Piper PA-28-180 · East Haddam, CT · Accident · 1 fatal · Field investigation · Final report · Apr 10, 1985 · N55408 · Destroyed > During approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain.2 NM east of the runway. The rising terrain parallels runway 14. - [NTSB LAX85FA197](https://openairdocs.org/ntsb/LAX85FA197.md): Cessna 177 · Fallbrook, CA · Accident · Serious injuries · Field investigation · Final report · Apr 10, 1985 · N2907X · Destroyed > Although aware of existing IMC conditions and reduced lighting with the setting of the sun, the plt attempted a visual apch to his home arpt which did not have an approved apch. His remarks to mcclellen-palomar twr, regarding the use of the on-board loran… - [NTSB CHI85IA160](https://openairdocs.org/ntsb/CHI85IA160.md): Swearingen SA226TC · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Apr 10, 1985 · N163MA · No damage > On short final at an airspeed bet 120 and 125 KTS full flaps were lowered for landing. When the flaps reached the full down position, the stall warning horn came on and the stick pusher on the rosemont stall avoidance system activated. The captain disengaged… - [NTSB SEA85LA088](https://openairdocs.org/ntsb/SEA85LA088.md): Cessna 172M · Mulino, OR · Accident · No injuries · Limited investigation · Final report · Apr 8, 1985 · N80241 · Substantial damage > The plt pushed the throttle forward to add power during final approach and the engine ceased operating. A forced landing was made onto a cabbage patch and the nose gear sheared off. The acft then nosed over. Investigation revealed the throttle cable housing… - [NTSB CHI85LA155](https://openairdocs.org/ntsb/CHI85LA155.md): Piper PA-32RT-300T · Port Huron, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 1985 · N2135A · Substantial damage > After a practice instrument apch, the plt (PIC) entered the traffic pattern to land on rwy 23. While in the pattern, theair became very turbulent. UNICOM reported the wind was from 270 deg at 20 gusting 35 KTS. On final apch with the flaps fully extended, the… - [NTSB CHI85LA154](https://openairdocs.org/ntsb/CHI85LA154.md): Smelko Cvjetkovic CA-65 · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Apr 7, 1985 · N3280 · Substantial damage > A forced landing was made in an open soft field after a total loss of power occurred while on final apch. The acft nosed over during the landing. The plt attempted to transfer fuel from the rear fuel tank to the empty front tank but did not have sufficient… - [NTSB NYC85FA099](https://openairdocs.org/ntsb/NYC85FA099.md): Piper PA-31-310 · Nantucket, MA · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1985 · N68DD · Destroyed > Acft collided with trees during final approach to runway 24. No evidence of pre-impact failure or malfunction of the acft was found. Reported wx at crash site indefinite 100 feet sky obscured. RVR 2400 feet. Acft should have encountered a decreasing headwind… - [NTSB FTW85LA169](https://openairdocs.org/ntsb/FTW85LA169.md): Piper PA-28RT-201T · Matagorda Is., TX · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N3562X · Destroyed > The pilot executed a VFR go-around while on final approach due to livestock on the runway and reportedly experienced engine power loss. The aircraft made a forced landing on the beach and flipped inverted, coming to rest in the water alongside the beach. The… - [NTSB DEN85LA104](https://openairdocs.org/ntsb/DEN85LA104.md): Luscombe 8E · Casper, WY · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N2482K · Destroyed > Before reaching the destination, the acft encountered turbulence & the passenger became ill. The plt tried to land on the east-west rwy, but the x-wind was too strong, so he then entered a pattern for rwy 3. After turning into the wind for a landing, the acft… - [NTSB FTW85LA167](https://openairdocs.org/ntsb/FTW85LA167.md): Cessna 177 · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1985 · N52690 · Substantial damage > The aircraft's engine quit on downwind leg. Unable to glide to the rwy, a forced landing was performed on soft terrain off the apch end of the rwy. The left main gear collapsed in the soft terrain and the nose wheel broke off as the acft slid to a stop.… - [NTSB FTW85LA164](https://openairdocs.org/ntsb/FTW85LA164.md): Cessna 172M · Angola, LA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1985 · N73616 · Substantial damage > The acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this… - [NTSB FTW85FA159](https://openairdocs.org/ntsb/FTW85FA159.md): Cessna 152 · Bixby, OK · Accident · 1 fatal · Field investigation · Final report · Mar 23, 1985 · N757LV · Destroyed > A flt school student working on his instructor rating made several low and slow approaches to an open fld. Witnesses saw the acft's nose pitch up slightly then drop. The acft rolled to the right and impacted the terrain in a steep dive. A witness stated the… - [NTSB LAX85LA184](https://openairdocs.org/ntsb/LAX85LA184.md): Cessna 152 · Shafter, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1985 · N67001 · Substantial damage > The student plt was on his 1st supervised solo flt. He reported that on downwind, the acft was too hi, so he extended 10 deg of flaps. On base, he extended the flaps to 20 deg, & before turning onto final apch, he further extended them to 30 deg. The student… - [NTSB CHI85LA146](https://openairdocs.org/ntsb/CHI85LA146.md): Cessna 172L · Brighton, MI · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 1985 · N2839Q · Substantial damage > While attempting to execute a go-around with a 90 degree crosswind, velocity 16 kmph, gusting to 28 kmph, the acft apparently stalled just after becoming airborne. It impacted the ground about 300 feet west of the rwy. Witnesses stated that the acft appeared… - [NTSB NYC85FNE01](https://openairdocs.org/ntsb/NYC85FNE01.md): Marr/Eckburg Long EZE · Waterbury, CT · Accident · Serious injuries · Final report · Mar 19, 1985 · N49EZ · Substantial damage > The acft crashed into an embankment short of rwy 36 after a loss of pwr on final approach. The plt said he was operating on the rt tank when the eng quit. He immediately awitched to the left tank and activated the boost pump. The prop had stopped and the acft… - [NTSB FTW85LA155](https://openairdocs.org/ntsb/FTW85LA155.md): Cessna 177 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1985 · N2207Y · Substantial damage > Aprx 15 mins after departure, on final apch to Monroe regional arpt the eng lost pwr due to fuel exhaustion. During the forced landing the acft struck cable tv lines and trees causing a right yaw and uncontrolled descent to the ground. The student plt stated… - [NTSB LAX85IA175](https://openairdocs.org/ntsb/LAX85IA175.md): Piper PA-44-180 · San Jose, CA · Incident · No injuries · Incident investigation · Final report · Mar 16, 1985 · N2138G · 2 aircraft · No damage > A Piper seminule was vectored to the final apch course & cleared for an ILS apch at 3000FT MSL. A DC-9, in trail at 5000FT MSL, was overtaking the seminule. The controller elected to change their sequence & cleared the seminule to climb to 4000FT MSL due to… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=195 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=194 --- 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.