NTSB investigations: Brantly B-2B, TX

9 cases on aircraft the registry lists as Brantly B-2B. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Brantly B-2B, TX per year, 1965–2026: 9 cases
1965	1
1967	1
1984	1
1988	1
1994	1
2004	1
2006	1
2008	1
2010	1

Where

Open the map

Latest cases

Query with 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" = 'TX' 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 ('1440506')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'TX' 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 ('1440506'))
  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."eventStateOrRegion" = 'TX' 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 ('1440506'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN11LA067Accident · 1 fatalLimited investigationFinal reportBrantly B-2B · Post, TXThe pilot's decision to operate the helicopter over the maximum gross weight and forward of the recommended center of gravity.Nov 14, 2010 · N2268U · Substantial damage NTSB CEN09CA068Accident · No injuriesData collectionFinal reportBrantly B-2B · Cedar Hill, TXThe pilot's improper decision to takeoff downwind. A contributing factor was the gusty conditions.Nov 20, 2008 · N2180U · Substantial damage NTSB DFW06CA217Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Carrizo Springs, TXThe loss of engine power due to a malfunction of the electric fuel pump. A contributing factor was the lack of suitable terrain for the forced landing.Sep 29, 2006 · N888CF · Substantial damage NTSB FTW04LA111Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Holliday, TXThe failure of the upper tail rotor shaft due to excessive misalignment after two hard landings. Also causal was the manufacturer's failure to provide specific maintenance procedures for checking the alignment of the upper tail rotor shaft.Apr 21, 2004 · N9030Z · Substantial damage NTSB FTW95LA029Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Tomball, TXA partial power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Oct 24, 1994 · N2166U · Substantial damage NTSB FTW88LA073Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Decatur, TXThe non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…Feb 27, 1988 · N2233U · Substantial damage NTSB FTW84LA381Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Alvin, TXThe helicopter experienced an unexplained power loss. An emergency landing was attempted but the helicopter collided with a ditch. Lacking sufficient rotor RPM for efective control the helicopter nosed over. The plt was mailed an NTSB 6120.1 form to complete…Sep 8, 1984 · N2161U · Destroyed NTSB FTW67A0088Accident · No injuriesClosedBrantly B-2B · Mansfield, TXMar 3, 1967 · N2189U · Substantial damage NTSB FTW65A0098Accident · No injuriesClosedBrantly B2B · Amarillo, TXMar 28, 1965 · N2264U · Substantial damage