NTSB investigations: Cessna 152, CA

6 cases on aircraft the registry lists as Cessna 152, where the sequence of events included Loss of control in flight. 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

20092026
NTSB investigations: Cessna 152, CA per year, 2009–2026: 6 cases
20091
20102
20171
20181
20221

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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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 WPR23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · San Jose, CAThe student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.Nov 13, 2022 · N5171B · Substantial damageNTSB WPR18FA075Accident · 1 fatalField investigationFinal reportCessna 152 · Concord, CAA loss of control for reasons that could not be determined based on the available information.Jan 29, 2018 · N93316 · Substantial damageNTSB WPR18FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Tehachapi, CAThe pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.Nov 20, 2017 · N24987 · DestroyedNTSB WPR10CA390Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe pilot’s failure to maintain aircraft control during final approach, resulting in a hard landing.Aug 8, 2010 · N6165M · Substantial damageNTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.Jul 2, 2010 · N94838 · Substantial damageNTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…Aug 16, 2009 · N67361 · Substantial damage