NTSB investigations, 2015, PA
20 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 13 |
| 2010 | 10 |
| 2011 | 12 |
| 2012 | 23 |
| 2013 | 13 |
| 2014 | 10 |
| 2015 | 20 |
| 2016 | 15 |
| 2017 | 21 |
| 2018 | 14 |
| 2019 | 12 |
| 2020 | 3 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 1 |
Where
Latest 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\") = 2015
AND 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\" = '470' 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 year(c."eventDate") = 2015 AND 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" = '470' 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 ERA16LA077Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Myerstown, PAThe pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.NTSB GAA16CA084Accident · No injuriesData collectionFinal reportPiper PA22 · New Castle, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.NTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…NTSB GAA16CA045Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Mount Pocono, PAThe student pilot's failure to remove the tension applied to the cyclic before takeoff, which resulted in a loss of directional control and the tail rotor striking the ground.NTSB ERA16LA010Accident · 1 fatalLimited investigationFinal reportMurray Blair L Free Bird Classic · Kylertown, PAThe pilot's failure to maintain sufficient airspeed during approach for landing, which resulted in an inadvertent aerodynamic stall/spin. Contributing to the accident was the pilot’s lack of flight experience in the accident airplane make and model.NTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…NTSB ERA15LA363Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gettysburg, PAThe total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's failure to maintain a proper approach speed during the forced landing, which resulted in impact with trees.NTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.NTSB GAA15CA243Accident · No injuriesData collectionFinal reportCessna 172 · New Enterprise, PAThe pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA15LA311Accident · Serious injuriesLimited investigationFinal reportThomas A Siminski Zenith CH 750 · Allentown, PAA partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…NTSB ERA15FA298Accident · 1 fatalField investigationFinal reportMchugh Tony Kitfox Model 1 · Montrose, PAThe pilot's failure to maintain control of the airplane during final approach, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.NTSB ERA15LA294Accident · No injuriesLimited investigationFinal reportCommander 114 · Reading, PAThe improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.NTSB ERA15LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Perkasie, PAThe pilot's failure to use the mixture control to override a throttle anomaly and reduce engine power, which resulted in excessive airspeed upon landing and a subsequent runway overrun. Contributing to the accident was the pilot’s inability to reduce the…NTSB GAA15CA148Accident · No injuriesData collectionFinal reportMooney M20R · West Mifflin, PAThe pilot's failure to maintain pitch control during landing, which resulted in a bounce and loss of control during landing, followed by a runway excursion, and collision with terrain during an attempt to abort the landing.NTSB ERA15LA239Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Dushore, PAThe total loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB ERA15LA238Accident · No injuriesLimited investigationFinal reportCessna T210 · Palmyra, PAThe pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.NTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.NTSB GAA15CA075Accident · Minor injuriesData collectionFinal reportHead Balloons AX8 105 - NO Series · Intercourse, PAThe pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.NTSB ERA15FA171Accident · 2 fatalField investigationFinal reportPiper PA28 · West Chester, PAThe failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…NTSB ERA15CA162Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · St Marys, PAThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and a nose over.