NTSB investigations: Eurocopter EC 130 B4, 2007
5 cases on aircraft the registry lists as Eurocopter EC 130 B4. 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
| 2004 | 2 |
|---|---|
| 2005 | 1 |
| 2007 | 5 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2017 | 3 |
| 2018 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680989'))
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") = 2007
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680989'))
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 SEA08CA027Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Meadview, AZThe downward flexing of the standing helicopter's main rotor blades and subsequent impact with its tail boom as a result of another helicopter's rotor blade's vortices. .NTSB DFW08CA010Accident · No injuriesData collectionFinal reportEurocopter EC 130 · Bay St Louis, MSThe pilot's encounter with dynamic rollover as result of his inadequate preflight inspection.NTSB LAX07LA281Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Meadview, AZCollision with a bird during cruise flight.NTSB MIA07FA116Accident · No injuriesField investigationFinal reportEurocopter EC 130 B4 · New York, NYThe fatigue fracture and in-flight separation of a 20-inch section of the blue composite main rotor blade trailing edge, aft of the spar, due to inadequate manufacture, and the manufacturer’s subsequent failure to detect an out-of-specification deviation in…NTSB SEA07LA110Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Makawao, HIThe pilot's improper decision to takeoff downwind in a confined landing zone, which resulted in a failure to attain translational lift and a loss of control.