NTSB investigations: Cessna 180, WI
18 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 4 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2011 | 1 |
| 2021 | 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\" = 'WI' 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" = 'WI' 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 CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.NTSB CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB CHI98LA297Accident · No injuriesLimited investigationFinal reportCessna 180 · Oshkosh, WIthe pilot of the other airplane did not maintain proper clearance.NTSB CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.NTSB CHI80FEP52Accident · No injuriesClosedCessna 180 · Bevent, WINTSB CHI79DEP34Accident · No injuriesClosedCessna 180 · Waunakee, WINTSB CHI75DER06Accident · No injuriesClosedCessna 180 · River Falls, WINTSB CHI72FEP48Accident · No injuriesClosedCessna 180 · Menomonee Fls, WINTSB CHI70DDJ26Accident · No injuriesClosedCessna 180 · Lone Rock, WINTSB CHI70F0310Accident · Minor injuriesClosedCessna 180 · Reeseville, WINTSB CHI70D0279Accident · No injuriesClosedCessna 180 · Phelps, WINTSB CHI70D0129Accident · Minor injuriesClosedCessna 180 · Balsam Lake, WINTSB CHI70D0077Accident · No injuriesClosedCessna 180 · Neenah, WINTSB CHI67D0668Accident · No injuriesClosedCessna 180 · Sextonville, WINTSB CHI67F0434Accident · No injuriesClosedCessna 210-5 · Waupun, WINTSB CHI65F0080Accident · No injuriesClosedCessna 180 · Oconomowoc, WINTSB UNK65X1199Accident · No injuriesClosedCessna 180 · Rice Lake, WI