Skip to content

NTSB investigations: Continental C85 series, ID

27 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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.Jul 24, 2021 · N946PD · Substantial damage NTSB WPR18LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Marsing, IDThe loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.Aug 14, 2018 · N89093 · Substantial damage NTSB WPR17LA122Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Rexberg, IDA loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.Jun 3, 2017 · N1627K · Substantial damage NTSB WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damage NTSB WPR09CA058Accident · No injuriesData collectionFinal reportCessna 140 · Preston, IDThe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a loss of control and subsequent nose over.Dec 17, 2008 · N4008N · Substantial damage NTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.Jun 29, 2008 · N83056 · Substantial damage NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.May 5, 2005 · N77377 · Substantial damage NTSB SEA00LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Arco, IDThe pilot's inadequate compensation for the wind condition. Wind gust was a factor.Sep 13, 2000 · N2007V · Substantial damage NTSB SEA99LA170Accident · No injuriesLimited investigationFinal reportChampion 7BCM · Coolin, IDThe pilot's failure to adequately compensate for wind conditions. Factors include variable, gusty crosswinds, and trees along the sides of the runway.Sep 19, 1999 · N2841E · Substantial damage NTSB SEA99LA036Accident · No injuriesLimited investigationFinal reportPiper J-5A · Rexburg, IDThe pilot's failure to maintain clearance from power lines.Feb 20, 1999 · N28123 · Substantial damage NTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.Sep 4, 1996 · N2595N · Substantial damage NTSB SEA96FA185Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Marsing, IDloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with terrain.Aug 11, 1996 · N2836E · Substantial damage NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.Oct 14, 1991 · N11XP · Substantial damage NTSB SEA91LA242Accident · Serious injuriesLimited investigationFinal reportAeronca 7DC · Yellow Pine, IDImproper inflight planning/decision by the pilot, which resulted in inadvertent flight into a box canyon and subsequent collision with trees, when there was insufficient space to reverse course and the aircraft would not outclimb rising terrain. The terrain…Sep 17, 1991 · N9654H · Destroyed NTSB SEA83LA085Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Blanchard, IDThe aircraft collided with a fence during landing on a narrow strip in a variable crosswind. The pilot had taken off from the same airstrip earlier without difficulty. He said a strong gust of wind struck his aircraft as it was touching down. This displaced…Apr 16, 1983 · N4049E · Substantial damage NTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDAug 30, 1973 · N76057 · Substantial damage NTSB SEA73FYG22Accident · Minor injuriesClosedCessna 120 · Sandpoint, IDJan 23, 1973 · N2074V · Destroyed NTSB SEA72DYA10Accident · No injuriesClosedAeronca 7BCM · Boise, IDAug 27, 1971 · N6057C · Substantial damage NTSB SEA70D0101Accident · No injuriesClosedCessna 140 · Eagle, IDOct 23, 1969 · N89290 · Destroyed NTSB SEA69D0222Accident · No injuriesClosedCessna 140 · Idaho Falls, IDApr 22, 1969 · N1926V · Substantial damage NTSB SEA69D0139Accident · No injuriesClosedCessna 120 · Cataldo, IDNov 9, 1968 · N2439N · Substantial damage NTSB SEA69D0038Accident · No injuriesClosedErcoupe 415-C · Nampa, IDJul 20, 1968 · N87283 · Substantial damage NTSB SEA67D0164Accident · Minor injuriesClosedAeronca 7AC · Twin Falls, IDOct 29, 1966 · N3085E · Substantial damage NTSB SEA66D0269Accident · No injuriesClosedCessna 120 · Boise, IDMay 10, 1966 · N76892 · Substantial damage NTSB UNK64X3084Accident · No injuriesClosedCessna 140 · Weiser, IDJul 28, 1964 · N2370V · Substantial damage NTSB UNK64X2128Accident · No injuriesClosedCessna 140 · Boise, IDJun 5, 1964 · N76680 · Substantial damage NTSB UNK64X1903Accident · No injuriesClosedAeronca 7BCM · Idaho City, IDMay 23, 1964 · N6057C · Substantial damage