NTSB investigations: Cessna 152
68 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “On ground/water collision with object”. 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, newest first
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.\"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\" = 310))
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."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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB MIA84LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe tailwheel equipped acft collided with a stopped Cessna while taxiing to takeoff. The Cessna was in the runup area. The Boeing A75 acft plt said he failed to see the parked acft.NTSB DEN84LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAfter receiving clearance to rwy 16L, the plt began taxiing thru a congested area where the taxiway & an arpt road were routed thru a hangar/parking area. In that area, the roadway was adjacent to the taxiway & to the right of the plt as he was taxiing. The…NTSB ATL84LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Boaz, ALThe acft collided with a traffic sign while taxiing for takeoff on a highway. The plt said he was a'path finder' for a fly-in and had the cooperation of the police. The owner of the acft said the plt was not authorized to use the acft for this flt.NTSB MIA84LA141Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLA truck ran into an acft waitng to takeoff. The acft was on the runup pad and the vehicle driver was distracted by an acft taking off. The control tower was not in service.NTSB MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB MIA83LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Near Tampa, FLThe plt reported that before the flt, he had taken 2 sominex tablets, but had insomnia & could not sleep, even though he was very tired. He stated that after takeoff, he thought he was heading southeast, but later, he found out that he was going northeast.…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…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…NTSB MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…NTSB ATL82IA218Incident · No injuriesIncident investigationFinal reportCessna 152 · Hampton, GADuring taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB MIA82DA081Accident · No injuriesFinal reportCessna 152 · Brooksville, FLWhile taxiing for takeoff on a road used for aircraft and vehicles the aircraft collided with a parked garbage truck.