NTSB investigations: Continental IO-520 series, 2017

12 cases on aircraft whose registry engine model is Continental IO-520 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 IO-520 series, 2017 per year, 2008–2026: 135 cases
20088
20096
20104
20116
201210
201310
20146
20157
20167
201712
20189
20198
20208
20215
20224
20236
20249
20253
20267

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\") = 2017
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
      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 GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.Oct 24, 2017 · N19EC · Substantial damageNTSB ANC17LA053Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AK***This probable cause was modified on November 27, 2018. Please see the docket for this accident to view the original probable cause.*** The pilot's improper decision to takeoff in an area of rough water and ocean swells, which resulted in a failure of the…Sep 4, 2017 · N16GP · Substantial damageNTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 26, 2017 · N208SS · Substantial damageNTSB GAA17CA439Accident · No injuriesData collectionFinal reportCessna A185 · Arctic Village, AKThe pilot’s failure to maintain directional control after an aborted takeoff.Jul 22, 2017 · N5227R · Substantial damageNTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.Jul 5, 2017 · N4207J · Substantial damageNTSB GAA17CA362Accident · No injuriesData collectionFinal reportCessna A185 · Henderson, NVThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Jun 23, 2017 · N4356R · Substantial damageNTSB GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.Jun 14, 2017 · N4877Q · Substantial damageNTSB GAA17CA313Accident · No injuriesData collectionFinal reportCessna A185 · Clovis, NMThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.May 31, 2017 · N185FF · Substantial damageNTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.May 27, 2017 · N2262T · Substantial damageNTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.May 17, 2017 · N4804F · Substantial damageNTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.May 9, 2017 · N185RX · Substantial damageNTSB GAA17CA212Accident · No injuriesData collectionFinal reportThomas Craig E Wittman W-10 · Stevensville, MTThe pilot’s decision to take off with a known master brake cylinder leak and his subsequent failure to maintain directional control during landing.Mar 28, 2017 · N13XZ · Substantial damage