NTSB investigations: Cessna 402, AK
6 cases on aircraft the registry lists as Cessna 402. 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
| 1969 | 1 |
|---|---|
| 1976 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1993 | 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\" = 'AK' 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 ('207590K'))
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" = 'AK' 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 ('207590K'))
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 ANC93LA090Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe failure of the pivot link for the downlock mechanism and the improper rigging of the landing gear locking mechanism by company maintenance personnel.NTSB ANC89FA070Accident · No injuriesField investigationFinal reportCessna C-402 · Tatitlek, AKInstallation of the improper washer on the scissors assembly of the left main landing gear. The extra forces encounteredon a gravel runway were sufficient to pull the bushing, washer, and bolt through the scissors assembly and allowing the lower half to pivot…NTSB ANC87MA057Accident · 2 fatalMajor investigationFinal reportCessna 402 · Anchorage, AKThe acft was on the last leg of a scheduled commuter flight, when it crashed in a heavily wooded area while making a VFR approach to merrill field, Anchorage, AK. The capt and his sole passenger were killed in the crash when the airplane struck the ground…NTSB ANC82FAA14Accident · No injuriesFinal reportCessna 402 · Fairbanks, AKThe plt reported that during taxi there was a light trace of dew on the windshield. The passenger stated that during the initial application of takeoff power the windshield became fogged & completely obscured forward visibility. The plt's attention was also…NTSB ANC76AA096Accident · 4 fatalClosedBeech A-45 · Summit Lake, AKNTSB ANC69D0105Accident · No injuriesClosedCessna 402 · Fairbanks, AK