NTSB investigations: Cessna A188B, 1995
19 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\") = 1995
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") = 1995
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 MIA95WA228Accident · No injuriesForeign investigationCessna A188B · Port Of Spain, Trinidad & TobagoNTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.NTSB CHI95LA279Accident · No injuriesLimited investigationFinal reportCessna 188B · Canton, KSfailure of the pilot to obtain the proper flying speed or to abort the takeoff, while there was sufficient runway remaining, which resulted in an inadvertent stall.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.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.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.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.NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB MIA95WA186Accident · No injuriesForeign investigationCessna A188B · Couva, Trinidad & TobagoNTSB MIA95LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Aberdeen, MSThe operator's and pilot's procedure of leaving the aircraft unattended with the engine running while loading agricultural chemicals into the aircraft. This resulted in the aircraft moving unattended and colliding with a ditch. Contributing to the accident…NTSB SEA95LA147Accident · No injuriesLimited investigationFinal reportCessna A188B · Esterbrook, WYThe pilot's failure to attain the proper touchdown point and airspeed for landing. Contributing to the accident were high density altitude, the short landing area, and the pilot's failure to initiate a go-around in time to allow recovery from the situation.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.NTSB FTW95LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Weslaco, TXThe inadequate visual lookout by both pilots. A factor was the inability of the pilots to communicate by radio due to the incompatible equipment installed in the two airplanes.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.NTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.NTSB ATL95LA108Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Garfield, GAThe pilot's failure to maintain flying speed during a climbout from a swath run which resulted in a stall and the subsequent collision with trees.NTSB NYC95LA084Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cairo, OHFailure of the pilot to maintain adequate airspeed after initiating a climb, which resulted in a stall/spin.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.