NTSB investigations: Cessna 340A, IL
6 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
| 1981 | 3 |
|---|---|
| 1986 | 1 |
| 1996 | 1 |
| 1998 | 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\" = 'IL' 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" = 'IL' 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 CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.NTSB CHI96FA152Accident · Serious injuriesField investigationFinal reportCessna 340A · Waukegan, ILthe pilot's inability to maintain visual contact with the runway environment due to 'flash blindness' when he turned on the airplane's landing light, and his subsequent inability to regain control of the airplane after turning off the landing light due to his…NTSB CHI86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Frankfort, ILFollowing a descent through icing conditions the plt was told by the UNICOM operator that the active rwy was 'slippery'.the plt landed aprx 600-700 ft down the 3176 ft rwy and found that the braking action deteriorated from poor to nil during rollout. He…NTSB CHI81FA078Accident · 2 fatalClosedCessna 340A · St Charles, ILNTSB CHI81DA050Accident · No injuriesClosedCessna 340A · Robinson, ILNTSB CHI81FEE18Accident · Serious injuriesClosedCessna 340A · Sugar Grove, IL