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

## Cases, newest first

- [NTSB SEA82FYK09](https://openairdocs.org/ntsb/SEA82FYK09.md): Aeronca 7AC · Near Creswell, OR · Accident · Serious injuries · Final report · Jul 1, 1982 · N1838E · Substantial damage
  > The aircraft crashed while the pilot was making a low pass over a grass field. The pilot reported that the plane struck the ground while he was proceeding westbound toward the setting sun, but he did not remember the details of the crash. An instructor pilot…
- [NTSB LAX82FVD19](https://openairdocs.org/ntsb/LAX82FVD19.md): Grumman G-164B · Stockton, CA · Accident · Serious injuries · Final report · Jul 1, 1982 · N4859S · Destroyed
  > The pilot was spraying a field that required flying under a double set of high powerlines. On the third pass after going under one set of wires the pilot pulled up too soon and hit the second set of wires. The pilot stated in his accident report that it was a…
- [NTSB FTW82DRJ13](https://openairdocs.org/ntsb/FTW82DRJ13.md): Air Tractor 301 · Clarksville, TX · Accident · 1 fatal · Final report · Jul 1, 1982 · N4437S · No damage
  > The pilot stated that he briefed the two flagmen about moving to next row as soon as the aircraft was lined up on the swath run. Both flagmen moved properly until on the fatal pass one flagman did not move and the aircraft struck him. The flagman struck by…
- [NTSB FTW82DA259](https://openairdocs.org/ntsb/FTW82DA259.md): Cessna 310Q · El Dorado, OK · Accident · No injuries · Final report · Jul 1, 1982 · N7692Q · Substantial damage
  > When the pilot arrived in the vicinity of his destination, he lowered the gear and flaps and dlew over an oil rig. He did this to alert someone on the ground to pick him up at the destination. As he applied power to proceed to the airport, the left engine did…
- [NTSB FTW82DA257](https://openairdocs.org/ntsb/FTW82DA257.md): Grumman G-164A · Epps, LA · Accident · No injuries · Final report · Jul 1, 1982 · N6562 · Substantial damage
  > The pilot stated that while he was spraying crops, he looked into the cockpit during a turn to check the amount of solution that was remaining. He stated that when he looked up, he was too low to complete the turn and miss the trees. He went to full power and…
- [NTSB ATL82DA188](https://openairdocs.org/ntsb/ATL82DA188.md): Grumman G-164A · Doddsville, MS · Accident · No injuries · Final report · Jul 1, 1982 · N7397 · Substantial damage
  > The pilot reported that at the end of a swath run, he noticed the smell of burned oil and saw smoke when the engine began a hard miss. He reported that these occurred when the number five cylinder failed. He made a forced landing in a flooded rice field where…
- [NTSB LAX82FA237](https://openairdocs.org/ntsb/LAX82FA237.md): Grumman American AA5A · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · Jun 29, 1982 · N26668 · Destroyed
  > The acft was observed flying at an altitude of 200 to 300 feet AGL. Witnesses describe a bank to the left which steepened until the wings were perpendicular to the ground. The acft then made a near vertical descent into the ground.
- [NTSB FTW82DA251](https://openairdocs.org/ntsb/FTW82DA251.md): Hughes 269C · Canadian, TX · Accident · No injuries · Final report · Jun 28, 1982 · N58407 · Substantial damage
  > The fixed-wing-rated/helicopter student pilot stated that it had been raining before he went to fly. Reportedly, he began to practice hovering while wearing wet tennis shoes. The student stated that his foot slipped off of the pedal because the soles of his…
- [NTSB DEN82DA119](https://openairdocs.org/ntsb/DEN82DA119.md): Hughes 269C · Ronan, MT · Accident · Minor injuries · Final report · Jun 28, 1982 · N9626F · Substantial damage
  > After spraying the field, the pilot was making an "end swath" when the helicopter collided with a power line. The helicopter crashed after a wire wrapped around the swash plate and damaged the controls. The pilot stated that he failed to see the wire.
- [NTSB ATL82DA179](https://openairdocs.org/ntsb/ATL82DA179.md): Bell 47G-3B-1 · Headland, AL · Accident · Minor injuries · Final report · Jun 28, 1982 · N12437 · Substantial damage
  > The pilot was positioning the aircraft for refueling when the main rotor contacted the fuel meter. There was substantialdamage to the helicopter and minor injuries to the chemical loader.
- [NTSB SEA82DA096](https://openairdocs.org/ntsb/SEA82DA096.md): Bensen B-8M · Kennewick, WA · Accident · No injuries · Final report · Jun 27, 1982 · N5919 · Substantial damage
  > The pilot stated that he was demonstrating the gyrocopter's vertical decent capability at an eaa fly-in. He flew the aircraft into the wind at approximately 200 feet, reduced power and failed to recover from the sink rate.
- [NTSB NYC82FHJ06](https://openairdocs.org/ntsb/NYC82FHJ06.md): Cessna 177 · Larchmont, NY · Accident · 3 fatal · Final report · Jun 27, 1982 · N3365T · Destroyed
  > The aircraft was on a flight to take pictures of a home that was recently constructed on the shore of long island sound. While in flight, pictures were also taken of boats. A witness on a boat stated taht after the pilot made several passes over boats, the…
- [NTSB NYC82FGT15](https://openairdocs.org/ntsb/NYC82FGT15.md): Aeronca 11AC · Peach Bottom, PA · Accident · 3 fatal · Final report · Jun 26, 1982 · N9451E · Destroyed
  > The non-certificated pilot took off with one passenger on board and with both doors removed. Witnesses observed the pilot make a number of passes near boats, under power lines and near people on the surface. A number of witnesses stated the passenger was…
- [NTSB MKC82FCQ11](https://openairdocs.org/ntsb/MKC82FCQ11.md): Cessna 188B · Scott City, KS · Accident · Serious injuries · Final report · Jun 26, 1982 · N4965R · Substantial damage
  > The aircraft crashed during an aerial application operation; however, the pilot could not remember the details of the accident. He believed that the propeller may have started to turn excessively fast, but this was not verified. After contacting the ground,…
- [NTSB MIA82DA141](https://openairdocs.org/ntsb/MIA82DA141.md): Piper PA-38-112 · Fellsmere, FL · Accident · Minor injuries · Final report · Jun 26, 1982 · N2437K · Substantial damage
  > The pilot was a foreign national with a private pilot certificate and was on a solo instructional flight. He reported that the engine lost power while he was practicing s-turns at 800 ft. he stated that he accomplished the procedure for an engine failure, but…
- [NTSB DEN82DA118](https://openairdocs.org/ntsb/DEN82DA118.md): Aerospatiale SA 315 B · 35 Se Moab, UT · Accident · Minor injuries · Final report · Jun 26, 1982 · N221RM · Substantial damage
  > Helicopter lifting sling loads lost power in a hover. Pilot jettisoned load and made a forced landing in a ravine, engine had dirt buildup and erosion in the compressor inlet case which led to compressor stall.
- [NTSB FTW82DRA22](https://openairdocs.org/ntsb/FTW82DRA22.md): Grumman G-164 · Hardin, TX · Accident · Serious injuries · Final report · Jun 25, 1982 · N8354K · Substantial damage
  > The pilot reported that he struck power lines while flying under them during a swath run. Also, he indicated that a thunderstorm was rapidly approaching the field at the time the accident occurred.
- [NTSB DEN82AA115](https://openairdocs.org/ntsb/DEN82AA115.md): Beech V35B · Near Ringling, MT · Accident · 6 fatal · Final report · Jun 24, 1982 · N4538S · Destroyed
  > Although IMC existed over mountainous areas, the plt attempted a visual flt direct to salt lake city. The probable flt path of the acft was one which is usually flown by plts on VFR flts. The course taken by plts desiring to cross over themountain ridges west…
- [NTSB LAX82FA232](https://openairdocs.org/ntsb/LAX82FA232.md): Aerospatiale SA-316B · Dardanelle, CA · Accident · 3 fatal · Field investigation · Final report · Jun 23, 1982 · N6456 · Destroyed
  > The pilot took off from modesto, CA on a medivac flight to pick up a victim that was injured in an automobile accident. A nurse and a medical technician were on board. Spotlights on vehicles were used to illuminate the landing area as well as high surrounding…
- [NTSB FTW82DA244](https://openairdocs.org/ntsb/FTW82DA244.md): Grumman G-164A · Coy, AR · Accident · No injuries · Final report · Jun 22, 1982 · N8729H · Substantial damage
  > The pilot reported that the engine lost power as he was pulling up from a swath run. He pumped the throttle several times, the engine regained power momentarily, then quit. The pilot dumped his load and made a forced landing in a muddy field. As the plane was…
- [NTSB DEN82FTI16](https://openairdocs.org/ntsb/DEN82FTI16.md): Piper PA-28-R-180 · Cameron, MT · Accident · Serious injuries · Final report · Jun 22, 1982 · N3901T · Destroyed
  > The pilot reported that he encountered a downdraft while climbing over rising terrain in an area of foothills near mountains. He reported a loss of airspeed and altitude when the aircraft was about 1000 ft from the crest. At about that time, the gear extended…
- [NTSB FTW82FRJ12](https://openairdocs.org/ntsb/FTW82FRJ12.md): Piper PA-36-375 · Wildsville, LA · Accident · 1 fatal · Final report · Jun 21, 1982 · N90297 · Destroyed
  > The pilot took off on a local flight to spray a bean field. About 1000 ft from the end of the field was a 300 ft radio tower. The aircraft was observed to circle the bean field and circle the radio tower twice. During a procedure turn, the aircraft struck the…
- [NTSB FTW82DA238](https://openairdocs.org/ntsb/FTW82DA238.md): Rockwell Intl S-2R · Eudora, AR · Accident · No injuries · Final report · Jun 21, 1982 · N4905X · Substantial damage
  > Since the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…
- [NTSB DEN82FA106](https://openairdocs.org/ntsb/DEN82FA106.md): Aerospatiale SA-315B · Dillon, MT · Accident · Serious injuries · Field investigation · Final report · Jun 21, 1982 · N47271 · Destroyed
  > The pilot maneuvered the helicopter close to the ground to "spook" an antelope. After a series of turns, the aircraft touched down on both skids and continued forward 246 ft before stopping.
- [NTSB NYC82DA128](https://openairdocs.org/ntsb/NYC82DA128.md): Bell 206B · Jamestown, RI · Accident · No injuries · Final report · Jun 20, 1982 · N20303 · Substantial damage
  > The helicopter was being used to photograph ships. According to the pilot, it began to spin while he was in a low level hover over the water. Subsequently, the helicopter struck the water, rolled over, then sank in about 104 ft of water and was not recovered.
- [NTSB LAX82FA225](https://openairdocs.org/ntsb/LAX82FA225.md): Bellanca 8KCAB · Westley, CA · Accident · 1 fatal · Field investigation · Final report · Jun 20, 1982 · N2661Z · Destroyed
  > The plt made a low pass over a ranch house traveling from nw to se. He then made a second low pass over the swimming pool area traveling in a NE direction, & waved to those standing by the pool. The acft began a 180 reversal turn, entered a steep nose down…
- [NTSB FTW82FPD13](https://openairdocs.org/ntsb/FTW82FPD13.md): Varieze · Roanoke, TX · Accident · 1 fatal · Final report · Jun 20, 1982 · N111CH · Destroyed
  > About 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the right winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…
- [NTSB DEN82DA108](https://openairdocs.org/ntsb/DEN82DA108.md): Callair A-9B · Rolla, ND · Accident · No injuries · Final report · Jun 20, 1982 · N7634V · Substantial damage
  > The pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…
- [NTSB CHI82DA217](https://openairdocs.org/ntsb/CHI82DA217.md): Taylorcraft BC12-D · La Porte, IN · Accident · Minor injuries · Final report · Jun 19, 1982 · N96054 · Substantial damage
  > The pilot had flown to the airport to participate in activities of a contest that included spot landings and balloon busting. He stated that on his third pass of a balloon busting contest, he turned too tight, too slow, and the aircraft stalled. The pilot…
- [NTSB CHI82DA215](https://openairdocs.org/ntsb/CHI82DA215.md): Bellanca 73CA · Fairfield, IL · Accident · Serious injuries · Final report · Jun 19, 1982 · N90977 · Destroyed
  > The pilot stated that after takeoff he flew 3 or 4 miles, started a right turn and could not recall any further events concerning the flight. Investigation revealed the aircraft crashed on flat terrain. Examination of the flight controls did not reveal any…
- [NTSB ATL82FKQ15](https://openairdocs.org/ntsb/ATL82FKQ15.md): Cessna R182 · Ocean Springs, MS · Accident · 3 fatal · Final report · Jun 19, 1982 · N757FB · Destroyed
  > A pilot-rated witness observed the entire flight and accident. He stated that after takeoff and gear retraction, the aircraft was held at a very low altitude, which he thought was to gain airspeed. The aircraft reached the end of the runway and went into a…
- [NTSB ATL82DA171](https://openairdocs.org/ntsb/ATL82DA171.md): Piper PA-25-235 · Ripley, IN · Accident · Minor injuries · Final report · Jun 18, 1982 · N8544L · Destroyed
  > When the pilot arrived to spray the field for the first time, he saw powerlines along a road and saw poles on both sides of a creek. He assumed that all of the lines followed the road. He was unaware that a powerline crossed the narrow field that he was about…
- [NTSB MKC82DA108](https://openairdocs.org/ntsb/MKC82DA108.md): Callair A-9B · Ulysses, KS · Accident · No injuries · Final report · Jun 17, 1982 · N7603V · Substantial damage
  > The pilot was on a spray flight over an area of sand hills. While dropping flags to help determine the wind on the surface, he encountered unfavorable wind conditions and a sudden loss of lift. He applied full power, but was unable to recover from the mushing…
- [NTSB FTW82DA230](https://openairdocs.org/ntsb/FTW82DA230.md): Rockwell S2R · Bishop, TX · Accident · No injuries · Final report · Jun 17, 1982 · N5028X · Substantial damage
  > Reportedly, the pilot realized he was low on fuel, but thought he had enough to finish spraying the field and return to the landing area. As he pulled up from the last pass, he noticed that one fuel gauge was on empty and the other was indicating about 1/8…
- [NTSB CHI82FA213](https://openairdocs.org/ntsb/CHI82FA213.md): Cessna 152 · Danville, OH · Accident · 1 fatal · Field investigation · Final report · Jun 17, 1982 · N5330M · Destroyed
  > The pilot made a low, slow pass over a camp so a passenger could drop a package. After the package was dropped, the aircraft entered a left turn, then stalled and spun to the ground.
- [NTSB LAX82DA222](https://openairdocs.org/ntsb/LAX82DA222.md): Rockwell Intl. S-2R · Firebaugh, CA · Accident · Serious injuries · Final report · Jun 16, 1982 · N4218X · Destroyed
  > The pilot was spreading fertilizer over a field and maneuvering over "high tension lines." No problems were encountered during previous flights earlier that day. The pilot had picked up another load which he reported was probably too much. He reported that…
- [NTSB CHI82DA212](https://openairdocs.org/ntsb/CHI82DA212.md): Bell 47G-2A · Hudsonville, MI · Accident · No injuries · Final report · Jun 16, 1982 · N364W · Substantial damage
  > The pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…
- [NTSB NYC82FGM11](https://openairdocs.org/ntsb/NYC82FGM11.md): Bell 47G-3B-1 · Kittanning, PA · Accident · 1 fatal · Final report · Jun 15, 1982 · N9276Z · Destroyed
  > The helicopter was on a powerline patrol flight with three occupants on board. While proceeding along the powerline with a tailwind, the pilot started to climb over a hill. He stated to the passengers that he was unable to out climb the hill, then circled to…
- [NTSB NYC82DA124](https://openairdocs.org/ntsb/NYC82DA124.md): Continental EL Tomcat MK5A · Imlaystown, NJ · Accident · No injuries · Final report · Jun 15, 1982 · N9062T · Substantial damage
  > During a swath run, a bird flew into the windshield and the pilot rolled the helicopter to the right to avoid further bird strikes. The right spray boom contacted the crops and pulled the aircraft into the ground resulting in substantial damage.
- [NTSB FTW82FPA12](https://openairdocs.org/ntsb/FTW82FPA12.md): Cessna 150 · Allen, TX · Accident · Serious injuries · Final report · Jun 13, 1982 · N3971U · Destroyed
  > A witness attending a horse show observed the acft fly over the field at low altitude in a slow flt & that something wrapped in plastic was dropped from the acft. The acft was in a nose high attitude approaching a stall. The acft then disappeared from his…
- [NTSB CHI82FA206](https://openairdocs.org/ntsb/CHI82FA206.md): Mcclary Mong Sport · Cedar, MN · Accident · 1 fatal · Field investigation · Final report · Jun 13, 1982 · N5099 · Destroyed
  > Witnesses observed the acft enter a steep nose down attitude & slow spiral from which the acft did not recover.
- [NTSB ATL82FLQ06](https://openairdocs.org/ntsb/ATL82FLQ06.md): Bellanca 8KCAB · Mayfield, KY · Accident · 1 fatal · Final report · Jun 13, 1982 · N50352 · Destroyed
  > The aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…
- [NTSB LAX82FVD18](https://openairdocs.org/ntsb/LAX82FVD18.md): Cessna 172 · Mckinleyville, CA · Accident · No injuries · Final report · Jun 12, 1982 · N64187 · Substantial damage
  > The aircraft struck and severed 3 power lines about 3 miles south of the departure airport. Prior to the accident, it was observed flying at low altitude in the vicinity. The pilot stated that he flew by a mobile home park to verify that a trailer had been…
- [NTSB FTW82FPD14](https://openairdocs.org/ntsb/FTW82FPD14.md): Learjet 23 · Abilene, TX · Accident · No injuries · Final report · Jun 12, 1982 · N5DM · Substantial damage
  > About 5 min after takeoff, the pilot initiated a high speed low pass over the airport. When the aircraft was about 1000 ft from the airport at about 100 ft AGL, the richt winglet separated. A witness estimated that the aircraft's speed was about 200 mph.…
- [NTSB ANC82DAG31](https://openairdocs.org/ntsb/ANC82DAG31.md): Piper PA-18 · Anchorage, AK · Accident · No injuries · Final report · Jun 12, 1982 · N8653Y · Substantial damage
  > The pilot reported that before takeoff, he had trouble getting the engine to develop power. He called a mechanic who advised that conditions were right for carburetor icing. The mechanic suggested running the engine with carburetor heat applied. The pilot did…
- [NTSB SEA82DA085](https://openairdocs.org/ntsb/SEA82DA085.md): Bell 206B · Swan Valley, ID · Accident · No injuries · Final report · Jun 11, 1982 · N1074Z · Substantial damage
  > The aircraft crashed during an external load operation at an elevation of about 6700 ft MSL in mountainous terrain. The pilot reported that the fuel gauge indicated 8 gallons remaining when he last checked it before the accident. Reportedly, he checked his…
- [NTSB MIA82DA133](https://openairdocs.org/ntsb/MIA82DA133.md): Bell 47G-4 · N. Greenville, FL · Accident · No injuries · Final report · Jun 11, 1982 · N1151W · Substantial damage
  > The pilot took off at about 1922 to dispense a non-toxic liquid chemical and fertilizer on a nearby melon field. After one normal swath run on a northerly heading, he pulled up and began a procedure turn to the left (west). He stated the afternoon sun…
- [NTSB ATL82FA161](https://openairdocs.org/ntsb/ATL82FA161.md): Aerospatiale AS350D · Hazard, KY · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1982 · N5781Z · Destroyed
  > The helicopter was on an aerial survey flight with 3 engineers on board. During the flight, the pilot was flying to various areas in response to commands from the observers (engineers). While responding to a command, the helicopter collided with an electrical…
- [NTSB SEA82DA083](https://openairdocs.org/ntsb/SEA82DA083.md): Grumman G-164A · Dayton, WA · Accident · Minor injuries · Final report · Jun 9, 1982 · N7365 · Destroyed
  > The pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…
- [NTSB NYC82DA121](https://openairdocs.org/ntsb/NYC82DA121.md): Scheicher K8B · Shrewsbury, PA · Accident · No injuries · Final report · Jun 9, 1982 · N3353G · Substantial damage
  > The pilot was on a round robin, cross-country flight from woodbine, MD to Shrewsbury, PA and return. When he arrived over shewsbury, he maneuvered the glider to take a picture of his turn point. While taking the picture, he skidded the glider to include the…

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

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

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