# NTSB investigations, 2011: Intentional act

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 ERA11LA457](https://openairdocs.org/ntsb/ERA11LA457.md): Piper PA-32R-301T · Graham, NC · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 2011 · N492ST · Substantial damage
  > The individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.
- [NTSB CEN11LA404](https://openairdocs.org/ntsb/CEN11LA404.md): Ayres S2R-T34 · Athleimer, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 2011 · N30902 · Substantial damage
  > Failure of the first stage planetary gearset in the propeller reduction gearbox, which resulted in catastrophic engine failure. Contributing to the failure was the misrepresentation of the gearset being zero-timed by the company that sold the gearset to the…
- [NTSB WPR11FA490](https://openairdocs.org/ntsb/WPR11FA490.md): Radford RV-6 · Grand Canyon, AZ · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2011 · N650RV · Substantial damage
  > The pilot's intentional flight into 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 year(c."eventDate") = 2011
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020510'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/020510/cases?year=2011

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