NTSB investigations: Cubcrafter CC340, CA
4 cases on aircraft whose registry engine model is Cubcrafter CC340. 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
| 2015 | 1 |
|---|---|
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('18050'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('18050'))
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 WPR20LA157Accident · 1 fatalClass 3 · LimitedFinal reportCub Crafters CCK-1865 · Valley Center, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control.NTSB GAA18CA169Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Mammoth Lakes, CAThe pilot’s failure to maintain directional control during the landing roll in a gusting crosswind conditions, which exceeded the airplane’s maximum demonstrated crosswind and resulted in the collapse of the left main landing gear.NTSB GAA17CA227Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Borrego Springs, CAThe pilot’s selection of an unsuitable takeoff area, which resulted in impact with obstacles.NTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…