# NTSB investigations, 2017, CA: Roll over

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 WPR18CA048](https://openairdocs.org/ntsb/WPR18CA048.md): Cessna 172P · Valley Springs, CA · Accident · Serious injuries · Data collection · Final report · Dec 14, 2017 · N54873 · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.
- [NTSB WPR17LA211](https://openairdocs.org/ntsb/WPR17LA211.md): Robinson Helicopter R22 · Long Beach, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2017 · N7514S · Substantial damage
  > The student pilot's failure to maintain rotor rpm during the crosswind landing approach and his subsequent improper decision to initiate an autorotation instead of applying corrective control inputs after the helicopter experienced normal airframe vibration.…
- [NTSB GAA17CA404](https://openairdocs.org/ntsb/GAA17CA404.md): Eurocopter AS 350 · King Vale, CA · Accident · Minor injuries · Data collection · Final report · Jul 11, 2017 · N357PJ · Substantial damage
  > The pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.

## 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 year(c."eventDate") = 2017
  AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' 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/097/sequence?state=CA&year=2017

---
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.
