NTSB investigations: Cessna 152
2,738 cases on aircraft the registry lists as Cessna 152. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 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, CANTSB LAX81FUA14Accident · Minor injuriesClosedCessna 152 · Santa Ana, CANTSB MKC81DCQ51Accident · No injuriesClosedCessna 152 · Hays, KSNTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYNTSB FTW81FA143Accident · 1 fatalClosedCessna 152 · Fort Worth, TXNTSB LAX81FVD44Accident · Minor injuriesClosedCessna 152 · Richmond, CANTSB MKC81FCG56Accident · No injuriesClosedCessna 152 · Liberty, MONTSB FTW81DPD39Accident · No injuriesClosedCessna 152 · Wichita Falls, TXNTSB CHI81DA097Accident · 1 fatalClosedCessna 152 · Bemidji, MNNTSB NYC81FHA21Accident · Minor injuriesClosedCessna 152 · Sparta, NJNTSB MKC81DCA25Accident · No injuriesClosedCessna 152 · Rollo, MO