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

## Cases, newest first

- [NTSB CEN17LA372](https://openairdocs.org/ntsb/CEN17LA372.md): Piper PA 25-235 · Westphalia, KS · Accident · No injuries · Limited investigation · Final report · Sep 28, 2017 · N7336Z · Substantial damage
  > A total loss of engine power due to a fatigue failure of the crankshaft that resulted from main bearing shift and lack of lubrication.
- [NTSB GAA17CA562](https://openairdocs.org/ntsb/GAA17CA562.md): Eurocopter AS 350 · Fullerton, CA · Accident · Minor injuries · Data collection · Final report · Sep 27, 2017 · N515ET · Substantial damage
  > The pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.
- [NTSB WPR17FA213](https://openairdocs.org/ntsb/WPR17FA213.md): Cessna 172L · Perkinsville, AZ · Accident · 2 fatal · Field investigation · Final report · Sep 22, 2017 · N7070Q · Destroyed
  > The pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.
- [NTSB GAA17CA555](https://openairdocs.org/ntsb/GAA17CA555.md): Godwin Jeff E Safari · Fayetteville, NC · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N186KW · Substantial damage
  > The student pilot’s failure to maintain lateral control during a hover pedal turn.
- [NTSB CEN17WA383](https://openairdocs.org/ntsb/CEN17WA383.md): Bell 47G · Llano Bonito de Pococí, Costa Rica · Accident · 1 fatal · Foreign investigation · Sep 18, 2017 · TI-BGH · Substantial damage
  > On September 18, 2017, at 0720 central daylight time, a Bell 47G2 helicopter, Costa Rican registration TI-BGH, serial number 1459, impacted terrain during an aerial application flight, near Llano Bonito de Pococí, Costa Rica. The pilot was fatally injured,…
- [NTSB WPR17LA209](https://openairdocs.org/ntsb/WPR17LA209.md): Trudel GP 4 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 17, 2017 · C-GTPX · 2 aircraft · Minor damage
  > The other pilot's failure to maintain clearance from the airplane during the line-abreast formation.
- [NTSB WPR17LA206](https://openairdocs.org/ntsb/WPR17LA206.md): Bell 47G 5 · Salinas, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2017 · N3285T · Substantial damage
  > The pilot’s inadequate visual lookout, which resulted in an in-flight collision with a wire.
- [NTSB ERA17LA328](https://openairdocs.org/ntsb/ERA17LA328.md): Piper J3C · Hanover Township, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 2017 · N38365 · Substantial damage
  > The pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.
- [NTSB CEN17FA354](https://openairdocs.org/ntsb/CEN17FA354.md): Cirrus Design SR22 · Glenwood Springs, CO · Accident · 4 fatal · Field investigation · Final report · Sep 16, 2017 · N462SR · Destroyed
  > The non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…
- [NTSB CEN17WA353](https://openairdocs.org/ntsb/CEN17WA353.md): Mooney M 20K · Braunwald, Switzerland · Accident · 2 fatal · Foreign investigation · Sep 12, 2017 · D-EPPW · Destroyed
- [NTSB CEN17LA375](https://openairdocs.org/ntsb/CEN17LA375.md): Hiller UH 12A · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Sep 11, 2017 · N2686 · Substantial damage
  > The loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.
- [NTSB CEN17FA342](https://openairdocs.org/ntsb/CEN17FA342.md): Rans S-6 · Stonewall, TX · Accident · 2 fatal · Field investigation · Final report · Sep 10, 2017 · N112CD · Substantial damage
  > The pilot's failure to maintain terrain clearance while conducting aerobatic flight maneuvers with insufficient altitude to recover.
- [NTSB ERA17WA318](https://openairdocs.org/ntsb/ERA17WA318.md): Cessna 172 · Hekpoort, South Africa · Accident · 2 fatal · Foreign investigation · Sep 3, 2017 · ZS-JDN · Destroyed
  > On September 3, 2017, about 0930 coordinated universal time, a Cessna 172M, South African registration ZS-JDN, was destroyed when it impacted a valley in the Magaliesberg Mountain range, near Hekpoort, South Africa. The two commercial pilots were fatally…
- [NTSB WPR17LA195](https://openairdocs.org/ntsb/WPR17LA195.md): Walker Edgar E Glastar · Cascade, ID · Accident · 1 fatal · Limited investigation · Final report · Sep 2, 2017 · N65EW · Destroyed
  > The pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…
- [NTSB CEN17WA378](https://openairdocs.org/ntsb/CEN17WA378.md): Piper PA25 · Sueco, Chihuahua, Mexico, Mexico · Accident · 1 fatal · Foreign investigation · Sep 2, 2017 · XB-EXZ · Substantial damage
  > On September 2, 2017, about 1700 hours universal coordinated time, a Piper PA25-235, Mexican registration XB-EXZ, was substantially damaged when it impacted powerlines near Sueco, Chihuahua, Mexico. The pilot was seriously injured. The local flight departed…
- [NTSB CEN17LA336](https://openairdocs.org/ntsb/CEN17LA336.md): Hughes 369A · Burnet, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2017 · N50MP · Substantial damage
  > The pilot's inadequate inflight decision making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ANC17LA051](https://openairdocs.org/ntsb/ANC17LA051.md): Leonardo AW139 · Tujunga, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 2, 2017 · N304FD · Substantial damage
  > A yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…
- [NTSB CEN17FA332](https://openairdocs.org/ntsb/CEN17FA332.md): Cessna 180J · Gaylord, MI · Accident · Serious injuries · Field investigation · Final report · Aug 28, 2017 · N180LP · Substantial damage
  > The pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.
- [NTSB WPR17LA188](https://openairdocs.org/ntsb/WPR17LA188.md): Robinson Helicopter R44 II · El Dorado Hills, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2017 · N61NM · Substantial damage
  > Maintenance personnel's inadequate routine maintenance on the helicopter engine, which led to low cylinder compression, improper magneto timing, and camshaft lobe wear, which subsequently resulted in degraded engine performance.
- [NTSB CEN17LA330](https://openairdocs.org/ntsb/CEN17LA330.md): Air Tractor AT 401 · Pearsall, TX · Accident · No injuries · Limited investigation · Final report · Aug 24, 2017 · N4532F · Substantial damage
  > The fatigue crack of an engine cylinder, which resulted in a partial loss of engine power.
- [NTSB WPR17LA186](https://openairdocs.org/ntsb/WPR17LA186.md): Hawker Siddeley Hunter MK.58 · Pacific Ocean (Pacific Ocean) · Accident · Minor injuries · Limited investigation · Final report · Aug 22, 2017 · N338AX · Destroyed
  > The pilot’s loss of airplane control after flying through another airplane's jet wash during an air defense exercise.
- [NTSB CEN17WA325](https://openairdocs.org/ntsb/CEN17WA325.md): Aviat Pitts S-2B · Holmestrand, Norway · Accident · 2 fatal · Foreign investigation · Aug 22, 2017 · LN-PTS · Destroyed
  > On August 22, 2017, at 1025 hours universal coordinated time, an Aviat Pitts S-2B, Norwegian registration LN-PTS, impacted the terrain following a loss of control while performing aerobatic maneuvers near Holmestrand, Norway. The pilot and passenger were…
- [NTSB ANC17FA047](https://openairdocs.org/ntsb/ANC17FA047.md): Rockwell International S 2R · Calipatria, CA · Accident · 1 fatal · Field investigation · Final report · Aug 22, 2017 · N5022X · Destroyed
  > A loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.
- [NTSB WPR17WA203](https://openairdocs.org/ntsb/WPR17WA203.md): Robinson Helicopter R44 II · Darwin Aerodrome, Australia · Accident · No injuries · Foreign investigation · Aug 18, 2017 · VH-LGN · Substantial damage
  > On August 18, 2017, at 1400 local time, a Robinson R44 II, VH-LGN, was substantially damaged during a forced landing near Darwin Aerodrome, Australia. The helicopter was operated under the pertinent civil regulations of the government of Australia. The pilot…
- [NTSB ERA17FA279](https://openairdocs.org/ntsb/ERA17FA279.md): Air Tractor AT502 · Philipp, MS · Accident · 1 fatal · Field investigation · Final report · Aug 16, 2017 · N6082B · Substantial damage
  > The pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, below a low overcast ceiling, which resulted in controlled flight into terrain.
- [NTSB CEN17WA320](https://openairdocs.org/ntsb/CEN17WA320.md): Piper PA36 · Vejer de la Frontera, Spain · Accident · 1 fatal · Foreign investigation · Aug 15, 2017 · EC-EHB · Substantial damage
  > On August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…
- [NTSB GAA17CA491](https://openairdocs.org/ntsb/GAA17CA491.md): Robinson Helicopter R44 · Westby, WI · Accident · No injuries · Data collection · Final report · Aug 14, 2017 · N97UP · Substantial damage
  > The pilot's failure to see and avoid power lines while maneuvering at low altitude.
- [NTSB ERA17LA276](https://openairdocs.org/ntsb/ERA17LA276.md): Bradley Roderick W Murphy Renegade · Guilford, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2017 · N210SQ · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA17FA274](https://openairdocs.org/ntsb/ERA17FA274.md): Bell 407 · Charlottesville, VA · Accident · 2 fatal · Field investigation · Final report · Aug 12, 2017 · N31VA · Destroyed
  > The pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…
- [NTSB CEN17LA316](https://openairdocs.org/ntsb/CEN17LA316.md): Navion Navion G · Adrian, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 11, 2017 · N249KC · Substantial damage
  > A leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.
- [NTSB ERA17WA273](https://openairdocs.org/ntsb/ERA17WA273.md): Bell 206 · Algiers, Algeria · Accident · 4 fatal · Foreign investigation · Aug 10, 2017 · 7T-WUF · Substantial damage
  > On August 10, 2017, about 0930 coordinated universal time, Bell 206L3 helicopter, Algerian registration 7T-WUF, was substantially damaged when it impacted terrain while maneuvering in Algiers, Algeria. The pilot and three passengers were fatally injured. The…
- [NTSB CEN17LA314](https://openairdocs.org/ntsb/CEN17LA314.md): Hughes 369D · Villa Grove, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2017 · N58424 · Substantial damage
  > The pilot’s failure to maintain main rotor clearance from a power line tower during low-level maneuvering.
- [NTSB ANC17WA045](https://openairdocs.org/ntsb/ANC17WA045.md): Air Tractor AT502 · La Crete, Canada · Accident · 1 fatal · Foreign investigation · Aug 10, 2017 · C-FWAS · Substantial damage
  > On August 10, 2017, about 0320 Coordinated Universal Time, an Air Tractor AT-502B airplane, C-FWAS, impacted terrain while conducting an aerial application repositioning turn near La Crete, Alberta, Canada. The pilot sustained fatal injuries. The…
- [NTSB CEN17LA311](https://openairdocs.org/ntsb/CEN17LA311.md): Cessna 172S · Wellston, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 2017 · N5274Q · Substantial damage
  > The failure of a connecting rod small end bushing, which resulted in a loss of engine power.
- [NTSB CEN17LA309](https://openairdocs.org/ntsb/CEN17LA309.md): Air Tractor AT-802A · Galesburg, IL · Accident · No injuries · Class 3 · Limited · Final report · Aug 9, 2017 · N528MB · Substantial damage
  > A total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…
- [NTSB ANC17LA040](https://openairdocs.org/ntsb/ANC17LA040.md): Robinson Helicopter R44 · Solomon, AK · Accident · No injuries · Class 3 · Limited · Final report · Aug 3, 2017 · N4138M · Substantial damage
  > The pilot's failure to maintain adequate altitude above water, and his loss of situational awareness, which resulted in an inadvertent descent and collision with water.
- [NTSB CEN17WA321](https://openairdocs.org/ntsb/CEN17WA321.md): Robinson R44 · Puerto Chiapas, Mexico · Accident · 1 fatal · Foreign investigation · Aug 2, 2017 · XB-MWZ · Substantial damage
  > On August 2, 2017, about 2115 universal coordinated time, a Robinson R44 helicopter, XB-MWZ, had a loss of engine power and subsequently impacted the Pacific Ocean near Puerto Chiapas, Mexico. Two persons were on board the helicopter. One person was reported…
- [NTSB WPR17LA174](https://openairdocs.org/ntsb/WPR17LA174.md): Rockwell International S 2R · Brawley, CA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2017 · N4913X · Substantial damage
  > The partial loss of engine power due to the overstress separation of three supercharger drive gear teeth.
- [NTSB WPR17FA170](https://openairdocs.org/ntsb/WPR17FA170.md): Beech 19A · Waipi'o, HI · Accident · 4 fatal · Field investigation · Final report · Jul 29, 2017 · N6142N · Substantial damage
  > The pilot's controlled flight into terrain for reasons that could not be determined based on the available evidence. Contributing to the accident was the pilot's decision to fly at low altitude in close proximity to the rising terrain.
- [NTSB GAA17CA453](https://openairdocs.org/ntsb/GAA17CA453.md): Piper PA36 · McCook, NE · Accident · No injuries · Data collection · Final report · Jul 29, 2017 · N132VA · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while maneuvering downwind during an agricultural application flight, which resulted in an aerodynamic stall at low altitude.
- [NTSB CEN17LA290](https://openairdocs.org/ntsb/CEN17LA290.md): Helicopteres Guimbal Cabri G2 · Beaumont, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2017 · N722TX · Substantial damage
  > The flight instructor's low-altitude maneuvering, which exceeded the helicopter's performance capability in the high-density altitude conditions and resulted in a loss of control.
- [NTSB CEN17CA294](https://openairdocs.org/ntsb/CEN17CA294.md): Air Tractor AT 502B · Harrold, SD · Accident · Minor injuries · Data collection · Final report · Jul 26, 2017 · N421CA · Substantial damage
  > The pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.
- [NTSB WPR17LA168](https://openairdocs.org/ntsb/WPR17LA168.md): Robinson Helicopter R44 II · Lake Sutherlin, MT · Accident · No injuries · Limited investigation · Final report · Jul 25, 2017 · N233JD · Substantial damage
  > The pilot’s transition into an out-of-ground-effect hover in high-density altitude conditions that exceeded the helicopter’s performance capabilities, which resulted in loss of rotor rpm.
- [NTSB GAA17CA454](https://openairdocs.org/ntsb/GAA17CA454.md): Air Tractor AT 802 · Trumann, AR · Accident · Serious injuries · Data collection · Final report · Jul 25, 2017 · N802DL · Substantial damage
  > The pilot’s improper decision to continue flight in deteriorating weather conditions, which resulted in collision with the ground.
- [NTSB GAA17CA436](https://openairdocs.org/ntsb/GAA17CA436.md): Bell 47G 3B · Toterville, IA · Accident · No injuries · Data collection · Final report · Jul 24, 2017 · N47AH · Substantial damage
  > The pilot’s failure to maintain rotor rpm while maneuvering at low altitude with low airspeed and a tailwind.
- [NTSB CEN17FA281](https://openairdocs.org/ntsb/CEN17FA281.md): Cessna 150F · Farmerville, LA · Accident · 1 fatal · Field investigation · Final report · Jul 23, 2017 · N8661S · Substantial damage
  > The pilot's failure to maintain clearance from the lake during a low-level maneuver.
- [NTSB WPR17FA161](https://openairdocs.org/ntsb/WPR17FA161.md): Applegate Panzl S331E · Apple Valley, CA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2017 · N331ST · Substantial damage
  > A fatigue failure of the left aileron control rod end during aerobatic flight, which resulted in the pilot's inability to maintain control of the airplane.
- [NTSB ERA17LA254](https://openairdocs.org/ntsb/ERA17LA254.md): Cessna 152 · Tamarac, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 2017 · N714UY · Substantial damage
  > The flight instructor's failure to ensure that the airplane's fuel system was free of water contamination before departing, which resulted in a total loss of engine power and subsequent forced landing.
- [NTSB CEN17CA346](https://openairdocs.org/ntsb/CEN17CA346.md): Robinson Helicopter R44 II · Logan, IA · Accident · Minor injuries · Data collection · Final report · Jul 20, 2017 · N192E · Substantial damage
  > The pilot’s failure to maintain clearance from a wire during an agricultural application flight.
- [NTSB ERA17LA249](https://openairdocs.org/ntsb/ERA17LA249.md): Grumman G 164 · Marydel, DE · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2017 · N691Y · Substantial damage
  > The pilot's failure to maintain adequate clearance from power lines while conducting an aerial application flight.

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

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

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