NTSB investigations: Flight Design CTSW, 2007
7 cases on aircraft the registry lists as Flight Design CTSW. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2006 | 4 |
|---|---|
| 2007 | 7 |
| 2008 | 3 |
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\") = 2007
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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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") = 2007
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN08LA008Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Afton, WYThe pilot's failure to correct the alignment of the airplane and his improper recovery from a bounced landing, resulting in exceeding the design stress limits that caused the right main landing gear to fail. A contributing factor in this accident was the…NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB CHI07CA228Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during landing which resulted in an inadvertent stall and subsequent impact with the ground.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB ATL07CA082Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fort Meade, MDThe student pilot's inadequate compensation for the gusty wind conditions during the landing flare, resulting in a loss of control, and an in-flight collision with terrain. A factor associated with the accident was the wind gusts.NTSB DEN07FA068Accident · Minor injuriesField investigationFinal reportFlight Design USA CT-SW · Albuquerque, NMThe 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…NTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.