NTSB investigations: Continental TSIO-520 series
1,736 cases on aircraft whose registry engine model is Continental TSIO-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 ('17040'))
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 ('17040'))
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 MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB NYC89LA081Accident · No injuriesLimited investigationFinal reportCessna 402B · Hyannis, MAInadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.NTSB MIA89LA075Accident · No injuriesLimited investigationFinal reportCessna T310R · Pensacola, FLFailure of the pilot to maintain the proper airspeed during the approach resulting in landing short of the runway and failure to maintain directional control during the landing roll.NTSB NYC89LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Newport, RILoss of control during an attempted go-around due to raising the flaps at low airspeed, in a nose high attitude.NTSB LAX89FA081Accident · 1 fatalField investigationFinal reportCessna 414 · Pleasanton, CAFailure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.NTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INNTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHNTSB LAX89LA036Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Camarillo, CAPilot of N8219J used poor judgement when she elected to execute the high speed taxi operation.NTSB DEN89LA027Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COThe private plt was flying 2 friends to his farm. His dirt strip runs east and west, but prevailing winds were 320 deg at 40, gusting to 50 KTS. A cross wind landing to the west had to be aborted and the plt elected to land to the north, on an access road.…NTSB DEN89FA009Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMBefore dawn, witnesses (who were preflighting an acft) saw N732QP taxiing to rwy 4. They heard an eng run-up; however, they were unable to see the acft takeoff due to heavy fog that had just moved over the arpt. (The witnesses decided to cancel their flt due…NTSB DEN89LA002Accident · Minor injuriesLimited investigationFinal reportCessna TP206B · Durango, COThe private plt was practicing landings in his acft. During takeoff ground run, while making a touch and go landing, the plt reported experiencing vibrations from both main gear and his acft departed the 5,000 x 50 ft rwy to the left. The plane traveled 100…NTSB LAX88LA296Accident · No injuriesLimited investigationFinal reportCessna 402C · Prescott, AZWhile taxiing, in order to clear a parked airplane to the right, the pilot maneuvered the airplane left of the centerline. The left main landing gear traveled off the asphalt. The airplane pivoted 90 degrees from the direction of travel collapsing the landing…NTSB LAX88LA290Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Paula, CADuring a cross country flight, the pilot diverted to a closer airport due to a low fuel state. The pilot was unable to land the airplane on the first attempt. During the second attempt, the engine quit. The pilot made an emergency landing where during the…NTSB ANC88FA111Accident · 2 fatalField investigationFinal reportCessna 402B · Mt. Torbet, AKThe on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the…NTSB LAX88LA287Accident · No injuriesLimited investigationFinal reportCessna T210N · Culver City, CADuring a pleasure flight, the engine experienced a loss of power. A forced landing was made during which the airplane collided with wires and was substantially damaged. During the inspection of the airplane, the fuel tanks were found exhausted of fuel.NTSB NYC88FA216Accident · 2 fatalField investigationFinal reportCessna TU206G · White Lake, NYThe float equipped aircraft made multiple takeoff attempts on a lake, getting airborne at least once prior to the accident. On the takeoff run that terminated in the accident, the pilot turned into an inlet after getting airborne with insufficent room to turn…NTSB LAX88FA245Accident · 4 fatalField investigationFinal reportCessna 320D · Mammoth Lakes, CAThe pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher…NTSB BFO88IA065Incident · No injuriesIncident investigationFinal reportCessna T210R · Washington, DCImproper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.NTSB MIA88WA207Accident · 1 fatalForeign investigationCessna 414 · Nassau, BahamasNTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.NTSB DEN88LA117Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Ft. Collins, CONTSB MIA88IA181Incident · No injuriesIncident investigationFinal reportCessna P210N · Daytona Beach, FLThe plt rprtd that while on final apch to land, he became distracted by conversation with the passenger & failed to lower the landing gear. Subsequently, the acft was landed with the gear retracted. After it was lifted from the rwy after the incident, the…NTSB DEN88FA111Accident · 1 fatalField investigationFinal reportCessna T210N · Seboyeta, NMThe plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a…NTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMNTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.NTSB ATL88LA105Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Lincolnton, NCJust after lift off for a LCL flt, the plt-in-cmd, who was in the right seat, noted the front edge of the nose baggage compt to 'pop open'. He assumed control of the acft and attempted to 'tear drop' a return to the opposite runway. During the maneuver, the…NTSB CHI88LA072Accident · No injuriesLimited investigationFinal reportCessna P210 · Indianapolis, INWhile landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,…NTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…NTSB DEN88LA080Accident · Minor injuriesLimited investigationFinal reportCessna TU-206 · Durango, COWhile on a cross country flight the plt ran short of fuel and altered course to another airport. The pilot said the acft engine failed short of the new destination due to fuel exhaustion. The plt performed an emergency landing in an open field and the acft…NTSB MIA88FA107Accident · 2 fatalField investigationFinal reportBeech 58P · Dunedin, FLFlt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…NTSB MKC88LA048Accident · No injuriesLimited investigationFinal reportCessna T-188C · Goodland, KSWhile flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree…NTSB BFO88FA014Accident · No injuriesField investigationFinal reportCessna T210N · Sterling, VAAbt 2.7 hrs after takeoff, the student plt & instructor (CFI) were practicing instrument apchs when the eng lost pwr. The CFI took control of the acft & made a forced lndg, but the acft was damaged on rough terrain. An exam of the acft revealed the right &…NTSB LAX88LA093Accident · 2 fatalLimited investigationFinal reportCessna TU206G · Kirkland, AZDuring a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.NTSB ATL88FA073Accident · Serious injuriesField investigationFinal reportCessna P210N · Huntsville, ALNTSB ANC88FA019Accident · Minor injuriesField investigationFinal reportCessna 402B · Anchorage, AKDrg arr in hvy traffic, reeve flt 726 (Boeing 727) & wilburs flt 304 (Cessna 402B, N969JW) recd radar adzys for visual apchs to rwys 6L & 6R, respectively. Subsequently, both flts were clrd to lnd. At 1555:04, the LCL twr ctlr transmitted that the wnd at the…NTSB MIA88WA056Accident · 1 fatalForeign investigationCessna 402B · Cat Island, BahamasNTSB LAX88WA067Accident · No injuriesForeign investigationPiper PA46 · Guaymas, MexicoNTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…NTSB LAX88FA052Accident · 4 fatalField investigationFinal reportCessna T210L · Camp Verde, AZNTSB LAX88LA046Accident · No injuriesLimited investigationFinal reportCessna T210M · Colusa, CAThe pilot executed a missed approach at the destination because of fog and reduced visibility. The pilot elected to divert to Colusa due to the weather and on approach to calusa the engine quit. Attempts to restart the engine were unsuccessful and the pilot…NTSB MIA88LA030Accident · No injuriesLimited investigationFinal reportCessna T-210N · Tallahassee, FLDuring ldg gear extension plt did not get safe down indication. Attempts to use emergency extension pump were unsuccessful. Acft was landed nose gear extended main gear retracted. Post accident inspection of the acft revealed the left main gear down lock…NTSB CHI88LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · Sugar Grove, ILWhile descending for landing the aircraft experienced total power failure due to fuel exhaustion. An emergency landing was made on a road and on short final, the aircraft collided with power lines which ran along the south side of the road. According to the…NTSB ANC88IA013Incident · No injuriesIncident investigationFinal reportCessna 402B · Cordova, AKThe company maintenance personnel were aware of a shimmy problem but they thought is was only worn bushings. The maintenance people stated they inspected the part but found no problem. The pilot-in-command also stated he found no problem upon visually…NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB MIA87LA253Accident · No injuriesLimited investigationFinal reportCessna TU206F · Tavernier, FLThe acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,…NTSB SEA87LA191Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Las Vegas, NVThe aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The…NTSB ANC87LA162Accident · No injuriesLimited investigationFinal reportCessna 206G · 100mi S.Kng Slm, AKThe aircraft experienced an engine power loss while in cruise flight and subsequently undershot a lake during the emergency landing. Examination of the engine revealed the number 2 bearing was found completely disintegrated and missing from its seat. Evidence…NTSB ATL87FA255Accident · Serious injuriesField investigationFinal reportCessna 402C · Atlanta, GADuring climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB FTW87FA196Accident · Minor injuriesField investigationFinal reportCessna P210N · Pearland, TXDrg arrival, the plt made a nr half circle ovr the arpt & entered a dwnwnd for rwy 14R. Drg the entry, he reduced pwr & noted 2 or 3 sputters fm the eng. Just bfr turning to a base leg, he advanced the throttle for adnl power, but there wasno response fm the…