# NTSB investigations: Pratt & Whitney R-2800 series, 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 WPR22FA331](https://openairdocs.org/ntsb/WPR22FA331.md): Yakovlev YAK-11 · Shafter, CA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 2, 2022 · N5943 · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.
- [NTSB LAX90FA336](https://openairdocs.org/ntsb/LAX90FA336.md): Lockheed PV-2 · Lakeport, CA · Accident · 8 fatal · Field investigation · Final report · Sep 29, 1990 · N7250C · Destroyed
  > The pilot-in-command's failure to maintain airspeed during a pull-up from a low pass. Factors which contributed to the accident were: the pilot's poor judgement in buzzing the seaplanes which resulted in insufficient altitude to recover from the stall, and…
- [NTSB LAX80DUG45](https://openairdocs.org/ntsb/LAX80DUG45.md): Republic P47D · Daggett, CA · Accident · No injuries · Closed · Jul 3, 1980 · N47DF · Substantial damage
- [NTSB OAK77FA015](https://openairdocs.org/ntsb/OAK77FA015.md): Lockheed PV-1 · Yosemite, CA · Accident · 2 fatal · Closed · Dec 9, 1976 · N80BD · Destroyed
- [NTSB OAK66A0012](https://openairdocs.org/ntsb/OAK66A0012.md): Martin M-404 · San Jose, CA · Accident · No injuries · Closed · Sep 19, 1965 · N444A · No damage
- [NTSB UNK64X1947](https://openairdocs.org/ntsb/UNK64X1947.md): Douglas DC-6A · Sacramento, CA · Incident · No injuries · Closed · May 25, 1964 · N90777 · Minor damage

## 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 ('52026'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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