# NTSB investigations: Limbach LIMBACH L2000: In flight 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 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 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')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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