Skip to content

NTSB investigations: Continental C85 series, NV

26 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" = 'NV' 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\" = 'NV' 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" = 'NV' 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 WPR17LA193Accident · No injuriesLimited investigationFinal reportCessna 140 · Empire, NVThe pilot's failure to maintain directional control during an off-airport precautionary landing on a dirt road with an uphill gradient.Aug 30, 2017 · N140X · Substantial damage NTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.Jul 17, 2016 · N2759K · Substantial damage NTSB WPR14CA145Accident · No injuriesData collectionFinal reportAeronca 7DC · Fallon, NVThe pilot's failure to maintain directional control during the landing roll with a tailwind.Mar 24, 2014 · N817DC · Substantial damage NTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…Mar 9, 2014 · N76856 · Destroyed NTSB WPR13LA191Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Mesquite, NVSeparation of the propeller from the engine during initial climb due to the incorrect torque applied to the propeller hub nut during maintenance.Apr 14, 2013 · N87114 · Substantial damage NTSB WPR12LA262Accident · No injuriesLimited investigationFinal reportCessna 120 · Smith Valley, NVThe failure of the right main landing gear strut due to corrosion-induced fatigue, which resulted in a runway excursion.Jun 8, 2012 · N1875N · Substantial damage NTSB LAX99LA059Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · North Las Vegas, NVFailure of the pilot-in-command of the other aircraft to see and avoid the stationary Cessna TR182.Dec 28, 1998 · N87714 · 2 aircraft · Minor damage NTSB SEA85LA006Accident · No injuriesLimited investigationFinal reportCessna 140A · Las Vegas, NVAccording to the plt he was unable to raise the tail of the acft during the takeoff and directional control could not be maintained. The plt made a hard landing in the acft on the day before the the accident. Investigators did not any flight control…Oct 10, 1984 · N9661A · Substantial damage NTSB LAX81FVW16Accident · Minor injuriesClosedErco 415-D · Indian Springs, NVAug 17, 1981 · N99848 · Substantial damage NTSB OAK76FXQ49Accident · No injuriesClosedCessna 140 · Silver Springs, NVJun 6, 1976 · N4094N · Substantial damage NTSB OAK76FVW24Accident · No injuriesClosedLuscombe 8A · Boulder City, NVMay 8, 1976 · N77874 · Substantial damage NTSB OAK76DXQ36Accident · No injuriesClosedErco 415-CD · Crescent Vly, NVMar 13, 1976 · N3540H · Substantial damage NTSB OAK74FVW06Accident · No injuriesClosedCessna 120 · Las Vegas, NVAug 22, 1973 · N76562 · Substantial damage NTSB OAK70FVW15Accident · No injuriesClosedCessna 140 · Las Vegas, NVMay 13, 1970 · N72685 · Substantial damage NTSB OAK70D0178Accident · No injuriesClosedCessna 140 · Searchlight, NVSep 13, 1969 · N2629N · Destroyed NTSB UNK68X0145Accident · No injuriesClosedAeronca 7AC · Sutcliffe, NVJun 2, 1968 · N2659E · Substantial damage NTSB OAK68D0160Accident · No injuriesClosedLuscombe 8A · Carson City, NVSep 20, 1967 · N2979K · Substantial damage NTSB OAK67F0289Accident · Minor injuriesClosedCessna 140 · Las Vegas, NVApr 27, 1967 · N76409 · Substantial damage NTSB OAK67D0307Accident · Minor injuriesClosedLuscombe 8E · Nixon, NVApr 23, 1967 · N1522B · Substantial damage NTSB OAK67D0121Accident · No injuriesClosedCessna 140 · Las Vegas, NVSep 3, 1966 · N72685 · Substantial damage NTSB OAK67D0089Accident · No injuriesClosedCessna 140 · Las Vegas, NVJun 4, 1966 · N3588V · Substantial damage NTSB LAX66F0107Accident · No injuriesClosedCessna 120 · Reno, NVSep 5, 1965 · N2642N · Substantial damage NTSB LAX66D0124Accident · No injuriesClosedErcoupe 415-C · Jiggs, NVAug 11, 1965 · N99753 · Substantial damage NTSB LAX66F0003Accident · Serious injuriesClosedCessna 140 · Lathrop Wells, NVJun 21, 1965 · N72467 · Substantial damage NTSB LAX66D0065Accident · No injuriesClosedLuscombe 8E · Las Vegas, NVJun 5, 1965 · N1687K · Substantial damage NTSB LAX65D0073Accident · No injuriesClosedCessna 140 · Ely, NVApr 26, 1965 · N76367 · Substantial damage