NTSB investigations: Continental TSIO-520 series
83 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of engine power”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 FTW00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Corning, ARThe loss of engine power for an undetermined reason. A factor was the dark night light condition.NTSB CHI00LA052Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Indianola, IAloss of engine power for undetermined reason. A factor relating to this accident was the tree.NTSB FTW99LA160Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Cleburne, TXThe total loss of engine power resulting from a failure of the #4 cylinder exhaust valve and/or piston. Factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB CHI99LA128Accident · No injuriesLimited investigationFinal reportCessna T-188C · Dalton, NEthe improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.NTSB SEA98TA152Accident · Minor injuriesFinal reportCessna TU206G · Burns, ORFatigue failure of the crankshaft.NTSB LAX98LA232Accident · No injuriesLimited investigationFinal reportBeech A36TC · Boulder City, NVloss of engine power for undetermined reasons over unsuitable terrain.NTSB CHI98LA240Accident · No injuriesLimited investigationFinal reportCessna T188C · Austin, MNthe improper maintenance by other maintenance personnel. Factors were the throttle control not safetied, the crops, and unsuitable terrain encountered by the pilotNTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.NTSB LAX98LA122Accident · No injuriesLimited investigationFinal reportCessna TU206F · Avalon, CAContamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.NTSB ATL97LA099Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Destin, FLa loss of engine power for undetermined reasons.NTSB LAX97LA038Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Elk Grove, CAloss of engine power for undetermined reason(s) after takeoff. The lack of maintenance/annual inspection was a related factor.NTSB SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.NTSB FTW95TA187Accident · No injuriesFinal reportCessna 210J · Fabens, TXLoss of engine power due to water contamination of the fuel.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB FTW94LA107Accident · No injuriesLimited investigationFinal reportCessna 210L · Haskell, OKWas the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB MIA94LA014Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Fort Lauderdale, FLAn engine failure for undetermined causes over terrain unsuitable for a forced landing.NTSB NYC94LA006Accident · No injuriesLimited investigationFinal reportCessna T210F · Frederick, MDThe mechanic's inadequate inspection and the pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, resulting in a loss of engine power and a forced landing.NTSB SEA93LA177Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Cheyenne, WYAn undetermined loss of engine power.NTSB FTW92LA109Accident · No injuriesLimited investigationFinal reportCessna T188C · Cordel, OKThe animals in the landing area. A factor was the loss of engine power for undetermined reasons.NTSB SEA91LA189Accident · No injuriesLimited investigationFinal reportBeech V35A · Weiser, IDThe pilot did not refuel the airplane resulting in fuel exhaustion.NTSB CHI90DEM03Accident · No injuriesFinal reportCessna T188 · Williamsburg, MIA loss of engine power for undetermined reasons. The lack of suitable terrain for landing was a factor related to the accident.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…NTSB DEN87LA210Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Albuquerque, NMThe private plt was returning from a business flight. The plt reported that the engine quit during the approach to landing. An emergency landing was made in an open field. The right wing hit a sign and skidded to rest across a paved road and into another open…NTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…NTSB SEA85LA025Accident · No injuriesLimited investigationFinal reportCessna 414 · Waterville, WAUpon arrival at the dest arpt the plt elected to perform a touch & go landing in order to evaluate rwy braking action. During climb out after the touch & go at about 100 ft AGL and 100 to 105 KTS the acft yawed to the right as the nose picthed up. Despite…NTSB CHI84IA404Incident · No injuriesIncident investigationFinal reportBeech A36TC · Lafayette, INThe plt reported that when he leveled off at 3000 ft MSL, the aux fuel boost switch was still on, so he switched it 'off.' When the switch was turned off, the eng began to run with a bit of vibration, so he returned the switch to 'on' & left it in that…NTSB ANC84FA065Accident · No injuriesField investigationFinal reportCessna TP206D · Homer, AKThe eng quite once, but the plt was able to restart it by turning on the boost pump. He landed at 2 different arpts after the initial failure, once to refuel & drain the fuel tanks & once to check the fuel lines & components under the cowling. Aprx 1 hr after…NTSB NYC83LA240Accident · No injuriesLimited investigationFinal reportBeech 58P · Lebanon, NHAccording to the plt there was a sudden power fluctuation at(rotation speed). The plt then aborted the takeoff but couldnot stop the acft before departing the rwy.NTSB CHI83LA067Accident · No injuriesLimited investigationFinal reportCessna T210N · Cassville, WIThe pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…NTSB LAX83LVG05Accident · No injuriesFinal reportCessna TU206F · Franklin, CAFinal approach was slightly high & the student plt reduced power. As the throttle was advanced from 1400 RPM the eng quit. The acft touched down approximately 300 ft short of the rwy & rolled into a fence. The fence caught the nose gear & turned the acft…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 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…