Skip to content

NTSB investigations: Continental C85 series, MA

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 GAA17CA156Accident · No injuriesData collectionFinal reportCessna 120 · Orange, MAThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.Feb 24, 2017 · N77116 · Substantial damage NTSB ERA12CA118Accident · No injuriesData collectionFinal reportCessna 120 · Montague, MAThe pilot's delay in performing a rejected takeoff after experiencing an intermittent loss of engine power, which resulted in a runway excursion.Dec 17, 2011 · N89809 · Substantial damage NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.Mar 19, 2011 · N2790K · Substantial damage NTSB BFO92LA147Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, MAThe pilot's abrupt application of the brakes which resulted in the airplane nosing over.Sep 13, 1992 · N1216B · Substantial damage NTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.Mar 31, 1992 · N3047N · Substantial damage NTSB NYC90LA208Accident · No injuriesLimited investigationFinal reportPiper J5 CUB · Douglas, MAA total engine failure when the #3 exhaust valve failed, causing internal damage to the engine. Factors related to the accident were: the pilot had to make a forced landing in unsuitable terrain.Aug 31, 1990 · N38428 · Substantial damage NTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…Aug 10, 1988 · N2232K · Substantial damage NTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.Mar 20, 1986 · N2643N · Substantial damage NTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…Apr 9, 1983 · N26182 · Substantial damage NTSB NYC82DA144Accident · Minor injuriesFinal reportErcoupe 415-C · Mansfield, MAWitnesses reported that the aircraft bounced during touchdown and began porpoising. After bouncing 4 or 5 times, the nose tire blew out. Subsequently, the aircraft vee ed off the runway and nosed over.Jul 3, 1982 · N93358 · Substantial damage NTSB NYC78FNE25Accident · Serious injuriesClosedCessna 140 · Oxford, MAJul 8, 1978 · N90136 · Substantial damage NTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MAJul 20, 1976 · N72708 · Substantial damage NTSB NYC76DNA25Accident · No injuriesClosedErco 415-C · Tauton, MAJan 10, 1976 · N99494 · Substantial damage NTSB NYC76AN029Accident · No injuriesClosedCessna 150 · Fitchburg, MAAug 28, 1975 · N3888V · 2 aircraft · Substantial damage NTSB NYC75FNA40Accident · No injuriesClosedSmith Mini · Hyannis, MAMay 22, 1975 · N18B · Substantial damage NTSB NYC75FNE31Accident · No injuriesClosedFunk B-85C · Westboro, MAMar 18, 1975 · N77703 · Substantial damage NTSB NYC74FNA31Accident · Serious injuriesClosedPiper J5A · Westford, MAJan 6, 1974 · N30313 · Substantial damage NTSB NYC72FNA20Accident · 1 fatalClosedPiper J3C-65 · Haverhill, MANov 13, 1971 · N3406K · Destroyed NTSB NYC71DFD19Accident · No injuriesClosedAeronca 7AC · S.Middleboro, MAOct 25, 1970 · N83457 · Substantial damage NTSB NYC70DFD13Accident · No injuriesClosedCessna 140 · Marlboro, MAMay 2, 1970 · N2002N · Substantial damage NTSB NYC70D0079Accident · No injuriesClosedAeronca 11BC · Hopedale, MAJul 31, 1969 · N85817 · Substantial damage NTSB NYC69F0379Accident · Minor injuriesClosedAeronca 11BC · Shutesbury, MAMar 1, 1969 · N85875 · Substantial damage NTSB NYC69D0159Accident · No injuriesClosedAeronca L-16A · Turners Fall, MAAug 31, 1968 · N1317V · Substantial damage NTSB NYC68F0470Accident · No injuriesClosedCessna 140 · Norwood, MAMay 3, 1968 · N72827 · Substantial damage NTSB NYC68D0462Accident · No injuriesClosedTaylorcraft BC12D1 · Mansfield, MAApr 28, 1968 · N44184 · Substantial damage NTSB NYC67D0627Accident · No injuriesClosedAeronca L-16 · Newburyport, MAMar 25, 1967 · N1121 · Substantial damage NTSB NYC67D0264Accident · No injuriesClosedAeronca 7BCM · Charlton City, MASep 17, 1966 · N1143V · Substantial damage NTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damage NTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MAJun 3, 1965 · N186CM · Minor damage NTSB OAK65F0006Accident · No injuriesClosedCessna 120 · Quincy Calif, MAFeb 6, 1965 · N2983N · Substantial damage NTSB UNK65X1216Accident · No injuriesClosedCessna 140 · Millbury, MAJan 2, 1965 · N90136 · Substantial damage NTSB UNK64X1660Accident · 1 fatalClosedAeronca 7BCM · Truro Beach, MAMay 7, 1964 · N1145V · Destroyed NTSB UNK64X1258Accident · No injuriesClosedCessna 140A · Marlboro, MAApr 11, 1964 · N89489 · Substantial damage NTSB UNK64X1026Accident · 1 fatalClosedCessna 140 · Westboro, MAMar 23, 1964 · N76660 · Destroyed