Skip to content

NTSB investigations: Continental C85 series, LA

21 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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 CEN24LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Schriever, LAThe pilot’s inadvertent application of the toe brakes during the takeoff roll.Jun 22, 2024 · N77143 · Substantial damage NTSB CEN16LA033Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Gonzales, LAMaintenance personnel’s improper installation of the carburetor during recent maintenance, including the omission of a required cotter pin, which resulted in a total loss of engine power.Nov 6, 2015 · N2942N · Substantial damage NTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.Jul 31, 2005 · N1703N · Substantial damage NTSB FTW00LA223Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-CD · Abbeville, LAThe pilot's misjudged flare and improper recovery from a bounced landing. A factor was the crosswind condition.Jun 29, 2000 · N3177H · Substantial damage NTSB FTW99LA159Accident · No injuriesLimited investigationFinal reportLuscombe 8E · New Iberia, LAThe pilot's inadvertent ground loop.Jun 4, 1999 · N2680K · Substantial damage NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundMar 20, 1993 · N1337B · Substantial damage NTSB FTW83LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ruston, LAOn takeoff the pilot heard a loud bang sound then lost engine power. The pilot made a 180 degree descending turn back toward the airport. At the edge of the airport the pilot made a hard touchdown on all three gear assemblies. Investigation revealed the…Dec 12, 1982 · N89100 · Substantial damage NTSB FTW83LA015Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Iota, LAThe pilot chose to land on a private farm landing strip with a 2000 foot sod-surface runway and 50 foot trees at the north end of the strip. The pilot touched down long, and attempted a go-around but the aircraft contacted tall brush. The aircraft veered to…Oct 15, 1982 · N89003 · Substantial damage NTSB FTW79DA093Accident · 1 fatalClosedCessna 140 · Basile, LAJul 6, 1979 · N1607V · Destroyed NTSB FTW77FRJ15Accident · Serious injuriesClosedLuscombe 8E · Shreveport, LAAug 6, 1977 · N2480K · Destroyed NTSB FTW76DRD40Accident · No injuriesClosedCessna 120 · Covington, LAMay 1, 1976 · N76630 · Substantial damage NTSB FTW76DRD39Accident · No injuriesClosedErco 415-C · Baton Rouge, LAApr 4, 1976 · N99729 · Substantial damage NTSB FTW73DRJ26Accident · No injuriesClosedPiper J3C-85 · Glenmora, LAMar 7, 1973 · N6529H · Substantial damage NTSB FTW73DRJ24Accident · Minor injuriesClosedAeronca 7DC · Lk Providence, LANov 22, 1972 · N81475 · Substantial damage NTSB FTW69F0467Accident · No injuriesClosedCessna 120 · Ruston, LAApr 6, 1969 · N77327 · Substantial damage NTSB FTW69F0370Accident · No injuriesClosedCessna 140 · Cecilia, LAJan 19, 1969 · N2187N · Substantial damage NTSB FTW69D0193Accident · No injuriesClosedAeronca L-16 · Slidell, LASep 29, 1968 · N4018B · Substantial damage NTSB FTW67D0425Accident · No injuriesClosedCessna 140 · Baton Rouge, LAJan 30, 1967 · N72844 · Substantial damage NTSB FTW67F0185Accident · No injuriesClosedCessna 140A · Sikes, LAAug 25, 1966 · N5330C · Substantial damage NTSB UNK64X3691Accident · No injuriesClosedCessna 120 · Pride, LAAug 30, 1964 · N77008 · Substantial damage NTSB UNK64X2357Accident · No injuriesClosedLuscombe 8A · Monroe, LAJun 18, 1964 · N1378K · Substantial damage