NTSB investigations: Cessna 402B, 1993
8 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\") = 1993
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") = 1993
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 MIA94WA005Accident · 2 fatalForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB MIA93WA195Accident · Serious injuriesForeign investigationCessna 402B · Sandy Point, BahamasNTSB BFO93LA164Accident · No injuriesLimited investigationFinal reportCessna 402B · Eau Claire, PAThe separation of the number four cylinder on the airplane's left engine for undetermined reasons. A factor in the accident was the rough/uneven terrain.NTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.NTSB MIA93WA094Accident · No injuriesForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB ATL93FA062Accident · 1 fatalField investigationFinal reportCessna 402B · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff. Factors which contributed to the accident were: the pilot's failure to ensure that the airplane maximum gross takeoff weight was not exceeded, the dark night, and rain.NTSB SEA93FA071Accident · 2 fatalField investigationFinal reportCessna 402B · Oakley, UTPoor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.NTSB ATL93FA058Accident · 2 fatalField investigationFinal reportCessna 402B · Geneva, ALThe pilot's failure to maintain minimum controllable airspeed during the initial climb, which resulted in a loss of aircraft control and collision with trees and terrain.