NTSB investigations: Cessna 340
8 cases on aircraft the registry lists as Cessna 340, 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1994 | 2 |
| 1998 | 1 |
| 2007 | 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 ('2076404')
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 ('2076404')
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 SEA08LA021Accident · 3 fatalLimited investigationFinal reportCessna 340 · Garberville, CAThe pilot's intentional visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the trees and terrain during climb. Contributing to the accident were the weather conditions of fog and a low…NTSB SEA98FA105Accident · 1 fatalField investigationFinal reportCessna 340 · Lincoln, MTThe pilot's improper or inadequate use of the aircraft's weather avoidance equipment, resulting in penetration of a Level 4 thunderstorm and subsequent loss of aircraft control from which the pilot did not recover. Factors included a thunderstorm and the…NTSB FTW94FA165Accident · 2 fatalField investigationFinal reportCessna 340 · Elko, NVThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain altitude (or clearance) from mountainous terrain. Factors related to the accident were: the adverse weather conditions, high (mountainous/hilly) terrain,…NTSB NYC94FA052Accident · 2 fatalField investigationFinal reportCessna 340 · Westhampton, NYThe pilot's inadequate inflight decision which resulted in ice accretion on the aircraft, degradation of aircraft performance, an aerodynamic stall, loss of control and inflight collision with the ground. Factors were icing conditions.NTSB CHI90FA056Accident · No injuriesField investigationFinal reportCessna 340 · Merrill, WIFailure of the pilot to maintain proper alignment with the runway during his landing roll and an inflight encounter with icing conditions.NTSB SEA86LA060Accident · No injuriesLimited investigationFinal reportCessna 340 · Burns, ORThe aircraft encountered airframe icing on a descent for a VOR approach. 1/8 to 1/4 inch of ice was present during landing. The pilot allowed a stall to occur prior to touch down with a hard landing resulting.NTSB ATL85FA079Accident · 3 fatalField investigationFinal reportCessna 340 · Johnson City, TNThe acft was IFR at 17000 ft flying thru wx SIGMET area for severe icing when the plt requested a descent due to airframe ice and turbulence. During the descent the plt reported shutting down the right eng. On final apch for an off-arpt landing attempt 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…