Cessna 172C
NTSB investigations · 219
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072408')
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072408')
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 MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB MKC90LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ames, IAThe wrong runway was selected and directional control was not maintained by the pilot in command.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB ATL89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Franklin, GAImproper planning/decision by the pilot by attempting to takeoff from an unsuitable field and his delay in aborting the takeoff. The terrain conditions and fence were contributing factors.NTSB BFO88LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · New Cumberland, WVThe plt said that during the landing roll the brakes did not operate despite his continued application of pressure on the pedals. As the acft neared the rwy end he tried to swerve the acft left toward a runup pad. However, at the same time the r brake…NTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…NTSB SEA87LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Burns, ORA loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil…NTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…NTSB SEA87LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Eatonville, WAThe student plt was on approach to home field after a x-c flight. During final, the pilot elected to go-around due to gusty winds and a downdraft. The acft stalled into trees along side the runway. Investigation revealed the flaps were set at 40 degrees and…NTSB LAX87LA021Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Michigan Bar, CADuring a pleasure cross-country flight, the aircraft experienced an enging failure. Examination of the fuel tanks revealed that both tanks were empty of fuel. The carburetor was removed from the engine and found to contain approximately 1 tablespoon of fuel.…NTSB CHI86LA217Accident · No injuriesLimited investigationFinal reportCessna 172C · Bement, ILOn touchdown the aircraft was not properly aligned with the rwy. While rolling out the left wing caught the full grown corn on the left edge of the rwy and pulled the aircraft into the corn.NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB FTW85LA334Accident · No injuriesLimited investigationFinal reportCessna 172B · Ada, OKThe student plt, who had been executing touch and go landings, stated that the acft bounced on touchdown and began porpoising. The student over-corrected and the acft subsequently impacted the runway in a nose low attitude damaging the prop, nose gear and the…NTSB CHI85LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · East Alton, ILThe acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the…NTSB MIA85LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Big Pine Key, FLThe plt stated that while in cruise flt at about 1200 ft & 2300 RPM the eng lost pwr & the acft was ditched aprx 100 yards off shore in the ocean waters. The acft was found to have sufficient fuel in both tanks. The fuel selector was on, the fuel screen was…NTSB MIA85LA033Accident · No injuriesLimited investigationFinal reportCessna 172C · Titusville, FLAccording to the plt, after he was unsuccessful in starting the acft eng he switched off the magnetos and master switch and exited the acft. Later, during the process of moving the propeller to a position to clear a hand toe bar, the acft started, taxied…NTSB LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…NTSB ATL83LA356Accident · No injuriesLimited investigationFinal reportCessna 172C · Portsmouth Isl., NCBefore hauling passengers, the plt elected to make a flt to survey the area & to practice a landing on Portsmouth island. He estimated that the wind at Portsmouth was from the north at 15 to 20 KTS. Also, he said that the arpt was oriented toward the…NTSB LAX83LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Rubidoux, CAThe acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.NTSB LAX82DA220Accident · No injuriesFinal reportCessna 172 · Lancaster, CADuring flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot…NTSB CHI82FA160Accident · 1 fatalField investigationFinal reportCessna 172C · Sunburg, MNThe pilot received several weather briefings and was advised of a severe cold front and thunderstorms in an area on his route. Prior to takeoff, he was advised that VFR flight was not recommended. While en route, the pilot reported that he was "totally…NTSB NYC81FGT03Accident · Minor injuriesClosedCessna 172 · Palmyra, PANTSB ANC81DAD03Accident · No injuriesClosedCessna 172C · Luck Lake, AKNTSB LAX80DVG75Accident · Minor injuriesClosedCessna 172C · Mount Shasta, CANTSB FTW80DRJ44Accident · No injuriesClosedCessna 172C · Rocky Branch, LANTSB MKC80DCA10Accident · No injuriesClosedCessna 172 · Festus, MONTSB NYC79FHA18Accident · No injuriesClosedCessna 172 · Germansville, PANTSB NYC79FHM18Accident · No injuriesClosedCessna 172 · Matawan, NJNTSB CHI79DEP05Accident · Minor injuriesClosedCessna 172 · Shawano, WINTSB DEN79FA004Accident · 1 fatalClosedCessna 172 · Provo, UTNTSB IAD78FA100Accident · No injuriesClosedCessna 172C · Creedmoor, NCNTSB IAD77FLJ34Accident · Minor injuriesClosedCessna 172 · Beaufort, NCNTSB IAD77FIG27Accident · Minor injuriesClosedCessna 172C · Stevensville, MDNTSB SEA77FYE27Accident · Minor injuriesClosedCessna 172 · Olga, WANTSB NYC77DFJ25Accident · No injuriesClosedCessna 172C · Syracuse, NYNTSB MKC77PTK12Accident · Minor injuriesClosedCessna 172 · Chamberlain, SDNTSB NYC77FNA06Accident · No injuriesClosedCessna 172C · Warwick, RINTSB IAD77DKM02Accident · No injuriesClosedCessna 172 · Bryson City, NCNTSB CHI77DEC09Incident · No injuriesClosedCessna 172 · Detroit, MINTSB MIA76FKG98Accident · Serious injuriesClosedCessna 172 · Shannon, GANTSB MKC76FCD39Accident · No injuriesClosedCessna 172C · Orchard, IANTSB MKC76DCQ33Accident · No injuriesClosedCessna 172 · Maize, KSNTSB SEA76DTA12Accident · No injuriesClosedCessna 172 · Malta, MTNTSB DEN76FTC21Accident · No injuriesClosedCessna 172C · Casper, WYNTSB IAD76FIJ09Accident · Serious injuriesClosedCessna 172C · Lansing, WVNTSB FTW76FRG03Accident · Serious injuriesClosedCessna 172 · Austin, TXNTSB ANC75DAG91Accident · No injuriesClosedCessna 172 · Anchorage, AKNTSB NYC75FNC20Accident · Minor injuriesClosedCessna 172C · West Dover, VTNTSB NYC75FNA22Accident · Serious injuriesClosedCessna 172C · Norwood, MA
Back to Cessna 172C