NTSB investigations: Cessna 152, NM
23 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
| 1978 | 2 |
|---|---|
| 1979 | 1 |
| 1981 | 3 |
| 1982 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1995 | 2 |
| 2000 | 2 |
| 2004 | 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\" = 'NM' 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" = 'NM' 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 DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB DEN01LA011Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roswell, NMthe flight instructor's failure to adequately preflight the airplane, which resulted in the loss of engine power due to fuel exhaustion. A contributing factor was the dark night light condition.NTSB DEN00FA067Accident · 1 fatalField investigationFinal reportCessna 152 · Roswell, NMThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin. A factor was the pilot's diverted attention to over flying her residence.NTSB FTW95LA324Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Raton, NMThe pilot's inadvertent activation of the flaps. Factors in the accident were the weather conditions and the dark night.NTSB FTW95LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmington, NMThe student pilot's inadequate compensation for wind conditions during the landing, which resulted in her failure to maintain proper runway alignment. The gusty crosswind was a related factor.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB DEN88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallup, NMPrior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude…NTSB DEN87LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe student plt was practicing unsupervised solo flt in gusty cross winds. He became distracted on takeoff and failed to correct for a left drift. At this point he had taken out all aileron correction and when the left wing came up, he also added left rudder.…NTSB DEN87LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt was on a solo x-country and landed at an intermediate arpt. The acft was taxiing from landing with a 24 kt tailwind. A strong gust of wind hit the acft and it nosed over.NTSB DEN86LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Alameda, NMThe student plt stated that during the landing, the aircraft bounced twice before it's nose gear collapsed. The student pilot said the aircraft nosed over onto its back following the nose gear collapse.NTSB DEN85LQA02Accident · No injuriesFinal reportCessna 152 · Santa Teresa, NMThe helcopter plt was on a solo instructional flt in the Cessna 152 airplane. He had only 9 hrs flt time in fixed wing acft. While on a touch-&-go landing, the acft bounced as it touched down. It then bounced 2 more times with each bounce becoming…NTSB DEN84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Kirtland Afb, NMUpon touchdown a hard landing was made after which the acft bounced and became airborne. The acft contacted the rwy hard at which time the nose gear collapsed.NTSB DEN84LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt made a forced landing and the acft nosed over on soft terrain after the engine quit during the last leg of a x-country. The plt said he had not visually checked the fuel tanks during pre-flight. An examination of the acft after the accident…NTSB FTW83LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Aztec, NMThe aircraft was involved in a hard bouncing landing when the student pilot allowed the aircraft to porpoise during landing. The nose gear failed during this sequence and the aircraft was damaged. The pilot was uninjured. The pilot did not file an accident…NTSB FTW82DA052Accident · No injuriesFinal reportCessna 152 · Albuquerque, NMThe instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from…NTSB FTW82FQA03Accident · Minor injuriesClosedCessna 152 · Alamo, NMNTSB FTW81DQA29Accident · No injuriesClosedCessna 152 · Grants, NMNTSB FTW81DQD15Accident · No injuriesClosedCessna 152 · Silver City, NMNTSB DEN79DQA45Accident · Serious injuriesClosedCessna 152 · Crown Point, NMNTSB DEN78DQD36Accident · No injuriesClosedCessna 152 · Deming, NMNTSB DEN78DQA43Accident · No injuriesClosedCessna 152 · Tucumcari, NM