# NTSB investigations: Revmaster 2100, FL

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 ERA13LA119](https://openairdocs.org/ntsb/ERA13LA119.md): Shoemaker James B KR-2 · Palmetto, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 2013 · N27CE · Substantial damage
  > The total loss of engine power for undetermined reasons, which resulted in a forced landing.
- [NTSB MIA96LA001](https://openairdocs.org/ntsb/MIA96LA001.md): Clapp KR-2 · Jacksonville, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1995 · N2CC · Destroyed
  > The pilot's inadequate preflight planning/preparation, failure to ensure proper weight and balance of the airplane, and failure to obtain or maintain sufficient airspeed during takeoff, which resulting in a stall and collision with wooded terrain.
- [NTSB MIA90FA043](https://openairdocs.org/ntsb/MIA90FA043.md): Tundermann Venne Q-2 · Zephyrhills, FL · Accident · Serious injuries · Field investigation · Final report · Dec 27, 1989 · N1UQ · Destroyed
  > Loss of engine power for undetermined reasons.
- [NTSB MIA86FA097](https://openairdocs.org/ntsb/MIA86FA097.md): Mcfarland Quickie 2 · Mulberry, FL · Accident · 2 fatal · Field investigation · Final report · Mar 15, 1986 · N335RM · Destroyed
  > Witnesses reported that the acft was flying at a lower than normal altitude and at full throttle when something broke off the acft. The acft then rolled to the right, went almost straight up and spiraled down striking the ground inverted. Post crash…

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

This list as a web page: https://openairdocs.org/ntsb?engine=52550&state=FL

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