NTSB investigations: Cessna A188B

8 cases on aircraft the registry lists as Cessna A188B, where the sequence of events included Loss of engine power (total). 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

20092026

NTSB investigations: Cessna A188B per year, 2009–2026: 8 cases
2009	2
2011	1
2018	2
2021	1
2026	2

Where

Open the map

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."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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))) 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.\"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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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."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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN26LA199Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Blair, NEOn May 27, 2026, about 1130 central daylight time, a Cessna A188B airplane, N84497, sustained substantial damage when it was involved in an accident near Blair, Nebraska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…May 27, 2026 · N84497 · Substantial damage NTSB ERA26LA216Accident · No injuriesClass 3 · LimitedPreliminary reportCessna A188B · Doerun, GAOn May 23, 2026, about 1500 eastern daylight time, a Cessna A188B, N8288G, was substantially damaged when it was involved in an accident near Doerun, Georgia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…May 23, 2026 · N8288G · Substantial damage NTSB ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.Apr 15, 2021 · N731TB · Substantial damage NTSB CEN18LA321Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Sedalia, MOA total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.Aug 6, 2018 · N4996R · Destroyed NTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.Jul 12, 2018 · N2483J · Minor damage NTSB CEN11LA513Accident · No injuriesLimited investigationFinal reportCessna A188B · Mount Hamill, IAThe loss of engine power due to fuel starvation and the pilot's inadequate fuel management.Jul 23, 2011 · N9234R · Substantial damage NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.Aug 20, 2009 · N4842R · Substantial damage NTSB CEN09LA447Accident · No injuriesLimited investigationFinal reportCessna A188B · Suring, WIA loss of engine power resulting from the fatigue failure of the crankshaft due to the loss of engine case through-bolt torque. Contributing to the engine failure was the operator's failure to overhaul the engine in accordance with the manufacturer's…Jul 16, 2009 · N9747G · Substantial damage