NTSB investigations, 2011
6 cases where NTSB found Hydraulic power system.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 8 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 2 |
| 2026 | 2 |
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\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010229'))
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") = 2011 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010229')) 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 ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB CEN11IA379Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIThe failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…NTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.NTSB WPR11GA144Accident · Minor injuriesFinal reportEurocopter AS 350 B2 · Riverside, CAThe failure of both pilots to follow proper procedures during a simulated hydraulic emergency that resulted in a loss of helicopter control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN11FA193Accident · No injuriesField investigationFinal reportGulfstream Aerospace GV-SP · Appleton, WIThe pilot flying's (PF) decision to land on a shorter-than-recommended runway with a known left hydraulic system failure rather than go around as suggested by the pilot-not-flying, his failure to immediately apply emergency brakes following the detection of…NTSB ERA11FA133Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 Magister · Kissimmee, FLThe pilot/mechanic's improper decision to continue a tight-turning landing pattern after a loss of hydraulic pressure, and his subsequent failure to maintain adequate airspeed during that pattern, which resulted in an accelerated maneuver stall. Contributing…