# 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 225 of 378 · 18,851 cases ## Cases, newest first - [NTSB LAX83LA180](https://openairdocs.org/ntsb/LAX83LA180.md): Hughes 269A · Lindsay, CA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N8775F · Substantial damage > The plt was rounding up cattle for a bbq. One of the steer in the herd charged the helicopter & struck its skid. The main rotor deflected & severed the tail boom. The plt lost control of the acft which impacted the ground & rolled over. - [NTSB MIA83LA125](https://openairdocs.org/ntsb/MIA83LA125.md): Hughes 300C · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1983 · N8602F · Substantial damage > The helicopter landed hard during a practice autorotation. - [NTSB LAX83LA195](https://openairdocs.org/ntsb/LAX83LA195.md): Piper PA18-150 · Likely, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 1983 · N3895Z · Substantial damage > The plt reported that he was on a flt to survey some irrigation properties. He reported that he was at aprx 200 ft AGL & had became preoccupied when he initiated a right turn & exceeded the bank limitation for the speed & weight of the acft. The acft stalled… - [NTSB ATL83LA158](https://openairdocs.org/ntsb/ATL83LA158.md): Grumman G-164A · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Apr 11, 1983 · N9782 · Substantial damage > The aircraft collided with a ditch during a forced landing after power loss while on an aerial application flight. The engine failed because of loss of #2 cylinder. The cylinder head cracked and ruptured two oil lines. With the windshield covered with oil and… - [NTSB LAX83LA186](https://openairdocs.org/ntsb/LAX83LA186.md): Cessna 152 · Guadalupe, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1983 · N5542H · Substantial damage > After practicing a series of power-on departure stalls at 3500 feet, the plt climbed to 6500 feet and practiced several power-off approach/landing stalls. At about 3000 feet the engine sputtered and quit. The plt was unable to restore power and made an… - [NTSB LAX83LA184](https://openairdocs.org/ntsb/LAX83LA184.md): Bell 47G-3B-1 · Delano, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1983 · N1397X · Substantial damage > The acft collided with a power line and trees while applying pesticide to an orchard. The pilot was flying into the rising sun and failed to see the power line which serviced an agricultural deep well. - [NTSB FTW83LA180](https://openairdocs.org/ntsb/FTW83LA180.md): Cessna 150 · Donna, TX · Accident · No injuries · Limited investigation · Final report · Apr 7, 1983 · N6648G · Substantial damage > According to the student plt, he was practicing a simulated emergency landing & had aborted the approach when the acft banked to the left, went out of control & crashed. An investigation revealed that the acft hit a palm tree, aprx 60 ft tall, then came to… - [NTSB SEA83LA078](https://openairdocs.org/ntsb/SEA83LA078.md): Aeronca 7AC · Near Sisters, OR · Accident · No injuries · Limited investigation · Final report · Apr 6, 1983 · N83096 · Substantial damage > According to the plt, he began climbing after making a pass over a frozen lake & Near a youth camp. He reported that the acft entered a stall, then began to spin to the right at aprx 1000 ft AGL. He initiated corrective action, but the main gear hit the lake… - [NTSB ANC83FA066](https://openairdocs.org/ntsb/ANC83FA066.md): Bell 206B · Stony River, AK · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1983 · N376KA · Substantial damage > The plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the… - [NTSB ATL83LA152](https://openairdocs.org/ntsb/ATL83LA152.md): Cessna 152 · Verbena, AL · Accident · No injuries · Limited investigation · Final report · Apr 4, 1983 · N757HT · Substantial damage > The acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency… - [NTSB LAX83FJA06](https://openairdocs.org/ntsb/LAX83FJA06.md): Grumman American AA-5B · Waimanalo, Oahu, HI · Accident · 1 fatal · Final report · Apr 3, 1983 · N28808 · Substantial damage > The acft was observed maneuvering over the water at low altitude prior to impact with the water. A surviving pax stated that he & the plt had a big party the day before the flt & they both had hangovers the following morning. He further stated that they had a… - [NTSB SEA83FA072](https://openairdocs.org/ntsb/SEA83FA072.md): Glasair SH2 · Camano Island, WA · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1983 · N94RB · Destroyed > The aircraft was observed in a flat left hand spin which continued to ground impact. The aircraft entered the spin from a vertical maneuver at about 2000 feet AGL. The pilot had helped build this aircraft. He was characterized as a conservative pilot and had… - [NTSB LAX83LA234](https://openairdocs.org/ntsb/LAX83LA234.md): Let L-13 · California City, CA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1983 · N99965 · Substantial damage > During flt, the glider sustained in-flt structural damage while maneuvering at an altitude of aprx 17,500 ft MSL in the vicinity of California City, CA. During a preliminary verbal statement to an FAA inspector, the plt stated that he had done a couple of… - [NTSB LAX83LA177](https://openairdocs.org/ntsb/LAX83LA177.md): Cessna T188C · Soloman, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 1983 · N2074J · Substantial damage > The acft experienced a partial power loss and made an emergency landing in the field it was spraying. The acft had only made one spraying pass since being serviced with a full load of fuel and 140 gallons of chemical before the power loss occurred. As the… - [NTSB MIA83FLA01](https://openairdocs.org/ntsb/MIA83FLA01.md): Cessna T188C · St. Augustine, FL · Accident · Serious injuries · Final report · Apr 1, 1983 · N2541J · Substantial damage > The plt reported that he had just completed east to west swath runs & turned toward the sun to trim the east side of the field. Also, he reported that his windshield was covered with spray mist which restricted his visibility. Subsequently, he did not see how… - [NTSB NYC83FU001](https://openairdocs.org/ntsb/NYC83FU001.md): Pterodactyl Ascender II · Lehighton, PA · Accident · 1 fatal · Final report · Mar 31, 1983 · UNREG · Destroyed > Several witnesses observed the ultralight vehicle takeoff & climb in a circular pattern to an alt of about 1500 ft. one witness stated that just prior to the accident sequence, the ultralight was turning with a steep angle of bank. At about that time, the… - [NTSB ANC83LA061](https://openairdocs.org/ntsb/ANC83LA061.md): Piper PA-18A · W. Clam Gulch, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1983 · N8081C · Substantial damage > The acft stalled and crashed during an approach to land in a wilderness area. According to the plt he was preoccupied with landing near a wolverine he wanted to shoot. His approach was too high so he closed the throttle put down full flaps and started a turn.… - [NTSB MKC83LA082](https://openairdocs.org/ntsb/MKC83LA082.md): Piper PA-25 · Anthony, KS · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1983 · N8547L · Substantial damage > The aircraft crashed during a forced landing after engine failure. It was determined during inspection after the accident that the fuel remaining in the aircraft was mostly water. The pilot during preflight had drained the fuel sumps and did not find any… - [NTSB SEA83LA086](https://openairdocs.org/ntsb/SEA83LA086.md): Eagle DW-1 · Waverly, WA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1983 · N8809A · Substantial damage > The pilot was on an aerial application mission spraying dry fertilizer on an upslope when he encountered a downdraft. Heturned downslope as the acft settled but was unable to prevent ground contact. The acft contacted the soft terrain and nosed over to an… - [NTSB LAX83LA163](https://openairdocs.org/ntsb/LAX83LA163.md): Cessna 188 · Stanfield, AZ · Accident · No injuries · Limited investigation · Final report · Mar 26, 1983 · N9893V · Substantial damage > The rated commercial plt was on a solo instructional flt while in training for aerial application. He stated that before the accident, he had visually checked the fuel load & thought there was sufficient fuel for the flt. He took off, sprayed a load of water,… - [NTSB LAX83FUJ12](https://openairdocs.org/ntsb/LAX83FUJ12.md): Cessna 182B · Benson, AZ · Accident · Serious injuries · Final report · Mar 26, 1983 · N7293E · Substantial damage > The acft collided with a tree following a power loss during a low pass over a remote open area. The pilot and his wife were on a local pleasure flt when he decided to make a low pass over an area. During a 2nd pass over the same area when he applied the power… - [NTSB LAX83LA159](https://openairdocs.org/ntsb/LAX83LA159.md): Hughes 369D · Rancho Bernardo, CA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1983 · N9589F · Substantial damage > According to the plt, he was about 10 ft AGL in a hover, with a left quartering tailwind at 5, gusting 10 KTS, when he attempted a left pedal turn. He said the helicopter began to turn to the right & additional left pedal application had no effect. He rolled… - [NTSB ATL83FA144](https://openairdocs.org/ntsb/ATL83FA144.md): Kit Built Scorpion 133 · Centerville, TN · Accident · 1 fatal · Field investigation · Final report · Mar 25, 1983 · N506R · Destroyed > The rotorcraft crashed in a steeply descending turn shortly after takeoff from about 100 feet AGL. No mechanical malfunction was found during, the on-site wreckage examination which would have resulted in the abrupt steep left bank and ground impact. The… - [NTSB LAX83FJA05](https://openairdocs.org/ntsb/LAX83FJA05.md): Murrayair MA1B · Nr Lihue Arpt, HI · Accident · 1 fatal · Final report · Mar 24, 1983 · N101MA · Destroyed > The acft collided with a tree during a turn-around while engaged in aerial application operations. The pilot had made a few runs over the same field until he exhausted his load. After landing and reloading he returned to the area to finish the job and on the… - [NTSB DEN83LA082](https://openairdocs.org/ntsb/DEN83LA082.md): American AA-5B · Heber City, UT · Accident · No injuries · Limited investigation · Final report · Mar 21, 1983 · N4520V · Substantial damage > After taking off at Heber City, UT, the plt turned to a 090 deg heading & began a climb with full throttle, mixture full rich, 80 to 90 KIAS & aprx 500 fpm rate of climb. At aprx 6500 ft MSL, he altered the course to 110 to 115 deg to provide better terrain… - [NTSB MIA83FA096](https://openairdocs.org/ntsb/MIA83FA096.md): Piper J3C-65 · Fort Lauderdale, FL · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1983 · N3618K · Destroyed > The pilot's father and fiancee were acting as ground crew for the banner pickup. The pilot's father, who is a senior captain for pan am, stated that the acfr flew in a very erratic manner after the banner towing hook was thrown out. The acft was banking and… - [NTSB LAX83FA150](https://openairdocs.org/ntsb/LAX83FA150.md): Cessna 150M · Dos Palos, CA · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1983 · N2832V · Destroyed > The non-rated plt & a friend (also non-rated) took the acft without permission of the owner. They took off at night & made repeated passes over the city of Dos Palos, CA. After about 15 to 20 min, the acft was flown to the vicinity of a home belonging to the… - [NTSB LAX83FA396](https://openairdocs.org/ntsb/LAX83FA396.md): Cessna 182 · Littlefield, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 19, 1983 · N2646G · Destroyed > The passenger stated the flt was behind schedule, and an airport thought to be tuweep was spotted. They descended to 150-200 ft to read a sign and when the plt tried to climb in a left turn he collided with rising terrain. The accident location is about 8… - [NTSB NYC83FA078](https://openairdocs.org/ntsb/NYC83FA078.md): Mitsubishi MU-2B-60 · North Adams, MA · Accident · 2 fatal · Field investigation · Final report · Mar 18, 1983 · N473MA · Destroyed > At 1145 the plt reported VFR conditions & requested radar vectors to the arpt. He was issued a cruise clearance of 5,000 ft & given a heading. 18 mi from the arpt he reported visual contact with the ground. At 1151 he was asked if he was familiar with the… - [NTSB MIA83LA087](https://openairdocs.org/ntsb/MIA83LA087.md): Hughes 269A · St. Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N9020M · Substantial damage > The helicopter contacted the ground with a skid during a hover and ended up in a dynamic roll over. This was a dual instructional flt and the student was at the controls in a hover at the runways end awaiting twr instructions when the right skid became stuck… - [NTSB LAX83LA137](https://openairdocs.org/ntsb/LAX83LA137.md): Taylorcraft BC12D · San Manuel, AZ · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N43958 · Substantial damage > According to the pilot, she was flying above a canyon and noticed a loss of altitude. The best rate of climb airspeed, 60 mph, failed to produce any climb, so the pilot began to circle to gain altitude. 'Before completion of the first circle the plane lost… - [NTSB SEA83FA062](https://openairdocs.org/ntsb/SEA83FA062.md): Cessna 150J · Glenns Ferry, ID · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1983 · N60461 · Destroyed > The acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft… - [NTSB MIA83LA091](https://openairdocs.org/ntsb/MIA83LA091.md): Gray J-3 Trainer · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Mar 13, 1983 · N1391P · Substantial damage > While maneuvering to enter the ultralight landing area on the arpt during an eaa fly-in, the elevator became jammed in the down position when a bolt in the linkage became jammed against the wheel axle which had been bent in a previous accident. The plt was… - [NTSB FTW83LA151](https://openairdocs.org/ntsb/FTW83LA151.md): Cessna 182RG · Sheffield, TX · Accident · No injuries · Limited investigation · Final report · Mar 13, 1983 · N1739R · Substantial damage > After takeoff from a ranch strip, the eng lost power during a turn, then started again after the plt leveled the wings. He maneuver over the strip & the eng cut out two more times. The acft descend into grassy terrain, but hit a rock & damaged the nose gear.… - [NTSB ATL83FKJ03](https://openairdocs.org/ntsb/ATL83FKJ03.md): Eaa Biplane P-2 · Southside, AL · Accident · 1 fatal · Final report · Mar 13, 1983 · N20KJ · Destroyed > The pilot was performing aerobatics over the airport at 400-500 feet AGL. On the last pass, he had completed one roll and was inverted in what appeared to be a second roll when the aircraft dove at the ground in a near vertical position. The aircraft engine… - [NTSB DEN83LA080](https://openairdocs.org/ntsb/DEN83LA080.md): Helio H-295 · Baggs, WY · Accident · No injuries · Limited investigation · Final report · Mar 12, 1983 · N533LD · Substantial damage > The plt reported that he was hauling hay for his stranded horse. The plt was delivering hay, 5 bales per flt & dropping 1 bale at a time. On the 19th drop, after 4 hrs & 15 min of flt time since refueling, the eng lost power. During a forced landing in deep… - [NTSB DEN83FTE07](https://openairdocs.org/ntsb/DEN83FTE07.md): Homebuilt Rotorcraft Z6 · Bennett, CO · Accident · 1 fatal · Final report · Mar 12, 1983 · N23104 · Substantial damage > The Homebuilt gyrocopter crashed on level terrain after rudder and rotor blade separation in flt. The rudder was found about 100 yards from the main wreckage. It had been struck by one of the rotor blades and had separated in flt. The separated rotor blade… - [NTSB LAX83LA135](https://openairdocs.org/ntsb/LAX83LA135.md): Vans RV-3A · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1983 · N630CB · Substantial damage > According to the plt, he took off, climbed to 1500 ft & set the engine controls at cruise power (2500 RPM at 160 mph). He stated that he then turned back toward the arpt & made a low pass without changing the power setting. As he started to climb from the low… - [NTSB DEN83FA077](https://openairdocs.org/ntsb/DEN83FA077.md): Champion 7EC · Wright, WY · Accident · 2 fatal · Field investigation · Final report · Mar 11, 1983 · N7527E · Destroyed > The acft spun into the ground from low alt while hunting foxes. The acft had previously landed in a wheat field and the occupants talked with a friend about seeing foxes nearby. They were going to fly around some more and have a look. A short time later the… - [NTSB MKC83LA075](https://openairdocs.org/ntsb/MKC83LA075.md): Cessna 150F · Ollie, IA · Accident · No injuries · Limited investigation · Final report · Mar 7, 1983 · N8803G · Substantial damage > The student reported that the eng lost aprx 500 RPM while he was practicing turns & stalls at an altitude of aprx 3500 ft MSL. Reportedly, the situation became worse & he was unable to maintain altitude. He applied carburetor heat, but it did not help.… - [NTSB LAX83FVG09](https://openairdocs.org/ntsb/LAX83FVG09.md): Beech V35B · Copperopolis, CA · Accident · 1 fatal · Final report · Mar 7, 1983 · N4755M · Destroyed > The acft was observed taking off to the south from the plt's private strip. The acft made a 180 deg turn & flew over theplt's residence near the runway. A momentary increase in eng RPM was heard. The acft then made another 180 deg turn & flew down the runway… - [NTSB LAX83LA128](https://openairdocs.org/ntsb/LAX83LA128.md): Grumman G-164A · Williams Afb, AZ · Accident · No injuries · Limited investigation · Final report · Mar 6, 1983 · N4529 · Substantial damage > While on a spray run, the eng lost power. Subsequently, the acft was damaged during a forced landing. - [NTSB ATL83FA127](https://openairdocs.org/ntsb/ATL83FA127.md): Douglas B-26C · Hubbards Fork, KY · Accident · 1 fatal · Field investigation · Final report · Mar 5, 1983 · N4060A · Destroyed > The plt & acft had been fighting forest fires earlier in the day. A late developing fire necessitated another dispatch. The acft arrived on scene & checked in with the lead acft circling overhead coordinating the fire fighting efforts. The tanker made 2 runs… - [NTSB FTW83LA135](https://openairdocs.org/ntsb/FTW83LA135.md): Champion 7ECA · Muskogee, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 1983 · N6386N · Substantial damage > The passenger was in the back seat with a 35 mm camera, a pocket camera, a pair of binoculars in a case and a windbreaker. While flying at dusk, they flew by a herd of deer, but the passenger did not get a photograph. Reportedly, the plt made a 180 deg turn &… - [NTSB CHI83FA125](https://openairdocs.org/ntsb/CHI83FA125.md): Dodd Pitts S1S · Harvard, IL · Accident · 1 fatal · Field investigation · Final report · Mar 1, 1983 · N11D · Destroyed > The acft crashed into an open field leaving no ground scars other than the principal impact. One witness saw the acft stall at the top of a loop and go into a spin (tail-down). He stated the acft rotated 6-8 times prior to impact with the engine running. The… - [NTSB LAX83FA121](https://openairdocs.org/ntsb/LAX83FA121.md): Hughes 269A · Phoenix, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 28, 1983 · N42426 · Destroyed > The purpose of flt was to take aerial photogrphs of a business agency near the crash site. The helicopter was observed orbiting a parking lot in a right hand pattern at 150-300 ft AGL. After 2-3 orbits it appeared to hover before pitching nose down to a near… - [NTSB LAX83FA120](https://openairdocs.org/ntsb/LAX83FA120.md): Ayres S2R-R3S · Kerman, CA · Accident · 1 fatal · Field investigation · Final report · Feb 27, 1983 · N40160 · Destroyed > The acft returning from a spray mission collided with a tree and crashed near the pilots home. The pilot made a low passover his house to let his wife know he had returned. He made a spray run over his own vineyard and collided with a largetree while pulling… - [NTSB ANC83LA050](https://openairdocs.org/ntsb/ANC83LA050.md): Piper PA-18 · Northway, AK · Accident · No injuries · Limited investigation · Final report · Feb 27, 1983 · N4876A · Substantial damage > The plt reported that while he was flying in a canyon, up cub creek, he encountered unanticipated turbulence. He decided to make a 180 deg turn & leave the canyon. However, while making a left turn, the right wing of the acft struck a tree. Subsequently, the… - [NTSB FTW83LA130](https://openairdocs.org/ntsb/FTW83LA130.md): Cessna 182R · Flatonia, TX · Accident · No injuries · Limited investigation · Final report · Feb 26, 1983 · N5515N · Substantial damage > The acft collided with a power line while the plt was making a low apch over a private strip. The top 3 inches of the vertical stabilizer was cut off. The plt did not realize the acft was damaged & landed without further incident. - [NTSB ATL83FA122](https://openairdocs.org/ntsb/ATL83FA122.md): Bell 47G-2 · Hardeeville, SC · Accident · No injuries · Field investigation · Final report · Feb 26, 1983 · N5191B · Substantial damage > The plt stated that he noticed a peculiar pedal reaction during a turn-around; however, he reported that this may have been caused by the wind which was gusting to 15 KTS. Shortly after completing the turn-around, he experienced a complete loss of tail rotor… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=226 ## 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=225 --- 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.