# Final NTSB investigations, CA: Medical event

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.

## Latest cases

- [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 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 WPR24LA003](https://openairdocs.org/ntsb/WPR24LA003.md): Cessna 340A · Hayward, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 2, 2023 · N121CB · Substantial damage
  > The pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.
- [NTSB WPR19IA030](https://openairdocs.org/ntsb/WPR19IA030.md): Cessna 208 · Bakersfield, CA · Incident · Minor injuries · Class 3 · Incident · Final report · Nov 24, 2018 · N781FE · No damage
  > The pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…
- [NTSB WPR10GA231](https://openairdocs.org/ntsb/WPR10GA231.md): Cessna T206H · Borrego Springs, CA · Accident · 1 fatal · Final report · May 7, 2010 · N663HP · Destroyed
  > The pilot suffered a sudden incapacitating event as a result of his severe cardiovascular disease.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '850' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/850/sequence?state=CA&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
