NTSB investigations: Continental C85 series, CT
18 cases on aircraft whose registry engine model is Continental C85 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 | 2 |
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 3 |
| 1973 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1986 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2025 | 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\" = 'CT' 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 ('17008'))
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" = 'CT' 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 ('17008'))
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 ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.NTSB ERA11CA017Accident · No injuriesData collectionFinal reportCessna 120 · Falls Village, CTThe pilot’s failure to abort the takeoff, which resulted in an in-flight collision with terrain.NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB NYC98LA120Accident · No injuriesLimited investigationFinal reportCessna 140 · Madison, CTThe pilot's improper in-flight decision to continue the landing and his delayed go-around attempt. A factor in this accident was the pilot's diverted attention.NTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage.NTSB NYC79FNE19Accident · No injuriesClosedLuscombe 8E · Plainville, CTNTSB NYC77FNE24Accident · No injuriesClosedCessna 120 · Woodbridge, CTNTSB NYC76FNE01Accident · Minor injuriesClosedPiper J-3 · Canaan, CTNTSB NYC74FNE10Accident · No injuriesClosedCessna 140 · Simsbury, CTNTSB NYC74AN021Accident · 2 fatalClosedAeronca S11AC · New Milford, CTNTSB NYC72FNE17Accident · No injuriesClosedCommonwlth 185 · Middlebury, CTNTSB NYC72FNE15Accident · No injuriesClosedAeronca 7DC · Oxford, CTNTSB NYC72FNE04Accident · No injuriesClosedCessna 140 · Meriden, CTNTSB NYC68A0127Accident · 1 fatalClosedCessna 140 · Woodstock, CTNTSB NYC67D0171Accident · No injuriesClosedPiper PA-17 · Burlington, CTNTSB NYC66F0056Accident · Minor injuriesClosedMiniplane DSA-1 · New Haven, CTNTSB UNK65X1332Accident · No injuriesClosedCommonwlth 185 · Meriden, CTNTSB UNK64X2698Accident · No injuriesClosedAeronca L16 · Meriden, CT