NTSB investigations: Continental 0-300 series, 2001
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
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\") = 2001
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") = 2001
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 LAX02FA040Accident · No injuriesField investigationFinal reportCessna 172C · Corona, CAa loss of engine power due to the pilot's improper use of the carburetor heat controls while in weather conditions conducive to serious carburetor icing.NTSB NYC02LA024Accident · No injuriesLimited investigationFinal reportCessna 172D · Argyle, NYThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC02FA012Accident · 3 fatalField investigationFinal reportCessna 172 · South Hero, VTThe pilot's failure to maintain aircraft control during the takeoff. Factors in this accident were wind gusts and the airplane's high gross weight condition.NTSB MIA02LA006Accident · No injuriesLimited investigationFinal reportCessna 170 · Bennettsville, SCThe blockage of the fuel vent and also the collapsed fuel supply line resulting in the total loss of engine power due to fuel starvation.NTSB IAD02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Phillips, MELoss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall.NTSB SEA02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lindsay, MTThe pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.NTSB FTW01LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Odom, ARthe pilot's failure to follow the proper procedures for hand-propping an airplane.NTSB LAX01LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172-A · Groveland, CAa loss of engine power due to water contamination forced the pilot to land in an unsuitable area resulting in collision with a tree.NTSB ATL01LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Mobile, ALThe pilot's improper landing flare that resulted in a hard landing. A factor was the pilot induced porpoise.NTSB CHI01LA219Accident · No injuriesLimited investigationFinal reportCessna 172C · Grand Island, NEThe procedures for using carburetor heat not followed by the student pilot and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing conditions, the carburetor icing, the student pilot's lack of…NTSB NYC01FA147Accident · 1 fatalField investigationFinal reportCessna 172 · Newfane, VTThe pilot's failure to maintain aircraft control during takeoff. A factor was the pilot's impairment due to a narcotic painkiller and antihistamine.NTSB LAX01LA209Accident · No injuriesLimited investigationFinal reportCessna 170B · Payson, AZThe pilot's failure to maintain directional control and improper corrective action while landing in a quartering tailwind condition. A contributing factor was his lack of experience in the type of operation.NTSB NYC01LA142Accident · Minor injuriesLimited investigationFinal reportCessna 170A · South Charlesto, WVThe pilot's failure to maintain directional control while landing.NTSB ANC01LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Wasilla, AKAn undershoot due to the pilot's failure to maintain a proper glide path during a VFR final approach to landing. A factor in the accident was a downdraft.NTSB SEA01LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Rogersburg, WAThe pilot's failure to maintain aircraft control while on final approach for landing. A tailwind was a factor.NTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.NTSB ANC01LA054Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's failure to refuel the airplane, and subsequent fuel exhaustion. A factor in the accident was an inadvertent stall during an emergency descent/landing.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB LAX01LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Lancaster, CAThe pilot's delay reversing course while flying toward rising terrain in a box canyon. Factors in the accident included a downdraft on the lee side of a ridge forming the box canyon, high density altitude, and the pilot's improper use of flaps.NTSB FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…NTSB LAX01LA132Accident · No injuriesLimited investigationFinal reportCessna 170B · Lincoln, CAThe certified flight instructor's inadequate supervision of his dual student who used excessive braking on landing resulting in the airplane's nose over.NTSB FTW01LA075Accident · No injuriesLimited investigationFinal reportCessna 172F · Clovis, NMthe pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.NTSB DEN01LA055Accident · No injuriesLimited investigationFinal reportCessna 172F · Larkspur, COthe flight instructor inadvertently stalling the airplane during a forced landing. Contributing factors were fuel exhaustion due to inadvertent opening of the fuel drain, lack of familiarity with the airplane, inadequate supervision of the flight, and the…NTSB DEN01LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Junction, COFailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was lack of total pilot experience in aircraft make and model.NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.NTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.