# NTSB investigations: Revmaster 2100, 2006

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 LAX06LA266](https://openairdocs.org/ntsb/LAX06LA266.md): Saloff Sonerai Iilt · Williams, AZ · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2006 · N90420 · Minor damage
  > the pilot's inadequate compensation for the wind conditions and failure to maintain directional control.
- [NTSB SEA06LA040](https://openairdocs.org/ntsb/SEA06LA040.md): Holscher KR II · McNeil Island, WA · Accident · No injuries · Limited investigation · Final report · Jan 8, 2006 · N395JT · Substantial damage
  > Fuel exhaustion while in cruise flight due to inaccurate fuel quantity indications. Factors included the pilot's failure to positively determine the quantity of fuel onboard the aircraft during preflight, and rough, uneven grassy terrain at the location where…

## 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 year(c."eventDate") = 2006
  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&year=2006

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