Fatal NTSB investigations: Continental I0-470 series, TN
8 cases on aircraft whose registry engine model is Continental I0-470 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 |
|---|---|
| 1987 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2018 | 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\" = 'TN' 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 ('17027'))
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" = 'TN' 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 ('17027'))
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 ERA24FA058Accident · 2 fatalClass 3 · FieldFinal reportBeech 35-C33 · Pulaski, TNThe pilot’s failure to maintain airplane control, which resulted in pilot-induced oscillations and a subsequent loss of control and impact with terrain.NTSB ANC18FA022Accident · 1 fatalField investigationFinal reportBeech 35 A33 · Helenwood, TNThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow the air start checklist.NTSB ATL04FA079Accident · 2 fatalField investigationFinal reportCessna 210 · Blountville, TNThe pilot's improper flare, and improper recovery which resulted in a bounced landing, collapse of the left main landing gear, and the pilot's failure to maintain airspeed while maneuvering resulting in a stall, uncontrolled descent, and collision with the…NTSB ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.NTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.NTSB MIA00FA069Accident · 1 fatalField investigationFinal reportBeech P-35 · Rogersville, TNthe pilot's improper in-flight planning/decision and continued visual flight into instrument meteorological conditions (IMC) that resulted in an in-flight collision with terrain and subsequent damage to the aircraft.NTSB ATL87FA064Accident · 2 fatalField investigationFinal reportCessna 310P · Memphis, TNThe plt reported an engine problem inside the outer marker to runway 31. The acft impacted the ground in a nose low attitude. The wreckage examination failed to disclose any system malfunction or failure. The acft was destroyed by impact forces, and a post…NTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TN