# NTSB investigations: Alon A2, 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 ATL04LA100](https://openairdocs.org/ntsb/ATL04LA100.md): Alon A2 · Fort Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 2004 · N5674F · Substantial damage
  > The loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.
- [NTSB MIA84LA249](https://openairdocs.org/ntsb/MIA84LA249.md): Alon A2 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N5609F · Substantial damage
  > The acft collided with mail boxes during a forced landing after the engine failed. The plt said he lost all engine powerwhile climbing through 1800 ft AGL. Post crash inspection of the engine revealed that the gasket on the fuel transfer pump bowl had failed.…
- [NTSB MIA69D0292](https://openairdocs.org/ntsb/MIA69D0292.md): Alon A-2 · Vero Beach, FL · Accident · No injuries · Closed · Nov 9, 1968 · N5652F · Substantial damage
- [NTSB MIA69F0106](https://openairdocs.org/ntsb/MIA69F0106.md): Alon A-2 · Tampa, FL · Accident · No injuries · Closed · Aug 25, 1968 · N5691F · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=0540102&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.