# Fatal NTSB investigations, CA: Simulated/training event

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 WPR17FA063](https://openairdocs.org/ntsb/WPR17FA063.md): Cessna 172 · Ramona, CA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 2017 · N2179L · Substantial damage
  > The flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.
- [NTSB WPR10FA078](https://openairdocs.org/ntsb/WPR10FA078.md): Piper PA-38-112 · Ojai, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2009 · N2463K · Substantial damage
  > Airspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.
- [NTSB LAX08LA191](https://openairdocs.org/ntsb/LAX08LA191.md): Cessna 172S · Oceanside, CA · Accident · 2 fatal · Limited investigation · Final report · Jun 23, 2008 · N2436F · Destroyed
  > Failure of the pilot to regain airplane control during an intentional stall/spin maneuver.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '600' 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/600/sequence?fatal=1&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
