NTSB investigations: Cessna T188C
21 cases on aircraft the registry lists as Cessna T188C, where the first occurrence was “In flight collision with object”. 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 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 2002 | 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\" = 220))
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" = 220))
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 DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB FTW02LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Forrest City, ARthe pilot's failure to maintain clearance with a light pole and power lines during an aerial application flight.NTSB FTW96TA400Accident · No injuriesFinal reportCessna T188C · Snyder, TXThe pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.NTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.NTSB FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB SEA94LA169Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Weiser, IDClearance from powerlines was not maintained. Factors include dusk light conditions.NTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.NTSB FTW91LA145Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Paulina, LAThe pilot's failure to maintain adequate visual lookout for the wires and his misjudging clearance when he attempted to fly under the wires.NTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.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 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 MKC86LA159Accident · No injuriesLimited investigationFinal reportCessna T188C · Davenport, IAThe ag pilot was spraying a field when he impacted powerlines which removed the upper one-third of the vertical stab and rudder. On landing he groundlooped and collapsed the right main gear.NTSB MIA86LA083Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Greenwood, MSThe plt stated that during an aerial application swath run, he struck a group of power lines & crashed into a field.NTSB FTW85LA323Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Floydada, TXThe plt stated he failed to see a metal stand pipe in the cotton field. The acft collided with the stand pipe and flipped inverted. Residue of the spraying chemical was observed on the windscreen after the accident. This residue restricted forward visibility…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 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 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 FTW82DA322Accident · No injuriesFinal reportCessna T188C · Altheimer, ARThe pilot stated he encountered turbulence while flying under a power line during a crop spraying operation. The left wing pitched-up and struck the power line and the aircraft went into an uncontrolable left bank. He reduced power and landed in a bean field,…NTSB ATL82FKQ11Accident · 1 fatalFinal reportCessna T188C · Mahew, MSDuring return flight to airport the pilot flew into a previously treated field for a cleanup swath run. Approximately 1700 feet from the south end of the field the aircraft collided with a 3-strand steel twisted cable powerline running east-west across the…