NTSB investigations: Cessna 177, OR
11 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 | 2 |
|---|---|
| 1969 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 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\" = 'OR' 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" = 'OR' 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 SEA95LA046Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA93LA158Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Troutdale, ORThe pilot's poor inflight decision, and fuel exhaustion. Factors include unfavorable winds, a dark night, and trees in the attempted landing area.NTSB SEA90LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Christmas Valle, ORThe pilot's inadequate preflight and failure to maintain alignment during landing ground roll. Factors in the accident were the contaminated fuel and the soft terrain on the landing surface.NTSB SEA83LA123Accident · No injuriesLimited investigationFinal reportCessna 177 · Hood River, ORThe acft was damaged in a hard landing during unfavorable wind conditons. The pilot had just come cross country where he encountered turbulence. When he called UNICOM to land they gave him winds of 15-25 KTS velocity from the west and turbulence on the final…NTSB SEA82DA079Accident · No injuriesFinal reportCessna 177 · Waldport, ORThe pilot elected to make a normal takeoff from a field of tall, wet grass. Acceleration was noted to be less than desired and the takeoff was aborted. The aircraft continued into a ditch in the overrun area.NTSB SEA75DYI23Accident · Minor injuriesClosedCessna 177 · Cottage Grove, ORNTSB SEA74DYI09Accident · No injuriesClosedCessna 177 · North Bend, ORNTSB SEA74AS005Accident · 2 fatalClosedCessna 177 · Prospect, ORNTSB OAK70A0001Accident · 2 fatalClosedCessna 177 · Astoria, ORNTSB SEA69F0051Accident · Minor injuriesClosedCessna 177 · Sweethome, ORNTSB SEA69D0020Accident · No injuriesClosedCessna 177 · Canby, OR