NTSB investigations: Continental TSIO-520 series, CA
14 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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\" = '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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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" = '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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 SEA08LA021Accident · 3 fatalLimited investigationFinal reportCessna 340 · Garberville, CAThe pilot's intentional visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the trees and terrain during climb. Contributing to the accident were the weather conditions of fog and a low…NTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.NTSB LAX05FA132Accident · 3 fatalField investigationFinal reportCessna T210L · Tranquility, CAthe pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…NTSB LAX05FA092Accident · 2 fatalField investigationFinal reportCessna P210N · Lebec, CAthe pilot's in-flight loss of control due to the flight's encounter with unforecasted localized mountain wave activity with severe to potentially extreme turbulence, downdrafts, and rotors.NTSB LAX03FA182Accident · 5 fatalField investigationFinal reportBeech A36TC · Los Angeles, CAthe pilot's in-flight loss of control due to spatial disorientation, and failure to maintain airspeed, which resulted in a stall/spin. Also causal was the pilot's disregard of the weather information provided and his attempt to continue VFR flight into IMC. A…NTSB LAX03FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Mather, CAloss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…NTSB LAX91FA117Accident · 1 fatalField investigationFinal reportBeech 58P · Green Valley, CAThe pilot's loss of aircraft control due to his disregard for and poor evaluation of significant weather advisories forecasting adverse weather conditions along the route of flight and the pilot's decision to initiate the flight.NTSB LAX91FA066Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAThe failure of the pilot-in-command to maintain control of the airplane while flying in instrument meteorological conditions and spatial disorientation of the pilot-in-command. Contributing to the accident was diversion of the pilot's attention to…NTSB LAX87FA267Accident · 4 fatalField investigationFinal reportCessna T210L · Marina Del Rey, CAWeather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.…NTSB LAX86FA140Accident · 3 fatalField investigationFinal reportBeech A36TC · Woodfords, CAThe wx deteriorated while the acft was cruising in IMC at 17,000 ft. moderate turbulence & icing conditions in the layered clouds were reported by other nearby flying acft. The plt informed ARTCC that he 'lost the autopilot,' & the acft's course began…NTSB LAX85LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Gorman, CAThe acft collided with high tension wires about 5 miles south of Gorman, CA. The plt stated that while enroute he 'stayed beneath' the prevailing broken cloud condition until entering the mountainous area at which time he saw a hole in the clouds & began to…NTSB LAX83FA348Accident · 2 fatalField investigationFinal reportCessna T210N · Watsonville, CAThe plt, who was a contractor, was scheduled to attend a heavy equip't auction in sacramento to begin a 1000. Witnesses heard normal eng sounds as the acft departed rwy 19 & turned to a left downwind departure turn. The acft was observed proceeding on a NE…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…