NTSB investigations: Cessna 421C, 1995
8 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\") = 1995
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") = 1995
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 FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB CHI96FA017Accident · 1 fatalField investigationFinal reportCessna 421C · Battle Creek, MIthe pilot's decision to fly in adverse weather (icing) conditions; the accumulation of airframe ice; and the pilot's failure to maintain adequate airspeed for the situation, which resulted in a loss of aircraft control. The icing condition was a related…NTSB LAX95FA321Accident · 2 fatalField investigationFinal reportCessna 421C · Phoenix, AZThe pilot's failure to maintain positive aircraft control, a proper airspeed and fly a proper approach path during final approach. Contributing factors to the accident were the pilot's physiological condition, impairment as a result of using a sedating…NTSB LAX95FA319Accident · 8 fatalField investigationFinal reportCessna 421C · Beaver Dam, AZFailure of the pilot to maintain adequate airspeed, while maneuvering on approach, which resulted in an inadvertent stall/spin and uncontrolled collision with terrain. Factors relating to the accident were: the pilot allowed the aircraft weight and balance…NTSB LAX95LA315Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe pilot's selection of a runway inappropriate for the tailwind condition and his resultant failure to achieve a touchdown point which would allow the aircraft to stop prior to over running the departure end. The rough condition of the dirt runway, the lack…NTSB ANC95LA119Accident · 4 fatalLimited investigationFinal reportCessna 421C · Cordova, AKMechanical loss of engine power for undetermined reason(s), and subsequent in-flight collision with water (or ditching at sea).NTSB FTW95FA130Accident · 4 fatalField investigationFinal reportCessna 421C · El Prado, NMThe pilot's decision to continue flight into known adverse weather conditions and the ensuing inadvertent stall due to airframe ice. Factors were the weather conditions.NTSB CHI95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Angola, INOverload failure of the right main landing gear shock strut sleeve for an unknown reason.