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 ANC98LA030Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions during landing. A factor was the crosswind.NTSB CHI98FA107Accident · 4 fatalField investigationFinal reportBeech A-36 · New Lebanon, INThe pilot's flight into known icing conditions. Contributing factors were the degraded aircraft performance, the pilot's inability to maintain the proper descent rate, trees, and the dark night condition.NTSB ANC98LA027Accident · No injuriesLimited investigationFinal reportCessna A185F · Homer, AKThe pilot's failure to maintain directional control. Factors in the accident are the sheared valve stem/deflation of the tire, and subsequent fracturing of the associated wheel.NTSB LAX98FA118Accident · 3 fatalField investigationFinal reportCessna 310H · Corona, CAThe failure of both pilots to maintain an adequate visual lookout and to see and avoid the other airplane.NTSB LAX98LA124Accident · No injuriesLimited investigationFinal reportCessna 210K · Fallon, NVThe aircraft owner/pilot's improper assembly of the engine oil pump, which resulted in failure of the unit and oil starvation failure of the engine. A factor was the lack of supervision of the owner/pilot's work by the A & P mechanic.NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.NTSB ANC98LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcgrath, AKThe pilot's failure to maintain directional control after landing. Factors associated with the accident are the presence of snow covered terrain, a tree, and the pilot's selection of an unsuitable landing area.NTSB MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…NTSB ANC98LA017Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKA separation of the axle from the landing gear strut due to overload, and stripping of the axle bolt threads.NTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.NTSB FTW98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Grants, NMThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…NTSB NYC98LA052Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Lancaster, PAPassenger control interference which resulted in pilot's failure to maintain control of the airplane during landing.NTSB ANC98LA013Accident · No injuriesLimited investigationFinal reportCessna 206 · Mnt. Village, AKThe pilot's improper flare and recovery from a bounced landing.NTSB ANC98LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Alakanuk, AKthe pilot's mismanagement of the airplane's fuel which led to the loss of engine power due to fuel starvation.NTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.NTSB NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.NTSB CHI98LA051Accident · No injuriesLimited investigationFinal reportBeech E55 · Gardner, KSthe inadvertant landing gear retraction, which occurred due to undetermined reason(s).NTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.NTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…NTSB FTW98LA029Accident · No injuriesLimited investigationFinal reportCessna 185C · Farmington, NMthe pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.NTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.NTSB SEA98LA034Accident · No injuriesLimited investigationFinal reportCessna U-206E · Friday Harbor, WAthe pilot's failure to park with the aircraft headed into the wind in high wind conditions. A factor include the high wind condition.NTSB LAX98LA003Accident · No injuriesLimited investigationFinal reportCessna 185F · Oakland, CAThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control.NTSB FTW98LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Albuquerque, NMthe pilot's failure to extend the landing gear. A related factor was his attention being diverted.NTSB MIA97LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Greenwood, MSThe intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.NTSB ANC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185E · Wasilla, AKThe loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB FTW97LA342Accident · No injuriesLimited investigationFinal reportBeech V35 · Sulphur Springs, TXthe pilot's delayed extension of the landing gear.NTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.NTSB ANC97LA134Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.NTSB NYC97FA178Accident · 2 fatalField investigationFinal reportCessna U206B · Gilbertsville, KYThe improper repair of a float by maintenance personnel which resulted in the total failure of the float.NTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…NTSB ANC97LA140Accident · Minor injuriesLimited investigationFinal reportCessna U206F · King Salmon, AKthe pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.NTSB ANC97LA138Accident · Serious injuriesLimited investigationFinal reportCessna U206E · Mcgrath, AKthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear and a nose over. Factors associated with the accident were: the pilot's failure to follow procedures and directives by neglecting to…NTSB ANC97LA136Accident · No injuriesLimited investigationFinal reportCessna 185F · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor was the short length of the off-airport site.NTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.NTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.NTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…NTSB ANC97FA121Accident · 3 fatalField investigationFinal reportCessna U206G · Halibut Cove, AKThe pilot's improper evaluation of the weather conditions which led the pilot to maneuver within the confines of the lake to avoid surrounding terrain and a subsequent inadvertent stall. Factors were the terrain-induced turbulence and gusts.NTSB ANC97LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKinadequate maintenance inspection and failure of the left main landing gear attachment due to fatigue. A factor was continuous use of the airplane for rough area, off-airport landings.NTSB MIA97LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Cadaretta, MSa hard landing resulting in the airplane departing the runway and impacting with a tree.NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB CHI97LA235Accident · No injuriesLimited investigationFinal reportCessna A188A · Norfolk, NEthe pilot's improper in-flight planning/decision, and failure or inability to control the airplane after encountering wake turbulence at low altitude during an aerial application maneuver. A related factor was the low altitude of the airplane when the wake…NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA228Accident · No injuriesLimited investigationFinal reportCessna 188B · Halstead, KSthe pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.NTSB ANC97LA112Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Palmer, AKA fatigue failure of the engine crankshaft, and an inadequate engine cylinder replacement by maintenance personnel. A factor in the accident was unsuitable terrain for a forced landing.NTSB NYC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185 · Norway, METhe pilot's failure to maintain control of the airplane while maneuvering to avoid an obstacle.NTSB ANC97LA110Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilots failure to maintain terrain clearance during the downslope, downwind, high altitude, takeoff. Factors were the snow and lighting conditions, and the tailwind takeoff.