NTSB investigations: Continental IO-520-F, 2000
5 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\") = 2000
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") = 2000
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 LAX00FA347Accident · Minor injuriesField investigationFinal reportCessna 207A · Valle, AZImproper maintenance and adjustment of the engine magnetos resulting in a loss of optimum performance during a critical takeoff that required peak engine performance.NTSB ANC00LA115Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable, rough, runway. Factors were the crosswind, the pilot's inexperience, the company's inadequate surveillance of their operation, and dispatch of an inexperienced pilot to the unsuitable airport.NTSB ANC00LA116Accident · No injuriesLimited investigationFinal reportCessna 207A · Aniak, AKThe pilot's inadequate recovery from a bounced landing. Factors in the accident were the pilot's inadequate preflight planning/preparation, insufficient information about the landing strip from company personnel, inadequate oversight of the flight by company…NTSB ANC00LA074Accident · Minor injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe inadequate visual lookout by the pilot of the other airplane, and the inadequate radio traffic advisories by the pilots of both airplanes.NTSB ANC00LA035Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Delta Junction, AKThe disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.