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 NYC08FA054Accident · 2 fatalField investigationFinal reportCessna 152 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW08CA028Accident · No injuriesData collectionFinal reportCessna 152 · Ardmore, OKThe pilot's improper landing flare which resulted in a hard landing.NTSB LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.NTSB MIA08LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYThe failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.NTSB NYC08CA017Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, METhe pilot's failure to maintain adequate clearance from trees during the approach.NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB NYC07CA169Accident · No injuriesData collectionFinal reportCessna 152 · Vero Beach, FLThe student pilot's failure to maintain directional control during landing, resulting in a runway excursion and subsequent nose over.NTSB LAX07LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tracy, CAThe pilot's improper recovery from a bounced landing and his failure to maintain directional control during the landing roll. Contributing to the accident were the operator's inadequate engine maintenance, which precipitated the loss of engine power, the…NTSB ATL07CA094Accident · No injuriesData collectionFinal reportCessna C152 · Miami, FLThe pilot's loss of consciousness while on final approach to land, resulting in an uncontrolled descent, and a hard landing on the runway.NTSB LAX07LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAA loss of engine power during cruise due to carburetor icing, and the pilot's delay in using carburetor heat.NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe single-engine pilot's failure to avoid the jet blast while taxiing and the ground controller's inattentiveness to the situation, which resulted in the airplane's being blown over.NTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB ATL07CA070Accident · No injuriesData collectionFinal reportCessna 152 · Hinesville, GAThe pilots improper preflight planning with resulted in a loss of engine power due to fuel exhaustion.NTSB LAX07CA076Accident · No injuriesData collectionFinal reportCessna 152 · Aptos, CAthe student pilot's becoming lost and disoriented that resulted in an improper in-flight decision to make a precautionary landing in an unsuitable open field.NTSB DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07CA058Accident · No injuriesData collectionFinal reportCessna 152 · McAlester, OKThe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose landing gear.NTSB LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.NTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.NTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.NTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.NTSB NYC07CA013Accident · No injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's inadequate flare, which resulted in a nosegear collapse during landing.NTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.NTSB DEN06CA134Accident · No injuriesData collectionFinal reportCessna 152 · Bennett, COThe pilot's failure to maintain control of the airplane during the aborted takeoff. Factors contributing to the accident were the low airspeed and the pilot's improper in-flight planning.NTSB SEA06CA186Accident · No injuriesData collectionFinal reportCessna 152 · Pembroke Pine, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the runway sign.NTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.NTSB LAX06LA230Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAa loss of engine power due to the failure of maintenance personnel to tighten the top spark plugs, and install the leads for the ignition harness to the top spark plugs.NTSB LAX06CA209Accident · No injuriesData collectionFinal reportCessna 152 · Concord, CAthe student pilot's unstabilized approach, misjudged landing flare, inadequate recovery from a bounced landing, and failure to maintain directional control. A contributing factor to the accident was the in-flight distraction.NTSB LAX06FA200Accident · 2 fatalField investigationFinal reportCessna 152 · Peoria, AZthe failure of both the flight instructor and student pilot to regain control of the airplane in a timely manner during an intentional spin maneuver, resulting in a collision with terrain. A factor in the accident was the instructor's inadequate supervision…NTSB SEA06CA099Accident · Minor injuriesData collectionFinal reportCessna 152 · Klamath Falls, ORThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Soft terrain was a contributing factor.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB NYC06CA109Accident · Serious injuriesData collectionFinal reportCessna 152 · Shamokin, PAThe pilot's failure to recover from a bounced landing, and her improper use of flaps during an aborted landing, which resulted in an in-flight collision with trees.NTSB LAX06CA143Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAthe failure of the student and certified flight instructor to maintain directional control and obtain/maintain an adequate airspeed during the attempted go-around. The flight instructor's inadequate supervision of the flight was also causal.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.NTSB SEA06LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Kelso, WAEncounter with carburetor icing conditions while maneuvering for the downwind which resulted in a loss of engine power due to carburetor ice. The aircraft nosing over during the landing roll in soft sand was a factor.NTSB LAX06CA079Accident · No injuriesData collectionFinal reportCessna 152 · Rancho Murieta, CAfuel contamination (water) due to the inadequate preflight by both pilots, which failed to detect the residual water contamination in fuel system. A factor in the accident was the soft terrain condition at the forced landing site.NTSB CHI06CA052Accident · No injuriesData collectionFinal reportCessna 152 · Pelican Lake, WIThe pilot selecting an unsuitable landing area. Factors were the snow and ice covered lake.NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB MIA06CA012Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLThe student pilot's inadequate recovery from a bounced landing resulting in substantial damage to the airplane.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.
Back to Cessna 152