NTSB investigations: Cessna 172G
14 cases on aircraft the registry lists as Cessna 172G, 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 1999 | 1 |
| 2005 | 1 |
Where
Latest 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 ('2072420')
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 ('2072420')
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 ATL05CA147Accident · Minor injuriesData collectionFinal reportCessna 172G · Ridgeland, SCThe loss of engine power for undertermined reasons which resulted in a collision with objects.NTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.NTSB FTW96LA204Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Okmulgee, OKThe pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.NTSB FTW96LA115Accident · No injuriesLimited investigationFinal reportCessna 172G · Gunnison, COLoss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB FTW93LA198Accident · No injuriesLimited investigationFinal reportCessna 172G · Fort Worth, TXThe power loss for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the inadvertent stall.NTSB MIA92LA061Accident · 1 fatalLimited investigationFinal reportCessna 172G · Atlantic Ocean (Atlantic Ocean)Loss of engine power due to undetermined reasons.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB ANC90LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKWater (or ice) contamination of the aircraft's fuel, and an inadequate preflight by the pilot. A factor related to the accident was: snow covered terrain in the emergency landing area.NTSB NYC90LA037Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Uxbridge, MAIce in the fuel strainer, which restricted fuel flow & resulted in fuel starvation, and the pilot inadvertently stalled the airplane, when he abruptly maneuvered it to avoid a transmission wire during a forced landing.NTSB ATL87LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fayetteville, NCDuring approach the pilot noticed that he was too high and fast for a normal approach. He reduced power and slowed the aircraft and increased the descent rate to attempt the landing. When he attempted to add power and arrest the increasing descent rate the…NTSB MIA86LA089Accident · No injuriesLimited investigationFinal reportCessna 172G · New Smyrna, FLThe flt had been cruising on the right fuel tank. During the descent, carb heat and rich mixture was selected. The eng quit and the plt selected both fuel tanks. Eng pwr was restored briefly during the descent, but not enough to sustain flt. A forced landing…NTSB CHI85FA316Accident · 1 fatalField investigationFinal reportCessna 172G · Plain City, OHThe plt had just taken off from his pvt strip for the fourth flt of the day when witnesses heard the eng quit. The acft had been flown 3.4 hrs since the last refueling. The acft was being operated on a mixture of avgas and automotive fuel with no STC. The…NTSB NYC84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Forrestport, NYThe acft stalled into trees near the edge of a lake and tumbled into the water after the engine quit due to fuel exhaustion at 2000 ft AGL aprx 2 miles from the lake. The plt said he should have used a dip-stick to measure the fuel in the tanks before takeoff…NTSB ATL82FKM04Accident · Serious injuriesFinal reportCessna 172G · Worthville, NCDuring arrival, the pilot entered a left downwind for runway 11 and proceeded to make a low pass over the strip to chase off cows. At approximately midfield, he initiated a climb and according to the passenger, when power was applied, the engine did not…