Final NTSB investigations: Cessna T188C, ND
9 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
| 1980 | 1 |
|---|---|
| 1982 | 2 |
| 1983 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 2000 | 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.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
AND c."completionStatus" = 'Completed'
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 CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.NTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.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 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 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 DEN83LA190Accident · No injuriesLimited investigationFinal reportCessna T188L · Wahpeton, NDThe acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision…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 DEN82DTG05Accident · No injuriesFinal reportCessna 188 · Devils Lake, NDThe pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…NTSB DEN80FTG16Accident · No injuriesClosedCessna T188 · Starkweather, ND