NTSB investigations: Cessna A188A, MS

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

19712026

NTSB investigations: Cessna A188A, MS per year, 1971–2026: 9 cases
1971	1
1972	4
1973	1
1976	2
1979	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" = 'MS' 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 ('2073008')) 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\" = 'MS' 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 ('2073008'))
  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" = 'MS' 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 ('2073008'))
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 MIA79FKQ24Accident · No injuriesClosedCessna 188 · Water Valley, MSAug 20, 1979 · N1586M · Destroyed NTSB MIA76DKQ46Accident · No injuriesClosedCessna A188A · Bruce, MSSep 9, 1976 · N1586M · Substantial damage NTSB MIA76FKQ40Accident · No injuriesClosedCessna 188 · Arcola, MSJul 26, 1976 · N9964G · Substantial damage NTSB MIA74FKQ03Accident · Serious injuriesClosedCessna A188A · Marks, MSJul 24, 1973 · N9942G · Substantial damage NTSB MIA73FKQ12Accident · No injuriesClosedCessna A188A · Calhoun City, MSSep 6, 1972 · N9966G · Destroyed NTSB MIA73DKQ14Accident · Serious injuriesClosedCessna A188A · Rulville, MSSep 6, 1972 · N4406Q · Destroyed NTSB MIA73DLT02Accident · No injuriesClosedCessna A188A · Olive Branch, MSAug 6, 1972 · N9905G · Substantial damage NTSB MIA72DLT14Accident · No injuriesClosedCessna 188A · Olive Branch, MSJun 16, 1972 · N9945G · Destroyed NTSB MIA71FKQ27Accident · Serious injuriesClosedCessna A188A · Carrollton, MSMar 11, 1971 · N2168U · Substantial damage