# NTSB investigations, CA: Miscellaneous

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 WPR24LA193](https://openairdocs.org/ntsb/WPR24LA193.md): Cessna A185F · Monument Hills, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 12, 2024 · N8WF · Substantial damage
  > A total loss of engine power for reasons that could not be determined.
- [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 WPR22LA049](https://openairdocs.org/ntsb/WPR22LA049.md): Taylorcraft BL-65 · New Cuyama, CA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 24, 2021 · N29508 · Destroyed
  > The pilot’s decision to intentionally crash the airplane.
- [NTSB WPR21LA366](https://openairdocs.org/ntsb/WPR21LA366.md): Sharp Ralph R Zenith Stol CH 701 · Bishop, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 24, 2021 · N701SA · Substantial damage
  > A loss of airplane control for undetermined reasons.
- [NTSB WPR15FAMS1](https://openairdocs.org/ntsb/WPR15FAMS1.md): Cessna 172S · Davenport, CA · Accident · 1 fatal · Missing aircraft · Final report · May 8, 2015 · N191TG
  > Undetermined because the airplane was not located.
- [NTSB WPR15LA150](https://openairdocs.org/ntsb/WPR15LA150.md): Cessna 206H · Redding, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 18, 2015 · N3535M · Destroyed
  > The pilot's intentional descent into terrain.
- [NTSB DCA14CA090](https://openairdocs.org/ntsb/DCA14CA090.md): Boeing 737 - 932ER · San Diego, CA · Accident · Serious injuries · Data collection · Final report · Mar 5, 2014 · N809DN · No damage
  > the flight attendant's inadvertent trip and fall over a passenger bag that was in the aisle.

## 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0205'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0205/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
