# NTSB investigations, 2011, NC: Aerodynamic stall/spin

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 ERA12LA112](https://openairdocs.org/ntsb/ERA12LA112.md): Piper PA-38-112 · Merry Hill, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 2011 · N9279T · Substantial damage
  > Operation of the airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s failure to maintain airspeed while making a forced landing following a total loss of engine power at low altitude, which resulted in an…
- [NTSB ERA12FA008](https://openairdocs.org/ntsb/ERA12FA008.md): Aviat A-1 · Moyock, NC · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2011 · N11HU · Substantial damage
  > The operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.
- [NTSB ERA11LA459](https://openairdocs.org/ntsb/ERA11LA459.md): Evans Robert W SR Pegazair 100 · Maysville, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2011 · N523RE · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.
- [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 ERA11CA129](https://openairdocs.org/ntsb/ERA11CA129.md): Kolb Kolb Mark III · Rutherfordton, NC · Accident · Serious injuries · Data collection · Final report · Jan 30, 2011 · N457A · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude resulting in a stall/spin and ground impact.

## 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" = 'NC' 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" = '241' 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/241/sequence?state=NC&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.
