Skip to content

Final NTSB investigations: Continental C85 series, ND

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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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 CEN13CA345Accident · Minor injuriesData collectionFinal reportCessna 140 · Minot, NDThe pilot's failure to maintain aircraft control during takeoff.Jun 7, 2013 · N2054V · Substantial damage NTSB CHI03LA139Accident · No injuriesLimited investigationFinal reportErcoupe 415E · Manvel, NDThe pilot's improper flare and inadequate recovery from a bounced landing. A factor contributing to the accident was the collapse of the nose landing gear strut.May 29, 2003 · N94779 · Substantial damage NTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.Jun 27, 1998 · N6035V · Substantial damage NTSB CHI97LA101Accident · Serious injuriesLimited investigationFinal reportAeronca 7CCM · Carson, NDa loss of engine power due to ice in the fuel line. A factor was inadequate maintenance and inspection.Apr 9, 1997 · N85257 · Substantial damage NTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.Aug 14, 1994 · N2501K · Substantial damage NTSB DEN88LA017Accident · No injuriesLimited investigationFinal reportPiper J5A · Devils Lake, NDA commercial plt was giving instruction to another commercial plt with a CFI rating. Witnesses observed the aircraft at approximately 100 feet over a water fowl production lake. The plt stated that during a turn and pull up, the engine lostpower and the…Oct 31, 1987 · N32887 · Substantial damage NTSB DEN85LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oaks, NDPlt stated that immediately after touchdown, the right wheel seemed to drag. Right drift was initially corrected by use of opposite aileron to reduce weight on right wheel and rudder for directional control. However, as the acft slowed weight settled on the…Nov 22, 1984 · N2759K · Substantial damage NTSB DEN84LA015Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oakes, NDAfter a brief stop at oaks, ND, for fuel, the plt took off to fly about 5 mi to his private strip in an alfalfa field. During the landing roll, the gear hit a gopher mound & the acft nosed over.Oct 25, 1983 · N2759K · Substantial damage NTSB MKC79DTG15Accident · Minor injuriesClosedCommonwlth 185 · Bottineau, NDAug 26, 1979 · N73825 · Substantial damage NTSB MKC76DTG08Accident · No injuriesClosedPiper J-3 · Rolette, NDSep 25, 1975 · N3393N · Substantial damage NTSB MKC73DTG02Accident · No injuriesClosedCessna 120 · Kindred, NDJul 22, 1972 · N2510N · Substantial damage NTSB MKC71DDD19Accident · No injuriesClosedPiper J3C-65 · Crosby, NDFeb 16, 1971 · N25835 · Destroyed NTSB MKC70DDD24Accident · No injuriesClosedCessna 120 · Crary, NDJun 6, 1970 · N2908N · Substantial damage NTSB MKC70D0196Accident · No injuriesClosedCessna 120 · Valley City, NDSep 3, 1969 · N2533N · Substantial damage NTSB MKC69D0337Accident · No injuriesClosedPiper J-3 · Stanley, NDFeb 13, 1969 · N38948 · Substantial damage NTSB MKC69D0335Accident · No injuriesClosedPiper PA-11 · Velva, NDDec 28, 1968 · N78816 · Substantial damage NTSB MKC69D0228Accident · No injuriesClosedAeronca 11BC · Manfred, NDAug 11, 1968 · N4029E · Substantial damage NTSB MKC69F0127Accident · No injuriesClosedCessna 140 · Foxholm, NDJul 22, 1968 · N76579 · Substantial damage NTSB MKC68D0116Accident · No injuriesClosedCessna 140 · Rutland, NDJul 10, 1967 · N81065 · Substantial damage NTSB MKC67F0492Accident · No injuriesClosedErcoupe 415C · Devils Lake, NDMar 26, 1967 · N2850H · Substantial damage NTSB MKC67D0203Accident · No injuriesClosedErcoupe 415-C · Langdon, NDSep 8, 1966 · N93364 · Substantial damage NTSB MKC66F0374Accident · No injuriesClosedCessna 120 · Grand Forks, NDDec 5, 1965 · N76219 · Substantial damage NTSB MKC66F0255Accident · No injuriesClosedCessna 140 · Michigan, NDSep 19, 1965 · N89525 · Substantial damage NTSB MKC66F0218Accident · No injuriesClosedCessna 140 · Grand Forks, NDAug 21, 1965 · N2302N · Substantial damage NTSB MKC65F3003Accident · No injuriesClosedCessna 120 · Harvey, NDJan 16, 1965 · N76770 · Substantial damage NTSB UNK65X0295Accident · No injuriesClosedCessna 140 · Edgely, NDOct 16, 1964 · N72307 · Substantial damage NTSB UNK64X4124Accident · No injuriesClosedCessna 140A · Milnor, NDSep 24, 1964 · N5381C · Substantial damage