Skip to content

NTSB investigations: Cessna A188B, MN

26 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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.Jul 4, 1998 · N5829G · Substantial damage NTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.May 18, 1998 · N4962Q · Substantial damage NTSB CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.Jul 13, 1997 · N9746G · Substantial damage NTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…Jun 29, 1997 · N4485Q · Substantial damage NTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.Aug 23, 1996 · N4797Q · Substantial damage NTSB MKC89LA140Accident · No injuriesLimited investigationFinal reportCessna 188B · Grygla, MNInadequate preflight planning and preparation by the pilot. Tall grass (high vegetation) at the end of the strip was a contributing factor.Jun 24, 1989 · N4724R · Substantial damage NTSB CHI88DER12Accident · No injuriesFinal reportCessna A188B · Clearbrook, MNOn initial climb the right cowling door came open. The pilot was unable to maintain a climb and elected to make an emergency landing in a hay field. The aircraft encountered unsuitable terrain and received substantial damage. Post accident inspection of the…Sep 14, 1988 · N4915Q · Substantial damage NTSB CHI86FER08Accident · No injuriesFinal reportCessna A188B · Montevideo, MNDuring takeoff roll from a roadway the wind shifted from a headwind to a tailwind. The pilot of this crop duster turned to avoid a stop sign on the roadway and allowed his landing gear to touch down on a crossing roadway. The aircraft then flipped over onto…May 19, 1986 · N9496G · Substantial damage NTSB CHI86FER05Accident · Serious injuriesFinal reportCessna A188B · Greenbush, MNThe plt reported that the acft contacted a soft spot, caused by recent rains, in the sod runway during takeoff. The acft decelerated, however, the plt attempted to continue the takeoff as not enough runway remained to abort. The acft did not obtain sufficient…Apr 21, 1986 · N9220R · Substantial damage NTSB CHI85LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Waskish, MNDuring initial takeoff climb of an aerial application flt the plt could not maintain alt. While he was dumping the chemical load the acft struck trees, impacted the terrain and burst into flames. The plt was not properly certificated to fly under FAR part 137.Jun 28, 1985 · N9254R · Destroyed NTSB CHI84LA366Accident · No injuriesLimited investigationFinal reportCessna A188B · Delavan, MNThe plt stated the acft would not climb rapidly enough on takeoff to clear powerlines. Plt elected to fly under the wires instead of climbing over them and risking stalling the acft. The prop, windshield, and vert stabilizer contacted the lowest wire. Plt…Aug 27, 1984 · N4797Q · Substantial damage NTSB CHI83LA332Accident · No injuriesLimited investigationFinal reportCessna 188B · Crookston, MNThe acft collided with a barley crop during a forced landing on a narrow dirt road. The acft had lost power after takeoff for a calibration spray run. The pilot stated he took off with about 10 gallons of fuel (1/8 tank) and did not visually check the fuel…Jul 18, 1983 · N92037 · Substantial damage NTSB CHI83LA316Accident · No injuriesLimited investigationFinal reportCessna 188-B · Springfield, MNThe acft crashed into a cornfield during a takeoff to spray crops. The pilot stated that there were no mechanical problems with the acft. Investigaiton showed that the pilot attempted a takeoff on rwy 31 with a 5 kt tailwind. The acftdid not become airborne.Jul 16, 1983 · N21700 · Substantial damage NTSB CHI81FER41Accident · No injuriesClosedCessna A188B · Villard, MNJun 3, 1981 · N91228 · Substantial damage NTSB CHI81FER40Accident · No injuriesClosedCessna A188B · Leroy, MNMay 29, 1981 · N4797Q · Substantial damage NTSB CHI81FER35Accident · Minor injuriesClosedCessna 188 · Roseau, MNMay 7, 1981 · N9207R · Substantial damage NTSB CHI81FER30Accident · Serious injuriesClosedCessna A188B · Wolverton, MNApr 10, 1981 · N6315G · Destroyed NTSB CHI80FER66Accident · No injuriesClosedCessna A188B · Garden City, MNAug 24, 1980 · N731AX · Substantial damage NTSB MKC79FER51Accident · Serious injuriesClosedCessna A188B · Donaldson, MNJun 28, 1979 · N8239G · Substantial damage NTSB MKC79DER44Accident · No injuriesClosedCessna 188 · Gully, MNMay 31, 1979 · N9709G · Substantial damage NTSB MKC78FER90Accident · Minor injuriesClosedCessna A188B · Clements, MNSep 2, 1978 · N70499 · Substantial damage NTSB MKC77DER37Accident · No injuriesClosedCessna A188B · Elbow Lake, MNApr 25, 1977 · N92619 · Substantial damage NTSB MKC76DER79Accident · No injuriesClosedCessna A188B · Angus, MNJul 10, 1976 · N4779Q · Substantial damage NTSB MKC76DER73Accident · No injuriesClosedCessna 188 · Clearbrook, MNJun 30, 1976 · N9370R · Substantial damage NTSB MKC76FER67Accident · Minor injuriesClosedCessna 188B · Lesueur, MNJun 3, 1976 · N92325 · Substantial damage NTSB MKC76FER11Accident · Serious injuriesClosedCessna 188 · Maynard, MNJul 23, 1975 · N9225R · Substantial damage