NTSB investigations: Cessna 177, 1990
10 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\") = 1990
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") = 1990
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 SEA90LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Christmas Valle, ORThe pilot's inadequate preflight and failure to maintain alignment during landing ground roll. Factors in the accident were the contaminated fuel and the soft terrain on the landing surface.NTSB CHI90LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Farmington, MOFuel exhaustion due to unknown reasons.NTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.NTSB MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB ATL90LA152Accident · No injuriesLimited investigationFinal reportCessna 177 · Windsor, NCThe pilot's failure to maintain control of the airplane during the flare phase of the approach. Contributing to the accident was the gusty wind condition on final caused by thunderstorm activity in the vicinity of the landing area. The pilot did not…NTSB MKC90LA149Accident · No injuriesLimited investigationFinal reportCessna 177 · Newton, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB ATL90LA122Accident · No injuriesLimited investigationFinal reportCessna 177 · Hazard, KYFailure of the pilot-in-command to execute a go-around, when an updraft caused the aircraft to be high on final.NTSB ATL90FA119Accident · 2 fatalField investigationFinal reportCessna 177 · Canton, GAThe intentional flight into instrument meteorological conditions by the non-instrument rated pilot.NTSB NYC90FA077Accident · 2 fatalField investigationFinal reportCessna 177 · Forty Fort, PALoss of engine power for an unknown reason, and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.