NTSB investigations: Cessna 152, MI

6 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

19822026
NTSB investigations: Cessna 152, MI per year, 1982–2026: 6 cases
19821
19841
19851
19861
19922

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\" = 'MI' 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 CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.Oct 13, 1992 · N69223 · Substantial damageNTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.Feb 6, 1992 · N65566 · Substantial damageNTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…Oct 19, 1986 · N69223 · Substantial damageNTSB CHI86LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, MIThe plt experienced engine failure due to fuel starvation ten miles north of his destination. During the forced landing the prop and left wing were substantially damaged. The plt stated that when he ran out of fuel the right fuel guage read between 1/4 and…Oct 29, 1985 · N68741 · Substantial damageNTSB CHI84LA271Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe plt stated that during preflight, he noticed that after straining the fuel sump, the strainer handle did not go backin as FAR as it should have. He checked to make sure no fuel was leaking & decided to take off. En route, he smelled fuel vapors. The eng…Jul 8, 1984 · N49185 · Substantial damageNTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…Feb 7, 1982 · N46733 · Substantial damage