NTSB investigations: Cessna A188B, CO
14 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
| 1972 | 1 |
|---|---|
| 1974 | 1 |
| 1975 | 3 |
| 1979 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1998 | 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\" = 'CO' 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" = 'CO' 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 FTW98LA324Accident · No injuriesLimited investigationFinal reportCessna A188B · Erie, COThe pilot's failure to maintain directional control of the airplane. A factor was a crosswind gust.NTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB DEN89DTE04Accident · 1 fatalFinal reportCessna A188B · Wiggins, COThe pilot failed to maintain an adequate visual lookout and collided with a standpipe which severed four feet of the right wing, resulting in loss of control inflight and subsequent collision with the terrain.NTSB DEN87DTE04Accident · No injuriesFinal reportCessna A188B · Stonington, COThe plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings…NTSB DEN87LA127Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Limon, COThe plt reports that he was using a dirt road for aerial app operations. The acft was loaded with 40 gals fuel and 140 gals chem and the density alt is EST to have been 8100 ft. the plt said the takeoff was made to the e with a quartering tailwind of about 15…NTSB DEN86LA198Accident · No injuriesLimited investigationFinal reportCessna A188B · Center, COAccording to the plt involved in the accident the acft crashed during takeoff because the eng was not developing full power. The owner of the ag spraying business (to whom the acft belongs) and another plt for the operator, stated the mixture was improperly…NTSB DEN85LA184Accident · No injuriesLimited investigationFinal reportCessna A188B · Del Norte, COThe plt was attempting to take off from a 3800-FT grass rwy. Field elevation was 7700 ft, temp was 88 deg. The plt said that at about 2500 ft down the rwy he decided to abort the takeoff. Directional control was lost and the airplane groundlooped. The plt…NTSB DEN79DTE81Accident · No injuriesClosedCessna A188B · Monte Vista, CONTSB DEN76DTE25Accident · No injuriesClosedCessna A188B · Monte Vista, CONTSB DEN76DTE27Accident · No injuriesClosedCessna 188 · Ft Collins, CONTSB DEN75FTE48Accident · Minor injuriesClosedCessna 188B · Longmont, CONTSB DEN74DTE85Accident · No injuriesClosedCessna 188 · Center, CONTSB DEN73DTE09Accident · No injuriesClosedCessna 188 · Pritchett, CO