NTSB investigations: Cessna T188C, 1987
6 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\") = 1987
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") = 1987
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 DEN87LA193Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Pisek, NDThe plt was preparing to spray a potato field with a mixture of water and 2 lbs of 'blight-out.' He made one observation pass over the field to check for obstructions and noticed two sets of power lines, one on the east side of a road and the other on the…NTSB DEN87LA183Accident · No injuriesLimited investigationFinal reportCessna T188C · Winnett, MTDuring landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged.NTSB CHI87DER08Accident · No injuriesFinal reportCessna T188C · Olivia, MNDuring a 180 degree turn from completion of a spray swath the aircraft began to sink. The pilot dumped his load and added power, however was unable to arrest sink. When it was obvious that impact with the ground was imminent, the pilot reduced power and…NTSB FTW87DRD09Accident · No injuriesFinal reportCessna T188C · Rayville, LAThe aircraft had to take off eastbound due to obstructions at the west end of the strip. The six to eight knot wind was variable from a right crosswind to a slight tailwind. Investigation revealed the aircraft's weight exceeded that established by the…NTSB SEA87LA114Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Yerington, NVWhile on an aerial application swath run the pilot allowed the aircraft landing gear to contact the grain crop, resulting in loss of airspeed, uncontrolled descent, impact with the ground and nose over.NTSB MKC87LA118Accident · No injuriesLimited investigationFinal reportCessna 188C · Dalton, NEThe PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.