NTSB investigations: Cessna 177A
6 cases on aircraft the registry lists as Cessna 177A, where the first occurrence was “Hard 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2006 | 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 ('2073706')
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\" = 200))
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 ('2073706')
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" = 200))
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 SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.NTSB LAX04CA136Accident · No injuriesData collectionFinal reportCessna 177A · Honolulu, HIthe pilot's misjudged landing flare, which resulted in a hard landing and porpoising down the runway.NTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.NTSB SEA96LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORfailure of the pilot to properly judge the distance and altitude to the runway just before touching down, and his premature flare for landing. Factors relating to the accident were: the presence of sun glare during the landing, and the resultant degradation…NTSB BFO88DIG01Accident · Minor injuriesFinal reportCessna 177A · Stevensville, MDWhile practicing touch-and-go landings, the student plt made an approach at a higher than normal airspeed. Subsequently,the acft bounced three times on the runway before the plt elected to go around. The student stated that control was lost on the go-around…NTSB ATL82DA247Accident · Minor injuriesFinal reportCessna 177 · Greensboro, NCThe pilot reported that during a landing on runway 27, he encountered gusty crosswinds from 150 to 160 deg. The said the aircraft drifted right about 30 ft. reportedly, he was slipping the plane back to the runway when the aircraft landed hard. During the…