Fatal NTSB investigations: Continental IO-360 series, TX
13 cases on aircraft whose registry engine model is Continental IO-360 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2016 | 1 |
| 2019 | 2 |
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\" = 'TX' 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 ('17025', '17045'))
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" = 'TX' 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 ('17025', '17045'))
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 CEN19FA155Accident · 1 fatalClass 3 · FieldFinal reportCessna R172 · Mertzon, TXThe pilot's loss of control due to spatial disorientation.NTSB CEN19FA094Accident · 4 fatalField investigationFinal reportCessna T337 · Longview, TXThe noninstrument-rated pilot's improper decision to continue flight into convective weather conditions, which resulted in the airplane exceeding its maximum maneuvering speed and the subsequent in-flight breakup. Contributing to the accident was the pilot's…NTSB CEN16FA111Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Navasota, TXThe flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…NTSB DFW05FA192Accident · 2 fatalField investigationFinal reportAero Commander 112 · Junction, TXThe pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.NTSB FTW01FA104Accident · 1 fatalField investigationFinal reportCessna 402B · Del Rio, TXthe loss of control due to a jammed trim tab, which resulted from the failure of maintenance personnel to properly secure the trim tab actuator rod when installing a replacement elevator.NTSB FTW97LA353Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · San Marcos, TXThe pilot's loss of control while performing aerobatics resulting in an inadvertent stall/spin. A factor was the lack of altitude available for recovery.NTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.NTSB FTW90GA088Accident · 1 fatalFinal reportCessna 337G · Notrees, TXThe pilot's decision to continue VFR flight into known IMC.NTSB FTW89FA073Accident · 4 fatalField investigationFinal reportCessna 172XP · Hondo, TXThe pilot's decision to depart into known adverse weather and his lack of instrument training and experience.NTSB FTW83AA024Accident · 4 fatalFinal reportPiper PA-31P · Carrollton, TXA PA-31, N100FD, was being vectored by dfw approach control (apch ctl) for a landing on rwy 13L at dallas-love fld. The plt's last received & acknowledged instructions were to descend & maintain 2000' & turn left to 190 deg. Simultaneously,a Cessna 337,…NTSB FTW81FA134Accident · 2 fatalClosedCessna R172E · Bishop, TXNTSB FTW79FA062Accident · 1 fatalClosedCessna R172K · Uvalde, TXNTSB FTW79FA037Accident · 2 fatalClosedCessna 172XP · Abilene, TX