NTSB investigations: Continental 0-300 series, 2014
12 cases on aircraft whose registry engine model is Continental 0-300 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 | 183 |
|---|---|
| 1965 | 197 |
| 1966 | 237 |
| 1967 | 250 |
| 1968 | 163 |
| 1969 | 112 |
| 1970 | 114 |
| 1971 | 113 |
| 1972 | 96 |
| 1973 | 87 |
| 1974 | 53 |
| 1975 | 51 |
| 1976 | 61 |
| 1977 | 68 |
| 1978 | 65 |
| 1979 | 49 |
| 1980 | 37 |
| 1981 | 48 |
| 1982 | 31 |
| 1983 | 31 |
| 1984 | 34 |
| 1985 | 31 |
| 1986 | 38 |
| 1987 | 39 |
| 1988 | 35 |
| 1989 | 27 |
| 1990 | 28 |
| 1991 | 23 |
| 1992 | 29 |
| 1993 | 30 |
| 1994 | 22 |
| 1995 | 32 |
| 1996 | 29 |
| 1997 | 18 |
| 1998 | 31 |
| 1999 | 28 |
| 2000 | 27 |
| 2001 | 28 |
| 2002 | 30 |
| 2003 | 37 |
| 2004 | 28 |
| 2005 | 32 |
| 2006 | 27 |
| 2007 | 28 |
| 2008 | 23 |
| 2009 | 18 |
| 2010 | 22 |
| 2011 | 17 |
| 2012 | 20 |
| 2013 | 21 |
| 2014 | 12 |
| 2015 | 22 |
| 2016 | 17 |
| 2017 | 20 |
| 2018 | 22 |
| 2019 | 23 |
| 2020 | 13 |
| 2021 | 30 |
| 2022 | 17 |
| 2023 | 19 |
| 2024 | 17 |
| 2025 | 25 |
| 2026 | 10 |
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\") = 2014
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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") = 2014
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022'))
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 WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…NTSB ERA14CA398Accident · No injuriesData collectionFinal reportCessna 172F · Oxford, NCThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's improper compensation for wind conditions.NTSB CEN14LA347Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Baytown, TXThe pilot’s failure to verify the fuel onboard before the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14CA291Accident · No injuriesData collectionFinal reportCessna 172B · Frankfort, KYThe pilot's failure to maintain directional control during landing in crosswind conditions, resulting in a loss of control and runway excursion.NTSB ANC14CA037Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe airplane's encounter with a tailwind during takeoff from a short, narrow airstrip, which resulted in a loss of lift and collision with brush and small trees.NTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.NTSB ANC14CA033Accident · No injuriesData collectionFinal reportCessna 172F · Fairbanks, AKThe pilot's improper inflight planning, which resulted in fuel starvation and a loss of engine power. A factor was the pilot's selection of a low cruise flight altitude, which provided little time for the selection of suitable terrain for the forced landing…NTSB ANC14CA026Accident · No injuriesData collectionFinal reportCessna 170B · Soldotna, AKThe pilot's failure to recognize a wind shift, resulting in a tailwind landing, loss of control, and ground loop.NTSB WPR14CA170Accident · No injuriesData collectionFinal reportPiper PA 18S-150 · Browning, MTThe pilot's failure to maintain directional control during the landing roll which resulted in a veer off the airstrip and collision with a ditch.NTSB ERA14CA171Accident · Serious injuriesData collectionFinal reportCessna 172 · Carlisle, PAThe pilot's decision to depart with a known mechanical malfunction and his improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an off-airport landing.NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.NTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.