Fatal NTSB investigations: Cessna A152
14 cases on aircraft the registry lists as Cessna A152. 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 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1987 | 1 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 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.\"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 ('2071836'))
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."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 ('2071836'))
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 FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.NTSB LAX94LA261Accident · 2 fatalLimited investigationFinal reportCessna 152 · Half Moon Bay, CAThe pilot's loss of aircraft control due to spatial disorientation.NTSB BFO93FA061Accident · 1 fatalField investigationFinal reportCessna A152 · Revere, PAThe CFI failed to adequately supervise the operation. Related factors were dark night, lost/disorientation of the pilot, and her lack of experience in type of operation (night flying).NTSB LAX90FA320Accident · 2 fatalField investigationFinal reportCessna A152 · Tucson, AZFailure of the pilot to recover from a spin. Factors related to the accident were: the pilot's failure to assure there was adequate altitude to recover from an inadvertent or intentional spin, and his lack of recent expereince in the type of operation.NTSB BFO90LA072Accident · 1 fatalLimited investigationFinal reportCessna A152 · Hyden, KYThe pilot intentionally continuing VFR flight into instrument meteorological conditions which resulted in spatial disorientation and loss of aircraft control. Factors contributing to the accident were the thunderstorms and the pilot's lack of instrument…NTSB DEN88FA036Accident · 1 fatalField investigationFinal reportCessna A152 · Benson, AZAbt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the…NTSB MIA83FA225Accident · 1 fatalField investigationFinal reportCessna A152 · Homosassa Sprgs, FLThe acft was first observed making low passes, almost striking trees & power lines. It then continued in a steep bank through about 90 deg of turn, rolled inverted & pitched down simultaneously. The acft impacted the ground in the parkinglot of a convenience…NTSB SEA82AA126Accident · 6 fatalFinal reportCessna 172 · Mercer Island, WAN2428E, a C-172, had departed sea-tac arpt for a VFR flt to snohomish, WA, about 27 mi on the 355 deg radial from the sea-tac VORTAC. It proceeded nnw over the west shore of Mercer Island located approximately 10 mi north of the sea-tac arpt. N761EL, a…NTSB SEA82FA052Accident · 1 fatalField investigationFinal reportCessna A152 · Bremerton, WAThe pilot took off downwind and against traffic in marginal weather conditions. No flight plan was filed and there was no record of a weather briefing. During departure, a near-miss occurred between N761QZ and a light twin-engine aircraft on an instrument…NTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.NTSB CHI81FA077Accident · 2 fatalClosedCessna 152 · E Liverpool, OHNTSB FTW80FA036Accident · 2 fatalClosedCessna A152 · Lomax, TXNTSB FTW80FA014Accident · 2 fatalClosedCessna 152 · Lillian, TXNTSB IAD79FA013Accident · 1 fatalClosedCessna 152 · Spencer, WV