NTSB investigations: Continental 0-200 series, 2005, WA
4 cases on aircraft whose registry engine model is Continental 0-200 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 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 10 |
| 1967 | 4 |
| 1968 | 11 |
| 1969 | 9 |
| 1970 | 9 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 8 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 7 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 11 |
| 1985 | 5 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 3 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 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 ('17020'))
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 ('17020'))
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 SEA06CA001Accident · Minor injuriesData collectionFinal reportCessna 150D · Greenwater, WAThe pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.NTSB SEA05FA158Accident · 2 fatalField investigationFinal reportCessna 150M · Renton, WAThe failure of the DHC-2 Beaver pilot to understand air traffic advisory information and the failure of the Cessna pilot to maintain visual separation, resulting in a midair collision. A factor contributing to the accident was the inadequate traffic advisory…NTSB SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.NTSB SEA05LA107Accident · No injuriesLimited investigationFinal reportCessna 150L · Spokane, WAThe pilot's inadequate in-flight decision by failing to fuel, resulting in fuel exhaustion and the loss of engine power while on approach for landing.