NTSB investigations: Cessna 177B, MT
7 cases on aircraft the registry lists as Cessna 177B. 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
| 1976 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 2003 | 1 |
| 2014 | 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\" = 'MT' 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 ('2073708'))
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" = 'MT' 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 ('2073708'))
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 WPR14FA362Accident · 1 fatalField investigationFinal reportCessna 177B · Neihart, MTThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude in turbulent conditions over mountainous terrain. Contributing to the accident was the pilot's improper decision to traverse the mountainous area with the airplane over…NTSB SEA04FA003Accident · 2 fatalField investigationFinal reportCessna 177B · Chinook, MTThe total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…NTSB SEA92FA113Accident · 4 fatalField investigationFinal reportCessna 177B · St. Ignatius, MTThe pilot in command's inadvertently allowing the aircraft to enter into a stall/spin. Factors contributing to the accident were: terrain condition, rising terrain, and the pilot in command's lack of familiarity with the geographic area.NTSB DEN86LA041Accident · No injuriesLimited investigationFinal reportCessna 177B · Billings, MTThe acft was damaged during a forced landing in a fld following a loss of pwr from fuel exhaustion. The plt stated that during the preflight he checked the fuel level by the gages and not visually. The gages indicated slightly over one-half full at that time.NTSB DEN82FTA09Accident · 1 fatalFinal reportCessna 177B · Wolf Pt., MTThe pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…NTSB DEN81FTA13Accident · No injuriesClosedCessna 177 · Lavina, MTNTSB SEA76FTA22Accident · No injuriesClosedCessna 177 · Hardin, MT