NTSB investigations: Cessna R172K, CA
20 cases on aircraft the registry lists as Cessna R172K. 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
| 1979 | 1 |
|---|---|
| 1981 | 3 |
| 1983 | 2 |
| 1984 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2016 | 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.\"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 ('2072431'))
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 ('2072431'))
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 WPR17CA001Accident · No injuriesData collectionFinal reportCessna R172K · Rosamond, CAThe pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.NTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.NTSB LAX08LA187Accident · No injuriesLimited investigationFinal reportCessna R172K · Big Bear City, CAThe pilot's failure to attain and maintain an adequate airspeed that led to a stall/mush. Contributing to the accident was the lack of suitable terrain for an off airport landing and a high density altitude.NTSB LAX04CA219Accident · No injuriesData collectionFinal reportCessna R172K · Hawthorne, CAthe pilot's misjudged flare and failure to maintain adequate airspeed, resulting in a stall and hard landing. Factors in the accident were the night conditions and the pilot's lack of familiarity in the make and model of airplane.NTSB LAX01LA256Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Mammoth Lakes, CAThe pilot's inadequate in-flight planning and his failure to maintain sufficient altitude above the terrain. Factors were the high terrain and the blind canyon.NTSB LAX97FA225Accident · 2 fatalField investigationFinal reportCessna R172K · Moreno Valley, CAThe pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…NTSB LAX96LA247Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Oroville, CAundetermined.NTSB LAX93LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Fresno, CAthe improper installation of an electrical wire bundle, and, the chaffing and subsequent arcing of the wires against a fuel line which resulted in a fire.NTSB LAX91LA227Accident · No injuriesLimited investigationFinal reportCessna R172K · Santa Clarita, CAFuel exhaustion due to the failure of the pilot to properly perform preflight planning and to ensure that an adequate fuel supply existed for the flight.NTSB LAX90LA271Accident · 1 fatalLimited investigationFinal reportCessna R172K · Lone Pine, CAThe pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.NTSB LAX88LA259Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Corona, CADuring takeoff the engine failed to develop full power & the acft collided with trees located approx 500 ft beyond the runway. Exam of the engine revealed the mixture control arm at its fuel pump housing attachment point had restricted movement & was…NTSB SEA86FA053Accident · 1 fatalField investigationFinal reportCessna 172XP · Napa, CABefore taking off, the plt appeared to have difficulty following taxi instructions. He then took off without clearance against crossing traffic. When he returned to land, he was cleared for rgt traffic to rwy 18. The acft entered a left downwind for rwy 24…NTSB LAX85LA018Accident · No injuriesLimited investigationFinal reportCessna R172 · Corning, CAThe plt reported that during a landing on rwy 34, the acft encountered a x-wind gust & was pushed off the rwy. It subsequently collided with a ditch & was damaged. The plt reported that the wind was from 300 deg at 16 gusting 22 KTS.NTSB LAX84FA473Accident · 3 fatalField investigationFinal reportCessna R172K · Independence, CAThe plt and two pax departed on a pleasure flt to look for a deer hunting area. Witnesses near the accident site stated that the saw the acft 'fly down the canyon on a northerly heading, reverse course and attempt to fly up the canyon.' They saw the acft…NTSB LAX83LA225Accident · No injuriesLimited investigationFinal reportCessna R172K · Huntington Bch, CAAfter returning from a sight-seeing flt to catalina island, the plt made an apch to rwy 19. The apch was high, so he went around. He landed on the 2nd apch, but the acft bounced, so he went around again. On the 3rd apch, he used 30 deg of flaps & had an…NTSB LAX83LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · San Martin, CAThe acft made a hard landing short of the runway while practicing an approach with a simulated engine failure. On turning final, the instructor decided the acft was too low to make the runway. She estimated they would be several hundred feet short. She took…NTSB LAX81DVG63Accident · No injuriesClosedCessna R172K · Chiles Valley, CANTSB LAX81DXQ27Accident · No injuriesClosedCessna R172K · So Lake Tahoe, CANTSB LAX81FUG40Accident · No injuriesClosedCessna R172K · Yucca Valley, CANTSB LAX79DVM11Accident · No injuriesClosedCessna R172H · Sn Luis Obspo, CA