Skip to content

NTSB investigations: Cessna 180D, AK

17 cases on aircraft the registry lists as Cessna 180D. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072610')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072610'))
  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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072610'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.Aug 23, 2022 · N6455X · Substantial damage NTSB GAA19CA286Accident · No injuriesData collectionFinal reportCessna 180 · Takotna, AKThe pilot's failure to maintain directional control during the takeoff, which resulted in impact with vegetation.May 26, 2019 · N3EH · Substantial damage NTSB ANC16LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe overstress fracture and subsequent separation of the left main landing gear axle due to a hard landing, which resulted in the pilot’s inability to maintain directional control of the airplane.May 3, 2016 · N6479X · Substantial damage NTSB ANC05CA138Accident · No injuriesData collectionFinal reportCessna 180 · Aniak, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with brush during the landing flare. A factor contributing to the accident was high vegetation.Sep 6, 2005 · N8624X · Substantial damage NTSB ANC98LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot's failure to maintain directional control during takeoff. Factors associated with the accident were soft airstrip conditions, and trees.Aug 19, 1998 · N180WH · Substantial damage NTSB ANC86LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe plt stated that he landed in the water with the landing gear on the floats in the down and locked position. The acft nosed over in the water on touchdown. The plt stated he failed to use a before landing checklist.Jul 11, 1986 · N6455X · Substantial damage NTSB ANC83LA129Accident · Serious injuriesLimited investigationFinal reportCessna C-180D · Barrow, AKThe pilot stated that he was taxiing downriver, downwind in order to get around two bends in the river to a straight section where a takeoff could be made. The left float of the aircraft struck a sandbar, causing the aircraft to roll end over end.Jul 25, 1983 · N6439X · Substantial damage NTSB ANC76AA093Accident · No injuriesClosedCessna 180D · Wrangell, AKJun 4, 1976 · N6014B · Substantial damage NTSB ANC76AA063Accident · No injuriesClosedCessna 180 · Mccarthy, AKJan 27, 1976 · N6443X · Substantial damage NTSB ANC74AA041Accident · No injuriesClosedCessna 180 · Chitna, AKOct 29, 1973 · N6443X · Substantial damage NTSB ANC72DAG53Accident · No injuriesClosedCessna 180D · Cantwell, AKSep 2, 1971 · N8619X · Substantial damage NTSB ANC72DAG15Accident · No injuriesClosedCessna 180D · Mckinley Pk, AKJul 26, 1971 · N8619X · Substantial damage NTSB ANC71DAG64Accident · No injuriesClosedCessna 180 · Valdez, AKJan 21, 1971 · N6443X · Substantial damage NTSB ANC71DAG10Accident · No injuriesClosedCessna 180 · Anchorage, AKJul 30, 1970 · N8619X · Substantial damage NTSB ANC70A0051Accident · Minor injuriesClosedCessna 180 · Cordova, AKDec 30, 1969 · N8619X · Substantial damage NTSB ANC70A0026Accident · No injuriesClosedCessna 180D · Chitina, AKSep 16, 1969 · N6475X · Substantial damage NTSB ANC69A0030Accident · No injuriesClosedCessna 180D · Manokotak, AKNov 16, 1968 · N8606X · Substantial damage