NTSB investigations: Cessna 152, MS
25 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2021 | 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\" = 'MS' 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" = 'MS' 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 CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.NTSB MIA02FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Poplarville, MSThe pilot's becoming lost and disoriented and his failure to maintain control of the airplane while flying over an unpopulated area on a dark night, which was the result of spatial disorientation. Factors in the accident was the pilot's consuming alcoholic…NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.NTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.NTSB MIA95LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lumberton, MSThe failure of the landing gear, steering system (rod end bolt) due to a bending overstress separation which resulted in loss of directional control.NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…NTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.NTSB MIA91LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Yazoo City, MSPoor planning decision by the student pilot, improper fuel calculations, resulting in fuel exhaustion due to an inadequate fuel supply. Contributing to the accident was overconfidence in his own personal ability by the student pilot.NTSB MIA89LA226Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe pilot's failure to attain the proper touchdown point during landing.NTSB MIA89LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and ditch were contributing factors.NTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…NTSB MIA88LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted.NTSB MIA88LA118Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe plt stated that he was simulating a loss of power & then attempting to turn back to the arpt & land on the runway that they departed from. As he was turning back from an approximate altitude of 600 feet, the acft stalled & crashed.NTSB MIA87LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Polarville, MSThe plt stated that he had just completed a touch-&-go ldg and was attempting to take off again. As he added power, the acft began to drift to the left. The acft continued left hitting a ditch along side the rwy and flipping over. The plt stated that the acft…NTSB ATL85LA178Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSPlt was returning to arpt with known low fuel state. The planned landing was to be on rwy 18 but while approaching the arpt, the eng missed. The plt elected to land on rwy 36 with a tailwind and conflicting traffic. The conflicting traffic cleared the rwy and…NTSB ATL81FKQ20Accident · 1 fatalClosedCessna 152 · Magee, MSNTSB ATL81FA025Accident · 1 fatalClosedCessna 152 · Ft Adams, MSNTSB ATL80FKQ15Accident · No injuriesClosedCessna 152 · Ocean Springs, MSNTSB MIA79FA087Accident · 2 fatalClosedCessna 152 · Greenville, MSNTSB MIA78DKQ41Accident · No injuriesClosedCessna 152 · Tylertown, MSNTSB MIA78FKQ18Accident · No injuriesClosedCessna 152 · Greenwood, MS