NTSB investigations: Cessna T188C, 1983
11 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
Latest 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\") = 1983
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") = 1983
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 CHI83LER02Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring takeoff the eng lost power & the acft crashed landed collapsing the gear. The crankshaft, P/N631716, had broken in the cheek area between #2 & #3 crank throws. 1 month prior to this accident the acft had collided with a fence. Afterinstalling a new…NTSB DEN83LA190Accident · No injuriesLimited investigationFinal reportCessna T188L · Wahpeton, NDThe acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision…NTSB ATL83LA310Accident · No injuriesLimited investigationFinal reportCessna T188C · Semmes, ALThe acft collided with a power line during an aerial application maneuver. There were 2 set of wires crossing the area, a low set and a high set. The pilot suddenly came upon the low set and climbed over them but collided with the high set. The vertical…NTSB DEN83LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Bozeman, MTThe acft settled into trees after the engine lost power during a swath run. The flt had been in progress for about 15 minutes. The plt started the 4th run and the acft started to settle. The plt dumped the load but did not touch the throttle or mixture. He…NTSB DEN83LA164Accident · No injuriesLimited investigationFinal reportCessna T188C · Carthage, SDThe acft was using a county road near the field being sprayed for takeoff. The pilot reported that the herbicide sloshedout onto the windscreen during takeoff and obscured his vision. The acft veered right and entered the ditch. The pilot said the hopper lid…NTSB FTW83LA292Accident · No injuriesLimited investigationFinal reportCessna T188C · Eudora, ARDuring the return trip to the arpt, the eng lost power & the plt landed in an open field with soft terrain. Shortly after touchdown, the right main gear dug into the soft soil & collapsed. A fire started after the acft came to rest & it was destroyed. The…NTSB FTW83LA301Accident · No injuriesLimited investigationFinal reportCessna T188C · Waxahachie, TXThe acft collided with a ditch and cartwheeled to a stop during landing. The plt stated that a downdraft was encounteredover the threshold and the acft touched down left of the centerline. The wing and spray room caught in tall grass and the acft veered into…NTSB LAX83LA177Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Soloman, AZThe acft experienced a partial power loss and made an emergency landing in the field it was spraying. The acft had only made one spraying pass since being serviced with a full load of fuel and 140 gallons of chemical before the power loss occurred. As the…NTSB MIA83FLA01Accident · Serious injuriesFinal reportCessna T188C · St. Augustine, FLThe plt reported that he had just completed east to west swath runs & turned toward the sun to trim the east side of the field. Also, he reported that his windshield was covered with spray mist which restricted his visibility. Subsequently, he did not see how…NTSB LAX83LA142Accident · No injuriesLimited investigationFinal reportCessna T188C · Clarksburg, CAAccording to the plt, he was taking off from a narrow gravel strip with a x-wind when he encounter a strong gust. Reportedly, he lost control when the acft was about 1 ft AGL & the right main wheel hit a ditch. Subsequently, the acft was spun around & was…NTSB ATL83LA112Accident · No injuriesLimited investigationFinal reportCessna T188C · Puckett, MSThe acft was damaged during a forced landing after the engine quit due to fuel exhaustion. The plt stated that he forgotto check the fuel prior to takeoff. He said he was upset and distracted because his employees did not want to work on Saturday. Examination…