NTSB investigations: Cessna 180B
9 cases on aircraft the registry lists as Cessna 180B, where the first occurrence was “Loss of control - on ground/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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 2003 | 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 ('2072606')
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\" = 260))
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 ('2072606')
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" = 260))
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 SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.NTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.NTSB ANC90LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot failed to maintain directional control during landing. Contributing factors were the rough terrain, and the pilot's lack of total and recent experience in that model airplane.NTSB FTW89LA046Accident · No injuriesLimited investigationFinal reportCessna 180B · Nocona, TXThe pilot's disregard of the aircraft performance data/operational limitations by landing in excess of the crosswind capability of the aircraft, and the resultant loss of directional control during the landing roll.NTSB LAX88LA171Accident · No injuriesLimited investigationFinal reportCessna 180B · Quincy, CAAt the end of a pleasure flight, while in the traffic pattern, the pilot noted that the winds were light and variable. While on final approach, a correction for drift was made. During the landing roll, in gusting conditions, the pilot lost control of the…NTSB ANC87LA041Accident · No injuriesLimited investigationFinal reportCessna 180B · Palmer, AKThe pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on…NTSB LAX85LA382Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Placerville, CAAcft ran off the rwy after landing. Plt reported acft veered to the left off the rwy and was able to correct back after application of power. Winds were variable at 7 KTS gusting to 12 KTS.NTSB DEN83LA128Accident · No injuriesLimited investigationFinal reportCessna 180B · Decker, MTThe tailwheel acft groundlooped on takeoff as the tail came up and the acft swerved sharply to the left. During the turn at about 40 mph the acft nosed over. The pilot noticed a pulling to the left as the takeoff roll commenced but thought he could contain it…