NTSB investigations: Cessna A188B, 2005
14 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\") = 2005
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") = 2005
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 DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB DFW05LA215Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Joiner, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA201Accident · No injuriesData collectionFinal reportCessna 188 · Mexico, MOThe pilot's failure to maintain directional control. Factors were the grass terrain adjacent to the runway and the collapse of the main landing gear.NTSB LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.NTSB DFW05LA171Accident · 1 fatalLimited investigationFinal reportCessna A188B · Piggott, ARThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall.NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.NTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB DFW05CA155Accident · No injuriesData collectionFinal reportCessna A188B · Goodlett, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain (soft) for the forced landing.NTSB DFW05CA176Accident · No injuriesData collectionFinal reportCessna A188B · Truman, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A contributing factor was the sunglare.NTSB CHI05LA114Accident · 1 fatalLimited investigationFinal reportCessna A188B · Ludell, KSThe pilot's failure to maintain clearance from trees during an aerial application maneuver. The trees and the sun glare were contributing factors.NTSB SEA05CA069Accident · No injuriesData collectionFinal reportCessna A188B · Palouse, WAThe pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.