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

## Cases, newest first

- [NTSB CEN11CA667](https://openairdocs.org/ntsb/CEN11CA667.md): Tompkins Tandem Rocket · Lemars, IA · Accident · Minor injuries · Data collection · Final report · Sep 25, 2011 · N29RT · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering.
- [NTSB WPR11CA467](https://openairdocs.org/ntsb/WPR11CA467.md): Robinson R22 Beta · Douglas, WY · Accident · No injuries · Data collection · Final report · Sep 24, 2011 · N3070S · Substantial damage
  > The pilot's failure to maintain yaw control of the helicopter while hover taxiing in gusty wind conditions.
- [NTSB ERA11LA503](https://openairdocs.org/ntsb/ERA11LA503.md): Cessna 120 · Cordele, GA · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2011 · N3101N · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN11FA666](https://openairdocs.org/ntsb/CEN11FA666.md): Robinson Helicopter R44 · Curren, MI · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2011 · N8324F · Substantial damage
  > The non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.
- [NTSB ANC11TA110](https://openairdocs.org/ntsb/ANC11TA110.md): Bell 206 B3 · Seward, AK · Accident · No injuries · Final report · Sep 23, 2011 · N204PA · Substantial damage
  > The pilot's failure to maintain clearance from snow-covered terrain during hover in deteriorating weather and flat light conditions, which resulted in a tail rotor strike.
- [NTSB WPR11LA461](https://openairdocs.org/ntsb/WPR11LA461.md): Bunker RLV-1 · Wells, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2011 · N49S · Substantial damage
  > The pilot did not maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot’s inadequate in-flight planning.
- [NTSB WPR11LA459](https://openairdocs.org/ntsb/WPR11LA459.md): Mcarthur Steen Skybolt · Greenleaf, ID · Accident · No injuries · Limited investigation · Final report · Sep 19, 2011 · N77VW · Substantial damage
  > Structural failure of the upper left wing during aerobatic flight.
- [NTSB WPR11LA458](https://openairdocs.org/ntsb/WPR11LA458.md): Aviat Pitts S-2B · Redlands, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 2011 · N46BT · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s impairment from alcohol.
- [NTSB CEN11FA652](https://openairdocs.org/ntsb/CEN11FA652.md): Concannon Milton Radial ROC · Socorro, NM · Accident · 2 fatal · Field investigation · Final report · Sep 19, 2011 · N91TX · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…
- [NTSB ERA11FA495](https://openairdocs.org/ntsb/ERA11FA495.md): North American T-28C · Martinsburg, WV · Accident · 1 fatal · Field investigation · Final report · Sep 17, 2011 · N688GR · Substantial damage
  > The pilot's impairment or incapacitation that occurred during a low-altitude aerobatic maneuver due to complications from a recent heart attack, resulting in his inability to maintain control of the airplane. Contributing to the accident was the Federal…
- [NTSB ERA11FA493](https://openairdocs.org/ntsb/ERA11FA493.md): Cessna 172M · Greenville, ME · Accident · 1 fatal · Field investigation · Final report · Sep 17, 2011 · N9932V · Substantial damage
  > The pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.
- [NTSB WPR11MA454](https://openairdocs.org/ntsb/WPR11MA454.md): North American/Aero Classics P-51D · Reno, NV · Accident · 11 fatal · Class 1 · Major · Final report · Sep 16, 2011 · N79111 · Substantial damage
  > The reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…
- [NTSB CEN11WA690](https://openairdocs.org/ntsb/CEN11WA690.md): Piper PA 28 · Montpellier, France · Accident · No injuries · Foreign investigation · Sep 16, 2011 · F-HMAT · Substantial damage
  > On September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…
- [NTSB CEN11LA646](https://openairdocs.org/ntsb/CEN11LA646.md): Bell 206B · Spicewood, TX · Accident · No injuries · Limited investigation · Final report · Sep 15, 2011 · N3181J · Substantial damage
  > The pilot did not maintain adequate rotor rpm during a low-altitude maneuvering flight.
- [NTSB CEN11FA645](https://openairdocs.org/ntsb/CEN11FA645.md): Remos Aircraft Gmbh Flugzeugba GX · Noblesville, IN · Accident · 2 fatal · Field investigation · Final report · Sep 15, 2011 · N107GX · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.
- [NTSB WPR11FA448](https://openairdocs.org/ntsb/WPR11FA448.md): Cessna 182H · Stanley, ID · Accident · 2 fatal · Field investigation · Final report · Sep 13, 2011 · N2404X · Substantial damage
  > The pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…
- [NTSB CEN11LA635](https://openairdocs.org/ntsb/CEN11LA635.md): Fairchild M-62A-3 · Waukegan, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 2011 · N103JC · Substantial damage
  > The pilot’s inadequate preflight inspection of the airplane, which resulted in fuel exhaustion and a total loss of engine power. Contributing to the accident were a malfunctioning fuel gauge and air traffic that prevented an on airport landing.
- [NTSB WPR11WA484](https://openairdocs.org/ntsb/WPR11WA484.md): Aerospatiale AS350 · Rockhampton, Australia, Australia · Accident · No injuries · Foreign investigation · Sep 8, 2011 · VH-RDU · Substantial damage
  > On September 8, 2011, at 0203 universal coordinated time, an Aerospatiale Industries AS-350BA, VH-RDU, collided with the terrain near Rockhampton, Australia. The helicopter was substantially damaged. Of the three occupants on board, two were fatally injured…
- [NTSB CEN11FA629](https://openairdocs.org/ntsb/CEN11FA629.md): Cirrus Design SR22 · West Liberty, OH · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2011 · N159JW · Substantial damage
  > The pilot’s improper decision to fly aerobatic maneuvers at low altitude, which resulted in a loss of control and impact with terrain. Contributing to the accident was the pilot’s impairment due to his recent use of multiple impairing drugs.
- [NTSB CEN11LA623](https://openairdocs.org/ntsb/CEN11LA623.md): Hoffmann HK36R Super Dimona · Winsted, MN · Accident · 1 fatal · Limited investigation · Final report · Sep 5, 2011 · N63RK · Substantial damage
  > The pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB WPR11GA431](https://openairdocs.org/ntsb/WPR11GA431.md): Bell 205 · Tehachapi, CA · Accident · Minor injuries · Final report · Sep 4, 2011 · N205WW · Substantial damage
  > The pilot's inability to adequately execute an emergency autorotation due to the flight's low altitude during external load operations, which resulted in a hard landing. Contributing to the accident was a torsionally overstressed tachometer shaft, which sent…
- [NTSB WPR11FA430](https://openairdocs.org/ntsb/WPR11FA430.md): Cessna P210 · Tehachapi, CA · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2011 · N7WJ · Destroyed
  > The pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.
- [NTSB WPR11WA438](https://openairdocs.org/ntsb/WPR11WA438.md): Robinson R44 · Plutonic Aero., Australia, Australia · Accident · 1 fatal · Foreign investigation · Sep 3, 2011 · VH-HCA · Substantial damage
  > On September 3, 2011, at 0330 universal coordinated time, a Robinson R44, Australia registry VH-HCA, collided with terrain while maneuvering near Plutonic Aerodrome, Australia. The helicopter was operated by Wieland Helicopter Company under the pertinent…
- [NTSB ANC11FA091](https://openairdocs.org/ntsb/ANC11FA091.md): Cessna 208B · Nightmute, AK · Accident · 1 fatal · Field investigation · Final report · Sep 2, 2011 · N207DR · 2 aircraft · Destroyed
  > The failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.
- [NTSB ERA11CA500](https://openairdocs.org/ntsb/ERA11CA500.md): Spectrum RX 550 · Hartland, ME · Accident · Minor injuries · Data collection · Final report · Sep 1, 2011 · UNREG · Substantial damage
  > A total loss of engine power due to fuel contamination.
- [NTSB CEN11CA637](https://openairdocs.org/ntsb/CEN11CA637.md): Aero Commander S2R · Park Rapids, MN · Accident · No injuries · Data collection · Final report · Sep 1, 2011 · N8962Q · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB CEN11CA638](https://openairdocs.org/ntsb/CEN11CA638.md): Enstrom F-28F · Menominee, MI · Accident · No injuries · Data collection · Final report · Aug 29, 2011 · N228F · Substantial damage
  > The pilot's failure to maintain control of the helicopter during a hover.
- [NTSB WPR11WA421](https://openairdocs.org/ntsb/WPR11WA421.md): Hughes 369D · South Malekula, Vanuatu, Vanuatu · Accident · 1 fatal · Foreign investigation · Aug 28, 2011 · YJ-HEL · Substantial damage
  > On August 28, 2011, at 1500 universal coordinated time, a Hughes 369D, Vanuatu registration YJ-HEL, collided with the ground after the attached long-line became entangled in the rotor system near Malekula, Vanuatu. The helicopter was operated by Vanuatu…
- [NTSB WPR11CA411](https://openairdocs.org/ntsb/WPR11CA411.md): Schweizer SGS 2-32 · Warner Springs, CA · Accident · Serious injuries · Data collection · Final report · Aug 28, 2011 · N5840V · Substantial damage
  > The pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.
- [NTSB ERA11LA473](https://openairdocs.org/ntsb/ERA11LA473.md): Woolston Glenn E Zenith 701 Stol · Carlton, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2011 · N246CV · Substantial damage
  > The pilot’s lack of recognition that the engine was being supplied fuel from only the right tank with the fuel selector in the both position, which resulted in the total loss of engine power due to fuel starvation. Contributing to the accident was the…
- [NTSB CEN11LA593](https://openairdocs.org/ntsb/CEN11LA593.md): Air Tractor AT-400 · Monango, ND · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 2011 · N23720 · Substantial damage
  > The pilot did not maintain adequate separation from a tree during the aerial-application flight.
- [NTSB WPR11CA398](https://openairdocs.org/ntsb/WPR11CA398.md): Bell 47G-4 · Los Banos, CA · Accident · Minor injuries · Data collection · Final report · Aug 21, 2011 · N948DS · Substantial damage
  > The pilot's failure to maintain clearance from the power poles while maneuvering during low-altitude operations.
- [NTSB CEN11LA606](https://openairdocs.org/ntsb/CEN11LA606.md): Boeing A75N1(PT17) · Mt. Clemens, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 21, 2011 · N49739 · 2 aircraft · No damage
  > The wing walker’s decision to release his grip of the airplane during an attempted aerial transfer from airplane to helicopter before both aircraft achieved the proper relative positioning for the transfer.
- [NTSB CEN11LA588](https://openairdocs.org/ntsb/CEN11LA588.md): Hendryx Steve/Wiley Ross Super Rebel · La Porte City, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 2011 · N540AF · Substantial damage
  > The improper assembly of the aileron cable by the airplane builder.
- [NTSB ERA11WA470](https://openairdocs.org/ntsb/ERA11WA470.md): Piper PA30 · Region del Bio Bio, Chile · Accident · 2 fatal · Foreign investigation · Aug 20, 2011 · CC-CTT · Substantial damage
  > On August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…
- [NTSB ERA11FA468](https://openairdocs.org/ntsb/ERA11FA468.md): Mitchell David N Lancair IV P · Hammonton, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 20, 2011 · N71DM · 2 aircraft · Substantial damage
  > The Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.
- [NTSB ERA11FA467](https://openairdocs.org/ntsb/ERA11FA467.md): Cessna 172M · Titusville, PA · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2011 · N13126 · Substantial damage
  > The flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.
- [NTSB CEN11LA582](https://openairdocs.org/ntsb/CEN11LA582.md): Vertical Unlimited 12 · Kansas City, MO · Accident · 1 fatal · Limited investigation · Final report · Aug 20, 2011 · N2BJ · Substantial damage
  > The pilot's impairment during an aerobatic airshow performance for reasons that could not be determined based on available information, which resulted in an in-flight loss of airplane control.
- [NTSB CEN11LA581](https://openairdocs.org/ntsb/CEN11LA581.md): Piper PA-25-235 · Whitewood, SD · Accident · 1 fatal · Limited investigation · Final report · Aug 20, 2011 · N7051Z · Substantial damage
  > The pilot's collision with terrain for undetermined reasons.
- [NTSB WPR11LA391](https://openairdocs.org/ntsb/WPR11LA391.md): Luscombe 8A · Cowiche, WA · Accident · No injuries · Limited investigation · Final report · Aug 18, 2011 · N1444K · Substantial damage
  > A partial loss of engine power during maneuvering flight due to an exhaust valve failure.
- [NTSB WPR11FA390](https://openairdocs.org/ntsb/WPR11FA390.md): Piper PA-18-150 · Forsyth, MT · Accident · 2 fatal · Field investigation · Final report · Aug 18, 2011 · N7666D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.
- [NTSB WPR11LA388](https://openairdocs.org/ntsb/WPR11LA388.md): Air Tractor AT-602 · Pine Bluffs, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 2011 · N8518Y · Substantial damage
  > The pilot's failure to maintain clearance from power lines during an aerial application flight.
- [NTSB WPR11CA387](https://openairdocs.org/ntsb/WPR11CA387.md): P&M GT450 · Teton Village, WY · Accident · Serious injuries · Data collection · Final report · Aug 17, 2011 · N988AZ · Substantial damage
  > The pilot's failure to maintain an adequate airspeed, which resulted in a stall mush to ground impact.
- [NTSB ERA11FA463](https://openairdocs.org/ntsb/ERA11FA463.md): Quad City Ultralight Challenger II · Ransom Township, PA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2011 · N6613Z · Substantial damage
  > The non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…
- [NTSB ERA11LA457](https://openairdocs.org/ntsb/ERA11LA457.md): Piper PA-32R-301T · Graham, NC · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 2011 · N492ST · Substantial damage
  > The individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.
- [NTSB WPR11FA383](https://openairdocs.org/ntsb/WPR11FA383.md): Piper PA-38-112 · Silver Bow, MT · Accident · 2 fatal · Field investigation · Final report · Aug 15, 2011 · N2584N · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering.
- [NTSB ERA11CA450](https://openairdocs.org/ntsb/ERA11CA450.md): Cessna 172M · Elkins, WV · Accident · No injuries · Data collection · Final report · Aug 13, 2011 · N5399Q · Substantial damage
  > The flight instructor's unfamiliarity with the geographic area, resulting in controlled flight into terrain.
- [NTSB CEN11LA671](https://openairdocs.org/ntsb/CEN11LA671.md): Fisher Michael E Hyster · Lake Jackson, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 13, 2011 · N7167S · Substantial damage
  > The improper maintenance of the throttle control cable, which resulted in the engine going to idle power after takeoff.
- [NTSB CEN11LA573](https://openairdocs.org/ntsb/CEN11LA573.md): Stevens R P/Mccright D W Vans RV-6 · Conroe, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 13, 2011 · N16DD · 2 aircraft · Substantial damage
  > The failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.
- [NTSB CEN11LA571](https://openairdocs.org/ntsb/CEN11LA571.md): Air Tractor AT-402 · Uvalde, TX · Accident · No injuries · Limited investigation · Final report · Aug 13, 2011 · N10119 · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering to avoid power lines during a precautionary landing, which resulted an aerodynamic stall. Contributing to the accident was the fluctuating engine power for undetermined reasons and the pilot's…

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

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

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