NTSB investigations: Cessna A188B, 1988
20 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 per year
| 1971 | 1 |
|---|---|
| 1972 | 7 |
| 1973 | 11 |
| 1974 | 37 |
| 1975 | 45 |
| 1976 | 56 |
| 1977 | 85 |
| 1978 | 69 |
| 1979 | 50 |
| 1980 | 60 |
| 1981 | 66 |
| 1982 | 24 |
| 1983 | 26 |
| 1984 | 33 |
| 1985 | 22 |
| 1986 | 20 |
| 1987 | 16 |
| 1988 | 20 |
| 1989 | 19 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 16 |
| 1993 | 16 |
| 1994 | 9 |
| 1995 | 19 |
| 1996 | 14 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 16 |
| 2000 | 15 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 14 |
| 2006 | 5 |
| 2007 | 8 |
| 2008 | 3 |
| 2009 | 8 |
| 2010 | 3 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 5 |
| 2020 | 3 |
| 2021 | 2 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 1988
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 year(c."eventDate") = 1988
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" 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 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…NTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…NTSB ANC88LA134Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Skwentna, AKThe airline transport rated pilot was flying a load of gasoline in a crop duster type airplane to a residence in rural Alaska. The landing site was a river sand bar located near the residence. The pilot stated, and witnesses concur, that the airplane's main…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…NTSB ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCNTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…NTSB ATL88DKG12Accident · No injuriesFinal reportCessna 188B · Bainbridge, GANTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…NTSB FTW88LA143Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dalhart, TXAs the ag airplane tried to level off at the start of the spray run, it continued the descent into the corn and flipped forward to the inverted position. The elevation in the area was 4100 ft MSL and the density altitude was 5000 ft.NTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GANTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…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…NTSB MKC88LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Dighton, KSDuring an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field…NTSB ATL88DMG06Accident · No injuriesFinal reportCessna 188 · Messic, NCDuring turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years.NTSB FTW88DRD03Accident · 1 fatalFinal reportCessna 188 · Winnsboro, LAThe private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full…NTSB MKC88DCJ01Accident · Serious injuriesFinal reportCessna A188B · Dalton, NEThe pilot was spraying a large field which had a power line along the north side. On the 1st couple of passes, the spray equipment had intermittent malfunctions. As the aircraft approached the field from north for the 4th pass, it struck the upper cable of…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…NTSB MKC88LA064Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Manter, KSWhile conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the…NTSB MIA88LA111Accident · No injuriesLimited investigationFinal reportCessna A188B · Macon, MSThe plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…NTSB LAX88DVD02Accident · No injuriesFinal reportCessna A188B · Lodi, CA