NTSB investigations: Bell 47D1, GA
9 cases on aircraft the registry lists as Bell 47D1. 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1998 | 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\" = 'GA' 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 ('1180802'))
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" = 'GA' 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 ('1180802'))
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 MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.NTSB ATL92LA017Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Rome, GAThe failure of a tail rotor blade for undetermined reasons.NTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.NTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.NTSB ATL83LA315Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAAfter completing a swath run, the plt pulled up, made a turn, then started a let down for another pass. As he increased power, the eng RPM went from 3000 to 3100. At the same time, the plt heard a whining noise and noted that the rotor RPM was decreasing. The…NTSB MIA79FLA48Accident · No injuriesClosedBell 47D1 · Hahira, GANTSB MIA78FKG74Accident · No injuriesClosedBell 47D1 · Hartwell, GANTSB MIA77DKG41Accident · No injuriesClosedBell 47-D1 · Berlin, GANTSB MIA77DKG08Accident · No injuriesClosedBell 47D1 · Vanceville, GA