# Fatal NTSB investigations: Flight Design CTLS: 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 CEN20LA219](https://openairdocs.org/ntsb/CEN20LA219.md): Flight Design Ctls · Beecher, IL · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 8, 2020 · N257V · Destroyed
  > The pilot’s decision to continue takeoff after a partial loss of engine power, and the pilot’s subsequent failure to control airplane pitch during a forced landing. Contributing to the accident was the partial loss of engine power for reasons that could not…
- [NTSB WPR16FA067](https://openairdocs.org/ntsb/WPR16FA067.md): Flight Design Ctls · Springville, CA · Accident · 2 fatal · Field investigation · Final report · Feb 11, 2016 · N911TS · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…
- [NTSB ERA16FA031](https://openairdocs.org/ntsb/ERA16FA031.md): Flight Design Ctls · Queens, NY · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2015 · N622BT · Substantial damage
  > The noninstrument-rated pilot's spatial disorientation and subsequent loss of airplane control while maneuvering at low altitude, over water with no visible horizon, in dark night conditions, which resulted in a collision with the water.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('060005B')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' 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/240/sequence?fatal=1&model=060005B

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