NTSB investigations, 2010
9 cases where the sequence of events included Ground handling event.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 4 |
| 2010 | 9 |
| 2011 | 11 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 10 |
| 2018 | 4 |
| 2019 | 7 |
| 2020 | 7 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 10 |
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\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '080' 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") = 2010 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '080' 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 DCA11CA014Accident · No injuriesData collectionFinal reportBoeing 737-7H4 · Philadelphia, PAthe failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.NTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…NTSB ERA11CA046Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · Pittsburgh, PAThe ground crew’s failure to detach the air-starter hose from the airplane before moving the cart away resulting in structural damage to a skin panel.NTSB ERA11LA044Accident · No injuriesLimited investigationFinal reportBoeing 737 · Fort Lauderdale, FLThe ground service vehicle driver's depressing of the accelerator rather than the brake pedal, resulting in a collision with the airplane.NTSB WPR10LA352Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NVThe passenger's failure to maintain clearance from a turning propeller. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB DCA10CA075Accident · No injuriesData collectionFinal reportBoeing 737 · New York, NYa baggage cart impacting the airplane and causing substantial damage as a result of the jet blast from a passing airplane.NTSB CEN10CA300Accident · No injuriesData collectionFinal reportCessna 172K · Wellington, KSThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller.NTSB WPR10FA199Accident · No injuriesField investigationFinal reportBoeing 737-3H4 · Los Angeles, CAThe tug operator’s failure to comply with company procedures when parking an unoccupied baggage tug, and the failure of the tug’s seat switch to disengage the electric motor when weight was removed from the driver’s seat.NTSB CEN10LA142Accident · No injuriesLimited investigationFinal reportBombardier BD-100-1A10 · Wheeling, ILThe deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.