NTSB investigations: Cessna 152, CA

9 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “On ground/water collision with object”. 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

19852026
NTSB investigations: Cessna 152, CA per year, 1985–2026: 9 cases
19852
19861
19912
19981
20001
20021
20041

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\" = 'CA' 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\" = 310))
  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.

NTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.Jan 11, 2004 · N67844 · Substantial damageNTSB LAX02LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Sacramento, CAFailure of the pilot to ensure the seat was set properly prior to engine start, and not using the parking brake when adjustment of seat was necessary, which resulted in the inadvertent deactivation of the brakes and subsequent collision with the fuel trucks.May 8, 2002 · N67975 · Substantial damageNTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.Jul 15, 2000 · N67603 · Substantial damageNTSB LAX99LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe pilot's failure to maintain clearance between the airplane's wing and a parked fuel truck.Oct 18, 1998 · N5550L · Substantial damageNTSB LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.Oct 5, 1991 · N5486G · 2 aircraft · Minor damageNTSB LAX91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe failure of the CFI aboard N25378 to adequately supervise the flight and the dual student pilot's improper use of the normal brakes.Mar 3, 1991 · N25378 · 2 aircraft · Minor damageNTSB LAX86LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · El Monte, CAThe student pilot was taxiing to the run-up area when his left wing struck the corner of a hangar. The pilot stated he was paying attention to the right wing which was close to another aircraft at the time.Sep 16, 1986 · N95010 · Substantial damageNTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…Dec 9, 1985 · N64851 · Substantial damageNTSB LAX85LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAFollowing an uneventful flt,the pilot taxied towards his parking area. He said as he looked to his right for a parking space the acfts left wing impacted a hanger and the acft turned left nosing into the hanger door.Aug 20, 1985 · N4807B · Substantial damage