NTSB investigations: Cessna 152
120 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of engine power”. 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
| 1982 | 8 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 9 |
| 1992 | 6 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 9 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 4 |
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.\"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\" = 350))
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" = 350))
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 DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB SEA06LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Kelso, WAEncounter with carburetor icing conditions while maneuvering for the downwind which resulted in a loss of engine power due to carburetor ice. The aircraft nosing over during the landing roll in soft sand was a factor.NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB ATL05LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, NCThe loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.NTSB ATL02LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring City, TNThe flight instructor's failure to follow standard training procedures that resulted in the loss of engine power during a simulated loss of engine power.NTSB CHI02LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNThe pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.NTSB LAX02LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder City, NVa loss of engine power due to an undetermined malfunction of the carburetor.NTSB FTW02LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW02LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · New Braunfels, TXthe loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.NTSB ATL01LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNA loss of engine power during takeoff due to carburetor ice. A factor was unsuitable terrain.NTSB CHI00LA261Accident · No injuriesLimited investigationFinal reportCessna 152 · New London, MOthe fuel exhaustion and inadequate preflight planning/preparation by the pilot.NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB CHI00LA245Accident · No injuriesLimited investigationFinal reportCessna 152 · Arthur, NDthe water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.NTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB CHI99LA286Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Evansville, INfuel exhaustion due to the flight instructor's improper in-flight decision. A factor was the ditch.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.NTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA366Accident · No injuriesLimited investigationFinal reportCessna 152 · Garland, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.NTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB MIA97LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Coral, FLLoss of engine power for undetermined reasons resulting in a forced landing to unsuitable terrain.NTSB MIA97LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · La Crosse, FLThe student pilot's failure to maintain a visual look out on landing rollout resulting in an on-ground collision with a berm/furrow, and subsequent nose over. Contributing to the accident was the student pilot's improper fuel management resulting in a total…NTSB ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.NTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.NTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.