Fatal NTSB investigations: Continental TSIO-520 series, OH
8 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
| 1985 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2010 | 1 |
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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'OH' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 CEN10FA180Accident · 2 fatalField investigationFinal reportBeech B36TC · Dayton, OHThe complete loss of engine power due to failure of the No. 1 main bearing, and the secondary failure of a crankcase through-bolt and the fuel pump drive coupling. Contributing to the accident was the pilot's decision to attempt a return to the airport for a…NTSB IAD97FA064Accident · 2 fatalField investigationFinal reportCessna 414 · Hillsboro, OHfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an advertent stall and collision with trees, vehicles, and the terrain.NTSB BFO95FA028Accident · 1 fatalField investigationFinal reportCessna T210M · Youngstown, OHloss of engine power for undetermined reason(s). Factors relating to the accident were: the weather conditions (restricted visibility with snow falling), reduced light condition at dusk, and the lack of suitable terrain for an emergency landing.NTSB NYC94FA067Accident · 1 fatalField investigationFinal reportCessna 414 · Defiance, OHThe pilot's inadequate inflight decision and planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB BFO94FA032Accident · 1 fatalField investigationFinal reportBeech BE-58 · Newtown, OHFailure of the pilot to maintain control of the aircraft after becoming spatially disorientated in night instrument meteorological conditions (IMC). Factors related to the accident were: the pilot's lack of experience in the type of operation, his lack of…NTSB NYC92FA029Accident · 5 fatalField investigationFinal reportCessna 340 · Columbus, OHThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in the loss of airplane control. Factors related to the accident were: the pilot's improper management of the fuel system; the pilot's lack of proficiency in…NTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHNTSB CHI85FA158Accident · 1 fatalField investigationFinal reportCessna T210N · Ravenna, OHThe plt departed port columbus uneventfully, flew for aprx 40 mins then shot a VOR apch to the mda at portage county. This fld does not have a wx reporting facility. The plt then performed a missed apch upon reaching mda. During the missed apch and after…