# Fatal NTSB investigations: Britten-Norman BN2A-26 ISLANDER

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 SEA91FA216](https://openairdocs.org/ntsb/SEA91FA216.md): Pilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AK · Accident · 4 fatal · Field investigation · Final report · Aug 20, 1991 · N68HA · Destroyed
  > The pilot's attempting to operate VFR in instrument meteorological conditions. Factors contributing to the accident were upsloping terrain in the aircraft's flight path as well as weather conditions resulting in an obscuration of the terrain.
- [NTSB LAX88FA065](https://openairdocs.org/ntsb/LAX88FA065.md): Britten-Norman BN2A-26 · Desert Center, CA · Accident · 2 fatal · Field investigation · Final report · Oct 31, 1987 · N25MR · Destroyed
  > The plt was hired to ferry an islander from el paso, TX to santa paula, CA. He represented himself to the ferry company as being an experienced islander plt. No previous islander flt time was found in the pilot's logbook. It was the plt's 40th birthday & he…

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1520226'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=1520226

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