NTSB investigations, 2016
5 cases where NTSB found Policy/procedure.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 11 |
| 2010 | 10 |
| 2011 | 7 |
| 2012 | 13 |
| 2013 | 8 |
| 2014 | 16 |
| 2015 | 8 |
| 2016 | 5 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 7 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 6 |
| 2023 | 3 |
| 2024 | 8 |
| 2025 | 3 |
| 2026 | 2 |
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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '040210'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040210')) 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 GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB DCA17MA022Accident · No injuriesMajor investigationFinal reportMcdonnell Douglas MD 10-10F · Fort Lauderdale, FLThe failure of the left main landing gear (MLG) due to fatigue cracking that initiated at a corrosion pit. The pit formed in the absence of a required protective cadmium coating the cause of which could not be determined from available evidence. Contributing…NTSB ANC17MA001Accident · 3 fatalClass 1 · MajorFinal reportCessna 208B · Togiak, AKThe flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…NTSB WPR16LA185Accident · Minor injuriesLimited investigationFinal reportHoover David Arnold AR 6 · Reno, NVThe pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…NTSB ERA16LA225Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Punta Gorda, FLThe tower controller’s failure to identify and mitigate jet blast from an airplane conducting an engine test run, and the effect of the jet blast on landing traffic, which resulted in a runway excursion when a landing airplane encountered the blast.…