NTSB investigations: Cessna A188B, TN

8 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

19742026

NTSB investigations: Cessna A188B, TN per year, 1974–2026: 8 cases
1974	1
1981	1
1985	1
1987	1
1994	1
2001	2
2014	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."eventStateOrRegion" = 'TN' 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\" = 'TN' 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" = 'TN' 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 ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.Aug 27, 2014 · N5850G · Substantial damage NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.Oct 17, 2001 · N4784R · Substantial damage NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.May 30, 2001 · N4893R · Substantial damage NTSB ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.Oct 1, 1994 · N731PS · Substantial damage NTSB ATL87LA190Accident · No injuriesLimited investigationFinal reportCessna A188B · Dyersburg, TNDrg a spraying opn, the plt returned to land on an asphalt hiway & reload with chemicals. As he flared to lnd, the eng accelerated to aprx '2/3 throttle' with no throttle movement. He believed the throttle was in the off psn when this occurred. A nose hi…Jun 25, 1987 · N2828J · Substantial damage NTSB ATL85LA247Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersburg, TNDuring the third takeoff the pilot failed to obtain and maintain flying speed and crashed in a field off the departure end of the ag strip.Aug 14, 1985 · N8295G · Substantial damage NTSB ATL82DLT01Accident · No injuriesClosedCessna A188B · Kenton, TNOct 9, 1981 · N4853R · Destroyed NTSB IAD75AI012Accident · 1 fatalClosedCessna A188B · Smyrna, TNSep 13, 1974 · N53235 · Destroyed