# 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 201 of 378 · 18,851 cases ## Cases, newest first - [NTSB LAX86FA004](https://openairdocs.org/ntsb/LAX86FA004.md): Cessna T210L · Lebec, CA · Accident · 4 fatal · Field investigation · Final report · Oct 6, 1985 · N29158 · Destroyed > The acft contacted trees and the terrain in an uncontrolled descent and was destroyed by impact and an ensuing fire. The acft's left elevator was not located during the post accident inspection. Witnesses reported seeing the acft flying low (50 ft AGL) and… - [NTSB LAX86FA002](https://openairdocs.org/ntsb/LAX86FA002.md): Piper PA-38-112 · Paradise, CA · Accident · 2 fatal · Field investigation · Final report · Oct 6, 1985 · N24126 · Destroyed > After takeoff, for an aflight orentation, the high time (over 2 4000 flt hours) pilot descended to an altitude of approx. 300 over a lake. The pilot was then flying up a twisting arm of the lake, in mountainous terrain into unmarked electrical transmission… - [NTSB MIA86LA004](https://openairdocs.org/ntsb/MIA86LA004.md): Bell 206L · Islamorada, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1985 · N60C · Substantial damage > Aircraft was ditched in the atlantic ocean after loss of engine power. Post crash inspection of the engine after recovery from the ocean revealed thje pc or compressor pressure air line had failed at a 'b' nut at the compressor schroll. With this line failed… - [NTSB ANC86LA001](https://openairdocs.org/ntsb/ANC86LA001.md): Champion Citabria 7GCBC · Ptarmigan Pass, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 1985 · N90921 · Substantial damage > The pilot-in-command stated that just after departure. He spotted a moose and made a low circle above the moose. He leveled off and attempted to pull the aircraft up. The nose of the aircraft pitched down and the airplane crashed to the ground. - [NTSB DEN86FA002](https://openairdocs.org/ntsb/DEN86FA002.md): Piper PA-18-150 · Chamberlain, SD · Accident · 2 fatal · Field investigation · Final report · Oct 3, 1985 · N40359 · Destroyed > The plt and his passenger friend were looking for stray cattle when aprx at 142 ft above the ground their acft struck an antennae mounted on a microwave tower. The acft descended and was destroyed on ground impact. - [NTSB SEA85FA228](https://openairdocs.org/ntsb/SEA85FA228.md): Teratorn Tierra II · Post Falls, ID · Accident · 2 fatal · Field investigation · Final report · Sep 29, 1985 · UNREG · Destroyed > The acft contacted the terrain in an uncontrolled descent following an inflt separation of the left wing. A witness stated the left wing separated as the acft was being maneuvered in a race track pattern using bank angles of 45 degs. The wife of the acft… - [NTSB NYC85LA250](https://openairdocs.org/ntsb/NYC85LA250.md): Cessna 152 · Galway, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1985 · N6120M · Substantial damage > Student plt was practicing maneuvers at 3000 ft when acft eng failed. The plt made a forced landing in a field. The tallgrass in field caused the landing gear to fail and substantially damaged the acft during the landing roll. NTSB metallurgist report shows… - [NTSB FTW85LA359](https://openairdocs.org/ntsb/FTW85LA359.md): Piper PA-28-R · Mount Vernon, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1985 · N7554J · Substantial damage > The pilot reported he ran out of gas maneuvering under an overcast to find a suitable landing site. He had attempted to circumnavigate a large area of severe weather but exhausted his fuel supply. He stated that the engine quit and he stalled the aircraft at… - [NTSB LAX85FA402](https://openairdocs.org/ntsb/LAX85FA402.md): Aerospatiale AS350D · Kula, HI · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1985 · N4268V · Substantial damage > The helicopter collided with terrain while on a sightseeing tour. The plt stated that the helicopter lost alt as he attempted to cross power lines. Directional control was lost during the ensuing down wind emergency landing. The helicopter contacted the… - [NTSB NYC85LA248](https://openairdocs.org/ntsb/NYC85LA248.md): Grumman American AA-1B · Hamburg, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1985 · N2640R · Substantial damage > The plt stated that he started a maneuver at 2700 ft. the maneuver was a dive after reducing pwr followed by a climb with a left turn at the top followed by a descending left turn. The turn 'at the top' was uncoordinated and g forces occurred. Throttle… - [NTSB CHI85FA383](https://openairdocs.org/ntsb/CHI85FA383.md): Cessna 150L · Hillsboro, OH · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1985 · N21903 · Destroyed > The acft was being flown by a plt who's company takes low alt photos of farms for later resale. This is accomplished with hand-held 35MM cameras from the right seat. According to the single witness to the accident, the acft was first sighted flying 'low and… - [NTSB NYC85FHJ06](https://openairdocs.org/ntsb/NYC85FHJ06.md): Robinson R-22 · Ronkonkoma, NY · Accident · Serious injuries · Final report · Sep 19, 1985 · N90716 · Destroyed > While hovering student pilot applied aft cyclic and the flt instructor could not regain control before tail rotor struck the taxiway. Helicopter rotated violently and rolled over and to rest on the skids. The helicopter was destroyed. - [NTSB SEA85FA217](https://openairdocs.org/ntsb/SEA85FA217.md): Ercoupe 415-C · Orchards, WA · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1985 · N93848 · Destroyed > The pvt plt was observed executing a wings level pull-up from a dive during which, the witness reported, the wing tips began fluttering. Immediately thereafter, both wings separated in positive overload. Visual meteorological conditions existed in the area of… - [NTSB CHI85FER02](https://openairdocs.org/ntsb/CHI85FER02.md): Grumman 164A · Becker, MN · Accident · No injuries · Final report · Sep 18, 1985 · N48405 · Substantial damage > The plt reported the eng pwr dropped from 2000 to 1550 RPM during the aerial application flt. The plt increased throttleand advanced the prop with no increase in pwr. The acft then settled to ground impact and nosed over. Post accident inspection disclosed… - [NTSB LAX85LA393](https://openairdocs.org/ntsb/LAX85LA393.md): Pitts S-2A · Carlsbad, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 17, 1985 · N13AS · Destroyed > After completing an upright spin over the pacific ocean during the filming of a movie viewed from the spinning acft, the plt climbed his acft back to the entry alt and entered a flat inverted spin. The acft was observed to spin through its recovery alt at… - [NTSB DEN85FA241](https://openairdocs.org/ntsb/DEN85FA241.md): Aerospatiale SA315B · Craig, CO · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1985 · N3836E · Destroyed > The helicopter was long-lining a 1280-pound air compressor to an 8500-foot MSL mountain drilling site. Witnesses heard a squealing sound and bang. They observed gray-white smoke and orange-blue flame emitting from the exhaust. The plt released the load and… - [NTSB ATL85FA276](https://openairdocs.org/ntsb/ATL85FA276.md): Laux Pitts S-1S · Paducah, KY · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1985 · N30BL · Destroyed > The aircraft was observed in the local area for several minutes. It was perfoming aerobatic maneuvers. One witness reported that it was lower than it usually was when it was perfoming these maneuvers. It was observed to do an inside loop, roll inverted and… - [NTSB FTW85LA348](https://openairdocs.org/ntsb/FTW85LA348.md): Cessna A185F · Catahoula, LA · Accident · 1 fatal · Limited investigation · Final report · Sep 13, 1985 · N333WL · Destroyed > The plt took off from a bayou with inadequate distance to climb above the trees growing along each side before the bayou made an aprx 120-DEG right turn. In order to avoid collision with the trees the plt entered a steep banked right turn to follow the bayou.… - [NTSB MKC85FA213](https://openairdocs.org/ntsb/MKC85FA213.md): Piper PA-28-180 · Hoskins, NE · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1985 · N15970 · Destroyed > This accident occurred on a telephone cable patrl flt. The acft would normally fly along the route of the buried cable at 200 to 300 ft AGL. When construction activity was sighted the plt would first record the sighting on a portable tape recorder and then… - [NTSB MIA85LKG06](https://openairdocs.org/ntsb/MIA85LKG06.md): Cessna A188B · Bascom, FL · Accident · Serious injuries · Final report · Sep 10, 1985 · N9742G · Destroyed > The acft collided with a pecan tree during a spray operation the plt said he should have been more attentive to the operation of the acft and the environment. - [NTSB ATL85FA272](https://openairdocs.org/ntsb/ATL85FA272.md): MBB BK-117A-1 · Aiken, SC · Accident · Serious injuries · Field investigation · Final report · Sep 9, 1985 · N117SR · Substantial damage > Plt was maneuvering helicopter at low alt and into rising terrain. On 3rd right turn racetrack pattern, witnesses observed acft descend slightly, roll into a 45 deg or greater bank and contact trees. The acft started a yawing rotation to the right and… - [NTSB CHI85FEV03](https://openairdocs.org/ntsb/CHI85FEV03.md): Cessna 172 · Sweetwater, IL · Accident · 1 fatal · Final report · Sep 8, 1985 · N6236E · Destroyed > The acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She… - [NTSB ANC85LAG03](https://openairdocs.org/ntsb/ANC85LAG03.md): Taylorcraft 19 · Anchorage, AK · Accident · No injuries · Final report · Sep 8, 1985 · N3588T · Substantial damage > The pilot stated that after he recovered from the spiral theaircraft struck the tree tops. At the time of the accident the weather was below VFR. - [NTSB SEA85FA208](https://openairdocs.org/ntsb/SEA85FA208.md): Piper PA-25-235 · Wenatchee, WA · Accident · 1 fatal · Field investigation · Final report · Sep 7, 1985 · N7340Z · Destroyed > After two application runs, plt apparently attempted to shorten the race-track pattern by initiating the inbound turn into a canyon. Acft was observed to climb clear of the canyon wall near completion of turn, but load was jettisoned at this point and the… - [NTSB ATL85LA269](https://openairdocs.org/ntsb/ATL85LA269.md): Grumman G-164A · Tunica, MS · Accident · No injuries · Limited investigation · Final report · Sep 6, 1985 · N9893 · Substantial damage > The plt stated that during aerial application maneuver he allowed the airspeed to get too low and the acft settled into a soy bean field. The left wing contacted the crop and the acft cartwheeled. - [NTSB ATL85FLT10](https://openairdocs.org/ntsb/ATL85FLT10.md): Aeronca 7AC · Mcewen, TN · Accident · Serious injuries · Final report · Sep 6, 1985 · N83053 · Destroyed > The plt stated the acft stalled during a turn at an alt between 200 and 300 ft AGL. Recovery was not accomplished prior to the acft impacting the terrain. - [NTSB DEN85LTG08](https://openairdocs.org/ntsb/DEN85LTG08.md): Piper PA-28-140 · Underwood, ND · Accident · Minor injuries · Final report · Sep 5, 1985 · N8864N · Substantial damage > The acft nosed over during a forced landing following a loss of pwr. The plt stated he was practicing slow flt on the return flt from picking the acft up after an annual inspection. As the acft slowed to 90 mph during slow flt, the plt attempted to increase… - [NTSB DEN85FA236](https://openairdocs.org/ntsb/DEN85FA236.md): Piper PA-28RT-201T · Saint Mary, MT · Accident · 2 fatal · Field investigation · Final report · Sep 5, 1985 · CGTGV · Destroyed > Plt received wx update enroute to kalispell, MT. He attempted to navigate through the glacier national park, following the 'going-to-the-sun' highway. The wx along the plt's route of flt included low cloud ceiling, limited visibility and mountain obscurement.… - [NTSB ATL85LKG09](https://openairdocs.org/ntsb/ATL85LKG09.md): Grumman G-164 · Opp, AL · Accident · No injuries · Final report · Sep 5, 1985 · N598Y · Substantial damage > The plt reported that during a pull-up and turnaround at the end of a swath run, the eng gave off smoke and lost pwr. The plt dumped the chemical load and performed a forced landing in a fld which contained 6 to 8 ft tall vegetation. The acft travelled aprx… - [NTSB ANC85LAA02](https://openairdocs.org/ntsb/ANC85LAA02.md): Piper PA-18 · Fairbanks, AK · Accident · No injuries · Final report · Sep 5, 1985 · N3839Z · Destroyed > The plt stated that while making a loss pass over a gravel area, he experienced violent sinking due to wind shear. The plt reported the winds were from 240 degs at 25 KTS gusting to 35 KTS. - [NTSB ANC85LAG02](https://openairdocs.org/ntsb/ANC85LAG02.md): Piper PA-18 · Kodiak, AK · Accident · Minor injuries · Final report · Sep 4, 1985 · N9919D · Substantial damage > The plt stated that he entered a small canyon with a ridge line at the end which he would have to cross. As the plt continued into the canyon he had insufficient alt to clear the ridge. The acft stalled and struck the side of the mountian ridge. - [NTSB MKC85LA204](https://openairdocs.org/ntsb/MKC85LA204.md): Grumman AA5 · Boone, IA · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1985 · N16LB · Substantial damage > After departing laporte city airport the plt of the acft proceeded to his destination airport despite deteriorating weather conditions at this destination. The plt stated he should not have proceeded into poor weather conditions. Weather conditions at the… - [NTSB LAX85LA394](https://openairdocs.org/ntsb/LAX85LA394.md): Glasflugel ST Liebelle 201B · California City, CA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1985 · N711DP · Substantial damage > The glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt. - [NTSB MKC85LA201](https://openairdocs.org/ntsb/MKC85LA201.md): Piper PA-24-250 · Weskan, KS · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N6903P · Substantial damage > The plt rptd a high eng oil temperature & low oil pressure while maneuvering over a siesmic operation site in west Kansas. The acft was substantially damaged when it contacted a ditch during a forced landing. Post accident inspection failed to disclose any… - [NTSB MKC85FA199](https://openairdocs.org/ntsb/MKC85FA199.md): Aeronca 7AC · Bridgeton, MO · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1985 · N2560E · Destroyed > A witness observed the acft flying in an easterly direction at an alt of 200 to 300 ft AGL. The acft then made a 180 deg turn to a westerly heading. After flying a distance of aprx 2000 ft, the acft entered a left turn and dove into a squash fld. Post… - [NTSB LAX85FA376](https://openairdocs.org/ntsb/LAX85FA376.md): Cessna T303 · Simi Valley, CA · Accident · Serious injuries · Field investigation · Final report · Aug 31, 1985 · N6490V · Destroyed > The acft collided with trees during a forced landing following a loss of pwr. The student plt stated the flt was normal until a 'violent right yaw' developed when the trottles were advanced to recover from a practice stall. As the CFI took over the controls… - [NTSB FTW85LRA04](https://openairdocs.org/ntsb/FTW85LRA04.md): Rockwell S2R-600 · Rosharon, TX · Accident · Minor injuries · Final report · Aug 30, 1985 · N4012P · Substantial damage > The plt reported the acft contacted the ground after the left boom caught weeds during a spray run. - [NTSB FTW85LA340](https://openairdocs.org/ntsb/FTW85LA340.md): Cessna L-19E · Palo Pinto, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 30, 1985 · N3255X · Destroyed > The acft was reported by witnesses to have been flying very low over a lake just prior to accident. The acft collided with pwr lines after passing over a dam and was destroyed on ground impact. The plt reported a loss pwr was experienced. The eng was test run… - [NTSB CHI85LA363](https://openairdocs.org/ntsb/CHI85LA363.md): Callair A-9 · Hollandale, MN · Accident · No injuries · Limited investigation · Final report · Aug 30, 1985 · N8273H · Substantial damage > During a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft… - [NTSB ATL85FA278](https://openairdocs.org/ntsb/ATL85FA278.md): Bellanca 8KCAB · Proctor, WV · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1985 · N4195Y · Substantial damage > The acft was artd msg and was the object of a search from 9-1-85 to 9-12-85. Acft found in remote area of mtns and dense woods by man on foot hunting ginseng on 9-16-85.ND witnesses found. Residents in area reported rain all day on 8-30-85 and it was heavy at… - [NTSB FTW85FQG03](https://openairdocs.org/ntsb/FTW85FQG03.md): Piper PA-25-235 · Morton, TX · Accident · 1 fatal · Final report · Aug 29, 1985 · N4708Y · Destroyed > After the plt completed a swath run, the acft entered a rgt climbing maneuver, then rolled wings level. After that, it reportedly began an abrupt climb for aprx 50 to 60 ft, then nosed down & crashed in a steep descent. After impact, the acft was destroyed by… - [NTSB CHI85LA360](https://openairdocs.org/ntsb/CHI85LA360.md): Schweizer G164A "450" · Constantine, MI · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N8444K · Substantial damage > The acft nosed over during a forced landing in a corn fld. The plt stated that at 30 ft AGL during his second swath run the eng backfired and lost pwr. He attempted to dump the load however, the acft continued to loose alt and the forced landing resulted.… - [NTSB FTW85LA336](https://openairdocs.org/ntsb/FTW85LA336.md): Beech A36 · Conroe, TX · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N6564D · Substantial damage > Acft was substantially damaged during an off-arpt emergency landing following an eng failure. During landing roll acft collided with a fence and the gear collapsed. Investigation revealed about 13 gallons of fuel in right fuel tank and none in the left tank.… - [NTSB FTW85FA335](https://openairdocs.org/ntsb/FTW85FA335.md): North American British Harvard Mkii · Ada, OK · Accident · 2 fatal · Field investigation · Final report · Aug 28, 1985 · N711XX · Destroyed > Two fully qualified single engine plts were in the acft at the time of the accidnet. The acft was observed making low passes near the airport after takeoff. One plt's mother lived near the accident site. The acft was in a steep banked right turn when the… - [NTSB LAX85LA374](https://openairdocs.org/ntsb/LAX85LA374.md): Air Tractor AT301 · Williams Afb, AZ · Accident · No injuries · Limited investigation · Final report · Aug 27, 1985 · N3168U · Substantial damage > After making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them. - [NTSB MIA85FA239](https://openairdocs.org/ntsb/MIA85FA239.md): Silvaire Luscombe 8E · Ocala, FL · Accident · 2 fatal · Field investigation · Final report · Aug 26, 1985 · N47BM · Destroyed > The acft was observed to take off, make a steep turn, a few seconds later, at an altitude of about 200 ft AGL, enter another steep turn and spin into the ground. Witnesses report that the pilot exhibited lack of control coordination while performing turns in… - [NTSB LAX85FJA06](https://openairdocs.org/ntsb/LAX85FJA06.md): Emroth Emair MA-1B · Pahala, HI · Accident · 1 fatal · Final report · Aug 26, 1985 · N1012Y · Destroyed > Witnesses reported seeing pieces of wood and fabric coming off the acft during it's second swath run. At the end of the run, the acft climbed abruptly to clear trees after which it entered an uncontrolled descent to ground impact. The acft was destroyed by… - [NTSB NYC85FA219](https://openairdocs.org/ntsb/NYC85FA219.md): Cessna 150L · Lewiston, NY · Accident · 1 fatal · Field investigation · Final report · Aug 25, 1985 · N18717 · Destroyed > Witnesses reported seeing the acft circling at low altitudes up to 30 minutes prior to the accident. One witness stated the plt appeared to be performing power stalls at an alt of aprx 500 ft AGL. The acft then entered a spin and descended to ground impact.… - [NTSB CHI85FA357](https://openairdocs.org/ntsb/CHI85FA357.md): Piper PA-28-235 · Worthington, MN · Accident · 2 fatal · Field investigation · Final report · Aug 25, 1985 · N8571W · Destroyed > The acft had progreesed 16 miles on a 95 mile x-country flt when it was witnessed in low flt over a corn fld. The acft was about 200 ft AGL when it entered a descending right power on turn until ground impact. An autopsy report on the plt disclosed,… - [NTSB ATL85LA259](https://openairdocs.org/ntsb/ATL85LA259.md): Hughes 269C · Elizabethtown, KY · Accident · No injuries · Limited investigation · Final report · Aug 25, 1985 · N9280F · Substantial damage > After takeoff from off airport landing zone, the acft encountered heavy raninshowers and the plt attempted to return to the landing zone. Visibility was such that the plt was unable to see the ground and the tailrotor contacted a lake adjacent to the landing… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=202 ## 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=201 --- 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.