NTSB investigations: Cessna 177, NE
13 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 | 3 |
|---|---|
| 1969 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1992 | 1 |
| 2003 | 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\" = 'NE' 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" = 'NE' 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 CHI03LA226Accident · No injuriesLimited investigationFinal reportCessna 177 · Murdock, NEThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.NTSB CHI92LA229Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenwood, NEThe private pilot's poor in-flight planning and decision making.NTSB MKC82FCJ03Accident · Serious injuriesFinal reportCessna 177 · Near Qgallala, NEThe pilot reported that during the preflight, there was about 4 inches of fuel in one tank and about 3 inches in the other tank. However, he did not remember the accident or what happended for about a week thereafter. Witnesses reported that the engine quit…NTSB MKC78FCJ08Accident · 3 fatalClosedCessna 177 · Hayes Center, NENTSB MKC73DCJ06Accident · No injuriesClosedCessna 177 · Papillion, NENTSB MKC72FCJ24Accident · No injuriesClosedCessna 177 · Omaha, NENTSB MKC71DCJ74Accident · No injuriesClosedCessna 177 · Fremont, NENTSB MKC70F0227Accident · No injuriesClosedCessna 177 · Gibbon, NENTSB MKC69F0371Accident · Minor injuriesClosedCessna 177 · Trenton, NENTSB MKC69F0343Accident · No injuriesClosedCessna 177 · Scribner, NENTSB MKC69D0209Accident · No injuriesClosedCessna 177 · Milford, NENTSB MKC69F0023Accident · No injuriesClosedCessna 177 · Omaha, NENTSB MKC68D0579Accident · No injuriesClosedCessna 177 · Columbus, NE