NTSB investigations: Cessna 402B, 1987
9 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\") = 1987
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") = 1987
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 DCA88RA019Accident · 1 fatalForeign investigationCessna 402 · St. Barthelemy, WNNTSB ANC88FA019Accident · Minor injuriesField investigationFinal reportCessna 402B · Anchorage, AKDrg arr in hvy traffic, reeve flt 726 (Boeing 727) & wilburs flt 304 (Cessna 402B, N969JW) recd radar adzys for visual apchs to rwys 6L & 6R, respectively. Subsequently, both flts were clrd to lnd. At 1555:04, the LCL twr ctlr transmitted that the wnd at the…NTSB MIA88WA056Accident · 1 fatalForeign investigationCessna 402B · Cat Island, BahamasNTSB ANC88IA013Incident · No injuriesIncident investigationFinal reportCessna 402B · Cordova, AKThe company maintenance personnel were aware of a shimmy problem but they thought is was only worn bushings. The maintenance people stated they inspected the part but found no problem. The pilot-in-command also stated he found no problem upon visually…NTSB LAX88LA022Accident · No injuriesLimited investigationFinal reportCessna 402B · Avalon, CAOn landing the pilot reported he heard a loud bang and the aircraft veered to the right. The pilot corrected to the leftby applying left brake. The aircraft returned to the center of the runway; however, it began to skid. The pilot realized that he was…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.NTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…NTSB SEA87LA049Accident · No injuriesLimited investigationFinal reportCessna 402B · Las Vegas, NVPlt filed IFR, 2+40 ete. Due delay, plt departed VFR and opened VFR flt plan. Enroute, stong hdwinds encountered. Also, clouds required altitude and course deviations to maintain VFR. Ate was 3+33. On final, left eng lost pwr, rt eng began surging. Into 20-KT…