# NTSB investigations: Limbach LIMBACH L2000

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 CEN21LA407](https://openairdocs.org/ntsb/CEN21LA407.md): Aeromot AMT-100 · Menomonie, WI · Accident · No injuries · Class 4 · Limited · Final report · Sep 7, 2021 · N69FW · Substantial damage
  > The pilot’s failure to extend the landing gear.
- [NTSB NYC06IA229](https://openairdocs.org/ntsb/NYC06IA229.md): American Blimp A-60+ · Manchester, MA · Incident · No injuries · Incident investigation · Final report · Sep 26, 2006 · N614LG · Minor damage
  > A malfunction of the rudder control system, and the pilot's inadequate preflight inspection. Contributing to the incident was the inadequate design of the chain keeper guards.
- [NTSB NYC00LA108](https://openairdocs.org/ntsb/NYC00LA108.md): Sportavia Putzer RF-5B · Gillespie, PA · Accident · No injuries · Limited investigation · Final report · Apr 1, 2000 · N55GS · Substantial damage
  > The pilot's improper weather evaluation, resulting in a tailwind departure.
- [NTSB LAX88DVA04](https://openairdocs.org/ntsb/LAX88DVA04.md): Schumann KR-2 · Merced, CA · Accident · 1 fatal · Final report · May 2, 1988 · N127AS · Destroyed
  > The pilot was flight testing a new airplane that he had constructed. He had completed two touch and go landings. During a third approach, witnesses observed the airplane approaching the runway at a very high airspeed. The airplane touched down on the runway…
- [NTSB MIA88LA021](https://openairdocs.org/ntsb/MIA88LA021.md): Parrish Dragonfly · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1987 · N41GK · Substantial damage
  > While on short final approach the flight encountered a wind gust which caused the left canard to drop. The landing gear on the left canard then struck the raised lip of the runway causing substantial damage. The aircraft came to rest on the runway.

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

This list as a web page: https://openairdocs.org/ntsb?engine=38601

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