NTSB investigations, PA
206 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases, newest first
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\" = '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 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 GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.NTSB ERA18LA192Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stewartstown, PAThe pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.NTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…NTSB ERA18FA122Accident · 2 fatalField investigationFinal reportMD Helicopter 600 · Smethport, PAThe helicopter pilot's failure to maintain adequate clearance during power line construction work, which resulted in the helicopter's main rotor striking and becoming entangled with a wire and a subsequent dynamic rollover and collision with terrain.…NTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.NTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.NTSB GAA18CA020Accident · No injuriesData collectionFinal reportCessna 150 · Pottsville, PAThe failure of the right rudder cable and subsequent loss of directional control during landing.NTSB ERA17LA333Accident · Serious injuriesLimited investigationFinal reportBuschmann/Vanzee Vari EZ · Ambler, PAWater contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.NTSB ERA17LA328Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Hanover Township, PAThe pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.NTSB ERA17LA288Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Marietta, PAThe pilot's failure to maintain directional control during takeoff with a quartering tailwind. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB ERA17LA269Accident · Serious injuriesLimited investigationFinal reportRose Herbert D Pietenpol AIR Camper · Tower City, PAThe pilot's incapacitation due to fainting as a result of complications from a previously undiagnosed heart condition.NTSB GAA17CA536Accident · Minor injuriesData collectionFinal reportMenzimer Gary Ray Firestar · Westfield, PAThe pilot's improper decision to operate an airplane without recent flight training and his inadvertent application of left electric rudder trim before flight and a subsequent loss of airplane control.NTSB GAA17CA462Accident · No injuriesData collectionFinal reportChampion 7ECA · Butler, PAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA17FA248Accident · 1 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PAA partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…NTSB GAA17CA406Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wilkes-Barre, PAThe flight instructor's delayed remedial action to maintain helicopter altitude during hover flight instruction, which resulted in the helicopter skid contacting a crack in the runway and a dynamic rollover.NTSB ERA17FA232Accident · 1 fatalField investigationFinal reportMorrisey 2150A · Honesdale, PAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's use of two psychoactive substances, which led to his impaired decision to attempt to takeoff after engine issues became evident.NTSB GAA17CA383Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Easton, PAThe pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.NTSB ERA17TA233Accident · No injuriesFinal reportLawrence O Nolte Zodiac CH650B · Dover, PAA total loss of engine power as a result of the loss of all electric fuel pumps due to a loss of electric power because of the installation of an improper battery on the airplane and the use of improper charging cables on the battery.NTSB ERA17FA223Accident · 1 fatalField investigationFinal reportSlip Stream Genesis · Linesville, PAThe pilot's failure to maintain airspeed during a climbing turn after takeoff and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery. Contributing to the accident was the…NTSB ERA17LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · West Chester, PAAn engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.NTSB ERA17CA177Accident · Serious injuriesData collectionFinal reportReupert Mark Avid Flyer · Reedsville, PAThe sport pilot's failure to maintain airplane control during takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB ERA17FA153Accident · 1 fatalField investigationFinal reportHoward DGA 15P · Monongahela, PAThe pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.NTSB GAA17CA196Accident · No injuriesData collectionFinal reportSchweizer SGS126 · Bangor, PAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.NTSB GAA17CA154Accident · No injuriesData collectionFinal reportCessna 180 · Bally, PAThe pilot’s failure to maintain directional control during takeoff in crosswind conditions.NTSB ERA17LA098Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Pottsville, PAA total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17CA030Accident · Minor injuriesData collectionFinal reportKolb Fire FLY · West Middlesex, PAThe noncertificated pilot’s loss of airplane control while maneuvering at a low altitude.NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.NTSB ERA17FA017Accident · 3 fatalField investigationFinal reportPiper PA28 · Austin, PAThe pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…NTSB ERA17LA016Accident · Serious injuriesLimited investigationFinal reportHatcher Roderick R CH701 · Albrightsville, PAA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB ERA16LA285Accident · Minor injuriesLimited investigationFinal reportShaffer Donald Arion Lightning · Toughkenamon, PAA total loss of engine power for reasons that could not be determined because examination of the engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA270Accident · No injuriesLimited investigationFinal reportCraig D Carter Stol CH 750 · Waynesburg, PAThe partial loss of engine power due to carburetor icing.NTSB ERA16CA237Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Honesdale, PAThe pilot's inadequate preflight planning, which resulted in his attempt to take off near the airplane’s maximum gross weight in high-density altitude conditions that degraded the airplane’s takeoff and climb performance and resulted in an aborted takeoff and…NTSB ERA16CA233Accident · Minor injuriesData collectionFinal reportCessna T206 · Farmington, PAThe pilot's failure to obtain the proper touchdown point and failure to perform a go-around once a safe landing on the runway could not be accomplished.NTSB ERA16LA200Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Toughkenamon, PAThe student pilot’s inadvertent actuation of the fuel shutoff valve, which led to a total loss of engine power, forced landing, and impact with a hangar. Contributing to the outcome was maintenance personnel’s inadequate inspection of the fuel shutoff system…NTSB GAA16CA248Accident · No injuriesData collectionFinal reportLuscombe 8 · Blue Bell, PAThe pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.NTSB ERA16LA166Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tannersville, PAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA16FA143Accident · 1 fatalField investigationFinal reportRobinson R44 · Canadensis, PAThe pilot's loss of control due to spatial disorientation, which occurred after ascending in order to clear rising terrain and inadvertently entering the clouds.NTSB GAA16CA156Accident · No injuriesData collectionFinal reportRolladen-Schneider LS8 · Pine Grove, PAThe pilot's inability to maintain the glider's descent rate and glide path after encountering a downdraft, resulting in a collision with trees during an off airport landing.NTSB ERA16LA126Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20 · Pottstown, PAThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.NTSB ERA16LA116Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAA partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.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.