NTSB investigations: Cessna A188B, 1994
9 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\") = 1994
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") = 1994
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 ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.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 MIA94LA204Accident · No injuriesLimited investigationFinal reportCessna 188B · Indian River, FLThe total loss of engine power for undetermined reasons over terrain unsuitable for a forced landing.NTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.NTSB ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.NTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.NTSB ATL94LA132Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Tifton, GAThe pilot's failure to follow the aircraft checklist, resulting in an attempted takeoff with the elevator trim improperly set. A factor was the trees at the perimeter of the airstrip.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.