NTSB investigations: Cessna A188B, NM
7 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
| 1977 | 3 |
|---|---|
| 1981 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 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\" = 'NM' 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" = 'NM' 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 DEN89LA213Accident · No injuriesLimited investigationFinal reportCessna 188B · Sunland Park, NMUndetermined. A factor related to the accident was the crop in the emergency landing area.NTSB DEN86LA130Accident · No injuriesLimited investigationFinal reportCessna A188B · Berino, NMThe pilot reports that he was taking off on his third aerial app flt of the day. He said the wind was from the nw and very light and he was departing to the n. the density alt was calculated to be 5,200 ft. acceleration seemed to be normal until about two…NTSB DEN84LA193Accident · No injuriesLimited investigationFinal reportCessna 188B · Albuquerque, NMThe arpt had a UNICOM & 2 rwys, 17/35 & 10/28. The acft had an operable radio, but the plt did not call UNICOM. He elected to land on rwy 17 which had a x-wind from 100 degs at 20 KTS. During the apch, the plt compensated for the x-wind by lowering the left…NTSB FTW81DQG46Accident · No injuriesClosedCessna 188B · Portales, NMNTSB DEN77FQA53Accident · No injuriesClosedCessna A188B · Raton, NMNTSB DEN77DQG07Accident · Minor injuriesClosedCessna 188 · Clovis, NMNTSB DEN77DQA43Accident · No injuriesClosedCessna 188 · Grady, NM