NTSB investigations: Flight Design CTSW
5 cases on aircraft the registry lists as Flight Design CTSW, where the defining event was Loss of engine power (total). 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
| 2012 | 1 |
|---|---|
| 2016 | 3 |
| 2021 | 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 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' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
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 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' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '341'))
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 WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA 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 CEN17LA041Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Port Allen, LAThe 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.NTSB CEN16LA221Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw HXB · Sealy, TXFailure of maintenance personnel to comply with the engine manufacturer’s mandatory service bulletin, which resulted in failure of the mechanical fuel pump diaphragm and a subsequent total loss of engine power.NTSB ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.NTSB ERA12LA229Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Venice, FLA total loss of engine power due to a loss of fuel pressure. The cause for the loss of fuel pressure could not be determined during postaccident testing.