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 FTW89LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Carmin, TXLoss of power for an unknown reason. Factors related to the accident were the ditch & fence.NTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.NTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.NTSB SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.NTSB BFO89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Selbyville, DEExcessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.NTSB MIA89LA227Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot's failure to follow the checklist and ensure that the elevator trim tab was adjusted properly for takeoff.NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB LAX89FA280Accident · 1 fatalField investigationFinal reportCessna 152 · Castaic, CAFailure of the instructor pilot to adequately supervise the conduct of the flight, failure of the instructor pilot to ensure adequate terrain clearance prior to initiating the maneuver, and failure of the instructor pilot to take timely and proper and proper…NTSB SEA89LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Mollala, ORPilot displayed poor judgement and did not adequately plan for the flight. The pilot was unfamiliar with the area and terrain conditions. As a result, the airplane was not able to attain sufficient altitude for the conditions to clear the terrain.NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB CHI89FA157Accident · 1 fatalField investigationFinal reportCessna 152 · York, SCFailure of the pilot to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: excessive workload (task overload) and diverted attention.NTSB LAX89LA258Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fremont, CAThe pilot's improper inflight decison to land on an unlighted runway during the hours of darkness. Darkness and the lack of runway lights were related factors.NTSB MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB DEN89FA177Accident · 1 fatalField investigationFinal reportCessna 152 · Logan, UTInadequate preflight and improper inflight planning/decision by the student, which resulted in fuel exhaustion from an inadequate supply of fuel, and the student's failure to maintain airspeed, while maneuvering, which resulted in an inadvertent stall/spin. A…NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB MIA89FA192Accident · No injuriesField investigationFinal reportCessna 152 · Miami Lakes, FLThe failure of the pilot to visually inspect the airplane fuel tanks during the preflight inspection to assure adequate fuel to conduct the flight was available.NTSB FTW89FA132Accident · 1 fatalField investigationFinal reportCessna 152 · Arlington, TXPoor judgement of the pilot, due to impairment from consumption of alcohol, and his failure to maintain proper altitude while maneuvering. Factors related to the accident were: darkness, the pilot's recent use of drugs, and his lack of flight experience.NTSB MIA89LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.NTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.NTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.NTSB MKC89LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOAircraft control was not maintained by the pilot in command due to improper use of the flight controls in flaring the aircraft for landing and counteracting the effects of the cross-wind on the drifting aircraft.NTSB NYC89LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Oneida, NYLoss of directional control during landing due to wind change. The aircraft landed hard on the runway due to improper flare by the pilot and a delayed response to the ballooning of the acft.NTSB LAX89FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Cordes, AZThe pilot misjudged his altitude, while maneuvering at low altitude over mountainous terrain. Factors related to the accident were: high density altitude, mountainous terrain, and diversion of the pilot's attention.NTSB FTW89FA117Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Worth, TXThe inadvertent stall of the airplane by the pilot. Factors contributing to the accident were the pilot's disregard of the weather advisory, the unfavorable windshift, and the thunderstorm outflow.NTSB FTW89LA116Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXImproper planning/decision by the solo student pilot and inadequate supervision by the student's instructor pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the instructor pilot's lack of…NTSB ATL89LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, TNThe separation of the mixture cable from the carburetor. Contributing factor(s) was: inadequate maintenance and inspection of the airplane and the soft terrain encountered during the forced landing.NTSB FTW89LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Kaufman, TXStudent pilot inadvertently becoming lost/disoriented and exhausting the fuel in the fuel system.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB LAX89LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Concord, CAStudent pilot had not attained compensation for the crosswind, and lost control of the airplane.NTSB MIA89FA154Accident · Minor injuriesField investigationFinal reportCessna 152 · Fort Pierce, FLFailure of the student pilot to maintain airspeed which resulted in an inadvertent stall. Contributing factors were: the weather conditions (smoke & haze), the student becoming lost, her lack of total experience, and her inability to understand ATC…NTSB MIA89LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco, FLFailure of the pilot to control the approach speed which resulted in a bounced landing. No recovery was made from the bounced landing, and the airplane was allowed to stall. The airplane then landed on the nose landing gear, which resulted in its overload…NTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.NTSB ATL89LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Hinckley, OHThe pilots failure to calculate proper fuel consumption for the flight which resulted in fuel exhaustion.NTSB MKC89FA107Accident · Serious injuriesField investigationFinal reportCessna 152 · Cottage Grove, MNPoor judgement of the pilot by flying while physically impaired from consumption of alcohol; and his failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and collision with wooded/hilly terrain.NTSB LAX89FA181Accident · 2 fatalField investigationFinal reportCessna 152 · Port San Luis, CAPilot failed to execute a 180 degree turn and inadvertently entered into instrument meteorological conditions.NTSB CHI89LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency…NTSB ATL89LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHPilot in command failed to maintain directional control of the aircraft while landing in a gusty crosswind. The crosswind component exceeded the published demonstrated crosswind capability of the airplane.NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.NTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.NTSB CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.NTSB BFO89LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing factors were the slight crosswind and the pilot's lack of experience.NTSB DEN89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student pilot's improper flare which resulted in a hard landing & separation of the nose landing wheel. Contributing to the accident was the pilot's lack of total experience.NTSB ANC89LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.NTSB FTW89LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXThe inadequate aircraft handling by the student pilot, where she allowed the airplane to start to porpoise, and then did not correct it.NTSB BFO89FA027Accident · 1 fatalField investigationFinal reportCessna 152 · West Chicago, ILImproper instruction by the student's flight instructor regarding the execution of s-turns on final approach to increase spacing and the retraction of flaps fully when executing a go-around and the failure of the student pilot to maintain adequate flying…NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB LAX89FA157Accident · Serious injuriesField investigationFinal reportCessna 152 · Chino, CAThe pilot's failure to obtain an appropriate weather briefing in preparation for the cross country flight and his failure to maintain an altitude sufficient to clear the terrain along the indended route after entering reduced visibility conditions.NTSB NYC89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bedford, MAImproper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…
Back to Cessna 152