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 MIA82DA118Accident · Minor injuriesFinal reportCessna T210M · Fort Lauderdale, FLApproximately 18 miles west of the Fort Lauderdale airport, while cruising at 7500 feet, the engine lost power. After advising the tower of the problem, ATC suggested attempting a landing at a closer airport. At this point the pilot stated that power had been…NTSB MKC82DA054Accident · No injuriesFinal reportCessna 340A · Lincoln, NEThe pilot tookoff from runway 17L at 1705 CST. After takeoff, he encountered a vibration. He decided to land and was cleared for runway 14. Reportedly, the vibration increased at 130 knots. The pilot reduced the power to decrease his speed and remain under…NTSB CHI82IA113Incident · No injuriesIncident investigationFinal reportCessna 402B · Waukegan, ILPilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…NTSB SEA82DA038Accident · No injuriesFinal reportCessna 340 · Idaho Falls, IDThe pilot reported that during an ILS approach, he broke out at about 500 ft AGL. He stated that he did not properly arrest the sink rate and struck the runway. He also stated that there probably was some ice under the wings that had accumulated during…NTSB LAX82FA109Accident · 3 fatalField investigationFinal reportCessna 340A · 12 N.E. Burbank, CAAfter takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft…NTSB MIA82DA074Accident · No injuriesFinal reportCessna T210M · Miami, FLThe pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up.NTSB ATL82FKQ11Accident · 1 fatalFinal reportCessna T188C · Mahew, MSDuring return flight to airport the pilot flew into a previously treated field for a cleanup swath run. Approximately 1700 feet from the south end of the field the aircraft collided with a 3-strand steel twisted cable powerline running east-west across the…NTSB FTW82DA081Accident · Minor injuriesFinal reportCessna P210N · Deleon, TXThe pilot reported that he entered a left traffic pattern for landing on runway 15 at dusk. He was unable to see a 400 ft tv tower located in the vicinity of the base leg. Therefore, he kept his base leg closer in and higher than normal. He reported that…NTSB DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…NTSB ATL82FID06Accident · No injuriesFinal reportCessna 402B · Newport News, VAThe pilot stated that during his first ILS approach, the localizer needle fluctuated to the left. He made corrective turns to the left. When he broke out of the clouds at the decision height (dh), he observed the runway to the right and made a missed…NTSB LAX82FA072Accident · 4 fatalField investigationFinal reportCessna P210N · 6 Nm North Of S, AZThe pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…NTSB FTW82AA046Accident · 7 fatalFinal reportRobertson C-402B · Laredo, TXThe acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then…NTSB SEA82FA032Accident · 4 fatalField investigationFinal reportCessna P210N · Boise, IDAfter takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…NTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…NTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…NTSB ATL82FKQ09Accident · Minor injuriesFinal reportCessna 414 · Aberdeen, MSThe non-instrument rated pilot crashed about 3 hrs after taking off with 4 1/2 hours of fuel on board. He crashed while attempting an off-airport landing in a large field. The field was located less than half way to his destination. The sheriff reported…NTSB LAX82DVG12Accident · Serious injuriesFinal reportCessna P210N · Napa, CADuring his approach for landing, the pilot became concerned about other aircraft taxiing near the runway. He reported that his landing procedure was interrupted as he was waiting for one of the planes to stop short of the runway. Also, he reported aborting…NTSB DEN82FA014Accident · Minor injuriesClosedCessna 340A · Pueblo, CONTSB DEN82FA013Accident · Serious injuriesClosedCessna T210M · Gunnison, CONTSB LAX82DVD08Accident · Minor injuriesClosedCessna T210 · Stockton, CANTSB NYC82FGM07Accident · No injuriesClosedCessna 340 · West Mifflin, PANTSB LAX82FVM04Accident · No injuriesClosedCessna 402 · Pacific Grove, CANTSB ATL82FA020Accident · 3 fatalClosedCessna T210 · Charleston, WVNTSB FTW82DRA11Accident · No injuriesClosedCessna U206G · Houston, TXNTSB MKC82DCQ04Accident · No injuriesClosedCessna P210N · Fort Scott, KSNTSB LAX82FUJ04Accident · No injuriesClosedCessna P210 · Phoenix, AZNTSB FTW82DRD01Accident · Minor injuriesClosedCessna TU206G · Lafayette, LANTSB LAX81FA134Accident · 2 fatalClosedCessna 414 · Tonopah, NVNTSB MIA81FKU05Accident · No injuriesClosedCessna 402B · Miami, FLNTSB DEN81FTE72Accident · No injuriesClosedCessna 210 · Rifle, CONTSB DEN81FA068Accident · 1 fatalClosedCessna T210L · Big Timber, MTNTSB LAX81FUK04Accident · Minor injuriesClosedCessna 402B · Kayenta, AZNTSB DEN81FTM42Accident · No injuriesClosedCessna 340A · Vernal, UTNTSB MIA81FLD65Accident · No injuriesClosedCessna 401B · Tampa, FLNTSB CHI81FEI30Accident · No injuriesClosedCessna TU206F · Rock Creek, OHNTSB MIA81DLA33Accident · No injuriesClosedBeech 58P · Jacksonville, FLNTSB ANC81FA108Accident · 4 fatalClosedCessna 340A · Ketchikan, AKNTSB MKC81FCQ48Accident · Minor injuriesClosedCessna T210N · Wichita, KSNTSB CHI81FA087Accident · No injuriesClosedCessna 210D · Zanesville, OHNTSB MIA81DLD61Accident · No injuriesClosedCessna T188C · Romeo, FLNTSB LAX81FA101Accident · 3 fatalClosedCessna T210 · Elko, NVNTSB NYC81FA067Accident · No injuriesClosedCessna 210 · Philadelphia, PANTSB DEN81FA042Accident · No injuriesClosedCessna TU206G · Cisco, UTNTSB LAX81DXQ22Accident · No injuriesClosedCessna T210 · Ely, NVNTSB MIA81FKT78Accident · No injuriesClosedCessna 210N · Key Largo, FLNTSB FTW81FA097Accident · 4 fatalClosedBeech A-36TC · Shreveport, LANTSB DEN81DTK09Accident · No injuriesClosedCessna T188C · White Lake, SDNTSB DEN81FA035Accident · 4 fatalClosedCessna T210N · Castle Rock, CONTSB DEN81FTE39Accident · No injuriesClosedCessna T210 · Pagosa Sprngs, CO