NTSB investigations: Bell 212, 1983
4 cases on aircraft the registry lists as Bell 212. 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 |
|---|---|
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 4 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2006 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181420'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181420'))
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 ANC84FA017Accident · Serious injuriesField investigationFinal reportBell 212 · Nuiqsut, AKThe search & rescue flt had been dispatched from barrow to an acft accident site adjacent to the Nuiqsut arpt. Accordingto the plt, upon arriving at Nuiqsut at 300 ft AGL the visibility was 2-3 mi. They lined up with snow machines for a visual apch to the…NTSB SEA84LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Coos Bay, ORThe helicopter snagged a cable with its skid during takeoff and rolled over. The acft had landed for fuel and was takingoff after refueling when a cable attached to a fertilizer dispencer caught on the helicopter's skid. The acft rolled to the right and…NTSB FTW83LA327Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene IslandAfter making an apch to an off-shore oil well heliport, the plt believed the tail rotor was too close to a stairwell, so he made a peddle turn to the right. During the turn, the tail rotor blades contacted a crane. The crane was located about 15 ft from the…NTSB LAX83FA277Accident · 2 fatalField investigationFinal reportBell 212 · Goleta, CAThe plt stated that as he approached the oil rig & reduced power to start his descent from 500 ft, the tail rotor (t/r) pedals began to vibrate. The vibrations became worse with a further reduction of power to reduce airspeed. The plt then planned a descent…