NTSB investigations: Cessna 180H
8 cases on aircraft the registry lists as Cessna 180H, where the first occurrence was “In flight collision 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1993 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 230))
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" = 230))
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 ANC04LA035Accident · No injuriesLimited investigationFinal reportCessna 180H · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a snow drift during takeoff/initial climb. Factors contributing to the accident were the snow-covered and uneven terrain.NTSB ANC03LA067Accident · 3 fatalLimited investigationFinal reportCessna 180 · Anchor Point, AKAn in-flight collision with water for an undetermined reason.NTSB ANC03LA022Accident · 1 fatalLimited investigationFinal reportCessna 180 · Petersburg, AKAn in flight collision with ocean water for an undetermined reason.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.NTSB LAX93LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Davenport, CAThe pilot's failure to maintain directional control to avoid the high vegetation. Factors relating to this accident were the failure of the pilot to obtain the climb airspeed and the inadvertent stall/mush.NTSB ANC93LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Port Alsworth, AKThe non instrument rated pilot in command entering instrument meteorological conditions. A factor in the accident was the snow/whiteout condition.NTSB ANC84LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKAccording to the plt, he circled the landing area & then began a low pass (upwind leg) at 30 to 40 ft AGL when the acft started to settle. He applied full power, but the acft struck the ground in a level attitude & rolled to a stop in a boulder patch. During…NTSB LAX84LA079Accident · 1 fatalLimited investigationFinal reportCessna 180 · Las Vegas, NVWhile on a x-country flt, the acft collided with the crest of a 10,000 ft mountain. Witnesses stated that the plt had circled in the area prior to the accident. The accident reportedly occurred at dusk, but witnesses said the area to the north of the site was…