NTSB investigations: Continental TSIO-520 series, CA

6 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the defining event was Landing gear not configured. 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 TSIO-520 series, CA per year, 2008–2026: 6 cases
20082
20121
20171
20181
20231

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.\"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 ('17040')
      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\" = '095'))
  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 WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damageNTSB WPR18LA264Accident · No injuriesLimited investigationFinal reportCessna T210 · San Luis Obispo, CAThe failure of the landing gear extension motor due to wear, which resulted in the right main landing gear not fully extending and locking into place during landing. Contributing to the accident was the pilot’s failure to ensure that all three landing gear…Sep 15, 2018 · N5340Y · Substantial damageNTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.Jul 7, 2017 · N333GK · Substantial damageNTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…Jan 8, 2012 · N580TC · Substantial damageNTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.Nov 22, 2008 · N732XS · Substantial damageNTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.Aug 20, 2008 · N818CT · Substantial damage