NTSB investigations: Cessna T188C, 1984
7 cases on aircraft the registry lists as Cessna T188C. 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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1979 | 4 |
| 1980 | 10 |
| 1981 | 8 |
| 1982 | 15 |
| 1983 | 11 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 2 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073012'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073012'))
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 MIA84LA220Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Pelham, GAThe acft landed short of the rwy during a forced landing after the engine quit on final approach. The plt reported that he had experienced trouble keeping the engine running at low power settings.NTSB DEN84LA252Accident · No injuriesLimited investigationFinal reportCessna 188 · Holyoke, COThe pilot lost directional control after landing with a rear right quartering crosswind reported at 5 KTS. Use of opposite rudder and braking was ineffective in regaining directional control. The pilot reported no response from the left brake and stated…NTSB ATL84LA217Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Glen Allen, MSThe plt stated that while doing aerial applications and flying into the sun he failed to see a tree and collided with it. The pilot was not wearing sunglasses nor was the aircraft equipped with sun shading devices.NTSB SEA84LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Pasco, WAWhile taxiing to takeoff, the right main gear got into soft terrain off the right edge to the rwy. This pulled the acft to the right & the right wing struck an embankment. The right main gear collapsed & the right wing was buckled.NTSB DEN84LA197Accident · No injuriesLimited investigationFinal reportCessna T188C · Philip, SDThe plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.NTSB ATL84LLT11Accident · No injuriesFinal reportCessna T188C · Shelby, MSAcft was departing on the ninth aerial application flt of the operation. Weather had been clear but thunderstorms were building in the local area. On takeoff roll, a strong gust from the left rear caused loss of directional control. Acft veered left and…NTSB MIA84LA080Accident · No injuriesLimited investigationFinal reportCessna T-188 · Arcadia, FLThe plt was maneuvering at low alt and low airspeed during aerial application. During a steep (80 bank) the acft stalledand crashed.