NTSB investigations: Cessna 177B, NY
8 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
| 1972 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1984 | 2 |
| 2008 | 1 |
| 2016 | 1 |
| 2021 | 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\" = 'NY' 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" = 'NY' 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 ERA21FA178Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Great Valley, NYThe pilot’s failure to maintain control during takeoff.NTSB ERA16LA286Accident · Minor injuriesLimited investigationFinal reportCessna 177 · McDonough, NYThe pilot’s improper recovery from a slow flight configuration at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot’s decision to operate at low…NTSB NYC08CA312Accident · No injuriesData collectionFinal reportCessna 177 · Warwick, NYThe pilot's failure to obtain the proper touchdown point while landing.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 NYC84LA181Accident · No injuriesLimited investigationFinal reportCessna 177B · Spring Valley, NYSufficient alt was not obtained to clear trees located aprx 100 ft off the departure end of the rwy during an aborted landing to avoid an overrun.NTSB NYC79FHJ19Incident · No injuriesClosedCessna 177B · Amityville, NYNTSB NYC78FFA31Accident · Minor injuriesClosedCessna 177B · Lake Placid, NYNTSB NYC72FFA31Accident · No injuriesClosedCessna 177B · Manlius, NY