NTSB investigations: Cessna 177B
11 cases on aircraft the registry lists as Cessna 177B, where the first occurrence was “Loss of control - on ground/water”. 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073708')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073708')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 MIA05CA151Accident · No injuriesData collectionFinal reportCessna 177B · Olive Branch, MSThe failure of the pilot to maintain directional control during the landing roll resulting in an on ground collision with a runway light and subsequent collapse of the nose landing gear.NTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.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 LAX98LA203Accident · No injuriesLimited investigationFinal reportCessna 177B · Fallon, NVThe pilot's improper use of rudder controls on a short field takeoff and his failure to maintain runway alignment.NTSB SEA97LA078Accident · No injuriesLimited investigationFinal reportCessna 177B · Everett, WAfailure of the pilot to maintain directional control of the airplane after landing. Factors relating to the accident include: a blown (failed) nose tire, and soft terrain beside the runway.NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.NTSB NYC93LA071Accident · No injuriesLimited investigationFinal reportCessna 177B · Brookville, OHThe pilot's failure to maintain directional control. Contributing was the lack of recency of experience.NTSB CHI92LA285Accident · No injuriesLimited investigationFinal reportCessna 177B · Norcross, MNThe pilot's premature liftoff which resulted in inadequate airspeed for takeoff. Factors related to the accident were the crosswind conditions, the pilot's inadequate compensation for the crosswind, and the pilot's total lack of experience.NTSB FTW89LA094Accident · No injuriesLimited investigationFinal reportCessna 177B · Harrah, OKFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve; and his improper planning/decision (indecision) concerning an attempted go-around. The pilot's lack of experience in the type of aircraft…NTSB DEN87LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Fort Collins, CODuring the approach to Fort Collins downtown airport, the pilot reported encountering moderate turbulence. At touchdown on runway 11, a crosswind gust pushed the aircraft off the left side of the runway into the grass. The aircraft bounced and came to a stop…NTSB ATL84LKG04Accident · Serious injuriesFinal reportCessna 177B · Kennesaw, GAThe acft bounced during landing and when it started to veer off the rwy the plt attempted a go-around. The acft collidedwith trees and came to rest in a small ditch.