Skip to content

NTSB investigations: Continental C85 series, IA

38 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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.May 16, 2018 · N77273 · Substantial damage NTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.Jul 19, 2015 · N45508 · Substantial damage NTSB CHI04LA004Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Waterloo, IAThe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain control of the airplane while landing. A factor associated with the accident was the strong, gusty wind condition.Oct 3, 2003 · N72701 · Substantial damage NTSB CHI04LA003Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Orange City, IAThe pilot's failure to maintain obstacle clearance from the trees while manuevering at a low altitude. A factor was the trees.Oct 3, 2003 · N1909K · Destroyed NTSB CHI95LA228Accident · Serious injuriesLimited investigationFinal reportReed RS15 · Ames, IAThe glider pilot's inadequate preflight of the glider by failing to properly secure a push-pull tube to the glider's right ruddervator; and failure of both the glider pilot and the tow pilot to release the tow rope, which led to a stall of the tow airplane.Jul 18, 1995 · N964 · 2 aircraft · Destroyed NTSB CHI90LA204Accident · No injuriesLimited investigationFinal reportWhittman W-8 · Toledo, IAWrong runway selected and aborted takeoff delayed by the pilot in command.Jul 29, 1990 · N6803D · Substantial damage NTSB MKC89LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Audubon, IAThe failure of the pilot to maintain control of the airplane. Contributing to the accident were the crosswind conditions.Jan 9, 1989 · N89867 · Substantial damage NTSB MKC84LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Larchwood, IAThe acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt…May 15, 1984 · N76450 · Substantial damage NTSB MKC83FA171Accident · Serious injuriesField investigationFinal reportAeronca 11CC · Orange City, IAThe aircraft had completed a landing in a field and the pilot was attempting a takeoff from the stopping point. The aircraft did not become airborne and ran for aprx 100 feet across a boggy swamp and impacted a four foot high dirt bank.Jul 31, 1983 · N4368E · Substantial damage NTSB MKC83LA101Accident · No injuriesLimited investigationFinal reportCessna C-140 · Mt. Pleasant, IAThe pilot stated he did not make a visual check of his fuel supply prior to flight. After a 45 minute solo flight he landed at a private strip and picked up a passenger. The right fuel tank was selected and the guage was indicating in the lower red 1/4 red,…Apr 30, 1983 · N77090 · Substantial damage NTSB MKC81FCD01Accident · Minor injuriesClosedCessna 120 · La Porte City, IANov 22, 1980 · N77351 · Substantial damage NTSB MKC79DCD34Accident · No injuriesClosedLuscombe 8E · Oskaloosa, IAAug 28, 1979 · N2518K · Substantial damage NTSB MKC78FCD44Accident · Serious injuriesClosedAeronca 7BCM · Toledo, IAAug 16, 1978 · N83659 · Destroyed NTSB MKC76DCD57Accident · No injuriesClosedCessna 170B · Salix, IAJul 18, 1976 · N1856C · Substantial damage NTSB MKC75FCD35Accident · Minor injuriesClosedCessna 120 · Dallas Center, IAFeb 22, 1975 · N2279N · Substantial damage NTSB MKC74FCD39Accident · No injuriesClosedCessna 120 · Hampton, IAJun 14, 1974 · N1883N · Substantial damage NTSB MKC73DCD60Accident · No injuriesClosedCessna 120 · Councl Bluff, IAMay 5, 1973 · N3089N · Substantial damage NTSB MKC73DCD06Accident · No injuriesClosedCessna 140 · Toledo, IAJul 23, 1972 · N1859V · Substantial damage NTSB MKC72FCD64Accident · No injuriesClosedLuscombe 8E · Adel, IAMar 25, 1972 · N1306B · Substantial damage NTSB MKC72DCD43Accident · Minor injuriesClosedCessna 140 · Mapleton, IANov 6, 1971 · N89093 · Substantial damage NTSB MKC72FCD35Accident · Serious injuriesClosedLuscombe 8E · Osage, IAOct 2, 1971 · N1971K · Destroyed NTSB MKC71DCD15Accident · No injuriesClosedLuscombe 8E · Independence, IAJul 19, 1970 · N2680K · Substantial damage NTSB MKC71DCD22Accident · No injuriesClosedCessna 120 · Gravity, IAMay 3, 1970 · N76806 · Substantial damage NTSB MKC70F0303Accident · No injuriesClosedCessna 140 · Newton, IADec 19, 1969 · N72363 · Substantial damage NTSB MKC70A0014Accident · 2 fatalClosedCessna 140 · Hartley, IAOct 1, 1969 · N1984V · Destroyed NTSB MKC68D0593Accident · No injuriesClosedCessna 120 · Dallas Ctr., IAMay 21, 1968 · N72715 · Substantial damage NTSB MKC68D0049Accident · Minor injuriesClosedErco 415-C · Clarinda, IAJul 9, 1967 · N3469H · Substantial damage NTSB MKC67D0590Accident · No injuriesClosedLuscombe 8E · Creston, IAMay 16, 1967 · N1977K · Substantial damage NTSB MKC67D0523Accident · No injuriesClosedErcoupe 415-C · Jefferson, IAMar 16, 1967 · N93667 · Substantial damage NTSB MKC67D0395Accident · No injuriesClosedCessna 120 · Marion, IADec 31, 1966 · N2672N · Substantial damage NTSB MKC67D0187Accident · No injuriesClosedErcoupe 415C · Knoxville, IAJul 23, 1966 · N87331 · Substantial damage NTSB MKC67D0084Accident · No injuriesClosedErcoupe 415C · Rockwell Cty, IAJul 16, 1966 · N3469H · Substantial damage NTSB MKC67D0031Accident · No injuriesClosedPiper PA-11 · Stratford, IAApr 26, 1966 · N4688M · Substantial damage NTSB MKC66D0385Accident · No injuriesClosedCessna 120 · Des Moines, IAJan 9, 1966 · N72715 · Substantial damage NTSB MKC65D0138Accident · No injuriesClosedLuscombe 8A · Creston, IAMar 12, 1965 · N1990B · Substantial damage NTSB MKC65D0046Accident · No injuriesClosedCessna 140 · Davenport, IAMar 6, 1965 · N2733N · Substantial damage NTSB UNK64X3103Accident · No injuriesClosedCessna 120 · Laporte City, IAJul 29, 1964 · N2081V · Substantial damage NTSB UNK64X1905Accident · No injuriesClosedCessna 140 · Marion, IAMay 23, 1964 · N81030 · Substantial damage