# 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 165 of 412 · 20,559 cases ## Cases, newest first - [NTSB ATL88LA038](https://openairdocs.org/ntsb/ATL88LA038.md): Cessna 172A · Dayton, OH · Accident · No injuries · Limited investigation · Final report · Nov 15, 1987 · N7623T · Substantial damage > The plt rptd that the engine began to sputter and lose power shortly after takeoff. A forced ldg was subsequently made in a nearby river. The acft nosed over on ldg and came to rest partially submerged in about 4 feet of water. Post-crash exam of the airplane… - [NTSB FTW88FA028](https://openairdocs.org/ntsb/FTW88FA028.md): Piper PA-28-180 · Lancaster, TX · Accident · 4 fatal · Field investigation · Final report · Nov 14, 1987 · N8980J · Destroyed > The pilot received a weather report indicating that IFR conditions prevailed. After takeoff the airplane traveled approximately 1/2 mile before it crashed. Pilot was not instrument rated and had very little total time. He did have three hours of night time… - [NTSB ATL88LA035](https://openairdocs.org/ntsb/ATL88LA035.md): Mooney M20A · Southport, NC · Accident · No injuries · Limited investigation · Final report · Nov 12, 1987 · N1051B · Substantial damage > The airplane lost engine pwr shortly after takeoff. A forced ldg was subsequently made in a nearby waterway. Post-crash exam of the airplane revealed that the fuel selector was in the left tank position, and that the left tank contained about 1/2 gallon of… - [NTSB FTW88IA025](https://openairdocs.org/ntsb/FTW88IA025.md): Piper PA-34-220T · El Paso, TX · Incident · No injuries · Incident investigation · Final report · Nov 8, 1987 · N83931 · Minor damage > The pilot stated that the nose baggage door was properly closed and locked before takeoff but it came open during the aircraft's initial climb at about 200 feet AGL. He made an immediate descent and landed on the remaining runway. He delayed the leveloff… - [NTSB NYC88LA035](https://openairdocs.org/ntsb/NYC88LA035.md): Cessna U206F · New Bedford, MA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1987 · N8384Q · Substantial damage > The Cessna U206F was taking off from a harbor. After becoming airborne it experienced a 40 knot airspeed loss. The plt stated that he was unable to maintain altitude and was forced to land on a beach. The acft flipped ovr after a pontoon caught a rock. A… - [NTSB FTW88DRG03](https://openairdocs.org/ntsb/FTW88DRG03.md): Herman Dragonfly · New Braunfels, TX · Accident · Minor injuries · Final report · Nov 6, 1987 · N5303H · Destroyed > The experimental, home built, aircraft was on its maiden fliht. The pilot stated he intended to fly the pattern for a check-out of the aircraft. The pilot indicated that he hoped to gain altitude early to permit returning to the field in case of an engine… - [NTSB NYC88LA030](https://openairdocs.org/ntsb/NYC88LA030.md): Cessna 172 · Norfolk, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1987 · N53461 · Substantial damage > The pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior… - [NTSB MIA88FA025](https://openairdocs.org/ntsb/MIA88FA025.md): Taylorcraft DC-65 · Davie, FL · Accident · Serious injuries · Field investigation · Final report · Nov 3, 1987 · N53736 · Substantial damage > Shortly after takeoff during the crosswind to downwind turn at an alt of aprx 50 ft, the acft stalled, spun to the left, & due to the low altitude the plt was unable to recover prior to impact in a left wing low nose down attitude. Postcrash examination of… - [NTSB DEN88LA020](https://openairdocs.org/ntsb/DEN88LA020.md): Piper PA-18-105 · Monte Vista, CO · Accident · No injuries · Limited investigation · Final report · Nov 3, 1987 · N5483H · Substantial damage > The plt attempted to take off on a frost-covered, pvt airstrip. Witnesses observed the aircraft become airborne before it settled back down to the ground. Control of the acft was lost and the acft nosed over. - [NTSB MIA88IA055](https://openairdocs.org/ntsb/MIA88IA055.md): Mcdonnell Douglas DC-9-82 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Nov 1, 1987 · N806NY · 2 aircraft · No damage > At 1710:53 EST, the LCL twr ctlr (lc) at the Newark intl arpt clrd Continental flt 321 (DC-9-82, N806NY) for takeoff on rwy 22L; 11 sec later, Continental flt 688 (Boeing 727, N577PE) rprtd 'left downwind for rwy 29.' Lc told flt 688 to 'maintain 1500 as you… - [NTSB LAX88DUM01](https://openairdocs.org/ntsb/LAX88DUM01.md): Durbin Monnett Moni · Ramona, CA · Accident · Serious injuries · Final report · Nov 1, 1987 · N190PJ · Destroyed > Acquaintances of the plt rprtd he had performed maintenance to repair an inoperative airspeed indicator. He then took off on a test flt. A witness, who was a plt, rprtd the eng started to 'cut out' at about 200 to 300 ft AGL, the tail 'waggled a couple of… - [NTSB ATL88LA027](https://openairdocs.org/ntsb/ATL88LA027.md): Aero Commander 100 · Moultrie, GA · Accident · No injuries · Limited investigation · Final report · Nov 1, 1987 · N3798X · Substantial damage > The plt took off to the north at the private, sod airstrip. He rptd that the acft began to 'drop' shortly after liftoff. He then attempted to arrest the descent by increasing the nose-up pitch angle, and the acft 'began to stall'. He aborted the takeoff and… - [NTSB ATL88FA025](https://openairdocs.org/ntsb/ATL88FA025.md): Mooney M-18C-55 · Camden, OH · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1987 · N4157 · Destroyed > The pilot took off downwind and did not use all of the available runway. With insufficient airspeed, the aircraft stalled shortly after takeoff. The pilot was unable to recover within the altitude remaining and collided with an oncoming train. - [NTSB NYC88LA025](https://openairdocs.org/ntsb/NYC88LA025.md): Cessna 150 · Millbrook, NY · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 1987 · N8362G · Substantial damage > The aircraft had just become airborne when power fluctuation occurred. On the second power loss, carburetor heat was applied but the engine lost power completely. The instructor pilot was making a turn back towards the airport when the wing contacted trees… - [NTSB CHI88LA009](https://openairdocs.org/ntsb/CHI88LA009.md): Cessna R182RG II · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 31, 1987 · N739JG · Substantial damage > After take-off, the pilot attempted to retract the landing gear when the hydraulic line on the right main gear actuator failed. The left main landing gear was stuck in the trailing position while the nose gear and right main gear remained down and locked. The… - [NTSB FTW88DRG02](https://openairdocs.org/ntsb/FTW88DRG02.md): Grumman Schweizer G-164A · Edcouch, TX · Accident · No injuries · Final report · Oct 30, 1987 · N45691 · Substantial damage > After a normal takeoff and climb to 200 feet AGL the pilot reduced power and the engine quit. A forced landing was made into a dry but soft plowed field. The aircraft rolled 300 feet and then nosed over into an inverted attitude and stopped. The engine was… - [NTSB ATL88LA024](https://openairdocs.org/ntsb/ATL88LA024.md): Cessna 337C · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1987 · N11GL · Substantial damage > PIC rpted rear eng quit after take-off. Fuel selector found on right main tank which was empty. Prop was not feathered and landing gear was found in transient position after crash. Owners manual cautions against higher drag with gear in transit due to large… - [NTSB FTW88LA015](https://openairdocs.org/ntsb/FTW88LA015.md): Beech 65 · Covington, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1987 · N504AC · Substantial damage > During initial climb from takeoff, the left engine failed for unknown reasons. The plt stated that right rudder and aileron inputs were ineffective to stop the acft from rolling left and the acft contacted the ground as he was retarding pwr on the right eng. - [NTSB FTW88LA014](https://openairdocs.org/ntsb/FTW88LA014.md): Piper PA-23-250 · Brownsville, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 1987 · N5606Y · Substantial damage > During initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and… - [NTSB DEN88LA015](https://openairdocs.org/ntsb/DEN88LA015.md): Piper PA-24-260C · Timberon, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 1987 · N9375P · Substantial damage > On takeoff with a 10 to 15 knot tailwind and 10 degrees of flaps, a 20 degree turn was attempted at 60 feet AGL. The pilot stated a downdraft forced the aircraft back to the ground. The aircraft struck a woodpile and several small trees. Post-crash fire… - [NTSB ATL88FA020](https://openairdocs.org/ntsb/ATL88FA020.md): Beech B24R · Louisville, KY · Accident · 3 fatal · Field investigation · Final report · Oct 24, 1987 · N6542R · Substantial damage > Drg tkof fm rwy 19, the plt transmitted 'we have a door open.' Twr psnl clrd him to lnd on any rwy, but he stated againthat a door was open. Again, twr psnl clrd him to lnd on any rwy. No otr radio calls were recd fm the acft. Svrl personssaw the acft at low… - [NTSB MKC88LA010](https://openairdocs.org/ntsb/MKC88LA010.md): Cessna 182 · Atwood, KS · Accident · No injuries · Limited investigation · Final report · Oct 20, 1987 · N2472Q · Substantial damage > The PIC said that he did an engine runup and allowed the engine to run about 6 additional minutes before commencing the takeoff. The PIC said that upon reaching 100 feet altitude in the takeoff sequence, he observed a decline in engine revolutions per minute… - [NTSB FTW88FA007](https://openairdocs.org/ntsb/FTW88FA007.md): Piper PA-32-260 · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Oct 16, 1987 · N3903W · Destroyed > The acft developed a fire in the eng area during the initial climb after takeoff. When the eng lost power the plt attempted a lndg in a small park. The acft touched down just short of a drainage ditch and collided with the sloping embankment on the opposite… - [NTSB ATL88DMG02](https://openairdocs.org/ntsb/ATL88DMG02.md): Questair 20 · Greensboro, NC · Accident · Minor injuries · Final report · Oct 14, 1987 · N62V · Substantial damage > Shortly after take-off, at about 500 ft AGL, the engine quit and the pilot attempted to return to the airport and land. The aircraft crashed and caught fire. The fuel system was found to have three fuel selectors installed. The main fuel selector, which… - [NTSB MKC88FA005](https://openairdocs.org/ntsb/MKC88FA005.md): Piper PA-32RT-300T · Lincoln, NE · Accident · 2 fatal · Field investigation · Final report · Oct 13, 1987 · N39922 · Destroyed > During climbout, smoke began filling the cabin and shortly thereafter the eng stopped. Ground witnesses observed smoke coming from the eng compartment just before the acft impacted a large woodpile behind a house located 1/2 mile east of the arpt. Examination… - [NTSB FTW88DRA01](https://openairdocs.org/ntsb/FTW88DRA01.md): Watkins/Monnett Moni · Silsbee, TX · Accident · Serious injuries · Final report · Oct 13, 1987 · N19MW · Substantial damage > Shortly after takeoff, the eng lost power & the plt tried to return to the arpt. However, as he was shutting off the fuel, the acft stalled & began to spin. He initiated corrective action, but the acft collided with trees before he could recover. An… - [NTSB NYC88FA005](https://openairdocs.org/ntsb/NYC88FA005.md): Cessna 150H · Gardner, MA · Accident · 2 fatal · Field investigation · Final report · Oct 12, 1987 · N50342 · Destroyed > While executing tough-and-go landings, the pilot neglected to partially raise the wing flaps, as recommended in the owners manual, before lifting off. Thereafter, the pilot failed to maintain a safe airspeed for the landing configuration and inadvertently… - [NTSB MIA88FA007](https://openairdocs.org/ntsb/MIA88FA007.md): Rockwell 700 · Pompano Beach, FL · Accident · 2 fatal · Field investigation · Final report · Oct 12, 1987 · N26574 · Destroyed > Witnesses stated that just after takeoff, the left engine started to leave a trail of white smoke, the acft then turned left back towards the arpt & crashed into the street. Post crash examination revealed one of the left engine crankshaft counterweights… - [NTSB MIA88FA006](https://openairdocs.org/ntsb/MIA88FA006.md): Robinson R-22-B · Plymouth, FL · Accident · 1 fatal · Field investigation · Final report · Oct 10, 1987 · N2276X · Destroyed > The private pilot, with an expired medical certificate and a license restricted to no carriage of passengers, took off and experienced an engine failure for undetermined causes. He did not execute an autorotation and the aircraft crashed. The pilot had also… - [NTSB LAX88LA008](https://openairdocs.org/ntsb/LAX88LA008.md): Maule M-5-210C · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N62008 · Substantial damage > During a pleasure flt, just after take-off, the acft was observed to climb out at an extremely high rate. The acft leveled off momentarily, and the left wing dropped. The acft began to descend and collided with the runway and two parked acft. - [NTSB ATL88LA006](https://openairdocs.org/ntsb/ATL88LA006.md): Beech H-18 · Sandersville, GA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N711LC · Substantial damage > The cockpit began to fill with smoke during initial climb after the plt raised the ldg gear. The plt returned to the arpt and made an emergency ldg. After evacuating the acft, the plt observed that the rt engine nacelle aft of the firewall was on fire.… - [NTSB MIA88FA005](https://openairdocs.org/ntsb/MIA88FA005.md): Cessna 421B · Deland, FL · Accident · 5 fatal · Field investigation · Final report · Oct 7, 1987 · N8043Q · Destroyed > The acft was observed to be flying slowly, then roll steeply to the left and dive into an unoccupied house from about 300 ft shortly after takeoff. The plt had considerable flt time but he had not flown this model, except for a 35 min checkout that morning.… - [NTSB LAX88LA007](https://openairdocs.org/ntsb/LAX88LA007.md): Piper PA-23-150 · Livermore, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1987 · N2077P · Substantial damage > The right engine ran rough during the initial climb phase of a personal flight. The pilot advised the tower controller of the aircrafts loss of power and entered the downwind leg of the traffic pattern for landing. The pilot stated that the aircraft was… - [NTSB FTW88DPJ01](https://openairdocs.org/ntsb/FTW88DPJ01.md): Ward Cassutt 3M · Yukon, OK · Accident · Serious injuries · Final report · Oct 7, 1987 · N3419W · Destroyed > During initial climb the engine failed and the pilot was unable to get a restart. The pilot, who was also the builder of the aircraft, was aware that in certain attitudes the engine would fail due to fuel starvation and that by changing the aircraft attitude… - [NTSB NYC88LA002](https://openairdocs.org/ntsb/NYC88LA002.md): Bellanca 17-30A · Newport, VT · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1987 · N39857 · Destroyed > Shortly after takeoff, the eng lost power as the acft was climbing thru about 75' AGL. Subsequently, the acft was damaged during an emerg landing. An exam revealed the acft had a very loosely fitting fuel cap & water was found in the fuel lines & sumps. The… - [NTSB MKC88LA002](https://openairdocs.org/ntsb/MKC88LA002.md): Cessna 150 · Hope, AR · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N8940S · Substantial damage > During tkof from a private 1500 foot airstrip the student plt stated that the acft would not climb and began to settle. He realized he was losing airspeed and did not have enough altitude to trade for airspeed so he chopped the throttle and made an emergency… - [NTSB CHI88IA003](https://openairdocs.org/ntsb/CHI88IA003.md): Mcdonnell Douglas DC-10-40 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Oct 5, 1987 · N157US · Minor damage > Aircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and… - [NTSB ANC88LA002](https://openairdocs.org/ntsb/ANC88LA002.md): Piper PA-18 · Wind River, AK · Accident · No injuries · Limited investigation · Final report · Oct 2, 1987 · N54763 · Substantial damage > The acft lost power during takeoff and the acft stall/mushed back to ground contact. The pilot stated that the partial power failure was due to carburetor icing. The examination of the aircraft engine revealed no mechanical failure or malfunction. - [NTSB FTW87LA228](https://openairdocs.org/ntsb/FTW87LA228.md): Piper PA-28-180 · Alvin, TX · Accident · No injuries · Limited investigation · Final report · Oct 1, 1987 · N4443T · Substantial damage > The plt initiated a soft field type takeoff with 10 deg of flaps. He said that he started the takeoff with 'full aft control wheel' until the acft became airborne, then he lowered the nose to remain in ground effect. However, he failed to maintain airspeed &… - [NTSB NYC87FA265](https://openairdocs.org/ntsb/NYC87FA265.md): Beech D95A · Pittstown, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 29, 1987 · N7955M · Destroyed > Pilot departed runway 26 at alexandria arpt toward trees in fog. Left wing hit trees. Acft landed hard collapsing landing gear. Acft hit a tree in area of pilot seat during lndg fatally injuring the plt. - [NTSB MKC87LA181](https://openairdocs.org/ntsb/MKC87LA181.md): Cessna 152 · El Dorado, KS · Accident · No injuries · Limited investigation · Final report · Sep 29, 1987 · N6156F · Substantial damage > After departing midfield and attaining approximately 100 feet of altitude, plt experienced a complete power failure. Plt attempted to reland on intersecting runway by executing an approximate 270 degree turn. Acft struck the terrain before completing the… - [NTSB FTW87FA225](https://openairdocs.org/ntsb/FTW87FA225.md): Piper PA-28-235 · Houston, TX · Accident · Serious injuries · Field investigation · Final report · Sep 27, 1987 · N9296W · Destroyed > Plt executed an emergency landing into trees after he experienced an inflight fire and eng failure shortly after t/o. the lndg in the trees was executed after the plt decided that he could not make it to a clear area. Investigation revealed that the fire had… - [NTSB FTW87DRG07](https://openairdocs.org/ntsb/FTW87DRG07.md): Nixon Quickie 1 · Del Rio, TX · Accident · Serious injuries · Final report · Sep 27, 1987 · N67SN · Destroyed > Earlier in the day, the plt had flown the home built acft on its maiden flt of 0.2 hrs with no rprtd problems. He stated that after taking off on the 2nd flt, he was climbing at aprx 200' AGL when the acft seemed to hit a gust of wind & roll left. He applied… - [NTSB MIA87FA260](https://openairdocs.org/ntsb/MIA87FA260.md): Beech B35 · Kissimmee, FL · Accident · 2 fatal · Field investigation · Final report · Sep 26, 1987 · N417 · Destroyed > The plt bgn taking off on a pvt 1800' grass strip which had trees nr the edges. Aprx 1575' fm the threshold, there was a parked acft nr the left side of the strip with its rgt wing protruding over the rwy area. While taking off with a rgt qtrg tail wind, the… - [NTSB SEA87MA192](https://openairdocs.org/ntsb/SEA87MA192.md): Fairchild SA227-AC · Twin Falls, ID · Accident · Serious injuries · Major investigation · Final report · Sep 25, 1987 · N2689E · Destroyed > Chk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to… - [NTSB MIA87FA259](https://openairdocs.org/ntsb/MIA87FA259.md): Beech D18S · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1987 · N76Q · Destroyed > Witnesses observed the aircraft taxi to the end of runway 27R and positioned so the tail was out in the overrun area. Witnesses further stated the aircraft appeared to take an overly long takeoff roll before lifting off. After lift off, the aircraft pitched… - [NTSB CHI87LA221](https://openairdocs.org/ntsb/CHI87LA221.md): Piper PA-28-181 · Troy, MI · Accident · No injuries · Limited investigation · Final report · Sep 25, 1987 · N7688F · Substantial damage > Drg the initial climb after takeoff, the eng lost power. Subsequently, the acft was dmgd drg a forced lndg west of the arpt. Drg an exam of the acft, 20 to 25 gal of avgas was fnd in the left fuel tank; however, the rgt tank had only residual fuel remaining.… - [NTSB ATL87LA261](https://openairdocs.org/ntsb/ATL87LA261.md): Cessna 150E · Winston Salem, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1987 · N2599J · Substantial damage > The stu plt discussed a cross country flt with his CFI, but did not get a sign off nor give a date for the flt. He then rented an acft and departed on the flt. During the flt, the com radio's became inop. The operator and the CFI were called from an enroute… - [NTSB MKC87LA177](https://openairdocs.org/ntsb/MKC87LA177.md): Beech A23A · Wentzville, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1987 · N6958Q · Substantial damage > The airplane became airborne after 1000 feet. A witness stated that after climbing to abt 10 feet, the right wing dropped almost to the ground. The acft then pulled up sharply to almost vertical and stalled at abt 75 feet above the ground and collided with a… - [NTSB FTW87FA223](https://openairdocs.org/ntsb/FTW87FA223.md): Piper J3C-65 · Greenwood, LA · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1987 · N3685K · Substantial damage > The pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=166 ## 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=165 --- 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.