Skip to content

NTSB investigations: Cessna 152, NE

19 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Where

Latest cases

Query with SQL

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" = 'NE' 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

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\" = 'NE' 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.

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" = 'NE' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.Aug 12, 2002 · N49998 · Destroyed NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.Jul 2, 2000 · N6432M · Substantial damage NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.Aug 18, 1999 · N869NE · Substantial damage NTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.Sep 2, 1992 · N6480M · Substantial damage NTSB MKC87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Gretna, NEThe instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for…Nov 11, 1986 · N5175M · Substantial damage NTSB MKC85LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Adams, NEPlt was making first landing at an ag strip and collided with 30 foot high utility wires which cross the apch end of thestrip. The wires are not marked.May 21, 1985 · N25868 · Substantial damage NTSB MKC84LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · David City, NEThe instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.…Dec 3, 1983 · N89812 · Substantial damage NTSB MKC83LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Sidney, NEThe student plt was on a solo x-country flt. As he approached Sidney, NE, he was unable to contact anyone on the radio & continued to the arpt at cruise alt. He descended while circling the arpt. Before reaching traffic pattern alt, he applied power, but the…Aug 1, 1983 · N67585 · Substantial damage NTSB MKC83LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Nebraska City, NEThe student plt lost directional control during a takeoff on his 2nd solo flt. He reported that as he started the takeoff, the acft began moving to the left of the rwy, so he applied right rudder, but too much, then too much left rudder. Subsequently, the…Jul 18, 1983 · N714VP · Substantial damage NTSB MKC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Ord, NEThe student pilot reported that on his third touch-and-go, he was momentarily distracted and looked down inside the aircraft. He inadvertentently pushed the left rudder and was unable to regain directional control before the left main wheel ran off the side…Jan 23, 1983 · N4640B · Substantial damage NTSB MKC83LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · 1nm N. Or Mcgre, NEUpon discovering his intended point of landing was closed, the pilot chose to land the aircraft on a nearby road. During his final approach the pilot saw a power line and dove under it landing short. The aircraft collided with road signs during the landing…Nov 6, 1982 · N65539 · Substantial damage NTSB MKC82DA104Accident · No injuriesFinal reportCessna 152 · 10 Sw Falls Cit, NEThe pilot stated that he took off to take photographs in nemaha county, KS. While enroute, he shot 6 rolls of film and then continued toward falls city, NE. He reported that about 7 miles from the airport, he ran out of fuel and landed in a wheat field. After…Jun 16, 1982 · N49974 · Substantial damage NTSB MKC82DA084Accident · No injuriesFinal reportCessna 152 · Ainsworth, NEThe pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots.May 19, 1982 · N5399B · Substantial damage NTSB MKC81DCJ12Accident · No injuriesClosedCessna 152 · Arthur, NEMay 7, 1981 · N6614H · Substantial damage NTSB MKC81DCJ05Accident · No injuriesClosedCessna 152 · Omaha, NEJan 2, 1981 · N89795 · Substantial damage NTSB MKC80DCJ29Accident · No injuriesClosedCessna 152 · Columbus, NEAug 25, 1980 · N49696 · Substantial damage NTSB MKC80DCJ11Accident · No injuriesClosedCessna 152 · Omaha, NEApr 23, 1980 · N25595 · Substantial damage NTSB MKC80FCJ08Accident · No injuriesClosedCessna 152 · Imperial, NEApr 5, 1980 · N757PY · Substantial damage NTSB MKC78DCJ16Accident · Minor injuriesClosedCessna 152 · Crete, NEMay 17, 1978 · N24290 · Substantial damage