NTSB investigations: Cessna 175A, CA
16 cases on aircraft the registry lists as Cessna 175A. 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
| 1964 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1989 | 1 |
| 2008 | 2 |
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 ('2072504'))
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 ('2072504'))
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 LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.NTSB LAX08LA118Accident · Serious injuriesLimited investigationFinal reportCessna C175A · Groveland, CAA total loss of engine power due to fuel starvation as a result of a blocked fuel line that was improperly fabricated by the pilot. Also causal was the pilot's excessive ground speed during the taxi tests that resulted in an inadvertent takeoff.NTSB LAX89LA196Accident · No injuriesLimited investigationFinal reportCessna 175A · Mojave, CAInadequate preflight planning/preparation, and the pilot's disregard of the wind information.NTSB OAK76DVG36Accident · No injuriesClosedCessna 175A · Fair Oaks, CANTSB LAX73FUM30Accident · No injuriesClosedCessna 175A · Holtville, CANTSB LAX73DUG29Accident · No injuriesClosedCessna 175A · Yucca Vally, CANTSB LAX72DUG10Accident · No injuriesClosedCessna 175A · Yucca Vally, CANTSB LAX71FUG01Accident · No injuriesClosedCessna 175A · Joshua Tree, CANTSB OAK69F0025Accident · No injuriesClosedCessna 175A · Napa, CANTSB LAX68F0173Accident · Minor injuriesClosedCessna 175A · Quartz Hill, CANTSB LAX66D0315Accident · No injuriesClosedCessna 175 · Goldstone Lke, CANTSB LAX66A0013Accident · 1 fatalClosedCessna 175A · Shoshone, CANTSB OAK66D0110Accident · No injuriesClosedCessna 175 · Eureka, CANTSB LAX65D0006Accident · Minor injuriesClosedCessna 175 · Brawley, CANTSB UNK65X0739Accident · No injuriesClosedCessna 175A · Santa Rosa, CANTSB UNK64X0374Accident · No injuriesClosedCessna 175 · Santa Rosa, CA