# NTSB investigations: Volkswagen CONVERSION: 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 ATL04LA050](https://openairdocs.org/ntsb/ATL04LA050.md): Baker KR-2 · St. Marys, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2003 · N93PC · Substantial damage
  > The pilot's failure to maintain airspeed during climb out which resulted in a stall and inflight collision with trees.
- [NTSB MIA03LA146](https://openairdocs.org/ntsb/MIA03LA146.md): Sonerai Sonerai IIB · Lakeland, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2003 · N224RB · Destroyed
  > The pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.
- [NTSB LAX03LA104](https://openairdocs.org/ntsb/LAX03LA104.md): Towner Kit Fox 4 · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Mar 3, 2003 · N95FT · Substantial damage
  > the propeller's separation in-flight as a result of a bird strike.
- [NTSB LAX92LA297](https://openairdocs.org/ntsb/LAX92LA297.md): Krug Lincoln Sportplane · Corona, CA · Accident · No injuries · Limited investigation · Final report · Jul 14, 1992 · N377JK · Substantial damage
  > The pilot/builder inadequate propeller component resulting in an inadequate climb performance. Contributing to this accident was the airplane's inability to climb.
- [NTSB MIA91LA194](https://openairdocs.org/ntsb/MIA91LA194.md): Schultz Avid Flyer 502 · O'Brien, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1991 · N15DW · Substantial damage
  > The pilot in command's improper planned final approach, which resulted in an in flight collision with an electrical service line, and in flight collision with terrain.
- [NTSB CHI84LA389](https://openairdocs.org/ntsb/CHI84LA389.md): Denil Sonera II · De Pere, WI · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1984 · N2265N · Substantial damage
  > Plt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.

## 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.engine_model_code IN ('63501')
    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?engine=63501&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.
