NTSB investigations: Cessna 421C, 2017
4 cases on aircraft the registry lists as Cessna 421C. 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 |
|---|---|
| 1977 | 2 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 7 |
| 1995 | 8 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 3 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 5 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076016', '2076017'))
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 year(c."eventDate") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076016', '2076017'))
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 ERA18LA033Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Presque Isle, METhe in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing.NTSB CEN17FA248Accident · 6 fatalField investigationFinal reportCessna 421C · Catawba, WIA loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.NTSB CEN17FA167Accident · 1 fatalField investigationFinal reportCessna 421C · Huntsville, TXThe pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined…NTSB WPR17LA051Accident · No injuriesLimited investigationFinal reportCessna 421C · Jackson, CAThe failure of the right main landing gear torque link bolt in overstress, which resulted in the collapse of the landing gear during the landing roll.