# NTSB investigations, 2011: Altitude deviation

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 WPR12MA034](https://openairdocs.org/ntsb/WPR12MA034.md): Eurocopter EC 130 B4 · Pukoo, HI · Accident · 5 fatal · Major investigation · Final report · Nov 10, 2011 · N11QV · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…
- [NTSB ERA11CA365](https://openairdocs.org/ntsb/ERA11CA365.md): Piper PA-32-300 · Bridgeport, CT · Accident · Serious injuries · Data collection · Final report · Jun 26, 2011 · N600DK · Substantial damage
  > The pilot's failure to maintain clearance from a blast fence on final approach to land.
- [NTSB ERA11FA219](https://openairdocs.org/ntsb/ERA11FA219.md): Beech 58 · Greensboro, NC · Accident · 2 fatal · Field investigation · Final report · Mar 30, 2011 · N569JL · Substantial damage
  > The pilot’s spatial disorientation due to a somatogravic illusion while conducting a missed approach in instrument meteorological conditions, which resulted in the airplane’s descent into objects and terrain.
- [NTSB ERA11CA180](https://openairdocs.org/ntsb/ERA11CA180.md): Robinson Helicopter R44 II · Weston, FL · Accident · Serious injuries · Data collection · Final report · Mar 5, 2011 · N4168W · Substantial damage
  > The pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.
- [NTSB ERA11FA102](https://openairdocs.org/ntsb/ERA11FA102.md): Cessna 310F · Orange, MA · Accident · 1 fatal · Field investigation · Final report · Jan 1, 2011 · N6725X · Substantial damage
  > The pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '282' 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/282/sequence?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.