Skip to content

NTSB investigations: Cessna A188B, OK

28 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

19742026

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 FTW04LA162Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Rush Springs, OKThe pilot's failure to maintain clearance with a utility pole and power lines while maneuvering during an aerial application.Jun 15, 2004 · N21650 · Substantial damage NTSB FTW03LA151Accident · No injuriesLimited investigationFinal reportCessna A188B · Kinta, OKThe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's failure to supervise the refueling of the aircraft and failure to use his before takeoff checklist.May 15, 2003 · N4931R · Substantial damage NTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.Sep 5, 1999 · N731PW · Substantial damage NTSB FTW96LA094Accident · No injuriesLimited investigationFinal reportCessna A188B · Enid, OKThe pilot's failure to maintain sufficient airspeed during the forced landing and to jettison the aircraft's load for a forced landing. A factor was the engine's failure due to a disconnected fuel line which was the result of improper maintenance.Jan 12, 1996 · N4744Q · Substantial damage NTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.Apr 6, 1992 · N70321 · Substantial damage NTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.Apr 6, 1991 · N4165J · Substantial damage NTSB FTW91LA058Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hobart, OKThe pilot's failure to maintain clearance with known objects.Apr 3, 1991 · N53215 · Destroyed NTSB FTW88DPJ10Accident · No injuriesFinal reportCessna A188B · Holdenville, OKThe aircraft was in cruise flight at 500 ft AGL when a total loss of power occurred. The pilot jettisoned the load and executed an emergency descent to land at the nearest available clearing. The aircraft collided with the terrain with high rate of descent…Aug 21, 1988 · N731CT · Destroyed NTSB FTW85LA322Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cushing, OKThe plt was test flying the acft after a major eng overhaul.a left turn was made away from the arpt after takeoff and immediately thereafter the eng lost pwr. With no suitable landing area within gliding distance, the acft was manuevered straight ahead where…Aug 15, 1985 · N21814 · Destroyed NTSB FTW84LA385Accident · No injuriesLimited investigationFinal reportCessna A188B · Maysville, OKWith aprx 300 ft of rwy remaining the plt rotated. The acft flew to about 15 ft before it settled back to the ground at the end of the sod strip. After rolling through 2 fences the acft collided with a dirt bank next to a ditch collapsing the main gear. The…Sep 11, 1984 · N9560G · Destroyed NTSB FTW84LA257Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Ripley, OKAcft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed.May 31, 1984 · N731KU · Substantial damage NTSB FTW81DPJ39Accident · No injuriesClosedCessna 188B · Anioch, OKSep 20, 1981 · N9560G · Substantial damage NTSB FTW81DPM15Accident · Serious injuriesClosedCessna A188B · Mcalester, OKJun 30, 1981 · N4823Q · Destroyed NTSB FTW81DPJ15Accident · No injuriesClosedCessna 188 · Seiling, OKApr 9, 1981 · N4830R · Substantial damage NTSB FTW81DPJ13Accident · No injuriesClosedCessna A188B · Cherokee, OKApr 1, 1981 · N731AM · Substantial damage NTSB FTW81DPJ11Accident · Serious injuriesClosedCessna A188B · Duncan, OKMar 11, 1981 · N86547 · Destroyed NTSB FTW80FPJ14Accident · No injuriesClosedCessna 188 · Olustee, OKApr 29, 1980 · N5635G · Substantial damage NTSB FTW80FPM02Accident · No injuriesClosedCessna 188B · Henryetta, OKOct 19, 1979 · N4727Q · Destroyed NTSB FTW79DPJ21Accident · No injuriesClosedCessna A188B · Cushing, OKMay 26, 1979 · N8358G · Substantial damage NTSB FTW78FPJ19Accident · No injuriesClosedCessna A188B · Kingfisher, OKMay 17, 1978 · N91138 · Substantial damage NTSB FTW78FPJ05Accident · 1 fatalClosedCessna A188B · Thomas, OKNov 3, 1977 · N4833R · Destroyed NTSB FTW78DPJ01Accident · No injuriesClosedCessna A188B · Albert, OKOct 5, 1977 · N6090G · Substantial damage NTSB FTW77FPJ20Accident · Serious injuriesClosedCessna A188B · Cherokee, OKJun 3, 1977 · N8210G · Destroyed NTSB FTW77DPJ21Accident · Minor injuriesClosedCessna A188 · Lawton, OKJun 3, 1977 · N9367R · Substantial damage NTSB FTW77FPJ10Accident · Minor injuriesClosedCessna A188B · Altus, OKMar 20, 1977 · N6500G · Substantial damage NTSB FTW76DPJ11Accident · No injuriesClosedCessna A188B · Albert, OKSep 1, 1975 · N53144 · Substantial damage NTSB FTW75FPM04Accident · Minor injuriesClosedCessna A188B · Atoka, OKAug 31, 1974 · N8638G · Destroyed NTSB FTW74FPM27Accident · No injuriesClosedCessna 188B · Dustin, OKJun 13, 1974 · N9541G · Destroyed