Fatal NTSB investigations: Britten-Norman BN-2A
8 cases on aircraft the registry lists as Britten-Norman BN-2A. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2021 | 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.\"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 ('1520204'))
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."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 ('1520204'))
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 CEN22FA031Accident · 4 fatalClass 3 · FieldFinal reportBritten-Norman BN-2A · Beaver Island, MIThe pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB DCA90MA010Accident · 8 fatalMajor investigationFinal reportBritten-Norman BN-2 · Block Island, RIThe aircraft crashed for an undetermined reason, during an overwater flight on a dark (moonless) night under a cloud layer. A SIGMET was in effect warning of moderate to occasionally severe turbulence below 6000 feet and the potential of low level wind shear.NTSB SEA88FA167Accident · 1 fatalField investigationFinal reportBritten-Norman BN-2A · Sitka, AKThe pilot encountered low ceilings, rain and fog while attempting to fly through a narrow mountain pass and successfully reversed course. He then flew into a small canyon off the main pass that terminated in a small glacier-covered bowl surrounded by steep…NTSB ANC78FA012Accident · 1 fatalClosedBrittnorman BN-2A · Toksook Bay, AKNTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRNTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKNTSB MIA71AM024Accident · 1 fatalClosedBrittnorman BN-2A · Orocovis, PRNTSB MIA70A0031Accident · 2 fatalClosedBrittnorman BN-2A · Missing Aircraft