NTSB investigations: Cessna 152, IA

5 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19832026
NTSB investigations: Cessna 152, IA per year, 1983–2026: 5 cases
19831
19881
19901
19932

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\" = 'IA' 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\" = 353))
  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 CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.Aug 2, 1993 · N49899 · Substantial damageNTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.Jan 19, 1993 · N60SX · Substantial damageNTSB MKC90LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, IAFuel exhaustion due to misjudged fuel consumption calculations by the pilot in command, and a forced landing to a field with a hidden obstruction.Jun 5, 1990 · N94615 · Substantial damageNTSB MKC88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Des Moines, IADuring a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel…May 29, 1988 · N67360 · Substantial damageNTSB MKC84LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Clear Lake, IAThe student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing…Oct 9, 1983 · N69035 · Substantial damage