# NTSB investigations: American Legend AL11

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 ERA24LA129](https://openairdocs.org/ntsb/ERA24LA129.md): American Legend AL11 · Fort Myers, FL · Accident · No injuries · Class 4 · Limited · Final report · Mar 3, 2024 · N729CJ · Substantial damage
  > The pilot’s failure to maintain directional control while landing with a crosswind.
- [NTSB DFW07CA072](https://openairdocs.org/ntsb/DFW07CA072.md): American Legend AL-11 · Dryden, TX · Accident · No injuries · Data collection · Final report · Feb 17, 2007 · N2480 · Substantial damage
  > The pilot's inadequate compensation for the existing crosswind conditions and failure to maintain proper runway alignment.
- [NTSB CHI06FA224](https://openairdocs.org/ntsb/CHI06FA224.md): American Legend AL11C · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Jul 30, 2006 · N848LC · Substantial damage
  > The failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…

## 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.aircraft_model_code IN ('060002N', '069002F'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=060002N

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