# NTSB investigations: Rolls-Royce 250-C20B, CA

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 WPR17LA071](https://openairdocs.org/ntsb/WPR17LA071.md): Bell 206B · Firebaugh, CA · Accident · No injuries · Limited investigation · Final report · Mar 1, 2017 · N211CS · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge, which led the pilot to believe that there was adequate fuel onboard.
- [NTSB WPR14CA319](https://openairdocs.org/ntsb/WPR14CA319.md): Bell 206B · Salinas, CA · Accident · No injuries · Data collection · Final report · Jul 19, 2014 · N291SH · Substantial damage
  > The pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.
- [NTSB WPR13FA080](https://openairdocs.org/ntsb/WPR13FA080.md): Bell 206 · Delano, CA · Accident · 1 fatal · Field investigation · Final report · Jan 2, 2013 · N828AC · Destroyed
  > The pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.
- [NTSB WPR12CA183](https://openairdocs.org/ntsb/WPR12CA183.md): Bell 206B · Arvin, CA · Accident · No injuries · Data collection · Final report · Apr 25, 2012 · N969W · Substantial damage
  > The pilot did not maintain clearance from power lines during low altitude maneuvering.
- [NTSB OAK73DXQ36](https://openairdocs.org/ntsb/OAK73DXQ36.md): Bell 47G3B1 · Belden, CA · Accident · Minor injuries · Closed · Jun 29, 1973 · N8465E · Substantial damage
- [NTSB OAK70A0008](https://openairdocs.org/ntsb/OAK70A0008.md): Bell 47G-3B · Willow Crek, CA · Accident · Serious injuries · Closed · Jul 25, 1969 · N8465E · Destroyed

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('54385'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=54385&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.
