NTSB investigations: Cessna 175
21 cases on aircraft the registry lists as Cessna 175, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 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\" = 353))
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" = 353))
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 SEA03LA093Accident · No injuriesLimited investigationFinal reportCessna 175 · Middleton, IDThe pilot's failure to follow the checklist which led to fuel starvation and subsequent loss of engine power. A contributing factor was the uneven terrain at the landing site.NTSB LAX02LA174Accident · No injuriesLimited investigationFinal reportCessna 175 · Anaheim, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB MIA00LA031Accident · No injuriesLimited investigationFinal reportCessna 175-235 · Mint Hill, NCThe PIC's improper preflight fuel planning and preparation and the PIC's improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB SEA98LA176Accident · No injuriesLimited investigationFinal reportCessna 175 · Emmett, IDThe pilot's failure to ensure an adequate fuel supply for the flight, resulting in fuel exhaustion. A factor was a fence in the forced landing area.NTSB CHI98LA270Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sheboygan, WIThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB IAD98LA063Accident · No injuriesLimited investigationFinal reportCessna 175 · Pemberton, NJThe pilot's inadequate fuel consumption calculations and his improper in-flight decision to continue flying with an inadequate fuel supply.NTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.NTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…NTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.NTSB CHI95LA311Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Staples, MNthe pilot's delay in the application of carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent forced landing in a swampy area. The carburetor icing (weather) condition was a related factor.NTSB FTW95LA315Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Silvercliff, COFailure by the pilot to fuel the aircraft which resulted in fuel exhaustion. A factor was unsuitable terrain for a forced landing.NTSB CHI94LA236Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Cottage Hill, ILthe pilot inadequate preflight planning/preparation and his inaccurate fuel consumption calculations.NTSB CHI94LA160Accident · No injuriesLimited investigationFinal reportCessna 175 · Plainfield, ILfuel contamination (water), and inadequate aircraft preflight inspection.NTSB LAX94LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Palm Springs, CAfuel exhaustion due to the pilot's failure to adequately monitor the fuel consumption during the flight.NTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…NTSB CHI90DEK06Accident · No injuriesFinal reportCessna 175 · Zanesville, OHThe pilot's failure to properly prelfight the airplane which resulted in an inadequate fuel supply and subsequent fuel exhaustion.NTSB MKC89LA078Accident · No injuriesLimited investigationFinal reportCessna 175 · Murray, NEWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the ditch in the emergency landing area.NTSB FTW85LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Bastrop, LAPlt stated that on preflight a small amount of water was drained from each wing tank. Also, the main fuel strainer was drained and fuel tanks were topped off (17 gals added). At about 500 ft AGL on initial climb, the engine quit and restart attempts were…NTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…NTSB ATL83LA148Accident · No injuriesLimited investigationFinal reportCessna 175 · Tuscaloosa, ALThe aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn…NTSB FTW82DA225Accident · Minor injuriesFinal reportCessna 175 · Fort Worth, TXDuring a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard.