NTSB investigations: Cessna 402B, 1986
4 cases on aircraft the registry lists as Cessna 402B. 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1974 | 4 |
| 1975 | 3 |
| 1976 | 4 |
| 1977 | 5 |
| 1978 | 9 |
| 1979 | 3 |
| 1980 | 6 |
| 1981 | 7 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 9 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 8 |
| 1993 | 8 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 3 |
| 2009 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
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 MIA87WA061Accident · No injuriesForeign investigationCessna 402 S/N 402B1031 · Treasure Cay, BahamasNTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…NTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…NTSB CHI86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Rochester, MNDuring a ILS approach in freezing rain conditions the pilot entered a high sink rate he could not stop until ground contact. The acft touched down short of the rwy and all three landing gear collapsed.