Skip to content

NTSB investigations: Continental C85 series, AR

29 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.Jun 14, 2018 · N9098C · Substantial damage NTSB GAA17CA066Accident · No injuriesData collectionFinal reportLuscombe 8 · Conway, ARThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and ground loop.Nov 12, 2016 · N2604K · Substantial damage NTSB CEN13LA454Accident · No injuriesLimited investigationFinal reportCessna 140 · Jonesboro, ARThe pilot's improper flare and recovery from a bounced landing and his delay in performing an aborted landing.Jul 31, 2013 · N2745N · Substantial damage NTSB CEN11CA644Accident · No injuriesData collectionFinal reportCessna 120 · Camden, ARThe flight instructor's inadvertent braking during taxi.Sep 12, 2011 · N89954 · Substantial damage NTSB CEN10CA332Accident · No injuriesData collectionFinal reportPiper J3C-65 · Hot Springs, ARA total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.Jun 14, 2010 · N70906 · Substantial damage NTSB DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.Oct 16, 2005 · N72901 · Substantial damage NTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.Jan 26, 2004 · N1961V · Substantial damage NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.Aug 10, 2003 · N72971 · Substantial damage NTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.May 31, 2002 · N94769 · Substantial damage NTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.Aug 24, 1999 · N4526E · Substantial damage NTSB FTW99LA042Accident · Serious injuriesLimited investigationFinal reportHoliman Pietenpol Aircamper · England, ARThe pilot's failure to maintain clearance with the powerline while maneuvering.Dec 2, 1998 · N396S · Substantial damage NTSB FTW97LA341Accident · Serious injuriesLimited investigationFinal reportBurgess Skyhopper · Jonesboro, ARThe pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.Sep 6, 1997 · N4186C · Substantial damage NTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.Mar 4, 1990 · N90061 · Substantial damage NTSB MKC87LA039Accident · No injuriesLimited investigationFinal reportCessna 120 · Salem, ARThe airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure…Jan 8, 1987 · N72516 · Substantial damage NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…Jun 1, 1986 · N89247 · 2 aircraft · Destroyed NTSB FTW76DPG60Accident · No injuriesClosedPiper J5A · Gould, ARMay 29, 1976 · N35276 · Substantial damage NTSB FTW75FPG33Accident · Serious injuriesClosedAeronca 7AC · Coy, ARFeb 11, 1975 · N85238 · Substantial damage NTSB FTW75DPG32Accident · Minor injuriesClosedLuscombe 8E · Marianna, ARJan 25, 1975 · N2045K · Substantial damage NTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARAug 27, 1973 · N92830 · Substantial damage NTSB FTW73FPG42Accident · No injuriesClosedErcoupe 415-C · Rosston, ARMar 27, 1973 · N99409 · Substantial damage NTSB FTW73DPG29Accident · No injuriesClosedCessna 120 · Corning, AROct 12, 1972 · N76324 · Substantial damage NTSB FTW73DPG20Accident · No injuriesClosedCessna 120 · Lakeview, ARSep 17, 1972 · N89729 · Substantial damage NTSB FTW71FPG42Accident · No injuriesClosedCessna 120 · Van Buren, ARMar 20, 1971 · N4257N · Substantial damage NTSB FTW70F0301Accident · Minor injuriesClosedCessna 120 · Mena, ARNov 15, 1969 · N1958V · Substantial damage NTSB FTW69D0238Accident · No injuriesClosedCessna 140 · Van Buren, ARSep 18, 1968 · N89173 · Substantial damage NTSB FTW68D0581Accident · No injuriesClosedCessna 140 · Clinton, ARMay 4, 1968 · N89323 · Substantial damage NTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARAug 3, 1965 · N89234 · Substantial damage NTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARJul 7, 1965 · N88371 · Substantial damage NTSB UNK64X1762Accident · No injuriesClosedLuscombe 8E · Brinkley, ARMay 14, 1964 · N2124K · Substantial damage