NTSB investigations: Cessna T188C, AR
7 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2004 | 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\" = 'AR' AND c.\"eventCountry\" = 'USA'
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" = 'AR' AND c."eventCountry" = 'USA'
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 FTW04LA214Accident · No injuriesLimited investigationFinal reportCessna T188C · Heth, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.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 MKC90LA127Accident · No injuriesLimited investigationFinal reportCessna 188 · Joiner, ARPremature lift-off by the pilot in command.NTSB FTW83LA292Accident · No injuriesLimited investigationFinal reportCessna T188C · Eudora, ARDuring the return trip to the arpt, the eng lost power & the plt landed in an open field with soft terrain. Shortly after touchdown, the right main gear dug into the soft soil & collapsed. A fire started after the acft came to rest & it was destroyed. The…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 FTW82DA276Accident · No injuriesFinal reportCessna T188C · Marvell, ARAn aerial application of an oil-based material resulted in a smearing of the windscreen. The pilot landed on a grass strip to clear the windscreen, and during, the landing, the aircraft flipped over. The pilot said when he applied brakes, the left wheel broke…NTSB FTW82DA188Accident · No injuriesFinal reportCessna T188C · Knobel, ARThe pilot stated that during his swath run the engine seemed to hesitate. While checking the engine the pilot collided with a levee and the landing gear separated from the aircraft. The pilot made a forced landing in an adjacent field.