NTSB investigations: Cessna T188C
13 cases on aircraft the registry lists as Cessna T188C, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 3 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2005 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 LAX06CA022Accident · No injuriesData collectionFinal reportCessna T188C · Beatty, NVthe pilot's inadequate compensation for gusty wind conditions and failure to maintain directional control of the airplane on the landing roll.NTSB LAX97LA293Accident · No injuriesLimited investigationFinal reportCessna 188 · Eloy, AZThe pilot's improper recovery from a bounced landing and his failure to maintain directional control due to inadequate rudder use.NTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.NTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.NTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.NTSB LAX93LA136Accident · No injuriesLimited investigationFinal reportCessna T188C · Delhi, CAThe pilot selected unsuitable terrain for takeoff and failed to maintain directional control of the aircraft. A factor in the accident was the standing water on the runway.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB FTW89DQG06Accident · Minor injuriesFinal reportCessna T188C · Levelland, TXA partial brake system failure due to a leak in the left brake master cylinder.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 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 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 DEN83LA028Accident · No injuriesLimited investigationFinal reportCessna T188C · Santa Rita, MTAircraft nosed over during landing. Aircraft was swerving left after brake application. More braking was used and aircraft nosed over.