Skip to content

NTSB investigations: Cessna A188B, NC

23 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

19752026

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ERA21LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna A188 · Dover, NCA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft. Contributing to the accident was the hard touchdown during the forced landing.Apr 15, 2021 · N731TB · Substantial damage NTSB ERA15LA281Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A188B · Albertson, NCThe pilot’s failure to maintain clearance from wires during takeoff due to his impairment from alcohol use.Jul 25, 2015 · N731MB · Substantial damage NTSB ERA15CA027Accident · No injuriesData collectionFinal reportCessna A188B · Louisburg, NCThe pilot's failure to maintain directional control during takeoff.Oct 23, 2014 · N731PM · Substantial damage NTSB ATL07LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · New Bern, NCLoss of engine power for undetermined reasons and the pilot's continued operation of the airplane with known deficiencies with the engine, which resulted in a forced landing and in-flight collision with the ground.Oct 21, 2006 · N9176R · Substantial damage NTSB ATL07CA007Accident · No injuriesData collectionFinal reportCessna 188B · Belhaven, NCThe pilot's failure to compensate for wind conditions and maintain adequate airspeed, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.Oct 11, 2006 · N91181 · Substantial damage NTSB MIA97LA221Accident · No injuriesLimited investigationFinal reportCessna 188 · Benson, NCThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with a cable, subsequent loss of engine power, forced landing, and an in-flight collision with terrain. Contributing to the accident was a total loss of…Jul 28, 1997 · N53240 · Destroyed NTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.Aug 19, 1995 · N731VX · Substantial damage NTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.Jun 13, 1995 · N4916Q · Substantial damage NTSB ATL91LA130Accident · 1 fatalLimited investigationFinal reportCessna 188 · Snow Hill, NCInadequate visual lookout by the pilot. Factors to the accident were tree.Jul 20, 1991 · N9072R · Destroyed NTSB ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCAug 16, 1988 · N8284G · Substantial damage NTSB ATL88DMG06Accident · No injuriesFinal reportCessna 188 · Messic, NCDuring turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years.May 18, 1988 · N8250G · Destroyed NTSB ATL81DLJ15Accident · No injuriesClosedCessna 188 · Newton Grove, NCJul 30, 1981 · N8112G · Destroyed NTSB ATL80DLJ18Accident · No injuriesClosedCessna 188B · Elizabeth City, NCAug 23, 1980 · N731CX · Substantial damage NTSB ATL80FLJ19Accident · No injuriesClosedCessna 188B · Rowland, NCJul 31, 1980 · N9623G · Substantial damage NTSB ATL80FLJ16Accident · No injuriesClosedCessna A188B · Harlowe, NCJun 3, 1980 · N53192 · Substantial damage NTSB IAD78DLJ13Accident · No injuriesClosedCessna 188T · Fairfield, NCMay 29, 1978 · N53299 · Substantial damage NTSB IAD78FLJ01Accident · No injuriesClosedCessna 188B · Roanoke Rapids, NCSep 30, 1977 · N4496Q · Substantial damage NTSB IAD77FLJ29Accident · No injuriesClosedCessna 188C · Clayton, NCAug 5, 1977 · N4449Q · Substantial damage NTSB IAD77DLJ27Accident · No injuriesClosedCessna 188B · Elizabeth City, NCAug 2, 1977 · N9212R · Substantial damage NTSB IAD77FLJ26Accident · No injuriesClosedCessna 188 · Columbia, NCJul 27, 1977 · N9095G · Destroyed NTSB IAD77DLJ31Accident · No injuriesClosedCessna A188B · Merritt, NCJun 24, 1977 · N4756R · Substantial damage NTSB IAD76FLJ28Accident · No injuriesClosedCessna A188B · Battleboro, NCSep 16, 1976 · N4845R · Substantial damage NTSB IAD76FLJ11Accident · No injuriesClosedCessna 188B · Laurinburg, NCSep 30, 1975 · N53162 · Substantial damage