NTSB investigations: Continental TSIO-520 series, 1982, CA
9 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 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 7 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 9 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 9 |
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 9 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 7 |
| 2013 | 4 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 7 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 8 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 1982
AND c.\"eventStateOrRegion\" = 'CA' 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 year(c."eventDate") = 1982
AND c."eventStateOrRegion" = 'CA' 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 LAX83LVG05Accident · No injuriesFinal reportCessna TU206F · Franklin, CAFinal approach was slightly high & the student plt reduced power. As the throttle was advanced from 1400 RPM the eng quit. The acft touched down approximately 300 ft short of the rwy & rolled into a fence. The fence caught the nose gear & turned the acft…NTSB LAX82DA302Accident · No injuriesFinal reportBeech 58TC · Oakland, CAN17841, landed with the landing gear retracted at metropolitan Oakland airport. The pilot claims that the landing gear was lowered prior to landing. Efforts to reach the pilot for further comments concerning this flight were unsuccessful.NTSB LAX82FVD20Accident · No injuriesFinal reportCessna 210 · Livermore, CAApproximately 4 to 5 minutes after takeoff the eng failed. The acft struck a fence while attempting to return to the airport. The right fuel tank gauge indicated 30 gals & the right tank was found empty. The left fuel tank gauge indicated 10 gals & it…NTSB LAX82DA246Accident · No injuriesFinal reportCessna T210L · South Lake Taho, CAThe pilot reported that during a landing, the aircraft bounced, came down, bounced again and ballooned. At that moment, he elected to go around. He stated that he advanced the throttle and retracted the gear to reduce drag, but the engine died and the plane…NTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The…NTSB LAX82FA203Accident · No injuriesField investigationFinal reportCessna T210N · Llano, CAThe pilot stated that when he attempted to extend the gear with the normal system, it would not operate. He stated that he cycled the gear handle 4 or 5 times and checked the circuit breakers. Reportedly, he tried to extend the gear with the hand pump but it…NTSB LAX82FA168Accident · 2 fatalField investigationFinal reportCessna T210M · Mt. Wilson, CAAt the fss the plt requested the current & forecast salt lake city wx. The wx was furnished & the specialist advised that VFR flt was not recommended. The plt did not wish a full briefing & was heard to say to his passenger "let's go check it out." The acft…NTSB LAX82FA109Accident · 3 fatalField investigationFinal reportCessna 340A · 12 N.E. Burbank, CAAfter takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft…NTSB LAX82DVG12Accident · Serious injuriesFinal reportCessna P210N · Napa, CADuring his approach for landing, the pilot became concerned about other aircraft taxiing near the runway. He reported that his landing procedure was interrupted as he was waiting for one of the planes to stop short of the runway. Also, he reported aborting…