NTSB investigations: Cessna 421C, 1985
5 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\") = 1985
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") = 1985
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 SEA86LA024Accident · No injuriesLimited investigationFinal reportCessna 421C · Idaho Falls, IDDuring initial apch inflight icing was encountered. The windscreen failed to heat due to an inoperative inverter. A small area on the right bottom portion of the windscreen de-iced due to defrost heat. The plt elected to land using the small clear area of the…NTSB MIA86FA014Accident · Minor injuriesField investigationFinal reportCessna 421C · Ft.Lauderdale, FLThe acft crashed on the arpt during an on demand air taxi flt. The plt stated that on final apch he encountered turbulence and rain. As he broke out of the rain the glare from the sun interferred with his visual perception. A go around was attempted but the…NTSB ATL85FA221Accident · 1 fatalField investigationFinal reportCessna 421C · Kennesaw, GAThe acft lost power on # 2 eng shortly after take-off. The acft crashed and burned in a wooded area several miles sw of the arpt. The # 2 eng was severly damaged in the fire. No pre-impact malfunction could be documented. Examination of the prop did not…NTSB DEN85FA125Accident · Serious injuriesField investigationFinal reportCessna 421C · Las Vegas, NMThe acft was landed in a pasture about 2 miles from the arpt after the acft began to descen 'behind the power curve' after takeoff. The plt said he used full power for takeoff but the takeoff was longer than normal. The da was computed to be 9286 ft. after…NTSB DEN85FA075Accident · 6 fatalField investigationFinal reportCessna 421C · Albuquerque, NMThe plt was flying his wife & her 4 friends to aspen, co for a ski vacation. Witnesses reported that during takeoff, the rgt baggage door opened. They observed the acft turn left onto a downwind with the landing gear extended. Eight witnesses reported the…