NTSB investigations: Cessna 402, 1982
3 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
| 1967 | 2 |
|---|---|
| 1968 | 8 |
| 1969 | 4 |
| 1970 | 4 |
| 1971 | 3 |
| 1973 | 2 |
| 1974 | 3 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 3 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 2001 | 1 |
| 2008 | 1 |
| 2011 | 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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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 NYC83LA027Accident · No injuriesLimited investigationFinal reportCessna 402 · Danielson, CTOn final the pilot realized he was late in reducing power and attempted to correct by abruptly bringing power back. A high sink rate was experienced and the pilot immediately applied full power. The aircraft impacted short of the runway.NTSB LAX82FA344Accident · Serious injuriesField investigationFinal reportCessna 402 · Grand Canyon, AZThis was the 3rd flt of the day. The plt completed a service order for 32 gals of fuel & laid it on top of a bench located just inside open hangar doors. The acft was not refueled & the order was later found on the hangar floor away from the bench. While over…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…