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 MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB LAX82DA064Accident · No injuriesFinal reportCessna 152 · Corona, CAFollowing a preflight inspection of the aircraft by the student pilot, the aircraft departed the Corona municipal airport on a dual training flight. Upon reaching an altitude of approximately 300 feet, the engine quit. The instructor landed the aircraft…NTSB MIA82DA040Accident · Minor injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot elected to land on runway 080 with winds from 170 degrees at 14 knots gusting to 25 knots. The aircraft ran off the side of the runway into soft sand where the nose wheel collapsed and the aircraft nosed over.NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…NTSB FTW82DA051Accident · No injuriesFinal reportCessna 152 · Mckinney, TXDuring local solo flight the aircraft veered off the left side of the runway resulting in substantial damage to the Cessna. The winds were gusting from 8 to 13 knots 35 degrees to the left of the runway heading.NTSB LAX82DA053Accident · No injuriesFinal reportCessna 152 · Lodi, CAThe pilot stated that during the landing roll he felt a vibration in the nose gear. Subsequently the aircraft veered offthe runway into soft ground and collapsed the nose gear.NTSB NYC82DA027Accident · No injuriesFinal reportCessna 152 · Ansonia, CTAfter departure from bridgeport on a local instructional flight, it was decided that a landing would be made at the Ansonia airport. The instructor reported that there was no NOTAM concerning hazardous runway conditions at Ansonia. During landing, the…NTSB MKC82DA021Accident · No injuriesFinal reportCessna 152 · Essex, MOThe student departed on a solo, cross-country flight. A comfort stop was made at an enroute airport during the first leg of the flight. The flight was then continued to the first pre-planned destination. After taking off on the second leg, the student became…NTSB FTW82DA044Accident · No injuriesFinal reportCessna 152 · Midland, TXDuring the student's first supervised solo flight he landed normally but lost control prior to adding power for a touch and go landing. The aircraft ran off the runway and collided with a pile of gravel coming to rest inverted.NTSB NYC82DA024Accident · No injuriesFinal reportCessna 152 · Enfield, NHWhile the student pilot was on a solo cross-country flight, the engine lost power and then ran intermittently. The power loss occurred while the plane was over a snow covered lake at 6500 ft MSL. The pilot elected to land on the lake. After touchdown, the…NTSB NYC82DA019Accident · No injuriesFinal reportCessna 152 · Cutchogue, NYAfter experiencing a partial loss of engine power in flight, the instructor took control of the aircraft. He applied carburetor heat, and headed back toward the airport. There was a gradual loss of power and the instructor elected to land in an open field.…NTSB ATL82DLG09Accident · No injuriesFinal reportCessna 152 · Grantiteville, SCThe pilot was unable to find the airport at his intended destination. He saw another airport and elected to land. A no-flap approach was made to rwy 24 with a north wind. The aircraft touched down about 500 feet from the departure end and then became airborne…NTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…NTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…NTSB FTW82FPA09Accident · Minor injuriesClosedCessna 152 · Scurry, TXNTSB DEN81DTA07Accident · Minor injuriesClosedCessna 152 · Big Timber, MTNTSB FTW82FRG19Accident · 1 fatalClosedCessna 152 · Christine, TXNTSB CHI82DEP14Accident · No injuriesClosedCessna 152 · Pewaukee, WINTSB ATL82FKJ08Accident · No injuriesClosedCessna 152 · Phenix City, ALNTSB CHI82DEC07Accident · No injuriesClosedCessna 152 · Howell, MINTSB LAX82FUJ14Accident · No injuriesClosedCessna 150 · Scottsdale, AZNTSB ATL82FLG05Accident · Minor injuriesClosedCessna 152 · Clemson, SCNTSB CHI82DEP11Accident · No injuriesClosedCessna 152 · Monroe, WINTSB NYC82DHA04Accident · No injuriesClosedCessna 152 · Manville, NJNTSB NYC82FHM02Accident · No injuriesClosedCessna 152 · Mahopac, NYNTSB ATL81FLG03Accident · No injuriesClosedCessna 152 · Hilton Head, SCNTSB NYC82FHJ02Accident · No injuriesClosedCessna 152 · Hudson River, NYNTSB LAX82DUJ11Accident · Minor injuriesClosedCessna 152 · Wikieup, AZNTSB SEA82DYM05Accident · No injuriesClosedCessna 152 · Sheridan, ORNTSB FTW82FRG10Accident · No injuriesClosedCessna 152 · Harlingen, TXNTSB FTW82FPD04Accident · No injuriesClosedCessna 152 · Roanoke, TXNTSB FTW82DRA08Accident · No injuriesClosedCessna 152 · College Sta, TXNTSB LAX82DVA07Accident · No injuriesClosedCessna 152 · Bakersfield, CANTSB NYC82DHD04Accident · No injuriesClosedCessna 152 · Toms River, NJNTSB LAX82FA011Accident · 1 fatalClosedCessna 152 · Avondale, AZNTSB NYC82FFJ02Accident · Serious injuriesClosedCessna 152 · Lockport, NYNTSB CHI82DEP06Accident · No injuriesClosedCessna 152 · Monroe, WINTSB NYC82FA003Accident · Serious injuriesClosedCessna 152 · Fishers Island, NYNTSB LAX82FA002Accident · 1 fatalClosedCessna 152 · Arvin, CANTSB NYC82FHM01Accident · Minor injuriesClosedCessna 152 · Blooming Grove, NYNTSB FTW82FA005Accident · 1 fatalClosedCessna 152 · Jayton, TXNTSB FTW82FQA03Accident · Minor injuriesClosedCessna 152 · Alamo, NMNTSB FTW82DPM04Accident · No injuriesClosedCessna 152 · Tulsa, OKNTSB FTW82DPA03Accident · No injuriesClosedCessna 152 · Mcgregor, TXNTSB ATL82FIG02Accident · No injuriesClosedCessna 152 · Frederick, MDNTSB CHI82FEK01Accident · No injuriesClosedCessna 152 · New Albany, OHNTSB MKC82DCG01Accident · No injuriesClosedCessna 152 · Point Lookout, MONTSB ATL81DIJ14Accident · No injuriesClosedCessna 152 · Smithville, WVNTSB LAX81FA133Accident · 1 fatalClosedCessna 152 · Carlsbad, CA
Back to Cessna 152