Fatal NTSB investigations: Continental TSIO-520 series, NM
12 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
| 1980 | 1 |
|---|---|
| 1984 | 2 |
| 1988 | 3 |
| 1991 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND 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'))
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" = 'NM' AND c."eventCountry" = 'USA'
AND 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'))
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 WPR23FA275Accident · 1 fatalClass 3 · FieldFinal reportCessna T310R · Santa Fe, NMA total loss of left engine power as a result of improper installation of the aft-facing crankshaft counterweight retaining rings. Also causal was the pilot’s failure to maintain adequate airspeed following the loss of left engine power, which resulted in the…NTSB CEN10FA324Accident · 5 fatalField investigationFinal reportCessna T310R · Ruidoso, NMThe pilot did not maintain proper airspeed on final approach for landing, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s limited experience in the airplane make and model.NTSB DEN07FA165Accident · 1 fatalField investigationFinal reportCessna T210M · Moriarty, NMthe instructor pilot's failure to maintain aircraft control during aborted landing and attempted go-around which resulted in an inadvertent elevator trim stall. Contributing to the accident were the instructor pilot's inadequate supervision during the…NTSB DEN99FA137Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMThe pilot's failure to maintain sufficient airspeed during final approach to landing, resulting in an inadvertent stall. A factor was the high density altitude.NTSB FTW98FA393Accident · 1 fatalField investigationFinal reportCessna T310R · Pie Town, NMThe pilot's continuing VFR flight into instrument meteorological conditions. Contributing factors were weather conditions, that included clouds, and mountainous terrain.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 DEN89FA009Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMBefore dawn, witnesses (who were preflighting an acft) saw N732QP taxiing to rwy 4. They heard an eng run-up; however, they were unable to see the acft takeoff due to heavy fog that had just moved over the arpt. (The witnesses decided to cancel their flt due…NTSB DEN88FA111Accident · 1 fatalField investigationFinal reportCessna T210N · Seboyeta, NMThe plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a…NTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMNTSB DEN85FA034Accident · 4 fatalField investigationFinal reportCessna P206 · Wagon Mound, NMPlt received 3 wx briefings before flt and informed of possibility of diminishing conditions. Acft collided with terrain 1 1/2 mi from I-25 that goes from raton to albuquerqe. Local residents described wx at aprx time of accident as heavy snow, high winds,…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 DEN80AA023Accident · 4 fatalClosedCessna TU206G · Clovis, NM