NTSB investigations: Cessna 152, AL

7 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Cessna 152, AL per year, 1985–2026: 7 cases
1985	2
1986	1
1995	2
1996	1
1999	1

Where

Open the map

Latest cases

Query with SQL

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" = 'AL' 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') 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

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\" = 'AL' 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')
      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."eventStateOrRegion" = 'AL' 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')
    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

Run 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 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.Oct 17, 1999 · N6504L · Substantial damage NTSB MIA96LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, ALfuel contamination, which resulted in loss of engine power, a forced landing, and impact with trees. A factor relating to the accident was: inadequate maintenance and/or inspection after the previous loss of engine power and forced landing.Jul 17, 1996 · N6481L · Substantial damage NTSB ATL95LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookwood, ALThe pilot's failure to lean the fuel mixture, stop at the first destination to refuel, and his incorrect fuel consumption calculations.Feb 23, 1995 · N6470P · Substantial damage NTSB MIA95FA072Accident · Serious injuriesField investigationFinal reportCessna 152 · Mobile, ALThe pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.Feb 7, 1995 · N757XX · Substantial damage NTSB ATL86LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Natural Bridge, ALThe student plt reported making an error during preflt planning for the solo x-country flt. The student's instructor didnot detect the error. The student plt flew an incorrect hdg, became lost and ran out of fuel. A forced ldg was made in a field.May 13, 1986 · N89339 · Substantial damage NTSB ATL86LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Huntsville, ALDuring a cross country flight, the pilot elected not to refuel at his proposed refueling point and continued to another airport. While on a visual approach to the runway, the aircraft lost power due to fuel exhaustion.Nov 24, 1985 · N45920 · Substantial damage NTSB ATL85LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Ozark, ALThe plt was on a x-country flt from Ozark, AL to columbia, SC & return. He used 22 gal of fuel en route to columbia. Before returning, he refueled the acft to its full capacity of 24.5 usable gals. However, on the return flt, he encountered headwinds, did not…May 8, 1985 · N6097M · Substantial damage