NTSB investigations: Cessna 180K, MT
7 cases on aircraft the registry lists as Cessna 180K. 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
| 1979 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1992 | 1 |
| 2000 | 1 |
| 2002 | 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.\"eventStateOrRegion\" = 'MT' 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 ('2072624'))
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" = 'MT' 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 ('2072624'))
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 SEA02LA104Accident · No injuriesLimited investigationFinal reportCessna 180K · Helena, MTBinding brakes for undetermined reasons and the pilot's failure to maintain directional control during an aborted takeoff.NTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB DEN86LA172Accident · No injuriesLimited investigationFinal reportCessna 180K · Ronan, MTAccording to the plt, during the takeoff ground run, his seat slid to the full aft position. The plt stated he lost control & the acft ground looped.NTSB DEN86FA071Accident · 1 fatalField investigationFinal reportCessna 180 · Kalispell, MTThe plt received a wx briefing and filed an IFR flt plan to Boeing field, seattle, WA. He departed Kalispell, MT, at 1135 MST. When the plt arrived in the spokane area, he obtained wx reports for seattle and decided to turn around and return to Kalispell. Wx…NTSB DEN83LA050Accident · No injuriesLimited investigationFinal reportCessna 180K · Billings, MTThe tailwheel (conventional gear) aircraft was equipped with a robertson stol modification. The pilot reported that with this modification, the plane's stall speed was lowered to 28 to 30 KTS. While in the traffic pattern, tower asked him to keep his speed up…NTSB SEA79FTI08Accident · No injuriesClosedCessna 180K · Missoula, MT