# NTSB investigations: Flight Design CTSW: Attempted remediation/recovery

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 CEN20CA039](https://openairdocs.org/ntsb/CEN20CA039.md): Flight Design Ctsw · Delaware, OH · Accident · Minor injuries · Data collection · Final report · Dec 20, 2019 · N91WW · Substantial damage
  > The student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.
- [NTSB GAA19CA373](https://openairdocs.org/ntsb/GAA19CA373.md): Flight Design Ctsw · Blairesville, GA · Accident · No injuries · Data collection · Final report · May 19, 2019 · N153SW · Substantial damage
  > The pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.
- [NTSB CEN17FA249](https://openairdocs.org/ntsb/CEN17FA249.md): Flight Design Ctsw · Monticello, IA · Accident · 1 fatal · Field investigation · Final report · Jul 1, 2017 · N62JN · Substantial damage
  > The pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…
- [NTSB CEN17LA041](https://openairdocs.org/ntsb/CEN17LA041.md): Flight Design Ctsw · Port Allen, LA · Accident · No injuries · Limited investigation · Final report · Nov 13, 2016 · N329CT · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from debris in the fuel selector valve restricting the fuel flow to the engine and led to a forced landing on rough 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.aircraft_model_code IN ('0600001')
    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" = '060' 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/060/sequence?model=0600001

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