NTSB investigations: Cessna 188, 1984
3 cases on aircraft the registry lists as Cessna 188. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 5 |
| 1968 | 7 |
| 1969 | 5 |
| 1970 | 4 |
| 1971 | 8 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 5 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 4 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2011 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073002'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073002'))
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 MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB MKC84LA193Accident · No injuriesLimited investigationFinal reportCessna 188 · Dyersville, IAThe acft was over max gross wt by aprx 147 lbs and exceeded the fwd CG limit with a 1200 lb chemical load. During the initial climb at 50-100 ft AGL the acft could not maintain flying speed, stalled, and entered an uncontrolled descent. The acft impacted…NTSB FTW84LA176Accident · No injuriesLimited investigationFinal reportCessna 188 · Clayton, LADuring the last landing of the day in a gusty crosswind, the acft went off the side of the rwy and nosed down in a plowed field. This was the plts 26th landing for this day, all on the same rwy. The wind was gusting to 20 KTS.