Skip to content

NTSB investigations: Cessna 210-5A(205A)

36 cases on aircraft the registry lists as Cessna 210-5A(205A). 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('2073204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2073204'))
  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 ('2073204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR20LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 205 · Red Creek, AZThe pilot’s failure to properly configure the flaps for an aborted landing, which resulted in degraded climb performance and impact with vegetation at the end of the runway.Oct 24, 2019 · N8326Z · Substantial damage NTSB ERA19LA006Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 205 · Wagoner, OKMaintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.Oct 4, 2018 · N8495Z · Substantial damage NTSB ERA15LA263Accident · Minor injuriesLimited investigationFinal reportCessna 210 5A(205A) · Stafford Twp, NJThe total loss of engine power due to the failure of the crankshaft, which resulted from a mechanic's failure to properly torque the engine cylinder through bolts.Jul 12, 2015 · N315EC · Substantial damage NTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.Apr 8, 2014 · N4862U · Substantial damage NTSB ATL02WA022Accident · No injuriesForeign investigationCessna C205 · Bimini, BahamasDec 22, 2001 · N55VX · Substantial damage NTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.Nov 1, 1994 · N4801U · Substantial damage NTSB LAX92LA376Accident · No injuriesLimited investigationFinal reportCessna 205A · Gerlach, NVThe pilot misjudged the landing flare and failed to properly recover from the bounced landing.Sep 6, 1992 · N4825U · Substantial damage NTSB DEN90LA110Accident · No injuriesLimited investigationFinal reportCessna 205 · Bluff, UTFailure of the pilot to properly select and survey his landing site.May 20, 1990 · N4807U · Substantial damage NTSB NYC82DA233Accident · Serious injuriesFinal reportCessna 205A · Augusta, MEOn landing, a severe drag on the left landing gear overcame pilot's attempted corrections. The aircraft went off the runway, down an embankment and overturned. The left brake locked, due to corrosion of carrier pins.Sep 17, 1982 · N4868U · Substantial damage NTSB MIA81FKT07Accident · No injuriesClosedCessna 205 · Belle Glade, FLNov 21, 1980 · N1863Z · Destroyed NTSB CHI78FA009Accident · Minor injuriesClosedCessna 205 · Lincolnshire, ILNov 11, 1977 · N1879Z · 2 aircraft · Substantial damage NTSB OAK77FA052Accident · 2 fatalClosedCessna 205A · Kirkwood, CAAug 28, 1977 · N4874U · Destroyed NTSB MIA77DLG07Accident · No injuriesClosedCessna 205 · Charleston, SCJan 10, 1977 · N4831U · Substantial damage NTSB CHI77FEC03Accident · No injuriesClosedCessna 205 · Utica, MIOct 28, 1976 · N8326Z · Substantial damage NTSB MKC76DCQ77Accident · No injuriesClosedCessna 205 · Winona, KSSep 19, 1976 · N8495Z · Substantial damage NTSB MKC76FCG55Accident · Minor injuriesClosedCessna 205A · Kansas City, KSMar 6, 1976 · N4806U · Substantial damage NTSB MKC76FCG29Accident · Minor injuriesClosedCessna 205A · Lees Summit, MONov 1, 1975 · N4851U · Destroyed NTSB DEN73AD048Accident · 1 fatalClosedCessna 205A · Parowan, UTApr 14, 1973 · N8490Z · Destroyed NTSB NYC73FKM20Accident · 1 fatalClosedCessna 205A · Taylorsville, NCDec 24, 1972 · N8448Z · Destroyed NTSB CHI72DEI39Accident · No injuriesClosedCessna 205A · Oberlin, OHApr 22, 1972 · N4831U · Substantial damage NTSB NYC71AN019Accident · 3 fatalClosedCessna 205A · Chatham, MAAug 13, 1970 · N4869U · Substantial damage NTSB CHI70FBM16Accident · Serious injuriesClosedCessna 205 · Angola, INMay 3, 1970 · N4840U · Substantial damage NTSB OAK70AP042Accident · 6 fatalClosedCessna 205A · Mercury, NVFeb 14, 1970 · N8485Z · Destroyed NTSB DEN70F0024Accident · Serious injuriesClosedCessna 210 · Roy, UTJun 23, 1969 · N8158Z · Substantial damage NTSB DEN69F0147Accident · No injuriesClosedCessna 210 · Heber, UTOct 31, 1968 · N4826U · Substantial damage NTSB MIA68F0347Accident · Minor injuriesClosedCessna 210 · Bay Minette, ALDec 19, 1967 · N4803U · Substantial damage NTSB SEA68D0047Accident · No injuriesClosedCessna 210 · Drummond, MTMay 25, 1967 · N8496Z · Substantial damage NTSB LAX67F0454Accident · Minor injuriesClosedCessna 205 · Long Beach, CAMay 5, 1967 · N4824U · Substantial damage NTSB DEN67A0045Accident · 2 fatalClosedCessna 210-5A · Albuquerque, NMFeb 7, 1967 · N4855U · Destroyed NTSB MIA67D0150Accident · No injuriesClosedCessna 210-5A · Columbus, GAAug 3, 1966 · N4869U · Substantial damage NTSB MIA66D0527Accident · No injuriesClosedCessna 205 · Opa Locka, FLApr 9, 1966 · N4834U · Substantial damage NTSB CHI66F0651Accident · No injuriesClosedCessna 205 · Rossberg, OHApr 3, 1966 · N4863U · Substantial damage NTSB SEA66F0218Accident · No injuriesClosedCessna 205 · Bellevue, WAMar 12, 1966 · N8496Z · Substantial damage NTSB MIA66A0045Accident · 2 fatalClosedCessna 205 · St Simons Isle, GAOct 22, 1965 · N4819U · Destroyed NTSB CHI66D0089Accident · No injuriesClosedCessna 205A · Madison, INJun 22, 1965 · N4862U · Substantial damage NTSB UNK64X2838Accident · No injuriesClosedCessna 205 · Anniston, ALJul 15, 1964 · N4834U · Substantial damage