NTSB investigations: Cessna 402C, 1984
6 cases on aircraft the registry lists as Cessna 402C. 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
| 1972 | 1 |
|---|---|
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 6 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 7 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2026 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R'))
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 SEA85LA026Accident · No injuriesLimited investigationFinal reportCessna 402C · Boise, IDDescent was made to aprx 50 ft AGL to observe a herd of cattle. Acft contacted power lines cutting off the left wing tip. Flt continued and landing was made at Boise air terminal without incident. Plt stated he did not see wires.NTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…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 CHI84LA136Accident · No injuriesLimited investigationFinal reportCessna 402C · Kenosha, WIThe acft ran off the rwys end after the plt landed downwind to avoid flying through a 'wall of precipation'. During the rollout in slush the brakes froze. The nose gear settled in mud and collapsed.NTSB LAX84IA204Incident · No injuriesIncident investigationFinal reportCessna 402C · Kalaupapa, HIWhile on final to rwy 23, a 20 ft wave ricocheted off the rwy embankment, striking the acft's rt flap. The plt executed a go-around & landed on rwy 05 without incident. Investigation revealed that the rt flap cable had broken.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…