# 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 169 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI87DCA01](https://openairdocs.org/ntsb/CHI87DCA01.md): Beech 3NM · Cahokia, IL · Accident · Minor injuries · Final report · Jun 16, 1987 · N37CB · Substantial damage > The acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation… - [NTSB ANC87LA079](https://openairdocs.org/ntsb/ANC87LA079.md): Piper PA-12 · Kvichak Bay, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 1987 · N92558 · Substantial damage > The pilot stated that during the takeoff the aircraft's engine lost power; the aircraft stalled and crashed on the gravel bar. The pilot also stated he did not know how much fuel was on board the aircraft and he did not remember the last time he fueled the… - [NTSB MIA87LA181](https://openairdocs.org/ntsb/MIA87LA181.md): Cessna 150H · St. Cloud, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1987 · N6647S · Destroyed > The plt stated that the engine ran good during the run up & on his takeoff roll the acft accelerated normally until he reached 45 knots, he looked down and noticed that the carburetor heat was on & he wasn't getting any more power. Realizing he was going to… - [NTSB FTW87LA143](https://openairdocs.org/ntsb/FTW87LA143.md): Cessna 172 · Cameron, TX · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N5079A · Substantial damage > During takeoff climb the aircraft struck a powerline then trees and impacted the ground. The aircraft was being flown bya student pilot with no medical certificate or solo endorsement. - [NTSB DEN87FA148](https://openairdocs.org/ntsb/DEN87FA148.md): Mooney M20K · Broomfield, CO · Accident · 2 fatal · Field investigation · Final report · Jun 14, 1987 · N4047H · Destroyed > Drg takeoff, the baggage door (bd) came open. Twr psnl advised the plt, but recd no discernible reply. At aprx 100' AGL,the acft pitched up & rolled left, then entered a steep dscnt & crashed aprx 500' left of the rwy. Except for the bd, nopreimpact mech… - [NTSB CHI87LA147](https://openairdocs.org/ntsb/CHI87LA147.md): Piper PA-28-180 · Anderson, IN · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N7306W · Destroyed > The plt rprtd that shortly after lift-off, the eng bgn 'hitting & missing.' He made a shallow left turn to avoid a house & land in a corn field. However, the acft stalled & the left wing struck the ground. An exam of the eng revealed that a screw (which held… - [NTSB MIA87LA179](https://openairdocs.org/ntsb/MIA87LA179.md): Cessna A188B · Senatobia, MS · Accident · No injuries · Limited investigation · Final report · Jun 10, 1987 · N4776R · Substantial damage > The plt stated that the acft was slow to climb after takeoff. He then dumped the load of chemical in an effort to clear trees. After clearing the trees the acft stalled and crashed into an open field. The plt also stated that there was no engine failure or… - [NTSB FTW87FA139](https://openairdocs.org/ntsb/FTW87FA139.md): Beech V35A · El Paso, TX · Accident · 2 fatal · Field investigation · Final report · Jun 10, 1987 · N39JB · Destroyed > Acft experienced a complete pwr loss shortly after takeoff and subsequently struck a house during the ensuing forced landing. No evidence of mechanical failure or malfunction was found during the investigation. Evidence did indicate that one tank was either… - [NTSB MKC87FA121](https://openairdocs.org/ntsb/MKC87FA121.md): Taylorcraft BL-65 · Hope, AR · Accident · Serious injuries · Field investigation · Final report · Jun 9, 1987 · N27424 · Substantial damage > The PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing… - [NTSB SEA87LA111](https://openairdocs.org/ntsb/SEA87LA111.md): de Havilland DHC-2 MK.1 · Sedro Woolley, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1987 · N64384 · Destroyed > Shortly after takeoff a loss of power occurred and the aircraft struck trees in flight. Less than 1/2 fuel was available in all three fuel tanks. The fuel selector valve was tested and found that the selections plate was indexed off center for all selections… - [NTSB MKC87LA122](https://openairdocs.org/ntsb/MKC87LA122.md): Cessna 140 · Ankeny, IA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1987 · N1990N · Substantial damage > While practicing take offs and landings, CFI and student experienced engine failure shortly after take off. An emergency landing was initiated, and during forced landing attempt the aircraft was substantially damaged. The CFI stated the engine quit due to… - [NTSB ANC87LA075](https://openairdocs.org/ntsb/ANC87LA075.md): Cessna 172N · Salcha, AK · Accident · No injuries · Limited investigation · Final report · Jun 8, 1987 · N733UP · Substantial damage > The pilot was indecisive during his attempted takeoff. He first elected to abort the effort, then changed his mind and added full power to continue the take off. The airplane rose a few feet off the river bar before stalling and crashing into the river. - [NTSB NYC87LA163](https://openairdocs.org/ntsb/NYC87LA163.md): Schweizer ASW-20 · Middletown, NY · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N98TX · Destroyed > The glider pilot failed to hook up the elevator control cable before launch and during takeoff there was no pitch control. The aircraft pitched up uncontrollably overstressing the rope. The rope broke and the glider impacted hard on a road bouncing 150 feet… - [NTSB NYC87LA161](https://openairdocs.org/ntsb/NYC87LA161.md): Piper PA-18 · Speculator, NY · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N8118 · Substantial damage > The plt had been practicing short water takeoffs with full flaps. After svcg the acft with a full load of fuel, he began a takeoff with 20 deg of flaps & got the float plane on the step. He rprtd that as he was applying full flaps, the acft enctrd a gust of… - [NTSB FTW87FA137](https://openairdocs.org/ntsb/FTW87FA137.md): Grumman AA-1B · Bulverde, TX · Accident · Serious injuries · Field investigation · Final report · Jun 6, 1987 · N1403R · Substantial damage > The plt attempted liftoff two or three times but after each try the acft would settle back onto the rwy. When about 50 yards from the end of the rwy, the acft again lifted off the ground and climbed to about 15 ft. the plt stated that the stall warning… - [NTSB LAX87DUG04](https://openairdocs.org/ntsb/LAX87DUG04.md): Gaston/Lakes Baby Lakes · Corona Airport, CA · Accident · Minor injuries · Final report · Jun 4, 1987 · N32G · Substantial damage > The aircraft engine power reduced during the initial climb phase of the takeoff. The pilot attempted to return to the runway of departure. The aircraft landed hard on the airport and nosed over on its back. - [NTSB DEN87LA144](https://openairdocs.org/ntsb/DEN87LA144.md): Cessna 188B · Malta, MT · Accident · No injuries · Limited investigation · Final report · Jun 4, 1987 · N417J · Destroyed > After takeoff on initial climb the acft had a pwr loss which resulted in a forced landing. A hard landing occurred in an open field which sheared off the main landing gear and damaged the airframe. The cause of the pwr loss could not be determined. - [NTSB LAX87LA223](https://openairdocs.org/ntsb/LAX87LA223.md): Cessna 152 · Oxnard, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1987 · N7320A · Destroyed > The pilot departed Oxnard arpt on a VFR flt to whitemant arpt, los angeles, CA. Grnd witness obsvd the airplane enter clouds and fog after crossing the western edge of the arpt boundary. The airplane was then obsvd in a descending left turn south of the arpt.… - [NTSB ATL87LA155](https://openairdocs.org/ntsb/ATL87LA155.md): Cessna 150H · Andalusia, AL · Accident · No injuries · Limited investigation · Final report · Jun 1, 1987 · N22553 · Substantial damage > The CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a… - [NTSB NYC87LA157](https://openairdocs.org/ntsb/NYC87LA157.md): Piper J-3 · Mercer, PA · Accident · No injuries · Limited investigation · Final report · May 31, 1987 · N38346 · Substantial damage > The flight departed from runway 27 uphill with the wind at 180 degrees in uncut grass. There were trees on the left side of the departure end of the runway. The plt stated that he lost lift as he approached the departure end of the runway. - [NTSB MIA87LA168](https://openairdocs.org/ntsb/MIA87LA168.md): Cessna 172P · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · May 31, 1987 · N63597 · Substantial damage > The plt selected 20 degrees of flaps for a short field takeoff. At aprx 75 ft AGL he raised them 10 degrees resulting in a nose high altiude. The acft then stalled and crashed uncontrolled in a nose low altitude causing the nose gear to collapse. The acft… - [NTSB MIA87LA167](https://openairdocs.org/ntsb/MIA87LA167.md): North American Navion · Defuniak Spring, FL · Accident · No injuries · Limited investigation · Final report · May 31, 1987 · N4007K · Substantial damage > The plt reported that after takeoff, at aprx 500 ft, the eng lost power. He then turned on the electric fuel pump in an attempt to restore it. Unable, he then elected to land the acft, during which, it collided with trees, fell to the ground & came to rest.… - [NTSB CHI87LA137](https://openairdocs.org/ntsb/CHI87LA137.md): Aircoupe A-2-DEX · Iola, WI · Accident · No injuries · Limited investigation · Final report · May 31, 1987 · N6509Q · Destroyed > The aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a… - [NTSB MKC87LA110](https://openairdocs.org/ntsb/MKC87LA110.md): Piper PA-22 · Carbondale, KS · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N5868D · Substantial damage > The PIC was moving his acft fm one airstrip to another in the LCL area. Wind cond's fm a nearby fss, recorded winds fm the southeast at 18 KTS, gusting to 25 KTS. The PIC rptd departing the sod airstrip to the southwest, and shortly aft establishing a climb,… - [NTSB DEN87LA133](https://openairdocs.org/ntsb/DEN87LA133.md): Piper PA-22-108 · Milbank, SD · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N5448Z · Substantial damage > The private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed… - [NTSB DCA87MA033](https://openairdocs.org/ntsb/DCA87MA033.md): British Aerospace 3101 · Kenner, LA · Accident · Serious injuries · Major investigation · Final report · May 26, 1987 · N331CY · Destroyed > The acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was… - [NTSB ATL87LA149](https://openairdocs.org/ntsb/ATL87LA149.md): Cessna 150M · Dahlonega, GA · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N704YK · Substantial damage > The acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight… - [NTSB FTW87DPA02](https://openairdocs.org/ntsb/FTW87DPA02.md): Moni Motor Glider · Terrell, TX · Accident · No injuries · Final report · May 23, 1987 · N59MA · Substantial damage > The pilot stated the cockpit canopy opened during initial climb at about 12 feet AGL and that this disrupted the air flow sufficiently that the aircraft became uncontrollable. The aircraft settled back onto the runway with a hard touchdown and then departed… - [NTSB FTW87LA126](https://openairdocs.org/ntsb/FTW87LA126.md): Piper PA-34-200T · Austin, TX · Accident · No injuries · Limited investigation · Final report · May 22, 1987 · N3980X · Substantial damage > The plt was unable to retract the landing gear after takeoff. The plt elected to return to the arpt and perform a precautionary landing. The touchdown was normal followed by the right main landing gear collapsing during the landing roll. The acft had… - [NTSB ATL87LA140](https://openairdocs.org/ntsb/ATL87LA140.md): Stinson 108-2 · Huntersville, NC · Accident · Serious injuries · Limited investigation · Final report · May 22, 1987 · N9796K · Substantial damage > The plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to… - [NTSB FTW87LA121](https://openairdocs.org/ntsb/FTW87LA121.md): Cessna A150L · Olla, LA · Accident · Serious injuries · Limited investigation · Final report · May 21, 1987 · N56QQ · Destroyed > Shortly after takeoff, witnesses observed the acft in a steep climb. Rprtdly, it then entered a left turn & appeared to stall. The plt stated that after about 180 deg of turn, he rolled out, nose low, leveled the wings, then a vibration started. Rprtdly, the… - [NTSB SEA87LA099](https://openairdocs.org/ntsb/SEA87LA099.md): Meyer 77-1 · Bellingham, WA · Accident · No injuries · Limited investigation · Final report · May 20, 1987 · N28LM · Substantial damage > A gusting 90 degree crosswind was present during the takeoff. A gust raised the aircrafts left wing and the pilot over-corrected with left aileron and left rudder. The aircraft then stalled, impacting the runway in a left wing down, nose low attitude. This… - [NTSB LAX87LA209](https://openairdocs.org/ntsb/LAX87LA209.md): Cessna 150M · Apple Valley, CA · Accident · Serious injuries · Limited investigation · Final report · May 18, 1987 · N9220U · Destroyed > The pilot lost control of the aircraft and entered an inadvertent spin during the initial climbout following a touch-and-go landing. The pilot reported a loss of power after climbing to 500 feet. Another pilot on the airport observed the aircraft in a very… - [NTSB ATL87DMG01](https://openairdocs.org/ntsb/ATL87DMG01.md): Grumman G-164B · Beaufort, NC · Accident · No injuries · Final report · May 18, 1987 · N3628Z · Destroyed > The plt had just loaded the hopper with dylox chemical. As the acft became airborne, the plt stated, he experienced wind shear and the acft rolled to the right. The plt corrected by leveling the wings and immediately experienced a second more violent wind… - [NTSB SEA87LA096](https://openairdocs.org/ntsb/SEA87LA096.md): Mooney M20F · Wagontire, OR · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N3523X · Substantial damage > During takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck… - [NTSB LAX87FA207](https://openairdocs.org/ntsb/LAX87FA207.md): Cessna 182L · Santa Monica, CA · Accident · Serious injuries · Field investigation · Final report · May 17, 1987 · N42814 · Destroyed > The acft lost power during initial climb and crashed on a residential street during an attempted forced landing. The throttle arm was found separated from the throttle shaft. The arm had been replaced 19 hours prior to the accident. Examination of the… - [NTSB DEN87LA126](https://openairdocs.org/ntsb/DEN87LA126.md): Mooney M20J · Englewood, CO · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N201MK · Substantial damage > The private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.… - [NTSB CHI87LA131](https://openairdocs.org/ntsb/CHI87LA131.md): Cessna 150J · Neillsville, WI · Accident · Minor injuries · Limited investigation · Final report · May 17, 1987 · N50499 · Destroyed > A student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &… - [NTSB BFO87LA038](https://openairdocs.org/ntsb/BFO87LA038.md): Cessna 150K · Selbyville, DE · Accident · Minor injuries · Limited investigation · Final report · May 16, 1987 · N5747G · Destroyed > During takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.… - [NTSB DEN87LA127](https://openairdocs.org/ntsb/DEN87LA127.md): Cessna A188B · Limon, CO · Accident · Minor injuries · Limited investigation · Final report · May 14, 1987 · N70164 · Substantial damage > The plt reports that he was using a dirt road for aerial app operations. The acft was loaded with 40 gals fuel and 140 gals chem and the density alt is EST to have been 8100 ft. the plt said the takeoff was made to the e with a quartering tailwind of about 15… - [NTSB NYC87FA146](https://openairdocs.org/ntsb/NYC87FA146.md): Piper PA-32-300 · Sayre, PA · Accident · 2 fatal · Field investigation · Final report · May 13, 1987 · N32774 · Destroyed > Drg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.… - [NTSB FTW87LA118](https://openairdocs.org/ntsb/FTW87LA118.md): Cessna 182 · Nowatta, OK · Accident · Minor injuries · Limited investigation · Final report · May 12, 1987 · N9845C · Substantial damage > During takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially… - [NTSB DCA87MA031](https://openairdocs.org/ntsb/DCA87MA031.md): Learjet 35A · West Mifflin, PA · Accident · 2 fatal · Major investigation · Final report · May 12, 1987 · N100EP · Destroyed > The coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &… - [NTSB BFO87LA036](https://openairdocs.org/ntsb/BFO87LA036.md): Beech C-24R · Chestertown, MD · Accident · No injuries · Limited investigation · Final report · May 12, 1987 · N18880 · Substantial damage > The pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to… - [NTSB NYC87LA144](https://openairdocs.org/ntsb/NYC87LA144.md): Mooney M20F · Caldwell, NJ · Accident · Minor injuries · Limited investigation · Final report · May 9, 1987 · N9374V · Destroyed > Drg a ngt takeoff, the eng lost pwr shortly after lift-off & the plt chose an area away from bldgs & obstructions for an emerg landing. However, drg the landing, the acft was extensively damaged. An exam revealed the rgt fuel tank was empty & the left tank… - [NTSB SEA87LA089](https://openairdocs.org/ntsb/SEA87LA089.md): Woehrle FLUT-R-BUG SA6B · Gleneden Beach, OR · Accident · 2 fatal · Limited investigation · Final report · May 8, 1987 · N3769G · Destroyed > Immediately after takeoff and while engaged in a tight climbing turn at low alt the pilot allowed the aircraft to enter a stall condition. Plt failed to recover before impacting the ground. - [NTSB NYC87LA142](https://openairdocs.org/ntsb/NYC87LA142.md): Pik 20 · Julian, PA · Accident · Serious injuries · Limited investigation · Final report · May 8, 1987 · CGPIK · Destroyed > The glider was assembled and all controls checked for freedom of movement prior to takeoff. During initial takeoff and climb, while in tow, the acft pitched nose up abruptly breaking the tow rope. The acft was then observed to turn right and nose down into… - [NTSB LAX87DVG07](https://openairdocs.org/ntsb/LAX87DVG07.md): Grumman G-164A · Lambertsville, CA · Accident · No injuries · Final report · May 8, 1987 · N4623 · Substantial damage > The pilot stated that shortly after takeoff the engine 'cut out' several times then quit completely. The pilot made an emergency landing on a plowed field and during the landing roll the aircraft nosed over. The accident was not reported for 4 days and during… - [NTSB ATL87LA134](https://openairdocs.org/ntsb/ATL87LA134.md): Piper PA-11 · Butler, AL · Accident · Minor injuries · Limited investigation · Final report · May 8, 1987 · N8024L · Substantial damage > The student plt reported that a gust of wind 'caught' the airplane's left wing shortly after takeoff at about 100 ft AGL; he subsequently 'lost control' and the airplane 'went down'. - [NTSB MIA87FA157](https://openairdocs.org/ntsb/MIA87FA157.md): Cessna 150M · San Juan, PR · Accident · Serious injuries · Field investigation · Final report · May 6, 1987 · N202CR · Destroyed > The plt stated that he performed his run up check with 'normal results.' Ten degrees of flaps were set for a soft field takeoff, & during the takeoff roll, 'the aircraft ran normal.' At aprx 55 mph 'the aircraft left the ground and immediately it settled down… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=170 ## 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=169 --- 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.