NTSB investigations: Continental A&C65 series, 2012

6 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

20082026
NTSB investigations: Continental A&C65 series, 2012 per year, 2008–2026: 123 cases
20083
200911
201010
20117
20126
20133
20149
20155
201611
20179
201813
20199
20206
20215
20224
20234
20245
20253

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\") = 2012
    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.

NTSB ERA12CA490Accident · No injuriesData collectionFinal reportAeronca 7AC · Winter Haven, FLThe student pilot’s failure to maintain directional control during the landing roll.Aug 1, 2012 · N1060E · Substantial damageNTSB ERA12CA430Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Camden, TNThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.Jun 30, 2012 · N96282 · Substantial damageNTSB WPR12CA287Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Paulden, AZThe pilot’s failure to maintain directional control during the landing roll.Jun 27, 2012 · N43087 · Substantial damageNTSB ERA12CA245Accident · No injuriesData collectionFinal reportAeronca 7AC · Clearwater, FLThe pilot's failure to maintain airplane control during takeoff and the flight instructor's inadequate supervision, which resulted in a runway excursion.Mar 20, 2012 · N82406 · Substantial damageNTSB ERA12CA235Accident · No injuriesData collectionFinal reportPiper J3C-65 · Douglas, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's lack of experience in the tailwheel-equipped airplane.Mar 17, 2012 · N3225N · Substantial damageNTSB WPR12LA122Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby 1-A · Fallbrook, CAThe pilot did not maintain directional control of the airplane during the takeoff roll.Mar 4, 2012 · N41017 · Substantial damage