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
| 1978 | 1 |
|---|---|
| 1985 | 3 |
| 1989 | 1 |
| 1997 | 1 |
Where
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.
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" 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 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.NTSB 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.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…NTSB 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…NTSB 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…NTSB FTW79DA027Accident · 2 fatalClosedCessna 152 · Husser, LA