Skip to content

NTSB investigations: Cessna A188B, SC

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

19722026

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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 ERA09CA319Accident · No injuriesData collectionFinal reportCessna A188B · Kingstree, SCThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.Jun 3, 2009 · N9364R · Substantial damage NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.Jul 18, 1995 · N731EM · Substantial damage NTSB ATL94LA080Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Latta, SCThe pilot's failure to obtain flying speed and the premature lift off which resulted in a stall.Apr 12, 1994 · N4856Q · Substantial damage NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.Jul 10, 1991 · N4905Q · Substantial damage NTSB ATL91LA105Accident · No injuriesLimited investigationFinal reportCessna 188 · Sycamore, SCThe pilot's failure to secure the gust lock during prelflight; the string jammed the flight controls and created an uncontrollable condition.May 31, 1991 · N731EP · Substantial damage NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.Sep 11, 1990 · N9422R · Destroyed NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.Oct 5, 1989 · N21897 · Substantial damage NTSB ATL84FA268Accident · 1 fatalField investigationFinal reportCessna A188B · Eastover, SCThe acft collided with the ground during a turn-around. The hopper dump valve on the acft was found closed after the accident. The fuel tanks were reportedly full (54 gallon capacity) and 120 gals of benlate, a non-toxic liquid herbicidehad been loaded aboard…Aug 22, 1984 · N9270R · Destroyed NTSB UNK78X0100Accident · No injuriesClosedCessna 188B · St Matthews, SCOct 1, 1977 · N53354 · Substantial damage NTSB MIA77FLG36Accident · No injuriesClosedCessna A188B · Bennettsville, SCSep 5, 1977 · N4454Q · Substantial damage NTSB MIA77FLG28Accident · No injuriesClosedCessna A188B · Lynchburg, SCAug 6, 1977 · N5619G · Substantial damage NTSB MIA77FLG16Accident · Minor injuriesClosedCessna A188B · Hampton, SCMay 7, 1977 · N21675 · Destroyed NTSB MIA76DLG48Accident · No injuriesClosedCessna 188 · Irmo, SCAug 29, 1976 · N21664 · Substantial damage NTSB MIA76DLG42Accident · No injuriesClosedCessna 188 · St Matthews, SCJul 20, 1976 · N53168 · Substantial damage NTSB MIA75DLG09Accident · Minor injuriesClosedCessna 188B · Cameron, SCAug 10, 1974 · N5754G · Destroyed NTSB MIA75FLG06Accident · No injuriesClosedCessna A188B · Fairfax, SCJul 25, 1974 · N8438G · Substantial damage NTSB MIA75FLG03Accident · Serious injuriesClosedCessna A188B · Dillon, SCJul 16, 1974 · N21703 · Destroyed NTSB MIA74DLG07Accident · No injuriesClosedCessna 188 · Bennettsville, SCAug 24, 1973 · N4454Q · Substantial damage NTSB MIA73DLG17Accident · No injuriesClosedCessna A188 · Fairfax, SCJul 31, 1972 · N21735 · Substantial damage