# NTSB investigations, MS: 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 ERA10CA112](https://openairdocs.org/ntsb/ERA10CA112.md): Bellanca 7ECA · Calhoun City, MS · Accident · No injuries · Data collection · Final report · Mar 19, 2007 · N90923 · Substantial damage
  > The pilot's failure to maintain clearance from a fallen tree located off the right side of the runway during takeoff.
- [NTSB DFW06CA005](https://openairdocs.org/ntsb/DFW06CA005.md): Cessna 152 · Tupelo, MS · Accident · No injuries · Data collection · Final report · Oct 5, 2005 · N94684 · Substantial damage
  > The pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.
- [NTSB MIA00LA182](https://openairdocs.org/ntsb/MIA00LA182.md): Piper PA-38-112 · Steens, MS · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 2000 · N9423T · Substantial damage
  > the flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.
- [NTSB ATL97LA007](https://openairdocs.org/ntsb/ATL97LA007.md): Piper PA-28R-200 · Olive Branch, MS · Accident · No injuries · Limited investigation · Final report · Oct 16, 1996 · N16413 · Substantial damage
  > The farmer's failure to maintain security of his livestock/animals.
- [NTSB MIA95LA170](https://openairdocs.org/ntsb/MIA95LA170.md): Piper PA-23-250 · Winstonville, MS · Accident · No injuries · Limited investigation · Final report · Jul 4, 1995 · N6323Y · Substantial damage
  > Poor preflight planning/preparation and clearance not maintained by the pilot in command.
- [NTSB MIA95LA001](https://openairdocs.org/ntsb/MIA95LA001.md): Cessna 152 · Greenwood, MS · Accident · No injuries · Limited investigation · Final report · Oct 3, 1994 · N65454 · Substantial damage
  > The student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…
- [NTSB MIA89LA025](https://openairdocs.org/ntsb/MIA89LA025.md): Piper PA-31-350 · Tupelo, MS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1988 · N637JC · 2 aircraft · Substantial damage
  > The Cessna plt was taxiing his acft on a marked taxiway when he observed a Piper PA-31-350 (chieftain) entering the taxiway ahead of his acft. The Cessna plt applied the brakes & stated the acft was stopped for 3-4 seconds before the left wing of the Piper…

## 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."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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?occurrence=310&state=MS

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