NTSB investigations, 2017
7 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\") = 2017
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") = 2017 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 ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB ERA17FA135Accident · 1 fatalField investigationFinal reportCessna 500 · Marietta, GAThe pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…NTSB GAA17CA179Accident · No injuriesData collectionFinal reportBurkhart Grob G 109B · Mokuleia, HIThe failure of the upper rudder hinge during flight due to severe corrosion. Contributing to the accident were the pilot’s inadequate preflight inspection and the lack of an annual inspection.NTSB GAA17CA135Accident · No injuriesData collectionFinal reportHughes OH 6A · Price, UTThe fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.NTSB CEN17FA100Accident · 1 fatalField investigationFinal reportBell 206B · Galveston, TXThe pilot's failure to recognize the flight had encountered instrument meteorological conditions at night, which resulted in an unrecognized descent and collision with water.