NTSB investigations, ID
7 cases where the defining event was Ground collision.
Cases per year
| 2010 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2023 | 1 |
| 2025 | 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\" = 'ID' 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" = 'ID' 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 WPR25LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Warren, IDThe pilot’s failure to adequately compensate for a wind gust during the departure roll, which resulted in a loss of directional control and a runway excursion.NTSB WPR24LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Boise, IDThe pilot’s failure to maintain directional control while taxiing, which resulted in impact with a fence.NTSB GAA15CA145Accident · No injuriesData collectionFinal reportBeech D17S · Idaho Falls, IDWhile taxiing as a flight of two, the pilot of the blue Beechcraft became distracted and impacted the red Beechcraft which had stopped.NTSB WPR15CA017Accident · No injuriesData collectionFinal reportIndus T-211 Thorpedo · Mountain Home, IDThe pilot's failure to maintain clearance with a parked truck while taxiing for takeoff.NTSB WPR14CA255Accident · No injuriesData collectionFinal reportCosmos Phase II Phase II 582 · Caldwell, IDThe pilot's failure to monitor the environment and to maintain sufficient altitude to clear power lines during low altitude flight.NTSB WPR13CA139Accident · No injuriesData collectionFinal reportCessna 172F · Nampa, IDThe failure of the pilot of another airplane, who was taxiing with no intent for flight, to maintain proper visual lookout.NTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.