NTSB investigations, 2016
4 cases where the sequence of events included Aircraft servicing event.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 9 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 7 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '020' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '020' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA17WA065Incident · No injuriesForeign investigationBoeing 737 · Adelaide, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the…NTSB DCA16CA211Accident · No injuriesData collectionFinal reportBoeing 737 832 · New York, NYinadvertent collision by ground service vehicle.NTSB GAA16CA405Accident · Minor injuriesData collectionFinal reportBell 206 · Outlook, WAThe pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.NTSB CEN16LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Laguna Pueblo, NMA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.