# NTSB investigations, 2010: 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 WPR11FA073](https://openairdocs.org/ntsb/WPR11FA073.md): Cessna T210M · Ogden, UT · Accident · Serious injuries · Field investigation · Final report · Dec 6, 2010 · N77CF · Substantial damage
  > The pilot did not maintain clearance from obstacles after descending below the published approach decision height when visibility was less than published approach minimums due to heavy ground fog and he did not execute a missed approach after failing to…
- [NTSB ERA11FA070](https://openairdocs.org/ntsb/ERA11FA070.md): Piper PA 46-350P · Destin, FL · Accident · 3 fatal · Field investigation · Final report · Nov 24, 2010 · N548C · Substantial damage
  > Controlled flight into water due to the pilot's improper descent below the published minimum descent altitude.
- [NTSB WPR10LA427](https://openairdocs.org/ntsb/WPR10LA427.md): Piper PA-28-180 · Sequim, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 2010 · N5101L · 2 aircraft · Substantial damage
  > The pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.
- [NTSB CEN10LA529](https://openairdocs.org/ntsb/CEN10LA529.md): Piper Aerostar 601P · Baraboo, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2010 · N601PP · Substantial damage
  > The pilot's diverted attention during an approach for landing that resulted in an altitude loss and impact with terrain.
- [NTSB CEN10CA365](https://openairdocs.org/ntsb/CEN10CA365.md): Piper PA-28-140 · Rogers, AR · Accident · No injuries · Data collection · Final report · Jun 28, 2010 · N643TP · Substantial damage
  > The pilot's failure to maintain a proper descent rate during the approach to land.
- [NTSB ERA10CA319](https://openairdocs.org/ntsb/ERA10CA319.md): Robinson Helicopter R22 Beta · West Palm Beach, FL · Accident · No injuries · Data collection · Final report · Jun 19, 2010 · N7988H · Destroyed
  > The CFI's failure to prevent ground contact during hover, which resulted in a dynamic rollover.
- [NTSB CEN10CA163](https://openairdocs.org/ntsb/CEN10CA163.md): Cessna 172S · Lawrence, KS · Accident · No injuries · Data collection · Final report · Mar 10, 2010 · N99HV · Substantial damage
  > The student pilot's failure to maintain an appropriate glide path during approach. Contributing to the accident was the student pilot's decision to continue the approach instead of going around.
- [NTSB ERA10LA162](https://openairdocs.org/ntsb/ERA10LA162.md): Piper PA-34-200T · Vero Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2010 · N103GK · Substantial damage
  > The certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.
- [NTSB ERA10LA113](https://openairdocs.org/ntsb/ERA10LA113.md): Foster John Glasair III · Oxford, CT · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2010 · N540WF · Substantial damage
  > The pilot's failure to maintain a proper approach path during visual conditions at dusk, which resulted in an in-flight collision with power lines.

## 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" = '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=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.