NTSB investigations: Cessna 340A, CO
8 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
| 1979 | 1 |
|---|---|
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
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\" = 'CO' 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 ('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 c."eventStateOrRegion" = 'CO' 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 ('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 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 DEN86FA259Accident · 5 fatalField investigationFinal reportCessna 340A · Crawford, COThe plt took off on a VFR flt with no flt plan filed or wx briefing. He encountered a wx squall line en route with low ceilings, fog, mixed rain and snow. While he was attempting to maneuver VFR through the wx at a low altitude above the ground, the acft…NTSB DEN85LA143Accident · No injuriesLimited investigationFinal reportCessna 340A · Englewood, COOn may 24, 1985, a Cessna 340, landed gear up off the runway at contennial arpt, Englewood, CO. The single eng ILS apch and 2 eng missed apch was planned. The instructor simulated the loss of the right eng at the outer marker by turning off the fuel supply.…NTSB DEN84FA162Accident · Minor injuriesField investigationFinal reportCessna 340A · Paonia, COThe pilot reported that at about 200 ft (AGL) on initial climb from takeoff, a complete power loss was experienced on the left engine. He stated the left propeller was feathered, but the aircraft would not hold altitude at recommended single-engine speed…NTSB DEN83FA059Accident · 4 fatalField investigationFinal reportCessna 340A · Aspen, COPrior to departure the flt was given an IFR clearance which began at herls intersection (16 mi nne) & to cross herls at or above 16,000 ft MSL. Departure arpt field elev is 7,793 ft. flts are required to proceed VFR to the initial fix of the IFR clearance.…NTSB DEN82FA014Accident · Minor injuriesClosedCessna 340A · Pueblo, CONTSB DEN79DTE75Accident · No injuriesClosedCessna 340 · Colorado City, CO