# NTSB investigations: Swearingen SA227-AC: On ground/water 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 MIA05LA084](https://openairdocs.org/ntsb/MIA05LA084.md): Swearingen SA227-AC · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 2005 · N811BC · Substantial damage
  > "This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.
- [NTSB FTW88IA055](https://openairdocs.org/ntsb/FTW88IA055.md): Swearingen SA227-AC · College Station, TX · Incident · No injuries · Incident investigation · Final report · Jan 20, 1988 · N3107P · Minor damage
  > The aircraft's nose gear struck a deer during the takeoff roll and the takeoff was aborted. The aircraft taxied back to the terminal and was examined by the flight crew. No damage was found. It then departed on its scheduled flight. It flew 18 flights during…
- [NTSB CHI83LA021](https://openairdocs.org/ntsb/CHI83LA021.md): Swearingen SA227-AC · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Oct 17, 1982 · N173MA · Substantial damage
  > The left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.

## 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 ('8780603')
    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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.