NTSB investigations: Cessna 152, PA
12 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of control - on ground/water”. 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
| 1983 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 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.\"eventStateOrRegion\" = 'PA' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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" = 'PA' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.NTSB NYC95LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Beaver Falls, PAthe failure of the student pilot to maintain directional control after touchdown.NTSB NYC93LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAImproper recovery from a bounced landing which resulted in the airplane departing the side of the runway and striking trees.NTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.NTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…NTSB NYC86LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, PAThe student plt was on a x-country flt. He rprtd that during the flare to land at Harrisburg, PA, the acft yawed left, then after touchdown, it veered off the left side of the rwy twd a VASI installation. He steered further left to avoid the VASI, then…NTSB NYC85LA161Accident · No injuriesLimited investigationFinal reportCessna 152II · Ebensburg, PAThe student plt was practicing takeoffs and landings when the acft traveled off the left side of the rwy during the fourth landing. Once off the rwy, the acft traveled into a construction area where it nosed over.NTSB NYC85LA127Accident · No injuriesLimited investigationFinal reportCessna C152 · Newry, PAThe student pilot, sole occupant was on his first solo flight performing touch and go landings at blue knob valley airport, Newry, Pennsylvania. During a landing. The aircraft touched down left of the centerline and drifted left contacting a barrel with the…NTSB NYC83LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Factoryville, PAAfter touchdown on a full stop landing, the student plt was instucted to apply brakes. When he failed to respond, the instructor (CFI) applied the brakes to stop the acft. As the brakes were engaged, the acft veered to the left. The CFI corrected with full…NTSB NYC83LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe turf rwy was wet from melting snow with snowbanks on both sides. The plt decided to take off from the left side staying clear of mud. Acceleration was slower than normal due to the wet grass & as the plt tried to rotate a loud bang was heard. The plt…