NTSB investigations, PA
9 cases where the sequence of events included Ground collision.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2020 | 1 |
| 2022 | 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\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' 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 c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' 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 ERA22LA364Accident · Minor injuriesClass 4 · LimitedFinal reportAerotek Pitts Special S-1S · Erwinna, PAThe inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…NTSB ERA21LA049Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Lititz, PAThe pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.NTSB GAA16CA447Accident · No injuriesData collectionFinal reportCessna 172 · Williamsport, PAThe student pilot's distraction during taxi operations, which resulted in the airplane's left wing impacting a hangar.NTSB ERA16CA264Accident · Serious injuriesData collectionFinal reportAeronca 7BCM · Connellsville, PAThe pilot's failure to properly set the throttle and secure the airplane before hand-propping the engine for startup.NTSB GAA15CA057Accident · Minor injuriesData collectionFinal reportCessna 182T · St Marys, PAThe pilot's decision to rotate the propeller by hand without properly securing the airplane.NTSB ERA13CA123Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Lancaster, PAThe pilot’s failure to maintain clearance from a parked vehicle while taxiing from landing.NTSB ERA10CA413Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe student pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.NTSB NYC08FA265Accident · No injuriesField investigationFinal reportCessna 550 · Reading, PAThe air traffic controller’s failure to properly monitor the runway environment. Contributing to the accident was the tractor operator’s failure to scan the active runway prior to crossing, and the Federal Aviation Administration’s inadequate emphasis on…