NTSB investigations: Cessna 177B, 1986
8 cases on aircraft the registry lists as Cessna 177B. 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
| 1970 | 2 |
|---|---|
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 11 |
| 1974 | 9 |
| 1975 | 11 |
| 1976 | 15 |
| 1977 | 15 |
| 1978 | 23 |
| 1979 | 17 |
| 1980 | 10 |
| 1981 | 11 |
| 1982 | 8 |
| 1983 | 5 |
| 1984 | 8 |
| 1985 | 11 |
| 1986 | 8 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 10 |
| 1991 | 4 |
| 1992 | 11 |
| 1993 | 8 |
| 1994 | 1 |
| 1995 | 11 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 6 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 6 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 5 |
| 2026 | 7 |
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 ('2073708'))
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 ('2073708'))
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 ANC87LA020Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Willow, AKThe pilot stated that he had good ground visibility but suddenly flew into whiteout conditions losing ground reference. He stated that before realizing what had happened the acft struck the top of the mountian rigde.NTSB BFO86LA048Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Westminster, MDFive inches of one propeller blade tip separated during cruise flight at an altitude of 3,500 ft MSL. The imbalance resulted in a severe vibration and a partial power loss. Unable to maintain altitude, the plt set up for a forced landing at clearview airport.…NTSB BFO86FA044Accident · 1 fatalField investigationFinal reportCessna 177B · Springfield, VAAccording to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally…NTSB DEN86LA233Accident · No injuriesLimited investigationFinal reportCessna 177B · Broomfield, COThe plt said that he was on a high final approach for landing and just prior to touchdown, the acft was hit by a strong gust of wind. After touchdown, the plt lost control of the acft and it went off the left side of the rwy. The acft sustained substantial…NTSB CHI86FA199Accident · No injuriesField investigationFinal reportCessna 177 · Oshkosh, WIA spl tfc management program was in effect for an annual eaa fly-in, & a waiver to FAA handbook 7110.65D was in effect which allowed for reduced sepn btn acft opng at wittman fld. As 2 acft were lndg, the plt of the 1st acft (Cessna 177, N17204) was told to…NTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…NTSB LAX86FA240Accident · 1 fatalField investigationFinal reportCessna 177B · Fullerton, CAThe plt took off on a flt to provide traffic reports to a local broadcasting station. Witnesses rprtd that shortly aftertakeoff, the eng began to misfire. The acft entered a steep left bank angle, then plummeted toward the gnd. While still in a steep nose…NTSB LAX86LA136Accident · No injuriesLimited investigationFinal reportCessna 177B · Tehachapi, CAAfter determining the takeoff wt of the acft would be over the max gross, the plt asked the operator the day before the accident to drain 20 gals of fuel from the tanks.a plt who flew the acft prior to the accident flt said he flew for about one hour and did…