Final NTSB investigations: Bell - K Copter 47D1
13 cases on aircraft the registry lists as Bell - K Copter 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
| 1969 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1988 | 1 |
| 1991 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1180843'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1180843'))
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 CHI91FA294Accident · 3 fatalField investigationFinal reportBell-K Copter 47D1 · Laurie, MOPoor judgement of the pilot, due to impairment from consumption of alcoholic beverage before flight, his intentional buzzing, and his inadequate visual lookout (failure to see-and-avoid power lines).NTSB MKC88FA054Accident · 1 fatalField investigationFinal reportBell 47D1 · Nixa, MODuring the process of moving the helicopter from the hangar the right skid slipped off the concrete helipad and became stuck in the mud. The pilot attempted to dislodge the skid by bringing the aircraft to a hover. The left skid became airborne and contacted…NTSB FTW82DA198Accident · No injuriesFinal reportBell 47D1 · Jonesboro, ARAfter loading 40 gallons of herbicide on the aircraft the pilot attempted to lift off the back of the loading truck. The takeoff was normal; however, as the helicopter cleared the truck, it was not able to sustain a hover. The pilot then executed a running…NTSB MKC81DCQ43Accident · No injuriesClosedBell 47G-2 · Sublette, KSNTSB FTW81DPJ24Accident · No injuriesClosedBell 47D1 · Okeene, OKNTSB NYC76AN120Accident · 2 fatalClosedBell 47D1 · Brewster, NYNTSB MKC75FCQ52Accident · No injuriesClosedBell 47D1 · Holcomb, KSNTSB CHI75FEV31Accident · 1 fatalClosedBell 47D1 · Shawneetown, ILNTSB CHI72FEV35Accident · No injuriesClosedBell 47D1 · Fairfield, ILNTSB FTW72FPA09Accident · No injuriesClosedBell 47D1 · Carrollton, TXNTSB FTW71DQG51Accident · No injuriesClosedBell 47D1 · Hale Center, TXNTSB FTW70F0064Accident · No injuriesClosedBell 47D1 · Richardson, TXNTSB FTW69F0497Accident · No injuriesClosedBell 47D1 · Powell, TX