NTSB investigations: Cessna 180K, 1986
6 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
| 1978 | 3 |
|---|---|
| 1979 | 12 |
| 1980 | 9 |
| 1981 | 4 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 3 |
| 1986 | 6 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1997 | 3 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 2 |
| 2006 | 5 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 1986
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 year(c."eventDate") = 1986
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 LAX87LA352Accident · 2 fatalLimited investigationFinal reportCessna 180K · Lakeport, CAThe plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was…NTSB SEA87LA013Accident · No injuriesLimited investigationFinal reportCessna 180K · Burlington, WAPlt was taking off in fog from wet grass strip. Acft swerved left, plt unable to arrest with opposite rudder and brake, collided with fence. Abort not attempted.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 FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…NTSB SEA86LA097Accident · No injuriesLimited investigationFinal reportCessna 180K · Emigrant Pass, NVThe plt was informed during a wx briefing that VFR flt was not recommended. The plt elected to takeoff regardless and encountered low ceilings and visibilities. While looking for an area of a highway to land the acft, pwr lines were contacted with the top of…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…