Skip to content

NTSB investigations: Cessna A188B, WA

18 cases on aircraft the registry lists as Cessna A188B. 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

19752026

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 ('2073005')) 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 ('2073005'))
  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 ('2073005'))
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 WPR11LA181Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Palouse, WAThe pilot did not maintain adequate clearance from obstacles during a low-level aerial application maneuver.Apr 1, 2011 · N5851G · Substantial damage NTSB SEA05CA069Accident · No injuriesData collectionFinal reportCessna A188B · Palouse, WAThe pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.Apr 4, 2005 · N4784Q · Substantial damage NTSB SEA04LA057Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAThe pilot's decision to takeoff downwind resulting in his inability to achieve a positive climb rate and an in-flight collision with terrain. Factors contributing to the accident included the rising terrain and the tailwind condition.Mar 25, 2004 · N731YZ · Substantial damage NTSB SEA96LA159Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Pullman, WAfailure of the pilot to maintain terrain clearance during a swath run. Factors relating to the accident were: unfavorable (variable) wind conditions, low airspeed, and uneven terrain.Jul 16, 1996 · N9336R · Substantial damage NTSB SEA93LA200Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waterville, WAThe pilot's inadequate visual lookout and failure to maintain clearance from the powerline.Sep 15, 1993 · N9523G · Destroyed NTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.Jul 12, 1993 · N5858G · Substantial damage NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.Jul 18, 1991 · N731YZ · Substantial damage NTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.Jun 22, 1990 · N4855R · Substantial damage NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.Jul 19, 1989 · N9768G · Destroyed NTSB SEA84LA187Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAPIC stated he landed in S0FT dirt short of the 1600 ft ag strip. The acft nosed over.Jul 31, 1984 · N731YZ · Substantial damage NTSB SEA84LA186Accident · No injuriesLimited investigationFinal reportCessna A188B · Pasco, WAThe acft was loaded with 1500 lbs of dry chemical (fertilizer). The air temp at the time of the accident was 95 deg f, resulting in a high density alt. Rising terrain existed at the point where the plt attempted a turnaround. In an attempt to turn away from…Jul 27, 1984 · N70296 · Substantial damage NTSB SEA82DA099Accident · No injuriesFinal reportCessna A188B · Othello, WAAt the completion of a spray operation, the pilot returned to the airport to land. During the landing roll realizing that no braking was available on the left wheel, the aircraft was intentionally ground looped in an effort to reduce the damage. According to…Jun 26, 1982 · N91367 · Substantial damage NTSB SEA80FYP14Accident · Serious injuriesClosedCessna A188B · Sprague, WAMar 14, 1980 · N70252 · Destroyed NTSB SEA79DYP38Accident · Minor injuriesClosedCessna 188B · Mattawa, WAJul 20, 1979 · N9845G · Substantial damage NTSB SEA79FYP25Accident · Serious injuriesClosedCessna 188B · Patterson, WAMay 29, 1979 · N8017G · Substantial damage NTSB SEA77DYP35Accident · No injuriesClosedCessna 188 · Connell, WAAug 3, 1977 · N72414 · Substantial damage NTSB SEA77DYP31Accident · No injuriesClosedCessna 188A · Warden, WAJun 23, 1977 · N70296 · Substantial damage NTSB SEA76DYG12Accident · No injuriesClosedCessna 188 · Monitor, WASep 5, 1975 · N9083G · Substantial damage