NTSB investigations: Britten-Norman BN2A-26 ISLANDER
8 cases on aircraft the registry lists as Britten-Norman BN2A-26 ISLANDER. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1987 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1997 | 2 |
| 2002 | 1 |
| 2007 | 1 |
| 2014 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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 ('1520226'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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 ('1520226'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA14LA465Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A · Ceiba, PRThe pilot’s loss of consciousness during taxi for reasons that could not be determined based on the available information.NTSB ANC07CA049Accident · No injuriesData collectionFinal reportBritten-Norman BN2A26 · Egegik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage during the landing roll when the airplane encountered soft sand.NTSB ANC02LA012Accident · No injuriesLimited investigationFinal reportBritten-Norman BN2A-26 · Ouzinkie, AKThe pilot's selection of unsuitable terrain for takeoff. Factors associated with the accident are a slush covered runway, and rough/uneven terrain.NTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.NTSB DCA97WA032Accident · Serious injuriesForeign investigationBritten-Norman BN2A-26 · Paseo Las Palma, Costa RicaNTSB SEA91FA216Accident · 4 fatalField investigationFinal reportPilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AKThe 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 NYC90FA110Accident · No injuriesField investigationFinal reportBritten-Norman BN2A-2F · Blue Bell, PAThe close proximity of the road to the threshold of the runway. Factors contributing to the accident were the obstruction to the driver's vision caused by trees and buildings.NTSB LAX88FA065Accident · 2 fatalField investigationFinal reportBritten-Norman BN2A-26 · Desert Center, CAThe 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…