NTSB investigations: Cessna 402B, ID
4 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
| 1990 | 1 |
|---|---|
| 1991 | 1 |
| 2005 | 1 |
| 2019 | 1 |
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 c.\"eventStateOrRegion\" = 'ID' 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" = 'ID' 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" 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 ANC19LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boise, IDA ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.NTSB SEA06LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Sandpoint, IDThe pilot's misjudged distance/altitude, which led to him landing short of the runway and impacting the runway's elevated lip. Contributing factors were the elevated runway lip and the right main landing gear failure.NTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…