NTSB investigations: Cessna 177B, 2010
6 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\") = 2010
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") = 2010
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 CEN11CA123Accident · No injuriesData collectionFinal reportCessna 177B · Seymour, INThe pilot's failure to maintain directional control while taking off with a gusting wind.NTSB ERA10CA460Accident · No injuriesData collectionFinal reportCessna 177B · Ocean City, MDThe pilot's improper recovery from a bounced downwind landing.NTSB ERA10LA396Accident · No injuriesLimited investigationFinal reportCessna 177B · Mashpee, MAThe pilot’s delayed use of carburetor heat while flying at reduced power settings in conditions that were favorable for carburetor icing resulting in the partial loss of engine power.NTSB ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.NTSB WPR10LA376Accident · No injuriesLimited investigationFinal reportCessna 177 · Rawlins, WYThe pilot's inadequate preflight planning, failure to properly use the takeoff checklist, and failure to lean the fuel mixture, which resulted in the airplane’s inability to attain sufficient airspeed due to the rich fuel mixture.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…