NTSB investigations: Cessna 177, KY
16 cases on aircraft the registry lists as Cessna 177. 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
| 1968 | 1 |
|---|---|
| 1969 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'KY' 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 ('2073704'))
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" = 'KY' 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 ('2073704'))
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 NYC00LA024Accident · No injuriesLimited investigationFinal reportCessna 177 · Frankfort, KYA total loss of engine power for undetermined reasonsNTSB IAD97LA109Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Louisville, KYInadequate compensation for wind conditions by the pilot.NTSB NYC93LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Bowling Green, KYThe pilot's inadequate inflight planning and decision which resulted in fuel exhaustion and the loss of engine power.NTSB BFO92LA002Accident · No injuriesLimited investigationFinal reportCessna 177B · London, KYThe loss of engine power from fuel starvation due to inadequate inflight planning/decision by the pilot.NTSB ATL90LA122Accident · No injuriesLimited investigationFinal reportCessna 177 · Hazard, KYFailure of the pilot-in-command to execute a go-around, when an updraft caused the aircraft to be high on final.NTSB ATL88LA071Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Springfield, KYOne witness stated that the eng misfired during the takeoff roll, others stated that the acft was about 75 ft high when it lost power. There were several interruptions of power before it quit totally. The pilot attempted to return to the departure airfield.…NTSB ATL86LA252Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrodsburg, KYThe plt reported experiencing a loss of power at an alt of aprx 100 ft AGL shortly after takeoff. A forced landing was made into a small field during which the nose gear collapsed. Cause of the power loss was not determined.NTSB ATL85LA218Accident · No injuriesLimited investigationFinal reportCessna 177 · Stanton, KYThe pilot reported that during takeoff, he believed that the flight controls were not responding to control inputs. Moments after lift-off, he aborted the takeoff. The airplane continued off the departure end of the runway, where the nose gear and engine…NTSB IAD80DLQ13Accident · Serious injuriesClosedCessna 177 · Albany, KYNTSB IAD78FLQ15Accident · No injuriesClosedCessna 177 · Morehead, KYNTSB IAD76FLQ05Accident · Serious injuriesClosedCessna 177A · London, KYNTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYNTSB CHI73FLQ11Accident · Serious injuriesClosedCessna 177 · Lexington, KYNTSB CHI70D0277Accident · No injuriesClosedCessna 177 · Columbia, KYNTSB CHI70F0199Accident · Minor injuriesClosedCessna 177 · Shelbyville, KYNTSB CHI69A0002Accident · Minor injuriesClosedCessna 177 · Pikeville, KY