NTSB investigations: Cessna A188A, 1983
5 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.
Cases per year
| 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 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\") = 1983
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") = 1983
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" 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 LAX84LA100Accident · No injuriesLimited investigationFinal reportCessna A 188 A · Cantua Creek, CAThe acft collided with a pick-up truck during a landing on a private airstrip. The truck driver became distracted while driving alongside the dirt rwy and reported that he did not see the arriving acft.NTSB CHI83LA434Accident · No injuriesLimited investigationFinal reportCessna 188A · Green Springs, OHTakeoff was on rwy 36. The reported winds at findlay, OH (32MI away) were 220 deg at 12 KTS gusting 19 KTS, with an OAT of 88 deg f. the plt stated that the acft rotated normally, cleared the trees, then kept settling & wouldn't climb any more. The plt made a…NTSB MKC83LA210Accident · No injuriesLimited investigationFinal reportCessna 188A · Klemme, IAThe acft inadvertently descended into the tops of a corn crop while dispensing smoke in preparation for spraying. The induced drag slowed the acft and it landed hard. The plt stated he diverted his his attn to the spray nozzles.NTSB ATL83FKG11Accident · 1 fatalFinal reportCessna A188A · Jesup, GAThe plt was spraying a field that was bordered by tree lines on the north & south edges. While pulling up from a swath run at the south side of the field, the acft hit the top of a pecan tree. Reportedly, after impacting the tree, the acft pitched up, entered…NTSB LAX83LA075Accident · No injuriesLimited investigationFinal reportCessna 188 · Five Points, CAThe pilot lost control of his aircraft during takeoff in a cross wind. The aircraft ground looped collapsed the right main landing gear and nosed over. The agricultural operations were canceled at this provisional strip because of wind and the aircraft was…