Fatal NTSB investigations: Continental TSIO-520 series, ID
17 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
| 1980 | 1 |
|---|---|
| 1982 | 3 |
| 1994 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 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\" = 'ID' 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" = 'ID' 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 WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.NTSB WPR20FA206Accident · 8 fatalClass 3 · FieldFinal reportCessna TU206 · Coeur d'Alene, IDThe failure of the pilots of both airplanes to see and avoid the other airplane.NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB WPR15FA143Accident · 4 fatalField investigationFinal reportCessna T210M · Challis, IDThe pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.NTSB WPR14FA094Accident · 5 fatalField investigationFinal reportBeech B36TC · Yellow Pine, IDThe pilot’s continued flight into known light-to-moderate icing conditions over mountainous terrain. Contributing to the accident was the loss of engine power due to induction icing.NTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.NTSB WPR10FA459Accident · 2 fatalField investigationFinal reportCessna T210N · Coeur d'Alene, IDThe pilot’s continued flight into instrument meteorological conditions and failure to maintain clearance with mountainous terrain while maneuvering in an area of low cloud ceilings.NTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.NTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.NTSB SEA00FA142Accident · 1 fatalField investigationFinal reportCessna TU-206G · Pistol Creek, IDA loss of engine power due to the fracture of the #2 cylinder intake valve stem and the puncturing of the #2 piston dome by the intake valve head. Factors include no suitable landing site within the maneuvering abilities of the aircraft, and coniferous trees…NTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.NTSB SEA83FA057Accident · 1 fatalField investigationFinal reportCessna TU206G · Soda Springs, IDA search for the aircraft was begun after the pilot's relatives reported it was overdue and residents near the crash site heard the sounds of a low flying plane suddenly terminate. Unofficial reports of the weather indicated it was about 200 ft obscured, 1/4…NTSB SEA82FYA08Accident · 1 fatalFinal reportCessna T210M · Shoshone, IDThe aircraft crashed in a near level attitude and at a high rate of speed. Neither the seat belt nor shoulder harness was fastened. The pilot's blood alcohol level was 236 mg%.NTSB SEA82FA032Accident · 4 fatalField investigationFinal reportCessna P210N · Boise, IDAfter takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…NTSB SEA80FA024Accident · 1 fatalClosedCessna T210L · Pocatello, ID