# NTSB investigations, CA: 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 1 of 45 · 2,215 cases

## Latest cases

- [NTSB WPR26FA346](https://openairdocs.org/ntsb/WPR26FA346.md): Airbus AS332 · Yosemite Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2026 · N332N · Destroyed
  > On September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…
- [NTSB WPR26FA345](https://openairdocs.org/ntsb/WPR26FA345.md): Eurocopter AS 350 B2 · Chatsworth, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 16, 2026 · N358TV · Destroyed
  > On September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…
- [NTSB WPR26LA291](https://openairdocs.org/ntsb/WPR26LA291.md): Cessna 177B · Perris, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2026 · N34852 · Substantial damage
  > On August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a…
- [NTSB WPR26LA220](https://openairdocs.org/ntsb/WPR26LA220.md): Cessna 172S · Morgan Hill, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2026 · N55231 · Substantial damage
  > An in-flight collision with a bird.
- [NTSB WPR26FA198](https://openairdocs.org/ntsb/WPR26FA198.md): Mooney M20J · Woodlake, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 23, 2026 · N4452H · Destroyed
  > On May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91…
- [NTSB WPR26FA121](https://openairdocs.org/ntsb/WPR26FA121.md): MD Helicopters 369FF · Mojave, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 9, 2026 · N530XX · Substantial damage
  > On March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA015](https://openairdocs.org/ntsb/WPR26LA015.md): Cessna 172S · Lathrop, CA · Accident · No injuries · Class 4 · Limited · Final report · Oct 4, 2025 · N103VK · Substantial damage
  > An inflight collision with a bird.
- [NTSB WPR25LA272](https://openairdocs.org/ntsb/WPR25LA272.md): American Champion 8KCAB · Jamesburg, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 31, 2025 · N15WJ · Substantial damage
  > On August 31, 2025, about 1100 Pacific daylight time, an American Champion 8KCAB Super Decathlon 177, N3357T, sustained substantial damage when it was involved in an accident near Jamesburg, California. The pilot and pilot rated passenger sustained minor…
- [NTSB WPR25LA112](https://openairdocs.org/ntsb/WPR25LA112.md): Enstrom 280FX · Waterford, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 15, 2025 · N402TA · Destroyed
  > The pilot’s failure to maintain clearance from water while operating at a low altitude.
- [NTSB WPR25LA078](https://openairdocs.org/ntsb/WPR25LA078.md): Bell 206A · Lemoore, CA · Accident · No injuries · Class 4 · Limited · Final report · Jan 14, 2025 · N6255N · Destroyed
  > The pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.
- [NTSB WPR25LA058](https://openairdocs.org/ntsb/WPR25LA058.md): Eurocopter AS 350 B2 · Los Alamitos, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 10, 2024 · N913WB · Substantial damage
  > The student pilot’s failure to maintain directional control during a run-on landing and the flight instructor’s excessive correction which resulted in impact with terrain. Contributing to the accident was the flight instructor’s delayed remedial action.
- [NTSB WPR25LA005](https://openairdocs.org/ntsb/WPR25LA005.md): Rotorsport Cavalon · Chico, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 7, 2024 · N726CA · Substantial damage
  > The pilot's failure to maintain adequate airspeed resulting in an inadvertent descent and subsequent collision with trees.
- [NTSB WPR24LA299](https://openairdocs.org/ntsb/WPR24LA299.md): Williams Helicopter UH-1H · Colusa, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 30, 2024 · N710WD · Substantial damage
  > The pilot’s failure to set collective friction which resulted in collective bounce and subsequent loss of control.
- [NTSB WPR24LA282](https://openairdocs.org/ntsb/WPR24LA282.md): Grumman Acft ENG Cor-Schweizer G-164B · Durham, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 13, 2024 · N6633K · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.
- [NTSB WPR24LA221](https://openairdocs.org/ntsb/WPR24LA221.md): Beech B19 · Running Springs, CA · Accident · No injuries · Class 4 · Limited · Final report · Jul 1, 2024 · N6553R · Substantial damage
  > The pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.
- [NTSB WPR24LA181](https://openairdocs.org/ntsb/WPR24LA181.md): Cessna 172P · Santa Ynez, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 5, 2024 · N9567L · Substantial damage
  > The pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…
- [NTSB WPR24LA134](https://openairdocs.org/ntsb/WPR24LA134.md): Bell 206L-3 · Tracy, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 23, 2024 · N17592 · Substantial damage
  > A loss of collective control authority due to fatigue failure of the collective servo cylinder extension arms from corrosion pitting.
- [NTSB WPR24FA123](https://openairdocs.org/ntsb/WPR24FA123.md): Ayres S2R-G10 · Derner, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 9, 2024 · N40261 · Substantial damage
  > The pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.
- [NTSB ANC24LA021](https://openairdocs.org/ntsb/ANC24LA021.md): Cessna 172 · Huasna, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 6, 2024 · N8907B · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during a low altitude maneuver, resulting in a loss of control.
- [NTSB WPR24LA117](https://openairdocs.org/ntsb/WPR24LA117.md): Piper PA-28-140 · Acton, CA · Accident · No injuries · Class 3 · Limited · Final report · Mar 23, 2024 · N1695H · Substantial damage
  > The pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.
- [NTSB WPR24LA094](https://openairdocs.org/ntsb/WPR24LA094.md): Aeronca 7AC · Valley Springs, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 23, 2024 · N1611E · Substantial damage
  > The pilot’s decision to maneuver the airplane at a low altitude and inadvertently entering a box canyon where the airplane could not outclimb the rising terrain.
- [NTSB WPR24LA093](https://openairdocs.org/ntsb/WPR24LA093.md): Bell 47G-3B-1 · Garey, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 23, 2024 · N2618W · Substantial damage
  > Maintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.
- [NTSB WPR24LA092](https://openairdocs.org/ntsb/WPR24LA092.md): Robinson Helicopter R44 II · Calexico, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 6, 2023 · N422DX · Substantial damage
  > The pilot's failure to maintain clearance from power lines during an aerial application flight.
- [NTSB WPR23LA338](https://openairdocs.org/ntsb/WPR23LA338.md): Bell 212 · Balch Camp, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 10, 2023 · N873HL · Destroyed
  > The pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…
- [NTSB WPR23LA336](https://openairdocs.org/ntsb/WPR23LA336.md): Piper PA-18-135 · Compton, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 3, 2023 · N7199K · Substantial damage
  > An overstress fracture of the pilot’s seat, which resulted in the loss of control during takeoff and the pilot’s inadvertent movement of the fuel selector and subsequent partial loss of engine power.
- [NTSB WPR23LA322](https://openairdocs.org/ntsb/WPR23LA322.md): Grumman American Avn. AA-5B · Lone Pine, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 19, 2023 · N4537Y · Substantial damage
  > The pilot's inability to maintain altitude after encountering a downdraft, which resulted in collision with terrain.
- [NTSB WPR23LA313](https://openairdocs.org/ntsb/WPR23LA313.md): Bell OH-58A · Guernsey, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 9, 2023 · N861CC · Substantial damage
  > The pilot’s overpitching of the main rotor blades while maneuvering at low altitude in a high-temperature environment at high gross weight, which resulted in a reduction of engine and rotor speed, excessive main rotor blade flapping, mast bumping, and impact…
- [NTSB WPR23LA305](https://openairdocs.org/ntsb/WPR23LA305.md): Grumman Acft ENG Cor-Schweizer G-164A · Davis, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 6, 2023 · N5450 · Substantial damage
  > An inflight loss of control during a low altitude operation for undetermined reasons.
- [NTSB DCA23LA397](https://openairdocs.org/ntsb/DCA23LA397.md): Supernal SUP83-1 · California City, CA · Accident · No injuries · Class 4 · Limited · Final report · Aug 3, 2023 · N183TD · Substantial damage
  > A loss of control in flight due to a loss of electrical power to one of the lift-motors.
- [NTSB DCA23LA340](https://openairdocs.org/ntsb/DCA23LA340.md): Supernal SUP83-1 · California City, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 29, 2023 · N283TD · Substantial damage
  > Erroneous signal processing that resulted in a total loss of propulsion power.
- [NTSB WPR23FA219](https://openairdocs.org/ntsb/WPR23FA219.md): Steen Skybolt · Rio Vista, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 8, 2023 · N202GM · Substantial damage
  > The pilots’ exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall and subsequent loss of control.
- [NTSB WPR23LA170](https://openairdocs.org/ntsb/WPR23LA170.md): Robinson Helicopter R44 II · Van Nuys, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 28, 2023 · N549TS · Substantial damage
  > The pilot’s failure to maintain lateral control of the helicopter, which resulted in a hard landing.
- [NTSB ANC23FA031](https://openairdocs.org/ntsb/ANC23FA031.md): Bell Helicopter Textron 407 · Nuevo, CA · Accident · 2 fatal · Class 3 · Field · Final report · Mar 24, 2023 · N14Z · Destroyed
  > The pilot’s decision to maneuver in a steep bank at a low altitude, which resulted in his failure to maintain clearance with terrain.
- [NTSB WPR23LA131](https://openairdocs.org/ntsb/WPR23LA131.md): Maule M-4-220C · Santa Ynez, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 18, 2023 · N40635 · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR23LA128](https://openairdocs.org/ntsb/WPR23LA128.md): Jones Jay D Cassutt M 11 · Castroville, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 12, 2023 · N55XJ · Substantial damage
  > A failure of the outboard trailing edge rib in the left wing, which resulted in a separation of the left aileron and a loss of control.
- [NTSB WPR23FA122](https://openairdocs.org/ntsb/WPR23FA122.md): Rockwell International S-2R · Willows, CA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 8, 2023 · N8424V · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines while flying under multiple conductors during a low-altitude aerial application flight, which resulted in propeller contact with a powerline and a subsequent loss of control.
- [NTSB WPR23LA120](https://openairdocs.org/ntsb/WPR23LA120.md): Grumman Acft ENG Cor-Schweizer G-164B · Vernalis, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 3, 2023 · N48492 · Substantial damage
  > The pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.
- [NTSB WPR23LA118](https://openairdocs.org/ntsb/WPR23LA118.md): Bell UH-1B · Orland, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 2, 2023 · N234SJ · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.
- [NTSB WPR23FA110](https://openairdocs.org/ntsb/WPR23FA110.md): Willman Loren LOREN'S Aircam · Grass Valley, CA · Accident · 2 fatal · Class 3 · Field · Final report · Feb 19, 2023 · N420PF · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.
- [NTSB WPR23LA112](https://openairdocs.org/ntsb/WPR23LA112.md): Star Lite SL1 · Corning, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Feb 16, 2023 · UNREG · Destroyed
  > The student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.
- [NTSB WPR23LA004](https://openairdocs.org/ntsb/WPR23LA004.md): Bell 206B · Fresno, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 1, 2022 · N284CA · Substantial damage
  > The disbond of a tail rotor drive shaft splined adapter, which resulted in a loss of tail rotor drive and a subsequent hard landing.
- [NTSB WPR22FA332](https://openairdocs.org/ntsb/WPR22FA332.md): Beech 58 · Galt, CA · Accident · 2 fatal · Class 3 · Field · Final report · Sep 4, 2022 · N142DR · Substantial damage
  > The certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.
- [NTSB WPR22LA268](https://openairdocs.org/ntsb/WPR22LA268.md): Piper J3C-65 · Huntington Beach, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 22, 2022 · N3666K · Substantial damage
  > A total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel at an altitude too low for recovery. Contributing was the pilot’s delayed decision to switch fuel tanks.
- [NTSB WPR22LA236](https://openairdocs.org/ntsb/WPR22LA236.md): Bell 206B · Merced, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 24, 2022 · N915B · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of power to the transmission and a subsequent hard landing.
- [NTSB WPR22FA195](https://openairdocs.org/ntsb/WPR22FA195.md): Meyer Fred J Hornet · Lucerne Valley, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 2, 2022 · N6366M · Substantial damage
  > The pilot’s failure to maintain altitude during an aerobatic maneuver, which resulted in an impact with terrain.
- [NTSB WPR21LA368](https://openairdocs.org/ntsb/WPR21LA368.md): Air Tractor AT-602 · Sacramento, CA · Accident · No injuries · Class 4 · Limited · Final report · May 21, 2022 · N8521V · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR22LA183](https://openairdocs.org/ntsb/WPR22LA183.md): Pyka Pelican · Winters, CA · Accident · Class 4 · Limited · Final report · May 14, 2022 · N605PK · Substantial damage
  > Delamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.
- [NTSB WPR22LA174](https://openairdocs.org/ntsb/WPR22LA174.md): Bell Helicopter Textron Canada 407 · Livermore, CA · Accident · Serious injuries · Class 3 · Limited · Final report · May 11, 2022 · N999GH · Substantial damage
  > Loss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.
- [NTSB WPR22LA140](https://openairdocs.org/ntsb/WPR22LA140.md): Bell OH-58A · Merced, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Apr 1, 2022 · N9287U · Substantial damage
  > The pilot’s failure to see and avoid wires while conducting an aerial application flight, which resulted in a wire strike and ground impact.
- [NTSB WPR22LA125](https://openairdocs.org/ntsb/WPR22LA125.md): Eurocopter AS332L1 · Azusa, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 20, 2022 · N950SG · Substantial damage
  > The pilot's failure to maintain clearance from a tree after encountering brownout conditions and a loss of visual reference during the approach to land.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=CA&page=2

## 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND 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?state=CA

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