NTSB investigations: Continental C85 series
2,292 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 CHI06LA191Accident · No injuriesLimited investigationFinal reportCessna 120 · Laporte, MNThe inadequate preflight planning/preparation by the pilot and the loss of engine power due to fuel exhaustion during takeoff. A contributing factor was the runway marker.NTSB MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.NTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.NTSB LAX06CA127Accident · No injuriesData collectionFinal reportCessna 140 · Mesa, AZthe pilot's improper use of the flight controls during landing, which resulted in a nose over.NTSB SEA06CA051Accident · No injuriesData collectionFinal reportErcoupe 415-C · Arlington, WAThe pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…NTSB CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.NTSB ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB DFW06CA029Accident · No injuriesData collectionFinal reportAeronca 7DC · Saginaw, TXThe flight instructor's delayed remedial action. Contributing factors were the gusty winds.NTSB DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DFW06CA002Accident · Minor injuriesData collectionFinal reportCulver LCA · McGregor, TXThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC05LA118Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12D-85 · Wasilla, AKThe total loss of engine power for an unknown reason while maneuvering, which precipitated an emergency descent and landing, and resulted in an in-flight collision with power lines and trees. A factor associated with the accident was the power lines.NTSB SEA05LA165Accident · 1 fatalLimited investigationFinal reportCessna 120 · Chiloquin, ORThe pilot's failure to maintain airspeed and a loss of control during a pull-up maneuver. A factor contributing to the accident was the inadvertent stall/spin, which resulted in the subsequent collision with terrain.NTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.NTSB IAD05LA090Accident · Serious injuriesLimited investigationFinal reportAeronca 11CC · Charlotte, VTThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and impact with terrain. A factor in the accident was the partial loss of engine power for undetermined reasons.NTSB ATL05CA119Accident · Minor injuriesData collectionFinal reportGlobe GC-1B · Athens, TNThe pilot's improper landing flare, which resulted in a hard landing.NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.NTSB ANC05LA053Accident · No injuriesLimited investigationFinal reportCessna 140 · Denali Park, AKThe loss of engine power during takeoff and cruise flight for an undetermined reason, which resulted in an emergency descent/landing, and collision with trees.NTSB IAD05LA035Accident · Minor injuriesLimited investigationFinal reportAeronca S7CCM · Ulster, NYA loss of engine power due to carburetor ice. Contributing to the accident was conditions conducive to carburetor icing.NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB CHI04CA288Accident · No injuriesData collectionFinal reportAeronca 7BCM · St. James, MOThe pilot's failure to maintain clearance from trees during the go-around. Factors were the sun glare and the trees.NTSB ANC04LA109Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.NTSB MIA04CA114Accident · No injuriesData collectionFinal reportCessna 140 · Wimauma, FLThe improper in-flight weather evaluation by the student pilot resulting in a downwind landing and subsequent nose over.NTSB ANC04LA081Accident · No injuriesLimited investigationFinal reportCessna 120 · Beluga, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in airplane departing the landing surface into a ditch, and subsequently nosing over in tall bushes. A factor contributing to the accident was soft…NTSB LAX04LA265Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Santa Clarita, CAthe pilot's inadequate planning/decision by his inadequate evaluation of the weather resulting in an attempt to conduct flight beyond the aircraft's climb performance capability.NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB ANC04LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Big Lake, AKAn in-flight loss of control for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.NTSB LAX04LA092Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Vacaville, CAthe pilot's failure to either obtain a preflight weather report and forecast for the destination or to add additional fuel, which ultimately resulted in fuel exhaustion and collision with trees.NTSB LAX04CA070Accident · No injuriesData collectionFinal reportLuscombe 8E · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA04LA008Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Spanaway, WAThe pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.NTSB IAD04CA002Accident · No injuriesData collectionFinal reportCessna 140 · Ridegway, VAThe pilot's improper pre-flight planning, which resulted in an engine failure due to fuel exhaustion.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.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.NTSB LAX03LA289Accident · 1 fatalLimited investigationFinal reportButzbach Smith Miniplane DSA1 · Escondido, CAThe pilot's low level aerobatic maneuver and his failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with terrain.NTSB CHI03FA301Accident · 1 fatalField investigationFinal reportAeronca 11BC · Colfax, WIThe pilot failed to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall. A factor associated with the accident was the low altitude at which the pilot was maneuvering.NTSB CHI03LA282Accident · 1 fatalLimited investigationFinal reportCessna 140 · Edwardsburg, MIThe pilot not maintaining altitude/clearance from the power line during his low level cruise. Factors were the power transmission line, the lake, and low altitude flight.NTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.NTSB CHI03LA253Accident · No injuriesLimited investigationFinal reportCessna 140 · Morrilton, ARThe deterioration of the fuel line resulting in fuel contamination and the loss of engine power.NTSB CHI03LA241Accident · 1 fatalLimited investigationFinal reportYoung Pietenpol Air Camper · Peru, INThe pilot not maintaining altitude/clearance from the trees during the landing. A factor was the trees he impacted.NTSB ANC03CA081Accident · No injuriesData collectionFinal reportCessna 140 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane and excessive application of the airplane brakes during the landing roll that resulted in the airplane nosing over.NTSB CHI03LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Sullivan, WIThe pilot's inadequate compensation for wind conditions resulting in a loss of directional control. A factor contributing to the accident was the crosswind.NTSB SEA03LA135Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Arlington, WAThe pilot's failure to maintain proper approach speed and landing touch down point resulting in a runway overrun. A factor was the tailwind condition.