NTSB investigations: Cessna A188A, 1974

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

19702026

NTSB investigations: Cessna A188A, 1974 per year, 1970–2026: 116 cases
1970	4
1971	5
1972	17
1973	12
1974	9
1975	12
1976	9
1977	6
1978	5
1979	2
1980	1
1981	2
1982	1
1983	5
1984	2
1985	2
1988	1
1989	1
1992	2
1993	3
1994	1
1995	3
1996	1
1997	1
2002	1
2003	1
2004	1
2005	1
2007	2
2011	1
2015	1
2022	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 year(c."eventDate") = 1974 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 year(c.\"eventDate\") = 1974
    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 year(c."eventDate") = 1974
  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 MIA75DKJ20Accident · Serious injuriesClosedCessna 188 · Mobile, ALSep 12, 1974 · N5685J · Destroyed NTSB MKC75FCJ19Accident · Serious injuriesClosedCessna 188A · Summerfield, KSAug 14, 1974 · N2452U · Substantial damage NTSB IAD75DLQ06Accident · No injuriesClosedCessna 188 · Owensboro, KYAug 10, 1974 · N5689J · Substantial damage NTSB MIA75FKJ05Accident · No injuriesClosedCessna 188 · Tuscaloosa, ALJul 21, 1974 · N7DS · Substantial damage NTSB FTW75DRJ02Accident · No injuriesClosedCessna A188 · Mangham, LAJul 11, 1974 · N9921G · Substantial damage NTSB MIA74D2G34Accident · Minor injuriesClosedCessna 188 · Florence, SCJun 17, 1974 · N1580M · Destroyed NTSB OAK74DVG54Accident · No injuriesClosedCessna 188 · Willows, CAMay 5, 1974 · N5672J · Substantial damage NTSB MIA74AM078Accident · Minor injuriesClosedCessna 188A · Clewiston, FLMar 8, 1974 · N5641J · 2 aircraft · Substantial damage NTSB IAD74FLT12Accident · Minor injuriesClosedCessna A188A · Trenton, TNJan 16, 1974 · N9983G · Substantial damage