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

## Cases, newest first

- [NTSB CEN17WA380](https://openairdocs.org/ntsb/CEN17WA380.md): Schweizer 269C · Locarno, Switzerland · Incident · No injuries · Foreign investigation · Feb 7, 2017 · HB-XFQ · No damage
  > On February 7, 2017, about 1016 universal coordinated time (UTC), a Schweizer 269C helicopter, Swiss registration HB-XFQ, conducted a precautionary landing near Locarno (LSZL), Switzerland, after the engine oil pressure was at minimum pressure and the oil…
- [NTSB ERA17CA101](https://openairdocs.org/ntsb/ERA17CA101.md): Robinson R22 · West Palm Beach, FL · Accident · No injuries · Data collection · Final report · Feb 6, 2017 · N7685H · Substantial damage
  > The flight instructor’s failure to maintain helicopter control while demonstrating low rotor rpm operations from a hover.
- [NTSB ERA17CA099](https://openairdocs.org/ntsb/ERA17CA099.md): Robinson Helicopter R22 · Fallston, MD · Accident · No injuries · Data collection · Final report · Feb 4, 2017 · N7518G · Substantial damage
  > The student pilot's failure to relinquish the flight controls to the flight instructor, which resulted in a collision with terrain.
- [NTSB WPR17LA061](https://openairdocs.org/ntsb/WPR17LA061.md): Beech 95 B55 (T42A) · Cameron Park, CA · Accident · No injuries · Class 3 · Limited · Final report · Feb 1, 2017 · N321BJ · Substantial damage
  > Failure of the landing gear to extend as a result of excessive wear within the landing gear gearbox and motor, which resulted in a gear-up landing.
- [NTSB CEN17LA096](https://openairdocs.org/ntsb/CEN17LA096.md): Cook Smith Aviation Repli · Justin, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 2017 · N712AZ · Substantial damage
  > A total loss of engine power due to fuel starvation as the result of a disruption in fuel flow.
- [NTSB CEN17FA095](https://openairdocs.org/ntsb/CEN17FA095.md): Cessna 177 · Price, TX · Accident · 1 fatal · Field investigation · Final report · Jan 31, 2017 · N2810X · Destroyed
  > The pilot's failure to maintain clearance from a communications tower guy-wire. Contributing to the accident was the pilot's decision to conduct a long distance transition flight at a low altitude.
- [NTSB WPR17WA060](https://openairdocs.org/ntsb/WPR17WA060.md): Grumman American G-73 · Perth, Australia · Accident · 2 fatal · Foreign investigation · Jan 26, 2017 · VH-CQA · Destroyed
  > On January 26, 2017, at 1708 local time, a Grumman American Aviation Corp. G-73, VH-CQA, collided with water while maneuvering near Perth, Australia. The airplane and the pilot and passenger were fatally injured. The flight was operated under the pertinent…
- [NTSB CEN17FA080](https://openairdocs.org/ntsb/CEN17FA080.md): Bellanca 7GCBC · Wellington, TX · Accident · 2 fatal · Field investigation · Final report · Jan 21, 2017 · N91Z · Destroyed
  > The pilot's improper decision to perform a steep turn at low altitude, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.
- [NTSB GAA17CA118](https://openairdocs.org/ntsb/GAA17CA118.md): Cessna 140 · Markleeville, CA · Accident · No injuries · Data collection · Final report · Jan 17, 2017 · N5623C · Substantial damage
  > The pilot’s failure to maintain altitude during a low pass and the subsequent impact with a snow berm, which resulted in a nosed-over.
- [NTSB GAA17CA117](https://openairdocs.org/ntsb/GAA17CA117.md): Air Tractor AT 802 · Vernon, UT · Accident · No injuries · Data collection · Final report · Jan 17, 2017 · N20361 · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain.
- [NTSB ERA17FA088](https://openairdocs.org/ntsb/ERA17FA088.md): Sharpe William L Buccaneer II B · Mayo, FL · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2017 · N696FT · Substantial damage
  > The pilot's failure to see and avoid power lines while flying at low altitude.
- [NTSB CEN17FA075](https://openairdocs.org/ntsb/CEN17FA075.md): Fields Steen Skybolt · Era, TX · Accident · 1 fatal · Field investigation · Final report · Jan 12, 2017 · N94RG · Substantial damage
  > The pilot’s loss of airplane control while conducting aerobatic flight maneuvers with insufficient altitude to recover.
- [NTSB WPR17FA047](https://openairdocs.org/ntsb/WPR17FA047.md): Robinson Helicopter R22 Beta · San Pedro, CA · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2017 · N702JJ · Substantial damage
  > The pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing. Also causal was the pilot's failure to maintain rotor rpm following the loss of engine…
- [NTSB ERA17LA075](https://openairdocs.org/ntsb/ERA17LA075.md): Cessna 172 · Bridgeport, AL · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2016 · N3772F · Substantial damage
  > The pilot's decision to make steep turns to the right while operating on the right fuel tank with low fuel quantity, which led to a loss of engine power due to unporting of the right fuel tank and fuel starvation.
- [NTSB ERA17LA070](https://openairdocs.org/ntsb/ERA17LA070.md): Beech A36 · Ormond Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 17, 2016 · N410BC · Substantial damage
  > The pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.
- [NTSB ERA17WA079](https://openairdocs.org/ntsb/ERA17WA079.md): Air Tractor AT502 · Primavera do Leste, Brazil · Accident · 1 fatal · Foreign investigation · Dec 13, 2016 · PR-AJF · Destroyed
  > On December 13, 2016, about 1930 coordinated universal time, an Air Tractor AT-502B, Brazilian registration PR-AJF, was destroyed after it impacted terrain and was subject to a postcrash fire, during an agricultural spraying operation near Primavera do Leste,…
- [NTSB WPR17WA039](https://openairdocs.org/ntsb/WPR17WA039.md): Robinson R44 · Juhu, India · Accident · 1 fatal · Foreign investigation · Dec 11, 2016 · VT-PHB · Destroyed
- [NTSB CEN17FA050](https://openairdocs.org/ntsb/CEN17FA050.md): Cub Crafters PA18 · Basin, WY · Accident · 1 fatal · Field investigation · Final report · Dec 7, 2016 · N444GB · Substantial damage
  > The pilot exceeded the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.
- [NTSB ANC17FA009](https://openairdocs.org/ntsb/ANC17FA009.md): Bellanca 7GCBC · Fairbanks, AK · Accident · 1 fatal · Class 3 · Field · Final report · Dec 7, 2016 · N88452 · Substantial damage
  > The pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…
- [NTSB ERA17FA066](https://openairdocs.org/ntsb/ERA17FA066.md): Fairchild SA227 · Camilla, GA · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2016 · N765FA · Destroyed
  > The pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.
- [NTSB CEN17WA052](https://openairdocs.org/ntsb/CEN17WA052.md): PZL Bielsko SZD51 · Husbands Bosworth, United Kingdom · Accident · 1 fatal · Foreign investigation · Dec 4, 2016 · G-CSFT · 2 aircraft · Destroyed
  > On December 4, 2016, about 1230 coordinated universal time, a PZL Bielsko SZD-51-1 glider, G-CSFT, and a Cessna 150L airplane, G-CSFC, collided in midair near Husbands Bosworth, Leicestershire, United Kingdom. The glider impacted terrain and the pilot was…
- [NTSB ERA17WA303](https://openairdocs.org/ntsb/ERA17WA303.md): Schempp Hirth VENTUS2C · San Carlos de Bolivar, Argentina · Accident · 1 fatal · Foreign investigation · Dec 3, 2016 · LV-EDB · Substantial damage
  > On December 3, 2016, about 1750 coordinated universal time, a Schempp Hirth Ventus-2C motorized glider, Argentine registration LV-EDB, operated by a private individual, was substantially damaged when it impacted terrain after the left wing detached from the…
- [NTSB WPR17WA026](https://openairdocs.org/ntsb/WPR17WA026.md): Air Tractor AT802 · Trangie, Australia · Accident · 1 fatal · Foreign investigation · Nov 21, 2016 · VH-NIA · Destroyed
- [NTSB WPR17FA021](https://openairdocs.org/ntsb/WPR17FA021.md): Hughes 369 · Pukoo, HI · Accident · 2 fatal · Field investigation · Final report · Nov 16, 2016 · N81GG · Destroyed
  > The pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.
- [NTSB WPR17WA022](https://openairdocs.org/ntsb/WPR17WA022.md): Robinson R66 · Winton, New Zealand · Accident · No injuries · Foreign investigation · Nov 14, 2016 · ZK-HAG · Substantial damage
  > On November 14, 2016, at 0230 universal coordinated time, a Robinson R-66, ZK-HAG, operated by Heliops Southland Limited under the pertinent regulations of the government of New Zealand, was substantially damaged after the helicopter experienced a low rotor…
- [NTSB WPR17LA020](https://openairdocs.org/ntsb/WPR17LA020.md): Piper PA 28-235 · Taylor, AZ · Accident · No injuries · Limited investigation · Final report · Nov 12, 2016 · N9398W · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.
- [NTSB CEN17LA038](https://openairdocs.org/ntsb/CEN17LA038.md): Weatherly 620B · Coleman, TX · Accident · No injuries · Limited investigation · Final report · Nov 12, 2016 · N2035J · Substantial damage
  > The pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA17FA038](https://openairdocs.org/ntsb/ERA17FA038.md): Quad City Challenger · Crescent City, FL · Accident · 2 fatal · Field investigation · Final report · Nov 9, 2016 · N327SH · Destroyed
  > An abrupt pitch-up maneuver following a descent, which resulted in the in-flight separation of the right wing due to the overload failure of both the forward and aft right wing attachment brackets.
- [NTSB WPR17WA028](https://openairdocs.org/ntsb/WPR17WA028.md): Air Tractor AT502 · Walgett, Australia · Accident · 1 fatal · Foreign investigation · Nov 5, 2016 · VH-LIK · Destroyed
- [NTSB ERA17LA031](https://openairdocs.org/ntsb/ERA17LA031.md): Haddow William H Pitts Special S 1 · New Bern, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 2016 · N27832 · Substantial damage
  > A loss of biplane control during aerobatic maneuvers for reasons that could not be determined because a portion of the biplane's flight control system was not recovered and could not be tested.
- [NTSB CEN17LA033](https://openairdocs.org/ntsb/CEN17LA033.md): North American TB 25N · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Oct 29, 2016 · N25YR · Substantial damage
  > The overstress failure of the landing gear connecting rod and the improper installation of the arresting cables, which allowed the landing gear door to depart in flight and impact the airplane.
- [NTSB ANC17FA003](https://openairdocs.org/ntsb/ANC17FA003.md): Cessna 172 · Palmer, AK · Accident · 1 fatal · Field investigation · Final report · Oct 29, 2016 · N6353E · Substantial damage
  > The student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.
- [NTSB WPR17LA014](https://openairdocs.org/ntsb/WPR17LA014.md): Aerospatiale AS350 · Starbuck, WA · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N369BD · Substantial damage
  > A total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.
- [NTSB ERA17CA030](https://openairdocs.org/ntsb/ERA17CA030.md): Kolb Fire FLY · West Middlesex, PA · Accident · Minor injuries · Data collection · Final report · Oct 28, 2016 · UNREG · Substantial damage
  > The noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.
- [NTSB CEN17LA099](https://openairdocs.org/ntsb/CEN17LA099.md): Robinson R22 Beta · Asherton, TX · Accident · No injuries · Limited investigation · Final report · Oct 28, 2016 · N522KC · Substantial damage
  > The partial loss of engine power due to the failure of the magneto's internal timing during low-altitude maneuvering.
- [NTSB CEN17LA027](https://openairdocs.org/ntsb/CEN17LA027.md): Air Tractor AT 502B · Hereford, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 2016 · N8525G · Substantial damage
  > The pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.
- [NTSB ERA17FA027](https://openairdocs.org/ntsb/ERA17FA027.md): Nanchang CJ6 · Blackshear, GA · Accident · 1 fatal · Field investigation · Final report · Oct 21, 2016 · N10EB · 2 aircraft · Substantial damage
  > The Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collision
- [NTSB ERA17LA024](https://openairdocs.org/ntsb/ERA17LA024.md): Cessna 172 · Cedar Key, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2016 · N1827Y · Substantial damage
  > A partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…
- [NTSB GAA17CA030](https://openairdocs.org/ntsb/GAA17CA030.md): Air Tractor AT 502 · Paragould, AR · Accident · Minor injuries · Data collection · Final report · Oct 18, 2016 · N4218E · Substantial damage
  > The pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.
- [NTSB ERA17WA021](https://openairdocs.org/ntsb/ERA17WA021.md): Cessna 172 · Peloponnese, Greece · Accident · 2 fatal · Foreign investigation · Oct 16, 2016 · 5B-CLB · Destroyed
  > On October 16, 2016, about 1415 universal coordinated time, a Cessna 172P, Greek registration 5B-CLB, was destroyed when it impacted mountainous terrain while performing a cross-country training flight near Peloponnese, Greece. The Greek certificated…
- [NTSB CEN17FA016](https://openairdocs.org/ntsb/CEN17FA016.md): Makela RV-4 · Oregonia, OH · Accident · 2 fatal · Field investigation · Final report · Oct 16, 2016 · N2626C · Destroyed
  > The pilot's decision to fly at a low altitude, which resulted in the collision with a zipline.
- [NTSB ERA17LA007](https://openairdocs.org/ntsb/ERA17LA007.md): James Bruton Flying Flea · Plymouth, CT · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 2016 · N83165 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR17LA002](https://openairdocs.org/ntsb/WPR17LA002.md): Tamarack Helicopters UH-1H · Gila Bend, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2016 · N175SF · Substantial damage
  > The separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.
- [NTSB CEN17LA006](https://openairdocs.org/ntsb/CEN17LA006.md): Cessna 172K · Wilmot, WI · Accident · No injuries · Limited investigation · Final report · Oct 4, 2016 · N46377 · Substantial damage
  > A failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.
- [NTSB CEN17FA005](https://openairdocs.org/ntsb/CEN17FA005.md): Beech D95A · Hitchcock, TX · Accident · 1 fatal · Field investigation · Final report · Oct 4, 2016 · N76S · Destroyed
  > The flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…
- [NTSB ERA17FA001](https://openairdocs.org/ntsb/ERA17FA001.md): Culver PQ 14A · Hickory, NC · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2016 · N4648V · Destroyed
  > The loss of engine power due to carburetor icing. Contributing to the accident was the pilot's use of automobile gasoline, which increased the likelihood of carburetor icing.
- [NTSB ANC16RA074](https://openairdocs.org/ntsb/ANC16RA074.md): Pitts S2 · Seoul, South Korea · Accident · 1 fatal · Foreign investigation · Sep 24, 2016 · HL1161 · Substantial damage
  > On September 24, 2016, about 1132 local time, an Aviat Pitts S-2B airplane, Republic of Korea registration number HL1161, operated by the pilot, was destroyed following an impact with terrain during an airshow at Taean Airfield, Republic of Korea. The pilot…
- [NTSB CEN16WA377](https://openairdocs.org/ntsb/CEN16WA377.md): Piper PA28 · Gödöllo, Pest, Hungary, Hungary · Accident · 4 fatal · Foreign investigation · Sep 18, 2016 · HA-APZ · 2 aircraft · Destroyed
- [NTSB WPR16LA184](https://openairdocs.org/ntsb/WPR16LA184.md): OGG Richard A OGG Glasair I · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2016 · N70GG · Substantial damage
  > The failure of an induction elbow following an engine backfire, which resulted in an in-flight fire and loss of engine power.
- [NTSB WPR16LA181](https://openairdocs.org/ntsb/WPR16LA181.md): Dehavilland DH115 Vampire · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2016 · N4861K · Substantial damage
  > The in-flight failure of the canopy and subsequent loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.

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

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

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