NTSB investigations: Cessna 401, KS
5 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
| 1970 | 1 |
|---|---|
| 1984 | 2 |
| 2004 | 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.\"eventStateOrRegion\" = 'KS' 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 ('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."eventStateOrRegion" = 'KS' 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 ('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 CHI04LA264Accident · Minor injuriesLimited investigationFinal reportCessna 401 · New Century, KSA loss of engine power due to fuel starvation and the pilot's failure to maintain directional control during approach to an alternate airport. Contributing to the accident was the pilot's failure to obtain a weather briefing, his flight into adverse weather,…NTSB MKC84LA238Accident · No injuriesLimited investigationFinal reportCessna 401 · Hutchinson, KSWhile taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter…NTSB MKC84LA117Accident · No injuriesLimited investigationFinal reportCessna 401 · Wichita, KSThe plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had…NTSB MKC71FCQ15Accident · No injuriesClosedCessna 401 · Baxter Sprgs, KS