NTSB investigations: Cessna A188, 1982
5 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\") = 1982
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") = 1982
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 ATL82DA260Accident · Minor injuriesFinal reportCessna A188 · Hillsboro, ALThe pilot reported that while making a swath run to the west over uneven terrain, his right wing contacted the cotton crop that he was spraying. The aircraft crashed and began to burn after coming to rest inverted. The pilot escaped with minor injuries before…NTSB ATL82DA186Accident · No injuriesFinal reportCessna A188 · Statesboro, GAThe pilot stated that he landed the aircraft on the numbers but was close to the left side of the runway. He delayed applying right rudder and the aircraft ground looped. The right landing gear collapsed and the right wing was substantially damaged.NTSB MKC82DA107Accident · No injuriesFinal reportCessna A188 · Appleton City, MOThe pilot elected to land on a crowned, asphalt, farm road while repositioning the aircraft for an agricultural operation. He reported that shortly after touchdown, the aircraft pulled to the left and the left wing entered high weeds. He said he was unable to…NTSB CHI82FA174Accident · 1 fatalField investigationFinal reportCessna A188 · Blue Earth, MNThe flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…NTSB NYC82FHD12Accident · No injuriesFinal reportCessna 188A · Winslow, NJThe acft ran out of fuel while returning to the arpt. The acft landed into a plowed field & then on into an orchard.