Cessna 172B
NTSB investigations · 258
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 ('2072406')
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 ('2072406')
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 FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.NTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.NTSB CHI94LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Shiocton, WIthe pilot's failure to maintain Vso during takeoff. Factors related to the accident was the disregard for performance data and trees.NTSB ATL93LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Statesville, NCThe improper use of carburetor heat by the pilot. A factor in the accident was the carburetor icing conditions.NTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.NTSB SEA92FA114Accident · 1 fatalField investigationFinal reportCessna 172B · Eatonville, WAUndetermined.NTSB FTW92LA088Accident · No injuriesLimited investigationFinal reportCessna 172B · Scottsville, TXPilots' inadequate compensation for unfavorable windshift. A facator was the unfavorable wind.NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.NTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.NTSB LAX91LA353Accident · No injuriesLimited investigationFinal reportCessna 172B · King City, CAThe total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.NTSB DEN91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172B · La Junta, COThe pilot's failure to maintain adequate airspeed and the resultant inadvertent stall. The pilot's failure to raise the flaps was a factor in the accident.NTSB ATL90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Midway, TNTotal failure of the number four exhaust valve, resulting in engine power loss and the subsequent forced landing of the airplane.NTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.NTSB FTW90LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXFailure to maintain directional control.NTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.NTSB MKC89LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Unionville, IAThe failure of the engine due to carburetor ice. Contributing factors included carburetor icing conditions, improper use of the carburetor heat control by the pilot, and the improperly rigged carburetor air box which resulted in reduced carburetor heating…NTSB FTW89LA027Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Plano, TXFuel exhaustion which resulted from the pilot's inadequate fuel consumption calculations and his failure to utilize numerous suitable sources of fuel along his route of flight.NTSB CHI89LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Columbus, OHStudent pilot's failure to maintain control of the airplane during landing flare.NTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…NTSB ATL87LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Belton, SCThe pilot reported that while on short final he experienced a downdraft which caused him to land hard. The aircraft bounced and went off the left side of the sod strip. The pilot lost control of the aircraft after it bounced. The pilot estimated that surface…NTSB MIA86LA167Accident · No injuriesLimited investigationFinal reportCessna 172 · Windermere, FLAfter leveling off at an alt of aprx 1000 ft the eng of the float plane failed for undetermined causes. The plt selected a small lake on which to land and a glide was established. The plt stated that he lowered the flaps too soon & the left wing struck trees.…NTSB DEN86LA140Accident · No injuriesLimited investigationFinal reportCessna 172B · Alamosa, COThe student plt had soloed that morning. After a short rest period he flew with his instructor. He then flew a second solo flt. The student plt made two landings. On the third approach the plt made a go-around. On the next approach the acft stalled close to…NTSB FTW86FA027Accident · 2 fatalField investigationFinal reportCessna 172B · Caddo Mills, TXMid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was…NTSB SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…NTSB MIA85LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawtey, FLThe acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was…NTSB SEA85LA143Accident · No injuriesLimited investigationFinal reportCessna 172B · Imbler, ORDuring takeoff from a field (off arpt), the acft failed to clear a fence. The pilot then attempted to abort the takeoff, but the acft hit a bale of hay & nosed over. The plt's last medical certificate was dated 9/2/82.NTSB MIA85FLD01Accident · Serious injuriesFinal reportCessna 172B · Brooksville, FLAccording to a plt statement, he entered the traffic pattern at about 800 ft & held 70 mph with 10 deg of flaps & the carb heat on. After turning onto final apch, he advanced the throttle for a power adjustment, but the eng did not respond. Subsequently, the…NTSB SEA85FA082Accident · 3 fatalField investigationFinal reportCessna 172B · Smith, NVAccording to witnesses, the plt made multiple passes over his residence at low alt. The witnesses observed the acft in various maneuvers at low alt. One maneuver was described as a pull-up from about 100 ft to aprx 600 ft, where the acft went into a wingover…NTSB FTW85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Coushatta, LAThe acft was on its 1st flt following maintenance for a previous nose gear shimmy problem. When the student made his 1st attempt to land, he noticed that the nose gear seemed to be cocked, so he aborted the landing. On the 2nd attempt, the acft swerved to the…NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB FTW83LA203Accident · No injuriesLimited investigationFinal reportCessna 172B · Spearman, TXThe acft swerved off the right side of the rwy and collided with a ditch. The acft nose gear collapsed during the sequence. The landing was on rwy 20 and during the approach the plt noticed that the wind was out of the south and that the wind sock was…NTSB ANC83LA006Accident · No injuriesLimited investigationFinal reportCessna 172 · Near Homer, AKThe pilot decided to land on a gravel bar. He made a touch-and-go, then returned for a full stop landing. During the landing, he decided there was insufficient room to stop. He applied full power to initiate a go-around and saw a log in the takeoff path. The…NTSB LAX82FUQ11Accident · No injuriesFinal reportCessna 172 · Lancaster, CAAt 1530 PST, the pilot received a weather briefing from the Lancaster fss. At that time, the wind was variable, 230 to 250 degrees, at 20 KTS. The pilot reported the wind was variable from the same direction at 22 to 26 KTS, while taxiing to runway 24. The…NTSB SEA81DYE38Accident · No injuriesClosedCessna 172A · Port Townsend, WANTSB ANC81FA062Accident · No injuriesClosedCessna 172 · Napaskiak, AKNTSB MIA81FA073Accident · 1 fatalClosedCessna 182 · La Belle, FLNTSB MIA81FKJ06Accident · No injuriesClosedCessna 172 · Defuniak Spgs, FLNTSB MIA80FA095Accident · 2 fatalClosedCessna 172 · Wabasso, FLNTSB MKC79DCD39Accident · No injuriesClosedCessna 172B · Council Bluffs, IANTSB MIA79FLD42Accident · 1 fatalClosedCessna 172B · Orlando, FLNTSB SEA79DTA05Accident · No injuriesClosedCessna 172B · Circle, MTNTSB SEA79DYA02Accident · Minor injuriesClosedCessna 172B · St.Anthony, IDNTSB SEA78DYP53Accident · No injuriesClosedCessna 172 · Ephrata, WANTSB MIA78DKJ69Accident · No injuriesClosedCessna 172B · Hanover, ALNTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNNTSB MKC78FA026Accident · 2 fatalClosedCessna 172 · Memphis, MONTSB CHI78FEV06Accident · Serious injuriesClosedCessna 172 · Fairfield, ILNTSB SEA77DYE35Accident · No injuriesClosedCessna 172 · Ilwaco, WANTSB NYC77FHA24Accident · No injuriesClosedCessna 172B · Vernon, NJNTSB MKC77FTG05Accident · Serious injuriesClosedCessna 172 · Stanton, ND
Back to Cessna 172B