NTSB investigations: Cessna A188B, MT

5 cases on aircraft the registry lists as Cessna A188B, where the first occurrence was “Loss of control - on ground/water”. 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

19822026
NTSB investigations: Cessna A188B, MT per year, 1982–2026: 5 cases
19821
19841
19861
19891
19991

Latest 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.\"eventStateOrRegion\" = 'MT' 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')
      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\" = 260))
  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.

NTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.Aug 9, 1999 · N9085R · Substantial damageNTSB DEN89LA106Accident · No injuriesLimited investigationFinal reportCessna A188B · Rapelje, MTThe inadequate compensation for the wind conditions by the pilot which resulted in a loss of directional control on landing and subsequent collision with a ditch.Apr 10, 1989 · N731XG · Substantial damageNTSB DEN87LA021Accident · No injuriesLimited investigationFinal reportCessna A188B · Rock Springs, MTDuring the initial takeoff ground run in high wind conditions the acft drifted to the right, impacted a dirt bank, ground looped and nosed down. During the ground loop the left wing struck the ground, damaging the main spar.Nov 24, 1986 · N4862Q · Substantial damageNTSB DEN84LA118Accident · No injuriesLimited investigationFinal reportCessna A188B · Hardin, MTThe plt returned to the arpt with about a 100 gal load of spray solution on board when the flagger would not work. During the landing, the acft swerved to the left & the right gear collapsed. No mechanical malfunction or failure of the gear or brakes was…Mar 28, 1984 · N92593 · Substantial damageNTSB DEN82DTI12Accident · No injuriesFinal reportCessna A188B · Carter, MTThe owner reported that the pilot landed on a road in a crosswind condition. The purpose for landing was to reload for fertilizer application. After touchdown, the aircraft ran off the road and flipped over.Apr 1, 1982 · N731AT · Destroyed