NTSB investigations: Cessna A188B, IN
11 cases on aircraft the registry lists as Cessna A188B. 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
| 1972 | 1 |
|---|---|
| 1975 | 1 |
| 1976 | 3 |
| 1978 | 1 |
| 1980 | 2 |
| 1988 | 1 |
| 2011 | 1 |
| 2015 | 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.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005'))
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."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073005'))
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 CEN15CA293Accident · Serious injuriesData collectionFinal reportCessna A188B · Crawfordsville, INThe pilot's failure to maintain clearance from the powerline during an aerial application operations.NTSB CEN11CA495Accident · No injuriesData collectionFinal reportCessna A188B · Greenstown, INThe pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.NTSB CHI88DET04Accident · No injuriesFinal reportCessna A188B · Preu, INAerial applicator experienced total failure of throttle cable during application swath run. Aircraft received substantial damage when pilot executed forced landing in adjacent crop field. Aircraft and engine had received annual inspection 125 hours prior to…NTSB CHI80DEX23Accident · No injuriesClosedCessna 188B · Saluda, INNTSB CHI80FEX07Accident · Serious injuriesClosedCessna A188B · Madison, INNTSB CHI78FET18Accident · No injuriesClosedCessna A188B · Butler, INNTSB CHI76DEA52Accident · No injuriesClosedCessna A188B · New Point, INNTSB CHI76FET46Accident · No injuriesClosedCessna A188B · Poneto, INNTSB CHI76DEA44Accident · No injuriesClosedCessna A188B · Vincennes, INNTSB CHI76FET14Accident · Minor injuriesClosedCessna A188B · Nappanee, INNTSB CHI73FEA12Accident · Minor injuriesClosedCessna A188 · Ellettsville, IN