# NTSB investigations, CA: Initial climb

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 42 · 2,097 cases

## Latest cases

- [NTSB WPR27LA019](https://openairdocs.org/ntsb/WPR27LA019.md): Cessna 177A · San Jose, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 17, 2026 · N30544 · Substantial damage
  > On October 17, 2026, at 1508 Pacific daylight time, a Cessna 177A, N30544, was substantially damaged when it was involved in an accident near San Jose, California. The pilot and one passenger sustained minor injuries. One passenger was seriously injured. The…
- [NTSB WPR27FA012](https://openairdocs.org/ntsb/WPR27FA012.md): Vans RV7A · Petaluma, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 7, 2026 · N425DG · Destroyed
  > On October 7, 2026, about 1038 Pacific daylight time, an experimental amateur built Vans RV-7A, N425DG, was destroyed when it was involved in an accident near Petaluma, California. The pilot and flight instructor were fatally injured. The airplane was…
- [NTSB ENG27LA001](https://openairdocs.org/ntsb/ENG27LA001.md): Boeing 777-222 · San Francisco, CA · Incident · No injuries · Class 4 · Limited · Investigation open · Oct 6, 2026 · N796UA
- [NTSB WPR26FA329](https://openairdocs.org/ntsb/WPR26FA329.md): Grumman American Avn. AA-5 · Fresno, CA · Accident · 4 fatal · Class 3 · Field · Preliminary report · Sep 5, 2026 · N6510L · Destroyed
  > On September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA324](https://openairdocs.org/ntsb/WPR26LA324.md): Zenith CH701 · Byron, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 30, 2026 · N701WJ · Substantial damage
  > On August 30, 2026, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH701, N701WJ, was substantially damaged when it was involved in an accident at Byron Airport (C83), Byron, California. The pilot was not injured. The airplane was…
- [NTSB WPR26LA263](https://openairdocs.org/ntsb/WPR26LA263.md): Schleicher ASW-27 · Montague, CA · Accident · No injuries · Class 4 · Limited · Final report · Jul 15, 2026 · N920KB · Substantial damage
  > The pilot’s inability to see and avoid a piece of loose wire in a field during an off-airport landing in a glider, which resulted in a ground loop. Contributing to the accident was the pilot’s inability to maintain a safe position behind the tow airplane…
- [NTSB WPR26LA251](https://openairdocs.org/ntsb/WPR26LA251.md): Luscombe 8A · Novato, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 7, 2026 · N45886 · Substantial damage
  > On July 7, 2026, about 1200 Pacific daylight time, a Luscombe 8A, N45886, was substantially damaged when it was involved in an accident near Novato, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26LA170](https://openairdocs.org/ntsb/WPR26LA170.md): Balony Kubicek Spol Sro BB100Z · Elk Grove, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 27, 2026 · N355WC · Substantial damage
  > The pilot’s delayed decision to deflate the balloon during a static display in windy conditions, which resulted in a loss of control and impact with a building. Contributing to the accident was the proximity of the balloon from structures during a static…
- [NTSB WPR26LA173](https://openairdocs.org/ntsb/WPR26LA173.md): Pipistrel Alpha Trainer · Salinas, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 18, 2026 · N143AW · Substantial damage
  > The flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR26LA158](https://openairdocs.org/ntsb/WPR26LA158.md): Alexander Schleicher ASH 31 MI · Williams, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 13, 2026 · N77UK · Substantial damage
  > On April 13, 2026, about 1051 Pacific standard time, an experimental Alexander Schleicher GMBH and Co., Ash 31 Mi Glider, N77UK, was substantially damaged when it was involved in an accident near Williams, California. The pilot sustained minor injuries. The…
- [NTSB WPR26LA037](https://openairdocs.org/ntsb/WPR26LA037.md): Grumman American Avn. AA-5B · Santa Ynez, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 30, 2025 · N74323 · Substantial damage
  > On October 29, 2025, about 1820 Pacific daylight time, a Grumman American AA-5B, N74323, was substantially damaged when it was involved in an accident near Santa Ynez, California. The commercial pilot was not injured. The airplane was operated as a Title 14…
- [NTSB WPR26FA008](https://openairdocs.org/ntsb/WPR26FA008.md): Airbus Helicopters EC 130 T2 · Sacramento, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 7, 2025 · N414RX · Substantial damage
  > On October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse…
- [NTSB WPR25FA257](https://openairdocs.org/ntsb/WPR25FA257.md): Cessna 140 · Shelter Cove, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 17, 2025 · N89447
  > On August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…
- [NTSB WPR25FA169](https://openairdocs.org/ntsb/WPR25FA169.md): Cessna 414 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · Jun 8, 2025 · N414BA · Substantial damage
  > On June 08, 2025, at 1230 Pacific daylight time, a Cessna 414A, N414BA, was substantially damaged when it was involved in an accident in San Diego, California. The pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25LA171](https://openairdocs.org/ntsb/WPR25LA171.md): Yakovlev YAK-50 · Hayward, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 7, 2025 · N150YK · Substantial damage
  > On June 7, 2025, about 1252 Pacific daylight time, a Yakovlev YAK-50, N150YK, was substantially damaged when it was involved in an accident near Hayward, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25LA159](https://openairdocs.org/ntsb/WPR25LA159.md): North American T-28B · Olivehurst, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 17, 2025 · N28DE · Substantial damage
  > On May 17, 2025, at 1022 Pacific daylight time, a North American T-28B, N28DE, was substantially damaged when it was involved in an accident near Marysville, California. The pilot and passenger were seriously injured. The airplane was operated as a Title 14…
- [NTSB DCA25LA174](https://openairdocs.org/ntsb/DCA25LA174.md): Pyka Pelican · Dixon, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 28, 2025 · N939NP · Substantial damage
  > The flight control system’s unanticipated transition to takeoff abort mode due to a software error in the autonomous flight control system, which resulted in a premature throttle reduction and hard landing.
- [NTSB WPR25LA073](https://openairdocs.org/ntsb/WPR25LA073.md): Cessna 150D · Temple City, CA · Accident · Class 4 · Limited · Final report · Jan 6, 2025 · N5943T · Substantial damage
  > The flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.
- [NTSB WPR25LA048](https://openairdocs.org/ntsb/WPR25LA048.md): Mooney M20F · Fullerton, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 25, 2024 · N9245V · Substantial damage
  > The loss of engine power during departure for reasons that could not be determined.
- [NTSB WPR25FA007](https://openairdocs.org/ntsb/WPR25FA007.md): Beech 95-B55 · Avalon, CA · Accident · 5 fatal · Class 3 · Field · Preliminary report · Oct 9, 2024 · N73WA · Substantial damage
  > On October 8, 2024, at 2005 Pacific daylight time, a Beech 95-B55, N73WA, was destroyed when it was involved in an accident near Avalon, California. The pilot, two pilot rated passengers, and two student pilot passengers were fatally injured. The airplane was…
- [NTSB WPR24LA267](https://openairdocs.org/ntsb/WPR24LA267.md): Piper PA-28R-201T · Sacramento, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 4, 2024 · N135DG · Substantial damage
  > A loss of engine power during the initial climb due to the detachment of the turbocharger’s inlet sleeve as a result of the installation of an incorrect sleeve clamp.
- [NTSB WPR24FA196](https://openairdocs.org/ntsb/WPR24FA196.md): Lockheed 12A · Chino, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 15, 2024 · N93R · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…
- [NTSB WPR24LA154](https://openairdocs.org/ntsb/WPR24LA154.md): Cessna 172G · Lakeport, CA · Accident · No injuries · Class 3 · Limited · Final report · May 16, 2024 · N4448L · Substantial damage
  > The pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.
- [NTSB WPR24LA106](https://openairdocs.org/ntsb/WPR24LA106.md): Cirrus Design SR22 · Whitethorn, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 8, 2024 · N2824M · Substantial damage
  > A total loss of engine power due to water-contaminated fuel.
- [NTSB WPR24FA073](https://openairdocs.org/ntsb/WPR24FA073.md): Ostroth Thane L Cozy MK IV · Half Moon Bay, CA · Accident · 4 fatal · Class 3 · Field · Final report · Jan 15, 2024 · N656TE · Destroyed
  > The airplane’s impact with the ocean for undetermined reasons after departing into night, instrument meteorological conditions.
- [NTSB WPR24LA070](https://openairdocs.org/ntsb/WPR24LA070.md): Air Tractor AT-502A · Stratford, CA · Accident · No injuries · Class 3 · Limited · Final report · Jan 10, 2024 · N6126U · Substantial damage
  > A partial loss of engine power due to the malfunction of the engine compressor bleed-off valve.
- [NTSB WPR24LA046](https://openairdocs.org/ntsb/WPR24LA046.md): Cessna P210N · Big Bear, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 2, 2023 · N7LV · Substantial damage
  > A loss of engine power during the initial climb for undetermined reasons, which resulted in an aborted takeoff and runway excursion.
- [NTSB WPR24LA049](https://openairdocs.org/ntsb/WPR24LA049.md): Cessna 172N · Watsonville, CA · Accident · No injuries · Class 4 · Limited · Final report · Nov 29, 2023 · N6212F · Substantial damage
  > An in-flight collision with a bird while in the initial climb.
- [NTSB WPR24LA041](https://openairdocs.org/ntsb/WPR24LA041.md): Bell OH-58A · Brawley, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 21, 2023 · N158TR · Substantial damage
  > A total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.
- [NTSB WPR24LA023](https://openairdocs.org/ntsb/WPR24LA023.md): Vans RV-12 · Novato, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 26, 2023 · N28BS · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons.
- [NTSB WPR24FA018](https://openairdocs.org/ntsb/WPR24FA018.md): Beech A36 · Covelo, CA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 21, 2023 · N8248K · Destroyed
  > The pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.
- [NTSB WPR23FA287](https://openairdocs.org/ntsb/WPR23FA287.md): Beech P35 · Upland, CA · Accident · 3 fatal · Class 3 · Field · Final report · Jul 30, 2023 · N8572M · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack, for reasons that could not be determined, which resulted in a subsequent aerodynamic stall and impact with a building.
- [NTSB WPR23LA239](https://openairdocs.org/ntsb/WPR23LA239.md): Piper PA-24-250 · Alturas, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 25, 2023 · N6430P · Substantial damage
  > A loss of engine power due to the failure of the right magneto distributor gear and the pilot’s decision to conduct a test flight with known mechanical issues.
- [NTSB WPR23LA156](https://openairdocs.org/ntsb/WPR23LA156.md): Piper PA-28-180 · Riverside, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 16, 2023 · N8376W · Substantial damage
  > The pilot’s failure to use carburetor heat during an extended ground delay before takeoff, which resulted in a total loss of engine power during initial climb due to carburetor ice.
- [NTSB WPR23LA121](https://openairdocs.org/ntsb/WPR23LA121.md): Piper PA-28-180 · San Andreas, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 3, 2023 · N9375J · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB WPR23LA082](https://openairdocs.org/ntsb/WPR23LA082.md): Cessna 172 · Watsonville, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 1, 2023 · N7181A · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines during a go around.
- [NTSB WPR23LA077](https://openairdocs.org/ntsb/WPR23LA077.md): Beech V35B · Livermore, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 25, 2022 · N65Y · Substantial damage
  > The pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.
- [NTSB WPR22LA316](https://openairdocs.org/ntsb/WPR22LA316.md): Cessna 150H · Vacaville, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 24, 2022 · N22507 · Substantial damage
  > The partial loss of engine power due to a stuck exhaust valve.
- [NTSB WPR22LA310](https://openairdocs.org/ntsb/WPR22LA310.md): Stucker Gary Banty · Camarillo, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 18, 2022 · N995GS · Substantial damage
  > The pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB WPR22LA242](https://openairdocs.org/ntsb/WPR22LA242.md): Cessna 120 · San Carlos, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 28, 2022 · N2056V · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB WPR22LA219](https://openairdocs.org/ntsb/WPR22LA219.md): Cessna TR182 · Davis, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 16, 2022 · N756EG · Destroyed
  > An in-flight fire during the initial takeoff climb for reasons that could not be determined based on the available evidence.
- [NTSB WPR22LA133](https://openairdocs.org/ntsb/WPR22LA133.md): Adams Dennis Allen Varieze · Mojave, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 26, 2022 · N88KL · Substantial damage
  > The failure of the carburetor intake Sceet tubing, which resulted in a total loss of engine power.
- [NTSB WPR22LA076](https://openairdocs.org/ntsb/WPR22LA076.md): Cessna 172H · Los Angeles, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 9, 2022 · N8056L · Substantial damage
  > The pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…
- [NTSB WPR22FA054](https://openairdocs.org/ntsb/WPR22FA054.md): Beech V35 · Visalia, CA · Accident · 4 fatal · Class 3 · Field · Final report · Dec 5, 2021 · N7933M · Substantial damage
  > The pilot’s loss of control due to spatial disorientation shortly after takeoff. Contributing to the accident was the pilot’s decision to depart into night instrument meteorological conditions.
- [NTSB WPR22FA026](https://openairdocs.org/ntsb/WPR22FA026.md): Ayres S-2R · Shafter, CA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 3, 2021 · N8960Q · Substantial damage
  > The pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.
- [NTSB WPR21LA326](https://openairdocs.org/ntsb/WPR21LA326.md): Piper PA-32-300 · Del Mar, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 24, 2021 · N2843T · Substantial damage
  > The partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.
- [NTSB WPR21FA270](https://openairdocs.org/ntsb/WPR21FA270.md): Cessna 421C · Monterey, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jul 13, 2021 · N678SW · Destroyed
  > The pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…
- [NTSB WPR21LA248](https://openairdocs.org/ntsb/WPR21LA248.md): Dewsnup Dave Zenair CH 701 SP · Chester, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 26, 2021 · N41XY · Substantial damage
  > The pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.
- [NTSB WPR21FA228](https://openairdocs.org/ntsb/WPR21FA228.md): Cirrus Design SR20 · Truckee, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 15, 2021 · N89423 · Substantial damage
  > The student pilot’s exceedance of the airplane’s critical angle of attack during a turn and the flight instructor’s delayed remedial action, resulting in an aerodynamic stall and a subsequent impact with terrain.
- [NTSB WPR21LA208](https://openairdocs.org/ntsb/WPR21LA208.md): Boeing A75N1(PT17) · Hollister, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 26, 2021 · N75016 · Substantial damage
  > The improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.