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

## Cases, newest first

- [NTSB SEA82FYK11](https://openairdocs.org/ntsb/SEA82FYK11.md): Cessna T210M · Cottage Grove, OR · Accident · 2 fatal · Final report · Jul 29, 1982 · N761ZY · Destroyed
  > The aircraft crashed while receiving radar vectors from eugene approach control to the vor-dme runway 34 approach at eugene, OR. Investigation revealed that the aircraft impacted tree tops in a level, nose down attitude and traveled approximately 180 yard…
- [NTSB NYC82DA172](https://openairdocs.org/ntsb/NYC82DA172.md): Hughes 269A · Westfield, MA · Accident · No injuries · Final report · Jul 29, 1982 · N8782F · Substantial damage
  > The helicopter started to spin around after takeoff during a hover in strong wind. The pilot decided to land. Sideloading broke a skid and the helicopter rolled over during touchdown.
- [NTSB CHI82IA282](https://openairdocs.org/ntsb/CHI82IA282.md): Cessna 172N · Columbus, OH · Incident · No injuries · Incident investigation · Final report · Jul 29, 1982 · N6292D · Minor damage
  > During stall recovery practice, the right control yoke jammed in the full forward position. Recovery was accomplished byplacing both feet on the instrument panel for leverage then pulling the yoke rearward. Investigation revealed that the RH nylon bearing on…
- [NTSB CHI82DA281](https://openairdocs.org/ntsb/CHI82DA281.md): Enstrom 280C · Spring Green, WI · Accident · No injuries · Final report · Jul 29, 1982 · N5698M · Substantial damage
  > The aircraft was on a photographic flight for the purpose of taking pictures of a piece of farm equipment. The first pass was made at about 50 ft AGL, heading into the wind. A turn was then made downwind, back toward the farm equipment. At about that time,…
- [NTSB LAX82FA279](https://openairdocs.org/ntsb/LAX82FA279.md): Cessna 152 · Morgan Hill, CA · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1982 · N5090Q · 2 aircraft · Substantial damage
  > A Cessna 152, N5090Q and a Cessna 172, N20100 collided in flight while the aircrews of both aircraft were on local dual instructional flights. The student in the Cessna 152 was practicing a recovery from an unusual attitude after the instructor (ip) put the…
- [NTSB CHI82DA279](https://openairdocs.org/ntsb/CHI82DA279.md): Bell 47G-2 · Plainview, MN · Accident · No injuries · Final report · Jul 28, 1982 · N19JM · Substantial damage
  > While making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…
- [NTSB ANC82DA063](https://openairdocs.org/ntsb/ANC82DA063.md): Piper PA-32-300 · Mckinley Nat'L., AK · Accident · Minor injuries · Final report · Jul 28, 1982 · N3093T · Substantial damage
  > The pilot was flying over one glacier at about 700 feet AGL and turned to fly to another upslope glacier. He encountereda downdraft and was unable to climb enough to avoid colliding with the glacier. The elevation of the crash site was about 6600 ft MSL.
- [NTSB DEN82DA144](https://openairdocs.org/ntsb/DEN82DA144.md): Piper PA-25-235 · Leonard, ND · Accident · No injuries · Final report · Jul 26, 1982 · N4461Y · Substantial damage
  > The pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.
- [NTSB CHI82DA276](https://openairdocs.org/ntsb/CHI82DA276.md): Piper PA25-235C · Ada, MN · Accident · No injuries · Final report · Jul 26, 1982 · N7208Z · Substantial damage
  > The pilot sprayed one field and proceeded to the next field about 2 miles away. He stated that he executed a tight 270 deg turn to the right at about 100 ft. he also stated that after about 90 deg through the turn, the aircraft lost power, stalled and…
- [NTSB SEA82FYM22](https://openairdocs.org/ntsb/SEA82FYM22.md): Piper 24-140 · Enterprise, OR · Accident · 3 fatal · Final report · Jul 25, 1982 · N55492 · Destroyed
  > Witnesses observed an aircraft fly over the city of Enterprise, Oregon on a bright night with clear sky conditions. Reportedly, the aircraft was flying very erratic; and just as it disappeared from the witnesses' sight, an explosion andfireball were observed…
- [NTSB DEN82DA143](https://openairdocs.org/ntsb/DEN82DA143.md): Cessna 150M · Nr. Colorado Sp, CO · Accident · No injuries · Final report · Jul 25, 1982 · N9424U · Destroyed
  > The acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.
- [NTSB SEA82DA128](https://openairdocs.org/ntsb/SEA82DA128.md): Aeronca 7AC · Kent, WA · Accident · Serious injuries · Final report · Jul 24, 1982 · N82651 · Destroyed
  > During practice steep turns the aircraft encountered its wake turbulence. Manuevers to regain control were not effective. The aircraft contacted trees in a nose low attitude.
- [NTSB FTW82FRJ14](https://openairdocs.org/ntsb/FTW82FRJ14.md): Cessna 188 · Monroe, LA · Accident · Serious injuries · Final report · Jul 24, 1982 · N9125G · Substantial damage
  > During turn around after first spray run, the aircraft collided with trees at an altitude of 75 feet. The path of flight was on a heading of 280 degrees, into the sun.
- [NTSB CHI82DA272](https://openairdocs.org/ntsb/CHI82DA272.md): Stinson 108-1 · Laporte, IN · Accident · No injuries · Final report · Jul 24, 1982 · N97904 · Substantial damage
  > The pilot/mechanic was preparing to make an annual inspection of the aircraft. He was in the process of flight testing the plane to find defects when engine stoppage occurred. While landing in a bean field. The left tire blew out and the left gear dug into…
- [NTSB CHI82DA270](https://openairdocs.org/ntsb/CHI82DA270.md): Austin S.E. 5A · Bolingbrook, IL · Accident · Serious injuries · Final report · Jul 24, 1982 · N8040Z · Destroyed
  > The pilots of an Austin s.e. 5A and a folker (both ww I replica aircraft) agreed to make a photo fly-by. The pilot of the Austin took off as number one, but instead of remaining in the traffic pattern, he turned out of the pattern. The folker pilot followed…
- [NTSB MKC82FCD08](https://openairdocs.org/ntsb/MKC82FCD08.md): Cessna A150L · New Hampton, IA · Accident · Serious injuries · Final report · Jul 23, 1982 · N5937J · Substantial damage
  > The aircraft crashed while maneuvering in the vicinity of the pilot/owner's private airfield. The pilot stated that plane went into a 180 deg reverse backslide after he started a left turn and applied left rudder and aileron. He reported that the plane began…
- [NTSB LAX82AA274](https://openairdocs.org/ntsb/LAX82AA274.md): Bell UH-1B · Valencia, CA · Accident · 3 fatal · Final report · Jul 23, 1982 · N87701 · Substantial damage
  > Acft being used to film movie scene depicting attack of village typical of villges in viet nam. Acft was about 25 ft AGL & above location where special effects explosives were detonated. As the plt turned acft for camera coverage, acft'stail section was…
- [NTSB CHI82FA267](https://openairdocs.org/ntsb/CHI82FA267.md): Robinson R22 · Milwaukee, WI · Accident · No injuries · Field investigation · Final report · Jul 23, 1982 · N9031F · Substantial damage
  > As the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…
- [NTSB LAX82FA269](https://openairdocs.org/ntsb/LAX82FA269.md): Cessna 150M · Orinda, CA · Accident · Minor injuries · Field investigation · Final report · Jul 21, 1982 · N8288U · Substantial damage
  > While enroute to oakland the plt reported experiencing a loss of climbing power at 2,000 ft near the san pablo reservoir. He applied carb heat, checked mixture setting & primer. He then extended full flaps & retarded the throttle just prior to landing in the…
- [NTSB LAX82DA271](https://openairdocs.org/ntsb/LAX82DA271.md): Grumman G-164A · Chandler, AZ · Accident · Minor injuries · Final report · Jul 21, 1982 · N6559 · Substantial damage
  > While spraying at night & during the fourth pass under power lines crossing the field, the acft contacted the wires. After the accident the flagger at the field informed the plt that the wind was causing the wires to whip up & down at times.
- [NTSB FTW82FPJ16](https://openairdocs.org/ntsb/FTW82FPJ16.md): Piper 18 · Gage, OK · Accident · Serious injuries · Final report · Jul 21, 1982 · N3937Z · Substantial damage
  > The aircraft was being used to spray grasshoppers and was flying in an easterly direction. The right wing struck a high line wire that is oriented north and south. After striking the wire the aircraft struck the ground approximately 190 feet east of the high…
- [NTSB FTW82FPD16](https://openairdocs.org/ntsb/FTW82FPD16.md): Cessna 188B · Stanford, TX · Accident · Serious injuries · Final report · Jul 21, 1982 · N731AK · Destroyed
  > The pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…
- [NTSB CHI82FA262](https://openairdocs.org/ntsb/CHI82FA262.md): Cessna 150L · Pontiac, IL · Accident · 2 fatal · Field investigation · Final report · Jul 21, 1982 · N18727 · Destroyed
  > Both plts onboard were cfi's. the acft was observed to slow down & enter a stall/spin which continued to impact.
- [NTSB MKC82FCQ13](https://openairdocs.org/ntsb/MKC82FCQ13.md): Cessna 152 · Rose Hill, KS · Accident · 1 fatal · Final report · Jul 20, 1982 · N5179B · Destroyed
  > The student pilot was on a solo flight while he was in a training phase to practice flight maneuvers. During the flight, the aircraft crashed and burned. An investigation revealed that the plane did not move after impact and both wings were crushed…
- [NTSB LAX82FA267](https://openairdocs.org/ntsb/LAX82FA267.md): Cessna T337H · Near Inyokern, CA · Accident · Serious injuries · Field investigation · Final report · Jul 20, 1982 · N1378L · Destroyed
  > Approximately 10 min after takeoff the acft impacted a ridge of a canyon at 5,500 ft MSL about 200 ft below the ridge line. The density altitude was 8,900 ft.
- [NTSB CHI82FA259](https://openairdocs.org/ntsb/CHI82FA259.md): Piper PA-25-150 · Winamac, IN · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1982 · N6241Z · Destroyed
  > The plt was practicing aerial application maneuvers, & after making a low pass down the rwy at his private airstrip, theengine quit. The acft collided with 30-FT high power lines located at the end of the strip. A state trooper who arrived at the scene 10 to…
- [NTSB CHI82DA261](https://openairdocs.org/ntsb/CHI82DA261.md): Grumman G-164B · East Grand Fork, MN · Accident · No injuries · Final report · Jul 20, 1982 · N8272K · Substantial damage
  > The acft stalled during pull-up from a swath run.
- [NTSB DEN82DA151](https://openairdocs.org/ntsb/DEN82DA151.md): Cessna 150F · Sheridan Lake, CO · Accident · No injuries · Final report · Jul 19, 1982 · N8232S · Substantial damage
  > The pilot reported that he was on a flight to check his fields and crops for possible hail damage. Reportedly, he decided to see how a friend was doing with his wheat harvest and to see if he had received hail damage. The pilot stated that he spotted his…
- [NTSB CHI82FA255](https://openairdocs.org/ntsb/CHI82FA255.md): Aeronca 7AC · Pine Valley Tow, WI · Accident · 2 fatal · Field investigation · Final report · Jul 19, 1982 · N85580 · Destroyed
  > The acft was observed flying at a low altitude to a point 1/4 mi NE of the town over a wooded area & began a turn to the left. During the turn the bank continued to increase & then the nose dropped & the acft descended steeply into the trees. The police…
- [NTSB SEA82FA117](https://openairdocs.org/ntsb/SEA82FA117.md): Piper PA-28-161 · Portland, OR · Accident · 1 fatal · Field investigation · Final report · Jul 18, 1982 · N2146Y · Destroyed
  > The pilot, enrolled in a course for a commercial pilot certificate, was scheduled for a solo flight from seattle to bremerton, Washington and return. He departed at about 1300 PDT. At about 1635 PDT, residents near the crash site reported that they saw and…
- [NTSB MIA82DA159](https://openairdocs.org/ntsb/MIA82DA159.md): Cessna 150 · Englewood, FL · Accident · No injuries · Final report · Jul 18, 1982 · N6440T · Substantial damage
  > As the pilot was climbing through about 700 ft MSL, he observed a person on the beach waving at his aircraft. He thought the person was someone he knew so had made a descending turn to 500 ft to take a better look. When he determined that it was the wrong…
- [NTSB LAX82DA264](https://openairdocs.org/ntsb/LAX82DA264.md): Bell 204 · Delano, CA · Accident · No injuries · Final report · Jul 18, 1982 · N910PD · Destroyed
  > The acft was spraying for mediterranean fruit flies with another acft. Entering a "scissors" or opposite direction pattern with the second helicopter spraying in the opposite direction, the plt had to slow down in order to begin his swath at the completion of…
- [NTSB LAX82FUJ42](https://openairdocs.org/ntsb/LAX82FUJ42.md): Air Tractor 301 · Yuma, AZ · Accident · 1 fatal · Final report · Jul 16, 1982 · N8538S · Destroyed
  > The pilot had completed his last load of the day and was en route back to the airport. According to witnesses, the aircraft entered a nose high attitude, then the nose dropped and the plane entered a spin. It struck the ground before recovering from the spin.…
- [NTSB LAX82FUQ16](https://openairdocs.org/ntsb/LAX82FUQ16.md): Grumman G-164 · Lancaster, CA · Accident · Serious injuries · Final report · Jul 15, 1982 · N4589 · Destroyed
  > Plt was spraying very low due to wind conditions. Acft struck a water sprinkler & immediately caught on fire.
- [NTSB MKC82FCQ12](https://openairdocs.org/ntsb/MKC82FCQ12.md): Cessna 172 · Medicine Lodge, KS · Accident · Serious injuries · Final report · Jul 14, 1982 · N75802 · Destroyed
  > The acft stalled while the plt was buzzing his grandfather's fishing cabin on a lake.
- [NTSB CHI82DA247](https://openairdocs.org/ntsb/CHI82DA247.md): Aero Commander S2R · Graceville, MN · Accident · No injuries · Final report · Jul 14, 1982 · N3690X · Destroyed
  > The pilot was on an aerial application flight to a field with power lines alongside. The wind was reported to be from the southeast a 6, gusting 11 KTS. The pilot said that he encountered "dead air" while he was in his fourth porcedure turn. Due to the…
- [NTSB FTW82FPG18](https://openairdocs.org/ntsb/FTW82FPG18.md): Grumman G-164A · Casa, AR · Accident · Serious injuries · Final report · Jul 12, 1982 · N4657 · Destroyed
  > The aircraft collided with rising terrain during a procedure turn. While spraying a rice field.
- [NTSB CHI82DA245](https://openairdocs.org/ntsb/CHI82DA245.md): Hughes 269A · Davison, MI · Accident · No injuries · Final report · Jul 12, 1982 · N8902F · Substantial damage
  > The student pilot was making a 180 degree pedal turn to the right while hovering. The instructor pilot (ip) stated that after 90 degrees of turn, the rate of turning started to increase and the student applied left pedal to slow the turn. The ip noted that…
- [NTSB MKC82DA120](https://openairdocs.org/ntsb/MKC82DA120.md): Piper PA-22-160 · Stockton, MO · Accident · No injuries · Final report · Jul 11, 1982 · N9319D · Substantial damage
  > The aircraft was one of a flight of four, making demonstration flybys at the airport. The pilot stated that he was slow flying, about 80 to 85 ft AGL, when the aircraft started to sink. At that time, he was about 1000 to 1500 ft behind, to the right, and 20…
- [NTSB FTW82FQG19](https://openairdocs.org/ntsb/FTW82FQG19.md): Piper PA-25 · Edmonson, TX · Accident · 1 fatal · Final report · Jul 10, 1982 · N4979Y · Destroyed
  > The pilot had been spraying the field for about 1 hr and was on the last pass. The owner/flagger stated that he had warned the pilot (by using a two way radio) to watch out for a standpipe and radio antenna, and the pilot acknowledged. He reported the plane…
- [NTSB FTW82DA276](https://openairdocs.org/ntsb/FTW82DA276.md): Cessna T188C · Marvell, AR · Accident · No injuries · Final report · Jul 9, 1982 · N9635J · Substantial damage
  > An aerial application of an oil-based material resulted in a smearing of the windscreen. The pilot landed on a grass strip to clear the windscreen, and during, the landing, the aircraft flipped over. The pilot said when he applied brakes, the left wheel broke…
- [NTSB SEA82DA104](https://openairdocs.org/ntsb/SEA82DA104.md): Piper PA-32-300 · 51 Nm Ese Yakut, AK · Accident · Minor injuries · Final report · Jul 8, 1982 · N1119X · Destroyed
  > The pilot reported that during departure, he proceeded east along the alsek river and along the south side of the alsek glacier while climbing to 6200 ft. he then decided that the intended route was closed due to low clouds and he initiated a turn to reverse…
- [NTSB FTW82DPG17](https://openairdocs.org/ntsb/FTW82DPG17.md): Rockwell S2R · Blackton, AR · Accident · No injuries · Final report · Jul 8, 1982 · N1762S · Destroyed
  > The eng failed during a swath run & the acft struck a rice levee drg the forced landing in an adjacent bean field. After exiting the aircraft and while talking to his flagman the pilot stated the aircraft began to burn around the engine area. The fire spread…
- [NTSB CHI82DA241](https://openairdocs.org/ntsb/CHI82DA241.md): Cessna 188B · Stevens Point, WI · Accident · Serious injuries · Final report · Jul 8, 1982 · N9284G · Destroyed
  > The pilot stated that when he was pulling up from a swath run, he noticed a left spray nozzle was leaking. At the same time, he noticed a person on the porch of a house that he was flying over. As he looked to see if the house and person would be avoided, the…
- [NTSB ATL82DA190](https://openairdocs.org/ntsb/ATL82DA190.md): Cessna A188B · Lula, MS · Accident · No injuries · Final report · Jul 7, 1982 · N731EG · Substantial damage
  > During a swath run under electrical transmission lines, the vertical stabilizer and rudder contacted the wires and separated from the aircraft. The pilot attempted to return to the airport, but was unable to control the aircraft. He then attempted an…
- [NTSB ATL82DA189](https://openairdocs.org/ntsb/ATL82DA189.md): Balloon Works Firefly 7 · Greenville, SC · Accident · No injuries · Final report · Jul 5, 1982 · N2236H · Substantial damage
  > The ballon with three persons on board dropped too low in a target hitting contest. The pilot then decided he could not climb above wires so he vented the Balloon in an attempt to land short. The bag contacted the wires and burned. The pilot stated he…
- [NTSB MKC82DA116](https://openairdocs.org/ntsb/MKC82DA116.md): Grumman G164A · Ericson, NE · Accident · No injuries · Final report · Jul 4, 1982 · N48534 · Substantial damage
  > The aircraft was flown from the loading area to the field intended for treatment. Upon arrival, the pilot reduced power and entered an observation fly-by. When the aircraft started to settle the pilot's application of power failed to arrest the descent. The…
- [NTSB CHI82DA238](https://openairdocs.org/ntsb/CHI82DA238.md): Piper PA-28-200R · Black River Fal, WI · Accident · No injuries · Final report · Jul 4, 1982 · N56339 · Substantial damage
  > The pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…
- [NTSB FTW82IA268](https://openairdocs.org/ntsb/FTW82IA268.md): Bell 47G2A1 · Near Mertzon, TX · Incident · No injuries · Incident investigation · Final report · Jul 3, 1982 · N73983 · Minor damage
  > While the aircraft was being hovered low and slow around a water trough, directional control was lost. The pilot autorotated to the ground and on touchdown the right skid buckled and the tailrotor gearbox separated when it struck an ant hill. The pilot…
- [NTSB FTW82DA258](https://openairdocs.org/ntsb/FTW82DA258.md): Grumman G-164B · Swifton, AR · Accident · Serious injuries · Final report · Jul 2, 1982 · N9869 · Destroyed
  > The pilot was engaged in an aerial application flight over a rice field with multiple high tension wires. At the beginning of a swath run, the aircraft struck power lines and crashed. The pilot had no recollection of the accident.

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

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

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