Skip to content

NTSB investigations: Cessna A188B, AZ

19 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

19732026

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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 LAX87DUJ10Accident · No injuriesFinal reportCessna 188B · Poston, AZJust after liftoff one propeller blade separated from the hub near the outboard end of the associated ferrule fitting which induced a failure of the cranckshaft. The pilot made a forced landing, overran the runway end and nosed over. Metallurgical analysis…Aug 29, 1987 · N8275G · Substantial damage NTSB LAX85LA348Accident · No injuriesLimited investigationFinal reportCessna A188B · Willcox, AZOn August 15, 1985, a Cessna 180 lost eng pwr due to fuel exhaustion and collided with the ground during an aerial applicaion maneuver. The acft sustained substantial damage but the pilot was not injured. The plt stated that he should have checked the fuel…Aug 15, 1985 · N4974Q · Substantial damage NTSB LAX84LUJ01Accident · No injuriesFinal reportCessna 188B · Salome, AZThe acft collided with the terrain following a loss of power due to fuel exhaustion while spraying a cotton field. The plt stated he was aware of the low fuel supply but was pushing to complete the job before dark.Aug 27, 1984 · N731VZ · Substantial damage NTSB LAX83LA441Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Winkelman, AZThe right wing collided with wires at the end of a swath run and the acft was pulled to the ground about 300 ft from the wires.Sep 16, 1983 · N21613 · Destroyed NTSB LAX82DA193Accident · Serious injuriesFinal reportCessna A188 · Ehrenberg, AZThe pilot stated that as he pulled up at the end of a trim run in order to miss some electric wires the aircraft began to shutter. It then rolled left, right, and back to the left going almost inverted before coming to rest in a cotton field.May 25, 1982 · N70454 · Destroyed NTSB LAX80FUJ97Accident · Serious injuriesClosedCessna A188B · Casa Blanca, AZSep 16, 1980 · N53388 · Substantial damage NTSB LAX80DUK02Accident · Minor injuriesClosedCessna A188 · Parker, AZSep 15, 1980 · N731VU · Substantial damage NTSB LAX80DUJ89Accident · No injuriesClosedCessna 188B · Hyder, AZAug 8, 1980 · N4786R · Substantial damage NTSB LAX80DUJ50Accident · Minor injuriesClosedCessna A188B · Sun City, AZApr 23, 1980 · N70143 · Destroyed NTSB LAX79DUJ15Accident · No injuriesClosedCessna 188 · Maricopa, AZNov 6, 1978 · N21613 · Substantial damage NTSB LAX78DUK05Accident · No injuriesClosedCessna 188 · Parker, AZSep 16, 1978 · N9393R · Substantial damage NTSB LAX78DUJ98Accident · No injuriesClosedCessna 188B · Mohave Valley, AZSep 4, 1978 · N4815R · Substantial damage NTSB LAX78DUK08Accident · No injuriesClosedCessna 188 · San Simon, AZSep 2, 1978 · N53286 · Substantial damage NTSB LAX77FUJ75Accident · Serious injuriesClosedCessna 188 · Poston, AZJul 27, 1977 · N8487G · Destroyed NTSB LAX76DUK07Accident · No injuriesClosedCessna 188 · Poston, AZSep 2, 1976 · N53219 · Substantial damage NTSB LAX76DUJ69Accident · No injuriesClosedCessna A188B · Poston, AZMar 30, 1976 · N84470 · Substantial damage NTSB LAX76DUJ26Accident · No injuriesClosedCessna A188B · Coolidge, AZSep 14, 1975 · N9765G · Substantial damage NTSB LAX75FUJ32Accident · No injuriesClosedCessna 188A · Poston, AZSep 8, 1974 · N4464Q · Substantial damage NTSB LAX73DUJ82Accident · No injuriesClosedCessna A188B · Parker, AZJun 6, 1973 · N21678 · Destroyed