NTSB investigations: Cessna 177B
10 cases on aircraft the registry lists as Cessna 177B, where the first occurrence was “Loss of engine power”. 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2003 | 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\" = 350))
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" = 350))
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 SEA04FA003Accident · 2 fatalField investigationFinal reportCessna 177B · Chinook, MTThe total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…NTSB LAX00LA069Accident · No injuriesLimited investigationFinal reportCessna 177B · Rialto, CAThe failure of the maintenance personnel to follow the manufacturer's procedures and directives regarding the proper torquing of the screws securing the oil pressure screen housing, which resulted in the loss of lubricating oil, and the subsequent seizure of…NTSB SEA97LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lake Powell, UTA loss of engine power for undetermined reasons.NTSB SEA95LA182Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WALoss of engine power for undetermined reason(s).NTSB LAX94LA026Accident · No injuriesLimited investigationFinal reportCessna 177B · Pleasant Grove, CAThe failure of the starter to turn the engine over due to inadequate maintenance and inspection.NTSB FTW93LA204Accident · No injuriesLimited investigationFinal reportCessna 177B · Shawnee, OKFuel system exhaustion induced power loss for undetermined reasons. A factor was a lack of suitable terrain.NTSB FTW92LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Clovis, NMEngine failure due to improper oil filter installation and subsequent improper aircraft control by the PIC which resulted in a stall. A factor was maintenance inspection not performed after the oil filter installation.NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.NTSB LAX86FA240Accident · 1 fatalField investigationFinal reportCessna 177B · Fullerton, CAThe plt took off on a flt to provide traffic reports to a local broadcasting station. Witnesses rprtd that shortly aftertakeoff, the eng began to misfire. The acft entered a steep left bank angle, then plummeted toward the gnd. While still in a steep nose…NTSB MIA85LA210Accident · No injuriesLimited investigationFinal reportCessna 177B · Cedar Key, FLThe plt reported that shortly after taking off, while flying at 1400 ft, there was a strong odor of fuel in the cabin, then the eng lost power. He was unable to restart the eng & subsequently ditched the acft in the gulf of Mexico about 1/4 mi south of Cedar…