NTSB investigations: Cessna A188, 1971
18 cases on aircraft the registry lists as Cessna A188. 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.
Cases per year
| 1966 | 1 |
|---|---|
| 1967 | 5 |
| 1968 | 10 |
| 1969 | 16 |
| 1970 | 11 |
| 1971 | 18 |
| 1972 | 12 |
| 1973 | 8 |
| 1974 | 11 |
| 1975 | 9 |
| 1976 | 6 |
| 1977 | 4 |
| 1978 | 7 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2024 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\") = 1971
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073004'))
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") = 1971
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073004'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI72FLQ15Accident · Serious injuriesClosedCessna A188 · Utica, KYNTSB SEA72FYG15Accident · Serious injuriesClosedCessna A188 · Albion, WANTSB SEA72FYG11Accident · 1 fatalClosedCessna 188 · Craigmont, IDNTSB MIA72FLT05Accident · No injuriesClosedCessna 188 · Tunica, MSNTSB CHI72DLQ11Accident · No injuriesClosedCessna A188 · Owensboro, KYNTSB MIA72FKQ05Accident · No injuriesClosedCessna 188 · Shaw, MSNTSB OAK72DVM03Accident · No injuriesClosedCessna 188 · Salinas, CANTSB FTW72DRG16Accident · No injuriesClosedCessna 188 · San Ygnacio, TXNTSB MKC72FCJ13Accident · No injuriesClosedCessna 188 · Lexington, NENTSB SEA72FYC15Accident · No injuriesClosedCessna A188 · St.Johns, ORNTSB MIA72DKG16Accident · No injuriesClosedCessna 188 · Shellman, GANTSB LAX72FUJ20Accident · No injuriesClosedCessna 188A · Queen Creek, AZNTSB SEA72DYG02Accident · No injuriesClosedCessna A188 · Brownstown, WANTSB FTW72DQG04Accident · No injuriesClosedCessna 188 · Friona, TXNTSB OAK72DVA02Accident · No injuriesClosedCessna 188 · Five Points, CANTSB LAX71FUJ97Accident · Serious injuriesClosedCessna A188 · Eloy, AZNTSB OAK71FVG71Accident · 1 fatalClosedCessna A188 · Willows, CANTSB SEA71FDA18Accident · No injuriesClosedCessna A188 · Joliet, MT