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 ANC99LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKThe loss of control due to wake turbulence, and the issuance of an improper takeoff clearance by air traffic control personnel. A factor associated with the accident was air traffic control personnel's failure to issue a safety advisory.NTSB CHI99LA282Accident · No injuriesLimited investigationFinal reportCessna 152 · Superior, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the gusty wind condition, the student's lack of experience, and the soft terrain encountered.NTSB CHI99LA249Accident · No injuriesLimited investigationFinal reportCessna 152 · Berrien Springs, MIFailure to obtain a proper climb rate and the delayed remedial action by the certified flight instructor. Contributing factors were the uphill terrain and trees.NTSB FTW99LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Frisco, TXThe pilot's failure to maintain directional control of the airplane during the simulated soft field takeoff.NTSB NYC99LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Stow, OHWas the failure of the flight instructor to recognize the high sink rate and apply corrective action in a timely manner.NTSB MIA99LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Chapel Hill, NCThe failure of the pilot to maintain airspeed resulting in the airplane stalling and entering a spin. Contributing to the accident was the pilot's impairment by marijuana.NTSB SEA99FA176Accident · 2 fatalField investigationFinal reportCessna 152 · Coeur d'Alene, IDThe flight crew's failure to maintain adequate airspeed, resulting in a stall and uncontrolled collision with terrain. A factor was mountainous/hilly terrain.NTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.NTSB FTW99LA144Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot's delayed landing flare and her subsequent improper recovery technique following the bounced landing.NTSB FTW99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe flight instructor's inadequate supervision resulting in an inadvertent stall/spin by the student pilot.NTSB LAX99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.NTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 152 · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.NTSB NYC99LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, NJThe pilot in command's improper preflight preparation, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB IAD99LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairfield, NJwas the pilot's inadequate compensation for winds and his improper recovery from a bounced landing.NTSB CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.NTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.NTSB CHI99LA116Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's misjudged flare and inadvertent stall during landing. A factor was the pilot's inadequate remedial action.NTSB ATL99LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bunn Level, NCThe loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.NTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.NTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…NTSB MIA99LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot's failure to maintain directional control during the landing roll. A related factor was the pilot's diverted attention.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB MIA99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, NCThe student pilots failure to maintain directional control during an attempted touch and go landing. This resulted in the airplane veering off the left side of the runway, and subsequent on-ground collision with a ditch and nosed over inverted..NTSB CHI99LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Odessa, MOthe total loss of engine power for reasons undetermined. Factors were total loss of engine power, the instructor pilot's encounter with unsuitable terrain, and the rough terrain.NTSB CHI99LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elmo, MNthe student pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the snow covered, icy runway condition and the snowbank which the airplane contacted.NTSB LAX99LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe CFI's loss of airplane control upon encountering a dust devil due to his improper in-flight decision to land in proximity to the observed adverse weather conditions.NTSB CHI99LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILthe pilot's failure to maintain proper runway alignment during the landing flare. A factor related to the accident was the snowbank which the airplane contacted.NTSB FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.NTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILthe student pilot not maintaining the proper descent rate on final approach, and the certified flight instructor's delayed remedial action.NTSB CHI99LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Appleton, WIThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…NTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.NTSB IAD99LA022Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe failure of both the pilot-in-command (CFI) and dual student of the other aircraft (Pitts) to maintain adequate visual lookout.NTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.NTSB IAD99LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJthe student's pilot's inadequate climb and his failure to maintain adequate altitude and clearance. A related factor was the wind gusts.NTSB ATL99FA016Accident · 1 fatalField investigationFinal reportCessna 152 · Daytona Beach, FLAn interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.NTSB CHI99LA027Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Monticello, INlow altitude stall and an ostentatious display by the pilot. Factors associated with this accident were the performance of a low altitude maneuver and an abrupt pullup by the pilot.NTSB MIA99LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Coral Springs, FLThe delay by the pilot to obtain proper assistance after becoming lost/disoriented resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's lack of total experience.NTSB MIA99LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB SEA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAA partial loss of engine power due to carburetor ice formation. Factors included insufficient altitude/time available for remedial action, a tail wind during the forced landing attempt, and a fence at the end of the runway.NTSB LAX99LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Petaluma, CAFailure of the pilot in the Tiger Moth to see and avoid traffic. A contributing factor was the delayed reaction of the student pilot in the Cessna to initiate a turnoff of the taxiway once it became apparent that the other airplane did not see him.NTSB FTW99LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe student pilot's failure to maintain directional control of the airplane.NTSB MIA99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Douglasville, GAFailure of the no. 1 cylinder exhaust valve guide due to erosion, which resulted in separation of the exhaust valve head, loss of engine power, and collision with a power pole during a forced landing on unsuitable terrain.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
Back to Cessna 152