Skip to content

NTSB investigations: Continental C85 series, AL

24 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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 GAA20CA095Accident · No injuriesData collectionFinal reportCessna 120 · Marion, ALThe student pilot's overapplication of the brakes during landing to avoid a deer on the runway, which resulted in a nose-over.Oct 23, 2019 · N77200 · Substantial damage NTSB NYC08CA058Accident · No injuriesData collectionFinal reportFisher Aero Celebrity · White Plains, ALA propeller failure during cruise flight.Dec 8, 2007 · N43682 · Substantial damage NTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.Oct 31, 1998 · N99924 · Substantial damage NTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.Jan 1, 1993 · N4292N · Substantial damage NTSB ATL90LA062Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Atmore, ALFuel starvation due to an inadequate preflight and improper positioning of the fuel selector. A factor related to the accident was: rough terrain in the emergency landing area.Feb 11, 1990 · N90093 · Substantial damage NTSB ATL89LA215Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Semmes, ALImproper replacement of the fuel cap gasket by the pilot, which resulted in a blocked fuel cap vent and fuel starvation. Trees in the emergency landing area contributed to aircraft damage.Sep 17, 1989 · N83732 · Substantial damage NTSB ATL87LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Butler, ALThe student plt reported that a gust of wind 'caught' the airplane's left wing shortly after takeoff at about 100 ft AGL; he subsequently 'lost control' and the airplane 'went down'.May 8, 1987 · N8024L · Substantial damage NTSB ATL83FKJ05Accident · 2 fatalFinal reportAeronca 7BCM L-16A · Gadsden, ALThe acft collided with the ground in a 70 degree dive while taking part in an air show as a spotter plane. The acft had dropped one smoke grendade and was orbiting to drop another when it turned left and pitched down. According to an inspection guide for this…Jul 9, 1983 · N2557B · Destroyed NTSB ATL83FKJ02Accident · Serious injuriesFinal reportLuscombe 8E · Elba, ALThe plt had received a wx briefing aprx 4 hrs before departure. He stated that on arrival, the arpt beacon light was not on & patches of ground fog were in the area. During the arrival, he approached from the south, flew north over the arpt, circled to the…Jan 8, 1983 · N1860K · Substantial damage NTSB MIA78DKJ93Accident · Minor injuriesClosedErco 415-C · Cragford, ALSep 24, 1978 · N3100H · Substantial damage NTSB MIA76FKJ96Accident · Minor injuriesClosedPiper J5A · Bessemer, ALAug 23, 1976 · N38027 · Substantial damage NTSB MIA75AKJ53Accident · No injuriesClosedLuscombe 8E · Lacey Springs, ALApr 5, 1975 · N2665K · Substantial damage NTSB OAK72DVD04Accident · No injuriesClosedCessna 140 · Livermore, ALJul 12, 1972 · N2046N · Substantial damage NTSB MIA71DKJ21Accident · No injuriesClosedPiper J-3 · Hazel Green, ALOct 1, 1970 · N5555P · Substantial damage NTSB MIA70DKJ50Accident · No injuriesClosedLuscombe 8E · Saints Crsrds, ALJun 9, 1970 · N2045K · Substantial damage NTSB MIA70DKJ28Accident · No injuriesClosedPiper J-3 · Bessemer, ALApr 29, 1970 · N98453 · Substantial damage NTSB MIA70DKJ08Accident · No injuriesClosedCessna 120 · Meridianville, ALFeb 16, 1970 · N4087N · Substantial damage NTSB MIA70D0186Accident · No injuriesClosedPiper J-3 · Bay Minette, ALSep 29, 1969 · N35471 · Substantial damage NTSB MIA69D0243Accident · No injuriesClosedCessna 120 · Geneva, ALNov 24, 1968 · N90177 · Substantial damage NTSB MIA68F0543Accident · Serious injuriesClosedCessna 140 · Brownsboro, ALMay 30, 1968 · N1895V · Substantial damage NTSB MIA68A0018Accident · 1 fatalClosedPiper J3C-65 · Headland, ALAug 9, 1967 · N3419N · Destroyed NTSB MIA67D0526Accident · No injuriesClosedCessna 140 · Pisgah, ALMay 23, 1967 · N76885 · Substantial damage NTSB UNK65X1468Accident · No injuriesClosedCessna 140 · Jamison, ALMar 7, 1965 · N72207 · Substantial damage NTSB UNK64X3481Accident · Minor injuriesClosedPiper J3 · Talladega, ALAug 19, 1964 · N98023 · Destroyed