Skip to content

NTSB investigations: Continental C85 series, UT

23 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

19652026

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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jun 1, 2019 · N2689K · Substantial damage NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.Apr 5, 2017 · N81173 · Substantial damage NTSB WPR10CA043Accident · Minor injuriesData collectionFinal reportCessna 120 · Mineral Canyon, UTThe pilot's incorrect use of brakes, which resulted in the airplane nosing over.Nov 1, 2009 · N2729N · Substantial damage NTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.Feb 9, 2008 · N72957 · Substantial damage NTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.Jan 20, 2008 · N71730 · Substantial damage NTSB SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.May 18, 2007 · N3007G · Substantial damage NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.Mar 9, 2001 · N1121J · Substantial damage NTSB DEN01LA068Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Morgan, UTthe pilot's failure to maintain directional control during landing roll which resulted in a collision with a snow bank on the edge of the runway.Mar 7, 2001 · N42523 · Substantial damage NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.Mar 15, 1995 · N3605V · Substantial damage NTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.Apr 13, 1994 · N2728K · Substantial damage NTSB SEA94LA046Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Manila, UTThe pilot's failure to maintain clearance. Factors include a tailwind, gusts, and a tree just off the departure end of the field used for takeoff.Jan 2, 1994 · N4244A · Substantial damage NTSB SEA92LA217Accident · No injuriesLimited investigationFinal reportCessna 140 · Moab, UTThe loss of engine power due to fuel exhaustion resulting from inaccurate fuel consumption calculations by the pilot. A factor relating to the accident was the terrain condition (ditch) in the landing area.Sep 25, 1992 · N2553N · Substantial damage NTSB DEN88LA130Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · West Jordon, UTJun 15, 1988 · N70471 · Substantial damage NTSB DEN83FA203Accident · 2 fatalField investigationFinal reportCessna 140A · Sevier, UTThe flt was returning to san jose,CA after an extended x-country flt to oshkosh,WI which began in the latter part of July. Earlier on the day of the accident, at 0645, the plt received a wx briefing at miles city,MT. He requested the general outlook to the…Aug 11, 1983 · N5301C · Destroyed NTSB DEN83FTM02Accident · 2 fatalFinal reportPiper J3C-65 · Near Holden, UTThe student pilot and his wife had flown from salt lake city to Holden, UT. According to his father, the plane crashed in an open field while the pilot was flying low and looking for a place to land. The plane crashed in an open grain field in about a 15 deg…Nov 6, 1982 · N67084 · Substantial damage NTSB DEN82FTM01Accident · No injuriesClosedCessna 140 · Ogden, UTNov 1, 1981 · N2347N · Substantial damage NTSB DEN77DTC24Accident · Minor injuriesClosedLuscombe 8F · Dutch John, UTAug 6, 1977 · N1341B · Substantial damage NTSB DEN76FTM12Accident · No injuriesClosedErco 415-C · Heber, UTApr 11, 1976 · N2335H · Substantial damage NTSB DEN70D0149Accident · No injuriesClosedAeronca 7BCM · Vernal, UTDec 7, 1969 · N68588 · 2 aircraft · Substantial damage NTSB DEN70D0054Accident · No injuriesClosedAeronca 7AC · Woods Cross, UTAug 5, 1969 · N81973 · Substantial damage NTSB DEN67D0266Accident · No injuriesClosedCessna 140 · Milford, UTMar 26, 1967 · N6321D · Substantial damage NTSB DEN67D0186Accident · Minor injuriesClosedAeronca 7AC · Layton, UTDec 16, 1966 · N81973 · Substantial damage NTSB DEN65F0023Accident · No injuriesClosedErcoupe 415C · Colton, UTFeb 11, 1965 · N2798H · Substantial damage