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
| 2008 | 8 |
|---|---|
| 2009 | 6 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 12 |
| 2018 | 9 |
| 2019 | 8 |
| 2020 | 8 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 9 |
| 2025 | 3 |
| 2026 | 7 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.NTSB 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…NTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA439Accident · No injuriesData collectionFinal reportCessna A185 · Arctic Village, AKThe pilot’s failure to maintain directional control after an aborted takeoff.NTSB 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.NTSB GAA17CA362Accident · No injuriesData collectionFinal reportCessna A185 · Henderson, NVThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB 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.NTSB GAA17CA313Accident · No injuriesData collectionFinal reportCessna A185 · Clovis, NMThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.NTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.NTSB 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.