NTSB investigations: Cessna 177B, 2002
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\") = 2002
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") = 2002
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 SEA02LA147Accident · No injuriesLimited investigationFinal reportCessna 177B · Elma, WAThe pilot's failure to maintain directional control during a bounced landing and recovery resulting in the aircraft's departing the runway. Contributing factors were the high brush/vegetation the aircraft rolled into and the pilot's reduced visual acquisition…NTSB DEN02FA080Accident · 2 fatalField investigationFinal reportCessna 177B · Crowheart, WYthe pilot's failure to maintain clearance of the high mountain terrain. Contributing factors were the high mountain terrain, and the high density altitude weather condition.NTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.NTSB SEA02LA077Accident · No injuriesLimited investigationFinal reportCessna 177B · New Plymouth, IDThe pilot's use of unsuitable terrain (landing surface) at his privately owned landing site. A contribtuing factor was the soft area which the aircraft's right main wheel encountered.NTSB LAX02FA144Accident · Minor injuriesField investigationFinal reportCessna 177B · Fullerton, CAThe total loss of engine power during cruise flight resulting from oil exhaustion. The oil exhaustion resulted from deterioration and total failure of the oil filter converter plate gasket, which had not been replaced due to maintenance personnel's failure to…NTSB LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.