NTSB investigations: Cessna 152, WY
12 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 | 3 |
|---|---|
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1985 | 1 |
| 1993 | 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.\"eventStateOrRegion\" = 'WY' 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.
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" = 'WY' 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" 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 SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.NTSB SEA93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Cheyenne, WYThe pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB DEN83LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Afton, WYThe pilot stated that he touched down on the snow covered runway and the brakes were frozen. The aircraft hit bare pavement and veered to the left. Wheel dropped off edge of runway into a snow bank. The aircraft nosed over. An interview with the pilot…NTSB DEN81FTC27Accident · No injuriesClosedCessna 152 · Casper, WYNTSB DEN81FTC15Accident · No injuriesClosedCessna 152 · Gillette, WYNTSB DEN81FA031Accident · 1 fatalClosedCessna 152 · Cowley, WYNTSB DEN80FTC19Accident · Minor injuriesClosedCessna 152 · Sheridan, WYNTSB DEN80FTC07Accident · No injuriesClosedCessna 152 · Lander, WYNTSB DEN78FTC33Accident · No injuriesClosedCessna 152 · Gillette, WYNTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYNTSB DEN78DTC12Accident · No injuriesClosedCessna 152 · Cheyenne, WY