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

## Cases, newest first

- [NTSB GAA16CA213](https://openairdocs.org/ntsb/GAA16CA213.md): Robinson Helicopter R22 · Troutdale, OR · Accident · Minor injuries · Data collection · Final report · May 4, 2016 · N227SH · Substantial damage
  > The flight instructor's failure to monitor outside the helicopter during hover flight, which resulted in a collision with terrain and rollover.
- [NTSB CEN16FA171](https://openairdocs.org/ntsb/CEN16FA171.md): Mcdonnell Douglas Helicopter 369E · Reedsville, WI · Accident · 1 fatal · Field investigation · Final report · May 4, 2016 · N629JK · Substantial damage
  > The failure of the power turbine governor's dual-spool bearing due to a lack of lubrication, which resulted in a complete loss of engine power and subsequent impact with terrain.
- [NTSB ERA16WA180](https://openairdocs.org/ntsb/ERA16WA180.md): Robinson R22 · Sao Paulo, Brazil · Accident · 2 fatal · Foreign investigation · May 2, 2016 · PR-RCA · Substantial damage
  > On May 5, 2016, about 1515 universal coordinated time, a Robinson R22 Beta, Brazilian registration PR-RCA, operated by AGD Aviation, was substantially damaged when it impacted wires and then terrain while maneuvering in Sao Paulo, Brazil. The flight…
- [NTSB WPR16FA097](https://openairdocs.org/ntsb/WPR16FA097.md): Extra Flugzeugproduktions-Und EA 300/L · Henderson, NV · Accident · 2 fatal · Field investigation · Final report · Apr 30, 2016 · N330MT · Destroyed
  > The pilot's failure to monitor and maintain clearance with terrain while maneuvering at low level. Contributing to the accident, was the pilot's failure to conduct an adequate amount of clearing turns while maneuvering at low level.
- [NTSB WPR16LA099](https://openairdocs.org/ntsb/WPR16LA099.md): Bell 47G 5 · San Ardo, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 29, 2016 · N6288N · Substantial damage
  > The failure of the pin in the outboard end of the lateral flight control torque tube.
- [NTSB GAA16CA205](https://openairdocs.org/ntsb/GAA16CA205.md): Burkhart Grob Flugzeugbau G103 Twin Astir · Marana, AZ · Accident · Minor injuries · Data collection · Final report · Apr 24, 2016 · N40880 · Substantial damage
  > The glider's loss of lift as a result of unfavorable wind conditions for glider operations, consequently resulting in a collision with trees.
- [NTSB CEN16FA169](https://openairdocs.org/ntsb/CEN16FA169.md): Cessna 182L · Carrollton, OH · Accident · 1 fatal · Field investigation · Final report · Apr 24, 2016 · N42411 · Substantial damage
  > An in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.
- [NTSB CEN16LA161](https://openairdocs.org/ntsb/CEN16LA161.md): Bell 47G-2A · Los Fresnos, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 2016 · N64702 · Destroyed
  > The pilot's inability to see and avoid the power lines because of trees obscuring his view.
- [NTSB CEN16WA174](https://openairdocs.org/ntsb/CEN16WA174.md): Cessna 150 · Strakonice, Czechia · Accident · 1 fatal · Foreign investigation · Apr 20, 2016 · OK-OKA · Substantial damage
  > On April 20, 2016, at 1253 universal coordinated time (UTC), a Cessna 150 airplane, Czech Republic registration OK-OKA, serial number 150741140, sustained substantial damage when it impacted terrain near the Strakonice Airport (LKST), Strakonice, Czech…
- [NTSB ANC16FA019](https://openairdocs.org/ntsb/ANC16FA019.md): Cessna 172 · Chugiak, AK · Accident · 4 fatal · Field investigation · Final report · Apr 20, 2016 · N63541 · Substantial damage
  > The in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.
- [NTSB CEN16LA156](https://openairdocs.org/ntsb/CEN16LA156.md): Bell 206 · Arden Hills, MN · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 18, 2016 · N119SP · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available evidence
- [NTSB CEN16LA154](https://openairdocs.org/ntsb/CEN16LA154.md): Air Tractor AT 502 · Kilbourne, LA · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 18, 2016 · N301LA · Destroyed
  > The failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.
- [NTSB ERA16CA160](https://openairdocs.org/ntsb/ERA16CA160.md): Bell 206 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Apr 16, 2016 · N326AC · Destroyed
  > The pilot's inadequate compensation for the wind while hovering out of ground effect, which resulted in a loss of tail rotor effectiveness.
- [NTSB CEN16FA146](https://openairdocs.org/ntsb/CEN16FA146.md): Rockwell 690B · Taylor, TX · Accident · 2 fatal · Field investigation · Final report · Apr 9, 2016 · N690TH · Destroyed
  > A loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.
- [NTSB ERA16FA144](https://openairdocs.org/ntsb/ERA16FA144.md): Bell 206 · Pigeon Forge, TN · Accident · 5 fatal · Field investigation · Final report · Apr 4, 2016 · N16760 · Destroyed
  > An inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…
- [NTSB GAA16CA173](https://openairdocs.org/ntsb/GAA16CA173.md): Beech F35 · Long Island, NC · Accident · Minor injuries · Data collection · Final report · Mar 30, 2016 · N4212B · Substantial damage
  > The pilot's decision to maneuver at low altitude, which resulted in a collision with power lines and substantial damage to the vertical stabilizer.
- [NTSB CEN16LA139](https://openairdocs.org/ntsb/CEN16LA139.md): Air Tractor AT-402 · Beyersville, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 29, 2016 · N4555E · Substantial damage
  > The pilot's failure to maintain visual separation from the power line due to a lack of identifiable and contrasting features, which led to an inflight collision with the line while maneuvering in gray, hazy conditions.
- [NTSB GAA16CA165](https://openairdocs.org/ntsb/GAA16CA165.md): Bell 206B · Hanford, CA · Accident · Minor injuries · Data collection · Final report · Mar 26, 2016 · N52Q · Substantial damage
  > The pilot's decision to release the collective while flying at 10 feet above ground level, resulting in the rapid helicopter descent and impact with terrain.
- [NTSB WPR16WA089](https://openairdocs.org/ntsb/WPR16WA089.md): Bell 206 · Carmila West, Australia · Accident · 1 fatal · Foreign investigation · Mar 25, 2016 · VH-WHU · Destroyed
  > On March 25, 2016, at 1028 local time, a Bell 206B, VH-WHU, collided with power lines during an aerial agriculture flight near Carmila West, Australia. The helicopter was destroyed by the post impact fire and the pilot was fatally injured. The flight was…
- [NTSB GAA16CA166](https://openairdocs.org/ntsb/GAA16CA166.md): Piper J5A · Lake Harbor, FL · Accident · Minor injuries · Data collection · Final report · Mar 25, 2016 · N41239 · Substantial damage
  > The pilot's exceedance of the critical angle of attack while maneuvering at low altitude, which resulted in an accelerated aerodynamic stall, spin, and impact with terrain.
- [NTSB CEN16LA135](https://openairdocs.org/ntsb/CEN16LA135.md): Brantly B 2B · Galena, MO · Accident · Serious injuries · Limited investigation · Final report · Mar 25, 2016 · N2266U · Substantial damage
  > The pilot’s loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA16LA139](https://openairdocs.org/ntsb/ERA16LA139.md): Hall, Wendall W Harmon Rocket II · Cheraw, SC · Accident · 1 fatal · Limited investigation · Final report · Mar 24, 2016 · N729PS · Substantial damage
  > The pilot's decision to fly at low altitude, which resulted in a collision with power lines.
- [NTSB WPR16FA087](https://openairdocs.org/ntsb/WPR16FA087.md): North American AT 6A · Astoria, OR · Accident · 2 fatal · Field investigation · Final report · Mar 23, 2016 · N7055D · Destroyed
  > The pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.
- [NTSB GAA16CA160](https://openairdocs.org/ntsb/GAA16CA160.md): Robinson R44 · Oak Island, NC · Accident · Minor injuries · Data collection · Final report · Mar 23, 2016 · N843JB · Substantial damage
  > The student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.
- [NTSB CEN16FA130](https://openairdocs.org/ntsb/CEN16FA130.md): Aeronca 7AC · Ellsworth, NE · Accident · 1 fatal · Field investigation · Final report · Mar 20, 2016 · N84580 · Destroyed
  > The pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…
- [NTSB WPR16LA082](https://openairdocs.org/ntsb/WPR16LA082.md): Grumman G164 · Juliaetta, ID · Accident · No injuries · Limited investigation · Final report · Mar 12, 2016 · N6894Q · Substantial damage
  > A partial loss of engine power due to a crack in the No. 2 cylinder.
- [NTSB CEN16LA123](https://openairdocs.org/ntsb/CEN16LA123.md): Brockman William A Challenger II · Neshkoro, WI · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 2016 · N710WB · Substantial damage
  > A total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…
- [NTSB CEN16LA121](https://openairdocs.org/ntsb/CEN16LA121.md): Ariosto James J Ariosto Mustang II · Normangee, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 2016 · N12JA · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.
- [NTSB WPR16LA079](https://openairdocs.org/ntsb/WPR16LA079.md): Piper PA 22-150 · Fountain Hills, AZ · Accident · No injuries · Limited investigation · Final report · Mar 2, 2016 · N4356A · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR16LA075](https://openairdocs.org/ntsb/WPR16LA075.md): Robinson Helicopter R66 · Torrance, CA · Accident · No injuries · Limited investigation · Final report · Feb 23, 2016 · N266RH · Substantial damage
  > A vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…
- [NTSB ERA16LA106](https://openairdocs.org/ntsb/ERA16LA106.md): Piper PA28 · Destin, FL · Accident · 2 fatal · Limited investigation · Final report · Feb 13, 2016 · N2209W · Destroyed
  > The noninstrument-rated pilot's decision to turn the airplane away from the lighted airport at low altitude, over water, with no visible horizon, in dark night conditions, which resulted in spatial disorientation and a loss of airplane control.
- [NTSB WPR16FA067](https://openairdocs.org/ntsb/WPR16FA067.md): Flight Design Ctls · Springville, CA · Accident · 2 fatal · Field investigation · Final report · Feb 11, 2016 · N911TS · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…
- [NTSB WPR16FA065](https://openairdocs.org/ntsb/WPR16FA065.md): Beech M35 · San Pedro, CA · Accident · 3 fatal · Field investigation · Final report · Feb 5, 2016 · N9872R · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.
- [NTSB WPR16FA064](https://openairdocs.org/ntsb/WPR16FA064.md): North American F51 · Maricopa, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 5, 2016 · N551JP · Substantial damage
  > The pilot’s failure to maintain airplane control while performing an acrobatic maneuver and his subsequent failure to recover from an inadvertent spin due to insufficient altitude.
- [NTSB ERA16WA101](https://openairdocs.org/ntsb/ERA16WA101.md): Robinson R66 · Aviatornyi, Russia · Accident · Serious injuries · Foreign investigation · Feb 2, 2016 · RA-06239 · Destroyed
  > On February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…
- [NTSB GAA16LA117](https://openairdocs.org/ntsb/GAA16LA117.md): Helicopteres Guimbal Cabri · Beaumont, TX · Accident · No injuries · Limited investigation · Final report · Jan 30, 2016 · N503DS · Substantial damage
  > The pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.
- [NTSB CEN16WA165](https://openairdocs.org/ntsb/CEN16WA165.md): Diamond DA42 · Vasteras, Sweden · Accident · Serious injuries · Foreign investigation · Jan 22, 2016 · SE-LVR · Substantial damage
  > On January 22, 2016, at 1807 universal coordinate time, a Diamond DA42, Swedish registration SE-LVR, operated by Airways Flygutbildning, collided with the terrain in Vasteras, Sweden, following a loss of control. The flight instructor, the pilot receiving…
- [NTSB CEN16LA102](https://openairdocs.org/ntsb/CEN16LA102.md): Piper PA31 · Denton, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 22, 2016 · N997DN · Substantial damage
  > The total loss of engine power due to fuel exhaustion for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB GAA16LA100](https://openairdocs.org/ntsb/GAA16LA100.md): Enstrom F-28 · Ritter Butte, OR · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 2016 · N756H · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.
- [NTSB GAA16CA101](https://openairdocs.org/ntsb/GAA16CA101.md): Cessna 182 · Baton Rouge, LA · Accident · No injuries · Data collection · Final report · Jan 11, 2016 · N4423R · Substantial damage
  > An inadvertent collision with a bird while maneuvering during an aerial observation flight.
- [NTSB WPR16FA046](https://openairdocs.org/ntsb/WPR16FA046.md): Aerostar S A YAK 52 · Alpine, WY · Accident · 2 fatal · Field investigation · Final report · Jan 4, 2016 · N912EB · Destroyed
  > The pilot's failure to maintain clearance from snow-covered terrain in flat light conditions.
- [NTSB WPR16LA045](https://openairdocs.org/ntsb/WPR16LA045.md): Piper PA18 · Newman Lake, WA · Accident · No injuries · Limited investigation · Final report · Jan 1, 2016 · N2684A · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ANC16LA011](https://openairdocs.org/ntsb/ANC16LA011.md): Cessna 172 · Anchorage, AK · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 2015 · N914CP · Destroyed
  > The pilot's intentional flight into a building.
- [NTSB CEN16LA084](https://openairdocs.org/ntsb/CEN16LA084.md): Schweizer 269C · Warrenton, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 2015 · N292B · Destroyed
  > The noninstrument-rated pilot's continued flight into instrument meteorological conditions at night, which resulted in the loss of visual reference to the ground and his subsequent failure to maintain clearance from trees.
- [NTSB GAA16CA102](https://openairdocs.org/ntsb/GAA16CA102.md): Piper PA 18A · Girdwood, AK · Accident · No injuries · Data collection · Final report · Dec 21, 2015 · N2791P · Substantial damage
  > Fuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.
- [NTSB WPR16FA040](https://openairdocs.org/ntsb/WPR16FA040.md): Airbus Helicopters AS350 · Superior, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2015 · N74317 · Substantial damage
  > The pilot's loss of helicopter control in mountainous terrain as the result of operating the helicopter outside the performance envelope of its hydraulic system and encountering the servo transparency phenomenon. Contributing to the accident was the pilot's…
- [NTSB ERA16LA070](https://openairdocs.org/ntsb/ERA16LA070.md): Cirrus Design SR20 · Charles Town, WV · Accident · No injuries · Limited investigation · Final report · Dec 16, 2015 · N614CD · Substantial damage
  > The flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.
- [NTSB GAA16CA082](https://openairdocs.org/ntsb/GAA16CA082.md): Aeronca 7BCM · Reidsville, NC · Accident · No injuries · Data collection · Final report · Dec 13, 2015 · N1316V · Substantial damage
  > The pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.
- [NTSB GAA16CA080](https://openairdocs.org/ntsb/GAA16CA080.md): Aviat A1 · Broadus, MT · Accident · Minor injuries · Data collection · Final report · Dec 13, 2015 · N29712 · Substantial damage
  > The pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.
- [NTSB WPR16FA036](https://openairdocs.org/ntsb/WPR16FA036.md): Barnett Allen S RV7 · Hurricane, UT · Accident · 2 fatal · Class 3 · Field · Final report · Dec 10, 2015 · N307AB · Substantial damage
  > The pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.

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

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

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