Cessna 172K
NTSB investigations · 691
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 ('2072430')
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 ('2072430')
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 CHI83LA240Accident · No injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNThe acft veered off the rwy during landing. The landing was on rwy 07. The wind was from 360 degrees at 15 KTS. A thunderstorm was in the area and some turbulence remained. The pilot stated he felt one good bump at 50 AGL and from that point to touchdown very…NTSB DEN83LA061Accident · No injuriesLimited investigationFinal reportCessna 172K · Dove Creek, COThe acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…NTSB CHI83LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenburg, INThe pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…NTSB MIA83LA040Accident · No injuriesLimited investigationFinal reportCessna 172J · Lowell, FLWhile attempting a go-around maneuver, the aircraft tail struck treetops that were located at the departure end of runway 18. The pilot landed the aircraft safely and discovered damage to the right horizontal stabilizer and the fuselage.NTSB MKC83FA025Accident · 3 fatalField investigationFinal reportCessna 172K · Oxford, NEThe pilot made 3 low passes near his son's home. Reportedly, the 3rd pass was made at an altitude of about 40 to 50 ft AGL. A witness then observed the pilot pull up abruptly to about a 45 deg climb. After climbing an additional 40 to 50 ft, the aircraft…NTSB NYC82DA225Accident · No injuriesFinal reportCessna 172K · Vinalhaven, METhe engine lost power at 100 feet of altitude after takeoff. The pilot found by pumping the throttle, he could regain some power. The aircraft collided with trees and came to rest on the ground. The mixture control cable had separated about one inch from it…NTSB LAX82DA292Accident · Minor injuriesFinal reportCessna 172K · Hanapepe, HIJust prior to touchdown a strong gust of wind caused the acft to drift right of the rwy centerline. During the go-aroundthe left wing struck the ground causing the acft to cartwheel.NTSB ANC82DAG38Accident · Minor injuriesFinal reportCessna 172K · 44mi Nw Mccarth, AKShortly after liftoff from a short gravel strip the aircraft settled back onto the rough terrain and crashed.NTSB ANC82DA054Accident · Minor injuriesFinal reportCessna 172K · Kasilof, AKThe pilot made a landing approach over trees at the approach end of the runway. The runway sloped slightly downhill in the direction of landing. The pilot landed long, then elected to go around, and during the go-around, the left wing struck a tree.NTSB LAX82FA170Accident · Minor injuriesField investigationFinal reportCessna 172K · Huntington Beac, CAThe pilot reported that while he was on final approach to runway 19, he applied full flaps near the airport boundary and the aircraft veered to the right. He said that the aircraft did not respond to aileron control inputs. The aircraft continued to the…NTSB LAX82FA167Accident · 2 fatalField investigationFinal reportCessna 172 · Morman Lake, AZThe acft departed winslow, AZ on a flt to long beach, CA with an en route stop scheduled for prescot, AZ. Before departing winslow, the plt was warned by another plt that he had encountered extreme turbulence in the vicinity of mormon mtn. The plt and pax's…NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…NTSB LAX82FA078Accident · 4 fatalField investigationFinal reportCessna 172K · Hollister, CAThe aircraft flew into the side of a mountain in level cruise. The accident happened during weather in which VFR flight had not been recommended. Clouds were obscuring the mountains. The aircraft was on the return leg of a cross-country flight. No flight plan…NTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…NTSB LAX82FUA08Accident · Minor injuriesClosedCessna 172K · Laguna Beach, CANTSB CHI82FEM04Accident · Serious injuriesClosedCessna 172 · Kinross, MINTSB SEA82DYM01Accident · No injuriesClosedCessna 172 · Long Creek, ORNTSB FTW82DRG06Accident · Minor injuriesClosedCessna 172 · Blanco, TXNTSB MIA82DKA02Accident · Serious injuriesClosedCessna 172 · Ponce, PRNTSB FTW82FPM02Accident · No injuriesClosedCessna 172 · Broken Arrow, OKNTSB CHI81DEM34Accident · No injuriesClosedCessna 172K · Mackinac Is, MINTSB ATL81FLJ09Accident · Serious injuriesClosedCessna 172K · Conetoe, NCNTSB LAX81FUG27Accident · Minor injuriesClosedCessna 172 · Hesperia, CANTSB FTW81DPG19Accident · No injuriesClosedCessna 172 · Bay, ARNTSB LAX81DUJ53Accident · No injuriesClosedCessna 172 · Phoenix, AZNTSB MKC81DCD10Accident · No injuriesClosedCessna 172 · Spencer, IANTSB ATL81DKJ06Accident · No injuriesClosedCessna 172 · Dothan, ALNTSB LAX81DUQ03Accident · Minor injuriesClosedCessna 172K · Inyokern, CANTSB DEN81DTK02Accident · No injuriesClosedCessna 172 · Faith, SDNTSB MIA80DLD88Accident · No injuriesClosedCessna 172K · Chiefland, FLNTSB DEN80FTE68Accident · Minor injuriesClosedCessna 172K · Aspen, CONTSB MKC80FCG28Accident · Minor injuriesClosedCessna 172K · Warrensburg, MONTSB CHI80DEP24Accident · No injuriesClosedCessna 172K · Waunakee, WINTSB CHI80FEX11Accident · Minor injuriesClosedCessna 172 · Mooresville, INNTSB FTW80DQD06Accident · No injuriesClosedCessna 172 · Dell City, TXNTSB SEA80DYE28Accident · Minor injuriesClosedCessna 172 · Concrete, WANTSB CHI80DEP21Accident · No injuriesClosedCessna 172 · Wilmot, WINTSB NYC80FA060Accident · 2 fatalClosedCessna 172 · Rockland, MENTSB LAX80DUG21Accident · No injuriesClosedCessna 172K · Blythe, CANTSB NYC80DNA05Accident · No injuriesClosedCessna 172K · Bedford, MANTSB FTW80DRA10Accident · No injuriesClosedCessna 172K · Arcola, TXNTSB FTW80FPJ04Accident · No injuriesClosedCessna 172K · Norman, OKNTSB CHI80FEM01Accident · Minor injuriesClosedCessna 172K · Byron Center, MINTSB SEA79FTI26Accident · No injuriesClosedCessna 172K · Three Forks, MTNTSB CHI79DEG23Accident · Minor injuriesClosedCessna 172 · Troy, OHNTSB SEA79FYP40Accident · No injuriesClosedCessna 172K · Deer Park, WANTSB ANC79DAG82Accident · Minor injuriesClosedCessna 172 · Purkeypile, AKNTSB OAK79FVD34Accident · No injuriesClosedCessna 172K · Livermore, CANTSB CHI79FEI29Accident · No injuriesClosedCessna 172K · Youngstown, OHNTSB OAK79FXQ18Accident · No injuriesClosedCessna 172K · Reno, NV
Back to Cessna 172K