NTSB investigations, 2016
5 cases where NTSB found Residence/building.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 6 |
| 2014 | 3 |
| 2015 | 9 |
| 2016 | 5 |
| 2017 | 8 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2026 | 1 |
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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022022'))
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", '03022022')) 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 CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ANC16CA058Accident · No injuriesData collectionFinal reportPiper J5A · Sterling, AKThe pilot's improper fuel management, which led to fuel exhaustion and a subsequent forced landing on a road too narrow for the airplane.NTSB GAA16CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Stamford, TXThe pilot's failure to maintain clearance from a hangar during taxi for departure.NTSB ERA16LA228Accident · Serious injuriesLimited investigationFinal reportAmerican AA1 · Knoxville, TNThe pilot's failure to maintain directional control during the landing roll in a quartering headwind.NTSB CEN16LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA 24 · Houston, TXThe total loss of engine power due to fuel exhaustion.