NTSB investigations, PA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 NYC87LA206Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Palmyra, PAThe Cessna 210 was cruising enroute when it experienced a loss of power which the pilot attributed to low fuel/ exhaustion. He then attempted an approach at reigle fld but was too long and went around. On his second approach, he was again high and long, and…NTSB NYC87LA201Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Huntingdon, PAThe flight encountered poor visibility while at cruise altitude. The pilot decided not to continue flight and landed on a football field. During roll out, the right main gear fell into a drain hole to the side of the field causing the aircraft to turn right…NTSB NYC87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Roseville, PAWitnesses rprtd the acft flew over a pvt strip at low alt, then it began climbing over rising, wooded terrain. Subsequently, the acft would not outclimb the terrain & it crashed into the treetops. No preimpact mechanical problem was found.NTSB NYC87LA190Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Kralltown, PAThe plt attempted to takeoff from a 2130 ft grass strip on a relatively hot & humid day with an air temp of 85 deg. About 2/3 of the way down the rwy, he rotated the acft to takeoff, but it would not climb sufficiently to clear a hill beyond the arpt boundry.…NTSB NYC87LA189Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Doylestown, PAUpon landing, the flight encountered standing water on the runway and the aircraft hydroplaned veering right of the centerline. The main landing gear collapsed causing substantial damage. The acft went off the rt side of the rwy after 2839 ft of roll and…NTSB NYC87LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Olyhant, PAThe cross country personal transportation flight arrived in the scranton, Pennsylvania area for a planned refueling stop and encountered heavy fog conditions. Six attempts to land were made, but were aborted. An attempt to land at another airport was also…NTSB NYC87LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot landed at Butler farm airport. The plt overshot the normal touchdown point at excessive speed. The aircraft skidded off the end of the runway and collided with a three foot deep ditch and was substantially damaged.NTSB NYC87LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt.Union Boro, PAThe aircraft collided with transmission wires while flying low during a pleasure flight. An uneventful precautionary landing was made on a highway with reduced power and full flaps.NTSB NYC87LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Towanda, PAThe Taylorcraft, N43978, collided with the tail of Piper, N4889L while both were taxiing to rwy 22. The plt of the Taylorcraft stated that he was taxiing parallel to the rwy and the Piper came from behind and to the left to cross in front of him. The plt of…NTSB NYC87LA177Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Quakertown, PAThe pilot came in high and fast on the approach. He reduced pwr initially to increase rate of descent. As he apched trees, he applied power to stop the descent, but collided with the tops of the trees. The acft yawed to the right about 30 degrees and touched…NTSB NYC87LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Grove City, PAThe plt rprtd that while on final apch to lnd at night, the acft stalled. He stated that he applied full power, but the acft 'just dropped.' It struck the ground short of the rwy. Drg impact, all three gear collapsed, the rgt main spar was damaged & the lower…NTSB NYC87LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Vera Cruz, PAThe plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but…NTSB NYC87LA157Accident · No injuriesLimited investigationFinal reportPiper J-3 · Mercer, PAThe flight departed from runway 27 uphill with the wind at 180 degrees in uncut grass. There were trees on the left side of the departure end of the runway. The plt stated that he lost lift as he approached the departure end of the runway.NTSB NYC87DGT01Accident · Minor injuriesFinal reportSchleicher ASW-20L · Mt Holley Sprgs, PAJust before touchdown, during an off-arpt landing, the plt tried to extend the flaps from a 30 deg position to full down (55 deg). He said that due to his short stature & seat position, he had difficulty positioning his left arm to do this. As he tried to…NTSB NYC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Reading, PAAccording to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the…NTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.NTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…NTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…NTSB DCA87MA031Accident · 2 fatalMajor investigationFinal reportLearjet 35A · West Mifflin, PAThe coplt (dual student) was to get a prof check on the 1st leg of the flt with a simulated single eng pwr loss on tkof. According to witnesses, the tkof was normal until lift-off aprx 3200' down the rwy; but after lift-off, the acft clbd only about 50' &…NTSB NYC87LA142Accident · Serious injuriesLimited investigationFinal reportPik 20 · Julian, PAThe glider was assembled and all controls checked for freedom of movement prior to takeoff. During initial takeoff and climb, while in tow, the acft pitched nose up abruptly breaking the tow rope. The acft was then observed to turn right and nose down into…NTSB NYC87LA141Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmyra, PAStudent pilot experienced up and downdrafts while on approach for landing at reigle airport. The pilot was unable to maintain directional control during roll out, ran off the left side of the runway, and across a grass field. The acft then nosed over when the…NTSB NYC87LA136Accident · No injuriesLimited investigationFinal reportBeech BE-18 · York, PAWhile the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire…NTSB NYC87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · W.Mifflin, PAPilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground.NTSB NYC87LA129Accident · No injuriesLimited investigationFinal reportBell 47G · Bethel, PAThe student pilot lost directional control of the helicopter and as the instructor pilot attempted to regain control, the main rotor blades struck the ground causing substantial damage to the aircraft.NTSB NYC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lehighton, PADuring takeoff roll, the flight encountered a wind gust and the plt aborted the takeoff at about 1500 feet from the takeoff point. The acft continued to slide off the end of the runway, down a slope and across a road impacting two trees.NTSB NYC87FA127Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · York, PAThe Piper PA-28-180 was making an NDB instrument approach under instrument meteorological conditions at night. The pilot manuevered the aircraft over the airport several times in an apparent attempt to acquire visual contact with the runway, lost control of…NTSB NYC87LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Pottstown, PADuring landing approach to runway 28, ground fog was encountered and the pilot overshot his intended touchdown point. The pilot stated that he slowed the airspeed to zero mph and the acft started to shake and fall even though the motor and rotor were at 100%…NTSB NYC87FA119Accident · 4 fatalField investigationFinal reportCessna 172N · Ferguson Twnshp, PAThe pilot, who had not completed his checkout in a Cessna 172, was observed to make a long landing and lift off with approximately 750 ft of runway remaining. The aircraft was observed to enter a nose high pitch attitude and drift into a right turn. The…NTSB NYC87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Du Bois, PAThe student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then…NTSB NYC87LA092Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Tunkhannock, PAThe plt was lndg on a grass rwy with an access road bordering the apch end. Across the road from the rwy threshold, there was a pile of snow which previously had been plowed from the rwy. In reference to lndg at ngt, the plt stated, 'coming in on final, I…NTSB NYC87FA095Accident · 2 fatalField investigationFinal reportCessna 152C · Port Matilda, PAThe university student departed the university air park airport in state college, PA on a local flight in VFR weather conditions. The aircraft nosed into the ground in an approximate 70 degree dive about 10 minutes after takeoff. The pilot was engaged in low…NTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.NTSB NYC87LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Beaver Falls, PAThe pilot attempted a turn while taxiing and added power to taxi over soft ground. The pilot did not realize the close proximity of aircraft wing tip to the hanger. The edge of the right wing caught a part of the hanger and was substantially damaged.NTSB NYC87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Marienville, PAThe Cessna 172 experienced a total loss of power while cruising at 4000 ft on an IFR flight plan. The pilot made a landing on a road and clipped a road sign after touchdown, the aircraft swerved into a ditch and received susbtantial damage. The two occupants…NTSB NYC87LA075Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, PAThe personal flight with four occupants on board landed about 40 feet short of the runway after completing two successful touch and go landings. Pilot stated that the wind was at 220 degrees at 10 knots.NTSB NYC87LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyertown, PAStudent pilot on a solo cross-country flight experienced fuel exhaustion, landed in a field and collided with a stonewall. The aircraft was substantially damaged and the pilot received minor injuries.NTSB NYC87DHA01Accident · No injuriesFinal reportPiper PA-28-180 · Lehighton, PAStudent pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch.NTSB NYC87FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Carlisle, PAThe student pilot flying a Cessna 152 scheduled his flight period so it coincided with another student pilot flying a Cessna 172. The pilot of the Cessna 172 reported seeing the Cessna 152 enter a two turn spin and recover. He then said he lost sight of the…NTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…NTSB NYC87DGM01Accident · Serious injuriesFinal reportMooney M20F · Eighty Four, PAThe pilot reported experiencing a rise in the acft's EGT and a loss of power during cruise flt. A forced landing was made during which the acft contacted trees. Examination of the fuel system showed that both the main fuel screen and the micro screen in the…NTSB NYC87FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Glen Mawr, PADrg arrival, the acft was vectored to intercept the ILS rwy 27 localizer (LOC) bfr reaching the munci initial apch fix (iaf), which was 21.5 mi fm the rwy. The ATC controller (ctlr) told the plt to maint 4000' until on the LOC, then clrd him for the apch.…NTSB NYC87LA033Accident · No injuriesLimited investigationFinal reportCessna 33TC · Phillipsburg, PAThe Cessna 337 experienced engine surging and plt made a precautionary landing at an airport while enroute to destination. The aircraft landed 200 ft short of the runway and received substantial damage while the two occupants were not injured. On scene…NTSB NYC87LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Philadelphia, PADuring hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the…NTSB NYC87LA031Accident · No injuriesLimited investigationFinal reportBeech BE18H · Pittsburgh, PAThe aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll.NTSB NYC87LA044Accident · No injuriesLimited investigationFinal reportCentrair 101A · Julian, PAThe pilot had decided to land following a 41 minute flt. The plt reported his airspeed was too fast during the landing apch and he over compensated which resulted in too slow of an airspeed. The glider touched down hard, became airborne and landed hard a…NTSB NYC87LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Port Matilda, PAThe aircraft experienced power loss for unknown reasons while cruising at 4500 feet MSL. An emergency landing was executed in an open field in a heavily wooded mountainous area. The aircraft was substantially damaged, and there was no fire. The pilot, being…NTSB NYC87LA009Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Erwinna, PAFlight encountered turbulence on descent below tree top level and when about 150 feet from the threshold a downdraft was encountered causing the aircraft to collide with the ground. The aircraft groundlooped when the left wing caught in the tall grass.NTSB NYC87LA004Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Derry, PAThe flight suffered an engine power loss while in cruise flight due to fuel starvation. The pilot stated that a pretakeoff check of fuel gauges was made and they all indicated fuel on board.NTSB NYC86LA244Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Beaver Falls, PAThe plt stated that the acft experienced engine problems during cruise flt and crashed about one mile northeast of Beaver Falls, PA. Post accident testing revealed that the engine was capable of developing power in accordance with the manufacturer's…NTSB NYC86LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140C · Indiana, PAThe acft was substantially damaged during a forced landing following a loss of eng power. Examination of the acft showed the fuel selector was on the the left tank which contained no useable fuel. There was useable fuel remaining in the right tank. The plt…