NTSB investigations: Cessna 180
6 cases on aircraft the registry lists as Cessna 180, where the sequence of events included 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
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2017 | 1 |
| 2021 | 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '240' 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 ('2072602')
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" = '240' 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 ANC21LA032Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Tyonek, AKThe pilot’s loss of directional control while dragging the surface of an ice- and snow-covered lake in gusting wind conditions, which resulted in an impact with a tree.NTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…NTSB WPR12LA418Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Nampa, IDAn uncommanded bank after takeoff followed by an aerodynamic stall. The reason for the uncommanded bank could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Robstown, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ANC10CA055Accident · No injuriesData collectionFinal reportCessna 180 · Cooper Landing, AKThe pilot's failure to maintain airspeed during takeoff, resulting in an uncontrolled descent and collision with terrain.NTSB ANC08CA044Accident · No injuriesData collectionFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control and inadequate compensation for wind conditions during a go-around. Contributing to the accident were wind gusts and a crosswind.