NTSB investigations: Cessna A188B, IA
10 cases on aircraft the registry lists as Cessna A188B. 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
| 1976 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2026 | 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\" = 'IA' 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 ('2073005'))
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" = 'IA' 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 ('2073005'))
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 CEN26LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188B · Algona, IAThe pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall.NTSB CEN11LA513Accident · No injuriesLimited investigationFinal reportCessna A188B · Mount Hamill, IAThe loss of engine power due to fuel starvation and the pilot's inadequate fuel management.NTSB CHI08CA260Accident · No injuriesData collectionFinal reportCessna A188B · Camanche, IAThe pilot took off on an unsuitable airstrip which resulted in the airplane becoming prematurely airborne with inadequate airspeed after it contacted a rise in the terrain.NTSB MKC90LA143Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Marshalltown, IAInadequate visual lookout and clearance not obtained.NTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…NTSB MKC84FCD01Accident · Serious injuriesFinal reportCessna A188B · Hesper, IAThe acft crashed after colliding with a power line. During the first spray pass the plt attempted to fly under the power line. The veritcal fin hit the wire and the acft crashed. There were no mechanical problems with the acft during this aerial application…NTSB MKC79FCD26Accident · Serious injuriesClosedCessna A188 · Des Moines, IANTSB MKC79FCD25Accident · Serious injuriesClosedCessna 188B · Iowa Falls, IANTSB MKC78DCD41Accident · No injuriesClosedCessna 188B · Yale, IANTSB MKC76DCD42Accident · No injuriesClosedCessna 188 · Cedar Falls, IA