NTSB investigations: Cessna 421B, 1985
5 cases on aircraft the registry lists as Cessna 421B. 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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 7 |
| 1975 | 1 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 12 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 7 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 3 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 6 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 2 |
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 ('2076014'))
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 ('2076014'))
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 DEN86FA033Accident · Serious injuriesField investigationFinal reportCessna 421B · Franktown, COThe acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an…NTSB MKC85LA215Accident · No injuriesLimited investigationFinal reportCessna 421B · Olathe, KSDuring the takeoff roll on an IFR flt, the right eng lost pwr and the plt aborted the takeoff. The acft ran off the end of the rwy, across two ditches, one road, through a fence and struck a post in a fld. During post accident tests, the right eng would run…NTSB MIA85LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Lakeland, FLDuring takeoff at Lakeland, FL, the left main wheel assembly separated from the acft & struck the leading edge of the horizontal stabilizer, causing substantial damage. The plt did not know the wheel had come off until he was notified by ATC. He then diverted…NTSB FTW85LQG01Accident · No injuriesFinal reportCessna 421B · Amarillo, TXThe acft ground looped following a collapse of the left main gear after a landing roll of aprx 600 to 700 ft. post accident inspection of the gear revealed a bolt had backed out of the gear down lock arm where it locks overcenter.NTSB NYC85FA097Accident · 2 fatalField investigationFinal reportCessna 421B · Johnson City, NYAfter a heavy snow shower passed over the airport, the accident acft attempted a departure. Immediately after takeoff the plt transmitted that he was coming back to land. The acft crashed shortly thereafter, 1 mile southwest of the airport. Ground witnesses…