NTSB investigations: Continental IO-520-F, 2012
4 cases on aircraft whose registry engine model is Continental IO-520-F. 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
| 1976 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 6 |
| 1985 | 10 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 7 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17237'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17237'))
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 ANC12CA067Accident · No injuriesData collectionFinal reportCessna 207A · Kotlik, AKThe pilot's failure to maintain altitude/clearance from terrain during cruise flight at low altitude, which resulted in an in-flight collision with water. A contributing factor was the pilot’s diverted attention to adjust the engine power.NTSB ANC12CA048Accident · No injuriesData collectionFinal reportCessna 207A · Platinum, AKThe pilot inadvertently taxied the airplane into a ditch.NTSB WPR12CA194Accident · No injuriesData collectionFinal reportCessna 207A · Grangeville, IDThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of airplane control.NTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.