NTSB investigations: Cessna 180, OH
17 cases on aircraft the registry lists as Cessna 180. 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
| 1964 | 4 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2012 | 1 |
| 2023 | 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\" = 'OH' 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 ('2072602'))
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" = 'OH' 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 ('2072602'))
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 ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.NTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.NTSB ATL89LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Russells Point, OHThe pilot's inaccurate evaluation of weather condition, and his failure to use available weather briefing resources. As a result, the pilot encountered structural icing which covered the windscreen, blocking forward visibility.NTSB ATL87DEI01Accident · Serious injuriesFinal reportCessna 180 · Wadsworth, OHThe airplane reportedly completed an NDB appch to rwy 02. The plt reported that he circled the rwy twice after arriving at the arpt to check the rwy condition. He subsequently landed on rwy 20 where he 'impacted something on runway or hit air pocket, did not…NTSB CHI78FA004Accident · 5 fatalClosedCessna 180 · Bidwell, OHNTSB CHI77DEG05Accident · No injuriesClosedCessna 180 · Lebanon, OHNTSB CHI76FEG01Accident · No injuriesClosedCessna 180 · Morrow, OHNTSB CHI75FEG06Accident · No injuriesClosedCessna 180 · Middletown, OHNTSB CHI75DEI03Accident · No injuriesClosedCessna 180 · Kelly Island, OHNTSB CHI72FEK03Accident · No injuriesClosedCessna 180 · Paulding, OHNTSB CHI69D0131Accident · No injuriesClosedCessna 180 · Sabina, OHNTSB CHI68D0620Accident · No injuriesClosedCessna 180 · Orient, OHNTSB CHI66D0301Accident · No injuriesClosedCessna 180 · Lagrange, OHNTSB UNK64X3439Accident · No injuriesClosedCessna 180 · Columbus, OHNTSB UNK64X2046Accident · 2 fatalClosedCessna 180 · Mansfield, OHNTSB UNK64X1519Accident · No injuriesClosedCessna 180 · Prt Columbus, OHNTSB UNK64X0518Accident · No injuriesClosedCessna 180 · Elyria, OH