# 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 214 of 377 · 18,850 cases ## Cases, newest first - [NTSB MIA84LA180](https://openairdocs.org/ntsb/MIA84LA180.md): Cessna 172N · Cocoa Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1984 · N2493E · Substantial damage > The plt was flying low & dropping leaflets in the vicinity of a graduation crowd at a high school. During a maneuvering turn, the acft fell 'from the sky' & crashed in a canal. According to witnesses, the acft was 'low & slow' when it started to turn prior to… - [NTSB NYC84LA204](https://openairdocs.org/ntsb/NYC84LA204.md): Hughes 500D · Bedford, PA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N5106Y · Substantial damage > According to the plt, the helicopter took off with under 200 lbs of fuel indicating on the fuel gage. Fifteen minutes after takeoff at 125 ft AGL the engine out warning system indicated an engine failure. The acft began to rotate about its vetical axis and… - [NTSB MIA84LA179](https://openairdocs.org/ntsb/MIA84LA179.md): Bell 47G-5 · Jupiter, FL · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N1201W · Substantial damage > The acft crashed landed after a partial loss of power. During an exam of the eng, the compressor bleed control valve was found stuck open causing an improper fuel/air mixture. - [NTSB MKC84LA158](https://openairdocs.org/ntsb/MKC84LA158.md): Schweizer G164B · Ellinwood, KS · Accident · No injuries · Limited investigation · Final report · Jun 3, 1984 · N6618Q · Substantial damage > While the plt was spraying a field of soybeans, the right main gear of the acft hit an irrigation sys that he had been crossing. The right main gear was torn off, but the acft continued to fly. During the landing on a sod arpt, the prop dug in & the acft… - [NTSB NYC84FGM04](https://openairdocs.org/ntsb/NYC84FGM04.md): Hiller UH-12E · Sigel, PA · Accident · No injuries · Final report · Jun 2, 1984 · N109EH · Substantial damage > The plt was on an aerial application flt over a wooded area. According to him, he had a tail rotor problem & it was necessary to extend his glide to reach an open area. Subsequently, the helicopter landed hard & the main rotor blades struck & severed the tail… - [NTSB MKC84LA159](https://openairdocs.org/ntsb/MKC84LA159.md): Cessna A188B · Campbell, NE · Accident · No injuries · Limited investigation · Final report · Jun 2, 1984 · N70042 · Substantial damage > During a forced landing in a milo field, the spray bar caught in the crop, causing the acft to pitch nose down before coming to a stop, damaging the wings and propeller. - [NTSB LAX84LA336](https://openairdocs.org/ntsb/LAX84LA336.md): Starduster II · Half Moon Bay, CA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1984 · N19PS · Substantial damage > The plt said he encountered wind shear at 700 ft AGL, lost control & landed in a field. The plt subsequently walked to a friend's house next to the field to report the occurrence. - [NTSB LAX84LA329](https://openairdocs.org/ntsb/LAX84LA329.md): Bell 206 · Allegheny, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 2, 1984 · N9722R · Substantial damage > The plt was delivering supplies from a mountain site to a river work site. He stated that on his 10th & last flt, the wind caused the helicopter & external load combination to shift laterally. At that time, the load/line became entangled in a tree. The… - [NTSB ATL84LA192](https://openairdocs.org/ntsb/ATL84LA192.md): Bellanca 7GCBC · Tunica, MS · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 1984 · N4211Y · Substantial damage > The non-rated plt stated that during a local flt, he flew over a water well drilling operation to survey the area. He reported that he circled at 500 ft 'indicate'. After surveying the area, he initiated a climb, but the eng lost power. Shortly after that,… - [NTSB ANC84FA080](https://openairdocs.org/ntsb/ANC84FA080.md): Cessna 180G · Tyonek, AK · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1984 · N4708U · 2 aircraft · Destroyed > Taking off from an abandoned road near a fishing camp, the Cessna turned back and descended with power on over his departure point, heading into the sun which was low on the horizon. It collided left wing to left wing with the Maule which had climbed out at a… - [NTSB FTW84LA263](https://openairdocs.org/ntsb/FTW84LA263.md): Rockwell A-9B · Maringouin, LA · Accident · 1 fatal · Limited investigation · Final report · Jun 1, 1984 · N7252V · Destroyed > The plt was completing the first swath pass attempting to fly under a power line and between a tree and parked farm equipment. In a slight left turn under the power line, the right wing contacted tree tops aprx 30 ft AGL. The acft continued aprx 150 yards… - [NTSB MKC84FA155](https://openairdocs.org/ntsb/MKC84FA155.md): Piper PA-38-112 · Hills, IA · Accident · 1 fatal · Field investigation · Final report · May 31, 1984 · N2364D · Destroyed > The acft impacted the ground in a 90 degree bank with the nose down about 20 degrees. The acft had been seen in a seriesof low alt dives and climbs. On this last climb over the trees a witness saw a wing suddenly drop and the acft disappear behind the trees.… - [NTSB FTW84LA257](https://openairdocs.org/ntsb/FTW84LA257.md): Cessna A188B · Ripley, OK · Accident · Minor injuries · Limited investigation · Final report · May 31, 1984 · N731KU · Substantial damage > Acft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed. - [NTSB MKC84LA154](https://openairdocs.org/ntsb/MKC84LA154.md): Grumman G-164A · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · May 30, 1984 · N937X · Substantial damage > While the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over. - [NTSB MKC84LA153](https://openairdocs.org/ntsb/MKC84LA153.md): Hiller 12E · Bedford, IA · Accident · Minor injuries · Limited investigation · Final report · May 29, 1984 · N2726C · Substantial damage > The plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft… - [NTSB DEN84FU006](https://openairdocs.org/ntsb/DEN84FU006.md): Weedhopper B · Beresford, SD · Accident · 1 fatal · Final report · May 29, 1984 · UNREG · Destroyed > The ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were… - [NTSB ANC84FA078](https://openairdocs.org/ntsb/ANC84FA078.md): Cessna 150L · Nome, AK · Accident · 3 fatal · Field investigation · Final report · May 29, 1984 · N17024 · Destroyed > Numerous witnesses observed the acft flying at low alt & behaving in an erratic manner. According to 3 witnesses, the plt buzzed persons fishing on a local river, an occupied roadhouse & vehicles on 2 roadways. Subsequently, the acft crashed on soft terrain… - [NTSB MIA84FU005](https://openairdocs.org/ntsb/MIA84FU005.md): Eipper Quicksilver GT · Lithia, FL · Accident · 1 fatal · Final report · May 28, 1984 · UNREG · Destroyed > The ultralight crashed in the backyard of a friends house as the plt circled at low alt while waving and shouting to be seen. The acft appeared to witnesses to stall before falling on the right wing to the ground from about 50 ft AGL. The engine continued to… - [NTSB LAX84LA326](https://openairdocs.org/ntsb/LAX84LA326.md): Aerotek Pitts Special S-1S · Piru, CA · Accident · No injuries · Limited investigation · Final report · May 28, 1984 · N608BC · Substantial damage > Plt was performing aerobatic manuevers in a designated practice area at an altitude of 2500 ft AGL. The plt stated that he performed a 'tail slide' maneuver and the engine stopped which 'is a normal engine response for the maneuver.' The plt was unable to… - [NTSB LAX84LA318](https://openairdocs.org/ntsb/LAX84LA318.md): Bell 47G-2 · Woodland, CA · Accident · Minor injuries · Limited investigation · Final report · May 28, 1984 · N94218 · Destroyed > According to the plt, the acft encountered a local whirlwind during a 90/270 ag maneuver & crashed. - [NTSB MKC84FA147](https://openairdocs.org/ntsb/MKC84FA147.md): Hughes 369D · Kearney, NE · Accident · 1 fatal · Field investigation · Final report · May 27, 1984 · N5102Z · Substantial damage > During return to arpt from a local flight, the plt diverted to observe property of a personal friend, located along a river bank. The plt was making a right turn about 200 ft AGL at 40 to 50 KTS airspeed when vibration was felt in the anti-torque pedals & the… - [NTSB FTW84FA244](https://openairdocs.org/ntsb/FTW84FA244.md): Bell 206B · San Antonio, TX · Accident · Serious injuries · Field investigation · Final report · May 27, 1984 · N102CD · Destroyed > In a left orbit the helicopter yawed right and continued the right rotation to impact. At the time of the loss of control the acft was operating out of ground effect at 250 ft AGL with a density alt of 3751 ft and an indicated airspeed of 20 to 25 KTS. The… - [NTSB LAX84FA315](https://openairdocs.org/ntsb/LAX84FA315.md): Bölkow Phoebus A-1 · Llano, CA · Accident · Serious injuries · Field investigation · Final report · May 26, 1984 · N7700 · Destroyed > Circling in lift near a high ridge the sailplane encountered what the plt referred to as wind shear. Losing control, the sailplane collided with a tree before impacting the ground. - [NTSB FTW84LA253](https://openairdocs.org/ntsb/FTW84LA253.md): Grumman G-164A · Kinder, LA · Accident · No injuries · Limited investigation · Final report · May 26, 1984 · N9693 · Substantial damage > The plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was… - [NTSB DEN84FA161](https://openairdocs.org/ntsb/DEN84FA161.md): Let L-13 · Edgewood, NM · Accident · 1 fatal · Field investigation · Final report · May 26, 1984 · N48032 · Destroyed > Witnesses reported that the acft appeared to be too high, too fast, and in a crab as it approached the rwy. Over the rwy the glider was observed to roll into a right turn as the nose came up. Shortly thereafter the right wing struck 3 parked acft and collided… - [NTSB ATL84LA186](https://openairdocs.org/ntsb/ATL84LA186.md): Bellanca 8KCAB · New Bern, NC · Accident · No injuries · Limited investigation · Final report · May 26, 1984 · N5030J · Substantial damage > The plt was performing a low level fly-by simulating an inexperienced flyers erratic maneuvers when the acft fell vertically to the ground and bounced into a fence before it came to rest in a field. The plt said he hit a down draft at a tree line. The fly-by… - [NTSB MKC84FA146](https://openairdocs.org/ntsb/MKC84FA146.md): Cessna 150H · Camdenton, MO · Accident · 2 fatal · Field investigation · Final report · May 25, 1984 · N7192S · Destroyed > Witnesses observed the acft flying low over a lake. As it approach the home of the plt's parents, the acft's wings moved as though waving, then the acft entered a steep climb. After reaching its maximum height from the pull-up, the acft rolled into a steep… - [NTSB ATL84FA183](https://openairdocs.org/ntsb/ATL84FA183.md): Cessna 152 · Piedmont, AL · Accident · Serious injuries · Field investigation · Final report · May 24, 1984 · N48767 · Substantial damage > The plt reported that prior to flying, he had 2 mixed drinks which contained alcoholic beverage. The flt originated at talledega, AL. The plt then flew to anniston, AL, where he landed. From there he flew to jacksonville & centre, where he made touch-&-go… - [NTSB MKC84LA144](https://openairdocs.org/ntsb/MKC84LA144.md): Enstrom F-28C · Louisville, NE · Accident · No injuries · Limited investigation · Final report · May 23, 1984 · N51792 · Substantial damage > According to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over. - [NTSB MKC84LA143](https://openairdocs.org/ntsb/MKC84LA143.md): Grumman G-164B · Silver Creek, NE · Accident · No injuries · Limited investigation · Final report · May 23, 1984 · N6677Q · Substantial damage > The plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision. - [NTSB MIA84FA170](https://openairdocs.org/ntsb/MIA84FA170.md): Piper PA-38-112 · St.Petersburg, FL · Accident · 2 fatal · Field investigation · Final report · May 23, 1984 · N2552A · Destroyed > According to witnesses, the plt did at least one complete roll prior to the accident. They stated that after rolling at about 100 ft above the water & parallel to the beach, the acft appeared to bank very steeply to the left, then pitch down into the water.… - [NTSB LAX84LA311](https://openairdocs.org/ntsb/LAX84LA311.md): Grumman G-164A · Williams, CA · Accident · No injuries · Limited investigation · Final report · May 23, 1984 · N5368 · Substantial damage > Shortly after departing the airfield, the eng lost power & the plt was unable to restart it. He landed in a soft, freshly plowed field. After rolling about 50 ft, the acft nosed over. An exam revealed that the shaft which holds the float assembly in the… - [NTSB NYC84FA180](https://openairdocs.org/ntsb/NYC84FA180.md): Beech D-45 · Taunton, MA · Accident · 1 fatal · Field investigation · Final report · May 22, 1984 · N812Z · Destroyed > N812Z crashed in a wooded area about one mile southeast of the Taunton municipal airport. Witnesses in the area observed the acft prior to the crash. One witness saw what appeared to be yellow smoke coming from the bottom of the acft. Some of the witnesses… - [NTSB LAX84LA313](https://openairdocs.org/ntsb/LAX84LA313.md): Cessna 172N · Ballard, CA · Accident · No injuries · Limited investigation · Final report · May 22, 1984 · N73857 · 2 aircraft · Minor damage > The pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of… - [NTSB ATL84LA182](https://openairdocs.org/ntsb/ATL84LA182.md): Cessna 152 · Jacksonville, AL · Accident · Minor injuries · Limited investigation · Final report · May 22, 1984 · N46910 · Substantial damage > According to the instructor (CFI), he & the student were practicing base-to-final turns as they were returning to the arpt. He reported that the acft was flown at about 60 KTS with 20 deg of flaps at appx 800 ft AGL. He stated that the student steepened the… - [NTSB ANC84FA074](https://openairdocs.org/ntsb/ANC84FA074.md): Piper PA-18 · Sleetmute, AK · Accident · 2 fatal · Field investigation · Final report · May 22, 1984 · N1378C · Substantial damage > According to witnesses, the plt made 3 low passes at some boats in Sleetmute slough. They estimated the passes were at 5 to 10 ft above the water, then the plt would pull up in a steep climb attitude, execute a 180 deg turn and make another pass. After the… - [NTSB ANC84FA073](https://openairdocs.org/ntsb/ANC84FA073.md): Piper PA-18-150 · Platinum, AK · Accident · 2 fatal · Field investigation · Final report · May 21, 1984 · N82454 · 2 aircraft · Destroyed > The herring season was to open at 1600 hrs. According to witnesses, about 30 acft were circling in left turns over merging schools of herring while the plts & their respective boat crews were awaiting the opening signal. The acft were circling under a low… - [NTSB LAX84LA303](https://openairdocs.org/ntsb/LAX84LA303.md): Piper PA-32RT-300 · Avalon, CA · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N30298 · Substantial damage > The plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the… - [NTSB DEN84FU005](https://openairdocs.org/ntsb/DEN84FU005.md): Eipper Quicksilver MX · Peyton, CO · Accident · 1 fatal · Final report · May 20, 1984 · UNREG · Destroyed > The ultralight was flying in formation with 2 other craft. The accident plt was seen by one of the other two plts to descend to a low alt over a creek bed and then pull up abrultly to climb over a power line. The landing gear collided with the wires and the… - [NTSB CHI84LA184](https://openairdocs.org/ntsb/CHI84LA184.md): Bell 47D1 · Alpena, MI · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N9158R · Destroyed > Prior to the accident, the owner/plt of the helicopter reportedly 'buzzed' a local baseball game. Shortly after that, the helicopter was observed to maneuver over a wooded area, enter a nose high attitude, then roll or bank & enter a descent into a wooded… - [NTSB SEA84FA110](https://openairdocs.org/ntsb/SEA84FA110.md): Rockwell S-2R · American Falls, ID · Accident · 1 fatal · Field investigation · Final report · May 19, 1984 · N4865X · Substantial damage > The load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither… - [NTSB NYC84FIG02](https://openairdocs.org/ntsb/NYC84FIG02.md): Cessna 172 · Elkton, MD · Accident · Serious injuries · Final report · May 19, 1984 · N8323B · Substantial damage > The acft was flown over the field at low alt in an attempt to pick up an AD banner. The acft had dived in a shallow angle from 300 ft to perform the pick-up. The banner was missed by the plt who climbed away in a steep ascent until he entered a hammerhead… - [NTSB LAX84FU028](https://openairdocs.org/ntsb/LAX84FU028.md): Pioneer FLT Star · Elk Grove, CA · Accident · Serious injuries · Final report · May 19, 1984 · UNREG · Substantial damage > The ultralight was on a solo training flt when the engine stopped as the vehicle passed over the rwy. The student made a shollow bank to the right and descended into an adjacent field where she and the vehicle collided with some bales of hay. The student had… - [NTSB MKC84LA140](https://openairdocs.org/ntsb/MKC84LA140.md): Piper PA-22-135 · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N2390A · Substantial damage > While manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction. - [NTSB LAX84LA309](https://openairdocs.org/ntsb/LAX84LA309.md): Cessna 172RG · Lakeside, AZ · Accident · Serious injuries · Limited investigation · Final report · May 18, 1984 · N9700B · Destroyed > The plt was unable to clear rising terrain after a low pass for a photo. The density alt was about 8700 ft. - [NTSB LAX84LA298](https://openairdocs.org/ntsb/LAX84LA298.md): Cessna P210N · Ramona, CA · Accident · Minor injuries · Limited investigation · Final report · May 18, 1984 · N4772K · Destroyed > As part of an experimental test flt in the turbine powered acft, intentional spins were performed. The planned one turn spin evolved into a flat spin. Recovery procedures were ineffective and the plt elected to deploy the anti-spin parachute. Despite repeated… - [NTSB SEA84LA109](https://openairdocs.org/ntsb/SEA84LA109.md): Grumman G-164 · Craigmont, ID · Accident · No injuries · Limited investigation · Final report · May 17, 1984 · N48373 · Substantial damage > During aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken… - [NTSB FTW84LA240](https://openairdocs.org/ntsb/FTW84LA240.md): Rockwell S2R · Alexandria, LA · Accident · No injuries · Limited investigation · Final report · May 16, 1984 · N5641X · Substantial damage > The acft collided with a static wire between two electrical poles while maneuvering during aerial application. Control was maintained and the acft returned to the airport and landed without futher incident. - [NTSB DEN84LA151](https://openairdocs.org/ntsb/DEN84LA151.md): Cessna A185F · Grand Junction, CO · Accident · Serious injuries · Limited investigation · Final report · May 16, 1984 · N714PM · Destroyed > The plt-in-command (PIC) was checking out another plt on a pipeline route. The copilot was occupying the left seat & was flying the acft. While surveying the pipeline, they proceeded north up a canyon toward Douglas pass. No turbulence & little effect from… - [NTSB LAX84FU027](https://openairdocs.org/ntsb/LAX84FU027.md): Mitchell TU-10 · Perris, CA · Accident · 2 fatal · Final report · May 13, 1984 · UNREG · Destroyed > The purpose of the flt was for one instructor plt (CFI) to check out the other CFI in the ultralight vehicle. Reportedly, many witnesses watched as the acft climbed to aprx 3000 ft AGL. The aircrew then performed a series of rolls to the left & right. The… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=215 ## 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=214 --- 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.