# NTSB investigations: U/A Canada PT6A series: 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 MIA05LA096](https://openairdocs.org/ntsb/MIA05LA096.md): de Havilland DHC-6 · Deland, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 23, 2005 · N24HV · Substantial damage
  > The pilot's inadequate visual lookout.
- [NTSB ATL04FA045](https://openairdocs.org/ntsb/ATL04FA045.md): Beech B200 · Morlan, GA · Accident · 2 fatal · Field investigation · Final report · Dec 5, 2003 · N85BK · Destroyed
  > The pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.
- [NTSB CHI03IA108](https://openairdocs.org/ntsb/CHI03IA108.md): Piper PA-31T1 · Wheeling, IL · Incident · No injuries · Incident investigation · Final report · Apr 17, 2003 · N855JL · Minor damage
  > The pilot's failure to maintain obstacle clearance and the inadequate glidepath which resulted in a collision with a utility pole. Contributing factors were the lack of experience in the incident airplane by the left seat pilot, the visual illusion of a…
- [NTSB ATL86FA032](https://openairdocs.org/ntsb/ATL86FA032.md): Beech C90 · East Greenwich, RI · Accident · 2 fatal · Field investigation · Final report · Nov 27, 1985 · N220F · Destroyed
  > The acft crashed about nine miles short of the rwy during an ILS approach to warwick, RI in IMC wx. The acft had been cleared to descend from 13000 to 3000 ft. the acft crashed outside the outer marker. The co-plt had reported the acft as inside the outer…

## 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 ('61508')
    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=61508&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.