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

## Cases, newest first

- [NTSB CEN17LA284](https://openairdocs.org/ntsb/CEN17LA284.md): Air Tractor AT802 · Reyno, AR · Accident · No injuries · Class 3 · Limited · Final report · Jul 18, 2017 · N816FF · Substantial damage
  > The pilot’s inadvertent use of the propeller control, which caused the propeller to feather while in flight with the engine still operating, resulting in a loss of thrust and a subsequent forced landing.
- [NTSB CEN17LA272](https://openairdocs.org/ntsb/CEN17LA272.md): Piper PA-25-235 · Pierce, NE · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 2017 · N7388Z · Substantial damage
  > The pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.
- [NTSB ERA17WA271](https://openairdocs.org/ntsb/ERA17WA271.md): Cessna 172 · Khuzhir, Russia · Accident · Serious injuries · Foreign investigation · Jul 16, 2017 · RA-2842G · Substantial damage
  > On July 16, 2017, at 1300 coordinated universal time, a Cessna 172M, Russian registration RA-2842G, ditched into Lake Baikal, near Khuzhir, Irkutskaya Oblast, Russia, after a total loss of engine power. The airplane incurred substantial damage during the…
- [NTSB CEN17FA270](https://openairdocs.org/ntsb/CEN17FA270.md): North American/Aero Classics P 51 · Cummings, KS · Accident · 2 fatal · Field investigation · Final report · Jul 16, 2017 · N251PW · Destroyed
  > The loss of airplane control while maneuvering at low altitude for reasons that could not be determined.
- [NTSB WPR17FA149](https://openairdocs.org/ntsb/WPR17FA149.md): Aviat A · Herriman, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 2017 · N211AM · Destroyed
  > The flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…
- [NTSB ERA17LA266](https://openairdocs.org/ntsb/ERA17LA266.md): Piper PA28R · Pembroke Pines, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 2017 · N55612 · Substantial damage
  > The loss of engine power for reasons that could not be determined postaccident engine test-runs revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA17CA406](https://openairdocs.org/ntsb/GAA17CA406.md): Robinson Helicopter R22 · Wilkes-Barre, PA · Accident · Minor injuries · Data collection · Final report · Jul 10, 2017 · N2336J · Substantial damage
  > The flight instructor's delayed remedial action to maintain helicopter altitude during hover flight instruction, which resulted in the helicopter skid contacting a crack in the runway and a dynamic rollover.
- [NTSB WPR17LA145](https://openairdocs.org/ntsb/WPR17LA145.md): Piper L 21B · Big Timber, MT · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2017 · N99031 · Substantial damage
  > The pilot's decision to fly at low altitude in the vicinity of power lines, which resulted in a wire strike.
- [NTSB CEN17LA267](https://openairdocs.org/ntsb/CEN17LA267.md): Robinson Helicopter R44 · Ireland, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2017 · N7224U · Destroyed
  > The pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.
- [NTSB CEN17FA259](https://openairdocs.org/ntsb/CEN17FA259.md): Air Tractor AT 602 · Cash, AR · Accident · 1 fatal · Field investigation · Final report · Jul 8, 2017 · N4257R · Destroyed
  > The pilot's incapacitation due to a cardiac event, which resulted in a loss of airplane control.
- [NTSB GAA17CA401](https://openairdocs.org/ntsb/GAA17CA401.md): Robinson Helicopter R44 · Paoli, IN · Accident · No injuries · Data collection · Final report · Jul 7, 2017 · N3203D · Substantial damage
  > The pilot's decision to maneuver an overgross weight helicopter at a low altitude and airspeed with a gusting tailwind, which resulted in a high descent rate and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB ERA17LA235](https://openairdocs.org/ntsb/ERA17LA235.md): Cessna T337 · Greenwood, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N337J · Substantial damage
  > The pilots' inadequate preflight inspection, during which they failed to adequately verify the quantity of fuel, which resulted in fuel exhaustion, a subsequent total loss of power to both engines, and a forced landing into trees. Contributing to the accident…
- [NTSB WPR17LA143](https://openairdocs.org/ntsb/WPR17LA143.md): Robinson Helicopter R44 II · Ronan, MT · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 2017 · N442DR · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in a loss of tail rotor effectiveness during a low-altitude orbiting maneuver and a subsequent hard landing.
- [NTSB GAA17CA393](https://openairdocs.org/ntsb/GAA17CA393.md): Bell 206 · Dixon, KY · Accident · No injuries · Data collection · Final report · Jul 6, 2017 · N8159J · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s failure to adequately identify hazards to flight during agricultural application operation planning.
- [NTSB GAA17CA386](https://openairdocs.org/ntsb/GAA17CA386.md): Alexander Schleicher ASH 31 MI · Ely, NV · Accident · Minor injuries · Data collection · Final report · Jul 5, 2017 · N31MX · Destroyed
  > The pilot’s failure to maintain the proper airspeed and his exceedance of the glider’s critical angle of attack, which resulted in a stall/spin.
- [NTSB WPR17LA140](https://openairdocs.org/ntsb/WPR17LA140.md): Robinson R44 · Bella Vista, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2017 · N488AS · Substantial damage
  > A partial loss of engine power during low-altitude maneuvering for reasons that could not be determined because postaccident examinations of the engine and airframe revealed no evidence of any preaccident mechanical malfunctions or failures that would have…
- [NTSB GAA17CA388](https://openairdocs.org/ntsb/GAA17CA388.md): Cessna 207 · Hope, AK · Accident · No injuries · Data collection · Final report · Jul 3, 2017 · N9620M · Substantial damage
  > The pilot’s inadvertent flight into instrument meteorological conditions and subsequent controlled flight into terrain.
- [NTSB GAA17CA385](https://openairdocs.org/ntsb/GAA17CA385.md): Air Tractor AT 502 · Edna, TX · Accident · No injuries · Data collection · Final report · Jul 2, 2017 · N6135P · Substantial damage
  > The pilot’s failure to see and avoid a tower during an agricultural application flight.
- [NTSB ERA17FA231](https://openairdocs.org/ntsb/ERA17FA231.md): Cessna 152 · Homestead, FL · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2017 · N49453 · Destroyed
  > The pilot's loss of control due to spatial disorientation while maneuvering in night conditions over an area devoid of ground reference lights.
- [NTSB WPR17FA139](https://openairdocs.org/ntsb/WPR17FA139.md): North Wing Uum Sport X2 912 · Chelan, WA · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2017 · N492XB · Destroyed
  > The flight instructor's failure to maintain control of the aircraft while demonstrating a spiral dive, which resulted in a loss of control. Contributing to the accident was the instructor's decision to demonstrate a spiral dive maneuver at an altitude that…
- [NTSB GAA17CA402](https://openairdocs.org/ntsb/GAA17CA402.md): Bell 206 · Uniontown, KY · Accident · No injuries · Data collection · Final report · Jun 30, 2017 · N60KH · Substantial damage
  > The pilot's failure to maintain adequate separation from power lines, which resulted in a loss of helicopter control.
- [NTSB CEN17LA244](https://openairdocs.org/ntsb/CEN17LA244.md): Air Tractor AT 602 · Stirum, ND · Accident · 1 fatal · Limited investigation · Final report · Jun 29, 2017 · N4196Y · Destroyed
  > The pilot's decision to attempt flight with low-level fog in the area, which resulted in an encounter with instrument meteorological conditions and impact with terrain.
- [NTSB GAA17CA369](https://openairdocs.org/ntsb/GAA17CA369.md): Bell 206B · Entiat, WA · Accident · No injuries · Data collection · Final report · Jun 26, 2017 · N183TC · Substantial damage
  > The pilot’s failure to secure a loose item inside the cockpit that interfered with antitorque pedal control and led to a loss of helicopter control due to a loss of tail rotor effectiveness.
- [NTSB ANC17CA044](https://openairdocs.org/ntsb/ANC17CA044.md): Brantly B2 · St. Michael, AK · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N5955X · Substantial damage
  > The pilot’s inadequate supervision of the refueling process, which resulted in a loss of engine power due to water contamination in the helicopter’s fuel system from the fuel drum and subsequent impact with terrain.
- [NTSB CEN17LA241](https://openairdocs.org/ntsb/CEN17LA241.md): Cessna 172 · Fulton, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 2017 · N6474B · Substantial damage
  > The partial loss of engine power due to water contamination in the fuel system.
- [NTSB ERA17WA224](https://openairdocs.org/ntsb/ERA17WA224.md): MD Helicopter 500 · Schinias Marathonas, Greece · Accident · 2 fatal · Foreign investigation · Jun 23, 2017 · SX-HBB · Substantial damage
  > On June 23, 2017, about 0645 universal coordinated time, a MD Helicopter 500E, Greek registration SX-HBB, was substantially damaged when it struck a power line and impacted terrain near Schinias Marathonas, Greece. The Greek certificated pilot and one…
- [NTSB ERA17LA209](https://openairdocs.org/ntsb/ERA17LA209.md): Hughes 369 · Dennis, WV · Accident · No injuries · Limited investigation · Final report · Jun 23, 2017 · N765KV · Substantial damage
  > The unporting of fuel due to the helicopter's nose-up attitude during long line operations, which resulted in fuel starvation and a total loss of engine power.
- [NTSB GAA17CA368](https://openairdocs.org/ntsb/GAA17CA368.md): Schempp-Hirth Discus 2B · Bishop, CA · Accident · Minor injuries · Data collection · Final report · Jun 22, 2017 · N21TH · Substantial damage
  > The pilot’s exceedance of the glider’s critical angle of attack while maneuvering over rising mountainous terrain, which resulted in an aerodynamic stall.
- [NTSB GAA17CA360](https://openairdocs.org/ntsb/GAA17CA360.md): Air Tractor AT 502 · Portales, NM · Accident · No injuries · Data collection · Final report · Jun 22, 2017 · N700LA · Destroyed
  > The pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.
- [NTSB GAA17CA356](https://openairdocs.org/ntsb/GAA17CA356.md): Robinson Helicopter R22 · Matagorda, TX · Accident · No injuries · Data collection · Final report · Jun 21, 2017 · N901KC · Substantial damage
  > The pilot’s failure to maintain helicopter control during an agricultural flight in gusting wind conditions.
- [NTSB GAA17CA355](https://openairdocs.org/ntsb/GAA17CA355.md): Bell UH1B · Williams, CA · Accident · No injuries · Data collection · Final report · Jun 21, 2017 · N6180A · Substantial damage
  > The pilot’s failure to maintain clearance from transmission wires while maneuvering at a low altitude during an agricultural application flight.
- [NTSB CEN17WA237](https://openairdocs.org/ntsb/CEN17WA237.md): Amateur Construction Kolb Firefly · Luffenhall, United Kingdom · Accident · 1 fatal · Foreign investigation · Jun 20, 2017 · G-CEPN
  > On June 20, 2017, about 0920 Coordinated Universal Time (UTC), a Kolb Firefly ultralite, British registration G-CEPN, impacted terrain under unknown circumstances near Newell Lane, Luffenhall, Hertfordshire, England. The pilot, the sole occupant on board, was…
- [NTSB WPR17FA128](https://openairdocs.org/ntsb/WPR17FA128.md): Prescot E. Wilkie RV-3 · Payette, ID · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2017 · N177TT · Destroyed
  > The in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.
- [NTSB CEN17LA232](https://openairdocs.org/ntsb/CEN17LA232.md): Bell-Tellijohn 47G · Hastings, MN · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2017 · N90529 · Substantial damage
  > The pilot's failure to maintain helicopter control for reasons that could not be determined because postaccident examination of the helicopter did not reveal any preimpact mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB CEN17LA230](https://openairdocs.org/ntsb/CEN17LA230.md): Grumman G164 · Delaplaine, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 2017 · N7501Z · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted in a forced landing on unsuitable terrain.
- [NTSB GAA17CA321](https://openairdocs.org/ntsb/GAA17CA321.md): Ag-Cat G 164 · Tulelake, CA · Accident · No injuries · Data collection · Final report · Jun 5, 2017 · N80083 · Substantial damage
  > The pilot’s improper decision to perform a low altitude fly-by over ground equipment, which resulted in the airplane striking the equipment.
- [NTSB WPR17FA120](https://openairdocs.org/ntsb/WPR17FA120.md): Piper PA 28-180 · Santa Rosa Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jun 4, 2017 · N4871L · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall and subsequent loss of control.
- [NTSB CEN17LA216](https://openairdocs.org/ntsb/CEN17LA216.md): William D Telfair/Zia Z Telfai Excalibur · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jun 4, 2017 · N78DZ · Substantial damage
  > The loss of pitch control due to the overload failure of the control rod.
- [NTSB CEN17FA209](https://openairdocs.org/ntsb/CEN17FA209.md): Robinson Helicopter R44 II · Dimmitt, TX · Accident · 1 fatal · Field investigation · Final report · Jun 3, 2017 · N7091F · Substantial damage
  > The pilot's incapacitation due to scarring from previous heart attacks and severe hypertrophy of the left ventricular wall which resulted in arrhythmia and a loss of control while maneuvering at low altitude.
- [NTSB CEN17IA233](https://openairdocs.org/ntsb/CEN17IA233.md): Schroder David Lancair IV P · Fulton, NY · Incident · No injuries · Incident investigation · Final report · Jun 1, 2017 · N366TF · No damage
  > The loss of oil pressure and subsequent engine overspeed/surge during a zero g-force maneuver, which resulted in the separation of a crankshaft counterweight and loss of engine power.
- [NTSB CEN17LA202](https://openairdocs.org/ntsb/CEN17LA202.md): Piper PA36 · El Campo, TX · Accident · Serious injuries · Limited investigation · Final report · May 28, 2017 · N3711E · Substantial damage
  > Foam contamination in the fuel injector nozzles from deteriorated foam baffles and water in the fuel flow divider, the combination of which resulted in the loss of engine power.
- [NTSB WPR17FA108](https://openairdocs.org/ntsb/WPR17FA108.md): Piper PA 30 · Haines, AK · Accident · 2 fatal · Field investigation · Final report · May 27, 2017 · N7376Y · Substantial damage
  > The pilot's decision to turn toward the inoperative engine after conducting a low-level pass, which resulted in an aerodynamic stall at too low an altitude to recover. Contributing to the accident was the pilot's decision to perform the flight and the engine…
- [NTSB ERA17LA194](https://openairdocs.org/ntsb/ERA17LA194.md): Avions Mudry Cie CAP 231 · Lebanon, PA · Accident · No injuries · Limited investigation · Final report · May 27, 2017 · N231X · Substantial damage
  > The partial separation of one counterweight and the subsequent seizure of the engine due to mechanical interference. Contributing to the partial separation of the counterweight was the overstress fracture of a retaining ring and the fatigue fracture of the…
- [NTSB ANC17FA026](https://openairdocs.org/ntsb/ANC17FA026.md): Arctic S 1B2 · Salcha, AK · Accident · 2 fatal · Field investigation · Final report · May 27, 2017 · N57AT · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering in high winds, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's improper decision to load the…
- [NTSB WPR17LA113](https://openairdocs.org/ntsb/WPR17LA113.md): Bell 206B · Rockville, ID · Accident · Serious injuries · Limited investigation · Final report · May 26, 2017 · N24FS · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of engine power and a subsequent hard landing.
- [NTSB GAA17CA305](https://openairdocs.org/ntsb/GAA17CA305.md): Grumman Acft ENG Cor-Schweizer G-164 · Maxwell, CA · Accident · Serious injuries · Data collection · Final report · May 26, 2017 · N6674K · Substantial damage
  > The pilot's failure to visually check the fuel quantity during the preflight inspection and ensure that sufficient fuel was onboard for the flight, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN17FA197](https://openairdocs.org/ntsb/CEN17FA197.md): Aerotek Pitts S 2A · Sheboygan Falls, WI · Accident · 2 fatal · Field investigation · Final report · May 26, 2017 · N67PN · Substantial damage
  > The pilot's failure to maintain airplane control following a partial loss of engine power during a low-level aerobatic maneuver; the reason for the loss of engine power could not be determined during postaccident examination of the engine. Contributing to the…
- [NTSB CEN17FA196](https://openairdocs.org/ntsb/CEN17FA196.md): Piper J3C · Chetek, WI · Accident · 1 fatal · Field investigation · Final report · May 24, 2017 · N35132 · Substantial damage
  > The pilot's failure to maintain control of the airplane while flying at a low altitude, which resulted in the airplane exceeding the critical angle of attack and a subsequent aerodynamic stall.
- [NTSB GAA17CA299](https://openairdocs.org/ntsb/GAA17CA299.md): Thomas E Hudzinski Backcountry Super CR · Talkeetna, AK · Accident · No injuries · Data collection · Final report · May 21, 2017 · N484WT · Substantial damage
  > The pilot’s failure to maintain a proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA17WA192](https://openairdocs.org/ntsb/ERA17WA192.md): Robinson R22 · Kwa-Zulu Natal, South Africa · Accident · 1 fatal · Foreign investigation · May 20, 2017 · ZS-RIT · Substantial damage
  > The South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…

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

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

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