Skip to content

NTSB investigations: Continental C85 series, TX

155 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, newest first

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 FTW92LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Acton, TXThe excessive airspeed during the landing. Factors were the carburetor icing conditions, the carburetor ice induced power loss, and the pilot's delayed use of carburetor heat.Apr 17, 1992 · N2430K · Substantial damage NTSB FTW91DRG01Accident · 1 fatalFinal reportTaylor Titch MK III · Seguin, TXThe pilot lost control at low level. Factors were the pilot attempting aerobatic maneuvers with insuffient altitude for recovery.Nov 17, 1990 · N14D · Destroyed NTSB FTW90LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Fabens, TXInadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…Jun 20, 1990 · N76728 · 2 aircraft · Substantial damage NTSB FTW90DRG01Accident · Serious injuriesFinal reportFunk, D.D. B85C · San Antonio, TXFailure of the pilot to maintain airspeed, which resulted in a stall. The unfavorable/gusty wind condition was a related factor.Oct 26, 1989 · N77707 · Substantial damage NTSB FTW88LA095Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Pipe Creek, TXShortly after takeoff, the engine started running rough. The pilot said he thought he could make the airport and turned toward it. Just short of the airport, the engine quit completely. The pilot was able to get to the airport but crossways to the runway.…May 2, 1988 · N80799 · Substantial damage NTSB FTW88FA024Accident · Serious injuriesField investigationFinal reportCessna 140 · Bryan, TXThe student plt took off at ngt with a passenger aboard. After takeoff, he remained in a left traffic pattern & made a low apch. Witnesses rprtd the plt then entered a rgt pattern, but the acft was lower & slower than normal as it was turning on the 2nd apch…Nov 8, 1987 · N72137 · Destroyed NTSB FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.May 24, 1987 · N111NZ · Substantial damage NTSB FTW85FA245Accident · 1 fatalField investigationFinal reportCessna 140 · Tioga, TXWitnesses observed the acft apchg from the northwest at an estimated alt of about 100 ft AGL. As it passed their position, the plt rolled into a steep (90 deg) right bank, then roll back out. The witnesses reported that after the acft rolled out of the bank,…Jun 4, 1985 · N3180N · Destroyed NTSB FTW84LA392Accident · No injuriesLimited investigationFinal reportCessna 140 · Liverpool, TXAt aprx 900 ft AGL the eng lost power and the plt executed a forced landing in the unimproved terrain. At touchdown the acft struck trees and a dirt enbankment nosing over inverted. Investigation revealed water in the gascolator as well as the left fuel tank.…Sep 13, 1984 · N89318 · Destroyed NTSB FTW84LA252Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Port Aransas, TXPlt stated an engine miss was experienced. Plt elected a precautionary landing on the beach during which main gear dug into sand and acft nosed over. During a helicopter recovery the acft was jettisoned from aprx 500 ft AGL. Impact damage resulting from the…May 28, 1984 · N27582 · Substantial damage NTSB FTW84LA181Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Fort Worth, TXThe plt lost directional control of the acft during landing roll & collided with 2 parked acft. The pilot stated that immediately upon runway contact the acft veered to the right toward the parked acft. He applied half throttle & full left rudder. Directional…Apr 1, 1984 · N26336 · Substantial damage NTSB FTW84LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Longview, TXThe plt landed in an rough surface overrun area marked by painted tires as unusable. The right main gear collapsed after touchdown and the acft slid to a stop. The plt said he did not see the tires marking the overrun until after the accident.Feb 25, 1984 · N2491N · Substantial damage NTSB FTW84LA117Accident · No injuriesLimited investigationFinal reportCessna 120 · Jayton, TXThe acft nosed over during landing. The plt said he was trying to correct a veer in the tail wheel acft and may have inadvertantly used the right brake.Jan 12, 1984 · N3014N · Substantial damage NTSB FTW81DPA16Accident · No injuriesClosedCessna 140 · Waco, TXAug 14, 1981 · N89691 · Substantial damage NTSB FTW81DRG38Accident · No injuriesClosedCessna 140 · Freer, TXMay 17, 1981 · N89062 · Substantial damage NTSB FTW81DA060Accident · No injuriesClosedPiper PA-25 · Kilgore, TXMar 29, 1981 · N6337Z · 2 aircraft · Substantial damage NTSB FTW81FQG19Accident · No injuriesClosedCessna 140 · Ozona, TXMar 7, 1981 · N77079 · Substantial damage NTSB FTW81FQG10Accident · No injuriesClosedCessna 140 · Canyon, TXJan 30, 1981 · N71U · Substantial damage NTSB FTW80FPD07Accident · No injuriesClosedCessna 120 · Lawn, TXDec 22, 1979 · N44BM · Substantial damage NTSB FTW79FPD37Accident · No injuriesClosedCessna 140 · Wichita Falls, TXAug 22, 1979 · N89445 · Substantial damage NTSB FTW79DPA01Accident · No injuriesClosedBreezy I · Sulphur Spgs, TXOct 8, 1978 · N3921 · Substantial damage NTSB FTW78DRG56Accident · No injuriesClosedFlybaby FB-1A · San Antonio, TXJun 25, 1978 · N1584 · Substantial damage NTSB FTW78DRA23Accident · Serious injuriesClosedCessna 140 · Manvel, TXMay 27, 1978 · N73073 · Substantial damage NTSB FTW77DPD33Accident · Minor injuriesClosedErco 415-D · Fort Worth, TXJul 30, 1977 · N99016 · Substantial damage NTSB FTW77FQD14Accident · Minor injuriesClosedSmith-Mini · Pecos, TXMar 16, 1977 · N292J · Substantial damage NTSB FTW77FQG01Accident · 1 fatalClosedWarren-Fayo · Big Spring, TXOct 3, 1976 · N11GW · Destroyed NTSB FTW76DRA58Accident · No injuriesClosedLuscombe 8E · Houston, TXSep 19, 1976 · N1850K · Substantial damage NTSB FTW76DQG98Accident · No injuriesClosedPiper J3C · Farwell, TXJul 9, 1976 · N75066 · Substantial damage NTSB FTW76FPD46Accident · Minor injuriesClosedErco 415-C · Alvarado, TXJun 6, 1976 · N3075H · Substantial damage NTSB FTW76DQG64Accident · No injuriesClosedChampion 7BCM · Lazbuddie, TXMay 13, 1976 · N2509B · Destroyed NTSB FTW76FPD12Accident · No injuriesClosedAeronca 7AC · N.Richlnd Hlls, TXOct 4, 1975 · N84781 · Substantial damage NTSB FTW76DRG21Accident · No injuriesClosedPiper J4E · Port Lavaca, TXSep 23, 1975 · N35999 · Substantial damage NTSB FTW76DPA07Accident · No injuriesClosedCessna 140 · Desoto, TXAug 18, 1975 · N77153 · Destroyed NTSB FTW75FRG81Accident · Minor injuriesClosedCessna 120 · San Antonio, TXMay 18, 1975 · N2912N · Destroyed NTSB FTW75FQG49Accident · No injuriesClosedCessna 140 · Midland, TXApr 4, 1975 · N2787N · Substantial damage NTSB FTW75FPD01Accident · No injuriesClosedCessna 120 · N.Richlnd Hls, TXJul 27, 1974 · N72384 · Substantial damage NTSB FTW74DQG56Accident · No injuriesClosedCessna 140 · Amarillo, TXMay 22, 1974 · N2020N · Substantial damage NTSB FTW74FRG70Accident · Minor injuriesClosedErco 415-C · Alice, TXMar 18, 1974 · N99749 · Substantial damage NTSB FTW73FPA14Accident · No injuriesClosedCessna 140 · Terrell, TXSep 26, 1972 · N77153 · Substantial damage NTSB FTW73FRA07Accident · No injuriesClosedCessna 140 · Houston, TXAug 6, 1972 · N1778V · Substantial damage NTSB FTW73FPA04Accident · No injuriesClosedCessna 140 · Baylor, TXJul 11, 1972 · N89691 · Substantial damage NTSB SEA72DYC36Accident · No injuriesClosedCessna 120 · The Dalles, TXApr 23, 1972 · N76892 · Substantial damage NTSB FTW72DQG27Accident · No injuriesClosedAeronca 7BCM · Paducah, TXJan 31, 1972 · N2501B · Substantial damage NTSB FTW72FRA26Accident · No injuriesClosedLuscomb 8E · Conroe, TXDec 15, 1971 · N1850K · Substantial damage NTSB FTW72DPD22Accident · No injuriesClosedCessna 120 · Weatherford, TXNov 21, 1971 · N72384 · Substantial damage NTSB FTW71FPA26Accident · No injuriesClosedStinson 10A · Waxahachie, TXMay 6, 1971 · N26426 · Substantial damage NTSB FTW71DQG76Accident · No injuriesClosedCessna 140 · Friona, TXMay 2, 1971 · N72919 · Substantial damage NTSB FTW71DRG78Accident · No injuriesClosedPiper J-3 · Lytle, TXFeb 6, 1971 · N1414 · Destroyed NTSB FTW71AF034Accident · No injuriesClosedCessna 140 · Mineral Wells, TXDec 22, 1970 · N2499V · 2 aircraft · Substantial damage NTSB FTW71FPA16Accident · No injuriesClosedCessna 140 · Garland, TXDec 1, 1970 · N1850V · Substantial damage