NTSB investigations: Bell 407, 2012
7 cases on aircraft the registry lists as Bell 407. 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
| 1997 | 2 |
|---|---|
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 4 |
| 2003 | 8 |
| 2004 | 5 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 3 |
| 2012 | 7 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 1 |
| 2017 | 4 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 6 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 3 |
| 2026 | 5 |
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\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182206'))
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") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182206'))
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 WPR13IA059Incident · No injuriesIncident investigationFinal reportBell 407 · Riverton, WYThe pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.NTSB ERA13FA014Accident · 2 fatalField investigationFinal reportBell 407 · Coolbaugh Township, PAThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.NTSB CEN13FA003Accident · 1 fatalField investigationFinal reportBell 407 · Intracoastal City, LAThe pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.NTSB ERA12TA538Accident · Minor injuriesFinal reportBell 407 · Bath, NYThe pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB CEN12IA518Incident · No injuriesIncident investigationFinal reportBell 407 · San Antonio, TXThe pilot’s failure to maintain clearance from a tower guy wire during the approach to a helipad at night.NTSB CEN12LA242Accident · Minor injuriesLimited investigationFinal reportBell 407 · Aberdeen, SDThe fatigue failure of two turbine engine blades due to vibration.