NTSB investigations: Continental 0-300 series, OK
55 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 | 1 |
|---|---|
| 1965 | 6 |
| 1966 | 5 |
| 1967 | 6 |
| 1968 | 4 |
| 1971 | 4 |
| 1972 | 3 |
| 1973 | 1 |
| 1976 | 2 |
| 1978 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 2 |
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 c.\"eventStateOrRegion\" = 'OK' 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 ('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 c."eventStateOrRegion" = 'OK' 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 ('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 CEN23LA226Accident · Serious injuriesClass 3 · LimitedFinal reportTemco GC-1B · Bristow, OKThe loss of engine power due to carburetor ice due to the pilot’s delayed application of carburetor heat.NTSB CEN23FA095Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Hooker, OKThe pilot’s decision to depart and continue the visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.NTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.NTSB CEN17FA085Accident · 1 fatalField investigationFinal reportCessna 172 · Jay, OKThe pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…NTSB DFW06CA164Accident · Serious injuriesData collectionFinal reportCessna 172F · Marietta, OKThe pilot's improper weather evaluation. Contributing factors were the strong tailwind and the high density altitude.NTSB DFW06CA166Accident · No injuriesData collectionFinal reportCessna 172A · Durant, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DFW05LA067Accident · No injuriesLimited investigationFinal reportCessna 172F · Sallisaw, OKA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.NTSB FTW98LA040Accident · No injuriesLimited investigationFinal reportCessna 172G · Elk City, OKThe high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.NTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.NTSB FTW85LA334Accident · No injuriesLimited investigationFinal reportCessna 172B · Ada, OKThe student plt, who had been executing touch and go landings, stated that the acft bounced on touchdown and began porpoising. The student over-corrected and the acft subsequently impacted the runway in a nose low attitude damaging the prop, nose gear and the…NTSB FTW85LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hobart, OKAt 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the…NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB FTW82DA224Accident · No injuriesFinal reportCessna 172 · Duncan, OKThe student pilot was practicing touch-and-go landings in winds from the southeast at 10 gusting 15 KTS. Just prior to landing, the aircraft encountered a gust of wind, then touched down hard. The engine fire wall was buckled and two tires blew out.NTSB FTW82DA068Accident · No injuriesFinal reportCessna 172 · Kingfisher, OKThe student pilot stated he read the wind direction as coming from the south and landed accordingly. The aircraft landed downwind, the nose wheel dug in and collapsed, and the aircraft nosed over.NTSB FTW81FPM19Accident · Minor injuriesClosedCessna 170A · Ramona, OKNTSB FTW78DPJ14Accident · No injuriesClosedCessna 172 · Tryon, OKNTSB FTW78FPM07Accident · Minor injuriesClosedCessna 172 · Muskogee, OKNTSB FTW77FPJ01Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNTSB FTW76FPM22Accident · 1 fatalClosedCessna 172F · Jenks, OKNTSB FTW73FPJ24Accident · Serious injuriesClosedCessna 172A · Canton, OKNTSB FTW72DPM02Accident · No injuriesClosedCessna 172A · Muskogee, OKNTSB FTW72FPM31Accident · Minor injuriesClosedCessna 172D · Grove, OKNTSB FTW72DPJ31Accident · No injuriesClosedCessna 172 · Oklahoma Cty, OKNTSB FTW72FPJ10Accident · Minor injuriesClosedCessna 172H · Bethany, OKNTSB FTW72DPJ03Accident · Minor injuriesClosedCessna 172 · Watonga, OKNTSB FTW72FPJ02Accident · No injuriesClosedCessna 172 · Fort Supply, OKNTSB FTW71DPJ27Accident · Minor injuriesClosedCessna 172 · Taloga, OKNTSB FTW69D0329Accident · No injuriesClosedCessna 172 · Miami, OKNTSB FTW68A0100Accident · 1 fatalClosedCessna 172 · Purcell, OKNTSB FTW68F0509Accident · Minor injuriesClosedCessna 172 · Oklahoma Cty, OKNTSB FTW68D0506Accident · No injuriesClosedCessna 172 · Fairview, OKNTSB FTW68D0402Accident · No injuriesClosedCessna 172 · Stigler, OKNTSB FTW68F0045Accident · Minor injuriesClosedCessna 172G · Washington, OKNTSB FTW68D0015Accident · No injuriesClosedCessna 172 · Ponca City, OKNTSB FTW67D0444Accident · No injuriesClosedCessna 172 · Newkirk, OKNTSB FTW67F0441Accident · No injuriesClosedCessna 172 · Oklahoma Cy, OKNTSB FTW67D0400Accident · No injuriesClosedCessna 172 · Lawton, OKNTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNTSB FTW67D0319Accident · No injuriesClosedCessna 172 · Norman, OKNTSB FTW67D0175Accident · No injuriesClosedCessna 172 · Apache, OKNTSB FTW67F0022Accident · No injuriesClosedCessna 172F · Bethany, OKNTSB FTW66D0583Accident · Minor injuriesClosedCessna 172 · Randlett, OKNTSB FTW66D0452Accident · No injuriesClosedCessna 172 · Altus, OKNTSB FTW66D0440Accident · No injuriesClosedCessna 172 · Oklahoma City, OK