Skip to content

NTSB investigations: Cessna A188B, MT

21 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

19762026

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" = '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')) 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\" = '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'))
  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" = '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'))
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 SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.Aug 9, 1999 · N9085R · Substantial damage NTSB SEA99LA095Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Big Sandy, MTThe pilot's failure to maintain clearance between the wire and his aircraft. A transmission wire and downdraft were factors.Jun 24, 1999 · N4788Q · Substantial damage NTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…Jun 29, 1996 · N731ED · Substantial damage NTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.Sep 9, 1993 · N731ED · Substantial damage NTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.Sep 2, 1993 · N21861 · Destroyed NTSB SEA90LA154Accident · No injuriesLimited investigationFinal reportCessna 188B · Denton, MTThe premature liftoff during takeoff ground roll by the pilot, resulting in a stall.Aug 3, 1990 · N9632G · Substantial damage NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.Jun 15, 1989 · N4971Q · Substantial damage NTSB 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 damage NTSB DEN87LA119Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Ignatius, MTAn ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an…May 6, 1987 · N9282R · Substantial damage NTSB 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 damage NTSB DEN84LA181Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTThe acft was damaged in a forced landing after the engine quit. The plt said that several weeks prior to the accident hediscovered the fuel crossover quick drain was 'frozen' shut and would not drain. He removed the drain to lubricate it and upon…Jun 19, 1984 · N731GL · Substantial damage NTSB 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 damage NTSB DEN83LA137Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Saco, MTThe acft collided with telephone lines during an aerial application run. The pilot's son reported that the acft was pulling up at the end of a spray run when the wires were hit. Most of the wires in this area are underground however thewires at the end of…Jun 10, 1983 · N4812Q · Substantial damage NTSB 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 NTSB DEN81FTI08Accident · Serious injuriesClosedCessna 188B · Turner, MTMay 27, 1981 · N4827Q · Substantial damage NTSB DEN80FTI07Accident · No injuriesClosedCessna 188B · Havre, MTMay 17, 1980 · N9172G · Substantial damage NTSB SEA79FTI18Accident · No injuriesClosedCessna 188 · Toston, MTJun 9, 1979 · N4810Q · Substantial damage NTSB SEA79DTI10Accident · No injuriesClosedCessna 188 · Carter, MTMar 21, 1979 · N21759 · Substantial damage NTSB SEA78FTI17Accident · No injuriesClosedCessna 188B · Chinook, MTMay 21, 1978 · N9355R · Substantial damage NTSB SEA77FTA19Accident · Minor injuriesClosedCessna 188 · Billings, MTMay 24, 1977 · N70146 · Substantial damage NTSB SEA76FTI27Accident · No injuriesClosedCessna 188B · Three Forks, MTMay 17, 1976 · N4810Q · Substantial damage