NTSB investigations: Cessna A188B
937 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.
Cases, newest first
Query with SQL
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.\"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."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" DESCRun 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 ATL94LA080Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Latta, SCThe pilot's failure to obtain flying speed and the premature lift off which resulted in a stall.NTSB MIA94LA011Accident · Minor injuriesLimited investigationFinal reportCessna AT188B · Zellwood, FLPartial loss of engine power for undetermined reasons.NTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.NTSB FTW93LA260Accident · No injuriesLimited investigationFinal reportCessna A188B · Manila, ARPartial loss of engine power due to the collapse of an air induction hose.NTSB SEA93LA200Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waterville, WAThe pilot's inadequate visual lookout and failure to maintain clearance from the powerline.NTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.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.NTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.NTSB CHI93LA314Accident · No injuriesLimited investigationFinal reportCessna 188 · Martin, SDthe pilot's failure to maintain control of the airplane during the takeoff roll.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.NTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.NTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.NTSB FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.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.NTSB NYC93LA097Accident · 1 fatalLimited investigationFinal reportCessna A188B · Marengo, OHThe pilot's misjudged clearance from obstacles during aerial application, resulting in a collision with trees. A factor in this accident was the pilot's lack of total experience in aerial application flying.NTSB FTW93LA006Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Montrose, ARThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's diverted attention in the cockpit.NTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.NTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.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.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.NTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.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.NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.NTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB CHI92DCQ03Accident · No injuriesFinal reportCessna A188B · Meade, KSThe pilot's improper preflight planning/preparation and his exceeding the aircraft's takeoff capability.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.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.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.NTSB MIA91LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Yazoo City, MSSeparation of the right main landing gear during take off due to failure of the bolts which secure the gear to the airframe. Contributing to the accident was the failure of the pilot to abort the takeoff.NTSB CHI91DCJ08Accident · No injuriesFinal reportCessna 188B · Belgrade, NEThe pilot's failure to take adequate remedial action. A related factor is the premature liftoff.NTSB BFO91LA076Accident · No injuriesLimited investigationFinal reportCessna A188B · New Market, MDInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the inoperative fuel quantity gages.NTSB CHI91DCJ06Accident · 1 fatalFinal reportCessna A188D · Gothenburg, NEThe pilot's failure to maintain airspeed which resulted in a stall. A factor related to the accident was the pilot's abrupt handling of the airplane.NTSB MIA91LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Monticello, FLLoss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB FTW91DRG05Accident · 1 fatalFinal reportCessna 188B · Driscoll, TXThe pilot's failure to maintain clearance from the guy wire during the aerial application maneuver.NTSB CHI91DEM07Accident · No injuriesFinal reportCessna 188B · Munger, MIA premature liftoff by the pilot. A factor contributing to this accident was the soft runway surface and a stall/mush.NTSB ATL91LA130Accident · 1 fatalLimited investigationFinal reportCessna 188 · Snow Hill, NCInadequate visual lookout by the pilot. Factors to the accident were tree.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.NTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.NTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.NTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.NTSB FTW91LA113Accident · No injuriesLimited investigationFinal reportCessna A188B · Lewisville, ARThe failure of the right brake line during a critical phase of operation.NTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.NTSB MIA91LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Doddsville, MSPoor planning decision by the pilot for failure to take into account the temperature extremes and what effect this would have on the ground roll distance. Contributing to the accident was his lack of total experience in the type of operation.