NTSB investigations: Cessna T188C
10 cases on aircraft the registry lists as Cessna T188C, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 3 |
|---|---|
| 1983 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1999 | 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\" = 353))
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" = 353))
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 LAX99LA182Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Stovepipe Wells, CAfuel exhaustion resulting from the pilot becoming lost and disoriented on a cross-country flight.NTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.NTSB ATL91LA153Accident · No injuriesLimited investigationFinal reportCessna T188C · Quitman, GAA total loss of engine power due to fuel starvation. The reason for the fuel starvation was not determined.NTSB CHI91DCJ04Accident · No injuriesFinal reportCessna T188C · Grand Island, NEThe pilot's failure to maintain adequate clearance from crops during aerial application maneuvers. Related factors are the failure of a propeller pitch change mechanism and the pilot's diverted attention.NTSB DEN90LA158Accident · No injuriesLimited investigationFinal reportCessna T-188 · Devils Lake, NDThe pilot's failure to refuel, resulting in fuel exhaustion. A forced landing in rough terrain is a factor.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 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…NTSB MKC82DA148Accident · No injuriesFinal reportCessna T188C · Near Traer, IAThe pilot failed to refuel during the last loading, and shortly after returning to the spray area, the engine quit. A forced landing was made in an alfala field during which the aircraft collided with a fence. During the investigation, no fuel was found in…NTSB DEN82DA136Accident · No injuriesFinal reportCessna T188C · Starkweather, NDThe pilot reported that the aircraft fuel tank had run out of fuel, so he added 2 to 3 gallons of av-gas. He said he thought this would be enough fuel to ferry the the aircraft four miles. He took off, and upon reaching about 400 ft AGL, the engine lost…NTSB DEN82DA117Accident · No injuriesFinal reportCessna 188 · 25nm Sw Santa R, MTAfter dispensing his second load, the pilot returned to the airport where he circled to wait for traffic to clear the runway. About 1/2 way through the circle, the engine lost power and the pilot observed that the fuel gauges indicated empty. He landed on a…