NTSB investigations, PA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 ERA16FA215Accident · 2 fatalField investigationFinal reportPiper PA31 · State College, PAThe pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB GAA16CA315Accident · No injuriesData collectionFinal reportSeela Gerald L Glasair SH 2F · State College, PAThe pilot's hard landing in gusting wind conditions. Contributing to the accident were the pilot's unfamiliarity with the newly purchased airplane's throttle resulting in an unstable approach, and the pilot's ability to compensate for the wind.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 DCA16CA153Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 214 · Philadelphia, PAan inadvertent encounter with clear air turbulence that resulted in a serious injury to a flight attendant.NTSB ERA16LA265Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PAMaintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.NTSB ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.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 ERA16LA154Accident · No injuriesLimited investigationFinal reportPiper PA28 · West Mifflin, PAThe pilot's failure to follow checklist procedures for an engine fire during start.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 ERA16CA105Accident · No injuriesData collectionFinal reportPiper PA34 · Williamsport, PAThe pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.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 ERA16FA063Accident · 2 fatalField investigationFinal reportTimothy C Williams CCK-1865 · Linesville, PAThe noninstrument-rated pilot's improper decision to attempt a flight under visual flight rules at night in instrument meteorological conditions to an unlit airstrip, which resulted in controlled flight into terrain.NTSB DCA16CA023Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 112 · Philadelphia, PAan inadvertent encounter with clear air turbulence.NTSB ERA16CA060Accident · No injuriesData collectionFinal reportEurocopter Deutschland EC 135 · Monongahela, PAThe inadequate securing of the wheeled fire extinguisher's cover which resulted in it being blown off of the fire extinguisher and ingested into the helicopter's fenestron during takeoff, resulting in a loss of directional control.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 GAA16CA038Accident · No injuriesData collectionFinal reportAeronca 7AC · Auburn, PAThe pilot's use of excessive brake pressure during the landing roll, which resulted in a nose over.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 ERA15LA369Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Pittsburg, PAAn engine fire, which resulted from the overpriming of a hot engine.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 ERA15LA319Accident · Serious injuriesLimited investigationFinal reportHead AX9 118 · New Holland, PAThe pilot's failure to adequately secure the vent line, which resulted in the premature deflation of the balloon’s envelope and its subsequent contact with power lines. Contributing to the accident were the pilot's choice of an unsuitable landing area, which…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 GAA15CA203Accident · No injuriesData collectionFinal reportWelch Floyd L Quickie Q 2 · Hazleton, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB ERA15LA279Accident · No injuriesLimited investigationFinal reportKinner Sportster B · Eagles Mere, PAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA15LA276Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA1B · Lititz, PAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.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 GAA15CA119Accident · No injuriesData collectionFinal reportCessna 172R · Beaver Falls, PAThe student pilot's failure to maintain airplane attitude control during the landing, resulting in a hard landing.NTSB GAA15CA099Accident · No injuriesData collectionFinal reportCessna 172 - R · State College, PAThe student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.NTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.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 GAA15CA055Accident · No injuriesData collectionFinal reportBeech C 50 · Honesdale, PAThe pilot's failure to stop the airplane on the runway during landing, resulting in an overrun, landing gear collapse and substantial damage to 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 ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.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.NTSB ERA15CA106Accident · No injuriesData collectionFinal reportCessna 172L · New Castle, PAPilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ERA15LA001Accident · 1 fatalLimited investigationFinal reportAir Command 582 · Monongahela, PAThe amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.