NTSB investigations: Cessna A185E
19 cases on aircraft the registry lists as Cessna A185E, where the sequence of events included Loss of control on ground. 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
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2024 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072818')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('2072818')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.NTSB WPR24LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Nampa, IDLoss of directional control during the takeoff roll.NTSB CEN20CA285Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Rochester, INThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB WPR20CA204Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · San Diego, CAThe pilot's failure to maintain airplane control during landing with a crosswind and excessive braking action, which resulted in the airplane nosing over.NTSB GAA19CA260Accident · No injuriesData collectionFinal reportCessna A185 · Northway, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and subsequent nose-over.NTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.NTSB GAA19CA100Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot's loss of directional control during the landing roll and his subsequent overapplication of left rudder, which resulted in the right wing impacting the runway.NTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.NTSB WPR17LA162Accident · No injuriesLimited investigationFinal reportCessna A185E · Nampa, IDThe pilot’s failure to maintain directional control of the tailwheel airplane during the landing roll.NTSB GAA17CA310Accident · No injuriesData collectionFinal reportCessna A185 · Fall River Mills, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA054Accident · No injuriesData collectionFinal reportCessna A185 · Winnemucca, NVThe pilot's failure to maintain directional control during the landing roll.NTSB GAA16CA459Accident · No injuriesData collectionFinal reportCessna A185 · Gooding, IDThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB ANC16LA046Accident · No injuriesLimited investigationFinal reportCessna A185 · Illiamna, AKThe overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.NTSB ERA15CA095Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, METhe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.NTSB ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB ANC13CA005Accident · No injuriesData collectionFinal reportCessna A185E · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a ground loop.NTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.NTSB SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.