NTSB investigations, 2015
13 cases where NTSB found Knowledge.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 8 |
| 2010 | 8 |
| 2011 | 10 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 8 |
| 2015 | 13 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 12 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 7 |
| 2022 | 16 |
| 2023 | 16 |
| 2024 | 15 |
| 2025 | 11 |
| 2026 | 5 |
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\") = 2015
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020320'))
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") = 2015 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020320')) 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 GAA16CA102Accident · No injuriesData collectionFinal reportPiper PA 18A · Girdwood, AKFuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.NTSB ANC16LA010Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Valdez, AKThe overhaul facility’s improper and excessive use of an approved lubricant during overhaul of the fuel injection servo, which resulted in a disruption of fuel flow and a total loss of engine power.NTSB CEN16FA011Accident · 2 fatalField investigationFinal reportBeech G35 · Eaton, COThe pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…NTSB ANC15CA072Accident · No injuriesData collectionFinal reportCessna 150D · Delta Junction, AKThe pilots decision to land on an unfamiliar, unimproved airstrip which resulted in a loss of control and runway excursion.NTSB WPR15LA253Accident · No injuriesLimited investigationFinal reportBeech C90 · Las Vegas, NVThe jet flight crew's use of an inappropriate checklist to resolve a parking brake hydraulic system pressure anomaly, which resulted in the airplane rolling down a slight incline and colliding with a parked twin-engine turboprop airplane. Contributing to the…NTSB ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.NTSB GAA15CA143Accident · No injuriesData collectionFinal reportAventura II · Fenton, MIThe failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.NTSB GAA15CA153Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Mackay, IDThe student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.NTSB CEN15FA189Accident · 1 fatalField investigationFinal reportCessna 152 · Batesville, ARThe noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…NTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.NTSB ANC15CA012Accident · No injuriesData collectionFinal reportBell 206B · Palmer, AKThe pilot's failure to maintain control while hovering at a low altitude, which resulted in an impact with frozen lake ice. Contributing to the accident was the pilot's decision to operate the helicopter from the left seat contrary to the rotorcraft flight…NTSB CEN15FA135Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Lubbock, TXThe pilot's loss of airplane control due to spatial disorientation and light ice accumulation while operating in night, instrument meteorological conditions with gusting wind.NTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…