NTSB investigations, 2011
12 cases where the sequence of events included Aircraft inspection event.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 24 |
| 2011 | 12 |
| 2012 | 14 |
| 2013 | 15 |
| 2014 | 15 |
| 2015 | 14 |
| 2016 | 10 |
| 2017 | 12 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 12 |
| 2021 | 15 |
| 2022 | 12 |
| 2023 | 14 |
| 2024 | 15 |
| 2025 | 12 |
| 2026 | 3 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ENG12IA013Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver International Airport, COA failure of the nose landing gear end cap due to fatigue. Contributing to the failure were the ineffective inspection and the unknown effect of grain direction on fatigue life.NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.NTSB CEN12CA003Accident · Serious injuriesData collectionFinal reportSadler Terry Rans S-7 Courier · Riley, KSA total loss of engine power during takeoff due to fuel starvation as a result of the pilot’s inadequate preflight inspection and failure to ensure that the fuel shutoff valve was turned on before departure.NTSB CEN11CA633Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Damon, TXThe pilot’s improper fuel management during cruise flight, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR11LA352Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Troutdale, ORThe in-flight separation of the tail rotor drive shaft cover as a result of maintenance personnel not ensuring that it was secured after a maintenance inspection; also causal was the pilot’s inadequate preflight inspection of the helicopter.NTSB CEN11LA414Accident · No injuriesLimited investigationFinal reportEnstrom F-28C-2 · Blair, NEThe failure of a tail rotor pitch change link due to the retaining bolt becoming separated in flight. Contributing to the accident was the pilot’s inadequate preflight inspection.NTSB WPR11LA266Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mount Pleasant, UTThe pilot’s failure to determine the airplane’s fuel quantity before takeoff, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…NTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.NTSB WPR11LA202Accident · No injuriesLimited investigationFinal reportRans S-12 · Marana, AZThe pilot's failure to conduct an adequate preflight inspection, which resulted in a loss of engine coolant during climb due to an unsecured tank cap. Contributing to the accident was the pilot's failure to use available engine power to ensure a landing on an…NTSB CEN11IA156Incident · No injuriesIncident investigationFinal reportSikorsky 92 · Galliano, LAThe misalignment of the retaining washer during routine maintenance, resulting in the subsequent separation of the washer and nut.NTSB ERA11IA172Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-20 · Walterboro, SCThe inadequate inspection and rigging of the nose landing gear downlock mechanism by maintenance personnel, which resulted in the failure of a bolt and the subsequent collapse of the nose gear during the landing roll.