Cessna 402A
NTSB investigations · 45
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('207590M')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('207590M')
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 ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.NTSB LAX04LA149Accident · No injuriesLimited investigationFinal reportCessna 402A · Peach Springs, AZthe pilot's inadequate flare and touchdown that imparted high side loadings on the right main landing gear, which resulted in an overload failure of the landing gear bellcrank and the collapse of that gear.NTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…NTSB LAX99FA225Accident · Minor injuriesField investigationFinal reportCessna 402A · Van Nuys, CAThe pilot's inadequate fuel management that resulted in fuel exhaustion and the subsequent collision with vehicles during a forced landing on a city street.NTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.NTSB CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB ATL96FA017Accident · 2 fatalField investigationFinal reportCessna 402A · Avon Park, FLThe failure of the pilot to maintain the proper climb rate and direction of flight following takeoff, resulting in a collision with obstacles. The reason for the loss of control and subsequent unusual attitude ground impact was not determined.NTSB MIA95FA155Accident · Serious injuriesField investigationFinal reportCessna 402A · Miami, FLThe pilot-in-command's failure to maintain airspeed (VMC) after loss of power of one engine while on final approach, resulting in an in-flight loss of control and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB DEN92FA081Accident · No injuriesField investigationFinal reportCessna 402A · Holyoke, COFailure of the pilot to feather the failed engine propeller. A factor was: power loss for undetermined reasons.NTSB NYC91LA108Accident · No injuriesLimited investigationFinal reportCessna 402A · Albany, NYA collapse of the nose gear due to a failure of the nose gear trunion.NTSB CHI90FA066Accident · Serious injuriesField investigationFinal reportCessna 402A · Mosinee, WIThe pilot disregarding the published decision height and not performing a missed approach.NTSB MIA89LA107Accident · No injuriesLimited investigationFinal reportCessna 402A · Miami, FLThe overload failure of the bellcrank for the left main gear retraction linkage assembly for an unknown reason.NTSB LAX87LA195Accident · Serious injuriesLimited investigationFinal reportCessna 402A · Kahului, HIShortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both…NTSB SEA87FA064Accident · No injuriesField investigationFinal reportCessna 402A · Walla Walla, WADuring lndg roll the rt main lndg gear of the Cessna 402A collapsed. Visual inspection of the bell crank assembly revealed fracture surfaces similar to those of instantaneous overload.NTSB LAX85LA381Accident · No injuriesLimited investigationFinal reportCessna 402A · San Jose, CAThe aircraft landed gear up. The pilot reported no malfunction and said he forget to lower the landing gear.NTSB ANC84LA024Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Kotlik, AKDuring arrival, the plt landed on the frozen river, which was being used in lieu of the Kotlik airstrip. The landing area on the river was aprx 5000 ft long. After touchdown during the landing, some small children had run onto the departure end of the landing…NTSB DEN82DA079Accident · No injuriesFinal reportCessna 402A · Bismarck, NDThe pilot discovered that the gear would not extend electrically. Manual extension was attempted, but the crank would not turn in either direction. While applying pressure to the cranks, the chain drive failed. The plane was landed with the gear retracted.…NTSB MKC82FA019Accident · 1 fatalField investigationFinal reportCessna 402A · North Kansas Ci, MOThe pilot received 2 weather briefings. Most of the first briefing was spent finding an alternate. The forecast includedimc with low ceilings, low visibilities with light snow, fog, and possible freezing drizzle. The aircraft was not certificated for flight…NTSB MIA81IA017Incident · Minor injuriesClosedCessna 402A · Marathon, FLNTSB DEN80FQA11Incident · No injuriesClosedCessna 402A · Albuquerque, NMNTSB CHI80FEM06Accident · No injuriesClosedCessna 402A · Lansing, MINTSB SEA79FA038Accident · No injuriesClosedCessna 402 · Wenatchee, WANTSB DEN79FQA24Accident · No injuriesClosedCessna 402 · Albuquerque, NMNTSB MKC78FA059Accident · Serious injuriesClosedCessna 402A · Manhattan, KSNTSB FTW78FPG29Accident · No injuriesClosedCessna 402A · Little Rock, ARNTSB IAD78FA007Accident · Serious injuriesClosedCessna 402A · Madisonville, KYNTSB CHI77FA065Accident · 3 fatalClosedCessna 402A · Yates City, ILNTSB MIA77FKQ09Accident · Minor injuriesClosedCessna 402 · Madison, MSNTSB IAD77FKW05Accident · No injuriesClosedCessna 402 · Erin, TNNTSB IAD76II087Incident · No injuriesClosedCessna 402A · Charlotte, NCNTSB OAK76FJA13Accident · Serious injuriesClosedCessna 402A · Honolulu, HINTSB NYC76FHJ10Accident · No injuriesClosedCessna 402A · White Plains, NYNTSB OAK76AP029Accident · 2 fatalClosedCessna 402 · Elko, NVNTSB SEA75AS045Accident · No injuriesClosedCessna 402A · Seattle, WANTSB MIA74AM071Accident · No injuriesClosedCessna 402A · Gainesville, FLNTSB NYC74AN011Accident · No injuriesClosedCessna 402 · Bar Harbor, MENTSB ANC73AA053Accident · No injuriesClosedCessna 402A · Dillingham, AKNTSB IAD73AI012Accident · 6 fatalClosedCessna 402A · Greensboro, NCNTSB MIA72FKT56Accident · No injuriesClosedCessna 402A · Opa Locka, FLNTSB LAX72FUJ25Accident · Minor injuriesClosedCessna 402A · Scottsdale, AZNTSB MIA71AM062Accident · No injuriesClosedCessna 402A · Ocala, FLNTSB OAK71DVD19Accident · No injuriesClosedCessna 402A · Arcata, CANTSB DEN70FQA03Accident · No injuriesClosedCessna 402 · Las Vegas, NMNTSB MKC70A0020Accident · Serious injuriesClosedCessna 402A · Decorah, IANTSB ANC69A0058Accident · 1 fatalClosedCessna 402A · Mt Mckinley, AK
Back to Cessna 402A