# NTSB investigations: Flight Design CTSW, NM

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 WPR21LA173](https://openairdocs.org/ntsb/WPR21LA173.md): Flight Design Ctsw · Santa Fe, NM · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 22, 2021 · N378CT · Substantial damage
  > A leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.
- [NTSB CEN13LA409](https://openairdocs.org/ntsb/CEN13LA409.md): Flight Design Ctsw · Taos, NM · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 2013 · N424CT · Substantial damage
  > The airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.
- [NTSB DEN07FA068](https://openairdocs.org/ntsb/DEN07FA068.md): Flight Design USA CT-SW · Albuquerque, NM · Accident · Minor injuries · Field investigation · Final report · Mar 10, 2007 · N102RK · Substantial damage
  > The total failure of the left main landing gear strut due to overload during the landing resulting in the loss of control and subsequent nose over. A factor contributing to the accident was the chief pilot 's inability to maintain directional control of the…

## 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."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0600001'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0600001&state=NM

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