NTSB investigations: Continental TSIO-520 series, TX
13 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 4 |
| 1996 | 3 |
| 1997 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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.
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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" 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 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,NTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.NTSB FTW01LA096Accident · No injuriesLimited investigationFinal reportCessna T210M · Abilene, TXthe loss of engine power while on final approach due to fuel starvation as a result of the pilot's improper use of the fuel selector. A contributing factor was the elevated runway edge.NTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.NTSB FTW97LA037Accident · No injuriesLimited investigationFinal reportCessna T210N · Grand Prairie, TXfailure of the pilot to ensure that the fuel selector was positioned to a tank with sufficient fuel, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's inadequate preflight, false indication from the…NTSB FTW96LA397Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Lonestar, TXThe loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.NTSB FTW96TA186Accident · No injuriesFinal reportCessna T210N · Beaumont, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW86FRA02Accident · Minor injuriesFinal reportCessna T210N · Houston, TXThe acft crashed in a wooded area during a forced landing after fuel exhaustion. The acft had extra fuel cans on board and had been flying for almost 12 hours in an attempt to avoid capture by U.S. Agents for the possession of marijuana. The acft contained…NTSB FTW85LA296Accident · No injuriesLimited investigationFinal reportCessna T210M · Kilgore, TXThe plt was to ferry the acft from mena, AR, to jacksonville, TX. During pre-flt he discovered the fuel gages were inop and a visual check of the fuel quantity was made. The plt estimated sufficient fuel remained in the tanks to complete the 50 minute flt. En…NTSB FTW85LA286Accident · No injuriesLimited investigationFinal reportCessna T210N · College Station, TXAbout 25 minutes after takeoff from a planned intermediate stop, the right fuel tank ran dry. After switching tanks, theplt decided to divert to a nearby arpt to refuel. During the descent, the left fuel tank ran dry and the eng quit due to fuel exhaustion.…NTSB FTW85FA257Accident · Minor injuriesField investigationFinal reportCessna T210N · Mineral Wells, TXThe pilot experienced engine power failure due to fuel exhaustion for unknown reasons since about 30 gallons of fuel should have been on board when the crash occurred. The pilot was vectored toward the nearest airport but was unable to reach it and crashed…NTSB FTW84LA096Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Port Arthur, TXThe acft crash landed in a muddy field about 1 mile from the arpt after the engine quit on final approach to land. The acft was examined after the accident and found to have an empty left fuel tank. The right tank contained 16 gallons of fuel. The plt stated…NTSB FTW83LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Midland, TXThe pilot advised Midland approach control that he was out of fuel over the west side of Midland, TX at 4800 feet. The aircraft was observed to disappear from the radar approximately 1/4 to 1/2 mile north of the airport. The pilot stated he ran the tanks dry.