# 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 206 of 378 · 18,851 cases ## Cases, newest first - [NTSB LAX85FA241](https://openairdocs.org/ntsb/LAX85FA241.md): North American AT6A · Lemoore, CA · Accident · 1 fatal · Field investigation · Final report · May 5, 1985 · N144KM · Destroyed > After dropping a parachutist to open an air show the plt's takeoff was delayed by a blown tire on a landing airplane and difficulties with filling his smoke oil tank. After completing about two thirds of his aerobatic routine the plt recovered from a reverse… - [NTSB CHI85FA186](https://openairdocs.org/ntsb/CHI85FA186.md): Piper PA-38-112 · Lakeville, MN · Accident · 2 fatal · Field investigation · Final report · May 5, 1985 · N2475L · Destroyed > The acft was observed to enter a spin from aprx 3000 ft AGL. The acft continued the spin to ground contact which witnesses stated occurred as the acft seemed to level off. Witnesses also reported seeing the acft perform aerobatics, which included loops, prior… - [NTSB DEN85LA123](https://openairdocs.org/ntsb/DEN85LA123.md): Cessna 172 · Garfield, CO · Accident · No injuries · Limited investigation · Final report · May 1, 1985 · N737DH · Substantial damage > The acft collided with terrain on the east side of monarch pass near Garfield, CO. The three occupants, all pilots, were not injured. The acft departed salida, CO, located aprx 20 miles east of the pass. The plt stated that the acft would not climb above… - [NTSB SEA85FYM01](https://openairdocs.org/ntsb/SEA85FYM01.md): Air Tractor AT301 · Weston, OR · Accident · Serious injuries · Final report · Apr 30, 1985 · N3652F · Destroyed > During this aerial application flight the aircraft clipped a tree and then impacted with the ground. The pilot was seriously injured when the stitching on the shoulder harness failed and the pilot was thrown forward. - [NTSB LAX85FJA02](https://openairdocs.org/ntsb/LAX85FJA02.md): Robinson R-22 · Hilo, HI · Accident · No injuries · Final report · Apr 29, 1985 · N8447C · Substantial damage > The acft rolled onto its left side within 10 ft of where it was parked prior to flt, the plt was attempting to come to a hover when it rolled. This was the plts 2nd attempt at solo flt in the helicopter. No mechanical malfunctions were noted during the post… - [NTSB MKC85LA091](https://openairdocs.org/ntsb/MKC85LA091.md): Piper PA-25-235C · Grenola, KS · Accident · No injuries · Limited investigation · Final report · Apr 28, 1985 · N8624L · Destroyed > While maneuvering during a swath to a field, the engine quit. The plt was operating his acft for aprx 1/2 hr prior to the loss of pwr. The plt states he visually checked the fuel level. An inspection of the acft engine revealed no mechanical failure or… - [NTSB CHI85LA179](https://openairdocs.org/ntsb/CHI85LA179.md): Pitts Pitts S2B · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Apr 28, 1985 · N260JH · Substantial damage > The acft performed 4 aileron rolls during which some alt was lost with each roll. During the final roll a wing made ground contact and folded as the acft slid to a stop. - [NTSB MIA85LA160](https://openairdocs.org/ntsb/MIA85LA160.md): Cessna C-182J · Loughman, FL · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N2892F · Substantial damage > The acft was towing a banner at 500 ft alt when the engine lost power. The pilot amde an emergency landing in a sandy field and the acft nosed over. The acft had flown 1 hr 15 min with the fuel tank selector on 'both'. The acft took off with a total of aprx… - [NTSB MIA85LA158](https://openairdocs.org/ntsb/MIA85LA158.md): Cessna 172K · Sharpes, FL · Accident · No injuries · Limited investigation · Final report · Apr 27, 1985 · N46494 · Substantial damage > Carburetor had rusted parts and needed an overhaul. Pilot was demonstrating power off stall to passengers, when he tried to apply power, engine did not respond. Landed in soft terrain. Swerved to avoid ditch. Nose wheel collapsed. - [NTSB MKC85FA089](https://openairdocs.org/ntsb/MKC85FA089.md): Piper PA-24-260 · Wakeeney, KS · Accident · 2 fatal · Field investigation · Final report · Apr 26, 1985 · N8852P · Destroyed > On a x-country flt from dodge city, KS, to hill city, KS, the plt encountered IFR wx conditions around Wakeeney, KS. The IFR conditions were not forecast for his area of flt. A 2000 CST observation at hill city, KS, was indicating IFR conditions existing aprx… - [NTSB FTW85FPA01](https://openairdocs.org/ntsb/FTW85FPA01.md): Air Tractor AT301-A · Rockwall, TX · Accident · Minor injuries · Final report · Apr 25, 1985 · N2361C · Substantial damage > The acft nosed over during a forced landing in a plowed field after the engine quit. Later exam showed water and fuel in the carburetor. The plt had expressed concern about contaminated fuel. The fuel came from the plt/operators own supply. - [NTSB DEN85FA120](https://openairdocs.org/ntsb/DEN85FA120.md): Cessna P210N · Laporte, CO · Accident · 1 fatal · Field investigation · Final report · Apr 22, 1985 · N6208W · Destroyed > The plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the… - [NTSB MKC85FA087](https://openairdocs.org/ntsb/MKC85FA087.md): Grumman G-164A · Coy, AR · Accident · 1 fatal · Field investigation · Final report · Apr 20, 1985 · N8729H · Destroyed > While approaching a field to dispense rice, the acft struck a set of power lines. The plt had flown over the same set of power lines for nearly 2 hours. The flagmen stated they heard the acft strike the wires and one of the wires made a 'pop' as if being… - [NTSB LAX85FA217](https://openairdocs.org/ntsb/LAX85FA217.md): Bell 206-L1 · Kailua/Kona, HI · Accident · Minor injuries · Field investigation · Final report · Apr 20, 1985 · N478KA · Destroyed > A revenue sight-seeing helicopter flight operating under 14 CFR 91 collided with lava rock while attempting a forced landing on the summit of muana loa volcano after a partial loss of power. The pilot stated that while in a shallow downwind turn at aprx 200… - [NTSB ATL85FA143](https://openairdocs.org/ntsb/ATL85FA143.md): Champion 7GCA · Collinsville, MS · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1985 · N9636S · Destroyed > Witnesses, friends of the plt, reported seeing the acft engaged in aerobatics at altitudes between 500 ft AGL and 2000 ft AGL, aprx 1/4 mile from their outdoor social function. They continued to report, the acft entered a spin and after aprx 2 3/4 revolutions… - [NTSB MIA85FA150](https://openairdocs.org/ntsb/MIA85FA150.md): Bellanca 8KCAB · Clearwater, FL · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1985 · N5054Y · Destroyed > The pilot was observed doing low level aerobatics. While diving inverted over the water, he attempted to perform an outside loop. The acft impacted the water inverted after the stall onset. Interviews with fellow pilots disclosed that the pilot had been… - [NTSB LAX85FA216](https://openairdocs.org/ntsb/LAX85FA216.md): Piper PA25-235 · Walnut Grove, CA · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1985 · N9636P · Destroyed > The acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's… - [NTSB LAX85FA210](https://openairdocs.org/ntsb/LAX85FA210.md): Cessna U206G · Tuba City, AZ · Accident · 6 fatal · Field investigation · Final report · Apr 19, 1985 · N8849Q · Destroyed > This was a medical transportation flight during the early morning hours in marginal weather conditions. The flight was not completed and was returning to the departure airport when it descended into desert terrain 10 miles short of its destination. - [NTSB FTW85FRA03](https://openairdocs.org/ntsb/FTW85FRA03.md): Condor Condor III · Hockley, TX · Accident · 2 fatal · Final report · Apr 19, 1985 · UNREG · Destroyed > The acft collided with the terrain in a near vertical descent. Witnesses stated the ultralight was airborne for aprx 5 minutes before a loud 'pop' was heard and it entered a steep nose down spiral. Inspection of the ultralight revealed a failed bolt in the… - [NTSB DEN85FA118](https://openairdocs.org/ntsb/DEN85FA118.md): Cessna 172 P · Santa Fe, NM · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1985 · N52457 · Destroyed > Two persons, neither rated as plts, took the acft without the knowledge or consent of the operator or arpt officials. They took off at night, & after a short time, returned to the arpt to land. During an attempted landing, the acft touched down hard, bounced… - [NTSB ATL85FA140](https://openairdocs.org/ntsb/ATL85FA140.md): Cessna 140 · Hawesville, KY · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1985 · N72587 · Destroyed > The acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river… - [NTSB ANC85LA069](https://openairdocs.org/ntsb/ANC85LA069.md): Piper PA-12 · Beluga, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N4228M · Substantial damage > Acft was doing low alt turns-about-a-point when the eng quit due to fuel starvation. The acft then crashed into trees. Plt stated the acft had aprx 5 gals of fuel an board at the time of the accident. - [NTSB FTW85LA186](https://openairdocs.org/ntsb/FTW85LA186.md): Cessna 152 · Roby, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 1985 · N89862 · Destroyed > The pipeline patrol plt diverted from the normal route to circle over a house in which he used to live. Witnesses reported the acft was in a low alt left turn when the left wing dropped and the rate of turn increased. The acft impacted a tree in a steep nose… - [NTSB MKC85FCA02](https://openairdocs.org/ntsb/MKC85FCA02.md): Piper PA-25-235 · Dexter, MO · Accident · Serious injuries · Final report · Apr 15, 1985 · N9826P · Destroyed > The plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &… - [NTSB FTW85FA188](https://openairdocs.org/ntsb/FTW85FA188.md): Bell UH-1B · Boutte, LA · Accident · Serious injuries · Field investigation · Final report · Apr 15, 1985 · N2252A · Destroyed > The plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft… - [NTSB LAX85FA202](https://openairdocs.org/ntsb/LAX85FA202.md): Cessna 172M · Camp Verde, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 14, 1985 · N73708 · 2 aircraft · Destroyed > Both acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close… - [NTSB CHI85LA161](https://openairdocs.org/ntsb/CHI85LA161.md): Cessna 150G · Stevens Point, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 1985 · N4609X · Substantial damage > During a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over. - [NTSB MIA85LA145](https://openairdocs.org/ntsb/MIA85LA145.md): Piper PA-28R-200 · Wabasso, FL · Accident · No injuries · Limited investigation · Final report · Apr 10, 1985 · N2648R · Substantial damage > Instructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with… - [NTSB MIA85FA146](https://openairdocs.org/ntsb/MIA85FA146.md): Bell 47G-2 · Panama City Bch, FL · Accident · Serious injuries · Field investigation · Final report · Apr 10, 1985 · N54522 · Substantial damage > The pilot was carrying two paying passengers for a sightseeing ride and had taken off two minutes earlier from a helicopter pad at the beach. He stated that he felt the engine sputter, the cyclic stick shake, less than 10 seconds later the acft hit the water… - [NTSB FTW85FA176](https://openairdocs.org/ntsb/FTW85FA176.md): Cessna 152 · Arlington, TX · Accident · Serious injuries · Field investigation · Final report · Apr 10, 1985 · N49831 · Destroyed > Acft on traffic patrol watch was observed for several minutes before crash at low altitude doing slow flt and flying erratic prior to acft stalling ans spinning into apt building no evidence of pre-impact failure or malfunction of the acft was found. - [NTSB SEA85FA082](https://openairdocs.org/ntsb/SEA85FA082.md): Cessna 172B · Smith, NV · Accident · 3 fatal · Field investigation · Final report · Apr 3, 1985 · N6923X · Destroyed > According to witnesses, the plt made multiple passes over his residence at low alt. The witnesses observed the acft in various maneuvers at low alt. One maneuver was described as a pull-up from about 100 ft to aprx 600 ft, where the acft went into a wingover… - [NTSB MKC85FA080](https://openairdocs.org/ntsb/MKC85FA080.md): Gulfstream-Schweizer G-164B · Garland, AR · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1985 · N8418K · Destroyed > The plt was beginning a spray run over a wheat field when the acft impacted the top 3 strands of a 4 strand, high voltage power line. The acft then descended uncontrolled until impact with the terrain. - [NTSB FTW85FPJ01](https://openairdocs.org/ntsb/FTW85FPJ01.md): Grumman AG CAT G-164 · Norman, OK · Accident · Serious injuries · Final report · Apr 1, 1985 · N5338 · Destroyed > The acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying. - [NTSB FTW85FA171](https://openairdocs.org/ntsb/FTW85FA171.md): Cessna T210N · Riesel, TX · Accident · 1 fatal · Field investigation · Final report · Apr 1, 1985 · N6436N · Destroyed > The acft eng had just been top overhauled and a stol kit was added. The mechanic reportedly told the plt to be 'easy' on the eng and fly the acft 45-60 mins near the traffic pattern so it could be checked for oil leaks. The plt reportedlyignored these… - [NTSB NYC85LA093](https://openairdocs.org/ntsb/NYC85LA093.md): Taylorcraft BC12-D · Orange, MA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N43871 · Substantial damage > The plt reported he was flying at about 25 ft above water. As the acft crossed over a grass covered sand bar, the gear encountered 'swail grass' & the acft was 'dragged in.' The plt also reported that the acft had encountered turbulence; however, a witness… - [NTSB LAX85LVM03](https://openairdocs.org/ntsb/LAX85LVM03.md): Bell 47G-2 · Watsonville, CA · Accident · No injuries · Final report · Mar 30, 1985 · N4227B · Destroyed > The plt stated he intended to climb over a pwr line at the end of a swath run, however, a tailwind gust was encountered and the acft could not obtain sufficient altitude to clear the line. The plt elected to fly under the line unaware of a lower line which… - [NTSB ANC85LA061](https://openairdocs.org/ntsb/ANC85LA061.md): Cessna 150C · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Mar 30, 1985 · N7866Z · Substantial damage > The pilot was on a local pleasure sightseeing trip when the engine quit; the pilot attempted a forced landing on a road. Just before touchdown the aircraft struck two power lines. The pilot stated that he ran out of fuel and he believed that he had enough… - [NTSB LAX85LA187](https://openairdocs.org/ntsb/LAX85LA187.md): Cessna 150 · Banning, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1985 · N6653G · Substantial damage > The acft collided with a power line 50 ft AGL while maneuvering over a freeway at low alt. A palm springs ATC employee who was driving his car in the eastbound lane of I-10 aprx 10 NM east of the Banning arpt, observed the accident acft on a westbound heading… - [NTSB ATL85FMG04](https://openairdocs.org/ntsb/ATL85FMG04.md): Gross Taylor Titch · Liberty, NC · Accident · 1 fatal · Final report · Mar 23, 1985 · N9438 · Destroyed > According to witnesses interviewed, pilot made a takeoff on runway 2, holding the plane just a few feet off the runway with a steep pull up at the end of the runway. It was then observed doing a steep bank, low altitude 180 degree turn and proceeded… - [NTSB DEN85FA102](https://openairdocs.org/ntsb/DEN85FA102.md): Piper PA-28-181 · Vail, CO · Accident · 2 fatal · Field investigation · Final report · Mar 22, 1985 · N8359B · Destroyed > The plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from… - [NTSB SEA85LA077](https://openairdocs.org/ntsb/SEA85LA077.md): Grumman G-164-A · Dufur, OR · Accident · No injuries · Limited investigation · Final report · Mar 17, 1985 · N5326 · Substantial damage > A loss of power occurred during aerial application and a forced landing was made onto a field. The right main gear sank into a hole and was torn off. The acft then flipped inverted. The throttle leakage was found to be broken. - [NTSB FTW85FA152](https://openairdocs.org/ntsb/FTW85FA152.md): Universal Stinson 108 · Emhouse, TX · Accident · 1 fatal · Field investigation · Final report · Mar 17, 1985 · N953D · Substantial damage > Witnesses observed the student plt making repeated low passes near his friend's house. While maneuvering, the acft collided with a power line, then crashed to the ground inverted. The student held a student plt certificate that was dated 10/17/62. No record… - [NTSB MIA85LA121](https://openairdocs.org/ntsb/MIA85LA121.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 14, 1985 · N95627 · Substantial damage > The acft collided with trees while the plt was practicing slow flt on a solo training flt. The plt stated after the accident that he diverted his attention from outside to the acft instrument panel and felt a jolt. A full pwr recovery to level flt was made… - [NTSB ANC85FA056](https://openairdocs.org/ntsb/ANC85FA056.md): Piper PA-18 · Koyukuk, AK · Accident · 1 fatal · Field investigation · Final report · Mar 14, 1985 · N62744 · Substantial damage > The plts of N62744 & three other acft were on an aerial hunting flt. Witnesses in two of the other acft stated the plt of N62744 was maneuvering near a wolverine, but was flying too fast. He announced on the radio that he was going to come back for another… - [NTSB MKC85FA069](https://openairdocs.org/ntsb/MKC85FA069.md): Cessna 150F · Waldron, MO · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1985 · N8078F · Destroyed > While maneuvering northbound on the Missouri river levee the passenger noticed the plt flying just above the levee road. The passenger stated the plt told him they were forty feet off the ground but sometimes lower. The passenger stated he saw the pickup… - [NTSB FTW85LA146](https://openairdocs.org/ntsb/FTW85LA146.md): Cessna 150G · Onalaska, TX · Accident · No injuries · Limited investigation · Final report · Mar 9, 1985 · N4767X · Destroyed > Pilot anderson was on a business type flight. He stated he lost engine power and attempted to make a forced landing. He was unable to land and collided with a electric pole then a porch railing and flipped inverted. Cause of loss of engine power not… - [NTSB CHI85LA134](https://openairdocs.org/ntsb/CHI85LA134.md): Hughes 269C · Center Village, OH · Accident · No injuries · Limited investigation · Final report · Mar 9, 1985 · N5125U · Substantial damage > While the student plt practiced hovering 8 to 12 inches AGL the heel of the right skid contacted the ground. The CFI stated he did not notice the helicopter drifting or descending but when the ground contact was felt he took over the controls. Up collective… - [NTSB ATL86FA028](https://openairdocs.org/ntsb/ATL86FA028.md): Piper PA-32-301 · Robbinsville, NC · Accident · 2 fatal · Field investigation · Final report · Mar 9, 1985 · N8470X · Destroyed > Msg acft found after 9 mos. Remains found on east side of coline ridge in graham co NC. Path of broken limbs/trees about level into mountainside. Both occupants fatal. - [NTSB ANC85FA052](https://openairdocs.org/ntsb/ANC85FA052.md): Bell 206B · Whittier, AK · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1985 · N2060V · Destroyed > The helicopter impacted terrain in a 150 ft gorge after contacting telephone lines along a railroad right-of-way aprx 2 miles north of a tunnel station. Purpose of the flt was to survey the area around the tunnel station. - [NTSB SEA85LA068](https://openairdocs.org/ntsb/SEA85LA068.md): Cessna 150F · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Mar 6, 1985 · N6812F · Substantial damage > While flying at ngt in the LCL practice area south of Nampa, the plt thought he had flown into IMC, but the wx was good. He was unable to see the ground, so he made a 180 deg turn, then noted problems seeing his instrument panel. Suspecting psbl carbon… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=207 ## 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=206 --- 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.