Skip to content

NTSB investigations: Cessna 402B, FL

22 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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

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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  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

Run 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 ERA18LA011Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 402 · St. Petersburg, FLThe pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing.Oct 18, 2017 · N900CR · Substantial damage NTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.Mar 14, 2014 · N419AR · Substantial damage NTSB ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.Sep 10, 2012 · N218LG · Minor damage NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…Jul 22, 2008 · N3990C · Substantial damage NTSB MIA08LA079Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe improper adjustment of the right main landing gear down lock by maintenance personnel resulting in the gear collapse during the landing roll..Mar 15, 2008 · N300SH · Substantial damage NTSB ANC06LA098Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Lauderdale, FLThe pilot's continued flight into adverse weather, and his failure to maintain directional control of the airplane during the landing roll, which resulted in a collision with an airport runway sign, and subsequent collapse of the nose gear. A factor…Jul 23, 2006 · N991PH · Substantial damage NTSB MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…May 22, 2003 · N402DD · No damage NTSB MIA03LA064Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Marathon, FLThe loss of engine power to both engines for undetermined reasons.Feb 20, 2003 · N554AE · Substantial damage NTSB MIA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLA loss of engine power due to fuel exhaustion and the pilot in command's failure to ensure that the aircraft had adequate fuel to complete the flight.Apr 20, 1999 · N744MA · Substantial damage NTSB MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.Dec 9, 1998 · N788SP · Substantial damage NTSB MIA98LA123Accident · No injuriesLimited investigationFinal reportCessna 402B · West Palm Beach, FLthe pilot allowed the airplane to improperly touchdown on the right main landing gear, resulting in the gear collapsing, and subsequent impact with runway visual range equipment.Apr 3, 1998 · N400AR · Substantial damage NTSB MIA98LA019Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe pilot's improper management of fuel resulting in a total loss of engine power on both engines due to fuel exhaustion.Nov 2, 1997 · N69312 · Destroyed NTSB ATL98FA008Accident · 3 fatalField investigationFinal reportCessna 402B · Tampa, FLThe pilot's failure to follow the landing checklist and extend the landing gear for landing, and his failure to maintain VMC during a go-around. Factors were: the pilot's diverted attention due to a non-stabilized instrument approach and his lack of recent…Oct 27, 1997 · N69293 · Substantial damage NTSB ATL92FA167Accident · 2 fatalField investigationFinal reportCessna 402B · Miramar, FLThe failure of the pilot to perform preflight planning in that the weight and balance of the aircraft were exceeded. The pilot's lack of experience in the type of aircraft and lack of multiengine certification.Aug 27, 1992 · N6AT · Substantial damage NTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…Jan 11, 1992 · N3767C · Destroyed NTSB MIA88LA189Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe right main gear collapsed on touchdown. An exam of the gear revealed that a fork bolt had been improperly adjusted. The facility that performed the last maintenance denied adjusting the bolt.Jun 13, 1988 · N7628Q · Substantial damage 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…Aug 23, 1987 · N3767C · Minor damage NTSB 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…Apr 25, 1986 · N401NA · Substantial damage NTSB MIA85IA069Incident · No injuriesIncident investigationFinal reportCessna 402B · Sanford, FLDuring cruise flt, the acft suddenly nosed down & began vibrating. Remedial action was taken & an uneventful emerg landing was made. An exam revealed that the bolt, nut & cotter pin (used to attach the elevator trim control rod to the elevator trim tab) were…Dec 29, 1984 · N402PB · Minor damage NTSB MIA83LA122Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Pierce, FLThe acft was landed wheels up. The pilot stated that he never heard the landing gear warning horn operate. Post accidentinvestigation showed that the landing gear operated properly but that the warning horn was inoperative. The pilot of theaccident acft held…Apr 12, 1983 · N13GM · Substantial damage NTSB MIA81FKU05Accident · No injuriesClosedCessna 402B · Miami, FLSep 26, 1981 · N5879M · Substantial damage NTSB MIA78DKT36Accident · No injuriesClosedCessna 402B · Naples, FLMar 16, 1978 · N69316 · Substantial damage