NTSB investigations: Cessna 172N, CA

9 cases on aircraft the registry lists as Cessna 172N, where the sequence of events included Runway excursion. 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 172N, CA per year, 2009–2026: 9 cases
20091
20141
20161
20191
20201
20231
20242
20261

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 ('2072434')
      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\" = '300' 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 WPR26LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Carlsbad, CAThe student pilot’s failure to maintain airplane control while landing in gusting crosswind conditions.Apr 22, 2026 · N733WT · Substantial damageNTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.Jul 2, 2024 · N74C · Substantial damageNTSB WPR24LA089Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Madera, CAThe pilot’s failure to maintain directional control during landing.Feb 11, 2024 · N737LU · Substantial damageNTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.Mar 10, 2023 · N73726 · Substantial damageNTSB WPR21LA069Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · San Diego, CAA partial loss of engine power due to the fatigue fracture of the No. 3 exhaust valve rocker arm stud.Dec 13, 2020 · N5098E · Substantial damageNTSB GAA19CA448Accident · No injuriesData collectionFinal reportCessna 172 · Van Nuys, CAThe pilot's failure to maintain directional control during landing with a left quartering crosswind, which resulted in a runway excursion and impact with runway lighting.Jul 23, 2019 · N737DW · Substantial damageNTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 18, 2016 · N7560D · Substantial damageNTSB WPR14CA399Accident · No injuriesData collectionFinal reportCessna 172N · Thermal, CAThe student pilot's failure to maintain directional control during landing after an encounter with a dust devil.Sep 30, 2014 · N738TJ · Substantial damageNTSB WPR10CA007Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAThe pilot’s improper flare and inadequate recovery from a bounced landing.Oct 7, 2009 · N2219E · Substantial damage