Skip to content

NTSB investigations: Cessna A188B, MO

24 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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 CEN23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Chillicothe, MOThe pilot’s decision to operate the airplane with a known tailwheel anomaly, which resulted in a loss of directional control.Aug 11, 2023 · N9237R · Substantial damage NTSB WPR23LA218Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Chillicothe, MOA partial loss of engine power due to a tear in the fuel manifold diaphragm, which prevented sufficient fuel flow to the engine.Jun 7, 2023 · N731UF · Destroyed NTSB CEN20CA320Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna A188 · Memphis, MOThe pilot did not remove the rudder gust lock during the preflight inspection, which resulted in a forced landing and collision with a tree.Jul 31, 2020 · N90834 · 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 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 damage NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.Jun 26, 2007 · N4998Q · Substantial damage NTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.Jul 26, 2005 · N731SV · Substantial damage NTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.Jun 19, 2005 · N9778G · Destroyed NTSB CHI03LA168Accident · No injuriesLimited investigationFinal reportCessna A188B · Hornersville, MOThe pilot's failure to maintain directional control of the airplane during takeoff. A contributing factor was the crosswind.Jun 17, 2003 · N70403 · Substantial damage NTSB CHI02LA282Accident · No injuriesLimited investigationFinal reportCessna A188B · Dexter, MOThe fatigue fracture of the connecting rod, the recommended engine overhaul not performed by the company, and the low altitude flight.Sep 9, 2002 · N4919Q · Substantial damage NTSB CHI00LA094Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hayti, MOthe failure of maintenance personnel to properly install and connect the aileron control rod. Factors were the inadequate annual inspection by maintenance personnel and the aileron control not possible by the pilot.Mar 21, 2000 · N4859Q · Substantial damage NTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.Jul 15, 1996 · N9703J · Substantial damage NTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.Jun 16, 1992 · N731GX · Substantial damage NTSB CHI90LA216Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Salisbury, MOProper touchdown point not attained and go-around not performed by the PIC.Aug 7, 1990 · N9106R · Substantial damage NTSB MKC83LA218Accident · No injuriesLimited investigationFinal reportCessna 188B · Catron, MOThe acft went out of control during the takeoff roll from a farm field. The plt states that as the roll began the left wing started to drop and the acft began turning left. The plt tried to correct with right brake but was unable to make a correction. The…Sep 8, 1983 · N4889Q · Substantial damage NTSB MKC81FCG46Accident · No injuriesClosedCessna A188B · Orrick, MOJul 11, 1981 · N731BD · Substantial damage NTSB MKC80FCA26Accident · No injuriesClosedCessna 188B · Advance, MOJul 11, 1980 · N84354 · Substantial damage NTSB MKC80DCG29Accident · Minor injuriesClosedCessna 188 · Cameron, MOJun 25, 1980 · N9136R · Destroyed NTSB MKC80DCG30Accident · No injuriesClosedCessna 188B · Bigelow, MOJun 24, 1980 · N731GR · Substantial damage NTSB MKC78FCA21Accident · No injuriesClosedCessna A188B · Marston, MOMar 17, 1978 · N84354 · Substantial damage NTSB MKC78DCA04Accident · No injuriesClosedCessna A188B · Kahoka, MOOct 27, 1977 · N9333R · Substantial damage NTSB MKC77FCA29Accident · No injuriesClosedCessna A188B · Senath, MOJul 15, 1977 · N53213 · Substantial damage NTSB MKC76DCA43Accident · No injuriesClosedCessna A188B · Portageville, MOAug 21, 1976 · N4833R · Destroyed NTSB MKC75FCA23Accident · No injuriesClosedCessna 188B · Caruthersville, MOApr 4, 1975 · N8278G · Substantial damage