NTSB investigations: Continental TSIO-520 series, 1985
10 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 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 7 |
| 1991 | 9 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 10 |
| 1997 | 6 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 5 |
Where
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\") = 1985
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 year(c."eventDate") = 1985
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 LAX86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 335 · Yuba City, CAUpon completing a 35 min sight-seeing flight the plt entered the traffic pattern & prepared for landing. While descending, both engines lost all power. The plt stated that he repositioned the fuel selectors to the aux tanks, power was restored to the left…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 DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…NTSB SEA85LA205Accident · Minor injuriesLimited investigationFinal reportCessna T210-M · Camano Island, WAThe plt failed to visually verify the fuel on board prior to takeoff and he was aware that one fuel gage was inaccurate.a total loss of pwr occurred over water aprx 30 miles from the intended destination arpt. The plt was able to reach land during the…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 LAX85LA257Accident · Serious injuriesLimited investigationFinal reportCessna T303 · Mesa, AZPlt took off from scottsdale at 1934 MST for a 13 NM flt to reposition the acft to home base. Within minutes the plt advised ATC that he was 6 mi out with minimum fuel and requested no delay. He then asked for clearance to rwy 22R and was cleared to land on…NTSB CHI85LA141Accident · No injuriesLimited investigationFinal reportCessna T210L · Sauk Village, ILDuring a night preflight the fuel quantity was visually checked and the plt estimated each tank contained 35 gals. The left fuel guage indicated 220 pounds and the right guage was inop. After aprx 1 hour 50 minutes of flt time a total loss of power occurred.…NTSB LAX85FA102Accident · Serious injuriesField investigationFinal reportCessna T210L · Hesperia, CAThe plt reptd that shortly after entering the downwind leg for ry 03 he completed the prelanding checklist. While on final approach the acft experienced a total loss of engine powe. The acft altitude was too low to negotiate a landing on the ry & the plt…