NTSB investigations: Cessna 414, TX
9 cases on aircraft the registry lists as Cessna 414. 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
| 1973 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1989 | 1 |
| 1999 | 1 |
| 2007 | 1 |
| 2014 | 2 |
| 2025 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075908'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2075908'))
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 CEN25LA362Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · New Braunfels, TXA in-flight collision with a bird during the descent for landing.NTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.NTSB CEN14CA295Accident · Minor injuriesData collectionFinal reportCessna 414 · Pleasanton, TXThe pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.NTSB DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB FTW99LA241Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Alpine, TXThe pilot's improper use of the emergency fuel boost pump, which resulted in excessive fuel flow to the engine and subsequent total loss of left engine power. Factor's were the high density altitude, the pilot exceeding the airplane's weight and balance, the…NTSB FTW90FA013Accident · Serious injuriesField investigationFinal reportCessna 414 · San Antonio, TXThe failure of the right propeller unfeathering accumulator hose due to improper installation and chaffing, and the pilot's operation of the airplane beyond its engine out performance capability. Factors were inadequate company maintenance, and the pilot's…NTSB FTW82AA299Accident · 12 fatalFinal reportRobertson C-414 · Lindale, TX7-Seat acft took off with 4 adults & 8 children aboard. Acft rotated at about 2000 ft down rwy & climbed in a flat nose high attitude before settling into 30 ft trees about 4223 ft from point of lift-off. Acft oscillated violently 2 or 3 times in the pitch…NTSB FTW81FQG31Accident · No injuriesClosedCessna 414 · Wink, TXNTSB FTW73DRG68Accident · No injuriesClosedCessna 414 · Austin, TX