NTSB investigations: Continental A&C65 series, 2011
7 cases on aircraft whose registry engine model is Continental A&C65 series, where the defining event was Loss of control on ground. 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
| 2008 | 3 |
|---|---|
| 2009 | 11 |
| 2010 | 10 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 9 |
| 2015 | 5 |
| 2016 | 11 |
| 2017 | 9 |
| 2018 | 13 |
| 2019 | 9 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 3 |
Where
Latest 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\") = 2011
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
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\" = '230'))
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") = 2011
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
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" = '230'))
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 CEN12CA117Accident · No injuriesData collectionFinal reportLuscombe 8E · Atchison, KSThe pilot's inadequate directional control during the landing roll.NTSB CEN11CA689Accident · Minor injuriesData collectionFinal reportPiper J3L-65 · Gainesville, TXThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.NTSB CEN11LA614Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Valparaiso, INThe pilot’s loss of directional control during landing. Contributing to the accident was the wear in the tailwheel assembly.NTSB CEN11CA613Accident · Minor injuriesData collectionFinal reportTaylorcraft DCO-65 · Higginsville, MOThe pilot's failure to maintain directional control during landing and his failure to maintain clearance from trees during the attempted aborted landing.NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.