NTSB investigations: Cessna 177, 1998
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\") = 1998
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") = 1998
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 MIA99LA061Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Lauderdale, FLThe intentional operation of the airplane by the pilot with known deficiencies in equipment (fuel leakage from the carburetor), poor preflight by the pilot for his failure to visually determine that the fuel tanks were full before the initial flight. Factors…NTSB MIA99LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Immokalee, FLThe certified flight instructor's inadequate supervision and his inadequate management of the fuel, which resulted in fuel exhaustion.NTSB SEA99LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Bellingham, WAInadequate preflight planning/preparation, and the pilot's failure to maintain altitude. VFR flight into IMC conditions and cloudy weather conditions were factors.NTSB FTW98LA413Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Belen, NMThe pilot inadvertently stalling the airplane.NTSB LAX98FA267Accident · Serious injuriesField investigationFinal reportCessna 177 · Los Angeles, CAThe failure of the pilot to accurately determine that an adequate quantity of fuel was aboard the aircraft for the intended flight, and the failure to monitor fuel quantity remaining while en route to ensure an adequate quantity of reserve fuel prior to…NTSB SEA98FA161Accident · 1 fatalField investigationFinal reportCessna 177 · Red Lodge, MTThe pilot's failure to maintain adequate altitude over, or clearance with, mountainous terrain during night visual flight rules flight. Factors included night lighting conditions and mountainous terrain.NTSB LAX98LA250Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Corona, CAThe loss of engine power due to a partially closed fuel shutoff valve as a result of improper maintenance installation.NTSB CHI98LA256Accident · No injuriesLimited investigationFinal reportCessna 177 · Cassville, WIan undetermined event which resulted in engine failure on landing roll out during attempted restart fuel ignited and an undetermined event in the airplane's fuel system which resulted in a fire.NTSB ATL98LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · New Port Richey, FLpartial loss of engine power for undetermined reasons, which led to a forced landing and collision with trees.