NTSB investigations: Cessna A188A

7 cases on aircraft the registry lists as Cessna A188A, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations: Cessna A188A per year, 1983–2026: 7 cases
1983	1
1988	1
1989	1
1992	1
1993	1
1994	1
2007	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073008') 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

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073008')
      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.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073008')
    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

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 CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.Jul 16, 2007 · N4412Q · Substantial damage NTSB ATL94LA140Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Cochran, GAThe pilot's failure to maintain airspeed and clearance from trees during an aerial application maneuver. Factors were the trees at the perimeter of the field, and the gusting tail wind conditions at the time of the accident.Jul 16, 1994 · N5657J · Substantial damage NTSB FTW93LA159Accident · No injuriesLimited investigationFinal reportCessna A188A · Decatur, TXThe pilot's failure to maintain adequate clearance. A factor was the turbulenceMay 15, 1993 · N9901G · Destroyed NTSB SEA92LA108Accident · No injuriesLimited investigationFinal reportCessna A188A · Redmond, ORProper clearance from objects was not maintained. Factors to the accident were: sunglare, wires, and visual lookout was not possible.May 21, 1992 · N9990G · Substantial damage NTSB DEN89DTG01Accident · 1 fatalFinal reportCessna 188A · Valley City, NDInadequate visual lookout by the pilot. The power line was a related factor.Aug 6, 1989 · N188TV · Destroyed NTSB LAX89DUJ01Accident · Serious injuriesFinal reportCessna A188A · Casa Grande, AZDuring aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.Oct 23, 1988 · N5640J · Destroyed NTSB ATL83FKG11Accident · 1 fatalFinal reportCessna A188A · Jesup, GAThe plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered…Aug 29, 1983 · N5633J · Substantial damage