NTSB investigations: Britten-Norman BN-2A-8
11 cases on aircraft the registry lists as Britten-Norman BN-2A-8. 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
| 1974 | 1 |
|---|---|
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1984 | 2 |
| 1997 | 1 |
| 2013 | 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 ('1520209'))
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 ('1520209'))
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 ERA14LA007Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-8 · Culebra, PRThe pilot's failure to maintain airplane control for reasons that could not be determined because the wreckage was not recovered.NTSB ATL97FA113Accident · Serious injuriesField investigationFinal reportPilatus BN-2 Islander · Fajardo, PRThe pilot's failure to maintain adequate visual lookout.NTSB MIA85FA059Accident · No injuriesField investigationFinal reportBritten-Norman BN-2 · San Juan, PRAfter landing the flt was directed by ground control to taxi to the cargo ramp making room for a taxiing Boeing 747. Ground control then asked the acft to make a 180 deg turn and taxi further east on the ramp. As the left turn was completed the right brake…NTSB NYC84LA103Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-8 · Tobyhanna, PAThe acft made a precautionary landing on a highway after both engines lost oil pressure. The plt feathered the right propeller because it gave abnormal indications before the left engine. The left engine was still operating at touchdown post accident…NTSB ANC82DA057Accident · No injuriesFinal reportBritten-Norman BN-2A · Nome, AKDuring the takeoff roll, a propeller blade tip failure occurred on the left engine. About 9 inches of the blade tip separated and entered the top side of the fuselage about 1 ft behind the pilot's head. The blade tip severed the throttle, fuel mixture,…NTSB MIA79FLG04Accident · Minor injuriesClosedBrittnorman BN-2A · Beaufort, SCNTSB MIA77FA024Accident · No injuriesClosedBrittnorman BN2A-8 · St.Thomas, VINTSB ANC76AA073Accident · No injuriesClosedBrittnorman BN-2 · Bethel, AKNTSB MIAMLAM050Accident · Minor injuriesClosedBrittnorman BN-2A · St Thomas, VINTSB MIA75AM024Accident · Minor injuriesClosedBrittnorm BN-2A · San Juan, PRNTSB MIA75AM025Accident · No injuriesClosedBrittnorman BN-2A · St Thomas, VI