NTSB investigations: Bell 47D1, AR

10 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

NTSB investigations: Bell 47D1, AR per year, 1964–2026: 10 cases
1964	1
1967	1
1972	1
1973	1
1974	1
1976	1
1977	1
1982	1
1990	1
1991	1

Where

Open the map

Latest cases

Query with SQL

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" = 'AR' 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

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\" = 'AR' 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" = 'AR' 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

Run 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 FTW91LA091Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Peach Orchard, ARThe pilot's failure to maintain adequate main rotor RPM resulting in deteriorated helicopter performance. A factor was the tailwind condition.Jun 5, 1991 · N8117 · Substantial damage NTSB MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.Jul 12, 1990 · N8117 · Substantial damage NTSB FTW82DA189Accident · No injuriesFinal reportBell 47D-1 · Harrisburg, ARDuring an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…May 20, 1982 · N93067 · Substantial damage NTSB FTW77DPG53Accident · No injuriesClosedBell 47D1 · Alicia, ARJun 29, 1977 · N10190 · Substantial damage NTSB FTW76FPG68Accident · Serious injuriesClosedBell 47B · Ravenden, ARJun 17, 1976 · N163B · Substantial damage NTSB FTW75DPG02Accident · No injuriesClosedBell 47D-1 · Almyra, ARJul 6, 1974 · N13012 · Substantial damage NTSB FTW74DPG10Accident · No injuriesClosedBell 47G · Black Rock, ARAug 9, 1973 · N163B · Substantial damage NTSB FTW73DPG34Accident · No injuriesClosedBell 47D · Plumerville, ARSep 20, 1972 · N925V · Substantial damage NTSB FTW68A0032Accident · No injuriesClosedBell 47D1 · Russellville, ARSep 18, 1967 · N903B · Substantial damage NTSB UNK64X2222Accident · No injuriesClosedBell 47D1 · Harrisburg, ARJun 10, 1964 · N322A · Substantial damage