NTSB investigations: Cessna 152, GA
8 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 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\" = 'GA' 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" = 'GA' 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 MIA02LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Valdosta, GAThe failure of the student pilot to maintain directional control during takeoff, resulting in an on ground encounter with an adjacent ditch and a collapsed nose gear strut during the attempt to abort the takeoff.NTSB MIA99LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAThe failure of the pilot to maintain directional control during takeoff from a touch and go landing resulting in the aircraft traveling off the runway, colliding with taxiway lights and a taxiway sign, collapsing the nose landing gear, and nosing down.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB MIA96LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAthe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB ATL93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Atlanta, GAThe student pilot's failure to maintain directional control of the airplane.NTSB ATL88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe acft was taxiing for departure when a gust of wind lifted the left wing and the acft overturned. The surface winds were reported at 16 knots with gusts to 27 knots. The plt stated that proper flight control inputs were used for taxiing in windy conditions.NTSB ATL86LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, GADuring an attempted touch and go landing the student plt lost directional control of the acft. The acft ballooned during touchdown, veered off the rwy and nosed over.NTSB ATL83LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Benning, GAStudent was doing a touch and go landing. While changing flap, carb heat and applying full throttle aircraft veered left. Recovery was attempted throttle off but aircraft left runway and collapsed nose gear, before flipping over.