NTSB investigations: Cessna 177B
16 cases on aircraft the registry lists as Cessna 177B, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1999 | 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 ('2073708')
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\" = 250))
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 ('2073708')
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" = 250))
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 LAX06LA246Accident · 2 fatalLimited investigationFinal reportCessna 177B · Kalaupapa, HILoss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.NTSB LAX99FA262Accident · 2 fatalField investigationFinal reportCessna 177B · Tusayan, AZwas the pilot's failure to have available and consult the FAA approved flight manual for performance data and, the high density altitude. Contributing to the accident were the dual magneto and spark plug system issues affecting optimum engine performance.NTSB CHI97FA024Accident · 1 fatalField investigationFinal reportCessna 177B · Chancellor, SDthe pilot's attempted flight with known deficiencies in equipment, his initiating VFR flight into IMC conditions, his spatial disorientation and loss of control of the airplane. Factors were fog, dark night, and inoperative directional gyro.NTSB SEA96MA079Accident · 3 fatalClass 1 · MajorFinal reportCessna 177B · Cheyenne, WYthe pilot-in-command's improper decision to take off into deteriorating weather conditions (including turbulence, gusty winds, and an advancing thunderstorm and associated precipitation) when the airplane was overweight and when the density altitude was…NTSB FTW95LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Torreon, NMThe pilot's failure to attain proper liftoff speed resulting in an inadvertent stall and the failure to remove frost from the wing. A factor was fatigue.NTSB CHI92FA161Accident · 2 fatalField investigationFinal reportCessna 177B · Almont, MIThe pilot's failure to maintain control of the airplane during takeoff while physically impaired by alcohol.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 ATL91LA100Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe pilot's failure to remove the control lock prior to attempting flight and his failure to follow the 'before takeoff' checklist. A factor in the accident was the pilot's diverted attention.NTSB CHI90DEP06Accident · 1 fatalFinal reportCessna 177B · Iola, WIFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin. Factors related to the accident were: the pilot's poorly planned approach, and his failure to go around.NTSB NYC90LA145Accident · No injuriesLimited investigationFinal reportCessna 177B · Danielson, CTThe failure of the pilot to maintain proper runway alignment, and his failure to obtain or maintain adequate airspeed during a go-around, which resulted in an inadvertent stall and collision with the shrubs and trees.NTSB SEA90LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Hitchcock, WAThe pilot's loss of control of the airplane during final approach for landing. Sunglare was a factor related to the accident.NTSB DEN86LA233Accident · No injuriesLimited investigationFinal reportCessna 177B · Broomfield, COThe plt said that he was on a high final approach for landing and just prior to touchdown, the acft was hit by a strong gust of wind. After touchdown, the plt lost control of the acft and it went off the left side of the rwy. The acft sustained substantial…NTSB LAX85FA253Accident · 2 fatalField investigationFinal reportCessna 177B · Ojai, CAWitnesses observed the acft enter a box canyon in level flt at an alt below the tops of the surrounding ridges. The eng pwr sounds were reported as 'normal' by the witnesses. Shortly after the acft disappeared behind a ridge, the witnesses saw black smoke…NTSB MKC85LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Lee'S Summit, MOUpon takeoff, acft lifted off the rwy and settled hard back onto the rwy. Inspection revealed acft was covered with 1/4 to 1/2 inch of snow & ice when the takeoff was attempted.NTSB NYC84LA194Accident · No injuriesLimited investigationFinal reportCessna 177B · New Paltz, NYAcft was landed on rwy 32 with wind from 60 degrees at 10 KTS. The acft bounced on touchdown, pwr was added and the acftbecame airborne. The acft drifted left and contacted a rock in grass off the left side of the rwy.NTSB ATL84FA082Accident · 4 fatalField investigationFinal reportCessna 177B · Lafayette, GAThe acft crashed in an open field during an uncontrolled descent after encountering forecast icing conditions. The plt had received weather briefings and filed a flt plan into icing conditions in an acft not equipped to handle icing. The plt stayed at an…