NTSB investigations: Continental IO-520-F, 1987
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\") = 1987
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") = 1987
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 ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…NTSB ANC88DAG01Accident · No injuriesFinal reportCessna 207A · Atmautluak, AKThe aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway.NTSB ANC88LA008Accident · No injuriesLimited investigationFinal reportCessna 207A · Sheldon Point, AKThe air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that…NTSB ANC87FA023Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKWx conds on the day of the acdnt were rprtd to be extremely variable. Initially, when the plt obtained a wx briefing, VFR flt was not rcmdd. Later, the wx improved & the plt elected to proceed on the flt. While en route, he enctrd snow showers & dscndd to…