Skip to content

NTSB investigations: Cessna A188B, SD

15 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with SQL

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" = 'SD' 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

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\" = 'SD' 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" = 'SD' 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

Run 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 CEN20LA309Accident · 1 fatalClass 3 · LimitedFinal reportCessna A188 · Corsica, SDThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and loss of control.Jul 27, 2020 · N53163 · Destroyed NTSB CHI97LA254Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Britton, SDthe pilot's failure to maintain clearance with the terrain during the spray run and his failure to maintain adequate airspeed during the turn after having contacted the terrain. A factor was the pilot's diverted attention.Aug 11, 1997 · N91919 · Substantial damage NTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.Oct 12, 1993 · N4788Q · Substantial damage NTSB CHI93LA314Accident · No injuriesLimited investigationFinal reportCessna 188 · Martin, SDthe pilot's failure to maintain control of the airplane during the takeoff roll.Aug 7, 1993 · N78516 · Substantial damage NTSB CHI91DTK02Accident · No injuriesFinal reportCessna 188/B · Hecla, SDThe failure of the pilot to maintain aircraft control as he attempted to jettison a load of agricultural chemical after the airplane failed to climb after takeoff. Factors associated with the accident are an attempted downwind takeoff by the pilot.Jul 13, 1991 · N9399G · Substantial damage NTSB DEN90LA125Accident · No injuriesLimited investigationFinal reportCessna 188A · Martin, SDThe on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.Jun 4, 1990 · N78516 · Substantial damage NTSB DEN83LA159Accident · No injuriesLimited investigationFinal reportCessna 188B · Pierre, SDThe plt was making practice swath runs with a load of water. During the third turn, at about 100 ft AGL, the eng stopped, according to the plt. The acft then landed hard & cartwheeled. No eng malfunctions were found.Jul 2, 1983 · N8965G · Substantial damage NTSB DEN82DA173Accident · No injuriesFinal reportCessna A188B · Britton, SDWhen the pilot departed to spray the last field for that day, he estimated that he had 19 to 20 gallons of fuel remaining. He figured it would take about 16 to 17 gallons of fuel to complete the job. About 1 hr later, as he was returning to land, the engine…Aug 16, 1982 · N91919 · Substantial damage NTSB DEN81DTK19Accident · Minor injuriesClosedCessna A188B · Webster, SDAug 5, 1981 · N4865R · Substantial damage NTSB DEN80DTK12Accident · No injuriesClosedCessna A188B · Pierre, SDJun 2, 1980 · N4487Q · Substantial damage NTSB MKC79DTK24Accident · No injuriesClosedCessna 188B · Ashton, SDAug 14, 1979 · N731CS · Substantial damage NTSB MKC78FTK33Accident · No injuriesClosedCessna A188B · Doland, SDJul 28, 1978 · N731LH · Substantial damage NTSB MKC78FTK16Accident · Serious injuriesClosedCessna 188 · Hayes, SDMay 23, 1978 · N9510G · Substantial damage NTSB MKC77DTK28Accident · Serious injuriesClosedCessna 188B · Turton, SDJun 27, 1977 · N91974 · Substantial damage NTSB MKC75FTK16Accident · No injuriesClosedCessna 188T · Freeman, SDMay 1, 1975 · N9246G · Substantial damage