# NTSB investigations: Cessna A152: In flight collision with object

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CHI87LA123](https://openairdocs.org/ntsb/CHI87LA123.md): Cessna A152 · Gobles, MI · Accident · Minor injuries · Limited investigation · Final report · May 6, 1987 · N761ED · Destroyed
  > During 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 DEN87LA027](https://openairdocs.org/ntsb/DEN87LA027.md): Cessna 152A · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Dec 2, 1986 · N4784A · Substantial damage
  > The student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…
- [NTSB SEA86LA014](https://openairdocs.org/ntsb/SEA86LA014.md): Cessna 150 · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1985 · N3231V · 2 aircraft · Substantial damage
  > The pilot of the landing aircraft failed to see and avoid the departing aircraft. The aircraft struck the departing aircrafts vertical stabilizer and rudder with the propeller. Approximately 40% of the vertical stabilizer and rudder separated from the…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071836')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2071836&occurrence=220

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.