NTSB investigations: Cessna 152, 1985, LA

4 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
NTSB investigations: Cessna 152, 1985, LA per year, 1978–2026: 38 cases
19783
19791
19804
19811
19823
19831
19842
19854
19882
19892
19901
19911
19921
19951
19961
19971
19981
19991
20002
20012
20041
20061
20091

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 year(c.\"eventDate\") = 1985
    AND c.\"eventStateOrRegion\" = 'LA' 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.

NTSB 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 FTW86LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner.Oct 3, 1985 · N67803 · Substantial damageNTSB 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 · Destroyed