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 NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.NTSB ATL94LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Lebanon, TNThe student pilot's failure to follow the flight instructor's instructions to abort the takeoff after the airplane failed to develop takeoff power. The student pilot also delayed in relinquishing the flight control of the airplane to the flight instructor. A…NTSB ATL94FA062Accident · 1 fatalField investigationFinal reportCessna 152 · Allendale, SCThe pilot's failure to maintain a proper altitude while in the VFR traffic pattern, resulting in a collision with trees. Factors were; his failure to comply with school directives by not obtaining a weather briefing prior to the accident flight, and the rain,…NTSB LAX94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Angwin, CAthe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilots lack of total experience.NTSB CHI94LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, MOimproper use of carbureter heat and a poorly planned precautionary landing approach. Factors related to the accident were carburetor icing conditions, the pilot's lack of total experience, trees and anxiety/apprehension.NTSB MIA94LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe improper recovery from a bounced landing by the pilot-in- command.NTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…NTSB BFO94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Bath, OHloss of engine power for undetermined reasons. A factor in the accident was the frozen, snow covered terrain.NTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB MIA94LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Port St. Lucie, FLThe failure of the pilot-in-command to properly preflight the airplane and ensure there was adequate fuel on board, and his improper in-flight planning/decision to continue the flight.NTSB MIA94FA070Accident · 1 fatalField investigationFinal reportCessna 152 · Brooksville, FLThe pilot-in-command's failure to maintain a visual lookout and altitude while maneuvering after becoming lost/disoriented, resulting in an in-flight collision with trees and terrain. Contributing to the accident was the pilot's physical impairment due to…NTSB LAX94LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corona, CAa loss of engine power due to water contamination in the fuel, and the instructor's failure to perform an adequate preflight inspection.NTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.NTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.NTSB MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.NTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.NTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB CHI94LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · C0rnell, ILthe pilot-in-command's misjudgment of fuel supply. A factor was fuel exhaustion.NTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.NTSB NYC94LA031Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Millbrook, NYThe student pilot's failure to maintain direction control which resulted in an inflight collision with trees. Factors were the student pilot's improper recovery from a bounced landing and his inexperience.NTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.NTSB FTW94FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKWas the pilot-in-command continued VFR flight into IMC. A factor was fog.NTSB SEA94LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe student pilot failed to flare. His diverted attention was a factor.NTSB BFO94LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverhead, NYThe pilot's preflight planning/preparation was inadequate which resulted in a loss of engine power due to fuel exhaustion.NTSB BFO94FA005Accident · 2 fatalField investigationFinal reportCessna 152 · Walkersville, MDImproper planning/decision by the instructor pilot (CFI) by teaching stalls and slow flight to a pre-solo student on a dark night, and the instructor's failure to maintain (or regain) control of the airplane, due to spatial disorientation. Factor's related to…NTSB FTW94FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Van Horn, TXWas the pilot's attempt to perform aerobatics at low altitude and the inadvertent stall. A factor was the pilot's ostentatious display.NTSB FTW94LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · San Angelo, TXWas malfunction of the throttle control push/pull rod and cable. A factor was unsuitable terrain for the forced landing.NTSB MIA93FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 152 · FLundetermined.NTSB CHI93LA374Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot-in-command's failure to maintain airspeed. Factors were his lack of total experience and his premature retraction of the flaps.NTSB ATL93LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student pilot's inadequate compensation for wind conditions during the touch and go landing. Factors were the crosswind conditions, and the hidden obstruction (rock) in the grass adjacent to the runway.NTSB LAX93LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Hesperia, CAThe pilot in command not maintaining a proper glidepath. Factors pertaining to this accident were: the pilot in command not obtaining a weather forecast for the return flight, and the lack of total experieince in night flying.NTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.NTSB ANC93FA175Accident · 1 fatalField investigationFinal reportCessna 152 · Fairbanks, AKThe student pilot's failure to maintain control of the airplane due to spatial disorientation. Factors were the dark night and the inadequate surveillance of the operation by the club management.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB CHI93LA325Accident · No injuriesLimited investigationFinal reportCessna 152-II · Keokuk, IAthe loss of engine power due to an exhaust valve failure. A factor related to the accident is the power line.NTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.NTSB MIA93LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLFailure of the pilot-in-command to apply right rudder while applying power during the touch-and-go landing. Contributing to the accident was the pilot-in-command's lack of total experience.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.NTSB FTW93FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Houston, TXCompany management's dispatch of an airplane with known deficiencies, their failure to correct the deficiencies, and the student pilot's inadvertent entry into a stall. Factors which contributed to the accident were: chafed wiring, fouled spark plugs, a…NTSB DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.NTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.NTSB DEN93LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corpus Christi, TXAn inadvertent stall. A factor was the pilot's intentional buzzing at low altitude over the beach.NTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…NTSB LAX93LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oceano, CAThe student pilot's misjudging the landing flare altitude and his improper recovery from a bounced landing. Factors relating to this accident are the student pilot's lack of total experience and failure to raise the flaps.NTSB MIA93LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA reported partial loss of engine power for undetermined reasons, resulting in a forced landing and subsequent ditching in the ocean.
Back to Cessna 152