NTSB investigations: Cessna 177, 1986
9 cases on aircraft the registry lists as Cessna 177. 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
| 1965 | 1 |
|---|---|
| 1967 | 5 |
| 1968 | 104 |
| 1969 | 103 |
| 1970 | 69 |
| 1971 | 43 |
| 1972 | 42 |
| 1973 | 28 |
| 1974 | 29 |
| 1975 | 30 |
| 1976 | 24 |
| 1977 | 20 |
| 1978 | 17 |
| 1979 | 18 |
| 1980 | 15 |
| 1981 | 13 |
| 1982 | 13 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 9 |
| 1989 | 14 |
| 1990 | 10 |
| 1991 | 10 |
| 1992 | 12 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 9 |
| 1999 | 11 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 5 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 7 |
| 2009 | 4 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 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 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 ('2073704'))
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 ('2073704'))
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 NYC87FA049Accident · 1 fatalField investigationFinal reportCessna 172M · Kingston, NYCessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final…NTSB CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…NTSB FTW87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Jacksboro, TXThe pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts.NTSB ATL86LA252Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrodsburg, KYThe plt reported experiencing a loss of power at an alt of aprx 100 ft AGL shortly after takeoff. A forced landing was made into a small field during which the nose gear collapsed. Cause of the power loss was not determined.NTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…NTSB FTW86LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Lubbock, TXDuring an attempted go-around, after touching down past the runway mid-point, the pilot stated he was unable to obtain sufficient power during the go-around. The aircraft crashed 200 feet off the end of the runway. FAA inspectors on the scene stated that they…NTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.NTSB DEN86FA092Accident · 3 fatalField investigationFinal reportCessna 177 · Anaconda, MTThe sole surviving pax said the eng lost power during cruise flight over mountainous terrain. The plt attempted a forced landing but hit a tree and the acft crashed. Aprx 5 gals of automotive fuel were drained from wing tank. Fuel sample taken from plt's…NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.