NTSB investigations: Cessna 177, 1996
6 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\") = 1996
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") = 1996
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 CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB MIA97LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ringgold, GAThe pilot's failure to see and avoid obstructions during takeoff.NTSB ATL96LA126Accident · No injuriesLimited investigationFinal reportCessna 177 · Lyon, MSthe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, which resulted in a ground swerve. The gusty crosswind condition was a related factor.NTSB NYC96FA178Accident · 1 fatalField investigationFinal reportCessna 177 · Youngstown, OHthe pilot's delay in aborting the landing, and his failure to attain adequate airspeed to fly out of ground effect, which resulted in a stall/mush and collision with the ground. Factors relating to the accident were: the pilot's improper recovery from a…NTSB IAD96LA095Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Versailles, OHFuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.NTSB LAX96LA107Accident · No injuriesLimited investigationFinal reportCessna 177 · Corona, CAimproper planning/decision by the pilot-in-command (PIC), and his failure to ensure that adequate airspeed was obtain and/or maintain during lift-off/initial climb. A factor relating to the accident was: the PIC allowed the airplane's maximum gross weight…