NTSB investigations: Cessna 152, KY
14 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 per year
| 1973 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 1 |
Where
Open the mapLatest 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\" = 'KY' 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" = 'KY' 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 NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB BFO93LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, KYThe student pilot's inadequate flare. A factor was the gusty wind.NTSB ATL90LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Peewee Valley, KYThe pilot's improper precautionary landings. The pilot's improper planning/decisions, the low fuel level, and the terrain conditions at the airstrip were related factors.NTSB ATL87LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Lewisburg, KYStudent PIC flew solo x-country. About 30 minutes after dpting enroute stop engine quit. He rptd checking fuel prior to departure. Flt school policy was to refuel at enroute stop which was not done. Acft was landed in a field and hit a fence during landing…NTSB ATL87LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Trenton, KYThe dual instruction flight was practicing soft field landings at a private grass strip. The aircraft stalled during a go-around attempt on the second approach when the student pilot executed a steep pullup to clear powerlines. The aircraft pitched down,…NTSB ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…NTSB ATL87FA010Accident · 2 fatalField investigationFinal reportCessna 152 II · Pembroke, KYThe acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft…NTSB ATL85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt Sterling, KYThe insturctor (CFI) was demonstrating a soft field takeoff from a grass area beside the rwy. At that time, the acft lifted off, then settled back onto the grass. The CFI reported that the right main gear touched down in a hole which caused the acft to veer…NTSB IAD80DLQ03Accident · No injuriesClosedCessna 152 · Bowling Green, KYNTSB IAD78DLQ28Accident · No injuriesClosedCessna 152 · Owensboro, KYNTSB CHI73ALQ20Accident · No injuriesClosedCessna 177RG · Lexington, KY