NTSB investigations: Cessna 340A, TX
9 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
| 1980 | 1 |
|---|---|
| 1982 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2021 | 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\" = 'TX' 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" = 'TX' 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 CEN21FA195Accident · 1 fatalClass 3 · FieldFinal reportCessna 340A · Tatum, TXThe pilot’s loss of airplane control for undetermined reasons.NTSB DFW06CA175Accident · No injuriesData collectionFinal reportCessna C340A · San Antonio, TXThe collapse of the left main landing gear as result of the failure of the gear pivot bolt for undetermined reasons.NTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB FTW02FA070Accident · 3 fatalField investigationFinal reportCessna 340A · Temple, TXThe pilot's mismanagement of fuel, which resulted in a total loss of engine power due to fuel starvation. Contributing factors were the pilot's failure to follow the checklist to feather the propellers in order to reduce drag.NTSB FTW93FA092Accident · 2 fatalField investigationFinal reportCessna 340A · Center Point, TXInadvertent stall. Factors were the weather and the light conditionsNTSB 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 FTW87FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Tomball, TXThe pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on…NTSB FTW83LA076Accident · No injuriesLimited investigationFinal reportCessna 340A · Austin, TXThe pilot reported that while on final approach to land, full flaps were extended as the aircraft crossed over a hill immediately before the runway threshold. After full flaps were selected, the aircraft entered a high sink rate and landed hard on the end of…NTSB FTW80FA034Accident · No injuriesClosedCessna 340 · Rosenberg, TX