# 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 193 of 377 · 18,850 cases ## Cases, newest first - [NTSB CHI87MA053](https://openairdocs.org/ntsb/CHI87MA053.md): Hughes 269B · Cross Plaines, IN · Accident · 2 fatal · Major investigation · Final report · Dec 10, 1986 · N8982F · Destroyed > The plt & observer were on a power line patrol flt. While proceeding southbound, they apchd an area were the lines were about 23 ft AGL & were crossed by another set of power lines, oriented in an east-west direction. The other power lines were about 45 ft… - [NTSB ANC87LA019](https://openairdocs.org/ntsb/ANC87LA019.md): Piper PA-18 · Shageluk, AK · Accident · No injuries · Limited investigation · Final report · Dec 7, 1986 · N9940D · Substantial damage > The pilot stated he encountered freezing rain and due to the build-up on the aircraft, he stalled and crashed in an open area next to the airport. - [NTSB NYC87FA045](https://openairdocs.org/ntsb/NYC87FA045.md): Cessna 152 · Carlisle, PA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1986 · N69123 · Destroyed > The student pilot flying a Cessna 152 scheduled his flight period so it coincided with another student pilot flying a Cessna 172. The pilot of the Cessna 172 reported seeing the Cessna 152 enter a two turn spin and recover. He then said he lost sight of the… - [NTSB DEN87LA029](https://openairdocs.org/ntsb/DEN87LA029.md): Piper PA-18-150 · Havre, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1986 · N7087D · Substantial damage > The plt inadvertently stalled the acft during pull-up after making a pass 20 ft above coyotes on the ground. The acft impacted level terrain and slid through a wire fence. - [NTSB ATL87LA036](https://openairdocs.org/ntsb/ATL87LA036.md): Sikorsky UH-19D · Roanoke Rapids, NC · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N37800 · Substantial damage > The plt said he was spreading fertilizer on trees when he heard a loud noise from the eng & the helicopter yawed left. At that time, the helicopter's alt & speed were about 100 ft & 40 KTS. Collective was raised to clear tree tops & reach a clearing. Before… - [NTSB LAX87DUJ02](https://openairdocs.org/ntsb/LAX87DUJ02.md): Grumman G-164 · Chandler, AZ · Accident · No injuries · Final report · Dec 5, 1986 · N671Y · Substantial damage > The acft collided with power lines during an aerial application flight. The pilot had made several passes prior to the accident and noticed the wires each time. Visibility was good, it was daylight conditions, and there were no mechanical problems. - [NTSB CHI87LA041](https://openairdocs.org/ntsb/CHI87LA041.md): Cessna 152 · Vergenns, IL · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 1986 · N95614 · Substantial damage > According to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the… - [NTSB ANC87LA018](https://openairdocs.org/ntsb/ANC87LA018.md): Cessna U206G · Uganik Pass, AK · Accident · No injuries · Limited investigation · Final report · Dec 4, 1986 · N4736U · Substantial damage > The pilot stated that he encountered a complete white-out condition; he started a turn to the left and struck the top of the ridge at the 1780 foot level. - [NTSB FTW87FA025](https://openairdocs.org/ntsb/FTW87FA025.md): Piper PA-32-260 · Baytown, TX · Accident · 1 fatal · Field investigation · Final report · Dec 3, 1986 · N43302 · Destroyed > The plt took off from a decommissioned, unlighted arpt at night after telling friends in a bar that he was going to new orleans. Later, witnesses observed the acft as the plt made several low passes over an interstate highway near the departure arpt. While… - [NTSB MKC87LA029](https://openairdocs.org/ntsb/MKC87LA029.md): Beech 95-B55 · Dumas, AR · Accident · No injuries · Limited investigation · Final report · Nov 30, 1986 · N783PT · Substantial damage > The plt stated that he was operating VFR out of ft. lauderdale, Florida, when he encountered IMC weather close to valdosta, Georgia. At this point, the plt further stated, he air-filed an IFR flight plan but elected not to land and refuel. According to ATC… - [NTSB NYC87FA039](https://openairdocs.org/ntsb/NYC87FA039.md): Bell 47-G2A · Jamesburg, NJ · Accident · Serious injuries · Field investigation · Final report · Nov 28, 1986 · N7579 · Destroyed > The CFI and private student were practicing lifting off to a hover. The CFI allowed the student to preform one or two under supervision and they were satisfactory. The CFI then allosed the student to start preforming the manuevers. The CFI heard the right… - [NTSB LAX87DVM01](https://openairdocs.org/ntsb/LAX87DVM01.md): Moore-Van RV-3 · Carmel, CA · Accident · 1 fatal · Final report · Nov 27, 1986 · N135RV · Destroyed > The experimental homebuilt acft was performing aerobatics consisting of loops, rolls and high speed climbs from pull-outs. The acft limitations allowed for the performance of aerobatics, which included the maneuvers the plt was performing at the time of the… - [NTSB SEA87LA033](https://openairdocs.org/ntsb/SEA87LA033.md): Piper J-3 · Waitsburg, WA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1986 · N6849H · Substantial damage > The pilot elected to circle coyotes at a very low altitude. During the second turn the aircraft felt mushy. The aircraft's left wing tip struck the ground followed by the aircraft striking the ground hard and flat. - [NTSB LAX87DVA02](https://openairdocs.org/ntsb/LAX87DVA02.md): Schweizer G-164A · Fresno, CA · Accident · No injuries · Final report · Nov 24, 1986 · N8741H · Substantial damage > The airplane collided with telephone lines while conducting an aerial application operation. The pilot reported that he was familiar with the area. He surveyed the field, in flight, before he commenced the spraying activities. The pilot did not report, nor… - [NTSB NYC87LA036](https://openairdocs.org/ntsb/NYC87LA036.md): Boeing Stearman 75 · No.Andover, MA · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1986 · N769WM · Substantial damage > Three banners were laid out for pickup by two stearman aircraft. One banner was an extra. The two stearmans approached the banner pick up point as a flight of two. As the first aircraft made its pickup an extra banner became tangled with the designated pickup… - [NTSB BFO87FA009](https://openairdocs.org/ntsb/BFO87FA009.md): Piper PA-28-161 · Danville, VA · Accident · 2 fatal · Field investigation · Final report · Nov 17, 1986 · N43905 · Destroyed > The aircraft was observed flying around the airport as the weather deteriorated. The pilot had elected to depart at about 2345 EST after obtaining a weather briefing 6 & 1/2 hours before. The plt had a total of about 83 hours flying time and did not have any… - [NTSB SEA87LA026](https://openairdocs.org/ntsb/SEA87LA026.md): Cessna 170A · Temple Bar, NV · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N5780C · Substantial damage > The plt departed with about 17 gals of auto fuel on board. During flt, the right fuel tank was emptied & the fuel selector was moved to the left tank position. About 1.7 hrs after taking off, the plt entered a left slip to dscnd & make a low pass down a rwy… - [NTSB SEA87LA025](https://openairdocs.org/ntsb/SEA87LA025.md): Hughes 369D · Winlock, WA · Accident · No injuries · Limited investigation · Final report · Nov 14, 1986 · N1089D · Substantial damage > The plt was loading xmas trees from a farm to a truck. He had just released a load and was en route back to the pickup area when the empty long-line sling contacted treetops. The sling rebounded into the tail rotor & damaged the gear box which resulted in… - [NTSB SEA87LA023](https://openairdocs.org/ntsb/SEA87LA023.md): Cessna 172M · Corral, ID · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1986 · N12870 · Substantial damage > The plt was scouting for elk in rugged rising terrain. The eng began losing power, so he applied carburetor heat. However, the RPM dropped further & the acft crashed on wooded terrain. No mechanical difficulties were found. County authorities stated that… - [NTSB MIA87DKT01](https://openairdocs.org/ntsb/MIA87DKT01.md): Pitts S-1T · Miami, FL · Accident · Minor injuries · Final report · Nov 8, 1986 · N22XP · Substantial damage > Aircraft collided with trees while recovering from a spin which was performed at low altitude as part of an airshow performance. Pilot stated he misjudged height of trees and recovered from the spin too low. - [NTSB MIA87FA022](https://openairdocs.org/ntsb/MIA87FA022.md): Grumman G-164A · Orlando, FL · Accident · 1 fatal · Field investigation · Final report · Nov 5, 1986 · N711WW · Destroyed > While the plt was making a banner pick-up, witnesses saw the acft engage the banner & enter a climb. The plt released the banner, then the acft mushed into a partially built hangar, crashed & burned. The plt, who was on fire, exited the rgt canopy hatch.… - [NTSB DEN87FA014](https://openairdocs.org/ntsb/DEN87FA014.md): Cessna 172M · Bozeman, MT · Accident · 3 fatal · Field investigation · Final report · Nov 4, 1986 · N3263B · Destroyed > The plt and his 2 pax's went flying to spot elk in a canyon area. A witness observed the acft low over trees when it suddenly shuddered, banked sharply to the left, then entered a steep descent. The aircraft crashed in a wooded area on the side of the canyon.… - [NTSB CHI87FA015](https://openairdocs.org/ntsb/CHI87FA015.md): Sikorsky S-58ET · Becker, MN · Accident · 1 fatal · Field investigation · Final report · Nov 4, 1986 · N4247S · Substantial damage > The helicopter (hel) was being used on an external load opn to psn a 2500 lb ventilator to the roof of a bldg. On the next to last load, the plt radioed that he noted a momentary illumination of the fuel bypass advisory light. He elected to cont the opn &… - [NTSB LAX87FA200](https://openairdocs.org/ntsb/LAX87FA200.md): Bellanca 17-30A · Flagstaff, AZ · Accident · 2 fatal · Field investigation · Final report · Nov 3, 1986 · N93495 · Destroyed > The plt & his wife desired to return to their Flagstaff, AZ, home following a weekend at stockton, CA., & they departed sck in VFR weather conditions. The weather at the destination arpt had been below VFR minimums all morning & it was forecast to remain poor… - [NTSB CHI87LA016](https://openairdocs.org/ntsb/CHI87LA016.md): Piper PA-28-181 · Lafayette, IN · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N8112T · Substantial damage > During an instructional flight a bird strike was encountered while practicing steep turns at about 2500' MSL. The horizontal stabilator was damaged to the point that it was barely operative. Landing was accomplished by using extreme forward pressure to the… - [NTSB MIA87FA020](https://openairdocs.org/ntsb/MIA87FA020.md): Bushby MM-1 · New Smyrna Bch, FL · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1986 · N3059 · Destroyed > Witnesses, including the victim's son riding as a pax in another acft flying at 800 ft, observed the midget mustang coming up from the right, behind and below them. While still below their alt, the mustang was observed to roll to the right, away from them,… - [NTSB BFO87FA006](https://openairdocs.org/ntsb/BFO87FA006.md): Piper PA-28-140 · Bloomington, MD · Accident · Minor injuries · Field investigation · Final report · Nov 1, 1986 · N5897U · Substantial damage > Witnesses observed 2 aircraft flying near treetop level and reported that one appeared to be about 10 feet behind the other. The lead aircraft collided with trees when the pilot delayed his pullup to a point where he was unable to climb over a ridge on his… - [NTSB DEN87FA011](https://openairdocs.org/ntsb/DEN87FA011.md): Cessna 172P · Gallup, NM · Accident · Serious injuries · Field investigation · Final report · Oct 30, 1986 · N65184 · Destroyed > While flying at a low level spotting deer in mountainous terrain the plt attempted to fly over a ridgeline with terrain that rose faster than the acft climb capability. At low airspeed and altitude he initiated a turn to reverse course toward lower terrain.… - [NTSB CHI87FA012](https://openairdocs.org/ntsb/CHI87FA012.md): Piper PA-18-150 · Int'L Falls, MN · Accident · 2 fatal · Field investigation · Final report · Oct 25, 1986 · N4875A · Destroyed > The acft was observed maneuvering over the passengers house just prior to the accident. The plt circled the residence with the acft wings almost perpendicular to the ground at an alt between 150 and 200 ft AGL. According to witnesses, as the wings reached the… - [NTSB NYC87MA024](https://openairdocs.org/ntsb/NYC87MA024.md): Enstrom F-28F · Manhattan, NY · Accident · 1 fatal · Major investigation · Final report · Oct 22, 1986 · N8617B · Destroyed > The aircraft was contracted by nbc to make daily highway traffic observations in the new york city area. The pilot and passenger, an nbc radio traffic reporter, were flying in a northerly direction along Manhattan's west side at an altitude of about 75 feet.… - [NTSB MKC87DCA01](https://openairdocs.org/ntsb/MKC87DCA01.md): Cessna C-152 · Fredericktown, MO · Accident · 2 fatal · Final report · Oct 21, 1986 · N89813 · Destroyed > The aircraft was being used to give relatives local area flights. The witnesses reported that the airplane had been doing low altitude maneuvers, stalls, and engine power cuts for over an hour. The witnesses observed the acft in a low altitude pass when it… - [NTSB NYC87FA023](https://openairdocs.org/ntsb/NYC87FA023.md): Cessna R172K · Rockwood, TN · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1986 · N7526V · Destroyed > The aircraft was observed departing at approx 2010 hours, reversing course and flying over the airport at 300-400 ft AGL. The aircraft crashed 3/4 miles south of the airport in unpopulated, mountainous/hilly terrain at an elevation of 1560 feet, which is 104… - [NTSB NYC87FA022](https://openairdocs.org/ntsb/NYC87FA022.md): Gulfstream American 112 · Beekman, NY · Accident · 1 fatal · Field investigation · Final report · Oct 18, 1986 · N1207J · Destroyed > The acft departed dutchess county airport, poughkeepsie, NY, and had an engine failure due to inadequate lubrication. The oil filter was found disconnected from the engine. At duthess county airport parking area, fresh oil was found on the grass parking area… - [NTSB LAX87DVA01](https://openairdocs.org/ntsb/LAX87DVA01.md): Rockwell S-2R · Dos Palos, CA · Accident · Minor injuries · Final report · Oct 15, 1986 · N8450V · Substantial damage > After departing the field on his last spray application, the aircraft's left wing collided with an antenna guy wire located about 100 feet above the ground. The pilot attempted to return to the airstrip aprx five miles away. However, as he entered into a… - [NTSB NYC87FA011](https://openairdocs.org/ntsb/NYC87FA011.md): Cessna 172 · Croton On Hud., NY · Accident · 1 fatal · Field investigation · Final report · Oct 14, 1986 · N6090J · Destroyed > Student pilot advised by millville fss that VFR flight not recommended due to current and forecast IFR conditions throughout route of flight. Acft observed flying near base of low clouds and in and out of clouds prior to crashing in a residential area. - [NTSB DEN87FA002](https://openairdocs.org/ntsb/DEN87FA002.md): Piper J3C-65 · Richey, MT · Accident · Serious injuries · Field investigation · Final report · Oct 9, 1986 · N3742Z · Destroyed > After making a low pass so the passenger could shoot at a coyote, the plt initiated a rgt turn to position the acft for another pass. While in the turn, the acft impacted the ground. The plt stated that the passenger (rear seat occupant) was partially out the… - [NTSB SEA87LA005](https://openairdocs.org/ntsb/SEA87LA005.md): Hughes 269A · Forest Grove, OR · Accident · No injuries · Limited investigation · Final report · Oct 7, 1986 · N986GC · Destroyed > Plt was overflying filbert orchard to shake nuts off trees with rotowash. Plt allowed rotor RPM to decay in a down wind turn 10 feet AGL. Acft collided with trees, then ground, and rolled over. - [NTSB LAX86DVA17](https://openairdocs.org/ntsb/LAX86DVA17.md): Hiller UH-12E · Visalia, CA · Accident · 1 fatal · Final report · Sep 29, 1986 · N5385V · Destroyed > While executing a 90 DEG/270 deg course reversal turn, the plt lost control of the helicopter which collided with the ground. Ground witnesses reported that the plt had completed spraying a cotton field and advised the ground flagger that the winds had… - [NTSB FTW86FA171](https://openairdocs.org/ntsb/FTW86FA171.md): Cessna 152 · Pearland, TX · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1986 · N5542P · Substantial damage > The commercial plt was conducting a pipeline patrol operation when the accident occurred. According to witnesses, the acft circled the area twice at an alt estimated to be below 100 ft AGL. The acft then banked left and nosed down to ground impact. - [NTSB DEN86FA259](https://openairdocs.org/ntsb/DEN86FA259.md): Cessna 340A · Crawford, CO · Accident · 5 fatal · Field investigation · Final report · Sep 25, 1986 · N6663G · Destroyed > The plt took off on a VFR flt with no flt plan filed or wx briefing. He encountered a wx squall line en route with low ceilings, fog, mixed rain and snow. While he was attempting to maneuver VFR through the wx at a low altitude above the ground, the acft… - [NTSB MIA86FA252](https://openairdocs.org/ntsb/MIA86FA252.md): Cessna 152II · Clewiston, FL · Accident · 2 fatal · Field investigation · Final report · Sep 23, 1986 · N4865L · Destroyed > Purpose of the flt was to spot stray cattle. The acft made a low pass after chasing a cow. According to witnesses, the acft stalled and descended to ground impact during the pull-up maneuver following the low pass. - [NTSB NYC86LA239](https://openairdocs.org/ntsb/NYC86LA239.md): Hiller UH12C · E.Conway, NH · Accident · No injuries · Limited investigation · Final report · Sep 22, 1986 · N73876 · Substantial damage > Pilot lost control of the helicopter while at hover then decided to land. However the pilot set the aircraft down hard. The main rotor blade severed the tail. - [NTSB DEN86FTE03](https://openairdocs.org/ntsb/DEN86FTE03.md): Homebuilt Bushby Mustang · Casper, WY · Accident · 1 fatal · Final report · Sep 21, 1986 · N117RD · Destroyed > The Homebuilt acft crashed during low alt maneuvers from about 150 ft AGL. A witness who helped build the acft was taking pictures and recording data of the flt at the time of the accident. This witness stated that the plt attempted an aileron roll. The first… - [NTSB SEA86FA248](https://openairdocs.org/ntsb/SEA86FA248.md): Cessna 172 · Overton, NV · Accident · 2 fatal · Field investigation · Final report · Sep 20, 1986 · N5481J · Destroyed > The UNICOM operator at boulder city made radio contact with '81J' at about 2300 PDT, after hearing an acft maneuvering in the area. The plt stated he did not plan to lnd at boulder city, but said he intended to fly 'up the vegas wash' area. At aprx 2300 to… - [NTSB NYC86FNC09](https://openairdocs.org/ntsb/NYC86FNC09.md): Cessna 205 · Twin Mountain, NH · Accident · Minor injuries · Final report · Sep 20, 1986 · N27WD · Substantial damage > During a 'bomb drop' contest at an organized 'fly-in', the pilot was maneuvering at low airspeed so his passenger could drop a water-filled balloon on a target which had been placed on runway 27. The acft suddenly banked to the right and pitched down striking… - [NTSB ATL86FA259](https://openairdocs.org/ntsb/ATL86FA259.md): Cessna 150M · Screven, GA · Accident · 2 fatal · Field investigation · Final report · Sep 20, 1986 · N66297 · Destroyed > The plt and his best man for his wedding scheduled for later in the day dep LCL apt early in the am. The acft was observed maneuvering at a low alt over the plts parents home. Witnesses described the maneuvers to be like a crop duster making pull ups and… - [NTSB FTW86LA169](https://openairdocs.org/ntsb/FTW86LA169.md): Bell 206B · Eugene Island · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 1986 · N16978 · Destroyed > Commercial helicopter pilot engaged in off-shore flight operations failed to remove aircraft tie-down lines prior to take off from the oil rig. Pilot lost control of aircraft in a hover causing the aircraft to collide with a metal safety net and,… - [NTSB ATL86LA261](https://openairdocs.org/ntsb/ATL86LA261.md): Piper PA-25-235 · Plymouth, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 1986 · N9513P · Substantial damage > During a turn to reverse direction while dispersing chemicals over a peanut crop, the engine lost power. The pilot dumped the load of chemicals and made a hard full stall forced landing in the peanut field. Inspection of the engine revealed that the left… - [NTSB FTW86FRD25](https://openairdocs.org/ntsb/FTW86FRD25.md): WSK PZL Mielec PZL-M18 · Mer Rouge, LA · Accident · 1 fatal · Final report · Sep 15, 1986 · N2710L · Destroyed > The pilot pulled up steeply at the end of a spray run and started a turn-around. During this time he allowed the airspeed to bleed off to the point at which the aircraft stalled and entered a spin without sufficient altitude to recover before ground impact… - [NTSB MIA86LA249](https://openairdocs.org/ntsb/MIA86LA249.md): Cessna A188B · Newberry, FL · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N4892R · Substantial damage > The plt stated that while spraying a field he experienced an eng problem and while attempting a precautionary landing in a cow pasture his left main gear hit a hole and collapsed. Post crash examination of the eng revealed that the linkage on the throttle… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=194 ## 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=193 --- 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.