NTSB investigations: Continental IO-520 series
4,750 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 DEN04CA080Accident · No injuriesData collectionFinal reportCessna T188C · Lamar, COA partial loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the low altitude.NTSB ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.NTSB SEA04FA088Accident · 1 fatalField investigationFinal reportCessna A185F · Molalla, ORThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain control. Factors include mountain obscuration, clouds and convective weather conditions.NTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.NTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.NTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.NTSB CHI04LA120Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Pleasant Hill, MOFuel exhaustion due to the pilot's improper fuel calculations. Contributing factors to the accident included the inaccurate fuel gage and the trees.NTSB DEN04LA071Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Englewood, COthe pilot's inadequate preflight planning which failed to verify an adequate fuel supply and his inadequate in-flight planning/decision which resulted in fuel exhaustion. The inadequate indication of his fuel quantity system is a contributing factor.NTSB ANC04LA050Accident · No injuriesLimited investigationFinal reportCessna U206F · Nanwalek, AKA loss of directional control for an undetermined reason during takeoff-initial climb, which resulted in the left wing colliding with the ground.NTSB DEN04LA075Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Rifle, COthe pilot's failure to verify the manual extension of the landing gear resulting in an inadvertent wheels up landing. Contributing factors include the electrical systems failure for undetermined reasons, the pilot's diverted attention and the pilot's improper…NTSB MIA04LA067Accident · No injuriesLimited investigationFinal reportCessna 206 · Clewiston, FLThe failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.NTSB LAX04LA178Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Elko, NVthe pilot's improper mixture leaning technique and failure to attain an adequate airspeed during takeoff, which resulted in a stall/mush.NTSB SEA04LA057Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAThe pilot's decision to takeoff downwind resulting in his inability to achieve a positive climb rate and an in-flight collision with terrain. Factors contributing to the accident included the rising terrain and the tailwind condition.NTSB LAX04LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Planada, CAthe partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…NTSB CHI04CA093Accident · No injuriesData collectionFinal reportBeech F33A · Wahoo, NEThe pilot's improper recovery from the bounced landing resulting in the collapse of the nose landing gear. A factor was the pilot's misjudged landing flare.NTSB LAX04LA149Accident · No injuriesLimited investigationFinal reportCessna 402A · Peach Springs, AZthe pilot's inadequate flare and touchdown that imparted high side loadings on the right main landing gear, which resulted in an overload failure of the landing gear bellcrank and the collapse of that gear.NTSB MIA04CA057Accident · No injuriesData collectionFinal reportBeech V35B · Bay St. Louis, MSThe failure of the pilot to complete the landing checklist and extend the landing gear resulting in a gear up landing and damage to the airplane.NTSB LAX04LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Tucson, AZthe pilot's inadequate compensation for the quartering tailwind and failure to maintain directional control during landing rollout.NTSB FTW04FA079Accident · 1 fatalField investigationFinal reportCessna 210N · Valley Spring, TXThe pilot's continued flight into known adverse weather and failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, due to spatial disorientation.NTSB IAD04LA011Accident · No injuriesLimited investigationFinal reportCessna 210E · Pittsburgh, PAThe owner/pilot-mechanic's failure to comply with an airworthiness directive, which resulted in a fatigue fracture to the left main landing gear saddle.NTSB LAX04LA131Accident · No injuriesLimited investigationFinal reportCessna 185F · Mesa, AZthe pilot's inadequate compensation for the crosswind and his failure to maintain directional control, which resulted in an inadvertent ground loop. A factor in this accident was the pilot's diverted attention.NTSB LAX04CA117Accident · No injuriesData collectionFinal reportCessna A185F · Fowler, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB LAX04CA104Accident · Serious injuriesData collectionFinal reportBeech F33A · Shoshone, CAthe CFI's failure to verify the wind direction prior to takeoff, which resulted in his failure to attain an adequate airspeed and led to an inadvertent stall-mush. The short runway and variable winds were factors.NTSB CHI04LA058Accident · No injuriesLimited investigationFinal reportCessna 310R · Port Huron, MIThe loss of directional control as a result of reduced braking performance due to a snow-covered runway. Also causal was the pilot's decision to land with a quartering tailwind. The snowbank was a contributing factor.NTSB SEA04LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Deer Park, WAThe dual student pilot's failure to maintain directional control during the landing roll and the failure of the flight instructor to provide remedial action. A factor was snowbank.NTSB MIA04CA040Accident · No injuriesData collectionFinal reportCessna 210L · Fort Meade, FLThe failure of the pilot to abort the takeoff after encountering fog during the preflight and engine run-up, and also his failure to maintain proper alignment with the runway during the takeoff roll due to a fogged windshield resulting in the collision with a…NTSB FTW04FA052Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe failure of flight/navigation instruments while in instrument meteorological conditions (in-cloud flight and low ceilings) resulting in spatial disorientation. A contributing factors was the prevaling instrument meteorological conditions (low ceiling and…NTSB CHI04LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Wellington, KSThe pilot not maintaining directional control during the landing roll. Factors were the dry grass and the concrete box he encountered during his excursion off the runway.NTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB NYC04LA016Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Swanton, OHThe pilot's improper fuel tank selection, which resulted in fuel starvation, and subsequent loss of engine power.NTSB ATL04LA025Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Edgefield, SCThe pilot's failure to follow the checklist to ensure the fuel filler cap was secured resulting in fuel starvation and subsequent loss of engine power.NTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.NTSB SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.NTSB DEN04LA013Accident · No injuriesLimited investigationFinal reportCessna 210G · Meeker, COthe pilot's failure to extend the landing gear. Contributing to the accident was the pilots failure to recognize the gear warning horn during the landing flare.NTSB CHI04LA023Accident · No injuriesLimited investigationFinal reportCessna A185E · Cedarville, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the rough terrain on which the airplane was landed.NTSB ATL04LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Hickory, NCThe pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL04TA012Accident · No injuriesFinal reportCessna 210L · Tallahassee, FLLoss of engine power due to crankshaft counterweight failure.NTSB DEN03FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech F33A · Greer, AZThe airplane is missing for unknown reason.NTSB ANC03LA128Accident · No injuriesLimited investigationFinal reportCessna 206 · Fairbanks, AKA failure of an attaching bolt that allowed the nose wheel fork to separate from the nose gear strut, which resulted in the collapse of the nose gear during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.NTSB MIA03LA184Accident · No injuriesLimited investigationFinal reportCessna 206 · Okeechobee, FLThe total loss of engine power due to fuel exhaustion for undetermined reasons. A finding in the investigation was the inadequate preflight inspection of the airplane by the pilot-in-command for his failure to note a partial blockage at the inlet of the left…NTSB NYC03FA197Accident · 3 fatalField investigationFinal reportCessna U206F · Greenville, METhe pilot's improper fuel management by which he failed to position the fuel selector in the proper position and resulted in fuel starvation during the initial climb.NTSB ANC03LA113Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Chalkyitsik, AKThe pilot's inadequate compensation for wind conditions, and his failure to maintain adequate airspeed during takeoff, which resulted in an in-flight collision with brush, and subsequent stall of the airplane. Factors associated with the accident were a…NTSB NYC03LA181Accident · No injuriesLimited investigationFinal reportCessna A185F · Marion, OHFatigue and corrosion of the right main landing gear attachment, which resulted in a gear collapse while landing.NTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.NTSB CHI03LA271Accident · No injuriesLimited investigationFinal reportCessna 188A · Freeman, SDThe pilot's failure to maintain directional control and clearance during landing roll. Additional factors included the pilot's improper recovery from a bounced landing, the crosswind and the corn crop.NTSB FTW03CA201Accident · No injuriesData collectionFinal reportCessna 210D · San Antonio, TXThe pilot's failure to comply with the checklist resulting in a wheels up landing. Contributing to the accident was self-induced pressure.NTSB ANC03FA094Accident · 3 fatalField investigationFinal reportBeech V35-B · Skagway, AKThe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall, which resulted in a collision with trees during takeoff-initial climb. Factors contributing to the accident were terrain features consisting of a ravine and rising terrain on…NTSB ANC03LA091Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKA complete loss of engine power during cruise flight due to the shifting of a main crankshaft bearing that produced a fatigue failure of the crankshaft. A factor contributing to the accident was unsuitable terrain for a forced landing, which resulted in a…