Cessna 152
NTSB investigations · 2,749
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 ('2071835')
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 ('2071835')
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 ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.NTSB LAX92FA202Accident · 1 fatalField investigationFinal reportCessna 152 · Pinyon Pines, CAThe pilot's failure to maintain adequate altitude while maneuvering in mountainous terrain which resulted in getting trapped in a box canyon, resulting in a stall due to inadequate airspeed. Factors which contributed to the accident were: the pilot's decision…NTSB CHI92LA131Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Branson, MOInadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.NTSB CHI92LA131Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Branson, MOInadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.NTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…NTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.NTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.NTSB NYC92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHThe failure of the pilot to maintain directional control during a touch and go which resulted in the airplane departing the runway and striking a ditch. Factors related to the accident were the improper use of the flight controls by the pilot and his lack of…NTSB LAX92LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Yucca Valley, CAWas the loss of engine power for undetermined reasons. A factor in the accident was the mountainous and rough nature of the terrain.NTSB NYC92LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Coatsville, PAThe failure of the student pilot to compensate for adverse winds during landing, which resulted in a loss of airspeed and subsequent stall and loss of control. A factor related to the accident was the student pilot's lack of total flight experience.NTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.NTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.NTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.NTSB ATL92LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's failure to maintain directional control of the airplane during the landing roll. Factor(s) in this accident were: the crosswind conditions prevailing at the airport, and the soft, muddy terrain conditions adjacent to the runway.NTSB LAX92LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Show Low, AZThe total loss of engine power due to undetermined reason(s). A factor in this accident was the soft soil the airplane encountered during landing roll which caused the airplane to nose over.NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.NTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.NTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.NTSB ANC92LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe failure of the pilot to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident were the partial loss of engine power for undetermined reasons, the icy runway condition, and the pilot's lack of total…NTSB DEN92LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Falcon, COEngine failure over unsuitable terrain due to fuel exhaustion. Factors were: pilot inexperience and becoming lost and disoriented.NTSB SEA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTDirectional control was not maintained. A factor to the accident was: the pilot's lack of total flight experience.NTSB CHI92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Alpha, ILInadequate preflight planning and refueling not performed by the pilot.NTSB CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…NTSB LAX92FA067Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAThe failure of the pilot to maintain adequate altitude above the ground to recover from an inadvertent stall. Contributing to the accident was the pilot's handling of the aircraft specifically an excessive angle of attack which resulted in reduced airspeed…NTSB MIA92FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Naples, FLThe pilot-in-command's incapacitation due to an undetermined cardiovascular event which resulted in an uncontrolled descent into the ground.NTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.NTSB MIA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe pilot-in-command's improper use of the rudder controls and brakes. A contributing factor was his lack of total experience.NTSB SEA92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe loss of control on takeoff by the pilot due to the improper flap setting, the premature liftoff and his failure to attain proper climb airspeed after takeoff.NTSB LAX92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe cfi's inadequate supervision and his delayed remedial action. A factor was carburetor icing conditions.NTSB ANC92LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Beluga, AKAn exhaust valve failure. Contributing to the accident was the rough, uneven terrain, and trees.NTSB LAX92LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Reedley, CAThe student pilot's improper use of the flight controls and his failure to maintain directional control of the aircraft. A contributing factor in the accident was the students lack of total experience.NTSB MIA92LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper flare & failure to recover from a ballooned landing.NTSB MIA92FA017Accident · Serious injuriesField investigationFinal reportCessna 152 · Valkaria, FLThe pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented and an in-flight collision with terrain. Contributing to the accident was the pilot's decision to operate the airplane with known…NTSB LAX92LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Willits, CAThe pilot's poor in-flight decision to continue his flight in deteriorating weather, and his misjudged weather evaluation.NTSB CHI92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 II · Lee'S Summit, MOThe student pilot's failure to maintain directional control. Related factors are the student's lack of total experience, improper touch and go procedures, and diverted attention.NTSB MIA92FA012Accident · 1 fatalField investigationFinal reportCessna 152 · Green Cove Spgs, FLThe pilot in command's failure to maintain a visual lookout.NTSB LAX92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot's improper landing flare which resulted in a hard landing and the buckling of the airplane's nose gear.NTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.NTSB LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.NTSB NYC91LA251Accident · Minor injuriesLimited investigationFinal reportCessna C-152 II · Blue Bell, PAThe pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…NTSB CHI91LA295Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, INFailure of the pilot to maintain directional control during the takeoff ground run from a touch-and-go landing.NTSB BFO91LA083Accident · No injuriesLimited investigationFinal reportCessna 152U · Burnt Chimney, VAImproper planning/decision by the pilot. The uphill runway and obstructions (trees) near the departure end of the runway were related factors.NTSB DEN91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKPower loss due to fuel exhaustion and the pilot's failure to refuel. A factor was: the rough uneven terrain.NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.
Back to Cessna 152