# 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 168 of 412 · 20,559 cases ## Cases, newest first - [NTSB MKC87FA138](https://openairdocs.org/ntsb/MKC87FA138.md): Aero Commander 500-B · Mason City, IA · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1987 · N9391R · Destroyed > The airplane was in a normal appearing climb after takeoff when it pitched up to a 70 to 80 degree attitude, stalled, dropped the right wing, then leveled the wings and hit the ground in a near-flat attitude. The weight and CG were within limits. No preimpact… - [NTSB MIA87LA206](https://openairdocs.org/ntsb/MIA87LA206.md): Piper PA-32R-300 · Hastings, FL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1987 · N4647F · Substantial damage > The plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in… - [NTSB DEN87LA180](https://openairdocs.org/ntsb/DEN87LA180.md): Cessna 172K · Tierra Amrilla, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1987 · N84704 · Substantial damage > No witnesses were found who had seen the accident. The man believed to be the plt gave the investigating police officer an assumed name. The wreckage dissappeared soon after the crash and has not been found to date. The acft attempted a takeoff with four… - [NTSB CHI87LA165](https://openairdocs.org/ntsb/CHI87LA165.md): Champion 7EC · Lake Monroe, IN · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1987 · N4365C · Substantial damage > The float equipped acft took off from Lake Monroe with 2 rated plts on board. The plt-in-command (PIC) stated that the takeoff distance may have been about 20% longer than normal. He said that after climbing about 200 to 250 ft, the coplt began a rgt turn,… - [NTSB CHI87LA164](https://openairdocs.org/ntsb/CHI87LA164.md): Piper PA-28-181 · Vincennes, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1987 · N8155A · Substantial damage > The pilot attempted to takeoff with the fuel tank selector selected to an empty tank. Shortly after lift-off the engine stopped and the acft skidded across a road and struck an embankment. - [NTSB LAX87DVG08](https://openairdocs.org/ntsb/LAX87DVG08.md): Budde Cassutt CB-1 · Winter, CA · Accident · Serious injuries · Final report · Jul 12, 1987 · N102 · Substantial damage > A homebuilt cassutt racer crashed during initial takeoff climb after a loss of power. The pilot assembled the experimental racing airplane in preparation for a flight to an air race and had completed a series of starts and run-ups. 'Everything checked normal'… - [NTSB CHI87FA162](https://openairdocs.org/ntsb/CHI87FA162.md): Cessna 180 · New Brighton, MN · Accident · 5 fatal · Field investigation · Final report · Jul 12, 1987 · N5027E · Destroyed > Witnesses observed the floatplane start a climbing left turn shortly after becoming airborne from a water takeoff. The aircraft's right wing dropped and the aircraft dove into the water where it struck the surface right wing first, flipped inverted and sank.… - [NTSB FTW87DRA06](https://openairdocs.org/ntsb/FTW87DRA06.md): Grumman G-164B · Beaumont, TX · Accident · No injuries · Final report · Jul 11, 1987 · N6881K · Substantial damage > Drg the initial climb after takeoff, the eng began losing RPM & the plt was unable to return to the arpt. He selected a pasture area for an emerg landing, but the eng contd losing power. While landing on soft terrain with tall wet grass, the acft nosed over.… - [NTSB MIA87FA203](https://openairdocs.org/ntsb/MIA87FA203.md): Rockwell 112A · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Jul 10, 1987 · N1440J · Destroyed > After take-off, the rt wing of the acft hit the ground about 1500 ft down the north-south rwy. The plt stated that the acft was rt wing heavy and opposite aileron had no effect. Surface winds at Vero Beach, about 8 miles east of the accident site were 090… - [NTSB FTW87LA169](https://openairdocs.org/ntsb/FTW87LA169.md): Maule M-4-210C · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jul 10, 1987 · N40684 · Substantial damage > The instructor plt (CFI) stated that drg the preflt, he & the student drained about 1 pint of water from the left wing tank & a small amount from the lower eng sump drain. No water was found in the rgt tank. The left tank was selected & a 12 to 15 min eng… - [NTSB CHI87DER12](https://openairdocs.org/ntsb/CHI87DER12.md): Taylorcraft F21A · Int'L Falls, MN · Accident · No injuries · Final report · Jul 10, 1987 · N2006L · Substantial damage > While on initial climb the aircraft encountered downdrafts and was unable to climb over high terrain and trees. When it became obvious to the pilot that he was not going to be able to climb over these obstacles, he closed the throttle and attempted to turn… - [NTSB FTW87LA163](https://openairdocs.org/ntsb/FTW87LA163.md): Piper PA-22-135 · Tulsa, OK · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1987 · N1175C · Substantial damage > Drg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr. - [NTSB ATL87DLT02](https://openairdocs.org/ntsb/ATL87DLT02.md): Gulfstream-Schweizer G164B-600 · Union City, TN · Accident · Minor injuries · Final report · Jul 8, 1987 · N8046K · Substantial damage > The ag-acft lost power while turning, shortly after departure from a field. During the subsequent forced ldg, the acft struck a fence and nosed over. The engine was torn from the acft during the impact sequence. Post-crash examination of the acft engine by an… - [NTSB FTW87DRG03](https://openairdocs.org/ntsb/FTW87DRG03.md): Wayne Hooks Cassutt III-M · Burnet, TX · Accident · Serious injuries · Final report · Jul 7, 1987 · N3790A · Minor damage > On July 7,1987, a cassutt 111M, N3790A, impacted the runway at kate craddock field (T-27) Burnet Texas. The pilot was conducting the initial test flight of the home built aircraft when the canopy came open. The pilot attempted to land the aircraft while… - [NTSB LAX87DUJ07](https://openairdocs.org/ntsb/LAX87DUJ07.md): Kiesel Midget Mustang · Window Rock, AZ · Accident · Minor injuries · Final report · Jul 5, 1987 · N68WK · Substantial damage > The aircraft lost power shortly after takeoff and collided with a dirt bank during the subsequent forced landing. Engineexamination revealed an open intake valve on the number 4 cylinder and the pilot stated a 'bent and cracked crankshaft from a prior… - [NTSB SEA87LA131](https://openairdocs.org/ntsb/SEA87LA131.md): Rockwell S-2R · Glenns Ferry, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1987 · N5580X · Destroyed > During takeoff with a quartering tailwind about 3/4 way down the runway the aircraft settled back onto the runway. There was not enough room to stop the aircraft. The aircrafts main gear caught on a fence and tall wheat with the aircraft coming to rest… - [NTSB FTW87FA161](https://openairdocs.org/ntsb/FTW87FA161.md): Piper PA-24-250 · El Paso, TX · Accident · Serious injuries · Field investigation · Final report · Jul 4, 1987 · N5777M · Destroyed > Escaping hot exhaust gas from the broken exhaust manifold melted the sealant from several areas of the firewall where hoses, wires, etc., pass through to the cocipit area. Heavy black smoke produced by smoldering wire insulation, fire shield material, etc.,… - [NTSB DEN87LA166](https://openairdocs.org/ntsb/DEN87LA166.md): Piper PA-18-150 · Las Vegas, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1987 · N9406P · Substantial damage > The plt reported that he experienced a departure stall after take off. A witness reported that the plt attempted a steep turn immediately after takeoff and that the acft appeared to stall. The left wing went down and the acft began an uncontrolled descent… - [NTSB NYC87LA195](https://openairdocs.org/ntsb/NYC87LA195.md): Aeronca 7AC · Jamestown, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1987 · N2460E · Substantial damage > The student plt rented the acft & flew to a field aprx 40 mi from the dep arpt. After landing, a passenger boarded the acft. The student started to takeoff again. Drg takeoff, the acft lifted off, but would not climb sufficiently to clear trees at the dep end… - [NTSB FTW87DRD09](https://openairdocs.org/ntsb/FTW87DRD09.md): Cessna T188C · Rayville, LA · Accident · No injuries · Final report · Jul 2, 1987 · N3239J · Destroyed > The aircraft had to take off eastbound due to obstructions at the west end of the strip. The six to eight knot wind was variable from a right crosswind to a slight tailwind. Investigation revealed the aircraft's weight exceeded that established by the… - [NTSB MIA87IA195](https://openairdocs.org/ntsb/MIA87IA195.md): Douglas DC3A · Hilliard, FL · Incident · No injuries · Incident investigation · Final report · Jun 30, 1987 · N31MS · Minor damage > According to the FAA the pilot stated that just after he rotated for takeoff the acft lost power in the left eng. He then aborted the takeoff, set the acft back on the runway & it slid off the left side into some bushes. The plts did not submit an operator… - [NTSB ANC87LA086](https://openairdocs.org/ntsb/ANC87LA086.md): Grumman G-44 · Wood River, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1987 · N176MS · Substantial damage > According to the pilot he was taking off and after initial climbout, approximately 50 feet above the water, the airplane stopped climbing. The engine sounded normal but the aircraft would not accelerate. The pilot stated that he stalled the aircraft on… - [NTSB NYC87LA193](https://openairdocs.org/ntsb/NYC87LA193.md): Piper PA-23-250 · Sandy Creek, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1987 · N4627P · Substantial damage > The pilot of the PA-23-250 attempted a takeoff on a 2200 ft long private airstrip with a grass runway. Witnesses reported the aircraft was airborne further down the runway than normal. The aircraft did not clear the trees on the departure end of the runway.… - [NTSB SEA87LA125](https://openairdocs.org/ntsb/SEA87LA125.md): Piper PA-32R-300 · Bend, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 1987 · N8713E · Destroyed > Shortly after takeoff a partial loss of power occurred and the pilot was not able to maintain altitude and airspeed. The pilot was not able to retract the gear due to the low airspeed because the automatic gear extension system was not in the override… - [NTSB NYC87LA143](https://openairdocs.org/ntsb/NYC87LA143.md): Cessna 172 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1987 · N79041 · Substantial damage > The plt rprtd that drg takeoff, the eng lost power. Subsequently, the acft crashed into an area of brush on level terrain about 1/2 mi off the departure end of the rwy. The operator rprtd that in a conversation with the plt, the plt indicated that he had… - [NTSB LAX87LA249](https://openairdocs.org/ntsb/LAX87LA249.md): Piper PA-28-161 · Auberry, CA · Accident · No injuries · Limited investigation · Final report · Jun 28, 1987 · N2856H · Substantial damage > During an approach into a private airstrip, the student pilot touched-down, then decided that there was not enough stopping distance and elected to go-around. On the initial climb-out the aircraft struck an object that made the aircraft yaw right then left.… - [NTSB ATL87DEI07](https://openairdocs.org/ntsb/ATL87DEI07.md): Eipper MX2 · Newbury, OH · Accident · Serious injuries · Final report · Jun 28, 1987 · N3924L · Substantial damage > The ultralight had not been flown for 8 months. Plt rpted that after takeoff the eng quit. Fuel had not been added since prior oct. Examination of eng revealed cracks in the exhaust system, evidence of overheating and recent scoring of cylinders. Witness… - [NTSB SEA87FA124](https://openairdocs.org/ntsb/SEA87FA124.md): Beech 77 · Spokane, WA · Accident · 2 fatal · Field investigation · Final report · Jun 27, 1987 · N37292 · Destroyed > On takeoff the aircraft climbed to 50-75 ft AGL, descended in a landing attitude, touched down on the runway near the departure end and took off again. When approaching high obstructions off the end of the runway, the aircraft entered a steep climb, rolled… - [NTSB FTW87LA153](https://openairdocs.org/ntsb/FTW87LA153.md): Grumman American AA-5A · Marietta, OK · Accident · No injuries · Limited investigation · Final report · Jun 27, 1987 · N9874U · Substantial damage > The plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell… - [NTSB FTW87DPA03](https://openairdocs.org/ntsb/FTW87DPA03.md): Rollins Starlite · Arlington, TX · Accident · 2 fatal · Final report · Jun 27, 1987 · N172SL · Destroyed > This was the first flight for the 156 hour private pilot in this make and model airplane, however, he had previously made several high speed taxi runs in it. According to witnesses, the pilot used only about half throttle for the attempted takeoff. The… - [NTSB ATL87LA193](https://openairdocs.org/ntsb/ATL87LA193.md): Bellanca 14-13-2 · Hamilton, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1987 · N74259 · Substantial damage > The plt rptd that he made a non-std rt-hand departure after t/o from rwy 29, to avoid traffic departing to the left. The acft began to sink as he attempted to climb over the lee side of a 200 ft-high ridge less than 1 mile northwest of the arpt. The acft… - [NTSB ATL87LA188](https://openairdocs.org/ntsb/ATL87LA188.md): Piper PA-28R-201T · Bowling Green, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1987 · N38344 · Destroyed > The instructor (CFI) rprtd he preflighted the acft & taxied to the refueling area. While there, he was apchd by another plt who wanted to go with him on this flt. They agreed & the CFI moved to the rgt seat. They commenced the start-up, run-up & takeoff… - [NTSB NYC87LA183](https://openairdocs.org/ntsb/NYC87LA183.md): Cessna 150J · Olcott, NY · Accident · No injuries · Limited investigation · Final report · Jun 24, 1987 · N51333 · Substantial damage > A student pilot practicing touch and go landings experienced an engine power loss on takeoff. During an approach to an open field for an emergency landing, the engine restarted. The pilot decided to return to the arpt. Upon entering downwind, the engine quit.… - [NTSB DEN87FA159](https://openairdocs.org/ntsb/DEN87FA159.md): Mooney M20A · Reserve, NM · Accident · 1 fatal · Field investigation · Final report · Jun 24, 1987 · N6060X · Destroyed > The plt was ferrying his acft from Reserve airport, NM, to jewitt mesa airport, apache creek, NM. There was a mature thunderstorm over the northern mountain ridge producing what one witness described as winds 'really blowing hard.' She said she saw the acft… - [NTSB SEA87LA122](https://openairdocs.org/ntsb/SEA87LA122.md): Cessna 150B · White City, OR · Accident · No injuries · Limited investigation · Final report · Jun 23, 1987 · N7352X · Substantial damage > After about one hour of flight and during a takeoff the engine ceased operating. The pilot attempted to land the aircraft onto the remaining runway but an overrun occurred. The aircraft rolled through a fence and then a ditch with the nose gear breaking off.… - [NTSB MKC87LA126](https://openairdocs.org/ntsb/MKC87LA126.md): Cessna 150L · Antioch, NE · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N1363Q · Substantial damage > The rwy was 1900 feet long with 5500 ft density altitude. With pilot and passenger and 30 degrees of flaps and calm wind, airplane lifted off, cleared fence and road. Pilot said he lowered the nose and raised flaps to 20 degrees but may have retracted them… - [NTSB FTW87LA150](https://openairdocs.org/ntsb/FTW87LA150.md): Cessna 150J · Chelsea, OK · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1987 · N51267 · Substantial damage > The non-rated plt attempted a downwind takeoff from a 1450' pvt grass strip. The strip was soft from recent rain & contained grass & weeds which were 6 to 7 inches hi. After taking off, the acft would not climb fast enough to clear obstacles. Subsequently, it… - [NTSB ATL87LA177](https://openairdocs.org/ntsb/ATL87LA177.md): Cessna 150M · Goldsboro, NC · Accident · No injuries · Limited investigation · Final report · Jun 21, 1987 · N704MW · Substantial damage > Student plt had dep apt for purpose of practicing ldgs. At about 400 ft he noted a pwr loss and rough running eng. He reduced the throttle setting and the roughness contd. Further reductions were made to the point where flight could not be maintained. The… - [NTSB MKC87LA117](https://openairdocs.org/ntsb/MKC87LA117.md): Cessna 150L · East Lynne, MO · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N17297 · Substantial damage > The PIC had been practicing t&g lndgs for the previous hour or so and decided to stop briefly to wait out rain showers in the area. After waiting the PIC fueled the acft with 10 gal of avn fuel and taxied to the active rwy to return to his originating arpt.… - [NTSB MIA87FA189](https://openairdocs.org/ntsb/MIA87FA189.md): Beech 23 · Miramar, FL · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1987 · N2387J · Destroyed > After the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a… - [NTSB MIA87FA188](https://openairdocs.org/ntsb/MIA87FA188.md): Cessna 172I · Ellisville, MS · Accident · 1 fatal · Field investigation · Final report · Jun 20, 1987 · N8446L · Substantial damage > Bfr the flt, the arpt owner adzd the plt not to fly, since he (the plt) appeared to be intoxicated. The plt 'said ok & left,' but returned aprx 1 hr later. A witness rprtd the plt atmtd to takeoff with full flaps. Drg the takeoff roll, theacft drifted off the… - [NTSB LAX87LA241](https://openairdocs.org/ntsb/LAX87LA241.md): Cessna TU206C · S. Lake Tahoe, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 1987 · N1177T · Substantial damage > Just after lift-off during a downwind departure the pilot decided that the acft was not climbing normally and aborted the take-off at mid-field. The pilot reduced power and extended 40 degrees of flaps. The pilot then decided that he would not be able to… - [NTSB DEN87LA157](https://openairdocs.org/ntsb/DEN87LA157.md): Hiller UH-12E · Ray, ND · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N68012 · Substantial damage > The plt reports that he was departing from an aerial app operating area. He said there was a tree line along a road with an opening and the takeoff was made toward the opening. There were wires across the opening and the poles were obscured by the trees on… - [NTSB DEN87LA156](https://openairdocs.org/ntsb/DEN87LA156.md): Talbott Avid Flyer · Palisade, CO · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N186TF · Substantial damage > The plt reported that he had just finished several short flights on the recently certified homebuilt acft to fly off the hr restriction. He had completed the shutdown checklist and had the fuel valve shut off. He restarted the eng without the checklist to… - [NTSB CHI87DEX07](https://openairdocs.org/ntsb/CHI87DEX07.md): Boeing E75 · Mccordsville, IN · Accident · Serious injuries · Final report · Jun 19, 1987 · N550LR · Destroyed > During initial climb the engine sustained a total power failure and the pilot attempted to return to the airport. The aircraft impacted in a soybean field approximately 200 feet short of the runway in a 20 degree nose down attitude. Investigation revealed the… - [NTSB MIA87FA187](https://openairdocs.org/ntsb/MIA87FA187.md): Mooney M20J · Merritt Island, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1987 · N5630K · Destroyed > According to witnesses, the plt performed a hasty preflt & an abbreviated run-up bfr taking off. After lift-off, the acft bgn a rgt turn, then rolled rapidly to the left & crossed over the extended rwy centerline twd a left downwind. Subsequently, it rolled… - [NTSB MIA87FA186](https://openairdocs.org/ntsb/MIA87FA186.md): Bellanca 8GCBC · Panama City, FL · Accident · 2 fatal · Field investigation · Final report · Jun 18, 1987 · N7620S · Destroyed > The purpose of the flt was to check out a new plt in banner towing operations. The first flt had been completed, the banner dropped & the second banner was engaged. Witnesses saw the acft make the steep climb after pick-up normally associated with banner… - [NTSB FTW87LA146](https://openairdocs.org/ntsb/FTW87LA146.md): Cessna 150F · Red Oak, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1987 · N7992F · Substantial damage > The pilot stated the aircraft did not appear to lift properly. It gained about 50 feet altitude after liftoff but then settled back to the ground. The departure runway was concrete and was 1200 feet in length. The field elevation was 650 feet MSL and the… - [NTSB FTW87FA151](https://openairdocs.org/ntsb/FTW87FA151.md): Cessna A188B · New Taiton, TX · Accident · Serious injuries · Field investigation · Final report · Jun 17, 1987 · N731XQ · Substantial damage > Acft was observed departing on rwy 35 of a 4,250' pvt ag strip after having been loaded to near capacity with 46% nitrogen fertilizer. Acft lifted off, crossed a fence parallel to the rwy and struck a fence that was perpendicular to the north end of the rwy.… - [NTSB DEN87LA158](https://openairdocs.org/ntsb/DEN87LA158.md): Cessna 170B · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Jun 16, 1987 · N2398D · Substantial damage > The plt landed to take pictures in Monument Valley off designated arpt. On takeoff the plt reported that the acft could not maintain sufficient altitude and that he had to make a forced landing. The plt did not report any mechanical failure or malfunction. Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=169 ## 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=168 --- 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.