Skip to content

NTSB investigations: Cessna A188B, AL

27 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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.Oct 2, 1998 · N4832R · Substantial damage NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.Aug 13, 1995 · N4940R · Destroyed NTSB ATL95LA151Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe chafing of the fuel flow gage pressure line with an electrical system wire which resulted in arcing.Aug 10, 1995 · N731DB · Destroyed NTSB ATL95LA150Accident · No injuriesLimited investigationFinal reportCessna 188T · Town Creek, ALThe pilot's failure to check the runway condition prior to takeoff. The soft runway was a factor.Aug 8, 1995 · N731MK · Substantial damage NTSB ATL95LA126Accident · No injuriesLimited investigationFinal reportCessna A188B · Decatur, ALThe pilot's selection of unsuitable terrain for a precautionary landing. Which resulted in the collapse of the main landing gear. The undetermined aircraft problem and rough/uneven terrain were related factors.Jul 3, 1995 · N6296G · Substantial damage NTSB ATL95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Huntsville, ALThe downdraft weather condition, and the pilot's failure to maintain adequate clearance from the terrain during his maneuver.Jun 15, 1995 · N5621G · Destroyed NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.Jun 29, 1993 · N731DH · Substantial damage NTSB ATL93LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's failure to maintain clearance from trees during agricultural application maneuvering. Factors were the trees in the vicinity of the planned flight path.Jun 5, 1993 · N91676 · Destroyed NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.Sep 2, 1992 · N4845Q · Substantial damage NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.Aug 19, 1992 · N731PV · Substantial damage NTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.Jul 30, 1992 · N4495Q · Substantial damage NTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.Sep 20, 1990 · N8677G · Substantial damage NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).Aug 16, 1989 · N9318G · Destroyed NTSB ATL89DKJ08Accident · Serious injuriesFinal reportCessna A188B · Atmore, ALPilot's failure to maintain visual lookout for obstacles. Contributing to the accident was the low (dawn) position of the sun which interfered with the pilot's vision.Jul 26, 1989 · N21612 · Substantial damage NTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.Jul 22, 1989 · N5618G · Destroyed NTSB ATL88DKG01Accident · No injuriesFinal reportCessna 188 · Samson, ALThe plt said the prop surged during a swath run. While rtning to land the engine quit. The acft landed in a plowed field, resulting in substantial damage to the rt wing and lndg gear. Inspection of the engine by the plt revealed that the oil filter adapter…Oct 15, 1987 · N731RF · Substantial damage NTSB ATL86LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Magnolia Spring, ALDuring a spray run the plt attempted to climb over a tall tree, the acft failed to clear the tree which was contacted with the right wing. The acft then crash landed in a field. The acft was observed to stagger during several turns earlier in the operation.…Jun 7, 1986 · N9105R · Substantial damage NTSB ATL85LA236Accident · No injuriesLimited investigationFinal reportCessna A188B · Trenton, ALThe pilot stated that the eng lost power while he was maneuvering for another spray run over the field. The aircraft settled into the trees and a post-crash fire developed.Aug 5, 1985 · N21708 · Destroyed NTSB ATL85LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Clanton, ALThe acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await…Jul 31, 1985 · N9381G · Substantial damage NTSB ATL84FKJ02Accident · 1 fatalFinal reportCessna A188B · Hazel Green, ALThe acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…Oct 29, 1983 · N731JJ · Destroyed NTSB ATL83LA341Accident · No injuriesLimited investigationFinal reportCessna A188B · Samson, ALThe acft collided with a dirt bank during a forced landing after an inflt power loss. The pilot was enroute to a field at about 500 ft AGL when the power loss occurred. The pilot did not jettison his load of chemicals. He landed on wet grass and was unable to…Aug 27, 1983 · N9172R · Substantial damage NTSB ATL83LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe acft collided with a cow during takeoff for an aerial application flt. The collision broke off the right main landing gear and killed the cow. The pilot stated that the cow got through the fence and wandered onto the strip. The airstrip has a small rise…Jul 2, 1983 · N9381G · Substantial damage NTSB ATL83LA170Accident · No injuriesLimited investigationFinal reportCessna A-188B · New Hope, ALThe acft struck powerlines and crashed during an emergency landing after a loss of power while spraying on an aerial application mission. The plt stated that while spraying he noticed oil beginning to cover the windshield. He had begun aclimb and dumped the…Apr 26, 1983 · N4874R · Substantial damage NTSB MIA76FKJ62Accident · Serious injuriesClosedCessna A188B · Mobile, ALMay 19, 1976 · N9013R · Destroyed NTSB MIA76DKJ26Accident · No injuriesClosedCessna A188B · Centre, ALOct 10, 1975 · N4490Q · Substantial damage NTSB MIA76DKJ21Accident · No injuriesClosedCessna 188 · Muscle Shoals, ALSep 19, 1975 · N5618G · Substantial damage NTSB MIA76DKJ12Accident · Serious injuriesClosedCessna A188B · Muscle Shoals, ALAug 10, 1975 · N8220G · Substantial damage