OpenAirDocs.org

NTSB investigations: Cessna 172L

18 cases on aircraft the registry lists as Cessna 172L, where the first occurrence was “Loss of control - in flight”. 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

19862026

Where

Open the map

Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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.

NTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.Jul 1, 2006 · N7943G · Substantial damageNTSB NYC05CA107Accident · No injuriesData collectionFinal reportCessna 172L · Tangier, VAThe pilot's failure to maintain directional control during landing.Jun 26, 2005 · N19681 · Substantial damageNTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.Jun 7, 2005 · N7668G · Substantial damageNTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.Sep 6, 2003 · N7632G · DestroyedNTSB LAX03FA109Accident · 2 fatalField investigationFinal reportCessna 172L · Rosamond, CAthe pilot's failure to maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall and impact with flat level terrain. Also causal was the pilot's impaired judgment due to recent use of cocaine, and ethanol.Mar 7, 2003 · N19770 · DestroyedNTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…Dec 9, 2001 · N4303Q · Substantial damageNTSB DEN99LA085Accident · No injuriesLimited investigationFinal reportCessna 172L · Gunnison, COThe pilot's inadvertent stall/mush immediately after takeoff. Factors were the high density altitude weather condition, and the pilot's total lack of experience in type of operation.May 25, 1999 · N172KB · Substantial damageNTSB SEA97LA185Accident · No injuriesLimited investigationFinal reportCessna 172L · Townsend, MTThe pilot's failure to maintain airspeed.Aug 9, 1997 · N7925G · Substantial damageNTSB BFO95LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Bethel, MEthe flight instructor's failure to ensure adequate control of the airplane during a go-around. The gusty wind conditions were contributing factors.Nov 22, 1994 · N19735 · Substantial damageNTSB BFO94LA138Accident · No injuriesLimited investigationFinal reportCessna 172L · Springfield, OHThe pilot's premature liftoff, failure to attain adequate airspeed, and improper level off.Aug 12, 1994 · N19644 · Substantial damageNTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.Nov 14, 1992 · N9854G · Substantial damageNTSB SEA92FA109Accident · 1 fatalField investigationFinal reportCessna 172L · Colburn, IDThe pilot became lost/disoriented, failed to maintain airspeed when he attempted to reverse course in a box canyon, and the aircraft stalled. Factors relating to the accident were the narrow box canyon, the high density altitude, and the lack of mountain…May 24, 1992 · N3988Q · DestroyedNTSB FTW91LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Mount Ida, ARThe pilot in command's failure to compensate for the adverse wind conditions which resulted in a loss of control on touchdown. A factor was the gusty crosswind.Nov 24, 1990 · N4275Q · Substantial damageNTSB NYC90LA209Accident · 1 fatalLimited investigationFinal reportCessna 172L · Montauk, NYPilot failed to attain airspeed during a go around, resulting in the airplane stalling at a low altitude. Contributing factor was the pilot's attention was diverted to airport maintenance personnel working near the approach end of the runway.Sep 1, 1990 · N4324Q · DestroyedNTSB CHI90LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Graceton, MNVso airspeed not maintained and stall encountered by the pilot in command/cfi.Jul 19, 1990 · N7895G · Substantial damageNTSB MKC88LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cameron, MOThe student pilot said he was practicing short field takeoffs from his pasture, when he stalled shortly after takeoff. The aircraft fell uncontrolled to the terrain causing substantial damage to the wings, fuselage and nose gear.Sep 25, 1988 · N2866Q · Substantial damageNTSB SEA88LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Leavenworth, WAOn initial climb over trees bordering 2500-FT mountain strip, plt experienced sudden and severe wind gusts beyond his capability to counter. Acft collided with trees and terrain.Sep 5, 1988 · N2811Q · Substantial damageNTSB ATL86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Charlotte, NCDuring the attempted takeoff the acft skipped, climbed a few feet, settled to the ground then climbed again before the plt attempted to abort the takeoff. The acft overran the end of the rwy, crossed a road and hit a ditch and nosed over. An estimated weight…Apr 8, 1986 · N2851Q · Destroyed