NTSB investigations: Cessna A188B, 1989
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\") = 1989
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") = 1989
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 FTW90DRA01Accident · Minor injuriesFinal reportCessna A188B · Muldoon, TXA total power loss due to water contamination in the fuel. A factor was the pilot's inadequate preflight inspection.NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.NTSB MIA90LA002Accident · No injuriesLimited investigationFinal reportCessna A188B · Wauchula, FLFuel starvation, improper planning/decision by the pilot, and his failure to attained the emergency procedure. Factors related to the accident were: the low fuel level, and improper planning/decision by the pilot.NTSB DEN89LA213Accident · No injuriesLimited investigationFinal reportCessna 188B · Sunland Park, NMUndetermined. A factor related to the accident was the crop in the emergency landing area.NTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.NTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.NTSB ATL89DKJ09Accident · 1 fatalFinal reportCessna 188B · Prattville, ALFailure of the pilot to maintain clearance from obstructions (trees).NTSB MIA89LA215Accident · No injuriesLimited investigationFinal reportCessna 188 · Canton, MSThe pilot's attempted flight in known adverse weather conditions. Factors related to the accident were: adverse weather conditions and the presence of the parked aircraft near the runway.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.NTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.NTSB FTW89DQG04Accident · No injuriesFinal reportCessna A188B · Vega, TXThe unfavorable wind condition (probable whirlwind or severe wind shear) that was encountered moments after lift-off.NTSB MKC89LA140Accident · No injuriesLimited investigationFinal reportCessna 188B · Grygla, MNInadequate preflight planning and preparation by the pilot. Tall grass (high vegetation) at the end of the strip was a contributing factor.NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB FTW89DRG07Accident · No injuriesFinal reportCessna A188B · La Coste, TXThe pilot's failure to attain sufficient airspeed for flight at departure.NTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.NTSB DEN89LA106Accident · No injuriesLimited investigationFinal reportCessna A188B · Rapelje, MTThe inadequate compensation for the wind conditions by the pilot which resulted in a loss of directional control on landing and subsequent collision with a ditch.NTSB ATL89DKG02Accident · Minor injuriesFinal reportCessna A188B · Statesboro, GAImproper inflight planning which allowed the engine to lose power due to fuel exhaustion.