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.

NTSB IAD00LA028Accident · No injuriesLimited investigationFinal reportBellanca B17-30A · Shenandoah, VAthe pilot's failure to maintain control during landing roll-out. A factor was the pilot's lack of total experience.Mar 24, 2000 · N146Q · Substantial damageNTSB CHI00LA094Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hayti, MOthe failure of maintenance personnel to properly install and connect the aileron control rod. Factors were the inadequate annual inspection by maintenance personnel and the aileron control not possible by the pilot.Mar 21, 2000 · N4859Q · Substantial damageNTSB MIA00LA112Accident · No injuriesLimited investigationFinal reportCessna A188B · Lake Placid, FLThe pilots inadequate visual outlook while performing aerial application resulting in the aircraft colliding with a piece of farm equipment which was parked in the field which caused the right main landing gear to separate and damage to the right wing during…Mar 19, 2000 · N84666 · Substantial damageNTSB CHI00LA091Accident · No injuriesLimited investigationFinal reportBeech 58 · Festus, MOthe pilot inadvertently retracted the landing gear instead of the flaps during the landing roll.Mar 19, 2000 · N19WM · Substantial damageNTSB DEN00LA061Accident · No injuriesLimited investigationFinal reportBeech A36 · Provo, UTThe pilot misjudging the flare. Factors were dark night conditions, and the pilot's lack of recent experience in the type of operation (night landings).Mar 16, 2000 · N367T · Substantial damageNTSB MIA00IA104Incident · No injuriesIncident investigationFinal reportBeech 58 · Memphis, TNfailure of the right main landing gear's dynamic brake relay, that resulted in the motor driving the gearbox past prescribed limits, resulting in a bent connecting rod, and failure of the gear to extend.Mar 14, 2000 · N225TA · Minor damageNTSB FTW00LA110Accident · No injuriesLimited investigationFinal reportCessna A188B · Perryton, TXThe pilot's failure to maintain directional control during the takeoff roll. A factor was the crosswind.Mar 13, 2000 · N4833Q · Substantial damageNTSB CHI00LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Pontiac, MIthe pilot's decision to fly into known adverse weather conditions which included icing and his inability to maintain aircraft control and a proper glidepath during the approach. Factors associated with the accident were the icing weather conditions and the…Mar 10, 2000 · N311JR · Substantial damageNTSB NYC00LA083Accident · No injuriesLimited investigationFinal reportCessna 310R · Sandusky, OHThe pilot's decision to land on a runway that was covered with ice and snow, without obtaining current wind information. Factors were the 20-knot tailwind and the snow-covered runway.Feb 18, 2000 · N87341 · Substantial damageNTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.Feb 14, 2000 · N875JC · DestroyedNTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.Feb 12, 2000 · N8425Q · Substantial damageNTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.Feb 12, 2000 · N711VS · Substantial damageNTSB LAX00LA095Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Glendale, AZthe pilot's attempt to go-around with inadequate altitude and airspeed available, resulting in a power demand that exceeded the capability of the aircraft. The fully extended gear and flaps were factors in this accident.Feb 8, 2000 · N4946U · Substantial damageNTSB ANC00LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuluksak, AKThe pilot's failure to maintain proper alignment during the takeoff roll. A factor associated with the accident was a soft area of snow on the runway.Feb 7, 2000 · N327CT · Substantial damageNTSB ANC00FA024Accident · 6 fatalField investigationFinal reportCessna U206G · Iliamna, AKThe pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.Feb 5, 2000 · N756HG · DestroyedNTSB LAX00LA074Accident · No injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZthe manufacturer representative's improper reinstallation of the crankshaft counterweight snap rings which subsequently separated, allowing the crankshaft counterweight to contact the crankshaft resulting in a total power loss of engine power.Jan 11, 2000 · N1565A · Substantial damageNTSB ANC00FA018Accident · 6 fatalField investigationFinal reportCessna 207 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.Dec 7, 1999 · N1747U · DestroyedNTSB NYC00LA046Accident · No injuriesLimited investigationFinal reportCessna 210L · Columbus, OHThe pilot's failure to verify landing gear extension. Factors were the unreliable retraction/extension assembly, and the flying club's continued operation of the airplane with known deficiencies in the equipment.Dec 4, 1999 · N1773X · Substantial damageNTSB DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.Nov 21, 1999 · N3928Y · Substantial damageNTSB ATL00LA013Accident · No injuriesLimited investigationFinal reportBeech BE36 · Daytona Beach, FLThe collapse of the main landing gear for undetermined reasons.Nov 14, 1999 · N3089A · Substantial damageNTSB SEA00LA017Accident · 1 fatalLimited investigationFinal reportCessna A185F · Astoria, ORThe pilot's failure to maintain airspeed after a delayed go-around. Factors include incapacitation due to the use of unapproved drugs.Nov 11, 1999 · N6245E · Substantial damageNTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…Nov 9, 1999 · N93688 · Substantial damageNTSB CHI00LA026Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rochester, INthe pilot did not obtain the proper touchdown point. Factors included the closed runway and the culvert.Nov 7, 1999 · N8235M · Substantial damageNTSB ATL00FA009Accident · 1 fatalField investigationFinal reportCessna 210N · Chamblee, GAThe failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.Nov 7, 1999 · N7317A · DestroyedNTSB SEA00FA012Accident · 4 fatalField investigationFinal reportCessna U206F · Challis, IDAircraft control was not maintained. The pilot's improper decision to abort the landing and flight into a box canyon were factors.Oct 31, 1999 · N902CT · Substantial damageNTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.Oct 30, 1999 · N1162M · Substantial damageNTSB ANC00LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…Oct 27, 1999 · N207SE · Substantial damageNTSB ATL00LA008Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, GAThe pilot's improper flare that resulted in a hard landing.Oct 23, 1999 · N7571Q · Substantial damageNTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.Oct 20, 1999 · N731PU · Substantial damageNTSB SEA00LA002Accident · No injuriesLimited investigationFinal reportBeech F33A · Idaho Falls, IDThe pilot's failure to adequately compensate for wind conditions. Factors include gusty, turbulent, variable crosswinds, and a fence in the vicinity of the runway.Oct 16, 1999 · N95CF · Substantial damageNTSB ANC00LA002Accident · No injuriesLimited investigationFinal reportCessna A185E · Yakutat, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was soft terrain.Oct 7, 1999 · N85CG · Substantial damageNTSB FTW00LA002Accident · No injuriesLimited investigationFinal reportCessna 210L · Fayetteville, ARThe cause of the right main gear collapse was undetermined. A factor was the failure of the gear 'down & locked' switch resulting in a false 'down & locked' indication in the cockpit.Oct 1, 1999 · N2157S · Substantial damageNTSB CHI99LA347Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Henrietta, MOThe engine failure due to mismanagement of the fuel system and aircraft control not maintained by the pilot.Sep 25, 1999 · N3047W · Substantial damageNTSB MIA99LA266Accident · No injuriesLimited investigationFinal reportCessna A188B · South Oxford, MSthe pilot's improper use of the brakes during the landing rollout.Sep 23, 1999 · N731RF · Substantial damageNTSB ANC99LA147Accident · No injuriesLimited investigationFinal reportCessna 185F · Pilot Point, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the pilot's inadequate evaluation of the weather conditions, a downdraft, and swampy terrain.Sep 19, 1999 · N60859 · Substantial damageNTSB ANC99LA153Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain a visual lookout for a parked airplane during taxi.Sep 17, 1999 · N36CF · Substantial damageNTSB ANC99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKCorrosion and a fatigue failure of the lower end of the landing gear strut. Factors in the accident were the manufacturer's and the FAA's insufficient standards/requirements for life limits and inspection procedures.Sep 15, 1999 · N85LC · Substantial damageNTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.Sep 11, 1999 · N6676V · Substantial damageNTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.Sep 5, 1999 · N731PW · Substantial damageNTSB ANC99LA126Accident · No injuriesLimited investigationFinal reportCessna A185E · Anchorage, AKThe total loss of engine power for an undetermined reason.Aug 30, 1999 · N124LR · Substantial damageNTSB ANC99LA118Accident · No injuriesLimited investigationFinal reportCessna 206 · Anaktuvuk Pass, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, and weather conditions consisting of clouds, rain, and fog.Aug 22, 1999 · N5446X · Substantial damageNTSB SEA99FA144Accident · 1 fatalField investigationFinal reportBeech F33A · White Swan, WAInadequate preflight planning/preparation and low airspeed. A dirt embankment, soft runway, and an excessive takeoff weight were factors.Aug 19, 1999 · N2291L · Substantial damageNTSB MIA99FA230Accident · 1 fatalField investigationFinal reportCessna 210L · Tampa, FLThe failure of the pilot to follow procedures and directives established by the operator for his failure to fuel the airplane after landing following the first leg. Contributing to the accident was the total loss of engine power due to fuel exhaustion.…Aug 19, 1999 · N640AJ · DestroyedNTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.Aug 19, 1999 · N136MC · DestroyedNTSB ANC99LA114Accident · No injuriesLimited investigationFinal reportCessna 206A · Cordova, AKA loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.Aug 15, 1999 · N4605F · Substantial damageNTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.Aug 9, 1999 · N9085R · Substantial damageNTSB ANC99FA108Accident · 4 fatalField investigationFinal reportCessna A185F · Juneau, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were mountainous/hilly terrain, low ceilings, the pilot's improper in-flight decision making, and the pilot's impairment from over-the-counter…Aug 9, 1999 · N80229 · DestroyedNTSB SEA99LA140Accident · No injuriesLimited investigationFinal reportCessna T210J · Sequim, WAThe pilot's failure to adequately compensate for the changing wind conditions. Factors include a berm located off the east end of the runway and a tailwind.Jul 31, 1999 · N821SB · Substantial damageNTSB ANC99LA116Accident · No injuriesLimited investigationFinal reportCessna 206 · Talkeetna, AKA leak/partial failure of the left main gear brake system. Factors in the accident were a short runway/landing area, and the presence of rocks/boulders at the end of the airstrip.Jul 31, 1999 · N3831G · Substantial damageNTSB ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.Jul 22, 1999 · N4949E · Substantial damage