NTSB investigations: Cessna 152
255 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 15 |
|---|---|
| 1983 | 11 |
| 1984 | 13 |
| 1985 | 10 |
| 1986 | 15 |
| 1987 | 17 |
| 1988 | 15 |
| 1989 | 21 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 11 |
| 1993 | 15 |
| 1994 | 9 |
| 1995 | 12 |
| 1996 | 8 |
| 1997 | 10 |
| 1998 | 10 |
| 1999 | 8 |
| 2000 | 11 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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.\"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\" = 353))
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" = 353))
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 ATL07CA070Accident · No injuriesData collectionFinal reportCessna 152 · Hinesville, GAThe pilots improper preflight planning with resulted in a loss of engine power due to fuel exhaustion.NTSB LAX06CA079Accident · No injuriesData collectionFinal reportCessna 152 · Rancho Murieta, CAfuel contamination (water) due to the inadequate preflight by both pilots, which failed to detect the residual water contamination in fuel system. A factor in the accident was the soft terrain condition at the forced landing site.NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.NTSB IAD04CA014Accident · Minor injuriesData collectionFinal reportCessna 152 · Hamilton, OHThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.NTSB NYC04LA045Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot's improper use of carburetor heat, which resulted in a total loss of engine power during cruise flight. A factor was carburetor icing conditions.NTSB MIA03CA095Accident · No injuriesData collectionFinal reportCessna 152 · Olive Branch, MSThe CFI's improper positioning of the fuel selector valve to the off position which resulted in fuel starvation and the subsequent loss of engine power.NTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.NTSB ATL02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe pilot's improper preflight planning and fuel management resulting in fuel exhaustion, and the total loss of engine power. The airplane nosed over during a forced landing to a cotton field.NTSB CHI02LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Sedalia, MOThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident was the soft, rough/uneven terrain.NTSB LAX02LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Henderson, NVFuel exhaustion during cruise flight due to the pilot's improper in-flight decision. A contributing factor was his improper preflight planning.NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.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 FTW00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blanchard, LAThe student pilot's failure to refuel, which resulted in fuel exhaustion. Factors were the dark night light conditions and lack of suitable terrain for the forced landing.NTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.NTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.NTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.NTSB ATL00LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe pilot's inadequate pre-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.NTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.NTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB LAX99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.NTSB NYC99LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Wall, NJThe pilot in command's improper preflight preparation, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.NTSB MIA99LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Coral Springs, FLThe delay by the pilot to obtain proper assistance after becoming lost/disoriented resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's lack of total experience.NTSB NYC98LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellington, CTWas the flight instructors lack of supervision over the student pilot's preflight inspection of the airplane, and which resulted in fuel exhaustion. Factors were the night conditions and the soft terrain.NTSB IAD98FA095Accident · 3 fatalField investigationFinal reportCessna 152 · Blue Ash, OHthe pilot's inaccurate calculation of the fuel which resulted in exhaustion of fuel and subsequent loss of engine power.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB IAD98LA071Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edgemere, MDThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB MIA98LA081Accident · No injuriesLimited investigationFinal reportCessna 150A · Gulf Of Mexicoa loss of engine power due to undermined reason resulting in a forced landing, and an in- flight collision with water.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB CHI98LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Quincy, ILimproper in-flight planning/decision by the flight instructor (CFI), by switching 'OFF' the fuel selector valve of the single-engine airplane (starving the engine of fuel) to 'simulate' an emergency. Factors relating to the accident were: the soft and uneven…NTSB LAX97LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Murrieta, CAfailure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.NTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.NTSB LAX97LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Mecca, CAfuel exhaustion as a result of the student pilot's inadequate preflight and failure to refuel.NTSB FTW97LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Lufkin, TXThe loss of engine power due to fuel exhaustion, which resulted from the student pilot becoming disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB LAX97LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gila Bend, AZthe pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.NTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…NTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.