NTSB investigations: Cessna 177B, VA
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
| 1974 | 2 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1986 | 1 |
| 2002 | 1 |
| 2013 | 1 |
| 2022 | 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\" = 'VA' 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" = 'VA' 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 ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…NTSB ERA13LA258Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Herndon, VAThe pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.NTSB BFO86FA044Accident · 1 fatalField investigationFinal reportCessna 177B · Springfield, VAAccording to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally…NTSB IAD78FIA01Accident · Minor injuriesClosedCessna 177 · Nokesville, VANTSB IAD76DID35Accident · No injuriesClosedCessna 177 · Danville, VANTSB IAD75DIJ09Accident · No injuriesClosedCessna 177B · Volney, VANTSB IAD74FIA15Accident · Minor injuriesClosedCessna 177B · Winchester, VA