NTSB investigations: Cessna 152, 1986, IL

5 cases on aircraft the registry lists as Cessna 152. 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

19782026
NTSB investigations: Cessna 152, 1986, IL per year, 1978–2026: 93 cases
19788
19793
19807
19813
19827
19836
19843
19854
19865
19876
19884
19895
19903
19913
19923
19932
19942
19961
19974
19982
19992
20012
20021
20051
20101
20111
20121
20131
20262

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 year(c.\"eventDate\") = 1986
    AND c.\"eventStateOrRegion\" = 'IL' 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'))
  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 CHI87LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe student pilot assumed he had full fuel tanks prior to takeoff. He then proceeded to fly the aircraft for approximately 4.4 hours. Just prior to his final landing he was forced to go around due to an aircraft on the runway. Following this go around he…Oct 5, 1986 · N5488B · Substantial damageNTSB CHI86LA221Accident · No injuriesLimited investigationFinal reportCessna 152II · Carbondale, ILThe pilot stated that as he was returning to the airport, the engine sputtered once and the RPM dropped very low. He applied carb heat, but there was no change, so he made an emergency landing in a corn field where the aircraft nosed over. During an…Sep 14, 1986 · N6490L · Substantial damageNTSB CHI86LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Dwight, ILThe tail of the aircraft struck the cab of a truck while on final approach. The CFI stated that, as they were passing over the road at the approach end of the runway, the aircraft entered a downdraft and the empennage struck the truck which was approaching…Sep 6, 1986 · N24980 · Substantial damageNTSB CHI86LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILThe starter would not engage, so the plt tied down the tail & hand propped the acft to start the eng, but did not use chocks. After the eng started, the acft rolled forward, slipped loose from the rear tie-down & ran into a pile of i-beams. A post acdnt exam…Mar 21, 1986 · N49421 · Substantial damageNTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…Jan 5, 1986 · N6422Q · Substantial damage