# 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 191 of 378 · 18,851 cases

## Cases, newest first

- [NTSB BFO87LA032](https://openairdocs.org/ntsb/BFO87LA032.md): Robinson R-22B · Manassas, VA · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N2486N · Substantial damage
  > The student, under the supervision of the instructor, was practicing hovering; about 5 ft AGL. The stu had been overcontrolling the acft and each time the instr would take corrective action to stabilize the acft. The accident occurred when the stu…
- [NTSB MKC87LA090](https://openairdocs.org/ntsb/MKC87LA090.md): Cessna A188B · Orleans, NE · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N6048G · Substantial damage
  > The pilot stated that he was spraying a wheat field with a load of chemicals, and was completing his fourth swath run, when he noticed powerlines in his flight path. He performed an evasive maneuver; however, the aircraft struckthe powerlines. The aicraft…
- [NTSB DEN87FA111](https://openairdocs.org/ntsb/DEN87FA111.md): Taylorcraft F21 TC · Boulder, CO · Accident · Serious injuries · Field investigation · Final report · Apr 25, 1987 · N2005C · Substantial damage
  > The flt instructor and student plt were practicing night touch and go landings. Flt instructor reduced engine power to idle after takeoff to simulate an engine failure. He banked the acft 'steeply' to the left at a low altitude. The acft struck the ground in…
- [NTSB LAX87LA189](https://openairdocs.org/ntsb/LAX87LA189.md): Cessna 172N · Lihue, HI · Accident · 4 fatal · Limited investigation · Final report · Apr 24, 1987 · N739RV · Destroyed
  > The pilot filled the aircraft's fuel tanks, loaded three air tour passengers and proceeded up a canyon that climbed up to an elevation of about 3000 feet MSL on a sightseeing flight. A ground tour bus driver observed smoke emanating from the canyon and…
- [NTSB LAX87DUM02](https://openairdocs.org/ntsb/LAX87DUM02.md): Rockwell S2R · Imperial, CA · Accident · No injuries · Final report · Apr 24, 1987 · N4194X · Substantial damage
  > During an aerial application applying sulphur, the sulphur ignited inflight. The pilot turned the aircraft back toward the airport; however, the cockpit filled with smoke and the pilot decided to land on a road. Due to the extent of fire damage it could not…
- [NTSB DEN87LA100](https://openairdocs.org/ntsb/DEN87LA100.md): Aero Commander A-9B · Wood, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1987 · N2755V · Destroyed
  > A commercial ag plt was working a field with 2-4-D and had been spraying for 15 minutes. On a turn to reverse direction at the end of a pass, the plt started a 45 degree bank pull up and added full throttle. The engine then had a partial power loss and began…
- [NTSB LAX87DJA06](https://openairdocs.org/ntsb/LAX87DJA06.md): Schweizer SGS2-33 · Mokuleia, HI · Accident · Serious injuries · Final report · Apr 23, 1987 · N11468 · Destroyed
  > During a local sightseeing flt along a ridge line, while maneuvering around a cloud build-up, the acft entered a windshear that suddenly nosed the acft over in an aprx 75 deg vertical dive. Just prior to colliding with trees, the plt was able to regain some…
- [NTSB FTW87LA101](https://openairdocs.org/ntsb/FTW87LA101.md): Sikorsky S-55B · De Quincy, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 1987 · N414A · Substantial damage
  > The pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…
- [NTSB MIA87LA142](https://openairdocs.org/ntsb/MIA87LA142.md): Air Tractor AT301 · Dundee, MS · Accident · No injuries · Limited investigation · Final report · Apr 22, 1987 · N3652B · Substantial damage
  > The plt stated that when reversing direction after an aerial application maneuver the eng quit. He then landed the acft in a creek due to insufficient altitude to clear trees that were in the flight path. Upon touchdown the acft nosed over and came to rest…
- [NTSB ATL87DEI02](https://openairdocs.org/ntsb/ATL87DEI02.md): Bell B-206-1 · Youngstown, OH · Accident · No injuries · Final report · Apr 22, 1987 · N79RR · Substantial damage
  > While hovering from the wash rack, the helicopter backed into a utility pole. The main rotor system separated from the airframe following the collision. There were no postimpact mechanical malfunctions/failures.
- [NTSB ATL87LA121](https://openairdocs.org/ntsb/ATL87LA121.md): Bell UH-1B · Bay Minette, AL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N88987 · Destroyed
  > During a logging operation, the helicopter experienced a complete engine failure shortly after attempting a pickup. The pilot entered an autorotative glide. The helicopter impacted the water and sank. The wreckage examination disclosed that the compressor…
- [NTSB NYC87LA129](https://openairdocs.org/ntsb/NYC87LA129.md): Bell 47G · Bethel, PA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N59321 · Substantial damage
  > The student pilot lost directional control of the helicopter and as the instructor pilot attempted to regain control, the main rotor blades struck the ground causing substantial damage to the aircraft.
- [NTSB MKC87FA083](https://openairdocs.org/ntsb/MKC87FA083.md): Aeronca 11AC · Stillwell, KS · Accident · Serious injuries · Field investigation · Final report · Apr 19, 1987 · N85846 · Substantial damage
  > The pilot stated that this flight was to be a photographic, pleasure trip involving two aircraft. After several aerial photos were taken of each other's aircraft, both airplanes landed at the accident airport. The PIC and his passenger then took-off while the…
- [NTSB FTW87DRA02](https://openairdocs.org/ntsb/FTW87DRA02.md): Hunter Executive · Arcola, TX · Accident · No injuries · Final report · Apr 18, 1987 · N9728N · Destroyed
  > The acft was being test flown following the replacement of a tail rotor drive belt. Following a ground run up and ground taxi, several hovering flts were made successfully. As the non-helicopter rated plt was hovering back to the parking area, he heard the…
- [NTSB MKC87LA082](https://openairdocs.org/ntsb/MKC87LA082.md): Piper PA-25-235 · Kipp, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1987 · N8599L · Substantial damage
  > The engine crankshaft broke into two pieces during an ag flight and during the forced landing in a wet, soft field, the airplane nosed forward to the inverted position.
- [NTSB LAX87LA179](https://openairdocs.org/ntsb/LAX87LA179.md): Bell 206B-II · Yucaipa, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1987 · N76EF · Destroyed
  > A Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…
- [NTSB FTW87DRD04](https://openairdocs.org/ntsb/FTW87DRD04.md): Grumman G-164 · Rayne, LA · Accident · No injuries · Final report · Apr 16, 1987 · N10259 · Substantial damage
  > The aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…
- [NTSB DEN87LA101](https://openairdocs.org/ntsb/DEN87LA101.md): Boeing A75N1 · Argusville, ND · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1987 · N63915 · Substantial damage
  > The plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…
- [NTSB LAX87LA178](https://openairdocs.org/ntsb/LAX87LA178.md): Bell 206B · Laupahoehoe, HI · Accident · 1 fatal · Limited investigation · Final report · Apr 15, 1987 · N370AH · Destroyed
  > The pilot of the Bell 206B and his three passengers arrived over a beached barge that they were to land on. The pilot hovered over the barge in a left quartering tailwind of about 10 knots and over a moderate sea with waves breaking against the barge. The two…
- [NTSB MIA87LA133](https://openairdocs.org/ntsb/MIA87LA133.md): Bell 206L · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1987 · N16780 · Substantial damage
  > Unlicensed pilot lost control of helicopter while in hover while attempting to steal the helicopter. The aircraft crashed to earth and rolled over. The pilot was on probation for attempting to steal a helicopter on a previous occasion. The plt received minor…
- [NTSB NYC87FA120](https://openairdocs.org/ntsb/NYC87FA120.md): Cessna 172P · Berwick, ME · Accident · 4 fatal · Field investigation · Final report · Apr 11, 1987 · N55309 · Destroyed
  > The acft was observed doing stalls. A witness said that prior to the crash he saw the nose lower and the right wing drop. The aircraft then entered into a spiral. It was observed descending into trees in a spiral. The plt was found in the right front seat.…
- [NTSB LAX87FA173](https://openairdocs.org/ntsb/LAX87FA173.md): Hughes 369E · Palm Desert, CA · Accident · Serious injuries · Field investigation · Final report · Apr 11, 1987 · N5200W · Substantial damage
  > The helicopter dscndd uncontrolled & crashed in a residential area. After the acdnt, the plt said he agreed to orbit the residence of his pax. At the aprx 135 deg point of a left orbit, he felt 'a bang & severe vibration in the tail.' The plt lost drctnl ctl…
- [NTSB FTW87DRG01](https://openairdocs.org/ntsb/FTW87DRG01.md): Davis Pitts S-1S · Coleman, TX · Accident · 1 fatal · Final report · Apr 11, 1987 · N90DW · Destroyed
  > The pilot had completed several aerobatic maneuvers for an air show and was in the process of doing a series of five snap rolls at an altitude of 200-300 feet AGL when the accident occurred. Witnesses observed the nose of the acft to drop during the third…
- [NTSB LAX87FA172](https://openairdocs.org/ntsb/LAX87FA172.md): Piper PA-28-161 · Malibu, CA · Accident · 2 fatal · Field investigation · Final report · Apr 10, 1987 · N4304F · Destroyed
  > The plt & his 3 passengers met at a bar then decided to go on a local night scenic flt. Subsequently, the acft crashed into the ocean as the plt was demonstrating low flt over the water. The plt & 1 passenger were hospitalized & treated for injuries &…
- [NTSB DEN87LA089](https://openairdocs.org/ntsb/DEN87LA089.md): Cessna 152 · Bountiful, UT · Accident · Minor injuries · Limited investigation · Final report · Apr 8, 1987 · N4970B · Substantial damage
  > The stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…
- [NTSB DEN87FA091](https://openairdocs.org/ntsb/DEN87FA091.md): Grumman G-164A · Lamar, CO · Accident · 1 fatal · Field investigation · Final report · Apr 8, 1987 · N8369 · 2 aircraft · Destroyed
  > The aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and…
- [NTSB DEN87FA090](https://openairdocs.org/ntsb/DEN87FA090.md): Bellanca 7GCBC · Berthold, ND · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1987 · N88177 · Destroyed
  > The plt took off to the east from a farm driveway to return home. Witnesses saw the airplane make an immediate right turn, followed by a left turn at aprx 35-50 ft AGL. The acft approached the farm at aprx 50-100 ft AGL. The acft suddenly pulled up, banked…
- [NTSB DEN87LA087](https://openairdocs.org/ntsb/DEN87LA087.md): Grumman G-164A · La Salle, CO · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 1987 · N72PB · Destroyed
  > While conducting an aerial application flt, the plt misjudged the distance to the end of the field and initiated the pull-up too late to avoid impact with a tree. After striking the tree, the acft descended out of control until impact with the ground.
- [NTSB SEA87LA074](https://openairdocs.org/ntsb/SEA87LA074.md): Hughes 369D · Forks, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1987 · N8356F · Destroyed
  > During external load operation the aircraft's engine ceased operating. The helicopter was too close to the ground for recovery. The helicopter descended, struck the ground hard and then rolled over onto its right side. Water in the fuel was discovered after…
- [NTSB CHI87DER03](https://openairdocs.org/ntsb/CHI87DER03.md): Hiller UH-12ET · Big Lake, MN · Accident · No injuries · Final report · Apr 3, 1987 · N135HA · Substantial damage
  > Aircraft was being maneuvered for landing on a ground support trailer when it experienced a power failure. Due to high trees autorotation was made to adjacent field. Aircraft landed on rough/uneven terrain and rolled over. Investigation revealed contaminated…
- [NTSB MKC87LA069](https://openairdocs.org/ntsb/MKC87LA069.md): Cessna 152 · Tribune, KS · Accident · No injuries · Limited investigation · Final report · Mar 31, 1987 · N89547 · Substantial damage
  > The pilot stated that he was spotting stray cattle after a snow blizzard moved through the region. Two hours into the flight, the pilot further stated, he reduced engine power for approximately 10 seconds--without carburetor heat. The engine then sputtered…
- [NTSB MIA87LA132](https://openairdocs.org/ntsb/MIA87LA132.md): Cessna 172M · Clarksdale, MS · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N12497 · Substantial damage
  > The pilot stated that while flying at a low altitude over a dried up lake bed the aircraft collided with an unmarked telephone wire. A landing was made in a field where damaged was inspected. The pilot then elected to takeoff and return to the departure…
- [NTSB CHI87FA104](https://openairdocs.org/ntsb/CHI87FA104.md): Piper PA-32-300 · Frankfort, IL · Accident · 1 fatal · Field investigation · Final report · Mar 27, 1987 · N452BH · Destroyed
  > Aircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…
- [NTSB ATL87LA095](https://openairdocs.org/ntsb/ATL87LA095.md): Piper PA-25 · Bainbridge, GA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1987 · N6699Z · Substantial damage
  > The acft collided with trees while conducting an ag training flight. The training program was part of the locust control in central and southern africa. There was an instructor on the ground who acted as a radio controller for the flight. The pilot failed to…
- [NTSB MIA87FA118](https://openairdocs.org/ntsb/MIA87FA118.md): Aero Mirage TC-2 · Williston, FL · Accident · 1 fatal · Field investigation · Final report · Mar 25, 1987 · N2484V · Destroyed
  > Witnesses stated that the acft made a 'fly by' at 300 ft to check and see if the gear was down. The ground personnel informed the plt that the gear appeared to be down. They stated that the acft then made a sharp left turn paralleling runway 14, they lost…
- [NTSB MIA87FA114](https://openairdocs.org/ntsb/MIA87FA114.md): Piper PA-28-140 · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Mar 20, 1987 · N726FL · Destroyed
  > The recently rated private pilot took three passengers for an airplane ride in his airplane that was over gross weight upon departure. During the flight he was performing low level dives at trees with rapid pull ups. During the last pull up the aircraft went…
- [NTSB LAX87FA151](https://openairdocs.org/ntsb/LAX87FA151.md): Cessna T210K · Prescott, AZ · Accident · Serious injuries · Field investigation · Final report · Mar 20, 1987 · N8105G · Destroyed
  > After overloading the aircraft with 5 pax and baggage, the pilot departed on a personal cross country flight to phoenix, AZ. He climbed the acft to and maintained an altitude of 14,500 feet MSL until reaching salt lake city, UT. The aircraft was then…
- [NTSB ATL87FA088](https://openairdocs.org/ntsb/ATL87FA088.md): Beech C23 · Semora, NC · Accident · 3 fatal · Field investigation · Final report · Mar 20, 1987 · N18879 · Destroyed
  > While conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…
- [NTSB LAX87LA157](https://openairdocs.org/ntsb/LAX87LA157.md): McDonnell Douglas 369E · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Mar 19, 1987 · N1601Y · Substantial damage
  > During factory flt training, prior to delivery of the new helicopter to the owner, the CFI said he asked the student to perform a series of emergency procedures which included quick stops from an initial takeoff followed by hovering autorotations. The CFI…
- [NTSB LAX87FA147](https://openairdocs.org/ntsb/LAX87FA147.md): Robinson R-22-A · Scottsdale, AZ · Accident · 2 fatal · Field investigation · Final report · Mar 16, 1987 · N2256M · Destroyed
  > A loss of control in flight for undetermined reasons.
- [NTSB LAX87FA146](https://openairdocs.org/ntsb/LAX87FA146.md): Cessna 182R · Avenal, CA · Accident · 2 fatal · Field investigation · Final report · Mar 16, 1987 · N3143E · Destroyed
  > The plt, with suspended commerical privileges & no current medical cert, borrowed his parents acft. While flying along an interstate highway at night, the acft collided with electrical transmission lines & crashed. Initial impact occurred at about 115' AGL.…
- [NTSB FTW87DPJ04](https://openairdocs.org/ntsb/FTW87DPJ04.md): Air Tractor 301 · Oluskee, OK · Accident · No injuries · Final report · Mar 14, 1987 · N8865S · Substantial damage
  > During aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.
- [NTSB ANC87DAG01](https://openairdocs.org/ntsb/ANC87DAG01.md): Rotorway Scorpion 1670 · Soldotna, AK · Accident · No injuries · Final report · Mar 14, 1987 · N48591 · Substantial damage
  > The pilot stated that he lost directional control of the aircraft while just a few feet above the ground resulting in substantial damage to the aircraft.
- [NTSB DEN87FA066](https://openairdocs.org/ntsb/DEN87FA066.md): Rockwell 680FL · Basalt, CO · Accident · Serious injuries · Field investigation · Final report · Mar 13, 1987 · N4581E · Destroyed
  > N4581E was operating under 14 CFR 135 carrying cargo. The plt stated that he departed VFR and had '7 to 10' mi vis at the acdt site. Witnesses at and near the acdt site stated that heavy snow was falling at the time of the acdt and the vis was 1 mi or less.…
- [NTSB LAX87LA140](https://openairdocs.org/ntsb/LAX87LA140.md): Hughes 269D · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1987 · N1103V · Substantial damage
  > During an external load operation, the engine lost power. The aircraft collided with the terrain and rolled over. Inspection of the engine revealed an overtemperature to the first and second stage turbine wheel airfoils.
- [NTSB ATL87FA087](https://openairdocs.org/ntsb/ATL87FA087.md): Cessna 150H · Oneida, TN · Accident · 1 fatal · Field investigation · Final report · Mar 9, 1987 · N50077 · Destroyed
  > The pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…
- [NTSB LAX87LA137](https://openairdocs.org/ntsb/LAX87LA137.md): Cessna 172C · Kahului, HI · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N6353F · Substantial damage
  > The acft collided with trees while manuevering in mountainous terrain. The plt had planned a local flight from honolulu to maui and return. Once over the island of maui, the plt notified the fss that he was changing his route and would be passing through the…
- [NTSB FTW87DPJ03](https://openairdocs.org/ntsb/FTW87DPJ03.md): Boeing B75N1 · Fairmont, OK · Accident · Minor injuries · Final report · Mar 8, 1987 · N5102N · Substantial damage
  > During the pull up at end of swath run pilot misjudged power line clearance. Top line caught on aircraft and caused uncontrolled descent to ground.
- [NTSB ANC87LA045](https://openairdocs.org/ntsb/ANC87LA045.md): de Havilland DHC-2 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N67688 · Substantial damage
  > The pilot stated that he encountered a complete whiteout condition and during the emergency landing on the frozen lake he lost directional control of the aircraft causing the left wing to strike the ground.
- [NTSB ANC87FA043](https://openairdocs.org/ntsb/ANC87FA043.md): Bell 47G-2 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Mar 7, 1987 · N6140C · Substantial damage
  > A flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=192

## 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=191

---
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.