Skip to content

NTSB investigations: Cessna A188B, IL

19 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

19742026

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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.Jul 5, 2017 · N4207J · Substantial damage NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.Sep 7, 1994 · N731SV · Substantial damage NTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.May 30, 1991 · N4887Q · Substantial damage NTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.May 8, 1985 · N731VR · Destroyed NTSB CHI83LA277Accident · No injuriesLimited investigationFinal reportCessna 188B · Campbell Hill, ILAfter taking off from a haul road, which was being used as an airstrip, the acft began climbing. At about 100 ft AGL, the plt noted a loss of power (thrust) as the eng began to overspeed. The plt lowered the nose to gain airspeed & dumped his load, but was…Jun 23, 1983 · N731KY · Substantial damage NTSB CHI82DA274Accident · No injuriesFinal reportCessna 188B · Loami, ILThe pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the…Jul 24, 1982 · N4970Q · Destroyed NTSB CHI81FEV23Accident · Serious injuriesClosedCessna A188B · Metropolis, ILJul 3, 1981 · N9545G · Substantial damage NTSB CHI80FEV39Accident · No injuriesClosedCessna 188 · Mill Shoals, ILSep 23, 1980 · N731SV · Substantial damage NTSB CHI80FEE34Accident · No injuriesClosedCessna A188B · Pecatonica, ILJul 23, 1980 · N4905R · Substantial damage NTSB CHI79FEV18Accident · Minor injuriesClosedCessna A188B · Effingham, ILApr 20, 1979 · N8904G · Substantial damage NTSB CHI79FEY16Accident · No injuriesClosedCessna A188-B · Thompsonville, ILApr 16, 1979 · N4847R · Substantial damage NTSB CHI78FEV40Accident · No injuriesClosedCessna A188B · Ramsey, ILJun 23, 1978 · N731CF · Substantial damage NTSB CHI78DEV38Accident · No injuriesClosedCessna 188 · Ashmore, ILJun 9, 1978 · N4729R · Substantial damage NTSB CHI77FEE45Accident · Serious injuriesClosedCessna A188B · Kankakee, ILAug 19, 1977 · N21602 · Destroyed NTSB CHI77DCA05Accident · No injuriesClosedCessna 188C · Valmeyer, ILAug 10, 1977 · N91828 · Substantial damage NTSB CHI77DEV31Accident · No injuriesClosedCessna 188B · Duquoin, ILJul 2, 1977 · N9246G · Substantial damage NTSB CHI77FEV24Accident · Minor injuriesClosedCessna A188B · Paris, ILMay 19, 1977 · N53330 · Substantial damage NTSB CHI76FEV43Accident · 1 fatalClosedCessna A188B · Monmouth, ILJun 8, 1976 · N70349 · Destroyed NTSB CHI74FEV44Accident · Serious injuriesClosedCessna A188B · Grayville, ILApr 16, 1974 · N21730 · Destroyed