NTSB investigations: Cessna 177
8 cases on aircraft the registry lists as Cessna 177, where the first occurrence was “In flight encounter with weather”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2003 | 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 ('2073704')
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\" = 240))
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 ('2073704')
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" = 240))
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 ATL03FA061Accident · 3 fatalField investigationFinal reportCessna 177 · Old Fort, NCThe pilot's decision to continue VFR flight into IMC and his failure to maintain terrain clearance which resulted in an in-flight collision with mountainous terrain.NTSB SEA99LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Bellingham, WAInadequate preflight planning/preparation, and the pilot's failure to maintain altitude. VFR flight into IMC conditions and cloudy weather conditions were factors.NTSB CHI97LA036Accident · No injuriesLimited investigationFinal reportCessna 177 · Regan, NDthe pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.NTSB ATL90LA152Accident · No injuriesLimited investigationFinal reportCessna 177 · Windsor, NCThe pilot's failure to maintain control of the airplane during the flare phase of the approach. Contributing to the accident was the gusty wind condition on final caused by thunderstorm activity in the vicinity of the landing area. The pilot did not…NTSB LAX90FA016Accident · 3 fatalField investigationFinal reportCessna 177 · So Lake Tahoe, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions.NTSB NYC85FFA02Accident · Serious injuriesFinal reportCessna 177 · Claryville, NYThe acft impacted trees during a precautionary lndg due to the plts EST of a low fuel state. The flt had proceeded r enroute to an intended dest of oxford me from frederick MD without filling a flt plan. After aprx 3 hrs of flying on a 60 degree mag hdg the…NTSB CHI83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot took off with an estimate 4 hrs of fuel on board. While en route, he encountered headwinds that were stronger than expected. After about 3 hrs and 48 min of flight, he was still about 27 to 28 mi from his destination and diverted to the Dayton…NTSB CHI83FA050Accident · 1 fatalField investigationFinal reportCessna 177 · Medina, OHAt about 1430 EST, the pilot took off from freedom field, Medina, OH in VFR conditions. When he returned about 3 hrs later at dusk, the weather was estimated to be: 400 ft overcast, 3/4 mi visibility with fog. A flight instructor heard the plane fly over the…