NTSB investigations: Cessna 180H
16 cases on aircraft the registry lists as Cessna 180H, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2011 | 3 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2026 | 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 ('2072618')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.NTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA521Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot’s failure to maintain an appropriate glidepath to an off-airport landing site.NTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.NTSB ANC16CA027Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during landing, which resulted in a collision with terrain. Contributing to the accident was the loose dirt and gravel deposited in the center of the runway.NTSB GAA15CA267Accident · No injuriesData collectionFinal reportCessna 180H · Delta Junction, AKThe pilot's failure to attain and maintain yaw control during the approach and attempted go around, which resulted in impact with trees and terrain.NTSB GAA15CA231Accident · Minor injuriesData collectionFinal reportCessna 180H · Ione, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA112Accident · No injuriesData collectionFinal reportCessna 180 · Vichey, MOThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB ANC14LA054Accident · No injuriesLimited investigationFinal reportCessna 180H · Seward, AKThe pilot’s execution of a hard uncoordinated landing, which resulted in the overstress fracture of the right main landing gear (MLG) axle attachment bolts and the subsequent separation of the of the right MLG axle.NTSB ANC14LA039Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot’s failure to maintain directional control during landing and an attempted go-around, which resulted in collision with terrain.NTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.NTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.NTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.NTSB ANC11CA111Accident · No injuriesData collectionFinal reportCessna 180H · Chenga Bay, AKThe pilot's failure to maintain clearance from an obstruction while landing at an off-airport site, resulting in a loss of control.NTSB ANC11CA043Accident · No injuriesData collectionFinal reportCessna 180H · Skwentna, AKThe pilot's loss of directional control during landing.