NTSB investigations, PA
5 cases where the sequence of events included AC/prop/rotor contact w person.
Cases per year
| 2009 | 1 |
|---|---|
| 2013 | 1 |
| 2016 | 2 |
| 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\" = '081' 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" = '081' 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 ERA23LA055Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Allentown, PAThe flight instructor’s decision to remove the nosewheel chock while the engine was still operating.NTSB GAA17CA063Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Port Matilda, PAThe bystander's decision to walk onto the runway, which resulted in him being struck by the glider's left wing.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 ERA13LA433Accident · 1 fatalLimited investigationFinal reportEnstrom F-28C · Bloomsburg, PAThe relieved pilot’s failure to maintain clearance from the rotating main rotor blades after he exited the helicopter.NTSB ERA10CA058Accident · Serious injuriesData collectionFinal reportCessna 150 · York, PAThe pilot's inadvertent encounter with a rotating propeller.