Fatal NTSB investigations: Cessna 152, LA

6 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

19782026
Fatal NTSB investigations: Cessna 152, LA per year, 1978–2026: 6 cases
19781
19853
19891
19971

Latest 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\" = 'LA' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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.

NTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.Feb 28, 1997 · N49205 · DestroyedNTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.Sep 3, 1989 · N24516 · 2 aircraft · DestroyedNTSB FTW86FA023Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, LAThe instrument flight instructor and student experienced a directional gyro failure. They covered the instrument and requested a return to their departure point. The aircraft was not equipped to fly the published approach. They requested a descent to an…Nov 2, 1985 · N93527 · DestroyedNTSB FTW85FA244Accident · 1 fatalField investigationFinal reportCessna 152 · Bogalusa, LAA few minutes after departure the student plt flew into the ground in an effort to return to the arpt about 1400 ft n of rwy 18 in aprx a 15 deg nose down and 35 deg left angle of bank. The afct slid about 80 ft when it rotated about it's right wing flipping…Jun 2, 1985 · N5097H · DestroyedNTSB FTW85FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Franklin, LAAcft crashed into a crawfish pond during a forced landing at night following a power loss as a result of fuel exhaustion. After departure, the plt contacted ARTCC and stated that his alternator was out. With center help, alternator was restored and plt cont'd…Apr 13, 1985 · N68303 · DestroyedNTSB FTW79DA027Accident · 2 fatalClosedCessna 152 · Husser, LADec 19, 1978 · N25819 · Destroyed