NTSB investigations: Cessna 177, MN
14 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 | 4 |
|---|---|
| 1969 | 4 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1985 | 1 |
| 1997 | 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\" = 'MN' 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" = 'MN' 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 CHI97LA269Accident · No injuriesLimited investigationFinal reportCessna 177 · Maple Lake, MNthe pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.NTSB CHI86LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Crookston, MNWhile doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.NTSB MKC80FER04Accident · No injuriesClosedCessna 177 · Wheaton, MNNTSB MKC79FA040Accident · 1 fatalClosedCessna 177 · Le Sueur, MNNTSB MKC78FER35Accident · Minor injuriesClosedCessna 177 · Lakeville, MNNTSB MKC76FER83Accident · Minor injuriesClosedCessna 177 · Minnetonka, MNNTSB MKC70F0231Accident · No injuriesClosedCessna 177 · Oklee, MNNTSB CHI70D0144Accident · Serious injuriesClosedCessna 177 · Spooner, MNNTSB MKC69D0455Accident · No injuriesClosedCessna 177 · Silver Lake, MNNTSB MKC69D0403Accident · No injuriesClosedCessna 177A · Lake Elmo, MNNTSB MKC69F0244Accident · Minor injuriesClosedCessna 177 · Whte Bear Lk, MNNTSB MKC69F0066Accident · No injuriesClosedCessna 177 · Minneapolis, MNNTSB MKC69D0059Accident · No injuriesClosedCessna 177 · Eden Prairie, MNNTSB MKC69D0048Accident · No injuriesClosedCessna 177 · Rushford, MN