NTSB investigations: Brantly B-2B, MI
6 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.
Cases per year
| 1968 | 1 |
|---|---|
| 1986 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2013 | 1 |
| 2017 | 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.\"eventStateOrRegion\" = 'MI' 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" = 'MI' 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" 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 CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…NTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.NTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB CHI86LA134Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt Clemens, MIAfter aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…NTSB CHI69F0058Accident · Minor injuriesClosedBrantly B-2B · Grand Ledge, MI