NTSB investigations, 2010
7 cases where NTSB found Equipment/furnishings.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 9 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 13 |
| 2013 | 17 |
| 2014 | 9 |
| 2015 | 7 |
| 2016 | 11 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 2 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 7 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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\") = 2010
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010225'))
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") = 2010 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010225')) 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 ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.NTSB WPR11IA019Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZThe overextension of the main cabin door due to difficulty opening the door because the power-assist motor cable was lodged within the main cabin door assembly.NTSB ANC10MA068Accident · 5 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Aleknagik, AKThe pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…NTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.NTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…NTSB CEN10LA240Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Fort Dodge, IAThe flight crew's inadequate separation from convective activity that resulted in serious injury to an unrestrained flight attendant.NTSB CEN10CA199Accident · Serious injuriesData collectionFinal reportCessna 172 · Lawton, OKThe private pilot's failure to maintain adequate airspeed, which resulted in a stall, and the failure of both pilots to initiate a go-around. Contributing to the severity of both pilots' injuries was the lack of available shoulder harnesses.