NTSB investigations: Continental 0-300 series, 2021
30 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\") = 2021
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") = 2021
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 ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…NTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB WPR22LA037Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to attain sufficient airspeed for the airplane to climb with a tailwind.NTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.NTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.NTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.NTSB ERA21LA383Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Miramar, FLThe flight instructor’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation. Contributing to the flight instructor’s injury was her failure to wear the shoulder harness.NTSB CEN21LA415Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170B · Ozark, ARThe pilot’s inadequate takeoff performance planning that resulted in a climb gradient too low to clear trees on departure, and his failure to maintain aircraft control that resulted in an aerodynamic stall and impact with terrain.NTSB WPR21LA337Accident · No injuriesClass 3 · LimitedFinal reportCessna 172E · Enterprise, ORThe fatigue fracture of the nose gear upper torque link, which resulted in the separation of the torque link from the shock strut and a loss of directional control.NTSB WPR21LA308Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Reno, NVThe pilot’s failure to maintain clearance from mountainous terrain prior to encountering a downdraft, which resulted in a forced landing and collision with terrain.NTSB WPR21LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Athol, IDThe failure of the windshield during spin recovery for reasons that were not determined.NTSB CEN21LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Iron Mountain, MIThe mechanics’ failure to follow procedures for high-thrust operations at the nontowered airport, which resulted in jet blast damage to an airplane taxiing nearby.NTSB ERA21LA313Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Waxhaw, NCThe pilot’s failure to abort the takeoff in sufficient time to stop the airplane on the runway remaining. Contributing to the accident was the lack of airplane takeoff performance due to the pilot’s failure to assure that the carburetor heat control was in…NTSB ANC21LA061Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Skwentna, AKA partial loss of engine power due to detonation/preignition damage to the No. 2 cylinder. The reason for the detonation/preignition damage could not be determined based on the available evidence.NTSB CEN21LA316Accident · No injuriesClass 3 · LimitedFinal reportCessna 172F · Eagle Butte, SDA total loss of engine power due to the fatigue failure of the No. 6 connecting rod.NTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.NTSB WPR21LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Miles City, MTThe pilot’s failure to maintain directional control during takeoff which resulted in a ground loop and collision with terrain.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB WPR21LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Washington, CAA total loss of engine power during an enroute climb due to a stuck exhaust valve and multiple failed piston compression rings.NTSB WPR21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Mesquite, NVThe pilot’s failure to maintain airplane control during the landing roll, which resulted in a nosed over.NTSB ERA21LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Johnson City, TNThe student pilot’s excessive airspeed during the landing approach and his delayed remedial action, which resulted in the airplane striking obstacles during an aborted landing. Contributing was the pilot’s decision to land with a tailwind.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB ERA21LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Fayetteville, NCThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.NTSB WPR21LA153Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Sand Point, IDThe student pilot’s improper landing flare which resulted in a hard landing, loss of directional control and subsequent nose over.NTSB WPR21LA122Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172G · Sisters, ORA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.NTSB ERA21LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Winchester, VAThe pilot’s delayed use of carburetor heat, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.