NTSB investigations: Cessna 177A, CA
8 cases on aircraft the registry lists as Cessna 177A. 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
| 1969 | 1 |
|---|---|
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2026 | 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\" = 'CA' 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 ('2073706'))
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" = 'CA' 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 ('2073706'))
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 WPR27LA019Accident · Serious injuriesClass 3 · LimitedInvestigation openCessna 177A · San Jose, CANTSB LAX99LA314Accident · No injuriesLimited investigationFinal reportCessna 177A · Big Bear City, CAA loss of engine power due to fuel system contamination, which resulted from the mechanic's failure to fully inspect and verify the serviceability of the fuel system before returning the aircraft to service for a maintenance ferry flight. The pilot's decision…NTSB LAX91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Dana Point, CAThe pilot's improper fuel consumption calculations.NTSB LAX76DUM12Accident · Minor injuriesClosedCessna 177 · San Diego, CANTSB LAX75FVM14Accident · Minor injuriesClosedCessna 177 · Paso Robles, CANTSB OAK73DVM31Accident · No injuriesClosedCessna 177A · Watsonville, CANTSB OAK72FVA25Accident · Serious injuriesClosedCessna 177A · Fresno, CANTSB LAX69A0059Accident · 2 fatalClosedCessna 177A · Corona, CA