Skip to content

NTSB investigations: Cessna 182A, WA

23 cases on aircraft the registry lists as Cessna 182A. 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."eventStateOrRegion" = 'WA' 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 ('2072704')) 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.\"eventStateOrRegion\" = 'WA' 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 ('2072704'))
  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" = 'WA' 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 ('2072704'))
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 WPR24LA206Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Spokane Valley, WAThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jun 24, 2024 · N4059D · Substantial damage NTSB WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.Jun 11, 2012 · N4715D · Substantial damage NTSB WPR11CA309Accident · Minor injuriesData collectionFinal reportCessna 182A · Vancouver, WAThe pilot's failure to properly engage the banner tow rope with the airplane's tail hook.Jul 5, 2011 · N5175D · Substantial damage NTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.Nov 20, 2007 · N6147B · 2 aircraft · Substantial damage NTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.Nov 8, 2003 · N2106G · Substantial damage NTSB SEA99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Silverdale, WAThe pilot-in-command's misjudgment of distance/altitude (undershoot) on final, and his failure to maintain directional control during the aborted landing.Jul 18, 1999 · N3900D · Substantial damage NTSB SEA96LA160Accident · No injuriesLimited investigationFinal reportCessna 182A · Toledo, WAloss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.Jun 22, 1996 · N9975B · Substantial damage NTSB SEA91LA168Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Naches, WAThe pilot's poor in-flight decision. Factors include high density altitude, high winds and downdrafts.Jul 13, 1991 · N2184G · Destroyed NTSB SEA91LA107Accident · No injuriesLimited investigationFinal reportCessna 182A · Mead, WACarburetor ice and the pilot not using the carburetor hear. Factors to the accident were: carburetor icing conditions, and the pilot did not adequately evaluate the weather conditions.May 17, 1991 · N5048D · Substantial damage NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.Jun 2, 1990 · N4944D · Substantial damage NTSB SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…Jul 31, 1987 · N6133B · Substantial damage NTSB SEA85LA220Accident · No injuriesLimited investigationFinal reportCessna 182A · Vancouver, WAThe plt was unable to land at his intended destination due to the rwy edge and end lights being inoperative. The plt diverted to a nearby arpt but fuel exhaustion occurred and a forced landing was made. The acft was landed on an overpass and during the…Sep 22, 1985 · N4774D · Substantial damage NTSB SEA80FYE50Accident · Minor injuriesClosedCessna 182A · Issaquah, WAAug 9, 1980 · N3890D · Substantial damage NTSB SEA80DYE37Accident · Minor injuriesClosedCessna 182 · Marblemount, WAJun 28, 1980 · N3901D · Destroyed NTSB SEA77DYP46Accident · No injuriesClosedCessna 182 · Walla Walla, WASep 8, 1977 · N5141D · Substantial damage NTSB SEA76AS014Accident · 2 fatalClosedCessna 182A · Cyrstal Mtn, WAAug 25, 1975 · N4783D · Destroyed NTSB SEA72DYG23Accident · No injuriesClosedCessna 182A · Pulman, WADec 23, 1971 · N5948B · Substantial damage NTSB SEA71DWG20Accident · No injuriesClosedCessna 182 · Moses Lake, WASep 14, 1970 · N4998D · Substantial damage NTSB SEA67F0339Accident · No injuriesClosedCessna 182 · Spokane, WAMay 20, 1967 · N6193B · Substantial damage NTSB SEA67D0123Accident · No injuriesClosedCessna 182 · Whidbey Isle, WAJul 17, 1966 · N5111D · Substantial damage NTSB SEA66F0172Accident · No injuriesClosedCessna 182 · Pasco, WADec 8, 1965 · N5111D · Substantial damage NTSB SEA66D0031Accident · No injuriesClosedCessna 182 · Walla Walla, WAJul 9, 1965 · N6119B · Substantial damage NTSB SEA76AS001Accident · 2 fatalClosedCessna 182A · Mineral, WAJun 15, 1964 · N4029D · Destroyed