NTSB investigations: Cessna 177B, PA

11 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

NTSB investigations: Cessna 177B, PA per year, 1973–2026: 11 cases
1973	1
1976	1
1980	1
1981	1
1982	1
1991	1
1995	1
2000	1
2011	2
2012	1

Where

Open the map

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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…May 5, 2012 · N34539 · Substantial damage NTSB ERA12CA020Accident · No injuriesData collectionFinal reportCessna 177B · Honesdale, PAThe pilot’s excessive airspeed during final approach and his delayed decision to abort the landing, resulting in the in-flight collision with trees during the go-around.Oct 10, 2011 · N34218 · Substantial damage NTSB ERA11LA154Accident · No injuriesLimited investigationFinal reportCessna 177B · Reading, PAInadequate maintenance inspection of the airplane which resulted in a shift of the shock mounted portion of the pilot's instrument panel, causing an interference of the pitch control during takeoff.Feb 18, 2011 · N11625 · Substantial damage NTSB NYC01LA029Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Prosperity, PAThe failure of the dual magneto ignition system points to open.Nov 2, 2000 · N35241 · Substantial damage NTSB NYC95LA120Accident · No injuriesLimited investigationFinal reportCessna 177B · Allentown, PAthe pilot misjudged the flare, resulting in a hard, bounced landing and impact with the runway. A factor in this accident was an improper recovery from a bounced landing.May 24, 1995 · N621PW · Substantial damage NTSB NYC92LA043Accident · No injuriesLimited investigationFinal reportCessna 177B · Dalmatia, PAThe pilot's failure to maintain proper altitude and object clearance which resulted in a collision with power lines.Dec 8, 1991 · N30832 · Destroyed NTSB NYC83FA041Accident · 1 fatalField investigationFinal reportCessna 177B · Starrucca, PADuring a weather briefing before takeoff, the student pilot was advised of icing conditions, turbulence, snowshowers and snow squalls along ridges north of the wilkes-barre/scranton, PA area. The weather briefer indicated that VFR flight was not recommended.…Dec 12, 1982 · N34595 · Destroyed NTSB NYC81FGM22Accident · No injuriesClosedCessna 177B · West Mifflin, PAJul 2, 1981 · N35241 · Substantial damage NTSB NYC80FHD24Accident · Serious injuriesClosedCessna 177B · Ambler, PAAug 16, 1980 · N34280 · Destroyed NTSB NYC77FGT06Accident · No injuriesClosedCessna 177B · Mifflintown, PADec 18, 1976 · N34328 · Substantial damage NTSB NYC73FHA73Accident · Minor injuriesClosedCessna 177B · Pottstown, PAApr 29, 1973 · N34231 · 2 aircraft · Substantial damage