NTSB investigations: Cessna 180
18 cases on aircraft the registry lists as Cessna 180, where the first occurrence was “On ground/water encounter with terrain/water”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072602')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320))
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 SEA06LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include gusty crosswinds.NTSB ANC05CA066Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with terrain during the landing roll, and subsequent nose down of the airplane. A factor associated with the accident was soft terrain.NTSB ANC04LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of deep/soft snow.NTSB ANC04LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · McCarthy, AKThe separation of the left main landing gear wheel from the gear leg, which resulted in a loss of directional control, and collapse of the right main landing gear. A factor contributing to the accident was the rough and uneven airstrip.NTSB ANC01LA019Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarks Point, AKThe pilot's excessive application of the brakes during landing roll. Factors associated with the accident were water on the runway, low tire pressure, a sheared tire valve stem, and a fractured landing gear axle.NTSB ANC00LA026Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site on a frozen, snow-covered lake. A factor associated with the accident was an area of drifted snow at the landing site.NTSB ANC99LA157Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's choice of unsuitable terrain for taxi, and inadequate compensation for high winds. Factors associated with this accident were the muddy ground, and the winds of 25 knots gusting to 40 knots.NTSB ANC99LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Sand Point, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a large rock.NTSB ANC99LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the soft, snow-covered terrain.NTSB ANC98LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Chalkitsik, AKThe pilot's failure to identify an unsafe/hazardous condition. A factor associated with the accident was soft terrain conditions.NTSB ANC96LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Hope, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was soft terrain.NTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.NTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.NTSB ANC95LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's selection of unsuitable terrain for taxi.NTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.NTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…NTSB DEN84LA056Accident · No injuriesLimited investigationFinal reportCessna 180 · Florissant, COThe acft collided with a snowbank during landing. The rwy had only been plowed to a width of about 16 ft according to the plt. This was a privately owned strip and the plt/owner said he instructed his maintenance man/ranch mgr to plow therwy to minimum width.…NTSB ANC82DAA11Accident · No injuriesFinal reportCessna 180 · Caribou Strip, AKThe pilot reported that he landed in calm wind conditions on a gravel runway that was 1800 ft long. He stated that the landing strip curved to the left, and after touchdown, he was unable to follow the strip to the left. The aircraft went off the right side…