NTSB investigations: Continental TSIO-520 series

66 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the defining event was Loss of engine power (total). 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
  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 CEN10LA512Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Houma, LAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 31, 2010 · N210PR · Substantial damageNTSB CEN10LA482Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Put-in-Bay, OHA total loss of engine power while on final approach for undetermined reasons.Aug 13, 2010 · N14AW · Substantial damageNTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.Jul 29, 2010 · N2085J · Substantial damageNTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…Jun 21, 2010 · N30266 · Substantial damageNTSB CEN10LA235Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · El Paso, TXA loss of engine power for undetermined reasons.Apr 30, 2010 · N3692Q · Substantial damageNTSB WPR10LA196Accident · No injuriesLimited investigationFinal reportCessna P210N · Leavenworth, WAThe failure of the number two cylinder exhaust and intake valves for undetermined reasons, which resulted in a loss of engine power.Apr 4, 2010 · N3599P · Substantial damageNTSB CEN10FA180Accident · 2 fatalField investigationFinal reportBeech B36TC · Dayton, OHThe complete loss of engine power due to failure of the No. 1 main bearing, and the secondary failure of a crankcase through-bolt and the fuel pump drive coupling. Contributing to the accident was the pilot's decision to attempt a return to the airport for a…Apr 1, 2010 · N4BA · DestroyedNTSB ERA10LA159Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Arcadia, FLThe total loss of engine power due to a fatigue fracture of the crankshaft resulting from worn bearings.Mar 3, 2010 · N4797K · Substantial damageNTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.Feb 18, 2010 · N731DS · Substantial damageNTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.Nov 13, 2009 · N667PC · Minor damageNTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.Oct 18, 2009 · N7217S · Substantial damageNTSB WPR09LA170Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Madera, CAA total loss of engine power during the initial climb due to fuel exhaustion as a result of the pilot's failure to properly monitor the airplane's fuel quantity and to correctly ascertain the fuel on board the airplane prior to takeoff.Mar 28, 2009 · N2445S · Substantial damageNTSB LAX08LA292Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CAA loss of engine power while maneuvering due to the disintegration of the number two main bearing, which resulted in a fracture of the crankshaft. Contributing to the accident was inadequate maintenance.Sep 10, 2008 · N6278C · Substantial damageNTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.Mar 29, 2008 · N4839P · Substantial damageNTSB LAX08LA073Accident · No injuriesLimited investigationFinal reportCessna 402C · Mercury, NVA loss of power to both engines resulting from a fitting failure and leak at the right fuel selector valve that allowed fuel from the right tank to be lost overboard, and that then introduced air into the left engine's fuel lines during an attempted…Mar 11, 2008 · N594DM · Substantial damageNTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.Mar 3, 2008 · N234MT · Substantial damage