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 SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.NTSB CHI93LA120Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Lee'S Summit, MOThe pilot's improper procedures during ground operations.NTSB MIA93LA091Accident · No injuriesLimited investigationFinal reportBeech V35B · Key Largo, FLThe pilot-in-command's complacency and decision to leave the aircraft controls unattended with the engine operating and without setting the parking brake.NTSB FTW93LA109Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe pilot's the improper flare prior to touchdown. Factors were the fuel starvation power loss and improper positioning of the fuel selector.NTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingNTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.NTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.NTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.NTSB ANC93LA035Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Bradley Lake, AKThe pilot in command not removing the frost from the plane's airfoil surfaces before takeoff and not aborting the takeoff when the airplane showed no sign of wanting to fly at the initial rotation point/airspeed. A factor in the accident was the icing…NTSB BFO93LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · Sunbury, OHThe pilot's failure to maintain directional control during the takeoff roll. The soft terrain was a related factor.NTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.NTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.NTSB ANC93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilots failure to follow VFR procedures. A factor was the whiteout snow condition.NTSB DEN93LA020Accident · No injuriesLimited investigationFinal reportBeech 58 · Ft Collins, COFailure by the pilot to follow IFR procedures in not executing a missed approach when he arrived at the runway threshold with improper alignment and improper descent rate for landing. A factor was: marginal weather conditions.NTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB ATL93FA028Accident · 1 fatalField investigationFinal reportBeech 58 · West Columbia, SCThe pilot's continued operation with known deficient equipment, his improper descent, and his failure to perform a missed approach. A factor was the operator's inadequate surveillance of the pilot's procedures and the maintenance of the airplane.NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB ATL93LA019Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rives, TNThe pilot's failure to follow instrument procedures while conducting an instrument approach which resulted in the collision with trees; the pilot descended below the minimum descent altitude.NTSB ANC93LA009Accident · No injuriesLimited investigationFinal reportCessna 206 · Slate Creek, AKThe icy condition of the runway and the discontinued snow removal.NTSB NYC93LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Cincinnati, OHThe failure of the pilot to maintain directional control during landing which resulted in the airplane striking a drainage ditch. Factors related to the accident were the crosswind and the drainage ditch.NTSB DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.NTSB MIA93LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Port St. Lucie, FLTotal loss of engine power due to fuel exhaustion caused by poor preflight planning preparation by the pilot in command.NTSB NYC93FA005Accident · 3 fatalField investigationFinal reportBeech 35 · New Manchester, WVThe pilot's failure to obtain adequate airspeed and abort the takeoff. The pilot's premature rotation, upsloping runway, and a tailwind are contributing factors.NTSB MIA93LA003Accident · 2 fatalLimited investigationFinal reportMcilraith Steen Skybolt · Hattiesburg, MSA loss of control for undetermined reasons.NTSB DEN93LA001Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Steamboat Sprgs, COThe pilot's selection of an unsuitable landing area when a suitable forced landing area was available. A factor was: fuel starvation for unknown reasons.NTSB ANC93LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Admiralty Isl, AKThe pilot's selection of unsuitable terrain. A factor related to the accident was: the soft sand.NTSB ATL93LA002Accident · No injuriesLimited investigationFinal reportBeech E-55 · Chattanooga, TNThe failure of an unknown person to follow proper procedures/directives by operating a radio-controlled model plane in airport traffic pattern airspace.NTSB ANC93LA004Accident · No injuriesLimited investigationFinal reportCessna 206U · Lime Village, AKPilot in command's poor preflight planning. A factor in the accident was the hazards on or near the gravel bar strip takeoff area.NTSB FTW92FA232Accident · 1 fatalField investigationFinal reportCessna 310R · Idabel, OKThe pilot's descent below the minimum descent altitude. Factors were the pilot's improper IFR procedure, low ceiling, and dark night conditions.NTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.NTSB MIA92LA189Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLUndetected chaffing and grounding of a wire to the nose landing gear squat switch which resulted in the landing gear being signalled at all times for gear up when electrical power was applied to the system. Contributing to the accident was the overheating of…NTSB MIA92LA188Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLFailure of the right main landing gear actuator due to overstress for undetermined reasons which resulted in loss of all landing gear system hydraulic fluid which in turn resulted in the pilot being unable to extend and lock the landing gear.NTSB ANC92LA169Accident · No injuriesLimited investigationFinal reportCessna 206 · Chena Marina, AKPilot in commands's poor preflight planning/preparation. Factors contributing to the accident were: lack of understanding of aircraft takeoff performance, lack of recency of PIC experience in type of operation, loss of aircraft performance takeoff…NTSB ANC92T#A11Accident · No injuriesClass 3Final reportCessna 185 · Kotzebue, AKNTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.NTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.NTSB ATL92LA174Accident · No injuriesLimited investigationFinal reportCessna 210M · Smithfield, NCThe pilot's operation of the airplane with known electrical deficiencies which resulted in a failure of the landing gear hydraulic powerpack. The pilot also failed to follow emergency procedures for lowering the landing gear. Factors were an inoperative…NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.NTSB ANC92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Fort Yukon, AKFatigue failure of an engine cylinder precipitated by the pilot-in-command intentionally exceeding the engine performance ratings in order to sustain flight in the grossly overweight condition. A factor contributing to the accident was the high grass. A…NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB ANC92LA151Accident · No injuriesLimited investigationFinal reportCessna 185E · Yakutat, AKThe pilot in command not maintaining directional control of the airplane.NTSB CHI92LA256Accident · No injuriesLimited investigationFinal reportCessna A185F · St. Cloud, MNFailure of the pilot-in-command to abort takeoff before overrunning the lake edge.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.NTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.