Fatal NTSB investigations: Continental TSIO-520 series
24 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 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.\"highestInjuryLevel\" = 'Fatal'
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\" = 230))
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."highestInjuryLevel" = 'Fatal'
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" = 230))
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 NYC07FA009Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Odenton, MDThe pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…NTSB ANC05FA090Accident · 3 fatalField investigationFinal reportCessna T207 · Nanwalek, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.NTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.NTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.NTSB LAX03FA037Accident · 1 fatalField investigationFinal reportBeech B36TC · Union City, CAthe pilot's failure to maintain an adequate terrain clearance altitude, which resulted in controlled flight into rising mountainous terrain. Contributing factors were the pilot's loss of situational awareness to his terrain proximity, the dark night, and the…NTSB DEN03FA002Accident · 1 fatalField investigationFinal reportCessna T210M · Laramie, WYthe pilot's improper inflight planning/decision, and his failure to maintain terrain clearance while attempting a low altitude maneuver. Contributing factors were the mountainous terrain, the airplane’s low altitude, and the pilot's lack of total instrument…NTSB LAX02FA049Accident · 1 fatalField investigationFinal reportCessna T210L · San Jacinto, CAThe pilot's loss of situational awareness and his failure to adhere to the prescribed instrument approach procedures, including the track and altitudes flown. The underlying reasons for the pilot's loss of situational awareness are unknown.NTSB FTW01LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-46-310P · Bulverde, TXthe pilot's failure to obtain airspeed after rotation, which resulted in a stall/mush. Contributing factors were the tailwind condition, high density altitude, and upsloping runway.NTSB CHI97FA102Accident · 2 fatalField investigationFinal reportCessna T210N · Vichy, MOfailure of the pilot to properly follow the missed approach procedure and maintain the minimum descent altitude (MDA) during night/IFR flight. Factors relating to the accident included: darkness, low ceiling, fog, and failure of the pilot to properly…NTSB LAX95LA257Accident · 1 fatalLimited investigationFinal reportCessna TU206 · Danville, CAThe pilot's intentional flight into known adverse weather and failure to maintain proper altitude.NTSB MIA91LA139Accident · 1 fatalLimited investigationFinal reportCessna TU-206G · Gulf Of MexicoAn in flight collision with the water for undetermined reasons.NTSB DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.NTSB LAX89FA081Accident · 1 fatalField investigationFinal reportCessna 414 · Pleasanton, CAFailure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.NTSB ANC88FA111Accident · 2 fatalField investigationFinal reportCessna 402B · Mt. Torbet, AKThe on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the…NTSB LAX87LA334Accident · 1 fatalLimited investigationFinal reportCessna 206 · Williams, AZThe aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled…NTSB DEN87FA023Accident · 5 fatalField investigationFinal reportBeech A36TC · Steamboat Sprgs, COPlt and four paxs were returning home from a ski vacation. A witness at the arpt observed a normal takeoff and saw the acft turn towards an area of high terrain located approximately 1.5 miles from the Steamboat arpt. The witness observed N36TS continue on a…NTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…NTSB DEN85FA026Accident · 1 fatalField investigationFinal reportCessna 340 · Las Vegas, NMThe pilot was carrying illegal cargo (marijuana) in N4001Q. During a low high speed pass at night over an intended landing area,the aircraft struck rising terrain. There was approximately 800 lbs of marijuana on the aircraft.NTSB LAX84FA469Accident · 2 fatalField investigationFinal reportCessna T210J · Valencia, CAWitnesses observed the acft entering a slow roll maneuver. As the acft became inverted, the roll rate decreased, the nose of the acft dropped toward the ground & the plane crashed. No preimpact part failure or malfunction was found. Toxicological checks of…NTSB NYC84FA294Accident · 2 fatalField investigationFinal reportCessna 414 · Wallingford, VTThe plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…NTSB CHI84FA053Accident · 3 fatalField investigationFinal reportCessna T210M · White Lk Twnshp, MIAt about 1600, the acft was taken out of a heated hangar & parked on the ramp for refueling. It remained outside until the plt took off at about 1740 EST. During that time, snow was falling & the temp dropped from 34 to 31 deg. The plt initially contacted the…NTSB DEN83FA027Accident · 2 fatalField investigationFinal reportCessna P210 · Sioux Falls, SDAt 1915 while enroute the plt was advised that the destination wx was 100 ft obscured, 3/8 mi in fog. At 2140 the plt contacted approach control & was advised the wx was 100 ft obscured & 1/8 mi with an RVR for rwy 3 of 2,400 ft. he was cleared for an ILS rwy…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 SEA82FYA08Accident · 1 fatalFinal reportCessna T210M · Shoshone, IDThe aircraft crashed in a near level attitude and at a high rate of speed. Neither the seat belt nor shoulder harness was fastened. The pilot's blood alcohol level was 236 mg%.