NTSB investigations: Cessna A188B, 1992
16 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\") = 1992
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") = 1992
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 FTW93LA006Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Montrose, ARThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's diverted attention in the cockpit.NTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.NTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.NTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.NTSB ATL92LA148Accident · No injuriesLimited investigationFinal reportCessna 188 · Town Creek, ALThe inadequate preflight planning/preparation by the pilot which resulted in reduced aircraft performance and the collision with trees during climbout. Factors were the soft and wet terrain.NTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.NTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB CHI92DCQ03Accident · No injuriesFinal reportCessna A188B · Meade, KSThe pilot's improper preflight planning/preparation and his exceeding the aircraft's takeoff capability.NTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.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 LAX92LA142Accident · No injuriesLimited investigationFinal reportCessna A188B · Corcoran, CAThe aircraft's encounter during the takeoff with a crosswind gust beyond the capability of the aircraft.