NTSB investigations: Cessna A188A, CA
10 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
| 1973 | 1 |
|---|---|
| 1974 | 1 |
| 1975 | 3 |
| 1977 | 1 |
| 1979 | 1 |
| 1983 | 2 |
| 2003 | 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\" = 'CA' 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 ('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 c."eventStateOrRegion" = 'CA' 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 ('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 LAX03LA070Accident · No injuriesLimited investigationFinal reportCessna A188A · Brawley, CAloss of engine power for undetermined reasons.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 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…NTSB LAX80DUM02Accident · No injuriesClosedCessna 188 · Holtville, CANTSB LAX77FUG56Accident · No injuriesClosedCessna 188B · Blythe, CANTSB LAX76FUM09Accident · Minor injuriesClosedCessna 188A · Brawley, CANTSB OAK76DVG19Accident · No injuriesClosedCessna A188A · Herald, CANTSB OAK75DVA62Accident · No injuriesClosedCessna A188A · Merced, CANTSB OAK74DVG54Accident · No injuriesClosedCessna 188 · Willows, CANTSB OAK73DVG72Accident · No injuriesClosedCessna A188A · Butte City, CA