NTSB investigations: Continental IO-520 series, 2005, WA
5 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1975 | 5 |
| 1976 | 1 |
| 1977 | 5 |
| 1978 | 6 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1988 | 4 |
| 1989 | 5 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 4 |
| 2000 | 1 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 3 |
| 2009 | 3 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 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\") = 2005
AND c.\"eventStateOrRegion\" = 'WA' 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") = 2005
AND c."eventStateOrRegion" = 'WA' 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 SEA05LA141Accident · No injuriesLimited investigationFinal reportCessna 206E · Stuart Island, WAThe pilot's excessive airspeed on final for the current runway surface conditions, and the intentional obstruction avoidance maneuver he executed when it became clear the aircraft was about to go off the end of the runway. Factors include the pilot's improper…NTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…NTSB SEA05LA110Accident · No injuriesLimited investigationFinal reportBeech A-36 · Tacoma, WAThe malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.NTSB SEA05CA069Accident · No injuriesData collectionFinal reportCessna A188B · Palouse, WAThe pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.NTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…