NTSB investigations, 2016
7 cases where NTSB found Airport structure.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 7 |
| 2019 | 3 |
| 2020 | 5 |
| 2022 | 2 |
| 2023 | 2 |
| 2025 | 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\", '03022042'))
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", '03022042')) 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 GAA16CA447Accident · No injuriesData collectionFinal reportCessna 172 · Williamsport, PAThe student pilot's distraction during taxi operations, which resulted in the airplane's left wing impacting a hangar.NTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.NTSB ERA16CA264Accident · Serious injuriesData collectionFinal reportAeronca 7BCM · Connellsville, PAThe pilot's failure to properly set the throttle and secure the airplane before hand-propping the engine for startup.NTSB GAA16CA377Accident · No injuriesData collectionFinal reportPiper PA 44 · Keene, NHThe flight instructor’s failure to use carburetor heat during the approach while operating in atmospheric conditions that were conducive to carburetor icing, which resulted in a loss of engine power due to carburetor icing.NTSB GAA16CA284Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Ferndale, MTThe pilot's loss of directional control during takeoff resulting in a decision to rotate early, and a collision with a hangar and subsequent fire.NTSB GAA16CA216Accident · No injuriesData collectionFinal reportAirborne Redback · Arlington, WAThe pilot's failure to adequately secure the aircraft while manually starting the engine from outside the cockpit, which resulted in the unmanned aircraft becoming airborne and colliding with a hangar roof.NTSB GAA16CA348Accident · No injuriesData collectionFinal reportBeech B200 · Carolina, PRThe pilot's failure to actuate the parking brake prior to leaving his seat, resulting in substantial damage.