NTSB investigations: Cessna 177RG
15 cases on aircraft the registry lists as Cessna 177RG, where the sequence of events included Off-field or emergency landing. 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
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2023 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073709', '2073710')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('2073709', '2073710')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 WPR25FA146Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Grass Valley, CAAn improperly tightened B-nut fitting at the fuel flow divider, which resulted in a fuel leak and loss of engine power due to fuel starvation, and the inadequate maintenance inspection, which failed to detect and correct the discrepancy.NTSB ERA23LA197Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177RG · Crestview, FLThe total loss of engine power due to the loosening and separation of the No. 1 connecting rod cap nuts in flight, resulting in catastrophic internal engine damage. Contributing to the accident was the pilot/owner’s failure to comply with the engine…NTSB CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB ERA20LA261Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Salinas, PRContamination and corrosion within the fuel system that resulted in a blockage, starvation of fuel to the engine, and the total loss of engine power.NTSB GAA19CA166Accident · Minor injuriesData collectionFinal reportCessna 177RG · Land O' Lakes, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA17CA505Accident · No injuriesData collectionFinal reportCessna 177RG · Byron, CAThe pilot’s improper preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR17LA142Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Vacaville, CAThe total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine revealed no mechanical failure or malfunction that would have precluded normal operation.NTSB CEN13LA076Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIA loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB WPR11FA186Accident · No injuriesField investigationFinal reportCessna 177RG · Gila Bend, AZA total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.NTSB ERA11CA047Accident · No injuriesData collectionFinal reportCessna 177RG · Bedford, KYThe mechanic's failure to properly secure a fuel line when it was reinstalled during an engine inspection.NTSB CEN10LA306Accident · No injuriesLimited investigationFinal reportCessna 177RG · Marietta, OHThe total loss of engine power due to the fatigue failure of the No. 2 cylinder attachment fasteners as a result of improper engine overhaul practices.NTSB CEN09LA487Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Black River Falls, WIThe loss of engine power during cruise due to the number two cylinder piston connecting rod failure for undetermined reasons.NTSB ERA09FA343Accident · 1 fatalField investigationFinal reportCessna 177 RG · Gilford, NHA loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…NTSB NYC08CA208Accident · Minor injuriesData collectionFinal reportCessna 177RG · Bessemer, ALFailure of the left magneto for undetermined reasons resulting in a partial loss of engine power during takeoff.