# NTSB investigations: Wright C7BA 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 WPR20CA153](https://openairdocs.org/ntsb/WPR20CA153.md): Ayres S 2R · Artois, CA · Accident · Minor injuries · Class 4 · Data collection · Final report · May 23, 2020 · N5573X · Substantial damage
  > The pilot's failure to maintain clearance from power lines during a go-around.
- [NTSB ANC17FA047](https://openairdocs.org/ntsb/ANC17FA047.md): Rockwell International S 2R · Calipatria, CA · Accident · 1 fatal · Field investigation · Final report · Aug 22, 2017 · N5022X · Destroyed
  > A loss of control for reasons that could not be determined because of the extensive thermal damage from the postcrash fire.
- [NTSB WPR11LA094](https://openairdocs.org/ntsb/WPR11LA094.md): Rockwell International S-2R · Oakley, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 10, 2011 · N4977X · Substantial damage
  > An in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…
- [NTSB LAX81FVG58](https://openairdocs.org/ntsb/LAX81FVG58.md): Rockwell S-2R · Clarksburg, CA · Accident · No injuries · Closed · Aug 5, 1981 · N4989X · Destroyed
- [NTSB OAK78DVG68](https://openairdocs.org/ntsb/OAK78DVG68.md): Sikorsky H-19 · Gerber, CA · Accident · No injuries · Closed · Jul 26, 1978 · N32533 · Substantial damage
- [NTSB OAK76DVG68](https://openairdocs.org/ntsb/OAK76DVG68.md): Aero Comdr 600S2R · Colusa, CA · Accident · No injuries · Closed · Apr 27, 1976 · N4983X · Substantial 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 ('67017'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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