NTSB investigations: Cessna T188C
10 cases on aircraft the registry lists as Cessna T188C, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 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\" = 250))
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" = 250))
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 SEA97LA104Accident · 1 fatalLimited investigationFinal reportCessna T188C · Mitchell, ORThe pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.NTSB SEA96LA114Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Roundup, MTfailure of the pilot to maintain adequate airspeed, during a turn-around maneuver after a swath run, which resulted in an inadvertent stall.NTSB FTW94FA311Accident · 1 fatalField investigationFinal reportCessna T188C · Roscoe, TXThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was the pilot's lack ofNTSB SEA93LA132Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Augusta, MTThe pilot's failure to maintain airspeed and terrain clearance while maneuvering on an aerial application flight. A factor relating to the accident was the pilot's diverted attention.NTSB MKC90LA127Accident · No injuriesLimited investigationFinal reportCessna 188 · Joiner, ARPremature lift-off by the pilot in command.NTSB MKC89DER01Accident · 1 fatalFinal reportCessna T188C · Wannaska, MNThe pilot-in-command did not maintain airspeed, resulting in an inadvertent stall.NTSB DEN88LA134Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Big Timber, MTThe plt said he was spraying 2,4,d on two barley flds. He had completed one fld and was turning around when the acft began to settle. He said when he attempted to avoid ground contact the acft stalled and collided with the ground. During a telephone…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.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 CHI83LA008Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Sparta, MIWitnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi…