NTSB investigations: Cessna 152
32 cases on aircraft the registry lists as Cessna 152, where NTSB found Directional control. 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 per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 5 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 1 |
Where
Latest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '01062020')))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062020')))
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 CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.NTSB ERA22LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, OHThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB CEN22LA261Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Eden Prairie, MNThe student pilot not maintaining directional control during landing which resulted in a runway excursion.NTSB ERA22LA211Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe pilot’s failure to maintain directional control while attempting to land in a crosswind.NTSB WPR22LA093Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Chemehuevi Valley, CAThe student pilot’s loss of directional control during takeoff.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB WPR20CA222Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hayward, CAThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the flight instructor's delayed remedial action, which resulted in the left wing striking the runway.NTSB CEN20CA202Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Arlington, TXThe pilot's failure to maintain airplane directional control during a gusty crosswind landing.NTSB GAA19CA390Accident · No injuriesData collectionFinal reportCessna 152 · Tracy, CAThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a vehicle.NTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.NTSB ERA19CA148Accident · Minor injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.NTSB GAA19CA169Accident · No injuriesData collectionFinal reportCessna 152 · Madras, ORThe student pilot's failure to maintain directional control during the aborted landing, which resulted in a collision with a snow berm and a subsequent nose-over.NTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB GAA17CA042Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's failure to maintain directional control during the aborted takeoff, which resulted in a runway excursion.NTSB CEN16LA259Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe pilot's unstabilized approach and uneven braking due to insufficient runway remaining, which resulted in a loss of directional control during landing. Contributing to the accident was the bound flap jackscrew, which jammed the flaps and led to the pilot’s…NTSB GAA16CA504Accident · No injuriesData collectionFinal reportCessna 152 · Immokalee, FLThe student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB ERA16LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Chester, CTThe pilot’s failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ERA15CA126Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot's initiation of the flare while too high above the runway, resulting in an aerodynamic stall, hard landing, and loss of directional control.NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.NTSB CEN12CA293Accident · No injuriesData collectionFinal reportCessna 152 · Lee's Summit, MOThe student pilot’s loss of directional control while landing.NTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB CEN10CA467Accident · No injuriesData collectionFinal reportCessna 152 · Breckenridge, MIThe pilot's failure to mantain directional control during the aborted landing.NTSB ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.NTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.NTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.