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 CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.NTSB ANC97TA098Accident · Minor injuriesFinal reportCessna U206G · Platinum, AKThe pilot's misjudgment of the proper touchdown point. A factor associated with the accident was a tailwind.NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..NTSB ANC97FA092Accident · 2 fatalField investigationFinal reportCessna 207A · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…NTSB ANC97IA089Incident · No injuriesIncident investigationFinal reportCessna 185 · Anchorage, AKThe pilot-in-command's failure to retract the landing gear which led to an inadvertent water landing with the amphibian float wheels extended. Associated factors are the pilot's habit interference and the FAA inspector's inadequate monitoring of the flight.NTSB ANC97LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Prudhoe Bay, AKThe pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.NTSB ANC97LA086Accident · No injuriesLimited investigationFinal reportCessna 185F · Sitka, AKfailure of the pilot(s) to properly flare the airplane during a simulated forced landing. The excessive rate of descent on final approach was a related factor.NTSB SEA97LA143Accident · No injuriesLimited investigationFinal reportCessna A188 · Richland, WAthe pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.NTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.NTSB FTW97LA211Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Oklahoma City, OKThe pilot's impairment of judgment and performance due to alcohol which led to an attempted takeoff in an airplane without an elevator installed.NTSB SEA97LA129Accident · No injuriesLimited investigationFinal reportCessna 210D · Renton, WALanding gear hydraulic system power pack failure.NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.NTSB MIA97LA171Accident · No injuriesLimited investigationFinal reportBeech E55 · Griffin, GAthe pilot's failure to extend the landing gear, which resulted in a wheels up landing.NTSB ANC97LA082Accident · No injuriesLimited investigationFinal reportCessna TU206A · Yakutat, AKthe pilot's selection of unsuitable terrain for landing.NTSB ANC97LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Cordova, AKThe pilot's decision not to perform a go-around. A factor in the accident was the presence of birds which led the pilot to extend and misjudge his touchdown point.NTSB NYC97LA082Accident · No injuriesLimited investigationFinal reportBeech F33A · Mattituck, NYthe pilot's inadequate compensation for the wind conditions and improper flare, which resulted in a hard landing.NTSB ANC97LA058Accident · No injuriesLimited investigationFinal reportCessna 185F · Manley, AKthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing run. Factors relating to the accident were: frozen terrain, adverse wind condition, and proximity of a snowbank.NTSB SEA97LA087Accident · No injuriesLimited investigationFinal reportCessna A185E · Billings, MTThe flight instructor's inadequate compensation for the wind conditions. The crosswind conditions were a factor.NTSB ATL97LA059Accident · No injuriesLimited investigationFinal reportCessna 210D · Huntsville, ALcorrosion and subsequent failure of the elevator trim tab, which resulted in vibration and failure of the elevator. Failure of maintenance personnel to comply with a service bulletin was a related factor.NTSB MIA97WA135Accident · 4 fatalForeign investigationBeech A-36 · Pitts Town, BahamasNTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.NTSB ANC97LA047Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Teller, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…NTSB MIA97WA110Accident · No injuriesForeign investigationCessna 310R · Deep Water Cay, BahamasNTSB ANC97LA042Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Grayling, AKThe partial loss of engine power due to a fractured connecting rod bolt, which was precipitated by fatigue. A factor associated with the accident was the snow covered terrain in the emergency landing site.NTSB ANC97LA040Accident · No injuriesLimited investigationFinal reportCessna 185 · Chugiak, AKThe pilot's improper installation of the main landing gear wheel penetration skis, which allowed the skis to rotate to a vertical position in flight and subsequently separate during landing.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB ANC97LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Ketchikan, AKthe pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.NTSB ANC97LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKthe pilot's inadequate compensation of wind conditins, and failure to maintain directional control during the takeoff run. The crosswind was a related factor.NTSB ANC97LA027Accident · No injuriesLimited investigationFinal reportCessna 207 · Chevak, AKthe pilot's continued VFR flight into instrument meteorological conditions, his misjudgment of distance and altitude during the approach to land, and his failure to attain a proper touchdown point during the landing. A factor relating to the accident was: the…NTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.NTSB LAX97LA101Accident · No injuriesLimited investigationFinal reportCessna 210H · Big Bear City, CAa corroded landing gear down limit switch, which resulted in a retracted left main gear during the landing sequence.NTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.NTSB MIA97LA079Accident · No injuriesLimited investigationFinal reportBeech V35 · Orlando, FLloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB MIA97LA076Accident · No injuriesLimited investigationFinal reportCessna U206D · Tampa, FLInadequate torque of the cylinder base nuts and through bolt nuts by company maintenance personnel which allowed movement of the crankcase halves. As a result the No. 2 main bearing failed which allowed excessive movement of the crankshaft resulting in…NTSB LAX97FA089Accident · 2 fatalField investigationFinal reportBeech F33A · Mt San Jacinto, CAcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude or clearance from mountainous terrain. Factors relating to the accident were: the high/mountainous terrain, and the adverse weather…NTSB FTW97LA066Accident · No injuriesLimited investigationFinal reportCessna 210N · Kerrville, TXthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI97LA040Accident · No injuriesLimited investigationFinal reportBeech B55 · Park Rapids, MNthe pilot's high flare. Factors were the icing weather condition and the airframe ice.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB LAX97FA049Accident · 1 fatalField investigationFinal reportBeech 95-C55 · San Diego, CAthe pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…NTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.NTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.NTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…NTSB SEA97LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Price, UTThe pilot's failure to maintain directional control during the landing roll.NTSB ATL97LA016Accident · No injuriesLimited investigationFinal reportCessna 188B · Ocilla, GAThe pilot's failure to adequately preflight and plan the fuel required for the flight.NTSB FTW97LA028Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Giddings, TXThe loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.NTSB MIA97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 21OK · Tampa, FLThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the improper planning/decision of the pilot of the Cessna 210 to depart the traffic pattern on the downwind leg rather than on the upwind leg as…NTSB CHI97LA002Accident · No injuriesLimited investigationFinal reportCessna 185 · Finley, NDfailure of the flight instructor (CFI) to ensure that clearance from the dock was maintained, while starting to taxi. The crosswind was a related factor.NTSB MIA97LA001Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Jackson, MSthe pilot's failure to maintain control of the airplane resulting in an in flight collision with the runway. A factor in this accident was the pilot diverted his attention away from flying the airplane to fix his shoe lace.NTSB LAX96LA341Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Santa Ynez, CAfailure of a maintenance technician to properly torque the fuel injector lines to three cylinders.NTSB ANC96LA152Accident · No injuriesLimited investigationFinal reportCessna 206F · Talkeetna, AKThe disconnection of the nosegear scissors assembly due to the loss of a retainer bolt.