# NTSB investigations: Continental C125 series: Loss of control in flight

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 CEN21LA069](https://openairdocs.org/ntsb/CEN21LA069.md): Globe GC1A · Ottawa, KS · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 28, 2020 · N3318K · Substantial damage
  > The student pilot’s failure to maintain attain proper pitch attitude of the airplane causing it to exceed its critical angle of attack, enter an aerodynamic stall, and subsequently impact terrain, and his poor decision making and lack of experience that led…
- [NTSB CEN17FA152](https://openairdocs.org/ntsb/CEN17FA152.md): Temco GC 1B · Hartsville, IN · Accident · 1 fatal · Field investigation · Final report · Apr 12, 2017 · N2377B · Substantial damage
  > The pilot's loss of control after exceeding the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.
- [NTSB ERA14LA363](https://openairdocs.org/ntsb/ERA14LA363.md): Temco GC 1B · Yulee, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2014 · N1CY · Substantial damage
  > The pilot’s failure to maintain airplane control, which resulted in subsequent impact with 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17011')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/240/cases?engine=17011

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