Skip to content

NTSB investigations: Cessna A188B, ND

20 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" = 'ND' 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\" = 'ND' 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" = 'ND' 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 CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.Jul 22, 2011 · N731AU · Substantial damage NTSB CHI06LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Rolla, NDThe pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…Aug 18, 2006 · N9224R · Substantial damage NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.Jun 19, 2005 · N774T · Substantial damage NTSB CHI04LA225Accident · 1 fatalLimited investigationFinal reportCessna A188B · Mylo, NDThe pilot's failure to maintain clearance from the windmill. The windmill was a contributing factor.Aug 12, 2004 · N92806 · Destroyed NTSB CHI02CA192Accident · No injuriesData collectionFinal reportCessna 188B · Tolley, NDThe pilot's failure to attain lift-off speed and his failure to abort the takeoff.Jul 16, 2002 · N4866Q · Substantial damage NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.Jun 5, 1997 · N8293G · Substantial damage NTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.Jul 29, 1996 · N5708G · Substantial damage NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.Jun 30, 1996 · N21744 · Substantial damage NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.Sep 14, 1992 · N9747G · Substantial damage NTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.Jul 11, 1990 · N4940R · Substantial damage NTSB DEN87LA161Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cayuga, NDThe plt was completing a swath run and struck a power line with the right wing, severing the wing. The aircraft did a snap roll to the right and impacted in a field.Jun 29, 1987 · N4703R · Destroyed NTSB DEN86LA230Accident · No injuriesLimited investigationFinal reportCessna A188B · Langdon, NDWhile ground taxiing for takeoff the acft left main gear brake failed. During the ensuing right ground loop the left main gear collapsed and the left wing impacted the asphalt taxiway.Aug 10, 1986 · N2417J · Substantial damage NTSB DEN80FTG11Accident · Minor injuriesClosedCessna 188 · Fairmount, NDMay 27, 1980 · N731WG · Substantial damage NTSB MKC79DTG11Accident · No injuriesClosedCessna A188B · Garsky, NDJul 5, 1979 · N2172J · Substantial damage NTSB MKC78DTG15Accident · No injuriesClosedCessna A188B · Brocket, NDSep 9, 1978 · N4865R · Substantial damage NTSB MKC78DTG10Accident · No injuriesClosedCessna A188B · Wahpeton, NDJun 14, 1978 · N4794Q · Substantial damage NTSB MKC78FTG09Accident · 1 fatalClosedCessna 188B · Sheyenne, NDJun 3, 1978 · N84677 · Destroyed NTSB MKC76FTG22Accident · Serious injuriesClosedCessna A188B · Langdon, NDJun 28, 1976 · N9622G · Substantial damage NTSB MKC75FTG06Accident · No injuriesClosedCessna 188 · Cummings, NDJul 25, 1974 · N8119G · Substantial damage NTSB MKC74FTG19Accident · No injuriesClosedCessna 188 · Crete, NDJun 22, 1974 · N8075G · Substantial damage