Skip to content

NTSB investigations: Cessna 177B, TX

16 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

Where

Latest cases

Query with SQL

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" = 'TX' 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

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\" = 'TX' 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" = 'TX' 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

Run 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 CEN27LA023AccidentLimited investigationInvestigation openCessna 177B · Bolivar, TXOct 20, 2026 · N30718 NTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.May 10, 2017 · N34207 · Substantial damage NTSB CEN14LA388Accident · No injuriesLimited investigationFinal reportCessna 177B · Georgetown, TXThe pilot’s improper recovery from a bounced landing.Jul 20, 2014 · N5511B · Substantial damage NTSB CEN12LA524Accident · No injuriesLimited investigationFinal reportCessna 177B · Carthage, TXThe loss of engine power during a low-level aerial observation flight as the result of the wearing of the rocker arm tip due to a thin carburized case layer, which resulted in a forced landing.Aug 7, 2012 · N17201 · Substantial damage NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.Feb 20, 1995 · N34958 · Substantial damage NTSB FTW93LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Houston, TXEngine power loss due to fuel exhaustion for undetermined reasons. Factors were the pilot's failure to monitor and recalculate fuel consumption en route and the lack of suitable terrain onto which the forced landing could have been executed.Aug 16, 1993 · N34689 · Substantial damage NTSB FTW93LA234Accident · No injuriesLimited investigationFinal reportCessna 177B · Grand Prairie, TXLoss of engine power due to fuel starvation as a result of a leaking fuel line. The fuel line was not the correct part as a result of a misidentification by Cessna.Aug 9, 1993 · N34293 · Substantial damage NTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…Jun 13, 1986 · N34889 · Substantial damage NTSB FTW83LA215Accident · 2 fatalLimited investigationFinal reportCessna 177B · Port Aransas, TXDuring a wx briefing, the non-instrument rated plt was told to expect no significant en route wx, but was advised of lower ceilings along the coastline, later that night. There were no records of en route wx briefings. When the acft was about 40 mi northwest…May 2, 1983 · N34581 · Destroyed NTSB FTW80FRA37Accident · No injuriesClosedCessna 177 · Schulenberg, TXJun 8, 1980 · N11950 · Substantial damage NTSB FTW79FQD01Accident · No injuriesClosedCessna 177B · Van Horn, TXNov 21, 1978 · N13380 · Substantial damage NTSB FTW78DRA10Accident · No injuriesClosedCessna 177 · Orange, TXDec 14, 1977 · N13734 · Substantial damage NTSB FTW77DQD26Accident · No injuriesClosedCessna 177B · Pecos, TXAug 22, 1977 · N34760 · Substantial damage NTSB FTW76FPD59Accident · No injuriesClosedCessna 177B · Paris, TXSep 11, 1976 · N34265 · Substantial damage NTSB FTW75FRG52Accident · No injuriesClosedCessna 177 · Sisterdale, TXJan 25, 1975 · N34121 · Substantial damage NTSB FTW73DRG61Accident · No injuriesClosedCessna 177 · Port Lavaca, TXMar 24, 1973 · N30670 · Substantial damage