NTSB investigations: Continental 0-300 series, 2004
28 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
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\") = 2004
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") = 2004
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 CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.NTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.NTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.NTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.NTSB IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.NTSB FTW04CA245Accident · No injuriesData collectionFinal reportCessna 172H · Houston, TXThe student pilot's failure to maintain clearance from a parked aircraft while taxiing. A contributing factor was the student pilot's anxiety attack.NTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.NTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…NTSB SEA04LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Port Angeles, WAThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.NTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…NTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.NTSB SEA04LA152Accident · 1 fatalLimited investigationFinal reportPaulick Wittman W-10 · Langley, WAThe pilot's inadequate preflight preparation to assure adequate takeoff performance to clear obstacles, and his failure to maintain obstacle clearance.NTSB ATL04CA163Accident · Minor injuriesData collectionFinal reportCessna 172 · Inman, SCThe pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.NTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.NTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.NTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB ANC04LA061Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.NTSB LAX04LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, CAthe pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.NTSB SEA04LA053Accident · No injuriesLimited investigationFinal reportCessna 172E · Raymond, WAThe pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.NTSB CHI04CA088Accident · Minor injuriesData collectionFinal reportCessna 172A · Springfield, MOThe pilot failed to initiate a go-around and the airplane porpoised during the hard landing. Factors associated with the accident were the excessive groundspeed and the overload failure of the nose gear.NTSB SEA04LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Marion, MTThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gust of wind and the snowbank.NTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.NTSB ANC04LA034Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe pilot's delayed response in initiating an aborted takeoff, which resulted in an overrun and collision with a snowbank.NTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.NTSB LAX04CA086Accident · No injuriesData collectionFinal reportCessna 172F · Redlands, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.