Fatal NTSB investigations: Continental IO-520 series, 2018
10 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
| 1964 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 4 |
| 1970 | 2 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 9 |
| 1977 | 6 |
| 1978 | 17 |
| 1979 | 30 |
| 1980 | 15 |
| 1981 | 15 |
| 1982 | 22 |
| 1983 | 21 |
| 1984 | 13 |
| 1985 | 7 |
| 1986 | 13 |
| 1987 | 5 |
| 1988 | 18 |
| 1989 | 9 |
| 1990 | 9 |
| 1991 | 11 |
| 1992 | 9 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 12 |
| 1999 | 13 |
| 2000 | 8 |
| 2001 | 19 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 21 |
| 2005 | 26 |
| 2006 | 16 |
| 2007 | 18 |
| 2008 | 15 |
| 2009 | 10 |
| 2010 | 14 |
| 2011 | 22 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 14 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 16 |
| 2020 | 13 |
| 2021 | 10 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 6 |
| 2026 | 8 |
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\") = 2018
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2018
AND c."highestInjuryLevel" = 'Fatal'
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 ERA19FA059Accident · 1 fatalField investigationFinal reportCessna 210 · Apalachicola, FLThe pilot's controlled flight into terrain as a result of his spatial disorientation during departure in dark nighttime conditions.NTSB ERA19FA039Accident · 1 fatalField investigationFinal reportCessna 310 · Walton, NYAn in-flight fire of undetermined origin. Contributing to the accident were the severe icing conditions encountered during the final minutes of the flight, which led to a loss of airplane control.NTSB WPR19FA001Accident · 1 fatalClass 2 · FieldFinal reportBeech V35 · La Verne, CAThe pilot's failure to maintain clearance from trees during a visual approach for landing. Contributing to the accident was the pilot's distraction during the approach.NTSB CEN18FA386Accident · 1 fatalField investigationFinal reportCessna U206 · Rainy Pass, AKThe pilot's improper decision to continue the flight in deteriorating weather conditions, which resulted in an inadvertent entry into a box canyon and subsequent controlled flight into mountainous terrain.NTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB ERA18WA143Accident · 3 fatalForeign investigationCessna U206F · Trelawny, JamaicaThe government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…NTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…NTSB CEN18FA108Accident · 2 fatalField investigationFinal reportBeech 58 · Ulysses, KSAn inflight loss of control and collision with terrain for reasons that could not be determined.NTSB ERA18WA217Accident · 1 fatalForeign investigationCessna A188 · La Vega, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a Cessna A188B airplane that occurred on February 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…