Fatal NTSB investigations: Continental TSI0-470-B
10 cases on aircraft whose registry engine model is Continental TSI0-470-B. 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
| 1967 | 1 |
|---|---|
| 1973 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 2012 | 1 |
| 2018 | 1 |
| 2020 | 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 ('17029'))
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 ('17029'))
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 CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB WPR18FA186Accident · 1 fatalClass 3 · FieldFinal reportCessna 320 · Eagle Mountain, UTThe pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…NTSB MKC88FA119Accident · 4 fatalField investigationFinal reportCessna 320 · Atwood, KSThe PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx…NTSB CHI86FA041Accident · 1 fatalField investigationFinal reportCessna 320 · Ada, OHThe pilot overflew a planned intermediate stop before running low on fuel. He was unable to find the airport he was being vectored to & attempted to land in a plowed field during dark conditions. As the aircraft passed over powerlines the aircraft was…NTSB LAX81FA020Accident · 2 fatalClosedCessna 320C · Marysville, WANTSB OAK77FA030Accident · 1 fatalClosedCessna 320C · Wells, NVNTSB CHI74FEE26Accident · 1 fatalClosedCessna 320 · Northbrook, ILNTSB NYC68A0045Accident · 6 fatalClosedCessna 320 · Bronx, NY