# NTSB investigations: Amateur-built UNKNOWN ENG, MS

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 ERA15LA077](https://openairdocs.org/ntsb/ERA15LA077.md): Thomas R Wade Revelation · Ellisville, MS · Accident · No injuries · Limited investigation · Final report · Dec 13, 2014 · N783QJ · Substantial damage
  > The failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…
- [NTSB ERA12CA588](https://openairdocs.org/ntsb/ERA12CA588.md): Henrie Raymond Zenith CH 701 Stol · Ashland, MS · Accident · Minor injuries · Data collection · Final report · Sep 29, 2012 · N234RH · Substantial damage
  > The pilot’s inadequate compensation for crosswind conditions during initial climb, which resulted in an impact with trees and terrain.
- [NTSB ERA12LA258](https://openairdocs.org/ntsb/ERA12LA258.md): Rotorcraft Developement OH-58C · McComb, MS · Accident · No injuries · Limited investigation · Final report · Mar 27, 2012 · N452MC · Substantial damage
  > A total loss of engine power due to oil starvation at the Nos. 5 and 8 engine bearings, which resulted in a catastrophic engine failure.
- [NTSB ANC05LA033](https://openairdocs.org/ntsb/ANC05LA033.md): Twente Pitts Model 12 · Marion, MS · Accident · 2 fatal · Limited investigation · Final report · Feb 12, 2005 · N20GT · Destroyed
  > The pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…
- [NTSB ATL04IA010](https://openairdocs.org/ntsb/ATL04IA010.md): Beech 58 · Columbus, MS · Incident · No injuries · Incident investigation · Final report · Oct 1, 2003 · N7219H · Minor damage
  > The pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.
- [NTSB MIA03FA122](https://openairdocs.org/ntsb/MIA03FA122.md): Piper PA-32R-301 · Carthage, MS · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2003 · N232HC · Destroyed
  > The failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…
- [NTSB ATL01LA031](https://openairdocs.org/ntsb/ATL01LA031.md): Sorrell SNS-2 Guppy · Raymond, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2001 · N6334F · Destroyed
  > The failure of the rudder horn bracket, that resulted in the inflight loss of control.
- [NTSB MIA93LA196](https://openairdocs.org/ntsb/MIA93LA196.md): Sukhoi SU-26M · Natchez, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1993 · N26CY · Substantial damage
  > The pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.
- [NTSB ATL84FA241](https://openairdocs.org/ntsb/ATL84FA241.md): Cessna 337A · Ocean Springs, MS · Accident · Serious injuries · Field investigation · Final report · Aug 3, 1984 · N90244 · Destroyed
  > The acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…
- [NTSB MIA78FKQ05](https://openairdocs.org/ntsb/MIA78FKQ05.md): N.American P-51 · Ellisville, MS · Accident · No injuries · Closed · Feb 15, 1978 · N117E · Substantial damage
- [NTSB MIA72IM084](https://openairdocs.org/ntsb/MIA72IM084.md): Martin 404 · Columbus, MS · Incident · No injuries · Closed · Feb 21, 1972 · N259S · Minor damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=99999&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.