Skip to content

NTSB investigations: Continental C85 series, NC

34 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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA21LA265Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11CC · Jefferson, NCThe pilot’s failure to maintain directional control upon landing.Jun 23, 2021 · N4134E · Substantial damage NTSB GAA18CA027Accident · No injuriesData collectionFinal reportCessna 120 · New Bern, NCThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.Oct 21, 2017 · N72552 · Substantial damage NTSB GAA16CA304Accident · No injuriesData collectionFinal reportCessna 120 · Climax, NCAn evasive maneuver during the landing roll to avoid deer on the runway, which resulted in a runway excursion and a nose over. Contributing to the accident was the lack of an airport perimeter fence.Jun 10, 2016 · N77216 · Substantial damage NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.Dec 13, 2015 · N1316V · Substantial damage NTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.Mar 6, 2012 · N5693C · Substantial damage NTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.May 3, 2011 · N1902K · Substantial damage NTSB MIA02LA021Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Southern Pines, NCThe dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.Nov 18, 2001 · N99236 · Substantial damage NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.Nov 24, 1996 · N1378K · Substantial damage NTSB ATL94LA170Accident · 1 fatalLimited investigationFinal reportPiper J-5A · Raeford, NCThe pilot's ostentatious display which resulted in a loss of control of the airplane.Sep 8, 1994 · N31172 · Destroyed NTSB ATL92LA094Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Wilmington, NCThe pilot's failure to obtain proper assistance during the engine starting procedure, and his failure to properly attend to the airplane with the engine running.May 3, 1992 · N72973 · Substantial damage NTSB ATL92LA027Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Statesville, NCLoss of engine power for undetermined reasons. A factor was the lack of a suitable landing site.Nov 28, 1991 · N35535 · Substantial damage NTSB ATL87FA001Accident · 3 fatalField investigationFinal reportPiper J3-65C · Goldsboro, NCThe J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The…Oct 5, 1986 · N70414 · 2 aircraft · Destroyed NTSB ATL81DKM01Accident · No injuriesClosedBaby GR LKS 1 · Greensboro, NCDec 7, 1980 · N66JM · Substantial damage NTSB ATL80DKM17Accident · No injuriesClosedAeronca 7BCM · Greensboro, NCMay 1, 1980 · N2KT · Substantial damage NTSB IAD75DKM21Accident · No injuriesClosedCessna 120 · Advance, NCMar 15, 1975 · N3748V · Substantial damage NTSB IAD75FLJ09Accident · Minor injuriesClosedCessna 140 · Angier, NCAug 23, 1974 · N2685N · Substantial damage NTSB IAD74DKM18Accident · No injuriesClosedCessna 140 · Greensboro, NCSep 3, 1973 · N2652N · Substantial damage NTSB IAD74DKM07Accident · No injuriesClosedAeronca 7BCM · Charlotte, NCJul 29, 1973 · N75367 · Substantial damage NTSB IAD73DKM27Accident · No injuriesClosedMcclish C · Asheville, NCMar 20, 1973 · N81136 · Substantial damage NTSB NYC72FLJ29Accident · No injuriesClosedLuscombe 8E · Kinston, NCApr 5, 1972 · N1558B · Substantial damage NTSB IAD71FLJ08Accident · No injuriesClosedCessna 140A · Jacksonville, NCAug 2, 1970 · N72979 · Substantial damage NTSB IAD70DLJ02Accident · No injuriesClosedCessna 120 · Chadbourne, NCMay 8, 1970 · N4071N · Substantial damage NTSB IAD70A0011Accident · 1 fatalClosedCessna 120 · Spruce Pine, NCAug 1, 1969 · N90109 · Destroyed NTSB DIA69F0054Accident · No injuriesClosedAeronca 7BCM · Charlotte, NCAug 30, 1968 · N75367 · Substantial damage NTSB DIA67D0056Accident · No injuriesClosedCommonwlth 185 · Boone, NCMar 12, 1967 · N34130 · Substantial damage NTSB MIA67F0199Accident · No injuriesClosedCessna 120 · Morganton, NCOct 8, 1966 · N4003N · Substantial damage NTSB MIA67D0051Accident · No injuriesClosedCessna 140 · Statesville, NCMay 14, 1966 · N3156N · Substantial damage NTSB MIA66F0424Accident · Minor injuriesClosedLuscombe 8A · Raleigh, NCFeb 6, 1966 · N1331B · Substantial damage NTSB MIA66F0280Accident · Minor injuriesClosedCessna 140 · Shelby, NCOct 27, 1965 · N76477 · Substantial damage NTSB IAD75AI030Accident · 1 fatalClosedCessna 120 · Black Mountain, NCSep 3, 1965 · N76173 · Destroyed NTSB MIA66D0054Accident · No injuriesClosedCessna 140 · Franklin, NCMay 31, 1965 · N90170 · Substantial damage NTSB UNK65X1425Accident · No injuriesClosedCessna 120 · Vanceboro, NCFeb 15, 1965 · N72368 · Destroyed NTSB UNK64X1877Accident · No injuriesClosedPiper PA11 · Franklin, NCMay 22, 1964 · N4902M · Substantial damage NTSB UNK64X1827Accident · Minor injuriesClosedPiper J3 · Clinton, NCMay 18, 1964 · N70729 · Substantial damage