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 NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB IAD02LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Doylestown, PApilot's failure to maintain clearance between the airplane and a parked fuel truck while taxing.NTSB IAD02FA018Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Pittsburgh, PAThe (undetermined) pilot-at-the-controls' early, and over rotation of the airplane's nose during the takeoff attempt, and his failure to maintain directional control. Also causal, was the captain's inadequate remedial action, both during the takeoff attempt…NTSB NYC02LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Brookville, PAFouling of the engine intake and exhaust valves with bromine and lead deposits.NTSB IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.NTSB IAD02LA009Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Jersey Shore, PAThe pilot's in-flight encounter with weather, which led to a forced landing to unsuitable terrain.NTSB IAD02LA011Accident · No injuriesLimited investigationFinal reportCessna 182 · York, PAThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and subsequent nose gear failure.NTSB IAD02LA005Accident · Minor injuriesLimited investigationFinal reportAerostar SA-60A · Luxor, PAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion, and his subsequent inability to avoid power lines.NTSB NYC02LA008Accident · No injuriesLimited investigationFinal reportAerospatiale ATR 42-320 · Yardley, PAan in flight collision with birds.NTSB IAD02LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Perkasie, PAThe pilot's improper flare, which resulted in a hard landing. A factor was the sun glare.NTSB NYC02LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Philadelphia, PAThe collapse of the right main landing gear for undetermined reasons.NTSB IAD02FA002Accident · 2 fatalField investigationFinal reportCessna 210M · Pittsfield, PAThe pilot's loss of control in flight due to spatial disorientation, and his subsequent overstress of the airplane during a recovery attempt. A factor in the accident was the pilot's use of inappropriate medications.NTSB NYC02LA004Accident · Serious injuriesLimited investigationFinal reportRich Woodstock I · Waynesburg, PAAn improperly secured canopy latch, which resulted in canopy separation during liftoff and the pilot's subsequent loss of control. A factor was the improper installation of the latch.NTSB DCA01MA065Accident · 44 fatalMajor investigationFinal reportBoeing 757 · Shanksville, PAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB NYC01LA226Accident · Serious injuriesLimited investigationFinal reportMurray JN4-D · Morrisdale, PAFailure of the ignition coil, which resulted in a loss of engine power. A factor was the 10-foot corn in the forced landing field.NTSB NYC01FA223Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bern Township, PAThe pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.NTSB NYC01LA221Accident · No injuriesLimited investigationFinal reportde Havilland DHC-94 Moth Minor · Farmington, PAThe in-flight separation of a propeller blade, which resulted in a forced landing to unsuitable terrain. A factor related to the accident was the plowed field.NTSB IAD01LA088Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's operation of the airplane with known deficiencies. Also causal was the loss of brake pressure, which resulted in the failure of the right brake, and subsequent loss of control of the airplane.NTSB NYC01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Davidsville, PAThe pilot's failure to abort the takeoff attempt. Factors included the pilot's failure to use both magnetos, and his failure to utilize soft field takeoff procedures.NTSB NYC01LA190Accident · 1 fatalLimited investigationFinal reportHolsclaw Barnett J4B · Titusville, PAThe pilot's failure to maintain control while maneuvering. A factor was the pilot's lack of experience in type of gyroplane.NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB NYC01LA138Accident · Serious injuriesLimited investigationFinal reportInterplane Sky Boy · Sayre, PAThe pilot's failure to maintain an adequate climb airspeed.NTSB NYC01LA130Accident · No injuriesLimited investigationFinal reportContinental Copters Tom Cat Mark 5A · Benton, PAThe pilot's inadequate preflight inspection, which resulted in a takeoff with a hose still attached and a subsequent dynamic rollover.NTSB NYC01IA134Incident · No injuriesIncident investigationFinal reportBoeing 727-233 · Harrisburg, PAThe inadvertent misrouting of a wire harness by maintenance personnel, which resulted in chafing to a hydraulic line and electrical wire, and subsequent fire.NTSB IAD01LA058Accident · No injuriesLimited investigationFinal reportBeech 55 · West Chester, PAThe partial blockage of the pitot/static system, which led to an inaccurate airspeed indication, and resulted in an aborted takeoff and runway overrun. A factor was the wet runway.NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.NTSB NYC01LA114Accident · No injuriesLimited investigationFinal reportSchweitzer 136 · Tinicum Twnshp., PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.NTSB NYC01LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Osceola Mills, PAA partial power loss due to a stuck exhaust valve in the # 2 cylinder, which resulted in a forced landing. A factor was the rising terrain.NTSB IAD01LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Factoryville, PAThe pilot's failure to reach the proper touchdown point, and his subsequent failure to abort the landing.NTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB NYC01LA098Accident · Minor injuriesLimited investigationFinal reportFobes CGS Hawk Plus · West Middlesex, PAThe partial loss of engine power, for undetermined reasons. Factors included the headwinds on base leg, and the unsuitable terrain for a forced landing.NTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.NTSB IAD01LA033Accident · No injuriesLimited investigationFinal reportMooney M20C · Peckville, PAloss of engine power for undetermined reasons.NTSB NYC01LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA365-N1 · West Mifflin, PAInsufficient lubrication within the tail rotor gearbox, which resulted in the seizure of the duplex ball bearing and a fixed pitch setting of the tail rotor. Also causal, was the pilot's loss of control, which was the result of a relative low speed/high power…NTSB NYC01FA040Accident · 3 fatalField investigationFinal reportMooney M20K · Rixford, PAThe pilot's loss of control of the airplane while maneuvering. Factors included low ceilings and the pilot's lack of instrument flight experience.NTSB NYC01LA029Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Prosperity, PAThe failure of the dual magneto ignition system points to open.NTSB IAD01LA007Accident · No injuriesLimited investigationFinal reportCessna 140 · Mcclure, PAThe loss of engine power over unsuitable terrain due to fuel starvation from a fuel strainer blocked with sealant particles.NTSB NYC01LA015Accident · Serious injuriesLimited investigationFinal reportMoore Starduster SA-300 · Erwinna, PAA total loss of engine power during initial climb for undetermined reasons.NTSB IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.NTSB IAD01LA002Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Philadelphia, PAA hole in the #4 piston for undetermined reasons which resulted in engine oil starvation and engine stoppage.NTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.NTSB NYC01FA001Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Seven Springs, PAThe pilot's improper recovery from a bounced landing.NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.NTSB NYC00LA264Accident · No injuriesLimited investigationFinal reportAeronca 11AC-991 · Gettysburg, PAThe pilot's failure to maintain control of the airplane after landing which resulted in the inadvertent ground loop.NTSB NYC00LA254Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's failure to attain the proper touchdown point.NTSB NYC00LA246Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Seven Springs, PAThe pilot's failure to maintain the manufacture's recommended safe single-engine airspeed, which resulted in a velocity-minimum-control roll to the right. A factor in the accident was the pilot's failure to maintain a proper glide path to his intended…