Fatal NTSB investigations: Cessna A188B, NE

8 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

19732026
Fatal NTSB investigations: Cessna A188B, NE per year, 1973–2026: 8 cases
19731
19781
19831
19861
19891
19901
19911
20041

Latest 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\" = 'NE' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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.

NTSB CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.Jun 21, 2004 · N731MP · Substantial damageNTSB CHI91DCJ06Accident · 1 fatalFinal reportCessna A188D · Gothenburg, NEThe pilot's failure to maintain airspeed which resulted in a stall. A factor related to the accident was the pilot's abrupt handling of the airplane.Aug 14, 1991 · N4820Q · Substantial damageNTSB CHI90DCJ01Accident · 1 fatalFinal reportCessna A188B · Amherst, NEThe pilot's failure to see and avoid power lines in his area of operation.Aug 2, 1990 · N84524 · Substantial damageNTSB MKC89DCJ03Accident · 1 fatalFinal reportCessna A-188B · Hay Springs, NEThe pilot's delay in intiating a climb at the end of a swath run.Jul 12, 1989 · N79291 · Substantial damageNTSB MKC86FCJ02Accident · 1 fatalFinal reportCessna A188B · Bridgeport, NEDuring an agricultural spray run, the aircraft collided with a utility pole, leaving part of the spary boom wrapped around the pole, and pieces of flap, wing, and fuel bladder nearby. The aircraft then impacted the ground about 1000 ft from the pole & was…Jun 19, 1986 · N84729 · DestroyedNTSB MKC83FA153Accident · 1 fatalField investigationFinal reportCessna 188B · Shelton, NEThe plt had dusted 1 field & had started dusting another that was located on rolling terrain. After making 3 swath runs over the 2nd field, he was maneuvering for a 4th run when the acft's right wing impacted with a power line cable. The wing's leading edge &…Jul 12, 1983 · N731AC · DestroyedNTSB MKC78FCJ43Accident · 1 fatalClosedCessna 188 · Grand Island, NEAug 27, 1978 · N53360 · DestroyedNTSB MKC73FCJ29Accident · 1 fatalClosedCessna A188B · Hebron, NEFeb 22, 1973 · N4493Q · Destroyed