NTSB investigations, PA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 IAD00FA079Accident · 1 fatalField investigationFinal reportMooney M20F · Jonestown, PAThe pilot's delay in aborting the landing, which resulted in a collision with transmission wires. Factors in the accident were the pilot's improper inflight decision to attempt a landing with a 14-knot tailwind, and his use of an unapproved pain medication.NTSB NYC00FA257Accident · 1 fatalField investigationFinal reportCessna 172L · Mill Creek, PAThe pilot's improper pre-flight planning, and in-flight planning decision to continue visual fight into deteriorating adverse weather conditions. Factors were the night conditions, low clouds and fog.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.NTSB IAD00LA072Accident · Serious injuriesLimited investigationFinal reportAero Commander 114-B · Somerset, PAPilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB NYC00LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · E. Stroudsburg, PAThe pilot's decision to takeoff with only partial engine power available.NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.NTSB NYC00LA184Accident · 2 fatalLimited investigationFinal reportHartzell Rans S-12 · Strattanville, PAThe pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.NTSB NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB NYC00LA156Accident · Minor injuriesLimited investigationFinal reportStewart S-51 · Forty Fort, PAThe owner/builder's inadequate design, resulting in total failure of the reduction gear assembly accessory drive shaft.NTSB IAD00LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE-55 · Erie, PAthe pilot's improper fuel management which resulted in fuel starvation and a loss of power to both engines. A factor was the pilot's inadequate pre-flight planning and takeoff with inadequate fuel for the flight.NTSB DCA00MA052Accident · 19 fatalClass 1 · MajorFinal reportBritish Aerospace J-3101 · Bear Creek Town, PAThe flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…NTSB NYC00LA137Accident · No injuriesLimited investigationFinal reportAnderson MA-18 · Pittsburgh, PAThe pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…NTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.NTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.NTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.NTSB NYC00LA129Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, PAA crack in the crankcase which resulted in a partial power loss.NTSB IAD00LA039Accident · Minor injuriesLimited investigationFinal reportRotorway Rotorway 162F Exec · Mcmurray, PAThe pilot's improper in-flight planning and decision to hover out of ground effect which resulted in a loss of tail rotor effectiveness.NTSB NYC00LA126Accident · No injuriesLimited investigationFinal reportCessna 185F · Pottstown, PAThe second pilot's inadequate compensation for wind conditions and the inadequate supervision of the flight instructor. Factors related to the accident were the crosswind and gusting wind conditions.NTSB IAD00LA031Accident · No injuriesLimited investigationFinal reportBeech 23 · Selinsgrove, PAThe student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.NTSB NYC00LA115Accident · No injuriesLimited investigationFinal reportMooney M-20F · Parker, PAThe pilot's failure to maintain an adequate visual lookout, due to his distraction with a flock of birds. A factor was the pilot's improper in flight decision to continue the simulated engine failure to too low of an altitude.NTSB NYC00LA108Accident · No injuriesLimited investigationFinal reportSportavia Putzer RF-5B · Gillespie, PAThe pilot's improper weather evaluation, resulting in a tailwind departure.NTSB NYC00LA110Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waynesburg, PAThe private pilot's inadequate compensation for wind conditions and the flight instructor's delay in remedial action. A factor in the accident was the gusting wind conditions.NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.NTSB NYC00LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · New Brighton, PAThe pilot's inadequate compensation for the gusty wind conditions. A factor was the windshear encountered on final approach.NTSB IAD00LA027Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Erwinna, PAthe improper entry into the traffic pattern by the pilot of the Piper airplane and the inadequate lookout by the pilots in both airplanes. A factor in the accident was that radio communication was not possible because the Piper was not so equipped, and the…NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB NYC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Bradford, PAThe pilot's inadequate ice/frost removal from the aircraft.NTSB NYC00FA064Accident · 2 fatalField investigationFinal reportAerostar 601P · Coatesville, PAThe pilot's failure to follow the published instrument approach procedure, and his failure to establish a climb after passing the missed approach point.NTSB IAD00LA016Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Waynesburg, PAthe pilot's failure to maintain aircraft control during the landing roll-out.NTSB NYC00FA063Accident · 2 fatalField investigationFinal reportCessna 310N · Old Forge, PABoth pilots' failure to adequately manage the fuel supply, which resulted in fuel starvation.NTSB NYC00MA048Accident · 3 fatalMajor investigationFinal reportIsrael Aircraft Industries 1124A · Gouldsboro, PAThe improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.NTSB NYC00LA053Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Shamokin, PAThe pilot's failure to maintain aircraft control.NTSB NYC00LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Reading, PAThe failure of the number two connecting rod after an improper overhaul by maintenance personnel.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB NYC00LA042Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Palmerton, PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.NTSB IAD00LA005Accident · No injuriesLimited investigationFinal reportAnkenbruck SEA Hawk · Somerset, PAThe pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.NTSB NYC00LA030Accident · No injuriesLimited investigationFinal reportCessna 150 · New Hope, PAThe pilot's failure to identify during the preflight that both fuel vents were blocked, resulting in a total loss of engine power.NTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.NTSB NYC00LA026Accident · Minor injuriesLimited investigationFinal reportBailey Exec 162F · Pottstown, PAThe student pilot's loss of control of the helicopter, his lack of recent experience, his lack of total experience, and his overconfidence in his personal ability. A factor in the accident was the student pilot's disregard of regulations.NTSB NYC00LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Fredericksburg, PAWas the inadequate visual lookout by the pilot of the Stearman.NTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.NTSB NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.NTSB NYC99FA198Accident · 2 fatalField investigationFinal reportCessna 210 · Mount Pocono, PAThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain aircraft control. A related factor was the fog.NTSB NYC99FA193Accident · 2 fatalField investigationFinal reportPiper PA28R-180 · Seven Springs, PAThe pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.