Cessna 172I
NTSB investigations · 235
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 ('2072426')
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 ('2072426')
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 MIA92LA176Accident · No injuriesLimited investigationFinal reportCessna 172I · Navarre, FLFailure of the pilot-in-command to maintain directional control after touchdown during the forced landing following partial loss of engine power during cruise flight. Contributing to the accident was the divertion of attention of the pilot in command to the…NTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.NTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.NTSB ATL92LA077Accident · No injuriesLimited investigationFinal reportCessna 172I · Knightdale, NCThe pilot's inadequate compensation for crosswind conditions, and his failure to maintain aircraft control. A factor was the crosswind conditions at the airport.NTSB ATL92LA051Accident · No injuriesLimited investigationFinal reportCessna 172I · Bainbridge, GAThe pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.NTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.NTSB ANC92LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Ekuk, AKThe pilot's improper in flight planning and decision in that he attempted to touchdown too close to the log.NTSB ATL91LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Clanton, ALFailure of the pilot to maintain control of the aircraft during a go-around. The pilot's lack of experience was a related factor.NTSB FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB DEN90LA084Accident · No injuriesLimited investigationFinal reportCessna 172I · Isabel, SDPilot's inadequate compensation for the wind conditions.NTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.NTSB BFO89LA018Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Fort Washington, MDThe passenger failed to maintain adequate clearance from the propeller as she attempted to board the aircraft. Both the pilot failure to supervise the boarding of the passenger and the night light conditions are contributing factors to the accident.NTSB ANC89FA022Accident · No injuriesField investigationFinal reportCessna 172I · Chugiak, AKThe pilot lost control, skidded off the left side of the wet icy runway, and nosed over in a snowbank during the landing phase of an attempted touch and go landing. He stated that while on downwind, he saw the wind sock indicate a change of wind direction,…NTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.NTSB NYC88LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Newport, VTDuring landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over.NTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…NTSB MKC88LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Sweet Springs, MODuring a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…NTSB ATL87LA206Accident · No injuriesLimited investigationFinal reportCessna 172I · Goodway, ALThe plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch…NTSB FTW87LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Baton Rouge, LAThe plt rprtd that after taking off to practice touch & go lndgs, the eng lost pwr. He atmtd to make a forced lndg on the arpt, but was unable. While lndg short of the rwy, the acft hit the top of a tree & the arpt security fence. Maintenance had just been…NTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…NTSB MIA87FA188Accident · 1 fatalField investigationFinal reportCessna 172I · Ellisville, MSBfr the flt, the arpt owner adzd the plt not to fly, since he (the plt) appeared to be intoxicated. The plt 'said ok & left,' but returned aprx 1 hr later. A witness rprtd the plt atmtd to takeoff with full flaps. Drg the takeoff roll, theacft drifted off the…NTSB DEN87LA128Accident · No injuriesLimited investigationFinal reportCessna 172I · Taos, NMThe private plt and his CFI rated pax were practicing touch and go landings at the local arpt. During landing a wind gust pushed the acft off the runway centerline to the right. The runway shoulder was soft, a go-around attempt was unsuccessful and the acft…NTSB MIA87LA085Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Pelahatchie, MSThe plt stated that he was practicing emerg power-off landings, when, on final apch, realized he wouldn't clear the trees located west of the rwy. He then cleared them by adding power thought the acft then descended in a flare attitude until contact with the…NTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.NTSB ATL86FLT03Accident · Minor injuriesFinal reportCessna 172I · Millington, TNThe acft collaped the nose lndg bear during a forced lndg after the engine failed during takeoff. During post ace eng exam the wires disconnected from the magneto switch. The wires were resting on the 'p' leads. The fastening screw found on the bottom of the…NTSB MKC85LA222Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Cameron, MOThe pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to…NTSB NYC85FFA01Accident · Serious injuriesFinal reportCessna 172I · Essex, NYWitnesses stated acft became airborne near the slight rise in the rwy, aprx 1500 ft down the rwy, and climbed to aprx 60 ft AGL. Acft shuttered and nose of acft pitched up. Left wing and nose then dropped. Acft continued descending to the left across a small…NTSB NYC84LA196Accident · No injuriesLimited investigationFinal reportCessna 172 · Orleans, MAShortly after level off the pilot stated that the engine began to run roughly. All emergency procedures were followed and a precautionary landing was made on the beach. As the acft touched down and rolled out, the nose wheel dug into the sand and the aircraft…NTSB CHI83LA435Accident · No injuriesLimited investigationFinal reportCessna 172 · Plymouth, MIThe plt reported that during an apch to land on rwy 18, he encountered heavy turbulence & elected to go around. He reported the wind was from 180 deg at 15, gusting 25 KTS. On the 2nd apch, turbulence was encountered again. The acft was fast & began to float…NTSB MIA83LA229Accident · 1 fatalLimited investigationFinal reportCessna 172I · Miami, FLThe acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…NTSB FTW83LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Forrest City, ARThe acft experienced power failure from about 20 feet AGL during takeoff from a private grass strip. A witness heard theengine spit and pop during the takeoff roll. He said it sounded just like his old pickup when it runs out of gas. After the accident the…NTSB MKC83FA087Accident · No injuriesField investigationFinal reportCessna 172 I · Paola, KSThe acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson…NTSB ATL83LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, GAThe aircraft collided with a parked van while taxiing from landing at mccollum airport,Marietta,GA. The acft was being demonstrated to a prospective buyer who was in the left front seat with the owner in the right seat. After a flight fromatlanta,GA they…NTSB LAX82DA131Accident · No injuriesFinal reportCessna 172 · Holbrook, AZThe student pilot was on his first solo flight. During the first touchdown, the aircraft bounced to the right. The student reported that after bouncing, the airspeed deteriorated as the aircraft floated and settled to the right. The aircraft struck sagebrush…NTSB MKC82FA011Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB CHI81FEV33Accident · No injuriesClosedCessna 172I · Danville, ILNTSB CHI81FEP30Accident · Minor injuriesClosedCessna 172I · Oconomowoc, WINTSB CHI81DEE27Accident · No injuriesClosedCessna 172 · Rock Falls, ILNTSB FTW80DPG68Accident · No injuriesClosedCessna 172I · Marianna, ARNTSB MIA80FKJ15Accident · No injuriesClosedCessna 172I · Foley, ALNTSB DEN79FTE37Accident · No injuriesClosedCessna 172 · Akron, CONTSB CHI79FEX31Accident · Minor injuriesClosedCessna 172 · Martinsville, INNTSB MIA79DLA09Accident · No injuriesClosedCessna 172 · Live Oak, FLNTSB LAX79FUQ06Accident · Minor injuriesClosedCessna 172I · Santa Barbara, CANTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNTSB DEN78DTE57Accident · No injuriesClosedCessna 172I · Ft Morgan, CONTSB MIA78DLD42Accident · Minor injuriesClosedCessna 172 · Avon Park, FLNTSB MKC77FCG53Accident · Minor injuriesClosedCessna 172I · Lebanon, MONTSB ANC77FAG81Accident · No injuriesClosedCessna 172 · Eagle River, AKNTSB MKC77FCA24Accident · Minor injuriesClosedCessna 172 · South Argyle, MO
Back to Cessna 172I