NTSB investigations: Cessna 421B, 1982
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\") = 1982
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") = 1982
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 ATL83FA073Accident · No injuriesField investigationFinal reportCessna 421B · Fort Payne, ALDuring landing the right main landing gear scissors bolt & bushing pulled through the scissors mount hole allowing the landing gear to rotate 90 deg. An incorrect washer (standard 5/16 in) had been installed in the scissors assembly duringrecent maintenance.…NTSB ATL83AA059Accident · 4 fatalFinal reportCessna 421B · Savannah, GAPlt reported he was on a missed approach & was returning to charleston "heading 360 degrees..." The acft crashed about 1/4 mi south & 100 ft short of the departure end of rwy 27. The wreckage scatter pattern was oriented on a heading of 155 deg. Missed…NTSB FTW82FPM17Accident · 1 fatalFinal reportCessna 421B · Afton, OKAt about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at…NTSB FTW82IA331Incident · Minor injuriesIncident investigationFinal reportCessna 421B · El Paso, TXN1969J is a 1974 Cessna 421B modified by a riley conversion kit. The aircraft was descending through about 1900 ft MSL when, without previous warning, it yawed left. The pilot reported that the acft then immediately yawed severely to the right and began to…NTSB DEN82DA030Accident · No injuriesFinal reportCessna 421B · Spanish Fork, UTThe aircraft tookoff from an airport with slush on the runway, about 10 minutes later, the pilot landed at another airport. The runway at the destination airport was covered with dry snow. During touchdown, the aircraft veered left and hit a snowbank beside…