# NTSB investigations, 2011, CA: Controlled flight into terr/obj (CFIT)

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 WPR11FA430](https://openairdocs.org/ntsb/WPR11FA430.md): Cessna P210 · Tehachapi, CA · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2011 · N7WJ · Destroyed
  > The pilot’s intentional low-altitude maneuvering and failure to maintain clearance from terrain due to distraction.
- [NTSB WPR11CA398](https://openairdocs.org/ntsb/WPR11CA398.md): Bell 47G-4 · Los Banos, CA · Accident · Minor injuries · Data collection · Final report · Aug 21, 2011 · N948DS · Substantial damage
  > The pilot's failure to maintain clearance from the power poles while maneuvering during low-altitude operations.
- [NTSB WPR11FA268](https://openairdocs.org/ntsb/WPR11FA268.md): Trusty Thorp T-18 · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Jun 20, 2011 · N851LT · Substantial damage
  > The pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.
- [NTSB WPR11FA230](https://openairdocs.org/ntsb/WPR11FA230.md): Cameron Lancair Legacy · Pioneer, CA · Accident · 1 fatal · Field investigation · Final report · May 18, 2011 · N121J · Substantial damage
  > The pilot’s continued flight into instrument meteorological conditions at an insufficient altitude to clear 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."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" = '120' 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/120/sequence?state=CA&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.
