NTSB investigations, NC
9 cases where the defining event was Ground collision.
Cases per year
| 2008 | 2 |
|---|---|
| 2010 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2026 | 1 |
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 c.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '200')
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 c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '200') 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 ERA26LA256Accident · No injuriesClass 4 · LimitedInvestigation openEmbraer Executive EMB-500 · Morrisville, NCNTSB DCA21LA226Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Asheville, NCThe fuel truck driver backing up in the direction of the airplane without the use of marshallers.NTSB DCA19CA102Accident · Minor injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCfailure of the ground crew to maintain visual separation and avoid the holding aircraft.NTSB DCA17CA197Accident · Serious injuriesData collectionFinal reportBombardier CL 600 2B19 · Charlotte, NCthe tug operator's initiation of a right turn onto the perpendicular terminal road in proximity to the airplane.NTSB GAA15CA066Accident · No injuriesData collectionFinal reportCessna 177B · Roxboro, NCThe pilot's failure to monitor the airplane's movement and maintain control of the airplane.NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.NTSB ERA10LA299Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-323 · Charlotte, NCThe Airbus A330 flight crew's failure to maintain clearance from a standing airplane while taxiing.NTSB ERA09CA122Accident · No injuriesData collectionFinal reportDassault-Breguet Falcon 50 · Asheville, NCThe pilot's failure to ensure that the airplane's wheels were properly secured before releasing the parking brake.NTSB NYC08CA088Accident · No injuriesData collectionFinal reportBombardier 35A · Charlotte, NCThe tug driver's failure to stop for a taxiway stop sign.