NTSB investigations: Continental E225 series

6 cases on aircraft whose registry engine model is Continental E225 series, where NTSB found Gear extension and retract sys. 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

20092026
NTSB investigations: Continental E225 series per year, 2009–2026: 6 cases
20091
20151
20161
20181
20231
20261

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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17015')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01023230')))
  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 ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.Jun 27, 2026 · N3272C · Substantial damageNTSB CEN23LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Grand Prairie, TXThe pilot’s failure to extend the landing gear before landing.Feb 20, 2023 · N4210D · Substantial damageNTSB GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.May 28, 2018 · N2167D · Substantial damageNTSB GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.Sep 16, 2016 · N168B · Substantial damageNTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…May 29, 2015 · N2984B · Substantial damageNTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.Mar 16, 2009 · N342R · Substantial damage