NTSB investigations: Continental TSIO-520 series, 2018, CA

5 cases on aircraft whose registry engine model is Continental TSIO-520 series. 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

19662026
NTSB investigations: Continental TSIO-520 series, 2018, CA per year, 1966–2026: 245 cases
19661
19691
19711
19721
19742
19751
19767
19774
19784
19799
198010
19818
19829
19837
19847
19857
19863
19877
19885
19894
19903
19915
19922
19932
19941
19953
19964
19971
19982
19993
20002
20017
20026
20039
20044
20055
20069
20079
20086
20094
20103
20115
20127
20134
20152
20162
20177
20185
20193
20204
20212
20223
20238
20242
20251
20262

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\") = 2018
    AND 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'))
  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 WPR19LA039Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Los Banos, CAA partial loss of engine power for reasons that could not be determined based on the available information.Dec 6, 2018 · N361TC · 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 WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.Aug 12, 2018 · N136RM · Substantial damageNTSB WPR18FA211Accident · 5 fatalClass 2 · FieldFinal reportCessna 414 · Santa Ana, CAThe pilot’s failure to maintain adequate airspeed while maneuvering in the traffic pattern which resulted in an aerodynamic stall and subsequent spin at a low altitude, which the pilot was unable to recover from.Aug 5, 2018 · N727RP · DestroyedNTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.May 9, 2018 · N210BG · Substantial damage