# NTSB investigations: AiResearch TPE331 series: 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 DEN03LA075](https://openairdocs.org/ntsb/DEN03LA075.md): Mitsubishi MU-2B-60 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Apr 18, 2003 · N157CA · Substantial damage
  > the pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.
- [NTSB NYC02LA047](https://openairdocs.org/ntsb/NYC02LA047.md): Swearingen SA-227-AT · Covington, KY · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 2002 · N556UP · Substantial damage
  > the tug driver's inadequate visual lookout which resulted in his failure to see the airplane in time to prevent the collision.
- [NTSB MIA94LA166](https://openairdocs.org/ntsb/MIA94LA166.md): British Aerospace BAE 3201 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jun 24, 1994 · N495UE · Substantial damage
  > Inadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.
- [NTSB NYC92LA083](https://openairdocs.org/ntsb/NYC92LA083.md): Fairchild SA-227AC · Lexington, KY · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1992 · N27465 · Substantial damage
  > Attempted suicide by the vehicle driver.
- [NTSB NYC90LA066](https://openairdocs.org/ntsb/NYC90LA066.md): Mitsubishi MU-2B-35 · Teterboro, NJ · Accident · No injuries · Limited investigation · Final report · Feb 9, 1990 · N349MA · 2 aircraft · Substantial damage
  > The pilot of N349MA failed to see and avoid another airplane taxiing in the same direction.
- [NTSB FTW86LA120](https://openairdocs.org/ntsb/FTW86LA120.md): Beech E18S · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Jun 24, 1986 · N2001C · 2 aircraft · Minor damage
  > A swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…
- [NTSB ATL85LA076](https://openairdocs.org/ntsb/ATL85LA076.md): Beech C90 · Winston Salem, NC · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N66KA · Substantial damage
  > During takeoff roll, at rotation, acft contacted a large dog which was on the rwy. Plt had good visibility except for light condition. Acdt occurred at night. Arpt perimeter is fenced but there are many gates, some of which remain open at night. Many dogs…

## 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 ('01514', '01517')
    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?engine=01514&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.