# NTSB investigations: Continental IO-240 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 GAA18CA474](https://openairdocs.org/ntsb/GAA18CA474.md): Diamond DA20 · Van Nuys, CA · Accident · No injuries · Data collection · Final report · Jul 18, 2018 · N309EF · Substantial damage
  > The student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.
- [NTSB WPR15LA154](https://openairdocs.org/ntsb/WPR15LA154.md): Diamond Aircraft Ind DA 20 C1 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Apr 24, 2015 · N309EF · 2 aircraft · Minor damage
  > Both pilots’ failure to see and avoid each other, which resulted in an on ground collision while taxiing. Contributing to the accident was the ground controller’s failure to notify either pilot about the presence of the other airplane on the taxiway.
- [NTSB WPR14CA299](https://openairdocs.org/ntsb/WPR14CA299.md): Diamond Aircraft Ind DA 20 C1 · Hoopa, CA · Accident · No injuries · Data collection · Final report · Jul 18, 2014 · N528DC · Substantial damage
  > The pilot's inadequate approach and excessive airspeed which resulted in a long landing and subsequent runway overrun onto rough terrain.

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

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