NTSB investigations: Continental TSIO-520 series, 2000
35 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
| 1966 | 3 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 12 |
| 1975 | 8 |
| 1976 | 22 |
| 1977 | 21 |
| 1978 | 37 |
| 1979 | 54 |
| 1980 | 44 |
| 1981 | 54 |
| 1982 | 60 |
| 1983 | 40 |
| 1984 | 44 |
| 1985 | 47 |
| 1986 | 55 |
| 1987 | 38 |
| 1988 | 29 |
| 1989 | 23 |
| 1990 | 26 |
| 1991 | 33 |
| 1992 | 24 |
| 1993 | 26 |
| 1994 | 35 |
| 1995 | 25 |
| 1996 | 34 |
| 1997 | 31 |
| 1998 | 23 |
| 1999 | 27 |
| 2000 | 35 |
| 2001 | 44 |
| 2002 | 39 |
| 2003 | 57 |
| 2004 | 42 |
| 2005 | 36 |
| 2006 | 56 |
| 2007 | 43 |
| 2008 | 38 |
| 2009 | 29 |
| 2010 | 48 |
| 2011 | 25 |
| 2012 | 27 |
| 2013 | 29 |
| 2014 | 22 |
| 2015 | 21 |
| 2016 | 20 |
| 2017 | 34 |
| 2018 | 29 |
| 2019 | 22 |
| 2020 | 26 |
| 2021 | 26 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 17 |
| 2025 | 25 |
| 2026 | 13 |
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 year(c.\"eventDate\") = 2000
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 year(c."eventDate") = 2000
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 LAX01LA065Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado City, AZthe pilot's improper preflight and failure to refuel the airplane.NTSB MIA01WA046Accident · Serious injuriesForeign investigationCessna 402B · Nosara, Costa RicaNTSB FTW01WA031Accident · Serious injuriesForeign investigationCessna T210N · Chihuahua, MexicoNTSB CHI01LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…NTSB LAX01FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Selma, CAThe pilot's improper decision to attempt a visual approach and landing in instrument meteorological conditions and his failure to follow instrument flight rules procedures.NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…NTSB CHI01LA005Accident · No injuriesLimited investigationFinal reportCessna T210N · Cahokia, ILaircraft control not being maintained by the inattentive pilot during the taxi. A factor to the accident was the soft terrain condition.NTSB NYC01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Marshfield, MAThe pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB CHI00LA291Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Moorehead, MNThe pilots failure to abort the takeoff and the airplane not attaining a proper climb rate for undetermined reasons.NTSB SEA00LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Council, IDthe fatigue failure of the crankshaft due to improper overhaul procedures. Factors include a soft area in the field where the forced landing took place.NTSB ATL00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Vero Beach, FLThe pilot's inability to control the aircraft after landing due to a loss of engine power and landing gear failure for undetermined reasons. A factor in the severity of the accident was the impact with the airport marker lights.NTSB ANC00LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area on the airstrip. Factors associated with this accident were the rough takeoff area, and the pilot's loss of directional control.NTSB FTW00LA231Accident · No injuriesLimited investigationFinal reportCessna T210L · Addison, TXthe electrical wire bundle fire during approach, which tripped the hydraulic motor circuit breaker resulting in collapse of the landing gear on landing.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 NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.NTSB MIA00FA208Accident · 1 fatalField investigationFinal reportCessna 402C · Vieques, PRThe airplanes entry into an uncontrolled descent for undetermined reasons from which it crashed into the ocean.NTSB MIA00LA207Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Boone, NCThe failure of the inter-cooler duct connecting the inter-cooler to the engine due to inadequate attachment of the inter-cooler to the aircraft which resulted in loss of turbocharger air overboard and loss of engine power and damage to the aircraft during a…NTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.NTSB LAX00FA213Accident · No injuriesField investigationFinal reportCessna 414A · Prescott Valley, AZThe pilot's physical impairment due to the cumulative effects of carbon monoxide from engine exhaust by-products, carbon monoxide from heavy tobacco use, and the loss of an undetermined amount of cabin pressurization. A factor in the loss of pressurization…NTSB SEA00LA090Accident · No injuriesLimited investigationFinal reportCessna T210M · Boise, IDThe deterioration and subsequent leakage of a hydraulic line which resulted in the total loss of hydraulic fluid and the inability of the pilot to extend the landing gear into the locked position.NTSB CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.NTSB ANC00LA061Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKAn in-flight collision with a bird.NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.NTSB DEN00LA077Accident · No injuriesLimited investigationFinal reportBeech A36TC · Monument Valley, UTFailure by the pilot to maintain control of the aircraft during landing roll. Factors were a dust devil/whirlwind and the pilot's lack of landing currency.NTSB FTW00RA128Accident · 7 fatalForeign investigationCessna TU206F · Nevaj, GuatemalaNTSB FTW00WA136Accident · No injuriesForeign investigationCessna 402B · San Jose, Costa RicaNTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.NTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.NTSB LAX00LA117Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Palo Alto, CAThe pilot's failure to obtain/maintain the proper visual glide path resulting in an undershoot and collision with the runway edge.NTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.NTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.NTSB NYC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Bradford, PAThe pilot's inadequate ice/frost removal from the aircraft.NTSB FTW00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Corning, ARThe loss of engine power for an undetermined reason. A factor was the dark night light condition.