NTSB investigations: Cessna 340, CA
10 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 2007 | 1 |
| 2010 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 WPR10FA116Accident · 2 fatalField investigationFinal reportCessna 340 · Lytle Creek, CAThe pilot’s loss of situational awareness while maneuvering under a cloud layer and failure to maintain sufficient clearance from mountainous terrain.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 LAX90LA242Accident · No injuriesLimited investigationFinal reportCessna 340 · Salinas, CAThe failure of maintenance personnel to reinstall the landing gear retract/extension linkage and the failure of inspection personnel to detect the improper installation.NTSB LAX89LA224Accident · No injuriesLimited investigationFinal reportCessna 340 · Paso Robles, CAImproper use (mismanagement) of the fuel system by the pilot, which resulted in fuel starvation. Related factors were: the lack of fuel quantity indicators (not installed) in the aircraft, flight by the pilot with this known deficiency, and trees in the…NTSB LAX81FA067Accident · 1 fatalClosedCessna 340 · Santa Maria, CANTSB LAX81FVD13Accident · No injuriesClosedCessna 340 · Santa Rosa, CANTSB LAX80FVG35Accident · No injuriesClosedCessna 340 · Weed, CANTSB LAX78FUQ29Accident · Minor injuriesClosedCessna 340 · Burbank, CANTSB LAX77DUG54Accident · No injuriesClosedCessna 340 · Riverside, CANTSB LAX77FUQ11Accident · No injuriesClosedCessna 340 · Santa Ynez, CA