NTSB investigations: Continental TSIO-520 series, WI
22 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
| 1979 | 1 |
|---|---|
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2001 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2015 | 1 |
| 2017 | 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\" = 'WI' 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" = 'WI' 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 CEN22FA021Accident · 1 fatalClass 3 · FieldFinal reportBeech B36TC · Lena, WIImpairment and subsequent incapacitation of the pilot for reasons that could not be determined. The incapacitation resulted in a loss of engine power due to fuel starvation. Likely contributing was pilot hypoxia due to altitude exposure, possibly worsened by…NTSB CEN20LA179Accident · 1 fatalClass 3 · LimitedFinal reportCessna P210 · Burlington, WIThe pilot did not maintain a safe altitude during the visual approach, and subsequently lost control which resulted an impact with trees and terrain.NTSB CEN17CA114Accident · No injuriesData collectionFinal reportCessna 340A · Waukesha, WIThe pilot’s decision to fly in in conditions conducive to structural icing and her subsequent failure to maintain airplane control during the instrument approach.NTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB CEN11CA128Accident · No injuriesData collectionFinal reportCessna 340A · Madison, WIThe pilot's failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure to check the de-ice fluid level prior to takeoff, which resulted in the failure of the de-ice…NTSB CEN10CA460Accident · No injuriesData collectionFinal reportCessna T210M · Shell Lake, WIThe collision with the deer during landing roll.NTSB CEN10IA059Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Elk Mound, WIThe loss of engine power due to component failure from excessive heating of the engine connecting rod journals.NTSB CEN09LA095Accident · No injuriesLimited investigationFinal reportCessna 402 · Madison, WIThe pilot’s improper fuel management, which resulted in a loss of engine power during an instrument landing due to fuel exhaustion.NTSB CHI07LA135Accident · No injuriesLimited investigationFinal reportCessna 414A · Sturgeon Bay, WIWorn brakes which resulted in an overrun during landing. A fence was a factor.NTSB CHI05FA016Accident · 2 fatalField investigationFinal reportCessna P210N · Wautoma, WIThe pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…NTSB CHI01LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Milwaukee, WIthe rich fuel mixture and the unsuitable landing area encountered by the pilot. Contributing factors were the high output of the fuel pump and the low altitude.NTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.NTSB CHI97LA087Accident · No injuriesLimited investigationFinal reportCessna T210 · Janesville, WIthe pilot inadvertently retracting the landing gear during the takeoff roll.NTSB NYC95FA056Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Chippewa Falls, WIThe pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…NTSB CHI94LA221Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Land O'Lakes, WIthe pilot's failure to maintain clearance with trees. Factors in the accident were the trees, the pilot's operation with known deficiencies in equipment, and the pilot's diverted attention.NTSB CHI93LA040Accident · No injuriesLimited investigationFinal reportCessna 401B · Rice Lake, WIImproper rigging of the right main landing gear retract bellcrank by other maintenance personnel.NTSB CHI91LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIInadequate visual outlook by the PIC.NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB CHI83LA067Accident · No injuriesLimited investigationFinal reportCessna T210N · Cassville, WIThe pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…NTSB CHI81DA017Accident · No injuriesClosedBeech 58TC · Elkhart Lake, WINTSB CHI79FA027Accident · 1 fatalClosedBeech 58P · Waukesha, WI