NTSB investigations: Cessna A188B, 1998
13 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\") = 1998
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") = 1998
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 MIA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilot's decision to attempt a flight with an unairworthy condition (leaky brake) and improper use of brakes on landing rollout. This resulted in a loss of brake fluid, directional control, ground loop, and on ground collision with terrain.NTSB ATL99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Tellasse, ALThe pilot's failure to maintain clearance from a utility line while conducting a swath run.NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB MIA98LA220Accident · No injuriesLimited investigationFinal reportCessna 188 · Atlantic Ocean (Atlantic Ocean)A complete loss of engine power due to loss of oil pressure, resulting in a force landing on non suitable terrain, and the subsequent sinking of the airplane in deep water.NTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.NTSB FTW98LA324Accident · No injuriesLimited investigationFinal reportCessna A188B · Erie, COThe pilot's failure to maintain directional control of the airplane. A factor was a crosswind gust.NTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.NTSB CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.NTSB FTW98FA290Accident · 1 fatalField investigationFinal reportCessna A188B · Panhandle, TXThe pilot's failure to maintain clearance from the power transmission wires while maneuvering during an aerial application flight.NTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.NTSB ANC98LA066Accident · No injuriesLimited investigationFinal reportCessna 188B · Talkeetna, AKThe pilot's failure to identify an unsafe/hazardous taxiway condition. A factor associated with this accident was the presence of rough and uneven terrain conditions.NTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.NTSB MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…