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 ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.NTSB CHI01LA288Accident · No injuriesLimited investigationFinal reportCessna 188 · Almond, WIthe pilot failed to maintain clearance from the corn crop. Additional factors were the inoperative spray pump, the corn crop, and the pilot's diverted attention.NTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.NTSB LAX01FA279Accident · 2 fatalField investigationFinal reportBeech F-33A · Mobile, AZThe flying pilot's initiation of an intentional maneuver at an altitude inadequate to maintain terrain clearance. Low altitude flight was a contributing factor.NTSB NYC01IA211Incident · No injuriesIncident investigationFinal reportCessna 210L · Bluefield, WVImproper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.NTSB ANC01LA108Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's selection of a the wrong runway, which resulted in a tailwind for the takeoff attempt. Factors associated with the accident are a short takeoff area, a tailwind, and the pilot's inadequate evaluation of the weather conditions.NTSB FTW01LA180Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Smith, ARthe overload fracture of the left main landing gear actuator which resulted in the loss of all hydraulic fluid and led to a wheels up landing.NTSB CHI01LA258Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Crane Lake, MNThe inadvertant control interference by the passenger's knee leading to the pilot's directional control of the floatplane not being possible.NTSB CHI01FA256Accident · 2 fatalField investigationFinal reportBeech E55 · Rensselaer, INthe pilot's ostentatious display when he buzzed the farmstead and did not maintain clearance from the barn.NTSB DEN01FA135Accident · 1 fatalField investigationFinal reportBeech V-35A · Lusk, WYthe pilot's inadequate visual lookout, which resulted in an inadvertent collision with transmission wires.NTSB ANC01LA094Accident · No injuriesLimited investigationFinal reportCessna U206 · McCarthy, AKThe pilot's decision to not abort the takeoff. Factors associated with the accident are a short and rising runway.NTSB ANC01LA096Accident · No injuriesLimited investigationFinal reportCessna U206 · Yakutat, AKThe pilot's failure to maintain clearance from high vegetation during the takeoff roll.NTSB MIA01LA199Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pelham, GAThe ground refueler's inadequate visual lookout resulting in his walking into the rotating propeller of the airplane and receiving fatal injuries.NTSB ANC01WA091Accident · 1 fatalForeign investigationCessna 185 · Yakutat, AKNTSB ANC01LA090Accident · No injuriesLimited investigationFinal reportCessna 185 · Yakutat, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident were trees.NTSB NYC01LA183Accident · No injuriesLimited investigationFinal reportBeech BE-36 · Biddeford, METhe pilot's inadequate preflight inspection, which resulted in an attempted takeoff with a control column lock installed.NTSB LAX01LA257Accident · No injuriesLimited investigationFinal reportCessna 185F · Visalia, CAThe pilot failed to maintain clearance from crops which bordered the narrow runway.NTSB CHI01LA225Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Freemont, MIThe broken throttle cable during cruise flight and the pilot's inadequate flare during the forced landing attempt. Factors relating to this accident were the low airspeed during the forced landing attempt and the short, corn stubble field.NTSB CHI01FA218Accident · 1 fatalField investigationFinal reportCessna 310R · Oak Creek, WIThe pilot not maintaining clearance from objects during an ILS approach in low night IFR conditions and his descent below decision height. Factors were the dark night, mist, low ceiling, and the trees west of the approach.NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB ANC01LA088Accident · No injuriesLimited investigationFinal reportCessna 185 · Cantwell, AKThe student pilot's failure to abort a landing resulting in an overrun. Factors in the accident were the pilot's diverted attention, and gusty wind conditions.NTSB CHI01LA179Accident · Serious injuriesLimited investigationFinal reportCessna T310P · St. Cloud, MNthe fuel starvation. Fuel management by the pilot was an additional cause. The muddy terrain was a contributing factor.NTSB FTW01LA139Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Magnolia, TXthe pilot's failure to maintain clearance over the wires while on final approach.NTSB MIA01LA155Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kill Devil Hill, NCThe loss of engine power due to fuel starvation for undetermined reasons resulting in the forced landing and subsequent on-ground collision with a sand dune with a resulting nose over. A factor in the accident was the unsuitable terrain encountered during the…NTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.NTSB IAD01LA058Accident · No injuriesLimited investigationFinal reportBeech 55 · West Chester, PAThe partial blockage of the pitot/static system, which led to an inaccurate airspeed indication, and resulted in an aborted takeoff and runway overrun. A factor was the wet runway.NTSB CHI01FA139Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · St Cloud, MNthe pilot not maintaining aircraft control during the loss of right engine power during initial climb. Factors were the loss of right engine power for an undetermined reason, the pilot not complying with flight manual emergency procedures, and the trees.NTSB ANC01LA057Accident · No injuriesLimited investigationFinal reportCessna 206 · Stebbins, AKA jammed control yoke during landing, an entangled wiring harness, and inadequate maintenance by company personnel. A factor associated with the accident was the pilot's inability to flare the airplane during landing, due to the mechanical malfunction.NTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.NTSB NYC01FA122Accident · 1 fatalField investigationFinal reportCessna U206E · New Market, VAA loss of engine power due to a failure of the number 5 piston for undetermined reasons. A factor in this accident was the inadequate emergency handling provided by the air route traffic controller.NTSB SEA01LA086Accident · No injuriesLimited investigationFinal reportCessna U206 · Yamhill, ORthe pilot's failure to adequately compensate for gusty tailwind conditions, resulting in an excessive rate of descent at touchdown. Factors include gusty tailwinds during the landing sequence.NTSB MIA01LA130Accident · No injuriesLimited investigationFinal reportCessna 210N · Gainesville, FLThe pilot's delay in securing all non-essential electrical equipment in-flight resulting in battery depletion before complete gear extension was accomplished using the normal system and subsequent collapse of the main landing gear. A contributing factor in…NTSB DEN01LA091Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Columbus, NMThe impact with terrain following an inadvertent stall/mush by the pilot during a go-around. A contributing factor was a dust devil.NTSB ANC01LA070Accident · No injuriesLimited investigationFinal reportCessna 207A · Deadhorse, AKThe pilot's failure to maintain altitude/clearance while maneuvering. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB ANC01LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable area for taxi. A factor associated with the accident was a rough/uneven taxiway.NTSB LAX01LA139Accident · Minor injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZThe certified flight instructor's inadequate supervision of the dual student who failed to recognize the extent of the crosswind and lost directional control. A factor in the accident was the variable wind condition.NTSB ANC01WA043Accident · 1 fatalForeign investigationCessna 210F · Teslin, CanadaNTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB ATL01LA038Accident · No injuriesLimited investigationFinal reportBeech 55 · Lake Wales, FLThe pilot's failure to follow the descent and before landing checklist that resulted in fuel starvation to both engines and the subsequent loss of engine power.NTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.NTSB IAD01LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · Newark, OHImproper maintenance, which resulted in the failure of the instrument panel shock mounts.NTSB FTW01LA071Accident · No injuriesLimited investigationFinal reportBeech 58 · Shreveport, LAthe pilot's failure to maintain visual separation with a parked airplane while taxing. Contributory factors were the dark night light conditions, the rain, and the non-lighted ramp area where the unoccupied airplane was parked.NTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.NTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.NTSB DEN01FA064Accident · 3 fatalField investigationFinal reportBeech V35 · Wendover, UTThe pilot flying at an altitude insufficient to clear surrounding terrain. Contributing factors were the pilot becoming lost/disoriented, his subsequent spatial disorientation, and dark night conditions.NTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.NTSB DEN01LA047Accident · No injuriesLimited investigationFinal reportBeech V-35A · Albuquerque, NMthe pilot's inattention during night taxiing, which resulted in his airplane impacting a parked airplane.NTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.