NTSB investigations: Continental TSIO-520 series, 2006
10 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 per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1986 | 1 |
| 1987 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 10 |
| 2003 | 12 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 10 |
| 2007 | 3 |
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\") = 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\" = 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 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" = 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 CHI07LA038Accident · No injuriesLimited investigationFinal reportBeech B36TC · Peoria, ILThe loss of engine power due to a fatigue fracture of the exhaust valve as a result of maintenance not performed by the aircraft owner, and the unsuitable terrain encountered during the forced landing.NTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.NTSB CHI07LA018Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Chester, ILThe fatigue failure of the turbocharger shroud which resulted in oil starvation to the engine. A factor was the muddy field.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB DFW06LA188Accident · 1 fatalLimited investigationFinal reportCessna P210N · Amarillo, TXThe loss of engine power as result of the failure by maintenance personnel to install oil pump support bushings, which resulted in the fracture of the driven-gear and subsequent loss of oil pressure. Contributing factors were the lack of suitable terrain for…NTSB DEN06FA091Accident · 2 fatalField investigationFinal reportBeech A36TC · Montrose, COthe pilot's inadequate preflight planning/decision by not having the airplane refueled prior to takeoff, and allowing the engine to be starved of fuel because he failed to switch the fuel selector valve. A contributing factor was the flight instructor's…NTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.NTSB DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.NTSB MIA06LA108Accident · No injuriesLimited investigationFinal reportCessna 414A · Pompano Beach, FLThe pilot's inadequate preflight/planning due to his failure to assure an adequate supply of fuel was available for the flight, resulting in the loss of engine power in both engines due to fuel exhaustion.NTSB SEA06FA054Accident · 1 fatalField investigationFinal reportBeech 58P · Bow, WAThe pilot's failure to maintain aircraft control during the climb to cruise. Contributing factors included a loss of engine power to the right engine folowing a turbocharger failure, instrument meteorological and dark night conditions.