NTSB investigations: Cubcrafters CC11-160

7 cases on aircraft the registry lists as Cubcrafters CC11-160, where the sequence of events included Collision with terr/obj (non-CFIT). 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20112026

NTSB investigations: Cubcrafters CC11-160 per year, 2011–2026: 7 cases
2011	1
2015	1
2017	2
2018	2
2020	1

Where

Open the map

Latest cases

Query with 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 ('060006N', '060009W') 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" = '470' 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

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 ('060006N', '060009W')
      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\" = '470' 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"

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 ('060006N', '060009W')
    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" = '470' 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

Run 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 CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.Sep 18, 2020 · N55JV · Substantial damage NTSB WPR18LA107Accident · Serious injuriesLimited investigationFinal reportCubcrafters CC11-160 · Browns Valley, CAThe pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.Mar 18, 2018 · N1951B · Substantial damage NTSB GAA18CA132Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Carson City, NVThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.Feb 10, 2018 · N88ZQ · Substantial damage NTSB CEN17LA265Accident · Minor injuriesLimited investigationFinal reportCubcrafters CC11-160 · Milesville, SDFuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…Jul 9, 2017 · N111JW · Substantial damage 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.Mar 18, 2017 · N153JM · Substantial damage NTSB GAA15CA292Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.Sep 29, 2015 · N4HW · Substantial damage NTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.Apr 23, 2011 · N143FJ · Substantial damage