NTSB investigations: Cessna 175
12 cases on aircraft the registry lists as Cessna 175, where the first occurrence was “Loss of engine power”. 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
| 1986 | 2 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072502')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 ATL05CA063Accident · Minor injuriesData collectionFinal reportCessna 175 · Charlotte, NCThe pilot's failure to follow the checklist by his failure to verify the fuel selector was in the on position which resulted in fuel starvation and the loss of engine power.NTSB CHI04LA028Accident · No injuriesLimited investigationFinal reportCessna 175 · Mears, MILoss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.NTSB CHI03LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Grand Island, NEThe loss of engine power due to fuel contamination and the pilot's inadequate preflight inspection.NTSB ANC01LA120Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Kenai, AKThe total loss of engine power during takeoff for an undetermined reason.NTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.NTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94LA080Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Paris, ARFailure by the pilot in command to have annual maintenance inspections performed on the aircraft.NTSB MIA92LA125Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Yulee, FLLoss of engine power due to undetermined reasons shortly after takeoff.NTSB ATL89LA208Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Spruce Pine, NCA loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).NTSB SEA88LA105Accident · No injuriesLimited investigationFinal reportCessna 175 · Olympia, WAAfter reducing power in order to land onto the runway a total loss of power occurred. The aircraft was landed short of the ruwnay and during landing roll a ditch was struck collapsing the right main and nose gear. Aircraft inspection revealed 2 2/3 gallons of…NTSB CHI86LA211Accident · No injuriesLimited investigationFinal reportCessna 175 · Muskegon, MIJust prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched…NTSB LAX86LA281Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Atwater, CAA Cessna 175 collided with a tree after a total loss of power during a VFR x-country flt. The plt indicated he experienced an eng failure at 2,000 ft MSL, while on descent, aprx 15 mi from his dest. He reported that the eng began to vibrate slightly. The…