NTSB investigations: Cessna 402C
9 cases on aircraft the registry lists as Cessna 402C, where the first occurrence was “In flight encounter with weather”. 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
| 1984 | 2 |
|---|---|
| 1989 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2006 | 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.\"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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 MIA06LA071Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Dorado, PRThe failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.NTSB LAX03FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Mather, CAloss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…NTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.NTSB ANC95FA016Accident · 5 fatalField investigationFinal reportCessna 402C · Elim, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: darkness and the adverse weather conditions.NTSB ANC93FA013Accident · 3 fatalField investigationFinal reportCessna 402C · Kiana, AKThe pilot in command's attempt to fly VFR into IMC conditions. Factors were snow, whiteout conditions, and mountainous terrain.NTSB MIA92FA067Accident · 2 fatalField investigationFinal reportCessna 402-C · Clewiston, FLPilot-in-command's improper inflight decision to attempt to descend and remain in VFR conditions in an area of thunderstorms and heavy rain. Contributing to the accident was the pilot-in-command's loss of control in flight.NTSB ANC89FA137Accident · 1 fatalField investigationFinal reportCessna 402 · Nome, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his improper in-flight planning/decision. The weather and terrain conditions were considered to be contributing factors.NTSB MIA84FA122Accident · 4 fatalField investigationFinal reportCessna 402C · Mineral Springs, FLThe acft collided with trees and the ground during flt in adverse weather. There is no record of the plt receiving a pre-flt briefing and no flt plan was filed. Witnesses heard an acft flying low followed by a loud thud. About 16 mi north at sarasota, FL, the…NTSB NYC84FA081Accident · 2 fatalField investigationFinal reportCessna 402 · Jaffrey, NHThe plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last…