Fatal NTSB investigations: Bensen B-8M
12 cases on aircraft the registry lists as Bensen B-8M. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1986 | 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 ('1300516'))
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 ('1300516'))
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 FTW86FRG26Accident · 1 fatalFinal reportBenson B-8M · New Braunfels, TXThe acft crashed out of control after the eng stopped during a landing approach, the acft had almost completed the 1st pattern around the field when the eng stopped. Investigation revealed a 1/4 inch nylon rope wrapped and tied around the rotor blade about 30…NTSB ATL83LA264Accident · 1 fatalLimited investigationFinal reportBensen B8M · Somerville, TNThe acft crashed during takeoff while on a pleasure flight. A witness stated that he saw the acft take off and climb outat a gradual climb to about 100 ft and then start a gradual descent to about 30 ft. at which time the acft nosed over and went almost…NTSB CHI82FA234Accident · 1 fatalField investigationFinal reportGoans G-5 · Kankakee, ILThe pilot was making his first flight since a special airworthiness certificate was issued. This aircraft was unique in that the rotor controls were cable instead of push-pull rods. The aircraft after takeoff started pitching up and down. This pitching…NTSB MIA80FKJ27Accident · 1 fatalClosedBensen BTS8-M · Selma, ALNTSB FTW80FPM03Accident · 1 fatalClosedBenson B8M · Sand Springs, OKNTSB CHI75FET08Accident · 1 fatalClosedBensen B-8M · Roanoke, INNTSB MKC74FGG09Accident · 1 fatalClosedBensen B8 · Windsor, MONTSB NYC69F0242Accident · 1 fatalClosedBensen B8M · Mickleton, NJNTSB NYC69F0180Accident · 1 fatalClosedBensen B8M · Bridgeton, NJNTSB DIA69F0008Accident · 1 fatalClosedBensen B-8M · West Point, VANTSB CHI67A0125Accident · 1 fatalClosedBensen B-8M · Westland, MINTSB MIA67A0051Accident · 1 fatalClosedBensen B8M · Morrisville, NC