Skip to content

NTSB investigations: Cessna A188B, OR

16 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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.Jun 14, 2017 · N4877Q · Substantial damage NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.Jul 21, 2000 · N731GR · Substantial damage NTSB SEA86LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Durkee, ORWhile crossing a mountain ridge at low altitude, the aircraft encountered downdrafts. The pilot was forced to land as he was unable to arrest the descent rate. The landing was accomplished onto very rough terrain.Jun 28, 1986 · N4835Q · Substantial damage NTSB SEA86LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Nyssa, ORDuring aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in…May 24, 1986 · N53177 · Destroyed NTSB SEA84LA122Accident · No injuriesLimited investigationFinal reportCessna 188B · Perrydale, ORThe plt stated that while taking off from the 1,100 ft rough strip, the acft struck a bump causing it to become airborneprematurely. The acft then settled back onto tall wheat past the end of the strip & flipped inverted.May 29, 1984 · N4918R · Substantial damage NTSB SEA84LA112Accident · No injuriesLimited investigationFinal reportCessna 188B · Shedd, ORWhile landing on a 1600 ft ag strip, the plt realized he had too much speed. However, there were power lines at the departure end of the strip, so he elected not to attempt a go-around. He intentionally ground looped the acft to avoid a ditch & road at the…May 7, 1984 · N731SW · Substantial damage NTSB SEA83LA049Accident · No injuriesLimited investigationFinal reportCessna A188B · Medford, ORThe aircraft collided with a tree during aerial application operations. The pilot stated that there was a powerline at one end of the orchard he was spraying and a row of leafless trees at the other. One of the taller boundary trees was overlooked by the…Feb 2, 1983 · N4784Q · Destroyed NTSB SEA81DYM33Accident · No injuriesClosedCessna A188B · Rickreall, ORJul 24, 1981 · N21706 · Substantial damage NTSB SEA79FYA20Accident · No injuriesClosedCessna 188 · Nyssa, ORJul 22, 1979 · N9499R · Destroyed NTSB SEA79DYA17Accident · No injuriesClosedCessna 188B · Ontario, ORJun 5, 1979 · N53177 · Substantial damage NTSB SEA79DYM33Accident · No injuriesClosedCessna 188B · Fox, ORMay 12, 1979 · N9451G · Substantial damage NTSB SEA77DYM27Accident · No injuriesClosedCessna 188B · Albany, ORApr 11, 1977 · N4918R · Substantial damage NTSB SEA77DYM19Accident · No injuriesClosedCessna 188 · Hood River, ORFeb 15, 1977 · N9451G · Substantial damage NTSB SEA76DYC10Accident · No injuriesClosedCessna A188B · Jefferson, ORAug 12, 1975 · N9873G · Destroyed NTSB SEA75DYC35Accident · No injuriesClosedCessna A188B · Albany, ORApr 9, 1975 · N9873G · Substantial damage NTSB SEA75FYC27Accident · No injuriesClosedCessna A188B · Independence, ORFeb 21, 1975 · N86448 · Substantial damage