Fatal NTSB investigations: Cessna 401
17 cases on aircraft the registry lists as Cessna 401. 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 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2006 | 1 |
| 2012 | 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.aircraft_model_code IN ('207590C'))
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.aircraft_model_code IN ('207590C'))
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 CEN12FA290Accident · 4 fatalField investigationFinal reportCessna 401 · Chanute, KSThe malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB MIA92FA114Accident · 1 fatalField investigationFinal reportCessna 401 · New Port Richey, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering for a forced landing following an in flight left engine fire for undetermined reasons. Contributing to the accident was the pilot in command's inadvertent shutdown of the wrong engine.NTSB ATL91FA148Accident · 1 fatalField investigationFinal reportCessna 401 · Monroe, NCInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. The pilot's lack of familiarity with the aircraft fuel system was a related factor.NTSB MIA89WA212Accident · 1 fatalForeign investigationCessna 401 · Grand Turk Isl., Turks & Caicos IslandsNTSB SEA87MA018Accident · 2 fatalMajor investigationFinal reportCessna 401 · Henderson, NVApproximately 5 1/2 minutes after departure and while the aircraft was climbing enroute, an unknown ignition source triggered an explosion of fuel/air vapor which existed within the interior of the left wing. Wing skin from the upper/lower wing surface was…NTSB SEA86FA046Accident · 3 fatalField investigationFinal reportCessna 401 · S. Lake Tahoe, CAAcft took off in clear wx but below-freezing temps with heavy frost on acft surfaces. No preflight, run-up or warm-up performed. On initial climb, left eng power loss occurred for undet reason, but probably associated with temp/cold eng operation. Plt turned…NTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…NTSB CHI81FA070Accident · 5 fatalClosedCessna 401 · Muskegon, MINTSB FTW80FA114Accident · 1 fatalClosedCessna 401 · Houma, LANTSB FTW76AF011Accident · 3 fatalClosedCessna 401 · Austin, TXNTSB LAX75OL015Accident · 3 fatalClosedCessna 401 · Los Mochis, MexicoNTSB IAD70AI061Accident · 1 fatalClosedCessna 401 · Spruce Pine, NCNTSB CHI70AC040Accident · 5 fatalClosedCessna 401 · Piketon, OHNTSB NYC68A0136Accident · 6 fatalClosedCessna 401 · Mohrsville, PANTSB NYC68A0074Accident · 1 fatalClosedCessna 401 · Whitefield, NHNTSB MIA67A0088Accident · 1 fatalClosedCessna 401 · Anderson, SC