# NTSB investigations, CA: Approach

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 47 · 2,301 cases

## Latest cases

- [NTSB WPR26FA330](https://openairdocs.org/ntsb/WPR26FA330.md): Cessna 172N · San Diego, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 8, 2026 · N734ZK · Destroyed
  > On September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…
- [NTSB WPR26LA322](https://openairdocs.org/ntsb/WPR26LA322.md): Krugh Patrick M Steen Skybolt · Big Bear, CA · Accident · Serious injuries · Class 4 · Limited · Investigation open · Aug 28, 2026 · N43PK · Substantial damage
- [NTSB DCA26WA347](https://openairdocs.org/ntsb/DCA26WA347.md): Boeing 737-8 · Fresno, CA · Incident · Class 5 · Foreign · Aug 9, 2026 · N173AM · No damage
- [NTSB WPR26LA268](https://openairdocs.org/ntsb/WPR26LA268.md): Piper PA-18 · Colusa, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 18, 2026 · N7590K · Substantial damage
  > The pilot's inadequate fuel planning and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR26LA240](https://openairdocs.org/ntsb/WPR26LA240.md): Bellanca 17-30A · Santa Paula, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 27, 2026 · N501CR · Substantial damage
  > The pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power.
- [NTSB WPR26LA164](https://openairdocs.org/ntsb/WPR26LA164.md): Cessna 172S · Pacoima, CA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 20, 2026 · N2126F · Substantial damage
  > On April 20, 2026, about 1107 Pacific daylight time, a Cessna 172S airplane, N2126F, sustained substantial damage when it was involved in an accident near Whiteman Airport (WHP), Pacoima, California. The pilot was seriously injured. The airplane was operated…
- [NTSB WPR25LA292](https://openairdocs.org/ntsb/WPR25LA292.md): Cessna 182N · Fallbrook, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 23, 2025 · N766EE · Substantial damage
  > On September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25LA275](https://openairdocs.org/ntsb/WPR25LA275.md): Piper PA-28-180 · Hollister, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 11, 2025 · N7756N · Substantial damage
  > The pilot’s delayed go-around from an unstabilized approach that resulted in an impact with terrain.
- [NTSB WPR25FA224](https://openairdocs.org/ntsb/WPR25FA224.md): Beech 95-B55 (T42A) · Pacific Grove, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 27, 2025 · N8796R · Substantial damage
  > On July 26, 2025, about 2237 Pacific daylight time, a Beech 95-B55, N8976R, was substantially damaged when it was involved in an accident near Pacific Grove, California. The pilot and two passengers were fatally injured. The airplane was operated as a Title…
- [NTSB OPS25LA048](https://openairdocs.org/ntsb/OPS25LA048.md): Embraer ERJ 170-200 LR · Monterey, CA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 15, 2025 · N185SY · No damage
  > On July 15, 2025, about 0005 Pacific Daylight Time (PDT), SkyWest Airlines (SKW) flight 3005, an Embraer 170-200LR, N185SY, conducted a pilot-initiated go-around approximately 4 miles from the threshold of runway 10R at Monterey Regional Airport (MRY),…
- [NTSB WPR25LA175](https://openairdocs.org/ntsb/WPR25LA175.md): Cessna 182P · Hyampom, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 13, 2025 · N78720 · Substantial damage
  > The pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.
- [NTSB WPR25FA161](https://openairdocs.org/ntsb/WPR25FA161.md): Cessna S550 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · May 22, 2025 · N666DS · Destroyed
  > On May 22, 2025, at 0347 Pacific daylight time (PDT), a Cessna Citation S550, N666DS, was destroyed when it was involved in an accident near San Diego, California. The pilot and five passengers were fatally injured. Eight people on the ground received minor…
- [NTSB WPR25FA146](https://openairdocs.org/ntsb/WPR25FA146.md): Cessna 177RG · Grass Valley, CA · Accident · 1 fatal · Class 3 · Field · Final report · May 1, 2025 · N52156 · Substantial damage
  > An improperly tightened B-nut fitting at the fuel flow divider, which resulted in a fuel leak and loss of engine power due to fuel starvation, and the inadequate maintenance inspection, which failed to detect and correct the discrepancy.
- [NTSB WPR25LA115](https://openairdocs.org/ntsb/WPR25LA115.md): Rotorsport UK Cavalon · Murrieta, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 20, 2025 · N157P · Substantial damage
  > The student pilot’s failure to maintain adequate airspeed during an approach and subsequent descent into terrain. Contributing to the accident was the student pilot’s failure to perform a go-around maneuver.
- [NTSB WPR25LA113](https://openairdocs.org/ntsb/WPR25LA113.md): Beech E-55 · Van Nuys, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 16, 2025 · N994WY · Substantial damage
  > An in-flight collision with a bird during an approach to land.
- [NTSB WPR25LA092](https://openairdocs.org/ntsb/WPR25LA092.md): Piper PA-28-235 · Shafter, CA · Accident · No injuries · Class 3 · Limited · Final report · Feb 9, 2025 · N8535N · Substantial damage
  > A total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.
- [NTSB WPR25LA086](https://openairdocs.org/ntsb/WPR25LA086.md): Cessna 172P · Ramona, CA · Accident · No injuries · Class 4 · Limited · Final report · Feb 2, 2025 · N5268K · Substantial damage
  > An in-flight collision with a bird in the airport traffic pattern.
- [NTSB WPR25LA085](https://openairdocs.org/ntsb/WPR25LA085.md): Cirrus Design SR22T · Santa Barbara, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 29, 2025 · N124LZ · Destroyed
  > An undetermined flap system anomaly that resulted in an irreversible right bank and rendered the airplane uncontrollable.
- [NTSB WPR25LA082](https://openairdocs.org/ntsb/WPR25LA082.md): Cessna 172K · Columbia, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 23, 2025 · N79910 · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB DCA25LA102](https://openairdocs.org/ntsb/DCA25LA102.md): Boeing 787 · Ojai, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Jan 8, 2025 · JA892A · No damage
  > An encounter with turbulence during descent, which resulted in a serious injury to a flight attendant.
- [NTSB WPR25FA072](https://openairdocs.org/ntsb/WPR25FA072.md): Vans RV-10 · Fullerton, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jan 2, 2025 · N8757R · Substantial damage
  > On January 2, 2025, about 1409 Pacific standard time, an experimental amateur built Vans Aircraft RV-10, N8757R, was destroyed when it was involved in an accident near Fullerton, California. The pilot and passenger were fatally injured, and there were 19…
- [NTSB WPR25LA068](https://openairdocs.org/ntsb/WPR25LA068.md): Remos Remos G-3/600 · Brawley, CA · Accident · No injuries · Class 4 · Limited · Final report · Dec 22, 2024 · N191DY · Substantial damage
  > The flight instructor’s lack of remedial action to the student pilot’s inadequate landing flare, which resulted in a hard landing and a loss of directional control.
- [NTSB WPR25LA039](https://openairdocs.org/ntsb/WPR25LA039.md): Piper PA32-300 · Pomona, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 17, 2024 · N617ET · Substantial damage
  > A total loss of engine power during final approach for reasons that could not be determined.
- [NTSB WPR25LA011](https://openairdocs.org/ntsb/WPR25LA011.md): Air Tractor AT502 · Corcoran, CA · Accident · No injuries · Class 4 · Limited · Final report · Oct 8, 2024 · N243LA · Substantial damage
  > A total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.
- [NTSB WPR24FA287](https://openairdocs.org/ntsb/WPR24FA287.md): Pitts S1 · Santa Paula, CA · Accident · Serious injuries · Class 3 · Field · Final report · Aug 25, 2024 · N42JF · Destroyed
  > The total loss of engine power at low altitude for reasons that could not be determined.
- [NTSB WPR24LA275](https://openairdocs.org/ntsb/WPR24LA275.md): Piper PA-30 · Concord, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 9, 2024 · N8458Y · Substantial damage
  > The failure of the main landing gear to extend and lock for reasons that could not be determined based on the available information. Contributing to the accident was a mechanical failure of the manual landing gear release mechanism due to inadequate clearance…
- [NTSB WPR24LA229](https://openairdocs.org/ntsb/WPR24LA229.md): Cessna 172N · San Diego, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 2, 2024 · N74C · Substantial damage
  > A failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.
- [NTSB WPR24LA218](https://openairdocs.org/ntsb/WPR24LA218.md): TL Ultralight Sting RG · Rio Linda, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 26, 2024 · N912RG · Substantial damage
  > A loss of engine power due to fuel exhaustion. Contributing to the accident was a fuel quantity indication that was inconsistent with the actual fuel state of the airplane, which likely led the pilot to overestimate the amount of fuel remaining onboard.
- [NTSB WPR24LA174](https://openairdocs.org/ntsb/WPR24LA174.md): Beech 35-C33A · San Diego, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 1, 2024 · N1259M · Substantial damage
  > A partial loss of engine power due to water contamination of the fuel system.
- [NTSB WPR24LA160](https://openairdocs.org/ntsb/WPR24LA160.md): Steen Skybolt · Santa Maria, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 26, 2024 · N873X · Substantial damage
  > A total loss of engine power during approach for reasons that could not be determined.
- [NTSB WPR24FA119](https://openairdocs.org/ntsb/WPR24FA119.md): Daher TBM700 · Truckee, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 31, 2024 · N960LP · Destroyed
  > On March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR24FA037](https://openairdocs.org/ntsb/WPR24FA037.md): Cessna P210N · San Diego, CA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 16, 2023 · N1400 · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.
- [NTSB OPS24LA004](https://openairdocs.org/ntsb/OPS24LA004.md): Airbus A321-271N · Long Beach, CA · Incident · Class 4 · Limited · Final report · Oct 27, 2023 · N216HA · 2 aircraft · No damage
  > The local controller’s poor judgment in prioritization of their ground traffic ahead of their airborne traffic, that became a distraction and led to a loss of situational awareness resulting in a near midair collision. Contributing to the incident was the…
- [NTSB WPR23LA341](https://openairdocs.org/ntsb/WPR23LA341.md): Bellanca 7ECA · El Cajon, CA · Accident · No injuries · Class 3 · Limited · Final report · Sep 9, 2023 · N57679 · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB WPR23LA320](https://openairdocs.org/ntsb/WPR23LA320.md): Cessna 172H · Santa Rosa, CA · Accident · No injuries · Class 4 · Limited · Final report · Aug 19, 2023 · N3282L · Substantial damage
  > The pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR23FA299](https://openairdocs.org/ntsb/WPR23FA299.md): Czech Sport SportCruiser · Van Nuys, CA · Accident · 2 fatal · Class 3 · Field · Final report · Aug 2, 2023 · N384SC · Destroyed
  > The misalignment of the carburetor piston slides, which resulted in a partial loss of engine power, and the flight instructor’s failure to maintain control of the airplane during an emergency landing, leading to an aerodynamic stall and impact with terrain.
- [NTSB WPR23FA258](https://openairdocs.org/ntsb/WPR23FA258.md): Cessna 172N · San Rafael, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 9, 2023 · N4922G · Substantial damage
  > The total loss of engine power due to carburetor icing as a result of the pilot’s failure to activate the carburetor heat in a timely manner during the descent.
- [NTSB WPR23FA257](https://openairdocs.org/ntsb/WPR23FA257.md): Cessna 550 · Murrieta, CA · Accident · 6 fatal · Class 3 · Field · Final report · Jul 8, 2023 · N819KR · Destroyed
  > The flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…
- [NTSB WPR23LA245](https://openairdocs.org/ntsb/WPR23LA245.md): Schleicher Alexander ASH 26 E · Williams, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 26, 2023 · N26DX · Substantial damage
  > The pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a collision with terrain.
- [NTSB WPR23LA202](https://openairdocs.org/ntsb/WPR23LA202.md): Mooney M-18C 55 · Napa, CA · Accident · Minor injuries · Class 3 · Limited · Final report · May 26, 2023 · N201MM · Substantial damage
  > The pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.
- [NTSB WPR23FA173](https://openairdocs.org/ntsb/WPR23FA173.md): Beech A36 · Big Bear, CA · Accident · 3 fatal · Class 3 · Field · Final report · May 1, 2023 · N2038Y · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB WPR23FA172](https://openairdocs.org/ntsb/WPR23FA172.md): Cessna 172S · Los Angeles, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 30, 2023 · N575ND · Substantial damage
  > The pilot’s failure to maintain clearance with the hilly terrain resulting from his loss of situational awareness due to the deteriorating weather conditions as he descended to approach his destination airport.
- [NTSB WPR23LA159](https://openairdocs.org/ntsb/WPR23LA159.md): Vashon Ranger R7 · Upland, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 18, 2023 · N349VR · Substantial damage
  > The pilot's improper selection of the mixture control, which resulted in a total loss of engine power and a collision with the airport boundary fence during a forced landing.
- [NTSB WPR23LA154](https://openairdocs.org/ntsb/WPR23LA154.md): Cessna T337G · Upland, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 16, 2023 · N38C · Substantial damage
  > The pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.
- [NTSB WPR23LA098](https://openairdocs.org/ntsb/WPR23LA098.md): Cessna T210N · Murrieta, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 27, 2023 · N4758C · Substantial damage
  > A loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.
- [NTSB WPR23FA092](https://openairdocs.org/ntsb/WPR23FA092.md): Cessna 414 · Modesto, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 18, 2023 · N4765G · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain proper airspeed during a turn to final, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction…
- [NTSB WPR23LA088](https://openairdocs.org/ntsb/WPR23LA088.md): Cessna 180K · Agua Caliente Springs, CA · Accident · No injuries · Class 4 · Limited · Final report · Jan 12, 2023 · N2875K · Substantial damage
  > The pilot’s failure to maintain aircraft control during an aborted approach, which resulted in a collision with terrain.
- [NTSB WPR23FA047](https://openairdocs.org/ntsb/WPR23FA047.md): Greg Hobbs Lightning · Torrance, CA · Accident · 2 fatal · Class 3 · Field · Final report · Nov 30, 2022 · N60MY · Substantial damage
  > The failure of the pilot to maintain control of the airplane while performing a slip maneuver on final approach. Contributing was the failure of the pilot to fly a stabilized approach.
- [NTSB WPR23FA027](https://openairdocs.org/ntsb/WPR23FA027.md): Cirrus Design SR20 · San Diego, CA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 5, 2022 · N700YZ · Substantial damage
  > The student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.
- [NTSB WPR22FA335](https://openairdocs.org/ntsb/WPR22FA335.md): Rutan Varieze · Columbia, CA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 5, 2022 · N10EZ · Substantial damage
  > The pilot’s improper maintenance of the ignition system, which led to an ignition system failure and a loss of engine power.

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

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