# NTSB investigations, 2010: Inflight upset

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 WPR11FA059](https://openairdocs.org/ntsb/WPR11FA059.md): Mooney M20R · Hollister, CA · Accident · 1 fatal · Field investigation · Final report · Nov 25, 2010 · VH-PPA · Substantial damage
  > The pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.
- [NTSB ERA11LA071](https://openairdocs.org/ntsb/ERA11LA071.md): Cessna 172N · Bluffton, SC · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2010 · N882AV · Substantial damage
  > An in-flight upset of undetermined origin resulting in a forced landing.
- [NTSB ERA11FA036](https://openairdocs.org/ntsb/ERA11FA036.md): Beech B36TC · Rienzi, MS · Accident · 2 fatal · Field investigation · Final report · Oct 26, 2010 · N8045Y · Substantial damage
  > The pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.
- [NTSB WPR11FA032](https://openairdocs.org/ntsb/WPR11FA032.md): Mooney M20J · Lander, WY · Accident · 4 fatal · Field investigation · Final report · Oct 25, 2010 · N201HF · Substantial damage
  > The pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…
- [NTSB CEN10IA453](https://openairdocs.org/ntsb/CEN10IA453.md): Piper PA-32R-301T · Mount Pleasant, TX · Incident · No injuries · Incident investigation · Final report · Aug 1, 2010 · N4184X · No damage
  > The failure of an aileron control cable due to a seized idler pulley bearing.
- [NTSB CEN10LA363](https://openairdocs.org/ntsb/CEN10LA363.md): Embraer EMB-145LR · Pioneer, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 2010 · N601DW · No damage
  > The inadvertent encounter with convective weather during cruise flight. Contributing to the accident was the flight crew's failure to detect and avoid the thunderstorm cell earlier in the flight, and the failure of air traffic controllers to provide the…
- [NTSB WPR10FA133](https://openairdocs.org/ntsb/WPR10FA133.md): Eurocopter EC135 · Cave Creek, AZ · Accident · 5 fatal · Field investigation · Final report · Feb 14, 2010 · N127TS · Substantial damage
  > The sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…

## 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") = 2010
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '271' 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/271/sequence?year=2010

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