# NTSB investigations, CA: Enroute

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 83 · 4,142 cases

## Latest cases

- [NTSB WPR26FA363](https://openairdocs.org/ntsb/WPR26FA363.md): Eurocopter Deutschland EC 135 P2+ · Avalon, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 1, 2026 · N313RX · Substantial damage
  > On September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…
- [NTSB WPR26LA323](https://openairdocs.org/ntsb/WPR26LA323.md): Beech E-55 · Mecca, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 30, 2026 · N333W · Substantial damage
- [NTSB WPR26LA300](https://openairdocs.org/ntsb/WPR26LA300.md): Zaklad Szybowcowy Jezow PW-6U · Floriston, CA · Accident · No injuries · Class 4 · Limited · Investigation open · Aug 7, 2026 · N17YC · Substantial damage
- [NTSB WPR26LA227](https://openairdocs.org/ntsb/WPR26LA227.md): Emigh Trojan A2 · Healdsburg, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 21, 2026 · N8329H · Substantial damage
  > On June 21, 2026, about 1210 Pacific daylight time, an Emigh Trojan A-2, N8329H, was substantially damaged when it was involved in an accident near Healdsburg, California. The flight instructor and student pilot were not injured. The airplane was operated as…
- [NTSB WPR26LA204](https://openairdocs.org/ntsb/WPR26LA204.md): Air Tractor AT-602 · Robbins, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N5111A · Substantial damage
  > On May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26FA130](https://openairdocs.org/ntsb/WPR26FA130.md): Beech A36 · Olympic Valley, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 23, 2026 · N2882W · Substantial damage
  > On March 22, 2026, at 1716 Pacific daylight time, a Beech A36, N2882W, was substantially damaged when it was involved in an accident near Olympic Valley, California. The pilot was fatally injured. The airplane was operated as a Title14 Code of Federal…
- [NTSB WPR26FA103](https://openairdocs.org/ntsb/WPR26FA103.md): Cessna 210B · Camarillo, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 16, 2026 · N9735X · Substantial damage
  > On February 15, 2026, about 1805 Pacific standard time, a Cessna 210B, N9735X, was substantially damaged when it was involved in an accident near Camarillo, California. The pilot was fatally injured and the passenger sustained serious injuries. The airplane…
- [NTSB WPR26LA073](https://openairdocs.org/ntsb/WPR26LA073.md): Evektor - Aerotechnik A S Sportstar MAX · Needles, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 27, 2025 · N2312T · Substantial damage
  > On December 27, 2025, about 1109 Pacific standard time, an Evektor-Aerotechnik AS Sportstar Max LSA airplane, N2312T, was substantially damaged when it was involved in an accident near Needles, California. The pilot and pilot rated passenger were not injured.…
- [NTSB WPR26LA071](https://openairdocs.org/ntsb/WPR26LA071.md): Cirrus Design SR22T · Lake Elsinore, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 23, 2025 · N272HM · Substantial damage
  > The pilot’s intentional deployment of the airframe parachute system due to task-saturation in instrument meteorological conditions.
- [NTSB WPR26LA065](https://openairdocs.org/ntsb/WPR26LA065.md): Cessna 150F · Temecula, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 20, 2025 · N8155S · Substantial damage
  > The pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR26LA060](https://openairdocs.org/ntsb/WPR26LA060.md): Beechcraft G36 · Tracy, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Dec 15, 2025 · N360FV · Substantial damage
  > On December 15, 2025, about 1526 Pacific standard time, a Beechcraft G36, N360FV, was substantially damaged when it was involved in an accident near Tracy, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA043](https://openairdocs.org/ntsb/WPR26FA043.md): Cessna 172M · Poleta, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 10, 2025 · N13221 · Substantial damage
  > On November 10, 2025, at about 1515 Pacific standard time, Cessna 172M, N13221, was substantially damaged when it was involved in an accident near Poleta, California. A pilot-rated passenger and a passenger were fatally injured, and the pilot was seriously…
- [NTSB WPR26LA034](https://openairdocs.org/ntsb/WPR26LA034.md): Piper PA-28R-200 · La Verne, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 29, 2025 · N5107S · Substantial damage
  > On October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title…
- [NTSB WPR26LA030](https://openairdocs.org/ntsb/WPR26LA030.md): Rutan Long-EZ · Long Beach, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 20, 2025 · N8183K · Substantial damage
  > On October 20, 2025, about 1603 Pacific daylight time, an experimental amateur-built Rutan Long-EZ, N8183K, was substantially damaged when it was involved in an accident in Long Beach, California. The pilot was seriously injured, and a pedestrian on the…
- [NTSB WPR26LA023](https://openairdocs.org/ntsb/WPR26LA023.md): Hawker Hawker Hunter MK.58 · Big Sur, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 15, 2025 · N335AX · Substantial damage
  > A complete loss of engine power for reasons that could not be determined.
- [NTSB WPR25FA277](https://openairdocs.org/ntsb/WPR25FA277.md): Lawson Thomas O Lancair Super ES · Mount Hamilton, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 12, 2025 · N905ET · Destroyed
  > On September 12, 2025, about 1421 Pacific daylight time, an experimental amateur-built Lancair Super ES, N905ET, was destroyed when it was involved in an accident near Mount Hamilton, California. The pilot was fatally injured. The airplane was operated as a…
- [NTSB WPR25LA261](https://openairdocs.org/ntsb/WPR25LA261.md): Piper PA-28-181 · San Diego, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 17, 2025 · N8150J · Substantial damage
  > On August 16, 2025, about 1737 Pacific daylight time, a Piper PA-28-181, N8150J, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR25LA212](https://openairdocs.org/ntsb/WPR25LA212.md): Cessna T240 · San Diego, CA · Accident · 1 fatal · Class 4 · Limited · Final report · Jul 13, 2025 · N636CS
  > Impact with the ocean for reasons that could not be determined because the pilot and airplane were not located.
- [NTSB WPR25LA188](https://openairdocs.org/ntsb/WPR25LA188.md): Filby Gerry RV-9 · Morgan Hill, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 23, 2025 · N696WG · Substantial damage
  > On June 23, 2025, about 1217 Pacific daylight time, an experimental amateur-built Vans Aircraft Inc RV-9 airplane, N696WG, was substantially damaged when it was involved in an accident near Morgan Hill, California. The pilot sustained minor injuries. The…
- [NTSB WPR25LA174](https://openairdocs.org/ntsb/WPR25LA174.md): Quitter John F MXL II · Acampo, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 14, 2025 · N375ME · Substantial damage
  > On June 14, 2025, about 1511 Pacific daylight time, an experimental MXL II, N375ME, was substantially damaged when it was involved in an accident near Acampo, California. The pilot was uninjured, and the passenger was seriously injured. The airplane was…
- [NTSB DCA25LA156](https://openairdocs.org/ntsb/DCA25LA156.md): Boeing 737-8 · San Diego, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 2, 2025 · N8776L · No damage
  > An encounter with an area of moderate clear air turbulence associated with the jet stream during cruise.
- [NTSB WPR25LA095](https://openairdocs.org/ntsb/WPR25LA095.md): Quicksilver Aeronautics L-S2S · Geyserville, CA · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2025 · N14QK · Substantial damage
  > The pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.
- [NTSB DCA25LA126](https://openairdocs.org/ntsb/DCA25LA126.md): Boeing 737-7H4 · Hacienda Heights, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 14, 2025 · N939WN · No damage
  > The airplane’s encounter with moderate turbulence during descent, which resulted in serious injury to a flight attendant.
- [NTSB WPR25LA089](https://openairdocs.org/ntsb/WPR25LA089.md): Lockheed C-130A · Daggett, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Feb 1, 2025 · N466TM · No damage
  > An inflight upset due to an improperly secured load that resulted in serious injuries.
- [NTSB WPR25LA069](https://openairdocs.org/ntsb/WPR25LA069.md): Sling Sling LSA · Carson, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 22, 2024 · N519CV · Substantial damage
  > The pilot’s decision to conduct a prolonged slip against warnings specified in the Pilot’s Operating Handbook which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR25FA062](https://openairdocs.org/ntsb/WPR25FA062.md): American Eurocopter AS350B3 · Potrero, CA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 16, 2024 · N617GC · Substantial damage
  > The pilot’s loss of control during cruise flight due to incapacitation for reasons that could not be determined.
- [NTSB WPR25LA055](https://openairdocs.org/ntsb/WPR25LA055.md): Vans RV14 · Palmdale, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 5, 2024 · N144SD · Substantial damage
  > On December 15, 2024, about 1303 pacific standard time, an experimental amateur built Vans RV-14, N144SD, was substantially damaged when it was involved in an accident near Palmdale, California. The pilot was not injured. The airplane was operated as a Title…
- [NTSB ENG25WA011](https://openairdocs.org/ntsb/ENG25WA011.md): Airbus A330 · Los Angeles, CA · Incident · Class 5 · Foreign · Dec 4, 2024 · VH-EBQ · No damage
- [NTSB WPR25LA037](https://openairdocs.org/ntsb/WPR25LA037.md): Cessna 172I · Los Angeles, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 14, 2024 · N46028 · Substantial damage
  > A partial loss of engine power due to carburetor ice accumulation.
- [NTSB WPR25LA004](https://openairdocs.org/ntsb/WPR25LA004.md): Cessna 172L · El Monte, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 7, 2024 · N7869G · Substantial damage
  > A total loss of engine power due to contaminated fuel.
- [NTSB WPR25LA003](https://openairdocs.org/ntsb/WPR25LA003.md): Raytheon C90A · Bakersfield, CA · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 4, 2024 · N6077X · No damage
  > The pilot’s incapacitation by an in-flight cardiac event that led to cardiac arrest.
- [NTSB WPR25LA001](https://openairdocs.org/ntsb/WPR25LA001.md): Cirrus Design SR22 · Bakersfield, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 2, 2024 · N752B · Substantial damage
  > On October 2, 2024, about 1347 Pacific daylight time, a Cirrus SR22, N752B, was substantially damaged when it was involved in an accident near Bakersfield, California. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR24FA309](https://openairdocs.org/ntsb/WPR24FA309.md): Nanchang China CJ-6A · Lancaster, CA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 22, 2024 · N313YK · 2 aircraft · Substantial damage
  > The CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.
- [NTSB WPR24LA314](https://openairdocs.org/ntsb/WPR24LA314.md): Cessna U206G · West Sacramento, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 19, 2024 · N6522Z · Substantial damage
  > Failure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.
- [NTSB DCA24LA316](https://openairdocs.org/ntsb/DCA24LA316.md): Boeing 757-224 · Dunnigan, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 19, 2024 · N12125 · No damage
  > The abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.
- [NTSB DCA24WA308](https://openairdocs.org/ntsb/DCA24WA308.md): Boeing 737-8 · San Francisco, CA · Incident · Class 5 · Foreign · Sep 16, 2024 · N105JS · No damage
- [NTSB WPR24LA269](https://openairdocs.org/ntsb/WPR24LA269.md): Protech PT2 · Lodi, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N657MJ · Substantial damage
  > A reported loss of engine power for reasons that could not be determined.
- [NTSB WPR24LA261](https://openairdocs.org/ntsb/WPR24LA261.md): Aeronca 11AC · Winchester, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 27, 2024 · N86270 · Substantial damage
  > A total loss of engine power due to a fatigue fracture of the crankshaft.
- [NTSB WPR24LA210](https://openairdocs.org/ntsb/WPR24LA210.md): Lancair LC42-550FG · Humboldt Bay, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2024 · N141PB · Substantial damage
  > Maintenance personnel’s incorrect installation of an engine rocker cover gasket, which resulted in oil exhaustion and subsequent loss of engine power during the initial climb.
- [NTSB WPR24LA207](https://openairdocs.org/ntsb/WPR24LA207.md): Piper J3C-65 · Scheelite, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 19, 2024 · N3627N · Substantial damage
  > The pilot’s inadvertent entry to a box canyon where the airplane could not outclimb the rising terrain.
- [NTSB WPR24LA212](https://openairdocs.org/ntsb/WPR24LA212.md): Piper PA31 · Lemoore, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 18, 2024 · C-GJBG · Substantial damage
  > The pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing.
- [NTSB WPR24FA195](https://openairdocs.org/ntsb/WPR24FA195.md): Luscombe 8A · South Lake Tahoe, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 12, 2024 · N37081 · Substantial damage
  > The pilot’s decision to continue low-altitude flight toward rising mountainous terrain in high density altitude conditions, which resulted in collision with trees and terrain.
- [NTSB WPR24LA167](https://openairdocs.org/ntsb/WPR24LA167.md): Canadian Car & Foundry Harvard MK IV · Modesto, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 2, 2024 · N7522U · Substantial damage
  > The pilot’s improper fuel tank selection, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was a malfunctioning fuel selector at low fuel levels.
- [NTSB DCA24LA206](https://openairdocs.org/ntsb/DCA24LA206.md): Boeing 737-8 · Oakland, CA · Accident · No injuries · Class 3 · Limited · Final report · May 25, 2024 · N8825Q · Substantial damage
  > Damage to the standby rudder power control unit connection to the vertical fin due to an extreme high wind event while the airplane was parked, which remained undetected and resulted in anomalous operation of the standby rudder power control unit.…
- [NTSB WPR24LA157](https://openairdocs.org/ntsb/WPR24LA157.md): Cessna P210 · Daggett, CA · Accident · No injuries · Class 3 · Limited · Final report · May 16, 2024 · N4769K · Substantial damage
  > The pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…
- [NTSB WPR24LA142](https://openairdocs.org/ntsb/WPR24LA142.md): Ultramagic Z-90 · Del Mar, CA · Accident · 1 fatal · Class 3 · Limited · Final report · May 4, 2024 · N290UM · No damage
  > The passenger’s intentional departure from the balloon in flight as an act of suicide.
- [NTSB WPR24LA135](https://openairdocs.org/ntsb/WPR24LA135.md): Bellanca 17-31ATC · El Cajon, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 29, 2024 · N8800V · Substantial damage
  > Maintenance personnel’s improper installation of an engine-driven vacuum pump, which resulted in oil starvation to the engine and a subsequent total loss of engine power. Contributing to the accident was the A&P IA’s lack of supervision.
- [NTSB WPR24FA124](https://openairdocs.org/ntsb/WPR24FA124.md): Gulfstream 695A · San Bernardino, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 14, 2024 · N965BC · Destroyed
  > The pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB WPR24LA121](https://openairdocs.org/ntsb/WPR24LA121.md): Kitfox Series 5 · Yucca Grove, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 5, 2024 · N743JT · Substantial damage
  > The pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.
- [NTSB WPR24LA114](https://openairdocs.org/ntsb/WPR24LA114.md): Mooney M20K · Farmington, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 16, 2024 · N38RK · Substantial damage
  > The pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.

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

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