NTSB investigations, PA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC82DA098Accident · No injuriesFinal reportAero Commander 680F · Prospectville, PAThe pilot had planned to purchase the aircraft and was ferrying it to buffalo, NY for inspection and repair. While en route, the right engine lost power. He feathered the right propeller and diverted to turner field. When he lowered the gear, he did not get a…NTSB NYC82DHA09Accident · No injuriesFinal reportBryan HP-18 · Hazelton, PAThe pilot departed blairstown, PA on a round robin, triangular course to bethel and dallas, PA and return to blairstown. He stated that while he was proceeding from bethel to dallas he encountered heavy sinking conditions in addition to a head wind.…NTSB NYC82DA089Accident · No injuriesFinal reportBell 47g-3b (Soloy Conversion) · New Hope, PAWhile making a cleanup swath around the bottom of a hill, the helicopter collided with wires. The pilot reported that he did not see the wires while holding his head in such a manner as to reduce the effect of sun-glare. After hitting the wires, the pilot…NTSB NYC82DA085Accident · No injuriesFinal reportRayan NAV-4 · Bloomsburg, PAAfter takeoff the pilot smelled smoke and observed the oil pressure drop to 20 PSI. When the oil pressure continued to drop the pilot decided to land at Bloomsburg airport, approximately 3 miles away. After landing the pilot taxied off the runway and the…NTSB NYC82DA084Accident · No injuriesFinal reportBeech 35-33 · Altoona, PAThe pilot stated that before landing, he performed his cockpit duties and put the gear in the down position. However, he lost sight of another aircraft in the traffic pattern and became preoccupied with trying to locate the aircraft. He was also preoccupied…NTSB NYC82FGT14Accident · No injuriesFinal reportChristian Eagle II · Lancaster, PAAfter taking off from runway 31, the pilot proceeded to an area where he performed inverted flight in an attempt to find a dime that may have been dropped in the cockpit. During his departure and arrival, he and a tower controller discussed and joked about…NTSB NYC82FA080Accident · 4 fatalField investigationFinal reportMBB BO-105C · New Ringgold, PAThe helicopter was leased by the allentown sacred heart hospital. At 2236 EDT, the pilot, who was standing by for duty, obtained a weather briefing. Later, at 2312, there was a request for a med-evac helicopter to respond to a car accident. The helicopter…NTSB NYC82DA079Accident · No injuriesFinal reportPiper 601P · New Castle, PAA witness who observed the accident stated that he saw N31EH on a very close right base at 150-200 ft above the ground. The aircraft was moving at a rapid rate of speed and was in a very steep right turn. As the aircraft got closer to the runway it became…NTSB NYC82FHD09Accident · Minor injuriesFinal reportLuscombe 8F · Essington, PAThe float equipped Luscombe stalled during fanal approach to a water landing near a dock. There was considerable rotorcraft activity near the seaplane base due to the presence of the queen elizabeth ii ocean liner.NTSB NYC82DA075Accident · No injuriesFinal reportPitts Special S-1C · Latrobe, PAThe pilot initiated a takeoff in winds that were gusting to 19 knots. As he raised the tail during the takeoff roll, the plane swerved right. The pilot stated that he overcorrected to the left. Subsequently, the plane departed the left side of the runway. The…NTSB NYC82DA073Accident · No injuriesFinal reportFairchild PT-19 · Butler, PAThe instructor pilot was flying with the owner of the aircraft to help him get acquainted with his plane. While on final approach, the owner let the aircraft get low. He corrected by adding power, but reportedly raised the nose beyond the stall angle. The…NTSB NYC82DA070Accident · No injuriesFinal reportStinson 108-1 · Factoryville, PAThe pilot was practicing landings in gusty wind conditions. He reported that the first landing was uneventful, but the second landing was aborted due to gusty turbulence. He stated that the third landing was made in relatively calm wind conditions until just…NTSB NYC82FGT13Accident · 1 fatalFinal reportCessna 182 · Catawissa, PAReportedly, the pilot departed the airport to accumulate time on a overhauled engine. The airport manager stated that shortly after takeoff, the pilot called on the UNICOM frequency that the engine and aircraft worked like new and he was completely satisfied…NTSB NYC82DA071Accident · No injuriesFinal reportPiper PA-28-181 · Allentown, PADuring final approach the landing gear collided with a snowbank and the aircraft skidded on its nose and main landing gear, coming to rest approximately 30-50 yards from the approach end of the runway.NTSB NYC82DHA08Accident · Serious injuriesFinal reportAeronca 11AC · Beach Lake, PAThe pilot of a ski equipped aircraft began taking off on a 900 ft strip. There was snow on the runway, but grass showed through in places. The pilot reported that the aircraft slowed "very very little" while crossing an area with grass showing. Just beyond…NTSB NYC82DA069Accident · No injuriesFinal reportCessna 310 · Pittsburgh, PAAfter takeoff a loud bang was heard during gear retraction. A fly by the tower confirmed that the nose gear was not in the locked position and all attempts to lock it failed. Touchdown was made on the main landing gear and after the airspeed dissipated to…NTSB NYC82FGM10Accident · 2 fatalFinal reportBeech E55 · Scandia, PAAt 0834 EST, the pilot departed bradford airport on an IFR flight to alton, IL. About 4 minutes later, he advised that he was having difficulty with his flight instruments while in IFR conditions. He attempted to return to the departure airport by using d.f.…NTSB NYC82FGT11Accident · Serious injuriesFinal reportPiper PA-44-180 · Mcsherrystown, PAThe pilot reported that when he arrived at night, there were snow showers at the airport. While turning final, he turnedhis landing lights on. However, he reported that he could see better with the landing lights off, so he turned them off. After touching…NTSB NYC82DA067Accident · No injuriesFinal reportPiper PA-28R-200 · Butler, PAApproximately 100 feet after touchdown a gust of wind lifted the left wing of the aircraft turning it into the wind. Directional control was lost and the aircraft collided with two parked aircraft. A PA-22, N54572, and an Ercoupe, N93552, both of which…NTSB NYC82FGT09Accident · Serious injuriesFinal reportPiper PA-28-151 · Annville, PADuring takeoff, the engine lost power at about 150 ft AGL. The pilot reported that the engine started when he switched from the left to the right fuel tank, but stopped again. He attempted to return to the airport, but was unable. The aircraft nosed over…NTSB NYC82FA059Accident · 5 fatalField investigationFinal reportCessna T210M · Williamsport, PAThe acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading…NTSB NYC82DA066Accident · No injuriesFinal reportBeech A23-24 · Lock Haven, PAWhile taxiing for takeoff the left wing of the aircraft collided with the nose of a parked Piper twin. The pilot stated that during his instrument scan he noticed that the alternator failed to show a charge and that this may have distracted his attention as…NTSB NYC82DA056Accident · Serious injuriesFinal reportBell 47J-2A · Emmaus, PAWhile maneuvering at approximately 200 feet AGL for an aerial photography mission a sudden and complete power failure occurred. The pilot initiated autorotation procedures and set a course for the only open area, a small field with a 15 degree upslope. A…NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…NTSB NYC82FA053Accident · 1 fatalField investigationFinal reportRobinson R22 · Spangler, PAThe helicopter struck a set of north-south powerlines while the pilot was patrolling a set of east-west powerlines. The powerlines being patrolled passed under the lines that were struck. The accident occurred over hilly, wooded terrain.NTSB NYC82DA052Accident · No injuriesFinal reportPiper PA-38-112 · Allentown, PAThe student pilot was practicing takeoffs and landings on runway 25 in crosswind conditions. The wind was from 330 degrees at 14 knots. On one of the landings, the aircraft bounced during touchdown. The pilot reportedly added a small amount of power for a…NTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB NYC82DA030Accident · No injuriesFinal reportPiper PA-38-112 · Easton, PAA takeoff was initiated on runway 17 with the wind from the southwest at 15 knots. During the takeoff roll, control of the aircraft was lost when a gust of wind was encountered. The plane struck a snowbank beside the runway and was substantially damaged.NTSB NYC82DA040Accident · No injuriesFinal reportCessna 310Q · Doylestown, PAWhile descending ice began to accummulate on the windshield and leading edges of the wings. The pilot stated that the windshield was covered with 1/2 to 3/4 inch of ice but he was able to clear a small strip large enough for him to see out. Upon reducing…NTSB NYC82DA039Accident · No injuriesFinal reportPiper PA-44-180T · Mount Pocono, PABefore takeoff, the pilot got a weather briefing and called the airport manager at the destination. Reportedly, the destination airport was open and usable at that time. In flight, the pilot asked ATC about reports of icing in the mt Pocono area and got a…NTSB NYC82DA034Accident · No injuriesFinal reportBellanca 17-30A · Factoryville, PADuring the previous flight, there was a landing gear malfunction. A mechanic checked the gear and a decision was made to fly the plane with the gear down to another airport for maintenance. During the subsequent flight, the "gear down" speed was not exceeded.…NTSB DCA82AA014Accident · Serious injuriesFinal reportMcdonnell-Douglas DC-10-10 · Philadelphia, PAThe aircrews of a united DC-10 (flt 99 heavy) and two U.S. Air DC-9'S (flt 25 and flt 199) taxied for takeoff at about the same time. Due to delays, the no. 2 engine of flt 199 was shut down in accordance with applicable fuel conservation procedures. After…NTSB NYC82DA026Accident · No injuriesFinal reportPiper Aerostar 601P · Somerset, PAThe aircrew intended to depart at 1600 EST, but due to the general aviation reservation restrictions, the flight was delayed until 1700. The pilot reported the takeoff was normal until just before rotation at 85 to 90 KTS, when freezing rain began to obscure…NTSB NYC82DA022Accident · No injuriesFinal reportCessna 310 · Butler, PAThe pilot arrived at the destination at dusk. He circled the airport at pattern altitude to check the wind and runway condition. He noted that the runway was covered with snow. A long approach was made to runway 36 in a calm wind condition. Just prior to…NTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…NTSB NYC82FGT07Accident · No injuriesClosedAeronca 7AC · Wellsboro, PANTSB NYC82DA013Accident · No injuriesClosedAeronca 7AC · Wellsboro, PANTSB NYC82FGM08Accident · No injuriesClosedHummer A · Butler, PANTSB NYC82DHA05Accident · No injuriesClosedMooney M20K · Kutztown, PANTSB NYC82FGT06Accident · No injuriesClosedStinson 108 · Brogue, PANTSB NYC82FGM07Accident · No injuriesClosedCessna 340 · West Mifflin, PANTSB NYC82FGT05Accident · No injuriesClosedPiper PA-24 · Montoursville, PANTSB NYC82FA011Accident · 4 fatalClosedCessna 150G · Osgood, PANTSB NYC82FGM06Accident · No injuriesClosedCessna 140 · Newry, PANTSB NYC82FA009Accident · 4 fatalClosedPiper PA-32 · Mount Pocono, PANTSB NYC82FGM05Accident · No injuriesClosedCessna 150G · West Middlesex, PANTSB NYC82FGM04Accident · No injuriesClosedCessna 150 · Wattsburg, PANTSB NYC82FGT04Accident · 1 fatalClosedCarver HP-14B · Altoona, PANTSB NYC82DHA06Accident · Minor injuriesClosedSchweizer SGS2 · Kutztown, PA