NTSB investigations: Bell 47D1, OK
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
| 1974 | 1 |
|---|---|
| 1979 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 2001 | 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\" = 'OK' 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" = 'OK' 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 FTW02LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Ardmore, OKthe flight instructor's selection of an unsuitable area for practicing a full touchdown autorotation, which resulted in a nose over. A contributing factor was the soft ground.NTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.NTSB FTW95FA181Accident · 2 fatalField investigationFinal reportBell 47D1 · Ardmore, OKInflight collision with a power transmission array static line when the flight instructor and dual (private pilot) student failed to maintain adequate visual lookout.NTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.NTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…NTSB FTW85LA074Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe acft collided with power lines during a recovery from a practice autorotational landing. The instructor plt took control of the acft for recovery and did not see the wires.NTSB FTW79DPJ37Accident · No injuriesClosedBell 47D1 · Ardmore, OKNTSB FTW74FPM29Accident · No injuriesClosedEL Tomcat 47 · Zafra, OK