NTSB investigations, 2008
6 cases where the defining event was Runway incursion veh/AC/person.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 7 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 9 |
| 2024 | 11 |
| 2025 | 15 |
| 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\") = 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\" = '320')
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" = '320') 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 ERA09CA024Accident · Minor injuriesData collectionFinal reportLange Flugzeugbau E1 Antares · Winter Haven, FLThe failure of the pilot of the other airplane to announce his intentions prior to takeoff, resulting in a runway incursion. Contributing to the accident was the limited forward visibility due to the runway slope.NTSB OPS08IA015Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2C1 · Allentown, PAThe failure of both tower controllers to maintain awareness of the position of N736GV and ensure that the aircraft was clear of the runway before issuing a takeoff clearance to ASH7138.NTSB CHI08CA277Accident · No injuriesData collectionFinal reportCessna 150L · Wadsworth, OHThe lack of radio communication with the airplane and the inadequate visual lookout by the driver of the vehicle.NTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.NTSB OPS08IA012Incident · No injuriesIncident investigationFinal reportCessna 172 · Reading, PAThe tower local controller permitted an aircraft to conduct a low approach and another aircraft to land on a closed runway. Contributing to the incident were the arrival radar controller who failed to correct the local controller when advised an aircraft…NTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.