NTSB investigations: Cessna A188B, AK
11 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
| 1975 | 1 |
|---|---|
| 1977 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1988 | 1 |
| 1998 | 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.\"eventStateOrRegion\" = 'AK' 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" = 'AK' 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 ANC99LA109Accident · No injuriesLimited investigationFinal reportCessna A188-B · Bettles, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft terrain.NTSB ANC98LA066Accident · No injuriesLimited investigationFinal reportCessna 188B · Talkeetna, AKThe pilot's failure to identify an unsafe/hazardous taxiway condition. A factor associated with this accident was the presence of rough and uneven terrain conditions.NTSB ANC88LA134Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Skwentna, AKThe airline transport rated pilot was flying a load of gasoline in a crop duster type airplane to a residence in rural Alaska. The landing site was a river sand bar located near the residence. The pilot stated, and witnesses concur, that the airplane's main…NTSB ANC85LA165Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Gold King Creek, AKThe plt stated that when he landed, the acft was rolling out on its main gear in a tail low attitude, when he applied braking action. A moment later, the acft began to pitch nose down. He compensated with full up elevator, but the acft nosed over.NTSB ANC85LA141Accident · No injuriesLimited investigationFinal reportCessna 188 · Dry Creek Mine, AKThe plt reported that while on final apch aprx 100 ft from touchdown, the acft yawed to the left and the left wing dropped. The acft contacted the ground aprx 25 ft left of the rwy and nosed over.NTSB ANC84FA189Accident · No injuriesField investigationFinal reportCessna 188 · Chugiak, AKThe plt stated the acft was covered with ice but he removed the majority of it before taking off. The acft contained a 200 gal load of fuel in the hopper. The plt stated the acft accelerated slower than normal and the takeoff ground run was long. He stated…NTSB ANC84LA145Accident · No injuriesLimited investigationFinal reportCessna 188 · Fairbanks, AKThe acft landed short of the rwy at a mining strip. The plt said he encountered a downdraft and in spite of the additionof full power the acft descended to the ground. The acft was loaded with 150 gallons of diesel fuel in the hopper and the plt attempted to…NTSB ANC84LA087Accident · No injuriesLimited investigationFinal reportCessna A188B · Kantishna, AKThe acft encountered uneven terrain during landing & rolled over. There were no acft malfunctions according to the plt. The plt to date has not filed an accident report. In a telephonic interview he said he encountered the uneven terrain during landing…NTSB ANC83FA095Accident · No injuriesField investigationFinal reportCessna C-188 · Noatak, AKThe acft collided with the runway at the mid-point in a 30 degree nose low attitude during takeoff. According to the pilot the takeoff was started at the north end of the 5000 foot runway and after 500 feet the acft lifted off normally. The pilot then relaxed…NTSB ANC77DAA49Accident · No injuriesClosedCessna A188B · Prospect Crk, AKNTSB ANC76DAA17Accident · No injuriesClosedCessna 188B · Livengood, AK