NTSB investigations: Cessna 177, GA
16 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
| 1968 | 1 |
|---|---|
| 1969 | 3 |
| 1970 | 1 |
| 1975 | 1 |
| 1977 | 2 |
| 1981 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
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 ERA11CA419Accident · No injuriesData collectionFinal reportCessna 177 · Americus, GAThe CFI and pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB ATL02LA090Accident · No injuriesLimited investigationFinal reportCessna 177 · Locust Grove, GAThe pilot improper flare during an aborted takeoff, followed by an subsequent hard landing.NTSB ATL01LA069Accident · No injuriesLimited investigationFinal reportCessna 177 · Milledgeville, GAThe student pilot's failure to maintain directional control and the subsequent collision with an object during an attempted landing. A factor was porpoise induced oscillation.NTSB MIA97LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ringgold, GAThe pilot's failure to see and avoid obstructions during takeoff.NTSB ATL90FA119Accident · 2 fatalField investigationFinal reportCessna 177 · Canton, GAThe intentional flight into instrument meteorological conditions by the non-instrument rated pilot.NTSB ATL83FKG10Accident · Serious injuriesFinal reportCessna 177 · Greensboro, GAThe plt-in-command reported that the acft was very low on fuel & he had 10 gallons added to each wing tank before departing madison, GA. From madison, he flew to Greensboro, GA for sales demonstrtion flts. During the 1st demonstration flt, the acft performed…NTSB ATL81FKG31Accident · Serious injuriesClosedCessna 177 · Cummings, GANTSB MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GANTSB MIA77FKG25Accident · Minor injuriesClosedCessna 177 · Jonesboro, GANTSB MIA75DKG82Accident · No injuriesClosedCessna 177 · Brooks, GANTSB MIA70FKG04Accident · No injuriesClosedCessna 177 · Villa Rica, GANTSB MIA71D0001Accident · No injuriesClosedCessna 177 · Valdosta, GANTSB MIA69A0083Accident · 3 fatalClosedCessna 177 · Chamblee, GANTSB MIA70D0049Accident · No injuriesClosedCessna 177 · Stone Mtn., GANTSB MIA69F0213Accident · No injuriesClosedCessna 177 · Marietta, GA