NTSB investigations, 2008
5 cases where the defining event was Ground handling event.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 2 |
| 2010 | 9 |
| 2011 | 10 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 6 |
| 2017 | 10 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 8 |
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\") = 2008
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '080')
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") = 2008 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '080') 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 WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.NTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.NTSB WPR09CA041Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Mountain Home, IDThe pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.NTSB SEA08LA182Accident · Serious injuriesLimited investigationFinal reportBoeing 777-300 · San Francisco, CAThe ground crewman's failure to follow the tow bar disconnect standard operating procedures.NTSB NYC08LA234Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Charlotte, NCThe tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.