# 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 204 of 378 · 18,851 cases ## Cases, newest first - [NTSB NYC85FA162](https://openairdocs.org/ntsb/NYC85FA162.md): Bellanca 7GCBC · Cape May, NJ · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1985 · N1880G · No damage > The tow plane came in for a banner pickup. The ground handler holding the tail of the double banner had his left foot caught by the banner as it went airborne. The ground handler was carried 50 to 100 ft in the air prior to falling to the ground. The ground… - [NTSB MKC85LA151](https://openairdocs.org/ntsb/MKC85LA151.md): Aero Commander S2R · Paragould, AR · Accident · No injuries · Limited investigation · Final report · Jul 3, 1985 · N5543X · Substantial damage > The acft was being used in aerial application of ordram when engine failed. A hard landing resulted during the forced landing in an open fld. Investigation revealed the float needle seat ass'y backed out of the threads in the main body of the carburetor FAR… - [NTSB SEA85LA155](https://openairdocs.org/ntsb/SEA85LA155.md): Bell 47G2 · Roosevelt, WA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1985 · N11VH · Substantial damage > A total loss of power occurred while on a CFR 137 flight, due to fuel exhaustion. Although the fuel gauge showed 1/2 tank of fuel, the pilot failed to visually check the fuel prior to this flight. During autorotation onto a wheat field a hard landing occurred… - [NTSB DEN85LA177](https://openairdocs.org/ntsb/DEN85LA177.md): Grumman G-164 · Platte, SD · Accident · No injuries · Limited investigation · Final report · Jul 1, 1985 · N6674K · Substantial damage > While the plt was spraying a field, the landing gear of the acft struck the center pivot of an irrigation structure. Later, when the acft was landed, the gear collapsed. - [NTSB ANC85LA115](https://openairdocs.org/ntsb/ANC85LA115.md): Piper PA-18 · Sandy Piont, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1985 · N49512 · Substantial damage > Pilot lost control while attempting to demonstrate aerobatic flight at low altitude and crashed. - [NTSB SEA85LA154](https://openairdocs.org/ntsb/SEA85LA154.md): Cessna 150G · Asotin, WA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1985 · N3814J · Substantial damage > While maneuvering, the aircrafts engine sputtered and then quit. During forced landing on a freshly plowed field, the aircrafts nose wheel dug in and collapsed. The acircraft nosed over. The aircraft was examined by an a & p mechanic and no abnormalities… - [NTSB LAX85LA299](https://openairdocs.org/ntsb/LAX85LA299.md): Bell 206B3 · Grand Canyon, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1985 · N2766Y · Substantial damage > During a movie filming flight, the helicopter was acting as the camera platform and filming a fixed wing aircraft during a straight in appraoch to the airport, the plt of the helicopter requested a right 180 degree turn at mid field to land at the north… - [NTSB ATL85FA198](https://openairdocs.org/ntsb/ATL85FA198.md): Piper J3C-65 · Dothan, AL · Accident · Serious injuries · Field investigation · Final report · Jun 28, 1985 · N151A · Substantial damage > A witness related that she observed the acft flying low over fields and trees. She lost sight of the acft as it went around a bend in the road. When she rounded the curve she saw the acft nose down in a field with the tail pointed virtually straight up. The… - [NTSB SEA85LA152](https://openairdocs.org/ntsb/SEA85LA152.md): Piper PA-25-235 · Burns, OR · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 1985 · N6647Z · Destroyed > During aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An… - [NTSB ATL85FLT08](https://openairdocs.org/ntsb/ATL85FLT08.md): Cessna A188B · Marks, MS · Accident · Serious injuries · Final report · Jun 27, 1985 · N4905Q · Minor damage > The plt reported that while he was on an aerial application flt, a rain storm suddenly began & forced him to quickly return & land. He reported that the rain was so heavy that he could only see straight down. He contacted his ground crew & asked them to help… - [NTSB CHI85FA253](https://openairdocs.org/ntsb/CHI85FA253.md): Piper PA-28-151 · Reedsburg, WI · Accident · 2 fatal · Field investigation · Final report · Jun 26, 1985 · N32461 · Destroyed > No known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.… - [NTSB SEA85LA151](https://openairdocs.org/ntsb/SEA85LA151.md): Bell UH-1B · Hoquiam, WA · Accident · 1 fatal · Limited investigation · Final report · Jun 25, 1985 · N4991D · No damage > The helicopter was being used during an external load operation to move large blocks of wood. However, while hovering, the sling broke. Subsequently, a block of wood struck a company employee on the head while he was working on the ground. The employee was… - [NTSB SEA85LA149](https://openairdocs.org/ntsb/SEA85LA149.md): Piper PA-25-235-C · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1985 · N7396Z · Substantial damage > During an aerial applications maneuver the engine ceased operating and a forced landing was made in an orchard in between apple tree rows. Engine and aircraft inspection could not reveal any abnormalities with the exception of a very dirty, partially clogged… - [NTSB CHI85FA251](https://openairdocs.org/ntsb/CHI85FA251.md): Neumann-Everett N2 · Cambridge, MN · Accident · 1 fatal · Field investigation · Final report · Jun 24, 1985 · N2287D · Destroyed > The newly rated prt plt was on his 12th flt in the recently certificated homebuilt that he had designed and built himself. While performing an unknown maneuver both horizontal stabilizers and both wings separated from the acft. The acft was restricted from… - [NTSB ANC85FA107](https://openairdocs.org/ntsb/ANC85FA107.md): Piper PA-18 · Lake Beverley, AK · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1985 · N74963 · Substantial damage > The plt stated that he & his student plt was flying around the lake well below the tree line, & after a steep right bank the acft struck the trees & crashed in the lake, the acft sank into 10 to 12 ft of water. - [NTSB SEA85LA146](https://openairdocs.org/ntsb/SEA85LA146.md): Grumman 164B · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N6762K · Substantial damage > A partial loss of power occurred during aerial application due to a crack around one of the cylinders. While the plt was attempting to dump chemicals, the acft settled onto the ground tearing off the rt main gear. The plt then flew on to Twin Falls to land.… - [NTSB SEA85FA147](https://openairdocs.org/ntsb/SEA85FA147.md): Cessna C-177RG · Yakima, WA · Accident · 4 fatal · Field investigation · Final report · Jun 22, 1985 · N1983Q · Destroyed > The pilot, while in slow-flight configuartion, at low altitude, in light chop, failed to see and avoid trees. Resulting tree impact caused acft into stall conditions. Acft contacted other trees, crashed and burned. - [NTSB FTW85LA264](https://openairdocs.org/ntsb/FTW85LA264.md): Bellanca 7ECA · Ville Platte, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 1985 · N53958 · Destroyed > The plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,… - [NTSB FTW85LA262](https://openairdocs.org/ntsb/FTW85LA262.md): Bell 206L-1 · Ship Shoal Blk · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1985 · N1086Q · Destroyed > The pilot had landed on the offshore platform and was in the process of repositioning the helicopter to one side of the landing pad to provide additional space for another aircraft when the main rotor blades struck a 3' steel sign post. Theblade separated… - [NTSB DEN85LA173](https://openairdocs.org/ntsb/DEN85LA173.md): Grumman G-164A · Deming, NM · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N5337 · Substantial damage > The plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n… - [NTSB CHI85LA246](https://openairdocs.org/ntsb/CHI85LA246.md): Anderson Skybolt · Escanaba, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1985 · N66AA · Substantial damage > Prior to the acdnt, the acft was observed making repeated low passes over the area where it subsequently crashed. Witnesses reported that during a turning maneuver over water, the acft collided with the surface & crashed. A police officer, who responded,… - [NTSB LAX85LA287](https://openairdocs.org/ntsb/LAX85LA287.md): Cessna 152 · Filmore, CA · Accident · No injuries · Limited investigation · Final report · Jun 21, 1985 · N24338 · Destroyed > The plt flew into a canyon with the intention of turning around to back out. He then decided the canyon was too narrow for a 180 degree turn. He continued flying up the canyon while attempting to gain alt, however, the rising terrain exceeded the acft's climb… - [NTSB LAX85FA286](https://openairdocs.org/ntsb/LAX85FA286.md): Bell 214B-1 · Squaw Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1985 · N214RM · Destroyed > The helicopter was engaged in lowering a large pole to the ground when the eng failed catastrophically due to a total first turbine rotor disc failure. The plt turned the acft down the mountain but was unable to gain enough speed to autorotate. The acft… - [NTSB ATL85FA191](https://openairdocs.org/ntsb/ATL85FA191.md): Piper J5A · Cleveland, GA · Accident · 1 fatal · Field investigation · Final report · Jun 20, 1985 · N35612 · Substantial damage > The plt took off from a private strip with his 5 yr old daughter on board. He then made several low passes by a guest house so that his daughter could wave to her grandparents. The acft was last seen headed generally in a northerly direction when it banked… - [NTSB MKC85FA134](https://openairdocs.org/ntsb/MKC85FA134.md): Ryan Navion A · Kingman, KS · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1985 · N4974K · Destroyed > After departing a pvt strip the acft was observed to perform some low altitude aerobatic maneuvers. The maneuvers consisted of two snap rolls at about 100 feet off the ground. The acft was observed descending steeply on the second roll maneuver until striking… - [NTSB LAX85LA284](https://openairdocs.org/ntsb/LAX85LA284.md): Grumman G-164 · Glenn, CA · Accident · No injuries · Limited investigation · Final report · Jun 19, 1985 · N73646 · Substantial damage > During initial climb on an ag flight the plt reported experiencing a loss of eng power. From the acft's alt of 30 ft AGL the plt attempted an emergency landing but did not have sufficient alt to negotiate a turn back toward the road from which he had… - [NTSB FTW85FRD02](https://openairdocs.org/ntsb/FTW85FRD02.md): Teratorn Tierra II · Lake Charles, LA · Accident · 1 fatal · Final report · Jun 18, 1985 · N4438V · Destroyed > The acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground… - [NTSB SEA85LA140](https://openairdocs.org/ntsb/SEA85LA140.md): Cessna 188A · Pocatello, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 1985 · N5695J · Substantial damage > During aerial application the aircrafts engine ceased operating. During engine tear down it was discovered that the engine's #2 connecting rod was broken and had come through the top of the crankcase. Recommended overhaul time is 1200 hours. This engine had a… - [NTSB MKC85FA133](https://openairdocs.org/ntsb/MKC85FA133.md): Hildebrand Spezio Sport DAL-1 · Gravois Mills, MO · Accident · 2 fatal · Field investigation · Final report · Jun 17, 1985 · N1141L · Destroyed > Witnesses reported that the acft made at least two complete circles over a cove on lake of the ozarks at low alt. Part of the acft track took it over the southeast shoreline where several lake homes are located. During the third circle, as the acft approached… - [NTSB DEN85LA161](https://openairdocs.org/ntsb/DEN85LA161.md): Air Tractor AT-301 · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Jun 17, 1985 · N2312U · Substantial damage > As the plt was pulling up over a power line at the end of a spray run, the eng lost power & smoke began coming from the right side of the eng. The plt turned to land in a field, but was unable to align the acft with forrows. During a forced landing, the acft… - [NTSB MKC85FCD01](https://openairdocs.org/ntsb/MKC85FCD01.md): Joel K. Senter RV-4 · Jefferson, IA · Accident · 1 fatal · Final report · Jun 16, 1985 · N4703S · Destroyed > The acft crashed out of control after & low alt demonstration passes above rwy at about 50 ft AGL. After the last pass, a low airspeed maneuver. The plt executed a steep turn and descended in a nose low attitude to ground impact. - [NTSB FTW85LA258](https://openairdocs.org/ntsb/FTW85LA258.md): Cessna 150 · Girard, TX · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N1991Z · Substantial damage > The plt stated he had just buzzed a friend's house when the eng began running rough. He was making a precautionary landing on a country road when a wing dropped and drug on the side of the adjacent ditch. The acft spun around 180 degs,sustaining substantial… - [NTSB CHI85LA239](https://openairdocs.org/ntsb/CHI85LA239.md): Boeing A75N1 · Deckerville, MI · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N57250 · Substantial damage > Purpose of the flt was a 'flour bombing contest'. After dropping a 'flour bomb' the plt entered a right bank to avoid trees along the flt path. The acft then stalled and impacted the ground on the main gear after which it nosed over. - [NTSB MIA85FA193](https://openairdocs.org/ntsb/MIA85FA193.md): North American SNJ-5 · Stuart, FL · Accident · 2 fatal · Field investigation · Final report · Jun 15, 1985 · N988E · Destroyed > The acft was observed by witnesses flying slow at an estimated alt of 700 ft. the acft was observed to stall, enter an over the top spin which immediately evolved into an upright spin. Recovery was not executed prior to the acft crashing into the ocean.… - [NTSB DEN85LA166](https://openairdocs.org/ntsb/DEN85LA166.md): Piper PA-25 · Leonard, ND · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N4733Y · Substantial damage > During an aerial spray operation, the plt returned to a field with his 2nd chemical load. As he descended over trees to begin a swath run, he began a flare, but the acft continued descending & impacted the ground. The right landing gear was torn off & the… - [NTSB MIA85LA192](https://openairdocs.org/ntsb/MIA85LA192.md): Bell 206B · West Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1985 · N156L · 2 aircraft · Destroyed > Two helicopters had just completed a mail delivery operation as a flt of two. N159L had landed and the plt left the eng running so as to let the eng operting temp stabilize. N156L approached in a ground hover and collided with N159L. The two plts received… - [NTSB FTW85LA256](https://openairdocs.org/ntsb/FTW85LA256.md): Air Tractor AT-301 · Brownsville, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1985 · N23692 · Substantial damage > The ag acft was destroyed when it failed to pull out of an aerial application maneuver following the initial swath run over a field. The plt stated that after making his turn to return to the field, he attempted to level the acft and received no response from… - [NTSB DEN85LA163](https://openairdocs.org/ntsb/DEN85LA163.md): Cessna 152 · Sunspot, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1985 · N47822 · Destroyed > The plt was flying in the valleys of mountainous terrain. He elected to fly to the left around what appeared to be a small hill, but was actually part of a ridge line. Subsequently, the acft entered a 'draw' & would not out-climb rising terrain. The acft… - [NTSB CHI85LA244](https://openairdocs.org/ntsb/CHI85LA244.md): Cessna 150 · Mcconnelsville, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1985 · N7122F · Substantial damage > The student plt had taken the acft without authority of the owner & reportedly was using it to elude police. While flying at low alt, he attempted to pass under wires along a state hiway. However, the acft impacted an embankment in a nose low, wings level… - [NTSB SEA85FA134](https://openairdocs.org/ntsb/SEA85FA134.md): Bell UH-1B · Juneau, AK · Accident · 1 fatal · Field investigation · Final report · Jun 11, 1985 · N99676 · Destroyed > While engaged in a log slinging operation over mountainous, densely forested terrain the rotor craft suffered a total power loss forcing the pilot to execute an autorotative landing into high conifer trees. Disassembly of the engine revealed evidence that the… - [NTSB NYC85FA145](https://openairdocs.org/ntsb/NYC85FA145.md): Sikorsky S76A · Belmar, NJ · Accident · 1 fatal · Field investigation · Final report · Jun 11, 1985 · N176FJ · 2 aircraft · Substantial damage > During takeoff & landing practice for a pre-solo plt the CFI saw a helicopter, N176FJ, approaching the arpt. N4956B, at the time of 1st sighting, was on a left base for rwy 3. The rotorcraft apparently did not see N4956B or hear any radio calls at this… - [NTSB MKC85LA123](https://openairdocs.org/ntsb/MKC85LA123.md): Grumman G-164A · Paragould, AR · Accident · No injuries · Limited investigation · Final report · Jun 11, 1985 · N48523 · Destroyed > Pilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined. - [NTSB MIA85LA188](https://openairdocs.org/ntsb/MIA85LA188.md): Piper PA-38-112 · Wabasso, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1985 · N2603C · Substantial damage > The acft nosed over during a forced landing on a beach. The plt was on a solo flt to practice maneuvers. He stated that when pwr was reduced to 1500 RPM in preparation for a stall series the RPM continued to decrease to aprx 1100. He was not able to regain… - [NTSB MKC85FA124](https://openairdocs.org/ntsb/MKC85FA124.md): E.T. Meredith III Christen Eagle II · Carlisle, IA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1985 · N33ET · Destroyed > The aerobatic airplane had a total of 23.6 flight hours at the time of this accident. This accident pilot had flown 6.3 hours of that time. The aircraft log did not indicate any spin practice by this pilot in this airplane but did indicate three flights with… - [NTSB DEN85LA155](https://openairdocs.org/ntsb/DEN85LA155.md): Piper PA-25-235 · Fillmore, UT · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N7346Z · Substantial damage > The plt reported the engine failed while he was spraying a corn field, necessitating a straight ahead forced landing. During the landing roll the wheels bogged down in the soft earth and the plane overturned. Subsequent examination of theengine by the plt… - [NTSB DEN85FA153](https://openairdocs.org/ntsb/DEN85FA153.md): Piper PA-32R-300 · Melstone, MT · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1985 · N75063 · Substantial damage > The acft was observed in a left turn in a steep dive until it passed out of view behind a hill. The investigation revealed no evidence of airframe or engine malfunction or failure piror to the crash. Medical findings revealed the plt, sole occupant, had 90… - [NTSB MKC85LA125](https://openairdocs.org/ntsb/MKC85LA125.md): Snow AT301 · Marianna, AR · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N5078S · Substantial damage > After departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft… - [NTSB MIA85FA187](https://openairdocs.org/ntsb/MIA85FA187.md): Ercoupe 415-C · Daytona Beach, FL · Accident · 1 fatal · Field investigation · Final report · Jun 8, 1985 · N99018 · Destroyed > According to witnesses, the plt was flying at a very low alt & was making 's' turns while proceeding southbound along a Beach. During the last left turn toward the east, the acft turned further left toward the north. While turning, the left wing struck water… - [NTSB DEN85LA160](https://openairdocs.org/ntsb/DEN85LA160.md): Ayres S2R-600 · Gardner, CO · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N4871X · Destroyed > The ag-acft stalled & crashed during an ag operation in high density alt. The mountainous terrain and downdrafts contributed to the overall effect of dissapating the clearance between the acft & the undulating terrain. - [NTSB CHI85FA226](https://openairdocs.org/ntsb/CHI85FA226.md): Schweizer G-164A · Red Lake Falls, MN · Accident · 1 fatal · Field investigation · Final report · Jun 8, 1985 · N6761Q · Destroyed > The plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=205 ## 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=204 --- 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.