NTSB investigations: Continental TSIO-520 series, 2006

5 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 per year

19822026
NTSB investigations: Continental TSIO-520 series, 2006 per year, 1982–2026: 143 cases
19826
19838
19848
198510
19864
19878
19888
19892
19907
19919
19924
19934
19945
19952
199610
19976
19982
19997
20003
20013
20022
20035
20047
20053
20065
20075

Latest cases

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 year(c.\"eventDate\") = 2006
    AND 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\" = 353))
  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 LAX07CA046Accident · No injuriesData collectionFinal reportCessna T210M · Las Vegas, NVfuel exhaustion due to the pilot's inadequate fuel consumption calculations and his failure to refuel the airplane during the cross-country flight,.Nov 24, 2006 · N977SA · Substantial damageNTSB DFW06CA134Accident · No injuriesData collectionFinal reportCessna P210N · Weslaco, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing,May 21, 2006 · N731RR · Substantial damageNTSB LAX06LA178Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Chico, CAThe loss of engine power due to the pilot's inadequate preflight inspection and failure to verify the amount of fuel onboard.May 18, 2006 · N212DW · Substantial damageNTSB CHI06CA118Accident · No injuriesData collectionFinal reportCessna T210L · Henryville, INThe pilot selected an empty fuel tank during the approach which resulted in fuel starvation and subsequent loss of engine power. A factor associated with the accident were the trees that the airplane contacted during the forced landing.Apr 21, 2006 · N732AN · Substantial damageNTSB ATL06CA042Accident · No injuriesData collectionFinal reportCessna T210N · Rome, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.Feb 1, 2006 · N2134U · Substantial damage