NTSB investigations: Cessna 152, IL
93 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.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
AND 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 CHI86LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILThe starter would not engage, so the plt tied down the tail & hand propped the acft to start the eng, but did not use chocks. After the eng started, the acft rolled forward, slipped loose from the rear tie-down & ran into a pile of i-beams. A post acdnt exam…NTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…NTSB CHI86LA048Accident · No injuriesLimited investigationFinal reportCessna 152 II · Aurora, ILDuring initial climbout the student plt saw his IAS drop 10 KTS. He aborted the takeoff and land hard on the nose gear. Gear collapsed.NTSB CHI86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILThe student pilot was practicing touch and go landings in preparation for a solo cross country. The pilot was compensating for a crosswind when he landed the aircraft on its nose resulting in substantial damage to the aircraft.NTSB CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…NTSB CHI85LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Alton, ILWhile on a solo training flt, the student plt flew from centralia to Alton, IL, & entered the traffic pattern to land onrwy 11. The wind was reported from 170 deg at 12 KTS gusting to 20 KTS. During the apch, the acft was blown to the left side of the rwy…NTSB CHI84FA402Accident · Serious injuriesField investigationFinal reportCessna 152 · Wheeling, ILWitnesses stated that the acft began to climb before it banked to the left and entered a nose down attitude. The student pilot's instructor stated that he was aware that the flt was to have taken place that evening but he did not discuss with the student…NTSB CHI84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Taylorville, ILThe acft collided with a snowbank and nosed over during landing. The student plt said a nose wheel shimmy developed during landing roll and he was unable to keep the acft on the 6O ft wide rwy.NTSB CHI83LA416Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankfort, ILThe plt stated that he touched down with a slight angle to the rwy and went off to the left side into the grass. He misjudged the distance to the trees and the left wing contacted a tree.NTSB CHI84LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILThe student plt stated that when approaching over wires she 'powered up and ended up coming in too fast.' The acft made initial contact on the nose wheel. Subst damage to the eng mount area and the left wing.NTSB CHI83LA303Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe acft was damaged in a forced landing after a power loss during takeoff. This was a dual instructional flt. The CFI stated that the engine lost power at about 100 ft AGL & he made a forced landing straight ahead. The fixed base operatorstated that…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB CHI83LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILThe student plt was on a round robin, cross-country training flt. His first landing was made on rwy 4 at the greater Kankakee arpt. During touchdown in a strong cross-wind, the acft bounced, then veered off the rwy. The acft then encountered soft terrain and…NTSB CHI83LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILThe student pilot made a hard landing on his first solo flight. The aircraft bounced several times and damaged the nose landing gear. The student had made four full stop landings with an instructor pilot. Then the instructor deplaned for the student to make…NTSB CHI83LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Ridott, ILThis was the pilot's first operation on the 1320 ft strip. After touchdown, he encountered poor braking action and attempted to go around. When he realized he had insufficient runway remaining, he aborted the go-around. Subsequently, the aircraft collided…NTSB CHI83LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student pilot with his instructor on board were performing touch and go landings. After the third takeoff the engine quit at approximately 150 ft AGL. The pilot made an emergency landing between the two runways at Rockford. Examination of the engine…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.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 CHI81FEE34Accident · No injuriesClosedCessna 152 · West Chicago, ILNTSB CHI81DEV12Accident · No injuriesClosedCessna 152 · Urbana, ILNTSB CHI81FEE26Accident · Serious injuriesClosedCessna 152 · Hoffman Est, ILNTSB CHI81FEE09Accident · No injuriesClosedCessna 152 · Crystal Lake, ILNTSB CHI81DEV05Accident · No injuriesClosedCessna 152 · St Francisvill, ILNTSB CHI81FCA03Accident · No injuriesClosedCessna 152 · Cahokia, ILNTSB CHI80DEE52Accident · No injuriesClosedCessna 152 · Lockport, ILNTSB CHI80FEE50Accident · No injuriesClosedCessna 152 · Aurora, ILNTSB CHI80DEE27Accident · No injuriesClosedCessna 152 · Wheeling, ILNTSB CHI80DEE26Accident · No injuriesClosedCessna 152 · Lockport, ILNTSB CHI79DEE80Accident · No injuriesClosedCessna 152 · Dwight, ILNTSB CHI79FEV19Accident · No injuriesClosedCessna 152 · Gillespie, ILNTSB CHI79FEE31Accident · Minor injuriesClosedCessna 152 · Geneva, ILNTSB CHI79DEV05Accident · No injuriesClosedCessna 152 · Peoria, ILNTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILNTSB CHI78FEE54Accident · No injuriesClosedCessna 152 · Wheeling, ILNTSB CHI78FEE46Accident · No injuriesClosedCessna 152 · Chicago, ILNTSB CHI78FEE36Accident · No injuriesClosedCessna 152 · Belvidere, ILNTSB CHI78FEV23Accident · No injuriesClosedCessna 152 · Monmouth, ILNTSB CHI78DEV21Accident · No injuriesClosedCessna 152 · Peoria, ILNTSB CHI78DEV13Accident · No injuriesClosedCessna 152 · Mt Vernon, IL