NTSB investigations: Cessna 152, 1987, SC
3 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 | 4 |
|---|---|
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 1 |
| 1993 | 2 |
| 1994 | 5 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 2003 | 2 |
| 2009 | 1 |
| 2010 | 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 year(c.\"eventDate\") = 1987
AND c.\"eventStateOrRegion\" = 'SC' 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 year(c."eventDate") = 1987
AND c."eventStateOrRegion" = 'SC' 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 ATL88LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the…NTSB ATL88LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse.NTSB ATL87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe student plt was unable to recall anything about the acdt. A plt/a&p observing the t.o. stated that the acft lifted off and climbed to 50-60 ft. when a flock of black birds flew up into the path of the acft. The acft pitchedup, yawed slightly, turned about…