NTSB investigations: Cessna 177, VA
8 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 |
|---|---|
| 1971 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1988 | 1 |
| 2004 | 1 |
| 2015 | 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\" = 'VA' 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" = 'VA' 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 ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…NTSB NYC04CA200Accident · No injuriesData collectionFinal reportCessna 177 · Warrenton, VAThe pilot's incorrect aborted landing procedure, which resulted in a collision with terrain.NTSB BFO88LA017Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Petersburg, VAThe plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third…NTSB IAD77DID19Accident · No injuriesClosedCessna 177 · Waynesboro, VANTSB IAD76DID38Accident · No injuriesClosedCessna 177 · Roanoke, VANTSB NYC72DIA05Accident · No injuriesClosedCessna 177 · Manassas, VANTSB IAD71AI053Accident · 4 fatalClosedCessna 177 · New Castle, VANTSB DIA69F0132Accident · Serious injuriesClosedCessna 177 · Waynesboro, VA