Fatal NTSB investigations: Cessna A188
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
| 1967 | 2 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1975 | 3 |
| 1976 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 2016 | 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 c.\"highestInjuryLevel\" = 'Fatal'
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 c."highestInjuryLevel" = 'Fatal'
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 ERA16FA316Accident · 1 fatalField investigationFinal reportCessna A188 · Alapaha, GAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.NTSB FTW92DPG13Accident · 1 fatalFinal reportCessna A188 · Forrest City, ARThe pilot's failure to maintain clearance with the trees.NTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.NTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…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 MIA80FLT01Accident · 1 fatalClosedCessna 188 · Tunica, MSNTSB FTW76FQG86Accident · 1 fatalClosedCessna A188 · Dimmitt, TXNTSB MIA76FKT88Accident · 1 fatalClosedCessna A188 · Indiantown, FLNTSB FTW75FQG60Accident · 1 fatalClosedCessna A188 · Dimmitt, TXNTSB FTW75FQG55Accident · 1 fatalClosedCessna A188 · Vega, TXNTSB DEN75FTC29Accident · 1 fatalClosedCessna A188 · Wheatland, WYNTSB CHI74FEI03Accident · 1 fatalClosedCessna 188A · Millersburg, OHNTSB SEA72FYG11Accident · 1 fatalClosedCessna 188 · Craigmont, IDNTSB OAK71FVG71Accident · 1 fatalClosedCessna A188 · Willows, CANTSB NYC71FHA04Accident · 1 fatalClosedCessna AG188 · Long Pond, PANTSB SEA68F0331Accident · 1 fatalClosedCessna A188 · The Dalles, ORNTSB OAK68A0014Accident · 1 fatalClosedCessna A188 · Pebble Bch, CANTSB OAK67A0089Accident · 1 fatalClosedCessna A188 · Acampo, CA