# 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 34 of 377 · 18,849 cases

## Cases, newest first

- [NTSB ERA17CA187](https://openairdocs.org/ntsb/ERA17CA187.md): Robinson R22 · Linden, NJ · Accident · No injuries · Data collection · Final report · May 20, 2017 · N2322Z · Substantial damage
  > The flight instructor's failure to maintain helicopter control while hovering, which resulted in skid contact with the ground and a dynamic roll-over.
- [NTSB CEN17WA215](https://openairdocs.org/ntsb/CEN17WA215.md): Ayres S2R · Candillargues, France, France · Accident · No injuries · Foreign investigation · May 16, 2017 · F-GIEN · Substantial damage
  > On May 16, 2017, about 0530 hours universal coordinated time, an Ayres S2R airplane, French registration F-GIEN, was substantially damaged during a forced landing following a loss of engine power near Candillargues, France. The pilot was not injured. The…
- [NTSB GAA17CA285](https://openairdocs.org/ntsb/GAA17CA285.md): Air Tractor AT 802 · Dumas, TX · Accident · Minor injuries · Data collection · Final report · May 15, 2017 · N319BM · Substantial damage
  > The pilot’s failure to maintain lateral control while maneuvering at a low altitude.
- [NTSB CEN17WA221](https://openairdocs.org/ntsb/CEN17WA221.md): Silence Twister · Abingdon, United Kingdom · Accident · Serious injuries · Foreign investigation · May 14, 2017 · G-JINX · Substantial damage
  > On May 14, 2017, at 1330 universal coordinated time (UTC), a Silence model Twister single-engine airplane, United Kingdom registration G-JINX, serial number LAA 329-15102, was substantially damaged during a forced landing following a loss of engine power…
- [NTSB ERA17FA180](https://openairdocs.org/ntsb/ERA17FA180.md): Beech A36TC · Hopkinsville, KY · Accident · 2 fatal · Field investigation · Final report · May 12, 2017 · N1804E · Destroyed
  > The noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…
- [NTSB WPR17FA101](https://openairdocs.org/ntsb/WPR17FA101.md): Icon A5 · Lake Berryessa, CA · Accident · 2 fatal · Field investigation · Final report · May 8, 2017 · N184BA · Substantial damage
  > The pilot's failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot's mistaken entry into a canyon surrounded by steep rising terrain while at a low altitude for reasons that could not be…
- [NTSB CEN17LA179](https://openairdocs.org/ntsb/CEN17LA179.md): Beech 19 · Weatherford, TX · Accident · Minor injuries · Limited investigation · Final report · May 8, 2017 · N18925 · Substantial damage
  > The flight instructor’s inadequate in-flight fuel management, which resulted in fuel starvation and a total loss of engine power.
- [NTSB GAA17CA265](https://openairdocs.org/ntsb/GAA17CA265.md): Rotorcraft Development OH-58A+ · Waterloo, IL · Accident · No injuries · Data collection · Final report · May 7, 2017 · N993YC · Substantial damage
  > The pilot’s failure to see and avoid transmission wires while maneuvering at a low altitude.
- [NTSB CEN17LA176](https://openairdocs.org/ntsb/CEN17LA176.md): Thrush S2R-H80 · Gypsum, KS · Accident · No injuries · Limited investigation · Final report · May 5, 2017 · N3045R · Substantial damage
  > A total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…
- [NTSB ERA17TA170](https://openairdocs.org/ntsb/ERA17TA170.md): Bell 206 · Orange Springs, FL · Accident · Serious injuries · Final report · May 2, 2017 · N911GE · Substantial damage
  > The pilot's failure to maintain adequate clearance between the helicopter's skid and the firefighting bucket and suspension cable, which resulted in the cable becoming entangled on the landing skid and a subsequent loss of helicopter control.
- [NTSB CEN17WA172](https://openairdocs.org/ntsb/CEN17WA172.md): Piper PA31 · Schefferville, Canada · Accident · 2 fatal · Foreign investigation · Apr 30, 2017 · C-FQQB · Substantial damage
  > On April 30, 2017, a Piper PA-31 airplane, C-FQQB, impacted terrain near Schefferville, Quebec. The two pilots were fatality injured. The accident investigation is under the jurisdiction and control of the Canadian government. This report is for information…
- [NTSB CEN17FA169](https://openairdocs.org/ntsb/CEN17FA169.md): Champion 7KCAB · Collinston, LA · Accident · 2 fatal · Field investigation · Final report · Apr 30, 2017 · N1899G · Destroyed
  > The failure of the flight instructor and the commercial pilot to maintain adequate clearance from a power line during an aerial application training flight.
- [NTSB GAA17CA249](https://openairdocs.org/ntsb/GAA17CA249.md): Cessna 177 · Marathon, NY · Accident · No injuries · Data collection · Final report · Apr 28, 2017 · N3224T · Substantial damage
  > The pilot’s failure to maintain altitude and airspeed while maneuvering at a low altitude.
- [NTSB ERA17LA168](https://openairdocs.org/ntsb/ERA17LA168.md): Robinson R44 · Newton, NC · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2017 · N728CB · Substantial damage
  > The pilot's failure to maintain an adequate airspeed during out-of-ground-effect maneuvering at a low airspeed with a tailwind, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.
- [NTSB ERA17FA164](https://openairdocs.org/ntsb/ERA17FA164.md): Bell-Carson 47G Super C 4 · Timmonsville, SC · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2017 · N865Z · Destroyed
  > The pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.
- [NTSB CEN17LA165](https://openairdocs.org/ntsb/CEN17LA165.md): Air Tractor AT 602 · Vidrine, LA · Accident · No injuries · Limited investigation · Final report · Apr 21, 2017 · N653LA · Substantial damage
  > The total loss of engine power for reasons that could not be determined because an examination of the engine and a test run did not reveal any mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN17LA163](https://openairdocs.org/ntsb/CEN17LA163.md): Grumman Schweizer G-164 · Palmer, KS · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N9533 · Substantial damage
  > A crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.
- [NTSB CEN17WA161](https://openairdocs.org/ntsb/CEN17WA161.md): Champion 8KCAB · Cancun, Mexico · Accident · 1 fatal · Foreign investigation · Apr 14, 2017 · N65SE · Destroyed
  > The accident investigation is under the jurisdiction and control of the Mexican government. This report is for informational purposes only and contains only information released by or obtained from the Mexican government. Further information pertaining to…
- [NTSB GAA17CA225](https://openairdocs.org/ntsb/GAA17CA225.md): Weatherly 620B · Lewistown, MT · Accident · No injuries · Data collection · Final report · Apr 10, 2017 · N9004M · Substantial damage
  > The pilot’s failure to maintain altitude during low-altitude maneuvers in flat light conditions.
- [NTSB CEN17LA151](https://openairdocs.org/ntsb/CEN17LA151.md): Grumman Acft ENG Cor-Schweizer G 164A · Nome, TX · Accident · No injuries · Limited investigation · Final report · Apr 8, 2017 · N971QC · Destroyed
  > An in-flight fire for reasons that could not be determined based on available information.
- [NTSB WPR17FA085](https://openairdocs.org/ntsb/WPR17FA085.md): Piper PA 46-310P · Harrisburg, OR · Accident · 4 fatal · Field investigation · Final report · Apr 7, 2017 · N123SB · Destroyed
  > An encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…
- [NTSB CEN17FA147](https://openairdocs.org/ntsb/CEN17FA147.md): Piper PA-28-180 · Oxford, IA · Accident · 2 fatal · Field investigation · Final report · Apr 7, 2017 · N9179J · Destroyed
  > The failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.
- [NTSB WPR17LA092](https://openairdocs.org/ntsb/WPR17LA092.md): Piper PA 28-140 · Whittier, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 2017 · N55339 · Substantial damage
  > The pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR17LA084](https://openairdocs.org/ntsb/WPR17LA084.md): Cirrus Design SR22 · Brinnon, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2017 · N167CB · Substantial damage
  > The flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.
- [NTSB ERA17FA144](https://openairdocs.org/ntsb/ERA17FA144.md): Buckeye Dream Machine · Knoxville, TN · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2017 · N4017L · Substantial damage
  > The pilot's decision to maneuver the aircraft at low altitude, towards rising terrain, which resulted in an inflight collision with trees.
- [NTSB ERA17FA143](https://openairdocs.org/ntsb/ERA17FA143.md): Cessna 170B · Edgewater, FL · Accident · 2 fatal · Field investigation · Final report · Apr 1, 2017 · N8082A · 2 aircraft · Destroyed
  > The Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.
- [NTSB ERA17WA146](https://openairdocs.org/ntsb/ERA17WA146.md): Grumman G164 · Pista La Julia, Ecuador · Accident · 1 fatal · Foreign investigation · Mar 30, 2017 · HC-BPI · Destroyed
  > On March 30, 2017, about 1645 universal coordinated time, a Grumman 164A, Ecuadorian registration HC-BPI, was destroyed when it impacted electrical wires and terrain near Pista La Julia, Ecuador. The foreign certificated pilot was fatally injured. The flight…
- [NTSB WPR17WA083](https://openairdocs.org/ntsb/WPR17WA083.md): Robinson R22 · Reefton, New Zealand · Accident · 1 fatal · Foreign investigation · Mar 27, 2017 · ZK-IHA · Substantial damage
  > On March 27, 2017, about 0345 Universal Time, a Robinson R22, New Zealand registration ZK-IHA, impacted forested terrain about 5.5 miles north of Reefton, West Coast. The pilot, the sole occupant was fatally injured, and the helicopter was substantially…
- [NTSB GAA17CA202](https://openairdocs.org/ntsb/GAA17CA202.md): Cessna 182 · Mackay, ID · Accident · Minor injuries · Data collection · Final report · Mar 25, 2017 · N52743 · Substantial damage
  > The pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.
- [NTSB ERA17FA136](https://openairdocs.org/ntsb/ERA17FA136.md): Cessna T210 · Hayden, AL · Accident · 4 fatal · Field investigation · Final report · Mar 25, 2017 · N6563D · Destroyed
  > The pilot's decision to continue the flight into known adverse weather conditions, which resulted in spatial disorientation and a subsequent loss of airplane control and in-flight breakup.
- [NTSB ERA17FA135](https://openairdocs.org/ntsb/ERA17FA135.md): Cessna 500 · Marietta, GA · Accident · 1 fatal · Field investigation · Final report · Mar 24, 2017 · N8DX · Destroyed
  > The pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…
- [NTSB ERA17FA131](https://openairdocs.org/ntsb/ERA17FA131.md): Air Tractor AT 602 · Minter City, MS · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2017 · N2049D · Destroyed
  > The pilot's incapacitation for reasons that could not be determined, which resulted in collision with trees and terrain.
- [NTSB CEN17FA127](https://openairdocs.org/ntsb/CEN17FA127.md): Mcdonnell Douglas Heli 369FF · Chalmers, IN · Accident · 1 fatal · Field investigation · Final report · Mar 14, 2017 · N530KD · Destroyed
  > The pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.
- [NTSB CEN17WA129](https://openairdocs.org/ntsb/CEN17WA129.md): MD Helicopter 369 · Mexicali, Mexico · Accident · 5 fatal · Foreign investigation · Mar 13, 2017 · XC-PEP · Destroyed
  > On March 13, 2017, about 1600 hours pacific daylight time, a MD Helicopters model 369FF single-engine helicopter, serial number 0079FF, Mexican registration XC-PEP, collided with high-voltage power lines while maneuvering near Mexicali, Mexico. The pilot and…
- [NTSB CEN17WA128](https://openairdocs.org/ntsb/CEN17WA128.md): Piper PA25 · Etchoropo, Sonora, Mexico · Accident · 1 fatal · Foreign investigation · Mar 12, 2017 · XB-FHP · Destroyed
  > On March 12, 2017, at 2050 hours universal coordinated time, a Piper PA25-235 airplane, Mexican registration XB-FHP, impacted terrain near Etchoropo, Sonora, Mexico. The pilot was fatally injured. The airplane was destroyed by impact forces.The accident…
- [NTSB ERA17LA120](https://openairdocs.org/ntsb/ERA17LA120.md): Cessna 150J · Argyle, NY · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 5, 2017 · N60939 · Substantial damage
  > A total loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.
- [NTSB ERA17WA124](https://openairdocs.org/ntsb/ERA17WA124.md): Piper PA25 · Villa Tapia, Dominican Republic · Accident · 1 fatal · Foreign investigation · Mar 4, 2017 · N8569L · Destroyed
  > On March 4, 2017, about 1330 coordinated universal time, a Piper PA-25-235, N8969L, was destroyed following a collision with antenna wires and terrain during an aerial application flight near Villa Tapia, Dominican Republic. The pilot was fatally injured. The…
- [NTSB ERA17FA119](https://openairdocs.org/ntsb/ERA17FA119.md): Beech B 60 · Duette, FL · Accident · 2 fatal · Field investigation · Final report · Mar 4, 2017 · N39AG · Destroyed
  > The pilots' decision to perform flight training maneuvers at low airspeed at an altitude that was insufficient for stall recovery. Contributing to the accident was the flight instructor's inappropriate use of non-standard stall recovery techniques.
- [NTSB CEN17CA120](https://openairdocs.org/ntsb/CEN17CA120.md): Aero Commander S2R · Fairmont, OK · Accident · Serious injuries · Data collection · Final report · Mar 2, 2017 · N1755S · Substantial damage
  > The pilot’s failure to maintain clearance from a power line while conducting agricultural spray operations.
- [NTSB WPR17LA071](https://openairdocs.org/ntsb/WPR17LA071.md): Bell 206B · Firebaugh, CA · Accident · No injuries · Limited investigation · Final report · Mar 1, 2017 · N211CS · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge, which led the pilot to believe that there was adequate fuel onboard.
- [NTSB CEN17FA111](https://openairdocs.org/ntsb/CEN17FA111.md): Cessna 172S · Berthoud, CO · Accident · 2 fatal · Field investigation · Final report · Feb 27, 2017 · N2461N · Substantial damage
  > The failure of the pilots to apply prompt and/or correct flight control inputs to adequately recover from the intentional aerodynamic spin.
- [NTSB WPR17WA073](https://openairdocs.org/ntsb/WPR17WA073.md): Cessna 152 · Hong Kong, China · Accident · No injuries · Foreign investigation · Feb 26, 2017 · B-HHN · Substantial damage
  > On February 26, 2017, about 0314 Coordinated Universal Time, a Cessna 152, B-HHN, collided with trees and came to rest in the trees while attempting a forced landing as a result of a reported loss of engine power. The airplane was operated by Hong Kong…
- [NTSB ERA17WA349](https://openairdocs.org/ntsb/ERA17WA349.md): Piper PA25 · Santa Catarina, Brazil · Accident · 1 fatal · Foreign investigation · Feb 23, 2017 · PT-WBO · Substantial damage
  > On February 23, 2017, about 1030 coordinated universal time, an Piper PA-25-235, Brazilian registration PT-WBO, was substantially damaged when it impacted terrain during an aerial application flight near Santa Catarina, Brazil. The foreign certificated pilot…
- [NTSB WPR17WA069](https://openairdocs.org/ntsb/WPR17WA069.md): Hughes 369E · Raetihi, New Zealand · Accident · Serious injuries · Foreign investigation · Feb 19, 2017 · ZK-HRK · Substantial damage
  > On February 19, 2017, at 0930 local time, a McDonnell Douglas Hughes 369E, ZK-HRK, operated by Precision Helicopters Ltd. collided with a ridgeline in the Waimarino Forest near Raetihi, New Zealand during an external load operation. The helicopter was being…
- [NTSB ERA17LA110](https://openairdocs.org/ntsb/ERA17LA110.md): Piper PA28R · Bayonne, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2017 · N15745 · Substantial damage
  > Maintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.
- [NTSB WPR17LA068](https://openairdocs.org/ntsb/WPR17LA068.md): Robinson Helicopter R22 Beta · Holbrook, AZ · Accident · No injuries · Limited investigation · Final report · Feb 18, 2017 · N7095A · Substantial damage
  > The pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.
- [NTSB ERA17FA107](https://openairdocs.org/ntsb/ERA17FA107.md): Beech A45 · Climax, GA · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2017 · N3434G · Substantial damage
  > The failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.
- [NTSB GAA17CA151](https://openairdocs.org/ntsb/GAA17CA151.md): Robinson Helicopter R44 · Holtville, CA · Accident · No injuries · Data collection · Final report · Feb 14, 2017 · N4534G · Substantial damage
  > The pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.
- [NTSB WPR17FA063](https://openairdocs.org/ntsb/WPR17FA063.md): Cessna 172 · Ramona, CA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 2017 · N2179L · Substantial damage
  > The flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.
- [NTSB ANC17LA016](https://openairdocs.org/ntsb/ANC17LA016.md): Piper PA18 · Sterling, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2017 · N1268A · Substantial damage
  > The pilot’s loss of control while maneuvering for reasons that could not be determined based on the available information.

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

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

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