# NTSB investigations: Maneuvering 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 186 of 378 · 18,851 cases ## Cases, newest first - [NTSB NYC88DGM03](https://openairdocs.org/ntsb/NYC88DGM03.md): Piper PA-28-161 · Spartansburg, PA · Accident · 1 fatal · Final report · Nov 14, 1987 · N8318L · Destroyed > The pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of… - [NTSB LAX88LA040](https://openairdocs.org/ntsb/LAX88LA040.md): Cessna 172B · Jamestown, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1987 · N7797X · Substantial damage > During a local sightseeing flight over a lake, the plt reported after circling for some time at a low altitude, the engine lost power. The plt made an emergency landing on the lake where the acft sank. Several days later, the acft was retrieved and the engine… - [NTSB DEN88DTE02](https://openairdocs.org/ntsb/DEN88DTE02.md): Boeing A75N1 · Keenesburg, CO · Accident · 1 fatal · Final report · Nov 10, 1987 · N65110 · Destroyed > The commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the… - [NTSB SEA88MA015](https://openairdocs.org/ntsb/SEA88MA015.md): Cessna 310N · Bellingham, WA · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1987 · N4178Q · Destroyed > The acft was chartered to take university (wwu) psnl to an alumni dinner. While rtrng at ngt, the plt made a localizer only, ILS rwy 16 apch in marginal VFR conds. Drg the apch, radar svc was terminated & the plt was told to ctc bellinghamradio, but he did… - [NTSB DEN88FA021](https://openairdocs.org/ntsb/DEN88FA021.md): Piper PA-28-181 · Durango, CO · Accident · 1 fatal · Field investigation · Final report · Nov 4, 1987 · N8266U · Destroyed > The two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the… - [NTSB LAX88FA032](https://openairdocs.org/ntsb/LAX88FA032.md): Robinson R22A · Moraga, CA · Accident · 2 fatal · Field investigation · Final report · Nov 3, 1987 · N8475A · Destroyed > A divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area. - [NTSB NYC88DHA01](https://openairdocs.org/ntsb/NYC88DHA01.md): Couden Skybolt · Mansfield, NJ · Accident · 2 fatal · Final report · Nov 1, 1987 · N341SB · Destroyed > Witnesses observed acft performing multiple aerobatic maneuvers. They said airplane was performing vertical maneuver or nearing top of loop when it entered an inverted flat spin. Rotation was stopped, but recovery incomplete when airplane crashed in a hay… - [NTSB LAX88LA030](https://openairdocs.org/ntsb/LAX88LA030.md): Piper PA-22-150 · San Jose, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 1987 · N4771A · Destroyed > While flying 500-600 feet above the terrain on a local pleasure flight, the pilot turned into what he believed to be an open ended canyon. After becoming aware that he had inadvertently turned into a box canyon, the pilot attempted a 'chandelle turn' to exit… - [NTSB LAX88FA065](https://openairdocs.org/ntsb/LAX88FA065.md): Britten-Norman BN2A-26 · Desert Center, CA · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1987 · N25MR · Destroyed > The plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he… - [NTSB DEN88LA017](https://openairdocs.org/ntsb/DEN88LA017.md): Piper J5A · Devils Lake, ND · Accident · No injuries · Limited investigation · Final report · Oct 31, 1987 · N32887 · Substantial damage > A commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the… - [NTSB CHI88FA012](https://openairdocs.org/ntsb/CHI88FA012.md): Bellanca 8KCAB · Lawrenceville, IL · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1987 · N41682 · Destroyed > While performing aerobatic maneuvers the aircraft entered a spin to the left and did not recover before impacting the ground. The acft entered the spin after the plt announced that this spin would be the last maneuver before landing. The spin was started at… - [NTSB MIA88FA023](https://openairdocs.org/ntsb/MIA88FA023.md): Cessna 150E · Aguadilla, PR · Accident · 2 fatal · Field investigation · Final report · Oct 30, 1987 · N4081U · Destroyed > Witnesses observed the acft maneuvering a low alt over ocean water near a shoreline. They saw it pull up sharply to clear a commercial boat dock, then nose over & impact the water in a nose low, rgt wing low attitude. The acft sank & came to rest in 30' of… - [NTSB LAX88LA025](https://openairdocs.org/ntsb/LAX88LA025.md): Mcdonnell Douglas 369D · Borrego Springs, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1987 · N47861 · Substantial damage > The pilot and three passengers were flying at low altitude over mountainous terrain looking for big horn sheep. Thirty minutes into the flight the pilot heard a loud noise and the tail yawed left. The pilot turned away from the mountain to look for a place to… - [NTSB FTW88DPJ02](https://openairdocs.org/ntsb/FTW88DPJ02.md): Piper PA-25 · Catoosa, OK · Accident · Serious injuries · Final report · Oct 26, 1987 · N9787P · Destroyed > The pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight. - [NTSB LAX88FA023](https://openairdocs.org/ntsb/LAX88FA023.md): Bellanca 7KCAB · Red Bluff, CA · Accident · 1 fatal · Field investigation · Final report · Oct 25, 1987 · N8645V · Destroyed > The pilot was asked to move his aircraft from a private airstrip on which he had landed without prior approval. As the aircraft climbed after takeoff the pilot made a left wingover, reversed course and buzzed the runway at an elevation of about 30 - 40 feet.… - [NTSB FTW88LA013](https://openairdocs.org/ntsb/FTW88LA013.md): Piper PA-12 · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Oct 25, 1987 · N4045M · Substantial damage > While circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage. - [NTSB SEA88FA011](https://openairdocs.org/ntsb/SEA88FA011.md): Cessna 180K · Walton, OR · Accident · 3 fatal · Field investigation · Final report · Oct 21, 1987 · N2754K · Destroyed > Witnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile… - [NTSB FTW88LA008](https://openairdocs.org/ntsb/FTW88LA008.md): Bell 47G-2 · Lapra, TX · Accident · No injuries · Limited investigation · Final report · Oct 20, 1987 · N8403E · Substantial damage > Upon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly… - [NTSB LAX88LA018](https://openairdocs.org/ntsb/LAX88LA018.md): Cessna 150L · Carpenteria, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1987 · N11176 · Destroyed > The pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses… - [NTSB FTW88DQG02](https://openairdocs.org/ntsb/FTW88DQG02.md): Air Tractor AT-301 · Lockney, TX · Accident · Serious injuries · Final report · Oct 19, 1987 · N73127 · Substantial damage > After completing a swath run, the plt began a procedure turn to the right for another run. During the maneuver, the acft stalled & turned counterclockwise for about 180 deg before impacting the ground in a nose down, left wing low attitude. - [NTSB ATL88LA017](https://openairdocs.org/ntsb/ATL88LA017.md): Piper J-3 · Clarks Hill, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1987 · N98806 · Substantial damage > The aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When… - [NTSB ANC88FA011](https://openairdocs.org/ntsb/ANC88FA011.md): Piper PA-18 · Homer, AK · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1987 · N4193Z · Substantial damage > The weather between Homer and anchorage included marginal conditions along segments of the route. The airline transport rated pilot was encouraged to take advantage of an offer to travel by automobile and still arrive in time for a commitment in anchorage. He… - [NTSB SEA88LA009](https://openairdocs.org/ntsb/SEA88LA009.md): Napper Vancraft · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N49694 · Destroyed > The experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to… - [NTSB MIA88FA008](https://openairdocs.org/ntsb/MIA88FA008.md): Extra Flugzeugbau 230 · Arcadia, FL · Accident · 1 fatal · Field investigation · Final report · Oct 17, 1987 · N230WF · Destroyed > The accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the… - [NTSB LAX88FA016](https://openairdocs.org/ntsb/LAX88FA016.md): Piper PA-28RT-201 · Buena Park, CA · Accident · 1 fatal · Field investigation · Final report · Oct 17, 1987 · N43551 · Destroyed > While depg on an IFR flt to VFR conds, the plt failed to provide the correct transponder code per ATC clnc. The local controller (ctlr) reminded him to set the correct code & the plt subsequently replied 'I'm having a problem right now... I've got to get… - [NTSB LAX88DXQ01](https://openairdocs.org/ntsb/LAX88DXQ01.md): Pugh LONG-EZ · Newell, CA · Accident · Serious injuries · Final report · Oct 17, 1987 · N38EZ · Destroyed > Before taking off, the plt noted that the wind sock was 'whipping & was about 3/4 full.' He said that after takeoff, he made a flyby at about 50' AGL, with an airspeed of about 150 mph. He then entered a steep climbing right turn. The plt estimated that at… - [NTSB LAX88FA015](https://openairdocs.org/ntsb/LAX88FA015.md): Dassault-Breguet DA 10 · Rancho Murieta, CA · Accident · 3 fatal · Field investigation · Final report · Oct 15, 1987 · N121FJ · Destroyed > In flight loss of control by the pilot flying while performing an intentional low level aerobatic maneuver. - [NTSB ATL88DKG01](https://openairdocs.org/ntsb/ATL88DKG01.md): Cessna 188 · Samson, AL · Accident · No injuries · Final report · Oct 15, 1987 · N731RF · Substantial damage > The plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter… - [NTSB ATL88LA012](https://openairdocs.org/ntsb/ATL88LA012.md): Cessna 150H · Scyrene, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1987 · N22553 · Substantial damage > The engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in… - [NTSB MKC88LA004](https://openairdocs.org/ntsb/MKC88LA004.md): Piper PA-28-140 · Storm Lake, IA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1987 · N4477X · Substantial damage > While practicing an approach to lndg stall, the stu plt stated that the eng failed to respond to throttle advancement. After unsuccessfully attempting emergency procs to include carb heat, fuel pump, and switching fuel tanks, he selected a fld. Prior to t/d,… - [NTSB ATL88DMG01](https://openairdocs.org/ntsb/ATL88DMG01.md): Rogers-Gibson 1 · Bennettsville, SC · Accident · 1 fatal · Final report · Oct 11, 1987 · N111MJ · Destroyed > The homebuilt aerobatic airplane impacted flat terrain adjacent to the rwy shortly after takeoff. A pilot/witness who was in the arpt terminal lobby at the time rptd that he briefly observed the airplane pass by the terminal at a low level in a near… - [NTSB BFO88FA002](https://openairdocs.org/ntsb/BFO88FA002.md): Cessna 172N · Lowmoor, VA · Accident · 1 fatal · Field investigation · Final report · Oct 9, 1987 · N3075E · Destroyed > The acft was involved in powerline patrol over mountainous terrain at low altitude. The plt made a climbing right turn to avoid a ridge and went into a valley where he was boxed in by two ridges. He unsuccessfully tried to outclimb one of the ridges before he… - [NTSB ATL88FA007](https://openairdocs.org/ntsb/ATL88FA007.md): Beech HA-1 · Memphis, TN · Accident · 1 fatal · Field investigation · Final report · Oct 9, 1987 · N9231 · Substantial damage > After t/o PIC was told by twr that tail stand, used to prevent acft from tipping on tail when loaded, was still attached to acft. PIC req teardrop turn back to departure rwy. Approach controller stated he saw mode c indication of 700'. A/p elev. Is 332'. Acft… - [NTSB SEA88LA003](https://openairdocs.org/ntsb/SEA88LA003.md): Piper PA-28-140 · Canby, OR · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1987 · N4112J · Destroyed > At a reduced power setting, while maneuvering, a loss of power occurred. An inadvertent stall was then entered. The student pilot is legally deaf, but the stall warning system incorporated a red stall warning light. After the stall occurred the aircraft… - [NTSB FTW88DRD01](https://openairdocs.org/ntsb/FTW88DRD01.md): Grumman G-164A · Port Allen, LA · Accident · No injuries · Final report · Oct 8, 1987 · N6743Q · Substantial damage > The pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped… - [NTSB MIA88LA014](https://openairdocs.org/ntsb/MIA88LA014.md): Hiller UH-12E · Union Church, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1987 · N4029R · Substantial damage > At an altitude of aprx 75 feet during an agricultural turn, the plt reported that the engine lost power. While executing a forced landing, the rotor blades contacted trees, after which, during the descent, the right skid collided with a stump & the helicopter… - [NTSB DEN88FA002](https://openairdocs.org/ntsb/DEN88FA002.md): Bellanca 7ECA · Fowler, CO · Accident · Serious injuries · Field investigation · Final report · Oct 5, 1987 · N8563V · Destroyed > During a pleasure flight the pilot flew too low over the Arkansas river, collided with powerlines and crashed into the river. The pilot stated he could not see well due to the setting sun in his eyes. The pilot and his passenger received serious injuries and… - [NTSB ATL88LA002](https://openairdocs.org/ntsb/ATL88LA002.md): Cessna 172F · Grand Bay, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1987 · N5647R · Substantial damage > The engine lost pwr shortly after t/o. the engine regained pwr as the plt was about to make a forced ldg in a field. He aborted the ldg attempt and attempted to make it back to the airstrip. The engine subsequently lost pwr again. The plt stretched his glide… - [NTSB DEN88FA001](https://openairdocs.org/ntsb/DEN88FA001.md): Piper PA-18-125 · Miles City, MT · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1987 · N1377A · Substantial damage > A cattle rancher was flying his aircraft looking for stray cattle and checking the condition of the ranch. He was at approximately 300 feet AGL when he spotted cattle that had strayed off the ranch. The pilot turned to get a better view of the cattle and flew… - [NTSB DEN88DQA01](https://openairdocs.org/ntsb/DEN88DQA01.md): Christen Industries Eagle II · Roswell, NM · Accident · 2 fatal · Final report · Oct 1, 1987 · N16RK · Destroyed > The plt and his plt rated pax departed Roswell at about 0900 MDT to practice maneuvers in the local area. The wreckage of the homebuilt acft was found in an open field about 1+20 after takeoff. There were no known witnesses to the accident. The inverted… - [NTSB DEN87LA247](https://openairdocs.org/ntsb/DEN87LA247.md): Bell 47G-3B1 · Grand Junction, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1987 · N7806S · Destroyed > The plt was practicing some helicopter maneuvers in preparation for taking an FAA flt examination. During one of his maneuvers the helicopter's main rotor blades struck the ground causing the acft to crash. A post accident fire errupted and destroyed the… - [NTSB MIA87LA262](https://openairdocs.org/ntsb/MIA87LA262.md): Boeing E75 · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1987 · N5190N · Substantial damage > The plt stated that the eng lost power & he was at low alt looking for an emerg ldg field when the wing hit a tree. The pax stated they were doing aerobatics at low alt & the eng quit. She stated that she was not wearing the required parachute & had asked the… - [NTSB SEA87LA195](https://openairdocs.org/ntsb/SEA87LA195.md): Beech 23 · Basin City, WA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N2330Q · Substantial damage > The pilot was making a low pass over the ground for a possible off airport landing next to his farm. During the low approach, he noticed power lines ahead and pushed forward on the controls to clear under them. However, there was a wrecked vehicle below the… - [NTSB ANC87LA167](https://openairdocs.org/ntsb/ANC87LA167.md): Piper PA-18 · Beluga Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N4471A · Substantial damage > The pilot stated that he was maneuvering 20 feet above the tree tops when a gust of wind made him lose directional control of the aircraft, causing the aircraft to strike the trees and hillside. - [NTSB ATL87LA266](https://openairdocs.org/ntsb/ATL87LA266.md): Cessna 172H · Chuckey, TN · Accident · No injuries · Limited investigation · Final report · Sep 25, 1987 · N3885R · Substantial damage > The plt estimated there was 9 gal of fuel on board when he took off. Aprx 20 min later, he was making a low pass over a private strip when the eng lost power. He stated that he repositioned the fuel selector to the other tank, but was unable to restart the… - [NTSB FTW87DPJ09](https://openairdocs.org/ntsb/FTW87DPJ09.md): G&C Helicopters EL Tomcat MK5A · Marlow, OK · Accident · Serious injuries · Final report · Sep 23, 1987 · N17315 · Substantial damage > Pilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn. - [NTSB LAX87DVA12](https://openairdocs.org/ntsb/LAX87DVA12.md): Grumman G164B · Buttonwillow, CA · Accident · No injuries · Final report · Sep 22, 1987 · N6607Q · Substantial damage > During an aerial application flight, after pulling out of a pass over a field the plt heard a loud bang followed by severe engine vibration. The acft lost power and the pilot made a forced landing in a plowed field. During the landing roll the acft nosed… - [NTSB CHI87FA219](https://openairdocs.org/ntsb/CHI87FA219.md): Beech H-18 · Rockford, IL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1987 · N5850S · Destroyed > The commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above… - [NTSB LAX87LA340](https://openairdocs.org/ntsb/LAX87LA340.md): Piper JC3-65 · Sacramento, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 1987 · N6187H · Substantial damage > The pilot was observed to be flying at a very low altitude by two separate witnesses. They stated that he was flying and maneuvering at approximately 15-20 feet AGL and buzzing powerlines. The pilot stated that he can not remember what happened and that the… - [NTSB LAX87FA341](https://openairdocs.org/ntsb/LAX87FA341.md): Bellanca 7ECA · Sonoma, CA · Accident · 1 fatal · Field investigation · Final report · Sep 20, 1987 · N8598V · Destroyed > The 70-hour student plt had recently passed the pvt plt written exam & had completed most of the flt trng for certification. He was looking forward to becoming a licensed plt. While on a personal flt, the plt flew over his brother's residence & was observed… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=187 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=186 --- 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.