Skip to content

NTSB investigations: Cessna A188B, CA

47 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

19732026

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.Jul 16, 2005 · N731GE · Substantial damage NTSB LAX04LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Planada, CAthe partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…Mar 25, 2004 · N478Q · Destroyed NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.Sep 2, 1998 · N202AW · Destroyed NTSB LAX96LA276Accident · No injuriesLimited investigationFinal reportCessna A188B · Merced, CAFuel exhaustion due to the pilot's inadequate preflight inspection and his failure to ensure that adequate fuel was onboard to complete the flight.Jul 18, 1996 · N731YT · Substantial damage NTSB LAX95LA118Accident · No injuriesLimited investigationFinal reportCessna A-188B · Elmira, CAthe pilot's failure to maintain control of the aircraft after an inadvertent encounter with the wake turbulence from a preceding agricultural aircraft while maneuvering at low altitude.Feb 23, 1995 · N731CZ · Substantial damage NTSB LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.Mar 14, 1992 · N53241 · Destroyed NTSB LAX88DVG10Accident · 1 fatalFinal reportCessna A188B · Dixon, CAPlt had completed aerial application of a field several miles south. Witnesses heard sounds of acft. One witness observed acft briefly inverted and 'out of control.' Acft impacted open field upright, wings level and nose down. Fire ensued. No evidence found…Sep 30, 1988 · N21871 · Destroyed NTSB LAX88DVG06Accident · No injuriesFinal reportCessna 188 · Upper Lake, CAThe acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff…Jun 23, 1988 · N4946Q · Destroyed NTSB LAX88DVA03Accident · No injuriesFinal reportCessna 188B · Gustine, CADuring an aerial application maneuver, at 70 ft. a.g.l., the engine lost all power. The pilot leveled the wings and dumped the remaining load. The engine regained full power, backfired, then lost power again. The aircraft collided with almond trees. An…Apr 2, 1988 · N21762 · Substantial damage NTSB LAX88DVD02Accident · No injuriesFinal reportCessna A188B · Lodi, CAFeb 5, 1988 · N2832J · Substantial damage NTSB LAX86FUG06Accident · No injuriesFinal reportCessna 188 · Thermal, CAThe plt lost directional control of the acft during his 4th takeoff from the rutted rwy surface. The tail wheel slipped into a rut on the rwy and the acft veered to the right where it contacted 8-10 ft tall brush. The acft traveled through the brush,…Sep 30, 1986 · N70240 · Substantial damage NTSB LAX84LA160Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Santa Nella, CADuring a low level ag turn, the acft's left wing impacted an 8-FT high stand pipe. The acft then cartwheeled & crashed. A few weeks before the accident, the plt had personally inspected the field. However, just days before the accident, the standpipe had been…Jan 30, 1984 · N731WR · Substantial damage NTSB LAX83LA466Accident · No injuriesLimited investigationFinal reportCessna 188B · Modesto, CAThe acft collided with a fence during takeoff and pulled the tailwheel out of the empennage. The plt said the dump valvefailed to work or 'struck' so he could not jettison the load. He felt the need to 'dump' when the acft hit a 'softspot' in the gravel and…Apr 15, 1983 · N9961J · Substantial damage NTSB LAX83LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Delhi, CAThe plt reported that he had been spraying fertilizer in the area all day. While taking off from a strip surrounded by trees, the acft climbed above the treetops, then began to settle. Subsequently, it crashed into almond trees & burned. The plt stated that…Mar 11, 1983 · N731JK · Destroyed NTSB LAX82DVD10Accident · Serious injuriesFinal reportCessna A188B · Lodi, CAThe pilot stated that he noted frost on the wings before takeoff, but felt there was not enough to be concerned. He initiated a takeoff on a 2500 ft airstrip with a load of paraquat and water. There was a slight tailwind. He stated that during the takeoff…Feb 23, 1982 · N731RG · Destroyed NTSB LAX81DVA44Accident · No injuriesClosedCessna 188 · Merced, CAMay 13, 1981 · N9752G · Destroyed NTSB LAX81DVA14Accident · No injuriesClosedCessna 188 · Huron, CADec 5, 1980 · N9335R · Substantial damage NTSB LAX80DVA67Accident · No injuriesClosedCessna A188B · Hanford, CASep 26, 1980 · N9158G · Substantial damage NTSB LAX80DVA17Accident · No injuriesClosedCessna 188B · Dos Palos, CAFeb 24, 1980 · N5928G · Destroyed NTSB LAX80DVD04Accident · No injuriesClosedCessna 188 · Courtland, CANov 29, 1979 · N4722Q · Substantial damage NTSB LAX79FVA55Accident · Serious injuriesClosedCessna 188 · Modesto, CAAug 7, 1979 · N70063 · Destroyed NTSB OAK79DVA45Accident · Minor injuriesClosedCessna 188B · Hanford, CAJun 6, 1979 · N9157G · Destroyed NTSB OAK79DVD25Accident · No injuriesClosedCessna A188B · Newman, CAMay 5, 1979 · N731AQ · Substantial damage NTSB OAK79DVA19Accident · No injuriesClosedCessna A188B · Dinuba, CAMar 3, 1979 · N4724R · Substantial damage NTSB LAX79DUM05Accident · No injuriesClosedCessna 188B · Brawley, CAJan 26, 1979 · N731UA · Substantial damage NTSB OAK78FVA86Accident · Serious injuriesClosedCessna 188 · Mendota, CASep 22, 1978 · N4913Q · Destroyed NTSB LAX79FUQ10Accident · No injuriesClosedCessna 188 · 0xnard, CASep 9, 1978 · N4899Q · Substantial damage NTSB OAK78DVA56Accident · No injuriesClosedCessna 188 · Turlock, CAJul 16, 1978 · N731LV · Substantial damage NTSB OAK78DVA55Accident · No injuriesClosedCessna 188B · Modesto, CAJul 14, 1978 · N731DZ · Destroyed NTSB OAK78DVA52Accident · No injuriesClosedCessna 188B · Modesto, CAJun 30, 1978 · N70063 · Substantial damage NTSB OAK78DVA45Accident · No injuriesClosedCessna 188B · Dos Palos, CAMay 22, 1978 · N4747R · Substantial damage NTSB OAK78DVG24Accident · No injuriesClosedCessna 188 · Locke, CAMar 29, 1978 · N4722Q · Substantial damage NTSB OAK78DVD19Accident · No injuriesClosedCessna 188B · Stockton, CAFeb 23, 1978 · N4916R · Substantial damage NTSB OAK78DVA24Accident · No injuriesClosedCessna A188B · Merced, CAFeb 11, 1978 · N9030G · Substantial damage NTSB OAK77DVG55Accident · No injuriesClosedCessna 188 · Courtland, CAAug 1, 1977 · N9439R · Substantial damage NTSB OAK77DVG44Accident · No injuriesClosedCessna 188B · Tulelake, CAJun 22, 1977 · N4842R · Substantial damage NTSB OAK77DVA25Accident · No injuriesClosedCessna 188B · Merced, CAMar 21, 1977 · N4724R · Destroyed NTSB OAK77DVA17Accident · No injuriesClosedCessna A188B · Modesto, CAJan 29, 1977 · N70063 · Substantial damage NTSB OAK76DVD52Accident · No injuriesClosedCessna 188B · Tracy, CAAug 28, 1976 · N4901R · Substantial damage NTSB OAK76FVG87Accident · 1 fatalClosedCessna 188 · Dixon, CAJun 27, 1976 · N4450Q · Destroyed NTSB OAK76FVA51Accident · 1 fatalClosedCessna 188C · Lemoore, CAMar 26, 1976 · N4451Q · Destroyed NTSB OAK76DVG13Accident · No injuriesClosedCessna A188B · Thornton, CAAug 1, 1975 · N9176R · Destroyed NTSB OAK76FVG10Accident · 1 fatalClosedCessna A188B · Vacaville, CAJul 23, 1975 · N6936G · Destroyed NTSB OAK75DVA22Accident · Minor injuriesClosedCessna 188 · Five Points, CASep 26, 1974 · N53230 · Substantial damage NTSB OAK75DVD04Accident · No injuriesClosedCessna 188 · Tracy, CAJul 15, 1974 · N8298G · Substantial damage NTSB OAK75DVA03Accident · No injuriesClosedCessna 188B · Merced, CAJul 10, 1974 · N9352G · Substantial damage NTSB OAK73FVA52Accident · Serious injuriesClosedCessna 188C · Murray, CAMay 2, 1973 · N21698 · Substantial damage