NTSB investigations: Cessna A152, 1987
7 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 | 3 |
| 1980 | 5 |
| 1981 | 5 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 2003 | 1 |
| 2005 | 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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 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 DEN88LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Tremonton, UTThe student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree…NTSB MKC87LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · El Dorado, KSAfter departing midfield and attaining approximately 100 feet of altitude, plt experienced a complete power failure. Plt attempted to reland on intersecting runway by executing an approximate 270 degree turn. Acft struck the terrain before completing the…NTSB MIA87LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe student plt had completed about 3.4 hrs of a solo cross-country training flt and was about 6 miles se of the airport, when the aircraft sustained a loss of power. A forced landing was performed in a celery field. Investigation revealed no usable fuel in…NTSB CHI87LA123Accident · Minor injuriesLimited investigationFinal reportCessna A152 · Gobles, MIDuring the third leg of a cross-country flight, the pilot reported that the sun was directly in his eyes while on final approach to rwy 27. He stated he first saw the set of power lines when they were about 25 feet ahead of the aircraft. While attempting to…NTSB MIA87LA105Accident · No injuriesLimited investigationFinal reportCessna A152 · Cocoa, FLThe plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident…NTSB ANC87LA037Accident · No injuriesLimited investigationFinal reportCessna A152 · Chugiak, AKThe student pilot was practicing touch and go landings on a snow covered runway when the pilot lost control of the aircraft, struck a runway perimeter snow berm and nosed over.