NTSB investigations: Cessna A188B

6 cases on aircraft the registry lists as Cessna A188B, where NTSB found Airspeed. 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

20082026
NTSB investigations: Cessna A188B per year, 2008–2026: 6 cases
20081
20092
20111
20171
20261

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.\"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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062010')))
  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 CEN26LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Algona, IAThe pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall.Jul 29, 2026 · N731CQ · Substantial damageNTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…Aug 4, 2017 · N3047J · Substantial damageNTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.Jul 22, 2011 · N731AU · Substantial damageNTSB ERA10LA059Accident · No injuriesLimited investigationFinal reportCessna A188B · Ripley, MSThe pilot’s failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall. Contributing to the accident was a partial loss of engine power due to water in the fuel.Nov 8, 2009 · N9368G · Substantial damageNTSB ERA09CA319Accident · No injuriesData collectionFinal reportCessna A188B · Kingstree, SCThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Jun 3, 2009 · N9364R · Substantial damageNTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.Aug 20, 2008 · N53243 · Substantial damage