NTSB investigations: Continental TSIO-520 series, KY
11 cases on aircraft whose registry engine model is Continental TSIO-520 series. 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
| 1978 | 1 |
|---|---|
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 3 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2017 | 1 |
| 2023 | 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\" = 'KY' 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'))
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" = 'KY' 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'))
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 WPR23LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Springfield, KYThe pilot’s failure to activate the pitot heat in a timely manner during flight into icing conditions, which resulted in a temporary failure of the flight instruments and a subsequent loss of control.NTSB ERA17FA180Accident · 2 fatalField investigationFinal reportBeech A36TC · Hopkinsville, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…NTSB NYC08LA152Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Louisville, KYThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin.NTSB MIA08FA027Accident · 2 fatalField investigationFinal reportCessna T210N · Bloomfield, KYthe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight break up. Contributing to the accident was the pilot's loss of control in-flight due to spatial disorientation.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB NYC97LA035Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Lexington, KYfailure of #5 exhaust valve and/or #5 exhaust valve guide, which resulted in a progressive engine failure (debris puncturing the #5 piston crown, exhaust gasses entering the crankcase, loss of oil through the breather system, oil exhaustion, and subsequent…NTSB IAD97LA005Accident · No injuriesLimited investigationFinal reportCessna T210M · Mentor, KYthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB NYC92FA150Accident · 1 fatalField investigationFinal reportCessna 340 · Falmouth, KYThe improper decision by the non-instrument-rated pilot to attempt VFR flight into instrument meteorological conditions resulting in a loss of airplane control and subsequent inadvertent spiral and collision with the ground. Factors related to the accident…NTSB IAD78FLQ36Accident · No injuriesClosedCessna T210M · Owensboro, KY