Skip to content

NTSB investigations: Continental C85 series, SC

22 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'SC' 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

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\" = 'SC' 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" = 'SC' 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

Run 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 ERA13CA208Accident · No injuriesData collectionFinal reportCessna 140 · Lancaster, SCThe pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.Apr 18, 2013 · N76688 · Substantial damage NTSB ERA11CA097Accident · No injuriesData collectionFinal reportCessna 140 · Winnsboro, SCThe excessive brake inputs by both pilots during the landing roll resulting in the airplane nosing over.Dec 24, 2010 · N76831 · Substantial damage NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.Mar 29, 2006 · N76688 · Substantial damage NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.Jun 16, 2005 · N37GH · Substantial damage NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…Mar 20, 1988 · N2233N · Substantial damage NTSB ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…Oct 18, 1987 · N98806 · Substantial damage NTSB ATL85LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Saluda, SCThe plt attempted a takeoff with the carb heat in the 'on' position. According to the plt, during initial climb the acft lost power and he was unable to maintain altitude. The plt made a forced landing in a pasture about 1 mi. From the airport.Apr 19, 1985 · N1819V · Substantial damage NTSB ATL80FLG11Accident · Minor injuriesClosedCessna 120 · Union, SCMay 31, 1980 · N72812 · Substantial damage NTSB MIA80FA010Accident · 2 fatalClosedErco 415-C · Bishopville, SCNov 18, 1979 · N99484 · Destroyed NTSB MIA75DLG25Accident · Minor injuriesClosedCessna 140 · Manning, SCMar 2, 1975 · N76371 · Substantial damage NTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCAug 25, 1973 · N7001H · Substantial damage NTSB MIA73FLG31Accident · No injuriesClosedErco 415-C · Inman, SCDec 30, 1972 · N99543 · Substantial damage NTSB MIA73DLG30Accident · No injuriesClosedCessna 140 · N Myrtle Beach, SCDec 27, 1972 · N72137 · Substantial damage NTSB MIA73FLG06Accident · No injuriesClosedPiper J3C · Cades, SCJul 18, 1972 · N77549 · Substantial damage NTSB MIA71DLG23Accident · No injuriesClosedPiper J-5A · Georgetown, SCMar 14, 1971 · N31172 · Substantial damage NTSB MIA70D0056Accident · No injuriesClosedLuscombe 8E · Aiken, SCJun 16, 1969 · N1607K · Substantial damage NTSB MIA69F0337Accident · No injuriesClosedCessna 120 · Kingstree, SCJan 18, 1969 · N1803N · Substantial damage NTSB MIA69F0249Accident · No injuriesClosedEaa Biplane PF · St.George, SCOct 13, 1968 · N155F · Substantial damage NTSB MIA68D0204Accident · No injuriesClosedLuscombe 8E · Lancaster, SCJun 10, 1967 · N2424K · Substantial damage NTSB MIA68F0207Accident · No injuriesClosedErco 415-D · Pamplico, SCMay 28, 1967 · N99642 · Substantial damage NTSB MIA67F0052Accident · Serious injuriesClosedCessna 140 · Beaufort, SCMay 18, 1966 · N73023 · Substantial damage NTSB UNK64X0443Accident · No injuriesClosedLuscombe 8E · Pontiac, SCFeb 2, 1964 · N1815K · Substantial damage