NTSB investigations: Cessna A188B
24 cases on aircraft the registry lists as Cessna A188B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2005 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.NTSB ATL97LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Zellwood, FLfailure of mechanics to adequately torque the crankcase through-bolts following a top overhaul, which subsequently resulted in a crankshaft failure. Soft/uneven terrain in the emergency landing area was a related factor.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.NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.NTSB CHI93DCQ02Accident · No injuriesFinal reportCessna 188 · Buhler, KSthe loss of engine power due to a fractured accessory (camshaft) drive gear.NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.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 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 SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.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 ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCNTSB LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…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…NTSB SEA86LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Nyssa, ORDuring aerial application the engine ceased operating due to a broken shaft in the fuel pump. The boost pump was turned on and the engine ran momentarily. The pilot was unable to dump his 700 pounds of dry chemical and had to keep a nose down attitude in…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…NTSB ATL84LA230Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Georgetown, MSThe plt reported that during a pull-up, the prop went to a low pitch angle & the eng was not developing full power. He noted that the tachometer was near the red line & he retarded the prop pitch control & the throttle. Also, he noted that the oil pressure…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…NTSB MKC84LA159Accident · No injuriesLimited investigationFinal reportCessna A188B · Campbell, NEDuring a forced landing in a milo field, the spray bar caught in the crop, causing the acft to pitch nose down before coming to a stop, damaging the wings and propeller.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…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…NTSB NYC83FFJ01Accident · No injuriesFinal reportCessna A188B · Williamson, NYThe acft collided with a tree during a forced landing after a power loss on takeoff. The pilot had a load of 125 gallonsof a fungicide for spraying trees when the engine quit at about 100 ft AGL. The load was dumped and the acft was turned to the right for a…NTSB NYC82FFA06Accident · No injuriesFinal reportCessna A188B · White Lake, NYWhile returning from a spraying operation, the engine began running rough, and within seconds, it lost power. The pilot was unable to restart the engine, and subsequently, ditched the aircraft in a reservior. An engine teardown revealed that the crankshaft…