NTSB investigations: Cessna 340A, 1987
6 cases on aircraft the registry lists as Cessna 340A. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 7 |
| 1982 | 6 |
| 1983 | 4 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 4 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 4 |
| 2007 | 3 |
| 2008 | 2 |
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076405', '2073325'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076405', '2073325'))
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 DEN88FA014Accident · 1 fatalField investigationFinal reportCessna 340A · Bailey, COThe aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…NTSB SEA88LA005Accident · No injuriesLimited investigationFinal reportCessna 340A · Tacoma, WAAs the plt was taxiing to the active rwy, the acft's right brake became inop due to a loss of hydraulic fluid. Subsequently, the acft went off the side of the taxiway, contd over an embankment & was damaged. The loss of hydraulic fluid was due to a leak in…NTSB SEA87LA193Accident · No injuriesLimited investigationFinal reportCessna 340A · Tecopa, CAA dual engine failure occurred after the first reduction in power at about 200 feet AGL. The aircraft then descended to the ground. No mechanical reason for the loss of power could be determined.NTSB FTW87LA221Accident · 1 fatalLimited investigationFinal reportCessna 340A · Lubbock, TXThe pilot did not declare an emergency or mention to the tower controller that his fuel was low. He was first told to enter right traffic for runway 17R but was subsequently told to enter right traffic for runway 26. (This was to allow a dea aircraft, at its…NTSB DEN87FA048Accident · 2 fatalField investigationFinal reportCessna 340A · Two Buttes, COThe plt and his wife were en route from palm springs, CA, to olathe, KS, and had stopped for fuel at farmington, NM. After departure, the acft was eventually cleared to FL 210. At 1934 the plt gave denver ARTCC the following PIREP: 'there's been some snow but…NTSB CHI87DEX05Accident · No injuriesFinal reportCessna 340A · Bloomington, INThe plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but…