# 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 192 of 378 · 18,851 cases ## Cases, newest first - [NTSB NYC87FA101](https://openairdocs.org/ntsb/NYC87FA101.md): Piper PA-28-140 · Locke, NY · Accident · 1 fatal · Field investigation · Final report · Mar 5, 1987 · N6489R · Destroyed > The student pilot of the PA-140 was performing a solo x-country flight. He had made a fuel stop approx 20 mins prior to the crash. Witness observed an aircraft flying low and remarked that the engine sounded very loud just before crashing into an occupied… - [NTSB MKC87LA054](https://openairdocs.org/ntsb/MKC87LA054.md): Cessna 172 · Malden, MO · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1987 · N20362 · Substantial damage > The acft was being used on training flt when the eng failed. During the forced landing in a muddy field, the acft flipped forward to an inverted position. Post accident inspection revealed the eng failed due to a connecting rod bolt failure on the number two… - [NTSB FTW87LA071](https://openairdocs.org/ntsb/FTW87LA071.md): Cessna 150M · Porter, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1987 · N714KG · Substantial damage > According to the pilot, he was flying low over the san jacinto river, approximately 50 ft AGL. During a descending right turn the aircraft contacted a power line. The aircraft crashed into the river causing substantial damage to both wing spars and the… - [NTSB NYC87FA095](https://openairdocs.org/ntsb/NYC87FA095.md): Cessna 152C · Port Matilda, PA · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1987 · N757BQ · Destroyed > The university student departed the university air park airport in state college, PA on a local flight in VFR weather conditions. The aircraft nosed into the ground in an approximate 70 degree dive about 10 minutes after takeoff. The pilot was engaged in low… - [NTSB MKC87FA051](https://openairdocs.org/ntsb/MKC87FA051.md): Piper PA-18 · Venango, NE · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1987 · N9498D · Destroyed > A witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost… - [NTSB SEA87LA059](https://openairdocs.org/ntsb/SEA87LA059.md): Bell 206B-III · Dayton, WA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N90327 · Destroyed > Plt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control. - [NTSB LAX87DVG02](https://openairdocs.org/ntsb/LAX87DVG02.md): Piper PA-25-235 · Williams, CA · Accident · No injuries · Final report · Feb 15, 1987 · N7162Z · Substantial damage > During an aerial application flt, the plt was paralleling a canal when the right wing became entangled in weeds and contacted the canal. The acft began a right turn when the acft slowed and the left main landing gear contacted the terrain. The acft nosed… - [NTSB ANC87FA036](https://openairdocs.org/ntsb/ANC87FA036.md): Champion 7ECA · Hay Stack Mt., AK · Accident · Serious injuries · Field investigation · Final report · Feb 15, 1987 · N1883G · Substantial damage > The pilot-in-command was maneuvering at the 2200 foot level of haystack mountain. He stated he was turning into the mountain at a steep angel of bank. While he was turning the airplane struck the trees. No mechanical irregularities were found during the on… - [NTSB ATL87FA071](https://openairdocs.org/ntsb/ATL87FA071.md): Hughes 269A · Buford, GA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 1987 · N3782B · Destroyed > The helicopter was observed to slow down over the parking lot then continued out over the lake. A puff of smoke was observed around the rear of the engine area and the helicopter fishtailed as it almost came to a stop then dropped into the water nose first.… - [NTSB FTW87DPJ02](https://openairdocs.org/ntsb/FTW87DPJ02.md): Air Tractor AT-302 · Colony, OK · Accident · Serious injuries · Final report · Feb 11, 1987 · N8864S · Substantial damage > During a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the… - [NTSB CHI87FA070](https://openairdocs.org/ntsb/CHI87FA070.md): Mooney M20J · Waskish, MN · Accident · 3 fatal · Field investigation · Final report · Feb 8, 1987 · N11665 · Destroyed > During the preflight wx briefing the non-instrument rated pilot was advised that VFR flight was not recommended. Shortly before the accident, the acft was observed flying over a state highway under a low overcast in poor visibility. The acft was witnessed to… - [NTSB MKC87FA048](https://openairdocs.org/ntsb/MKC87FA048.md): Cessna A150K · West Memphis, AR · Accident · 1 fatal · Field investigation · Final report · Feb 7, 1987 · N8459M · Destroyed > The airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep… - [NTSB ANC87LA034](https://openairdocs.org/ntsb/ANC87LA034.md): Cessna 182 · Paxson, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1987 · N5312B · Substantial damage > The pvt plt took off at night and flew into instrument conditions. He had failed to unlock the direction gyro until the acft entered the clouds. The acft crashed 32 miles from the departure point due to fuel exhaustion. Automotive fuel was being used in the… - [NTSB ANC87IA032](https://openairdocs.org/ntsb/ANC87IA032.md): Piper PA-31-350 · Barter Island, AK · Incident · No injuries · Incident investigation · Final report · Feb 4, 1987 · N35232 · Minor damage > The pilot flew into rising terrain during a night VFR flight. After shutting down the right engine and achieving only partial propeller feather he elected to make a gear up landing. The plt was flying at 500 ft AGL when he wandered from over water to on-shore… - [NTSB LAX87LA106](https://openairdocs.org/ntsb/LAX87LA106.md): Cessna 170B · Plaster City, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 1987 · N3441C · Substantial damage > During a local business flight the pilot was flying low, approximately 50 ft AGL, and slow with 30 degrees of flaps extended to take aerial photographs of a motorcyclist on the ground. Upon completing a 360 degree turn to the left, the aircraft flew through… - [NTSB LAX87DJA04](https://openairdocs.org/ntsb/LAX87DJA04.md): Glaser-Dirks DG-400 · Dillingham, HI · Accident · 1 fatal · Final report · Feb 2, 1987 · N104MN · Destroyed > The aircraft was observed flying over a ridge at a 'good rate of airspeed'. It turned back towards the ridge and collided with the terrain. There was a SIGMET in effect for moderate to severe turbulence. Investigation revealed no preimpact mechanical… - [NTSB MKC87FA044](https://openairdocs.org/ntsb/MKC87FA044.md): Cessna 150D · Central City, NE · Accident · 2 fatal · Field investigation · Final report · Feb 1, 1987 · N4372U · Destroyed > At about 0305 CST, witnesses in vehicles saw the acft lndg lgt as they were driving along a hwy. they rprtd the lgt was moving erratically as the acft was proceeding along the hwy at low alt. Subsequently, the acft struck a utility pole & power lines, then… - [NTSB LAX87FA103](https://openairdocs.org/ntsb/LAX87FA103.md): Piper PA-28-181 · Gualala, CA · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1987 · N75178 · Destroyed > The student plt, flying his own acft, took off under VFR conditions for an intended 45 min solo cross country flt. The plt encountered deteriorating wx & attempted to return to the departure airport. A witness observed the aircraft enter clouds, turn left &… - [NTSB LAX87LA105](https://openairdocs.org/ntsb/LAX87LA105.md): Sikorsky S-58B · Los Angeles, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 1987 · N5594C · Substantial damage > A Sikorsky S-58B collided with a marked 253 ft AGL antenna tower (twr) while maneuvering over external load lift site. The plt indicated that he was sitting in the right seat of the acft in a right descending orbit conducting a site recon and that he was… - [NTSB ANC87FA033](https://openairdocs.org/ntsb/ANC87FA033.md): Champion 7EC · Kenai, AK · Accident · No injuries · Field investigation · Final report · Jan 31, 1987 · N7539B · Substantial damage > The pilot allowed the wing tip to descend into brush and willows while turning to avoid obscured sky conditions. The turn was downwind and the airplane stalled and struck the snow while skidding sideways. - [NTSB NYC87LA069](https://openairdocs.org/ntsb/NYC87LA069.md): Hughes 269D · Antrim, NH · Accident · No injuries · Limited investigation · Final report · Jan 28, 1987 · N3624J · Substantial damage > During a practice hover, the pilot lost directional control and the helicopter pitched up at an angle of about 20-25 degrees causing the tail rotor to contact the snow. The aircraft was substantially damaged, but there were no injuries. The CFI stated that… - [NTSB LAX87FA101](https://openairdocs.org/ntsb/LAX87FA101.md): Mooney M20E · Dunsmuir, CA · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1987 · N79366 · Destroyed > During a pleasure flight, the airplane was seen flying low and disappeared into instrument meteorological conditions, consisting of low clouds, gusty winds and snow which lasted throughout the day. The airplane was found on the side of a hill in a descending… - [NTSB SEA87LA048](https://openairdocs.org/ntsb/SEA87LA048.md): Michael D. Mansfield KR-2 · Fallon, NV · Accident · 2 fatal · Limited investigation · Final report · Jan 25, 1987 · N66996 · Destroyed > The owner and an acquaintance, both commerically rated pilots, departed Fallon, Nevada, on a personal flight to a nearby town. Witnesses reported observing the aircraft engaged in maneuvers described as steep turns and sharp dives a short distance from the… - [NTSB LAX87DJA03](https://openairdocs.org/ntsb/LAX87DJA03.md): Emroth Emair MA-1B · Naalehu, HI · Accident · Serious injuries · Final report · Jan 20, 1987 · N88896 · Destroyed > During an aerial application flight, the aircraft was observed to make a downwind run when the pilot dumped the load collided with the terrain, become airborne and eventually collided with trees. Witnesses stated that they heard the engine running and that it… - [NTSB DEN87FA043](https://openairdocs.org/ntsb/DEN87FA043.md): American Aerolights Falcon C · Albuquerque, NM · Accident · 1 fatal · Field investigation · Final report · Jan 18, 1987 · N918AA · Destroyed > After takeoff the plt initiated a steep nose up left climbing turn to approximately 300 ft AGL where the acft stalled. It entered a spin and descended in a nose down attitude until impact with the ground. The acft was destroyed and the student plt was fatally… - [NTSB NYC87DHD04](https://openairdocs.org/ntsb/NYC87DHD04.md): Marrone VM-1 · Jobstown, NJ · Accident · 1 fatal · Final report · Jan 17, 1987 · N4047A · Destroyed > The plt was observed to make a low pass over the arpt, then cont beyond the departure end where the acft flew into a row of trees. Witnesses rprtd the sun was low & that the plt was flying toward the sun. Impact with the trees occurred about 1200 ft from the… - [NTSB MIA87FA074](https://openairdocs.org/ntsb/MIA87FA074.md): Cessna 150L · Naranjito, PR · Accident · 2 fatal · Field investigation · Final report · Jan 16, 1987 · N10103 · Destroyed > The pilot and passenger were reported to be on a personal flight during their lunch hour. They departed from isla grande airport and proceeded to a dirt airstrip at Naranjito, PR. At Naranjito, witnesses saw the airplane go into a low pass over the dirt… - [NTSB LAX87FA096](https://openairdocs.org/ntsb/LAX87FA096.md): Morrisey 2150A · Mt. Baldy, CA · Accident · 2 fatal · Field investigation · Final report · Jan 16, 1987 · N5138V · Destroyed > During a local flt, the airplane was seen circling over a ridge four times. On the fifth pass, the airplane disappeared northbound into the clouds. A witness reported that at the time the mt tops were covered with fog and that blizzard conditions existed.… - [NTSB DCA87MA018](https://openairdocs.org/ntsb/DCA87MA018.md): Swearingen SA-226TC · Kearns, UT · Accident · 10 fatal · Class 1 · Major · Final report · Jan 15, 1987 · N163SW · 2 aircraft · Destroyed > The two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the… - [NTSB CHI87IA061](https://openairdocs.org/ntsb/CHI87IA061.md): Nihon YS-11A-500 · Remmington, IN · Incident · No injuries · Incident investigation · Final report · Jan 13, 1987 · N906TC · Minor damage > The flight crew failed to adhere to appropriate procedures and directives when they failed to select the HP cock levers to the hswl (lock out) position while performing an approach to landing stall during a training/test flight. When stall recovery was… - [NTSB NYC87DHD02](https://openairdocs.org/ntsb/NYC87DHD02.md): Cessna 170 · Pittman, NJ · Accident · Serious injuries · Final report · Jan 7, 1987 · N2528V · Destroyed > The pilot stated that approx 15 mins after takeoff, while in a left turn, both he and his pax heard a loud snap. This was followed by collapse of the left rudder pedal and a right rolling motion. The aircraft began to spiral; just prior to impact the spiral… - [NTSB LAX87FA077](https://openairdocs.org/ntsb/LAX87FA077.md): Cessna 182Q · Essex, CA · Accident · 1 fatal · Field investigation · Final report · Jan 7, 1987 · N28MB · Destroyed > Upon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.… - [NTSB LAX87LA076](https://openairdocs.org/ntsb/LAX87LA076.md): Varga 2150A · Hayward, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 5, 1987 · N5076V · Substantial damage > After rtrng fm a flt, the plt took off again (using rwy 28L) & turned to the se. A witness (se of the arpt), said he sawthe acft at low alt (estd 100 to 200 ft) flying in his drctn. He noted no otr indcn of a problem until after the acft made a 'very sharp… - [NTSB FTW87FA043](https://openairdocs.org/ntsb/FTW87FA043.md): Mooney M20J · Gladewater, TX · Accident · 1 fatal · Field investigation · Final report · Jan 3, 1987 · N201AV · Destroyed > The pilot departed into low overcast clouds (about 200 foot ceiling) with one to two miles visibility in light rain and fog. He did not file a flight plan although he was instrument rated. His currency for flight in instrument conditions are unknown.… - [NTSB LAX87LA073](https://openairdocs.org/ntsb/LAX87LA073.md): Cessna 152 · San Dimas, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 1987 · N5540H · Substantial damage > Witnesses rprtd the acft had circled the area 2 times at aprx 200' before it hit trees & crashed. Subsequently, it came to rest against a residence where the plt's sister lived. According to the plt, the eng started 'sputtering,' so he applied carb heat, but… - [NTSB ATL87FA052](https://openairdocs.org/ntsb/ATL87FA052.md): Cessna 150F · Newville, AL · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1987 · N8780S · Destroyed > The aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the… - [NTSB NYC87LA054](https://openairdocs.org/ntsb/NYC87LA054.md): Cessna 152 · Fairfax, VT · Accident · Serious injuries · Limited investigation · Final report · Dec 30, 1986 · N94336 · Destroyed > The CFI reported that he had initiated a simulated eng failure for the student. The student responded properly to the simulated emergency and lined the acft up on an apch to a field. At 200 ft AGL, the student was instructed to go-around at which time full… - [NTSB FTW87FA041](https://openairdocs.org/ntsb/FTW87FA041.md): American AA-1A · Robertson, TX · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1986 · N9493L · Destroyed > Witnesses stated that the aircraft was circling the top of a 94 ft tall oil well makeover rig when it descended below their line of sight. Another witness a mile away stated that the aircraft began spinning before ground impact. No evidence of any malfunction… - [NTSB CHI87FA060](https://openairdocs.org/ntsb/CHI87FA060.md): Cessna 150L · Lakeview, MI · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1986 · N6965G · Destroyed > Witnesses observed the aircraft buzzing a farm where a friend of the pilot resided. Following a low pass, the aircraft pulled up into a steep, left climbing turn. At the top of the climb, the nose dropped and the aircraft spiraled into the ground. - [NTSB NYC87DNE01](https://openairdocs.org/ntsb/NYC87DNE01.md): Kosch Whitehead #21 · Stratford, CT · Accident · Serious injuries · Final report · Dec 29, 1986 · N1901G · Minor damage > The experimental aircraft was making taxi tests on an abandoned taxiway when it became airborne. A photographer rushed out from a marked safety area directly in the flight path of the aircraft and was struck by the aircraft receiving a broken arm. The… - [NTSB DEN87FA035](https://openairdocs.org/ntsb/DEN87FA035.md): Piper PA-12-150 · Gilcrest, CO · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1986 · N78475 · Destroyed > The plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4… - [NTSB LAX87MA068](https://openairdocs.org/ntsb/LAX87MA068.md): Piper PA-28-181 · Long Beach, CA · Accident · No injuries · Major investigation · Final report · Dec 26, 1986 · N7646F · 2 aircraft · Substantial damage > A Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS… - [NTSB FTW87FA037](https://openairdocs.org/ntsb/FTW87FA037.md): Cessna 150L · Altus, OK · Accident · 1 fatal · Field investigation · Final report · Dec 26, 1986 · N18227 · Destroyed > The pilot was circling about 40-50 feet above the ground at a slow rate of airspeed while searching for a lost dog. He was using 10 degrees of flaps and most probably operating at a reduced power setting. Carburetor icing conditions were present and… - [NTSB DEN87FA037](https://openairdocs.org/ntsb/DEN87FA037.md): Piper PA-18-150 · Lewistown, MT · Accident · 2 fatal · Field investigation · Final report · Dec 26, 1986 · N6712L · Substantial damage > On the morning of the day of the accident the private plt/owner and his friend took off on an all day coyote hunting flt. When the acft failed to return that evening an air and ground search was begun. The burned wreckage of the acft was found 3 days later… - [NTSB FTW87LA040](https://openairdocs.org/ntsb/FTW87LA040.md): Cessna 172 · Marble Falls, TX · Accident · No injuries · Limited investigation · Final report · Dec 24, 1986 · N53384 · Substantial damage > A pilot on a cross country flight in the local area at randolf afb, TX. Was flying low over the llano river about 50 ft. AGL and contacted a power line, substantially damaging the right wing. The pilot continued on to randolf afb and landed without incident. - [NTSB MKC87FA033](https://openairdocs.org/ntsb/MKC87FA033.md): Champion 7ECA · Cambridge, NE · Accident · 2 fatal · Field investigation · Final report · Dec 21, 1986 · N2674G · Substantial damage > The low time PIC had been flying his acft over the farm land in search of coyotes. Several of the grd crew had flown as psngrs with him during the time period of this search. Witnesses stated that they saw the acft turn left and right as it was spotting the… - [NTSB FTW87DQA01](https://openairdocs.org/ntsb/FTW87DQA01.md): Beggs Pitts S-1 · El Paso, TX · Accident · 1 fatal · Final report · Dec 20, 1986 · N16GB · Substantial damage > Commercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX. - [NTSB MKC87LA032](https://openairdocs.org/ntsb/MKC87LA032.md): Cessna 172P · Pine Bluff, AR · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N75579 · Substantial damage > The pilot stated he had flown over trees from the southeast and descended to 50 ft. upon seeing trees in front of the acft he turned left, away from the trees. The left wing touched the ground followed by the nose gear. The acft then flipped forward to the… - [NTSB ATL87LA044](https://openairdocs.org/ntsb/ATL87LA044.md): Hughes 269C · Bowling Green, KY · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N7416F · Destroyed > While hovering in a grassy area near the hangar facility, the pilot experienced a complete loss of flight control. The helicopter struck the ground and sustained substantial damage. The helicopter component examination failed to disclose any system… - [NTSB ANC87LA020](https://openairdocs.org/ntsb/ANC87LA020.md): Cessna 177 · Willow, AK · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1986 · N30814 · Substantial damage > The pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=193 ## 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=192 --- 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.