NTSB investigations: Continental 0-300 series, CO
49 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 | 3 |
|---|---|
| 1965 | 3 |
| 1966 | 7 |
| 1967 | 4 |
| 1968 | 2 |
| 1969 | 4 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'CO' 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" = 'CO' 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 CEN23LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Divide, COA loss of engine power during cruise flight for reasons that could not be determined.NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB CEN15LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Routt County, COThe pilot’s intentional flight into terrain.NTSB CEN13CA200Accident · No injuriesData collectionFinal reportCessna 172 · Kremmling, COThe student pilot’s failure to maintain directional control while landing.NTSB CEN13LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Akron, COThe pilot’s physical impairment due to alcohol intoxication, which resulted in an aerodynamic stall during landing.NTSB DEN06LA036Accident · No injuriesLimited investigationFinal reportCessna 172C · Pagosa Springs, COthe pilot initiating flight into known adverse weather, and his delay in not taking remedial action sooner by not making a precautionary landing. Contributing factors include the pilot's failure to obtain preflight and in-flight weather briefings, his…NTSB DEN05LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Montrose, COthe pilot's improper in-flight planning during the descent which resulted in partial loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to select carburetor heat during the descent and unsuitable terrain for the forced…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 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 DEN00LA011Accident · No injuriesLimited investigationFinal reportCessna 172B · Englewood, COThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.NTSB FTW98LA166Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Collins, COthe pilot's improper in flight planning/decision in electing to land with a known 30 knot tailwind. Factors were high winds and a tailwind.NTSB FTW96LA362Accident · No injuriesLimited investigationFinal reportCessna 172H · Durango, COthe pilot's improper flaring of the airplane at too high an altitude, resulting in a hard landing.NTSB FTW96LA281Accident · No injuriesLimited investigationFinal reportCessna 172H · Pierce, COa loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.NTSB DEN91LA011Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, COThe failure of the pilot to flare properly during landing. The pilot's total lack of experience is a factor.NTSB DEN90LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Colorado Spgs, COThe pilot in command attempted a takeoff with the fuel mixture full rich, with a high density altitude, resulting in a partial loss of engine power during initial climb.NTSB DEN87LA095Accident · No injuriesLimited investigationFinal reportCessna 170A · Durango, COThe plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side…NTSB DEN83FTE02Accident · 1 fatalFinal reportCessna 172G · Mack, COWhile on a flt from evanston, WY to glenwood, CO, the plt encountered "cloud to ground" conditins & diverted toward grand junction, CO. He stated that due to a nav problem, he radioed grand junction tower to verify his position. Grand junction had no radar &…NTSB DEN82DA031Accident · No injuriesFinal reportCessna 172N · Broomfield, COPrior to landing, the pilot monitored the ATIS and noted that the wind was from 320 degrees at 15 knots. While on final approach for landing, he heard a radio transmission stating that the wind was gusting to 30 knots. While landing, he thought the right tire…NTSB DEN80DTE80Accident · No injuriesClosedCessna 170B · Durango, CONTSB DEN79DTE39Accident · No injuriesClosedMaule M-4 · Englewood, CONTSB DEN74FTE62Accident · No injuriesClosedMaule M4220C · Brighton, CONTSB DEN72FTE51Accident · No injuriesClosedCessna 172H · Denver, CONTSB DEN72DTE47Accident · No injuriesClosedCessna 172B · Erie, CONTSB DEN71DXD42Accident · No injuriesClosedCessna 172 · Broomfield, CONTSB DEN70D0159Accident · No injuriesClosedCessna 172 · Colorado Spg, CONTSB DEN70D0147Accident · No injuriesClosedCessna 172 · Sedalia, CONTSB DEN70D0157Accident · No injuriesClosedCessna 172 · Englewood, CONTSB DEN69D0217Accident · No injuriesClosedCessna 172 · Fort Carson, CONTSB DEN69D0150Accident · No injuriesClosedCessna 172 · Ft.Carson, CONTSB DEN68D0229Accident · No injuriesClosedCessna 172H · Fort Carson, CONTSB DEN68D0004Accident · No injuriesClosedCessna 172 · Colo.Springs, CONTSB DEN67D0254Accident · Minor injuriesClosedCessna 172 · Ft.Collins, CONTSB DEN67D0256Accident · No injuriesClosedCessna 172G · Colo.Springs, CONTSB DEN67D0222Accident · No injuriesClosedCessna 172 · Denver, CONTSB DEN67D0183Accident · No injuriesClosedCessna 172 · Aurora, CONTSB DEN67D0130Accident · No injuriesClosedCessna 172 · Denver, CONTSB DEN67F0104Accident · Minor injuriesClosedCessna 172B · Larkspur, CONTSB DEN67F0092Accident · No injuriesClosedCessna 172 · Littleton, CONTSB DEN66F0273Accident · Minor injuriesClosedCessna 172 · Pueblo, CONTSB DEN66F0272Accident · No injuriesClosedCessna 172 · Greely, CONTSB DEN66D0241Accident · No injuriesClosedCessna 172 · Nunn, CONTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CONTSB DEN66D0189Accident · No injuriesClosedCessna 170 · Montrose, CONTSB DEN66F0156Accident · No injuriesClosedCessna 172 · Usaf Academy, CONTSB UNK65X0427Accident · No injuriesClosedCessna 172 · Manzanola, CONTSB UNK64X3562Accident · No injuriesClosedCessna 172 · Colo Springs, CONTSB UNK64X0533Accident · No injuriesClosedCessna 172 · Watkins, CO