NTSB investigations: Cessna 340, 1982
4 cases on aircraft the registry lists as Cessna 340. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 8 |
| 1980 | 2 |
| 1981 | 4 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1998 | 2 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 3 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 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\") = 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 ('2076404'))
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 ('2076404'))
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 FTW83FRG03Accident · 2 fatalFinal reportCessna 340 · Benavides, TXA deer hunter saw the aircraft on a final approach to an open field at dusk, with the gear and flaps down. He stated that when it was at about 100 ft AGL, the nose pitched down and the plane struck the ground and burst into flames. The aircraft was loaded…NTSB SEA83LA007Accident · No injuriesLimited investigationFinal reportCessna 340 · Bellevue, WAAccording to the pilot, the right engine lost power at or shortly after rotation for takeoff. Reportedly, there was insufficient room to stop on the runway with a house near the end. He opted to continue the takeoff and fly to a safe landing area. He stated…NTSB SEA82DA113Accident · No injuriesFinal reportCessna 340 · Sunriver, ORThe pilot reported that he landed 10 KTS fast to compensate for a 15 kt crosswind. He reported that during the landing roll, the right brake felt like it was not working. Rather than going off the end of the runway, he applied heavy left brake and steered the…NTSB SEA82DA038Accident · No injuriesFinal reportCessna 340 · Idaho Falls, IDThe pilot reported that during an ILS approach, he broke out at about 500 ft AGL. He stated that he did not properly arrest the sink rate and struck the runway. He also stated that there probably was some ice under the wings that had accumulated during…