NTSB investigations: Cessna 180
10 cases on aircraft the registry lists as Cessna 180, 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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1993 | 1 |
| 1999 | 1 |
| 2006 | 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 ('2072602')
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 ('2072602')
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 LAX06FA206Accident · 4 fatalField investigationFinal reportCessna 180 · Payson, AZThe pilot's failure to maintain clearance from the terrain during a low level flyby maneuver. A factor was glare from the sun and shadows created by the mountainous terrain.NTSB ANC99LA154Accident · No injuriesLimited investigationFinal reportCessna 180 · Pilot Point, AKThe pilot's misjudgment of the touchdown point. A factor in the accident was the uneven terrain.NTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.NTSB ANC90LA156Accident · No injuriesLimited investigationFinal reportCessna 180-A · Lime Village, AKThe pilot-in-command's failure to understand the performance data during takeoff. Contributing to the accident was the unsuitable terrain not being identified by the pilot-in-command.NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.NTSB SEA88LA080Accident · 2 fatalLimited investigationFinal reportCessna 180 · Hailey, IDThis Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…NTSB SEA86FA233Accident · 1 fatalField investigationFinal reportCessna 180 · Wallace, IDPlt received wx brief, advised VFR for proposed flt. Plt filed VFR flt plan and departed. Wreckage located 2 days later at crest of mountain pass.NTSB ANC85LA178Accident · No injuriesLimited investigationFinal reportCessna 180 · Tutna Lake, AKThe plt elected to takeoff from a lake that was aprx 1/2 mi long & oriented on an east/west heading. During a x-wind takeoff, the plt had difficulty getting the acft to lift off, but elected to continue the takeoff. The acft finally lifted off, but failed to…NTSB ANC82DAG39Accident · Minor injuriesFinal reportCessna 180 · Rush Lake, AKThe float-equipped acft failed to clear rising terrain after taking off from Rush Lake. The pilot stated that the enginewas developing full power.NTSB ANC82DA025Accident · No injuriesFinal reportCessna 180 · Mcgrath, AKThe pilot reported there was no wind on the ground. However,immediately after takeoff he encountered a downdraft which would not allow him to clear trees at the end of the airstrip. Takeoff was on runway 5.wind reported by farewell,AK,located 19MI nw of the…