# 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 194 of 377 · 18,850 cases ## Cases, newest first - [NTSB FTW86LA167](https://openairdocs.org/ntsb/FTW86LA167.md): Hiller UH-12E · Norias, TX · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N40268 · Substantial damage > The commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain. - [NTSB SEA86LA243](https://openairdocs.org/ntsb/SEA86LA243.md): Grumman G164A-450 · Orovado, NV · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1986 · N8025K · Destroyed > Power lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire. - [NTSB SEA86FA245](https://openairdocs.org/ntsb/SEA86FA245.md): Cessna 150M · Carbonado, WA · Accident · 2 fatal · Field investigation · Final report · Sep 12, 1986 · N9250U · Destroyed > The instructor and passenger departed on either an introductory flight, initial instructional flight, (or combination thereof). During the flight the aircraft was flown down a canyon which the instructor had flown down previously. As the aircraft approached… - [NTSB LAX86LA344](https://openairdocs.org/ntsb/LAX86LA344.md): Hughes 269C · Carlsbad, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1986 · N58323 · Substantial damage > The helicopter departed palomar airport (crq), Carlsbad, CA, on a local instructional flight and was the second flight for the dual student. After completing the flight lesson the student asked the CFI to demonstrate hovering. The CFI initiated an… - [NTSB LAX86FVM08](https://openairdocs.org/ntsb/LAX86FVM08.md): Hiller UH 12E · Gonzales, CA · Accident · No injuries · Final report · Sep 7, 1986 · N149HA · Substantial damage > A loss of power was expereinced as the acft descended into a field at the beginning of an aerial application spray run. The plt initiated a forced landing into the field. During the landing the right skid dug into the field, tipping the helicopter onto its… - [NTSB CHI86LA219](https://openairdocs.org/ntsb/CHI86LA219.md): Hughes 500 (369HS) · West Lafayette, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1986 · N2254X · Destroyed > The helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then… - [NTSB BFO86FA044](https://openairdocs.org/ntsb/BFO86FA044.md): Cessna 177B · Springfield, VA · Accident · 1 fatal · Field investigation · Final report · Sep 6, 1986 · N34953 · Substantial damage > According to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally… - [NTSB DEN86LA248](https://openairdocs.org/ntsb/DEN86LA248.md): Cessna 150J · Goodrich, ND · Accident · No injuries · Limited investigation · Final report · Sep 5, 1986 · N50989 · Substantial damage > Plt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the… - [NTSB FTW86FRD24](https://openairdocs.org/ntsb/FTW86FRD24.md): Texas Helicopter OH-13E/M74 · Port Allen, LA · Accident · No injuries · Final report · Sep 3, 1986 · N38092 · Substantial damage > The helicopter experienced partial power loss and descended to ground. It spray booms became entangled in the soy beans. The helicopter started to nose over, then rolled onto its right side and came to rest. Reason for the partial power loss is undetermined. - [NTSB LAX86FUM04](https://openairdocs.org/ntsb/LAX86FUM04.md): Steen Skybolt UNK · Chula Vista, CA · Accident · 2 fatal · Final report · Sep 2, 1986 · N64596 · Destroyed > During a local pleasure flight, the aircraft was observed to make a climbing right turn to the inverted position. When observed a few seconds later, the aircraft was right side up in a shallow spin. The aircraft remained in this position until colliding with… - [NTSB ATL86FA239](https://openairdocs.org/ntsb/ATL86FA239.md): Cessna P206-B · Wht Sulphur Spr, WV · Accident · 1 fatal · Field investigation · Final report · Sep 2, 1986 · N4782F · Destroyed > After completing the revenue producing portion of this trip the company president called his company operations and told his secretary to send everyone home since it was a holiday. He was going to return the acft to its home base himself. The plt departed… - [NTSB CHI86FEC06](https://openairdocs.org/ntsb/CHI86FEC06.md): Lawrence Baby Great Lakes · Holly, MI · Accident · 1 fatal · Final report · Sep 1, 1986 · N1BL · Substantial damage > The plt/owner had recently acquired the acft & had only about 3 hrs of flt time in this make & model. After taking off, he flew to the area of a friend's house & made svrl passes over a field near the house. After the last pass, the plt turned to an easterly… - [NTSB ATL86FA240](https://openairdocs.org/ntsb/ATL86FA240.md): Piper PA-28-161 · Hampton, NH · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1986 · N8285C · Destroyed > The acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft… - [NTSB NYC86LA225](https://openairdocs.org/ntsb/NYC86LA225.md): Piper PA-22-150 · Dennis Port, MA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1986 · N3841P · Substantial damage > According to the plt, he was flying at an alt of 800 ft along the coastline during an aerial advertising flt and was switching from the right fuel tank to the left when the eng lost power. The acft was then ditched in 14 foot deep water. Post accident… - [NTSB NYC86FA219](https://openairdocs.org/ntsb/NYC86FA219.md): Cessna 152 · Bargaintown, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1986 · N6563L · Destroyed > The student pilot on a supervised solo cross country, diverted from his planned route and was observed flying low over a residential area performing maneuvers at or below tree top level. The pilot apparently lost control of the aircraft. Aircraft impacted the… - [NTSB LAX86LA339](https://openairdocs.org/ntsb/LAX86LA339.md): Taylorcraft BC-12D · Lompoc, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1986 · N434CW · Substantial damage > According to the plt's son the plt routinely overflew his home and rocked the wings. The plt indicated that he was flying at 1100 ft MSL (aprx 650 ft AGL) over his son's ranch and decided to demonstrate slow flt. He slowed the acft to 70 mph and made one… - [NTSB LAX86FVG07](https://openairdocs.org/ntsb/LAX86FVG07.md): Phillips Steen Skybolt · Sonora, CA · Accident · Minor injuries · Final report · Aug 31, 1986 · N69Z · Substantial damage > An amateur built Phillips steen skybolt experienced an inflight failure of the upper wing panel fabric which led to a rapid descent and subsequent hard landing in a parking lot. Examination of the wing panel revealed no evidence of glue or bonding material… - [NTSB DEN86LA245](https://openairdocs.org/ntsb/DEN86LA245.md): Aerotek Pitts S-2B · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 31, 1986 · N260PS · Destroyed > The plt rprtd that while he was performing aerobatics at an airshow, the acft's eng momentarily lost power during inverted flt at the top of a loop. He was unable to complete the loop. Subsequently, the acft contacted the rwy in a level attitude while it was… - [NTSB SEA86LA235](https://openairdocs.org/ntsb/SEA86LA235.md): Cessna 182D · Stibnite, ID · Accident · 2 fatal · Limited investigation · Final report · Aug 30, 1986 · N8778X · Destroyed > After taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft… - [NTSB SEA86FA231](https://openairdocs.org/ntsb/SEA86FA231.md): Ercoupe 415C · Prosser, WA · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1986 · N3002H · Destroyed > The plt was practicing fly-bys for the next days airshow. The left wing sustained an inflight structural failure. Investigation revealed a progressive crack in the #7 rib emanating from previous damage to the leading edge of the left wing tip. This resulted… - [NTSB MKC86LA122](https://openairdocs.org/ntsb/MKC86LA122.md): Grumman G-164A · Bayard, NE · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · N7364 · Substantial damage > The plt stated he encountered downdrafts near trees he was going to overfly while in a turnaround maneuver to spray crops. Instead of flying over the trees, the plt stated that the acft descended into the ground near the trees while in the turn. Wind… - [NTSB ANC86LA139](https://openairdocs.org/ntsb/ANC86LA139.md): Bellanca 8KCAB · Susitna River, AK · Accident · No injuries · Limited investigation · Final report · Aug 29, 1986 · N1177E · Substantial damage > The pilot was demonstrating inverted flight to the student pilot and after one minute of flight in that attitude the engine began to run rough and then finally failed. The pilot performed a forced landing and during the landing roll the airplane nosed over. - [NTSB LAX86LA335](https://openairdocs.org/ntsb/LAX86LA335.md): Schweizer SGS 2-32 · Fremont, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1986 · N9845E · Substantial damage > The glider tow pilot stated that he noticed the glider's spoilers in the open position shortly after takeoff. He brought the glider to the traffic pattern. The glider pilot released from the tow and made a sharp turn during which the glider pitched up,… - [NTSB NYC86FHD03](https://openairdocs.org/ntsb/NYC86FHD03.md): Passonno Skybolt · Moorestown, NJ · Accident · 1 fatal · Final report · Aug 27, 1986 · N8FP · Destroyed > The Passonno skybolt was observed to recover from a loop and then the tail surfaces started to shake. The acft then descended to the ground and was destroyed by impact. Examination of various horizontal stabilizer and elevator components showed that the… - [NTSB ATL86LA229](https://openairdocs.org/ntsb/ATL86LA229.md): Piper J3C-65 · Benson, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1986 · N25803 · Destroyed > The acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site… - [NTSB SEA86LA221](https://openairdocs.org/ntsb/SEA86LA221.md): Cessna 172A · San Juan Island, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1986 · N7405T · Destroyed > The pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the… - [NTSB SEA86LA223](https://openairdocs.org/ntsb/SEA86LA223.md): Ayres S2R-600 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N4077X · Substantial damage > During an aerial application flight, the plt entered a right turn during a 'border pass.' While in the right turn, the right wing struck the ground and the aircraft cartwheeled & crashed. - [NTSB MIA86LA240](https://openairdocs.org/ntsb/MIA86LA240.md): Boeing PT-17 · Dublin, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1986 · N55290 · Substantial damage > While buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground. - [NTSB MIA86FA241](https://openairdocs.org/ntsb/MIA86FA241.md): Russell Post Moni Motorglider · Fellsmere, FL · Accident · 1 fatal · Field investigation · Final report · Aug 24, 1986 · N49P · Destroyed > Witnesses reported seeing the aircraft performing aerobatic maneuvers at approximately 1500 feet. The aircraft was later found with the tail surfaces separated. The tail surfaces were found 300 and 400 feet from the main wreckage. A metallurgical examination… - [NTSB LAX86FUM02](https://openairdocs.org/ntsb/LAX86FUM02.md): Star-Lite UNK · Ramona, CA · Accident · 1 fatal · Final report · Aug 23, 1986 · N42TJ · Destroyed > During a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the… - [NTSB SEA86LA214](https://openairdocs.org/ntsb/SEA86LA214.md): Taylorcraft BC12-D · Cusick, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 1986 · N95913 · Substantial damage > The pilot was performing as a barnstormer close to a local fair. After completion of several low passes the pilot was attempting to make a steep 180 degree turn to a landing. The turn was completed at insufficient altitude to recover and the aircraft struck… - [NTSB NYC86LA227](https://openairdocs.org/ntsb/NYC86LA227.md): Bell 47J-2A · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1986 · N255PH · Substantial damage > The plt experienced a total power loss of the acft eng while practicing autorotations. The helicopter landed hard, the main rotor flexed and severed the tail boom. Post accident inspection of the helicopter revealed the fuel selector was positioned on the… - [NTSB MKC86LA177](https://openairdocs.org/ntsb/MKC86LA177.md): Grumman G-164 · Goodwin, AR · Accident · No injuries · Limited investigation · Final report · Aug 22, 1986 · N634U · Substantial damage > The ag acft was being used to spray nudrin on soybeans when the engine lost power. The plt made a forced landing in a rice field and the acft flipped forward to the inverted position. Investigation revealed the two-piece cam reduction gear came apart. An AD… - [NTSB SEA86FA217](https://openairdocs.org/ntsb/SEA86FA217.md): Aeronca 7GCB · Stanley, ID · Accident · 2 fatal · Field investigation · Final report · Aug 21, 1986 · N9940Y · Destroyed > Witnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft… - [NTSB SEA86FA215](https://openairdocs.org/ntsb/SEA86FA215.md): Cessna T207A · Frenchglen, OR · Accident · 6 fatal · Field investigation · Final report · Aug 21, 1986 · N73569 · Destroyed > Although low altitude flight within the gorge was not in accordance with the mission profile the pilot entered the canyon and proceeded upslope towards rising terrain. 87% of the pilot's extensive flight experience was in helicopter aircraft and he had… - [NTSB SEA86FA213](https://openairdocs.org/ntsb/SEA86FA213.md): Luscombe 8A · Pelican, AK · Accident · 2 fatal · Field investigation · Final report · Aug 19, 1986 · N45830 · Destroyed > At about 1500 adt on 8/19/86, the plt departed on a flt to hoonak, AK. When he did not return, a search was initiated. The acft was located at 1400 adt on the following day where it had crashed on rising mountainous terrain at an elev of about 1740 ft. an… - [NTSB LAX86LA334](https://openairdocs.org/ntsb/LAX86LA334.md): Cessna 172 · Oroville, CA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1986 · N8976B · Substantial damage > The pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They… - [NTSB FTW86LPJ11](https://openairdocs.org/ntsb/FTW86LPJ11.md): Homebuilt SA-100 · Oklahoma City, OK · Accident · Minor injuries · Final report · Aug 17, 1986 · N57DH · Substantial damage > The acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated… - [NTSB NYC86FNC08](https://openairdocs.org/ntsb/NYC86FNC08.md): Champion 7HC · Epsom, NH · Accident · 2 fatal · Final report · Aug 16, 1986 · N8937R · Destroyed > A student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available. - [NTSB SEA86LA210](https://openairdocs.org/ntsb/SEA86LA210.md): Wise OR-71-B · Richland, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1986 · N26RW · Substantial damage > While on a qualifying lap for an air race the number one piston failed. A forced landing was then made onto a field. - [NTSB LAX86LA322](https://openairdocs.org/ntsb/LAX86LA322.md): Luscombe 8F · Marble Canyon, AZ · Accident · 2 fatal · Limited investigation · Final report · Aug 15, 1986 · N2122B · Destroyed > Witnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was… - [NTSB DEN86FA231](https://openairdocs.org/ntsb/DEN86FA231.md): North American AT-6D · Redcliff, CO · Accident · 2 fatal · Field investigation · Final report · Aug 15, 1986 · N9813C · Destroyed > A husband & wife rprtd that the acft flew near their house at a very low alt, then climbed in the direction of the sun to clear over a bridge. Moments later, the acft collided with power lines that were suspended between 2 towers. The towers were located atop… - [NTSB ATL86FEI10](https://openairdocs.org/ntsb/ATL86FEI10.md): Senior Aero Sport D-260 · Valley City, OH · Accident · 2 fatal · Final report · Aug 15, 1986 · N35250 · Destroyed > According to witnesses, the acft was in lvl flt at low alt when it entered a steep climbing maneuver. Subsequently, it entered a steep dscnt & crashed in aprx a 75 deg nose down attitude. There was evidence the acft was in a right bank & was spinning or… - [NTSB FTW86LQG18](https://openairdocs.org/ntsb/FTW86LQG18.md): Cessna A188B · Mcadoo, TX · Accident · Minor injuries · Final report · Aug 14, 1986 · N4851R · Destroyed > The pilot stated he encountered unfavorable wind conditions during a procedure turn which caused the aircraft to bank excessively. Subsequently, the aircraft descended and impacted the ground. The plt thought the aircraft may have encountered a 'whirlwind.' A… - [NTSB ATL86FEK05](https://openairdocs.org/ntsb/ATL86FEK05.md): Piper PA-25-235 · Melrose, OH · Accident · Serious injuries · Final report · Aug 14, 1986 · N4454Y · Substantial damage > The acft collided with a traffic sign during an aerial application flt. The plt had made a low pass prior to the collision. - [NTSB CHI86FA198](https://openairdocs.org/ntsb/CHI86FA198.md): Bellanca 7GCBC · Perrinton, MI · Accident · 2 fatal · Field investigation · Final report · Aug 13, 1986 · N36284 · Substantial damage > The pvt PIC and his pax, also a pvt plt, departed the pic's pvt airstrip for a local pleasure flt. An acft, similar in size and color to the plt's was seen doing low level flt at tree top level with abrupt pull-ups near where the plt normally flew. The plt… - [NTSB SEA86FA203](https://openairdocs.org/ntsb/SEA86FA203.md): Maule M-5-235C · Grangeville, ID · Accident · 1 fatal · Field investigation · Final report · Aug 10, 1986 · N6267M · Destroyed > A passenger in the acft reported the plt made more than one pass over 'a salt lick', each time coming closer and closer to the trees. On the last pass the acft 'just fell out of the sky', hit the trees, and landed upside down. Fire broke out almost… - [NTSB FTW86LA145](https://openairdocs.org/ntsb/FTW86LA145.md): Cessna 172D · Cordell, OK · Accident · No injuries · Limited investigation · Final report · Aug 9, 1986 · N2730U · Substantial damage > The pilot was practicing maneuvers at 1200 feet AGL, when the engine began to run rough. He applied the carburetor heat and had a large power reduction. He then turned off the carburetor heat and had a total loss of power at approximately 800 feet AGL. The… - [NTSB LAX86LA317](https://openairdocs.org/ntsb/LAX86LA317.md): Cessna 152 · Big Bear, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1986 · N95370 · Substantial damage > The plt planned a cross country flight from palm springs, CA. To the nearby mountain resort community of Big Bear, CA. Enroute, the plt navigated the acft over an area where the terrain was rising at a rate faster than his acft was climbing. The plt attempted… - [NTSB LAX86FA315](https://openairdocs.org/ntsb/LAX86FA315.md): Piper PA-28-140 · Phoenix, AZ · Accident · 3 fatal · Field investigation · Final report · Aug 7, 1986 · N8876N · Destroyed > The recently certificated private pilot initiated flt with an over loaded acft into high density alt conditions. The acft stalled as it made a climbing left turn to the crosswind leg of the traffic pattern. The stall resulted in an uncontrolled collision with… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=195 ## 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=194 --- 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.