NTSB investigations: Cessna 177B, 1988
5 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\") = 1988
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") = 1988
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 ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…NTSB SEA88LA119Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Elko, NVPlt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of…NTSB BFO88LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Milford, DEThe plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by…NTSB SEA88LA125Accident · No injuriesLimited investigationFinal reportCessna 177B · Ocean Shores, WADuring taxi for takeoff, plt misjudged clrnc between wingtip and mowing machine.NTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.