NTSB investigations: Cessna A188B, UT
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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2009 | 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\" = 'UT' 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" = 'UT' 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 WPR09CA303Accident · No injuriesData collectionFinal reportCessna A188B · Ogden, UTA partial loss of engine power due to the number one cylinder air induction tube becoming disconnected for undetermined reasons.NTSB DEN83LA163Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Hooper, UTThe spraying operation was being conducted over a large mosquito abatement district. The district was mapped out into several small areas to be sprayed. Due to the many areas to be sprayed, the plt did not inspect each section for obstacles prior to the flt.…NTSB DEN82DA101Accident · No injuriesFinal reportCessna 188B · Central, UTPilot ran out of fuel and made a forced landing during which a wing collided with a fence.NTSB DEN81FTM32Accident · Minor injuriesClosedCessna A188B · Layton, UTNTSB DEN80DTM24Accident · No injuriesClosedCessna 188 · Vernal, UTNTSB DEN77FTM19Accident · Minor injuriesClosedCessna 188B · Vernal, UTNTSB DEN76DTM35Accident · No injuriesClosedCessna 188B · New Castle, UT