NTSB investigations: Cessna 175
14 cases on aircraft the registry lists as Cessna 175, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 3 |
| 1988 | 3 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 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\" = 351))
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" = 351))
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 DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.NTSB ATL99LA023Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Locust Grove, GALoss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.NTSB FTW98LA039Accident · No injuriesLimited investigationFinal reportCessna 175 · Arnaudville, LAa cracked fuel line, which allowed air to enter the line and lead to fuel starvation and loss of engine power. A related factor was: the lack of suitable terrain for a forced landing.NTSB NYC95LA066Accident · No injuriesLimited investigationFinal reportCessna 175 · Quantico, VAthe failure of a connecting rod, which resulted in the total loss of engine power. Subsequently, the airplane was ditched.NTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB ANC92LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Wasilla, AKFailure of the engine crankshaft due to an oil passage hole being blocked. Contributing to the accident was the unsuitable terrain.NTSB MIA89LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Starke, FLFlt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…NTSB LAX89LA054Accident · No injuriesLimited investigationFinal reportCessna 175 · Tracy, CAThe airplane was found nosed over and abandoned short of the airport. The owner of the airplane was identified as the pilot, however, he does not hold a pilots license nor a medical certificate. Inspection of the airplane revealed that the fuel tanks were…NTSB LAX88LA283Accident · No injuriesLimited investigationFinal reportCessna 175 · Needles, CAWhile at cruise flight, the pilot noticed that the oil pressure was low and shutdown the engine. During the emergency landing, the prop freewheeled, vibrated severely, and smoke filled the cockpit. The acft landed on a pipeline right of way causing…NTSB LAX87LA271Accident · No injuriesLimited investigationFinal reportCessna 175 · Jackson, CAJust after takeoff the engine began missing then quit at an altitude of aprx 200 ft AGL. The plt attempted to return and land at the airport but was unable to reach the runway. Inspection of the engine revealed that the number 5 cylinderbarrel was cracked at…NTSB MKC87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Tipton, MOThe pilot stated that, fifteen minutes into the flight, while at cruise the engine oil pressure began dropping as the oil temperature rose. While attempting to reach sedalia, Missouri to perform a precautionary landing, oil began covering the aircraft's…NTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…NTSB DEN84LA112Accident · No injuriesLimited investigationFinal reportCessna 175 · Ogden, UTAfter takeoff, the eng began to smoke & lose power. During a forced landing in a muddy plowed field, the acft nosed over. A compression check was accomplished & the #5 cylinder was found to have zero compression. The cylinder was removed & found to be cracked…NTSB DEN82DA199Accident · No injuriesFinal reportCessna 175 · Hulett, WYThe pilot reported that during flight the engine began to run rough. He diverted toward a nearby airstrip, but while en route, there was a "bang" and smoke began entering the cabin. At that point, he shut off the fuel, magnetos and master switch, then lost…