NTSB investigations: Cessna A152
11 cases on aircraft the registry lists as Cessna A152, 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1987 | 3 |
| 1990 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071836')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071836')
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 FTW98LA180Accident · No injuriesLimited investigationFinal reportCessna A152 · Brigham City, UTfailure of the pilot to maintain directional control of the airplane during a touch and go landing. Related factors were: the pilot allowed his attention to be diverted into the cockpit for an excessive amount of time, and the encounter with a ditch.NTSB FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.NTSB ATL95LA146Accident · No injuriesLimited investigationFinal reportCessna 152A · Sanford, FLThe pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB SEA94LA185Accident · No injuriesLimited investigationFinal reportCessna A152 · Bremerton, WAThe pilot's failure to maintain directional control.NTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.NTSB CHI91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIDirectional control not maintained by the PIC.NTSB DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…NTSB MIA87LA105Accident · No injuriesLimited investigationFinal reportCessna A152 · Cocoa, FLThe plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident…NTSB ANC87LA037Accident · No injuriesLimited investigationFinal reportCessna A152 · Chugiak, AKThe student pilot was practicing touch and go landings on a snow covered runway when the pilot lost control of the aircraft, struck a runway perimeter snow berm and nosed over.NTSB SEA85LA039Accident · No injuriesLimited investigationFinal reportCessna 152A · Pullman, WAPlt made 10 touch and go landings and had just raised the flaps and was applying full pwr to initiate another takeoff. Noting he was rt of the centerline he applied left rudder. Acft veered sharply to the left where it slid on ice into a snowbank.NTSB SEA85LA045Accident · No injuriesLimited investigationFinal reportCessna A152 · Deer Park, WADuring landing practice on an instructional flight at an uncontrolled arpt, acft was being taxiied back for takeoff after a full stop landing. Surface was icy and snow-covered. Student was practicing directional control exercise with rudder. Acft skidded and…