NTSB investigations: Cessna 402C

6 cases on aircraft the registry lists as Cessna 402C, where the sequence of events included Runway excursion. 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

20102026

NTSB investigations: Cessna 402C per year, 2010–2026: 6 cases
2010	1
2015	1
2017	1
2019	1
2023	1
2026	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA26LA246Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 402 · Provincetown, MAOn June 15, 2026, about 0810 eastern daylight time, a Cessna 402C, N499CA, was substantially damaged when it was involved in an accident at Provincetown Municipal Airport (PVC), Provincetown, Massachusetts. The airplane transport pilot (pilot flying) and…Jun 15, 2026 · N499CA · Substantial damage NTSB ERA23LA189Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Ft. Lauderdale, FLThe pilot’s ineffective use of the airplane’s brakes, which resulted in a runway overrun.Apr 9, 2023 · N404PJ · Substantial damage NTSB WPR19LA094Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Montague, CAThe pilot’s failure to maintain directional control while landing on a wet/icy runway.Feb 15, 2019 · N5849C · Substantial damage NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…Jul 27, 2017 · N618CA · No damage NTSB ERA15LA125Accident · No injuriesLimited investigationFinal reportCessna 402C · Isla de Vieques, PRThe pilot's failure to maintain directional control during the landing roll with a strong crosswind, which resulted in a runway excursion.Feb 10, 2015 · N223PB · Substantial damage NTSB ERA10LA128Accident · No injuriesLimited investigationFinal reportCessna 402C · Watertown, NYThe pilot's decision to continue the approach with a known anomaly with the left airspeed indicator. Contributing to the accident was an undetermined malfunction of the left airspeed indicator and the condition of the runway, resulting in decreased braking…Feb 1, 2010 · N121PB · Substantial damage