NTSB investigations: Cessna A185E
13 cases on aircraft the registry lists as Cessna A185E, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 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.\"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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 ANC04LA055Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's inadequate compensation for wind conditions during takeoff and initial climb, which resulted in a loss of control, and an in-flight collision with water. A factor contributing to the accident was gusty wind conditions.NTSB ANC03FA051Accident · 4 fatalField investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall, an uncontrolled descent and in-flight collision with terrain. A factor associated with the accident was rising terrain.NTSB ANC97LA135Accident · Serious injuriesLimited investigationFinal reportCessna 185E · Igiugig, AKfailure of the pilot to maintain adequate airspeed, during a maneuvering turn at low altitude, which resulted in an accelerated stall and subsequent collision with the terrain. A factor relating to the accident was: the lack of altitude to recover from the…NTSB ANC95FA167Accident · 2 fatalField investigationFinal reportCessna 185 · Petersburg, AKThe pilot's failure to maintain sufficient airspeed above the airplane's stall speed. The high terrain and low ceiling (clouds) were related factors.NTSB CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.NTSB ANC91FA115Accident · 2 fatalField investigationFinal reportCessna A185F · Amitchiak Lake, AKThe pilot's failure to maintain the airplane's airspeed above stalling; thereby losing control. Factors contributing to the accident were the mountainous terrain, the mountain wave, and insufficient altitude from which to recover.NTSB ANC90LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Chandler, AKThe pilot-in-command's failure to maintain control of the airplane.NTSB ATL89FA197Accident · Serious injuriesField investigationFinal reportCessna A185E · Myrtle Grove, FLThe pilot in command inadvertently stalled the aircraft during a balked landing.NTSB SEA88FA140Accident · 3 fatalField investigationFinal reportCessna 185 · Liscome Bay, AKWhile in a narrow, tree-lined area just above a small cove, the pilot lost control of the aircraft while maneuvering, in preparation for a landing on a lake. The aircraft struck trees in-flight while in an unusual attitude and then struck the water. Poor…NTSB ANC87FA084Accident · No injuriesField investigationFinal reportCessna 185 · Anchorage, AKThe acft was stalled on short final for landing. It touched down hard on the rwy and directional control was lost. The acft veered off the right side of the rwy and struck two parked acft.NTSB DEN84LA263Accident · No injuriesLimited investigationFinal reportCessna 185 · Akron, COThe aircraft was aprx 200 lbs under max gross weight for the takeoff. According to the pilot all of his previous takeoffs had been at near sea level. He stated that he was not used to high density takeoffs such as this one (7011 feet density altitude). The…NTSB SEA83LA177Accident · No injuriesLimited investigationFinal reportCessna 185E · Boise, IDThe acft landed in a near maximum velocity crosswind and while braking to control/correct a swerve, the right main landing gear separated from the acft. The landing was on rwy 28R and the wind was from 200 degrees at 10 to 14 KTS on final and 12 KTS when the…NTSB FTW82DA229Accident · Minor injuriesFinal reportCessna A185E · Amarillo, TXThe float/wheel equipped aircraft approached a private gravel strip for landing and encountered gusty winds. The aircraft drifted off the runway and the float/wheel dug into the soft dirt and the aircraft nosed over. The pilot reported the winds as…