NTSB investigations: Continental IO-520 series
4,751 cases on aircraft whose registry engine model is Continental IO-520 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 ('17032'))
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 ('17032'))
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 SEA92LA179Accident · No injuriesLimited investigationFinal reportCessna A185F · Ennis, MTDirectional control was not maintained. Factors to the accident were: a loose gravel airstrip, wind gusts and inadequate remedial action.NTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.NTSB ANC92LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe pilot in command/instructor pilot failed to maintain directional control of the airplane during the ground run.NTSB DEN92FA081Accident · No injuriesField investigationFinal reportCessna 402A · Holyoke, COFailure of the pilot to feather the failed engine propeller. A factor was: power loss for undetermined reasons.NTSB NYC92LA138Accident · No injuriesLimited investigationFinal reportBeech 58 · West Chester, PAAn encounter with windshear which resulted in the airplane landing hard and short of the runway. A factor related to the accident was the gusty wind conditions.NTSB ANC92LA117Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Anaktuvuk Pass, AKThe pilot in commands improper planning and decision to commence a takeoff in unfavorable wind conditions. Contributing factors to the accident were the impossibility of the pilot to maintain the proper climb rate, the unfavorable wind conditions, and the…NTSB LAX92TL#12Accident · No injuriesClass 3Final reportCessna 185F · Termo, CANTSB CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.NTSB ATL92LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Maxton, NCThe pilot's inadequate compensation for wind condition and the pilot-in-command's inadequate supervision of the pilot in training.NTSB LAX92LA273Accident · No injuriesLimited investigationFinal reportCessna U206E · Mayer, AZThe failure of the engine due to the slippage of the number 2 main bearing and the resultant oil starvation failure of the number 2 connecting rod. The number 2 main bearing slippage was caused by the failure of the pilot/owner to overhaul the engine in a…NTSB ANC92LA099Accident · No injuriesLimited investigationFinal reportCessna 185F · Ekuk, AKThe pilot's selection of unsuitable terrain for landing. A factor was the hidden obstruction on the surface of the landing area.NTSB LAX92LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Brawley, CAFuel starvation due to the pilot's; 1) failure to refuel the aircraft, 2) improper use of the fuel system, and 3) his delayed positioning of the fuel selector valve to a tank containing fuel. A factor in the accident was the pilot's failure to adhere to the…NTSB SEA92LA138Accident · Minor injuriesLimited investigationFinal reportNavion H · Gillette, WYAn engine power loss due to the collapse of the induction air ducting, inadequate maintenance, and improper approval of the modification.NTSB SEA92LA134Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ronan, MTThe pilot's operation with known deficiencies in equipment and erratic operation of the fuel control system. A factor contributing to the accident was: soft terrain.NTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.NTSB ANC92LA095Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKEngine failure due to total oil loss. Contributing to the accident were the separation of the oil filter adapter from the oil pump due to improper maintenance procedures and non adherence to recommended directives by company maintenance personnel, and the…NTSB ANC92LA093Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKFailure to maintain directional control. Factors include tailwheel vibration/shimmy, and an inadvertent ground loop.NTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.NTSB ANC92LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKInadequate visual look out by the pilot of both aircraft. Contributing to the accident were the pilot's diverted attention, the other moving aircraft/object (c 172), and the excessive taxi speed of the c 172.NTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.NTSB SEA92LA120Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Panguitch, UTShorting of the grounding wire (p lead) to the magnetos followed by overloading of the nose wheel strut. A factor contributing to the accident was: rough/uneven terrain.NTSB LAX92LA240Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe pilot did not abort the takeoff in time to avoid the on ground collision with the fence and creek bank.NTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB DEN92LA054Accident · No injuriesLimited investigationFinal reportCessna T210H · Boulder, COPower loss due to low fuel pump pressure and a chafed upper deck reference line. A factor was: the pilot's inability to maintain directional control due to a partially extended main landing gear.NTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.NTSB SEA92LA108Accident · No injuriesLimited investigationFinal reportCessna A188A · Redmond, ORProper clearance from objects was not maintained. Factors to the accident were: sunglare, wires, and visual lookout was not possible.NTSB BFO92LA071Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Turner, METhe pilot's inadequate flare which resulted in a hard landing. Contributing to the accident was the soft terrain.NTSB CHI92DEC01Accident · No injuriesFinal reportCessna 188A · Imlay City, MIThe pilot induced premature liftoff which resulted in inadequate airspeed and the resulting stall.NTSB ANC92FA069Accident · No injuriesField investigationFinal reportCessna 172 · Ruth Glacier, AKThe failure of the pilots of both airplanes to maintain an adequate visual lookout. Factors which contributed to the accident was the failure of the pilot of the CE-172 to become aware of and to use the listed frequency for inter aircraft communications, and…NTSB ATL92FA090Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Burnsville, NCThe pilot's failure to adequately evaluate the weather information and his continued visual flight into instrument conditions, which resulted in a collision with high terrain. A factor was the dark night.NTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.NTSB LAX92LA181Accident · No injuriesLimited investigationFinal reportNavion G · Santa Paula, CAThe pilot's improper aircraft preflight by failing to assure the fuel selector handle was in the proper position. Factors relating to this accident was the engine fuel starvation.NTSB SEA92LA071Accident · No injuriesLimited investigationFinal reportCessna A185F · Billings, MTA worn tailwheel steering system and inadequate inspection of the airplane. A factor relating to the accident was the crosswind condition.NTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.NTSB ANC92LA057Accident · No injuriesLimited investigationFinal reportCessna U206G · Kotzebue, AKThe pilot's failure to remove all the frost from the airplane and exceeding the gross weight limit of the airplane.NTSB ATL92LA072Accident · No injuriesLimited investigationFinal reportCessna U206G · Lafayette, TNThe pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.NTSB ANC92LA054Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKPoor in flight planning/decision. Factors to the accident were: snow covered terrain, and wrong runway not identified.NTSB CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.NTSB LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.NTSB CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.NTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.NTSB LAX92LA139Accident · No injuriesLimited investigationFinal reportCessna 210G · Livermore, CAThe failure of the left main landing gear saddle.NTSB ANC92T#A02Accident · No injuriesClass 3Final reportCessna 185 · Barrow, AKNTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.NTSB ANC92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Pelican, AKThe pilot's inadequate visual lookout during takeoff. Contributing to the accident was the glare from the sun.NTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.NTSB ANC92IA029Incident · No injuriesIncident investigationFinal reportCessna 207 · Port Moller, AKThe icy and snow covered condition of the runway surface and the pilot's inadequate preflight planning and preparation by not surveying the surface of the entire runway.NTSB MIA92LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · West Palm Beach, FLPartial failure of the landing gear motor which caused internal damage to the landing gear retract motor and gearbox assy.NTSB CHI92LA072Accident · No injuriesLimited investigationFinal reportBeech A36 · Griffith, INPremature gear retraction during takeoff roll by the pilot.