NTSB investigations: Cessna 180H
9 cases on aircraft the registry lists as Cessna 180H, where the first occurrence was “Loss of control - in flight”. 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 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2006 | 1 |
Where
Latest 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 ('2072618')
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\" = 250))
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 ('2072618')
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" = 250))
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 NYC06CA183Accident · No injuriesData collectionFinal reportCessna 180H · Blue Bell, PAThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in the right wing contacting the runway. A factor was the crosswind.NTSB ANC97LA124Accident · No injuriesLimited investigationFinal reportCessna 180H · Arctic Village, AKThe pilot's inadequate compensation for gusty wind conditions. Factors were the gusty wind conditions, and the pilot's misjudging the wind information.NTSB SEA95LA125Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Monroe, WAThe pilot's failure to maintain airspeed.NTSB ANC92LA038Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Shishmaref, AKThe non-instrumented rated pilot-in-command attempted visual flight into known instrument meteorological conditions. Factors contributing to the accident were the fog, the icing conditions, and the pilot's over confidence in his personal ability.NTSB LAX89LA045Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Eureka, CADuring the takeoff run on calm water, the floatplane pilot noticed three pylons ahead. He felt there was insufficient space to abort, so he continued the takeoff. Just before reaching the pylons, he rotated the airplane in an effort to lift-off & clear the…NTSB SEA87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Shelton, WADuring initial climbout the pilot stated that a loss of power occurred. However, no reason for loss of power could be found. An eye witness to the accident stated that he heard power throughout the takeoff to the moment of impact. The propeller showed heavy…NTSB ANC86LA045Accident · No injuriesLimited investigationFinal reportCessna 180-H · Cordova, AKThe pilot stated that after lift off from the water, the left wing tip caught the water causing the aircraft to cartwheel and sink. At the time of the accident the wind was reported as 060 degrees at 15 knots gusting 35 knots.NTSB ANC85FA136Accident · Minor injuriesField investigationFinal reportCessna 180H · Anchorage, AKThe pilot attempted to takeoff uphill from a short airstrip with a steep incline during a no wind condition. The airplane drifted off the centerline after liftoff and struck three parked airplanes before hitting trees and turning over. Uphill takoffs are not…NTSB ANC83FA096Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt of the float plane reported that he initiated his takeoff from lake hood toward the southeast with a 'canal option.' He stated that during the takeoff, he pulled the acft into the air before reaching the canal, then started a left turn toward the…