NTSB investigations, 2010
8 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\") = 2010
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") = 2010 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 WPR11TA083Accident · No injuriesFinal reportQuest Kodiak 100 · Reedsport, ORThe pilot's failure to maintain clearance from power lines during a low-level aerial observation flight. Contributing to the accident was pilot's failure to review a route hazards map prior to initiating the flight.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB ANC10LA065Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's decision to make a low-altitude pass over a remote airstrip toward rising terrain in weather conducive to downdrafts.NTSB CEN10CA342Accident · Minor injuriesData collectionFinal reportVans RV-12 · Salida, COThe pilot’s incorrect elevator trim setting and his inexperience in the airplane make/model.NTSB CEN10LA335Accident · No injuriesLimited investigationFinal reportCessna 525A · Storm Lake, IAThe pilot’s decision to land on a water contaminated runway, which resulted in a runway excursion during the landing roll. Contributing to the accident was the pilot’s lack of knowledge regarding the landing distance required and the limited braking…NTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.NTSB ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.NTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…