NTSB investigations: Cessna A188B, TX

13 cases on aircraft the registry lists as Cessna A188B, where the first occurrence was “In flight collision with object”. 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

19822026
NTSB investigations: Cessna A188B, TX per year, 1982–2026: 13 cases
19821
19841
19872
19891
19911
19931
19971
19981
19991
20002
20071

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\" = 'TX' 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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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 DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.Aug 8, 2007 · N4827J · Substantial damageNTSB FTW01LA012Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Stanton, TXThe failure of the pilot to maintain clearance with the power lines, while maneuvering during an aerial application flight.Oct 19, 2000 · N53211 · DestroyedNTSB FTW00LA270Accident · 1 fatalLimited investigationFinal reportCessna 188B · Stanton, TXThe pilot's failure to maintain clearance from guy wires and tower.Sep 29, 2000 · N4983Q · DestroyedNTSB FTW00LA024Accident · No injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot's failure to maintain clearance with the powerlines.Nov 3, 1999 · N72062 · Substantial damageNTSB FTW98FA290Accident · 1 fatalField investigationFinal reportCessna A188B · Panhandle, TXThe pilot's failure to maintain clearance from the power transmission wires while maneuvering during an aerial application flight.Jun 30, 1998 · N3845J · DestroyedNTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.Oct 14, 1997 · N731GY · DestroyedNTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.Jul 8, 1993 · N4739R · Substantial damageNTSB FTW91DRG05Accident · 1 fatalFinal reportCessna 188B · Driscoll, TXThe pilot's failure to maintain clearance from the guy wire during the aerial application maneuver.Jul 28, 1991 · N85987 · DestroyedNTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.May 4, 1989 · N731FR · DestroyedNTSB FTW87DRA05Accident · No injuriesFinal reportCessna A188B · El Campo, TXWhile attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage.Jul 10, 1987 · N731LP · Substantial damageNTSB FTW87FA151Accident · Serious injuriesField investigationFinal reportCessna A188B · New Taiton, TXAcft was observed departing on rwy 35 of a 4,250' pvt ag strip after having been loaded to near capacity with 46% nitrogen fertilizer. Acft lifted off, crossed a fence parallel to the rwy and struck a fence that was perpendicular to the north end of the rwy.…Jun 17, 1987 · N731XQ · Substantial damageNTSB FTW84LA337Accident · 1 fatalLimited investigationFinal reportCessna A188B · Batesville, TXThere were no known acft or eng problems involved in the accident. A witness stated the acft started its pullup from the first swath run of the day on an agricultural operation, collided with an electrical transmission line & fell to the ground, fatally…Aug 4, 1984 · N731LQ · DestroyedNTSB FTW82FPD16Accident · Serious injuriesFinal reportCessna 188B · Stanford, TXThe pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…Jul 21, 1982 · N731AK · Destroyed