NTSB investigations: Continental GO-300 series, CO
8 cases on aircraft whose registry engine model is Continental GO-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 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2009 | 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 ('17024'))
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 ('17024'))
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 CEN09CA615Accident · No injuriesData collectionFinal reportCessna 175 · Rio Blanco, COThe pilot's failure to maintain directional control during landing and his failure to execute a go-around.NTSB DEN03LA073Accident · No injuriesLimited investigationFinal reportCessna 175A · Colo. Springs, COthe stuck open exhaust valve on the engine's number 2 cylinder, the pilot's improper preflight planning, and his failure to maintain aircraft control. Factors contributing to the accident were the low altitude flight maneuver performed, the low airspeed, the…NTSB FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.NTSB DEN89LA103Accident · Minor injuriesLimited investigationFinal reportCessna P172D · Crested Butte, COThe pilot selected a runway with unsuitable conditions for taking off. The unfavorable wind and terrain conditions were related factors.NTSB DEN78FA011Accident · 2 fatalClosedCessna 175 · Leadville, CONTSB DEN73FTE41Accident · No injuriesClosedCessna 175A · Glenwood Spg, CONTSB DEN65D0101Accident · No injuriesClosedCessna 175 · Denver, CONTSB UNK64X2881Accident · Minor injuriesClosedCessna 175A · Monte Vista, CO