NTSB investigations: Continental TSIO-520 series, 2024
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
| 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\") = 2024
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") = 2024
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 GAA25WA036Accident · Serious injuriesClass 5 · ForeignCessna 340A · Magny-lès-Villers, FranceNTSB CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB ERA25LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Ball Ground, GAThe pilot and the flight instructor’s failure to maintain control of the airplane during a simulated loss of engine power during takeoff, which resulted in a runway excursion, and collision with a taxiway sign.NTSB GAA25WA016Accident · Serious injuriesClass 4 · ForeignCessna 340A · Saint-Denis-de-l'Hôtel, FranceNTSB CEN25LA048Accident · No injuriesClass 4 · LimitedFinal reportBeech 58TC · International Falls, MNThe pilot’s loss of directional control during landing.NTSB ERA24LA386Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boston, MAThe failure of a solid hydraulic fluid line, which resulted in a loss of hydraulic fluid that prevented the landing gear extension process from completing normally. Contributing to the outcome was the pilot’s failure to fully activate the emergency landing…NTSB ERA24FA305Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 402 · Easton, MDOn July 16, 2024, about 0932 eastern daylight time, a Cessna 402B, N7875E, was substantially damaged when it was involved in an accident near Easton, Maryland. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA24FA301Accident · 1 fatalClass 3 · FieldFinal reportCessna 402B · Aguadilla, PRThe pilot’s decision to operate the airplane with known maintenance discrepancies, which resulted in a total loss of right engine power. Contributing to the outcome was the pilot’s failure to maintain airspeed while returning to the airport with a single…NTSB CEN24LA329Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Leadville, COA loss of brake fluid for reasons that could not be determined, which resulted in a loss of braking effectiveness during landing.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB CEN24FA240Accident · 2 fatalClass 3 · FieldFinal reportCessna 414A · McKinney, TXThe pilot's improper decision to attempt continued flight after a loss of left engine power with usable runway remaining and his subsequent failure to follow the emergency procedures and maintain air minimum control speed, which resulted in a loss of control.…NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.NTSB WPR24LA157Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Daggett, CAThe pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…NTSB WPR24LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Placerville, CAThe pilot’s loss of directional control during the landing roll.NTSB WPR24LA126Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Auburn, WAAn overstress fracture of the left main landing gear actuator, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB GAA24WA141Accident · 1 fatalClass 5 · ForeignCessna T210M · Leeds, United Kingdom