NTSB investigations: Cessna 152, MT
15 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2013 | 1 |
Where
Open the mapLatest 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\" = 'MT' 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" = 'MT' 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" 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 WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.NTSB SEA03LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Butte, MTThe pilot's inadequate compensation for gusty variable wind conditions and his improper flare. Factors include gusty and variable winds .NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB SEA91LA199Accident · No injuriesLimited investigationFinal reportCessna C-152 · W. Yellowstone, MTThe failure by the pilot to calculate aircraft fuel comsumption and the pilot's poor inflight planning. Factors relating to the accident were the inadequate preflight planning by the pilot, his lack of qualification and experience, and his disorientation…NTSB DEN89LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTThe student plt was practicing takeoffs and landings, with reported winds gusting to 14 KTS. During a landing the plt misjudged the flare and attempted to go around. He said the wind raised the right wing and that he overcorrected with aileron and pulled back…NTSB DEN86LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wisdom, MTThe student plt departed minden, NV on an unauthorized x-co flt that terminated in the accident at Wisdom, MT. During the landing roll at an abandoned arpt at Wisdom, the nose of the acft dug into the snow covered runway and the acft nosed over. The plt…NTSB DEN85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalispell, MTThe acft collided with a snowbank during the landing roll following a loss of directional control. The plt reported that the left brake froze or locked up when it was applied during the landing. Inspection revealed that there was a substantial amount of ice…NTSB DEN84LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTPlt flared abruptly and acft floated before it touched down hard on the rwy collapsing the nose gear. Acft traveled 20 ft off the right side of the rwy before coming to rest.NTSB DEN84LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDuring a crosswind takeoff the right wing began to raise just as the plt was thinking about rotating. This startled him & he aborted the takeoff. The acft departed the left side of the rwy & flipped over on its back.NTSB DEN84LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Homestead, MTThe acft crashed from an altitude of 200 ft while maneuvering over a creek. The acft was overloaded by 135 lbs with 2 occupants and full fuel. There were no FAA records found on the plt.NTSB DEN83FTI04Accident · 2 fatalFinal reportCessna 152 · Hamilton, MTThe acft was flying uphill at low alt when it struck the top of 4 trees and impacted the ground about 40 yards away inverted with power on at low airspeed. The elevation at the crash site was about 6000 ft MSL with the tops of the terrain in the direction of…NTSB DEN82FA198Accident · 1 fatalField investigationFinal reportCessna 152 · Divide, MTThe acft stalled & crashed on the side of a ridge. The plt was described as an avid outdoorsman, sportsman & hunter. According to local residents near the crash site, the area is well populated with large & small game. Density altitude was computed to be…NTSB DEN81DTA07Accident · Minor injuriesClosedCessna 152 · Big Timber, MT