NTSB investigations: Bell 47D1
6 cases on aircraft the registry lists as Bell 47D1, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 2 |
| 1991 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1180802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1180802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.NTSB FTW91DRD05Accident · No injuriesFinal reportBell 47-D1 · Sun, LAThe total loss of power for undetermined reasons and the failure of the pilot to maintain rotor RPM. A factor was the lack of suitable terrain.NTSB NYC89LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G · Champion, NYThe pilot was unable to sustain flight due to a severe downdraft accompanied by a power loss at a low altitude.NTSB MIA88LA212Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ruleville, MSDuring an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…NTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.NTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.