NTSB investigations: Continental IO-520 series, 2012, AK
9 cases on aircraft whose registry engine model is Continental IO-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
| 1967 | 1 |
|---|---|
| 1968 | 2 |
| 1969 | 4 |
| 1970 | 4 |
| 1971 | 6 |
| 1972 | 4 |
| 1973 | 10 |
| 1974 | 6 |
| 1975 | 14 |
| 1976 | 32 |
| 1977 | 21 |
| 1978 | 23 |
| 1979 | 17 |
| 1980 | 21 |
| 1981 | 22 |
| 1982 | 18 |
| 1983 | 17 |
| 1984 | 20 |
| 1985 | 14 |
| 1986 | 15 |
| 1987 | 11 |
| 1988 | 21 |
| 1989 | 17 |
| 1990 | 17 |
| 1991 | 17 |
| 1992 | 21 |
| 1993 | 19 |
| 1994 | 16 |
| 1995 | 18 |
| 1996 | 15 |
| 1997 | 25 |
| 1998 | 30 |
| 1999 | 15 |
| 2000 | 11 |
| 2001 | 13 |
| 2002 | 15 |
| 2003 | 13 |
| 2004 | 9 |
| 2005 | 17 |
| 2006 | 8 |
| 2007 | 12 |
| 2008 | 14 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 13 |
| 2012 | 9 |
| 2013 | 16 |
| 2014 | 2 |
| 2015 | 8 |
| 2016 | 11 |
| 2017 | 8 |
| 2018 | 11 |
| 2019 | 3 |
| 2020 | 6 |
| 2021 | 8 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 4 |
| 2026 | 10 |
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\") = 2012
AND c.\"eventStateOrRegion\" = 'AK' 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 ('17032'))
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") = 2012
AND c."eventStateOrRegion" = 'AK' 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 ('17032'))
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 ANC13CA005Accident · No injuriesData collectionFinal reportCessna A185E · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a ground loop.NTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.NTSB ANC12LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Denali Park, AKThe pilot’s failure to maintain clearance from an electric transmission line during the approach to land because he was distracted by the airplane’s broken and deflected landing ski. Contributing to the accident was the in-flight failure of the right ski…NTSB ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.NTSB ANC12FA079Accident · Minor injuriesField investigationFinal reportBeechcraft F33A · Fairbanks, AKThe total loss of engine power reason that could not be determined because postaccident examination and test run did not reveal any anomalies that would have precluded normal operation.NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC12LA046Accident · No injuriesLimited investigationFinal reportCessna A185F · Skwentna, AKThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power in cruise flight. Contributing to the accident was the pilot's failure to follow the checklist after the loss of engine power.NTSB ANC12CA027Accident · No injuriesData collectionFinal reportCessna U206G · Naknek, AKThe pilot's decision to take off from an unsuitable off-airport site.