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 NYC88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lairdsville, PAThe Cessna 172 took off on a solo x-c flight with a student pilot/owner operator at the controls. After takeoff. The pilot reported a loss of engine power and made an off airport forced landing in a plowed field. The nose wheel dug in after approx 200 ft and…NTSB NYC88LA144Accident · No injuriesLimited investigationFinal reportCessna 150F · West Chester, PAThe pilot preflighted the aircraft and performed a runup before takeoff. The flight departed from runway 27. When the aircraft reached about 200 feet, the engine experienced a power loss and altitude could not be maintained. The pilot elected to land in a…NTSB NYC88IA141Incident · No injuriesIncident investigationFinal reportCessna S550 · Allentown, PAWhile cruising at FL350 in light turbulence, the trailing half of the left hand outboard trailing edge flap separated from the acft. The pilot declared and emergency and landed at poughkeepsie, new york, without further incident. The portion of the damaged…NTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…NTSB NYC88FA131Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Thomasville, PADue to the pilot's improper preflight planning, he attempted to takeoff with his aircraft weight above the maximum gross weight in a high unfavorable 90 degree crosswind, failed to maintain directional control, and collided with trees.NTSB NYC88LA134Accident · No injuriesLimited investigationFinal reportBeech C17B · Butler, PAAfter landing the airplane was taxiing on runway 08 when it went off the side of the runway and struck a runway light and taxi sign. While attempting to get back on the runway, the left gear collapsed.NTSB NYC88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Slatington, PAThe pilot landed at Slatington, Pennsylvania during strong wind conditions. When the pilot applied brakes, a sudden gust of wind lifted the left wing and pushed the aircraft off the right side of the runway down an embankment, and into a tree stump.NTSB NYC88LA122Accident · No injuriesLimited investigationFinal reportCessna 172 · Myerstown, PAThe pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.NTSB NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.NTSB NYC88LA118Accident · No injuriesLimited investigationFinal reportCessna 150 · Downingtown, PADuring takeoff from shannon airport, the flight experienced an engine power loss and crashed. Pilot stated that water was found in the carburetor. The plt said after the acc that after the power loss he noticed powerlines and houses in front and made a sharp…NTSB NYC88LA116Accident · No injuriesLimited investigationFinal reportBell 206L · Allentown, PADuring an FAA flight check an autorotational descent was made with a planned power recovery, the helicopter fell through the maneuver and collided with the ground. The main rotor blades flexed downward, striking the horizontal fin winglets and the tail boom.NTSB NYC88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Erie, PAThe pilot failed to maintain flying speed and the airplane settled back onto the runway and ran off the end.NTSB NYC88LA113Accident · No injuriesLimited investigationFinal reportPiper J-3 · Downingtown, PAThe pilot was performing touch and go wheel landings. During an approach the pilot came in too low and the right main landing gear impacted an electric power pole. The pilot landed the aircraft on a grass strip with only the left main gear then flipped…NTSB NYC88DGT01Accident · 1 fatalFinal reportNorth American F-51D · State College, PAN51WE, a North American F-51D took off as the second ship of a two ship flight with N6341T, another F-51D. They were observed climbing in formation into the clouds. N6341T assumed communications and said they were a flight of 2 and ok, after ATC was unable to…NTSB NYC88LA092Accident · No injuriesLimited investigationFinal reportCessna 182 · Westfield, PAThe pilot was attempting a soft field takeoff with full power and right rudder applied. During ground run, the tail of the aircraft struck a snowbank, pulling the aircraft into the snow. When the left main gear hit the snow the aircraft flipped over onto its…NTSB NYC88LA083Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Waterfall, PAShortly after takeoff, the pilot heard a loud 'boom' and experienced a loss of tail rotor control accompanied by an increase in N2 and RPM. A radio transmission was made to the aircraft that was trailing and then an approach for landing set up. On landing,…NTSB NYC88LA085Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Philadelphia, PAThe Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing…NTSB NYC88DHA02Accident · 1 fatalFinal reportGribosh LONG-EZ · Perkasie, PAThe homebuilt airplane was being operated on its second test flight after manufacture. Witnesses stated that they heard the engine 'making power changes' and 'surging' while the airplane was maneuvering at 30 to 50 feet above the ground. Also, they reported…NTSB NYC88FA072Accident · 1 fatalField investigationFinal reportCessna 337E · Friedens, PAThe 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…NTSB NYC88IA078Incident · No injuriesIncident investigationFinal reportBeech 1900C · Philadelphia, PAThe Beech 1900C took off on a scheduled commuter flt. When attempting to level the aircraft at 5000 ft, the co-pilot was unable to push the control wheel forward FAR enough to level off. By reducing power, the crew was able to compensate. The crew…NTSB NYC88FA069Accident · 2 fatalField investigationFinal reportCessna 182L · Waynesburg, PAShortly after departure from runway 26, the aircraft engine failed. The aircraft banked to about 90 degrees, descended and impacted the ground. A flight instructor described the wind as very gusty and varying out of the south at approximately 10-20 knots. The…NTSB NYC88LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Honesdale, PAShortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the…NTSB NYC88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pottstown, PADuring soft field takeoff, the instructor pilot who was watching from the ramp, said the the student plt seemed to have excessive angle of attack and stalled the aircraft. The aircraft crashed on airport property about 1,000 feet from the start of the takeoff…NTSB NYC88LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Middletown, PAAfter landing the pilot was cleared to taxi to the parking area at stanbaugh's general aviation. During a maneuver between a de-icer truck and a parked airplane, the pilot allowed the aircraft to become too close to the truck and caught the wing tip on the…NTSB NYC88LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Montoursville, PAAfter takeoff, the plt remained in the traffic pattern to practice takeoffs & landings. He made a touch-&-go, then rprtd on a right downwind for another landing. He acknowledged a clearance to continue, but moments later, an ELT signal began transmitting.…NTSB NYC88FA041Accident · 4 fatalField investigationFinal reportMooney M20C · St. Marys, PAWhile getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the…NTSB NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…NTSB NYC88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jeannette, PAThe aircraft suffered an engine failure during approach and crashed short and to the right of the runway. The acft then nosed over. Post acc investigation and engine exam by the FAA revealed no reason for the eng malfunction.NTSB NYC88LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver Falls, PADuring hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.NTSB NYC88LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erwinna, PAThe pilot was landing the aircraft on runway 25 at vansant airport. At about 100 feet down the runway, the aircraft veered to the left, off of the runway and slid down an embankment and came to rest after colliding with a tree.NTSB NYC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-4 · St. Paul, PAThe flight was enroute from mount pleasant to winchester, Virginia on a heading of 140 degrees and at 4500 feet. About 25-30 minutes into the flight, engine power loss was experienced. The pilot switched from the auxilliary to the main fuel tank and applied…NTSB NYC88LA010Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Henryville, PAOn takeoff from a private airport, the flight encountered downdrafts and the left wing dropped. As the pilot attempted to level the wings, he realized that the aircraft was no longer climbing but descending at a rapid rate. The aircraft crashed on rising…NTSB NYC87LA271Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Waynesburg, PAThe pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the…NTSB NYC87LA267Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Irwin, PADuring taxi operation, the pilot lost directional control of the aircraft and it struck a tree stump which was located to the side of the runway. The aircraft then continued to roll about 500 feet off the rwy where it came to rest with substantial damage.NTSB NYC87FA262Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Montoursville, PAThe plt initiated the ILS approach and acknowledged a frequency change. The acft was found on a steep hill one mile south of the airport. No evidence of an engine or control system malfunction was found. It appeared that the pilot made a missed approach and…NTSB NYC87FA260Accident · Serious injuriesField investigationFinal reportBoeing 737 · Philadelphia, PAThe acft was in a holding pattern at 11,000' in an area of thunderstorms & turbulence. Although the seat belt sign was on, two passengers (pax) went to the aft lavatory. As one of the pax was waiting & the other was exiting the lavatory, the acft encountered…NTSB NYC87FA257Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Pittsburgh, PAWhile descending out of flt lvl 270 for lndg, usair flight 10 encountered light to moderate turbulence. Prior to this this encounter, the capt advised all passengers and cabin crew to remain seated and to engage their seatbelts. A similar announcement was…NTSB NYC87LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Emmaus, PADrg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank…NTSB NYC87LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Scottdale, PADuring a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…NTSB NYC87DGM03Accident · No injuriesFinal reportWoody Pitts S1 · Irwin, PAThe pilot's inability to maintain control of the aircraft during initial climbout. Inadvertent use of the rudder controls was a factor.NTSB NYC87LA256Accident · No injuriesLimited investigationFinal reportCessna 310N · Williamsport, PAAfter landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut…NTSB NYC87DHA02Accident · 2 fatalFinal reportKolb Twinstar · Hilltown, PAAfter the acft took off, witnesses heard a power change & saw what appeared to be a left turn to return to the grass strip. Subsequently, it entered a descent & crashed in a left wing down, nose low attitude. The passenger was taken to a hospital, but died…NTSB NYC87LA247Accident · No injuriesLimited investigationFinal reportCessna 172M · W. Mifflin, PAThe non-certificated pilot took the aircraft without authorization. The aircraft crashed during an attempted landing on runway 10 at allegheny county airport and was substantially damaged. There were two passengers on board but they were not injured. The plt…NTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…NTSB NYC87LA246Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Harrisburg, PAThe aircraft engine lost power while descending for a landing. The plt stated that when he advanced the throttle the engine quit completely. During lndg alongside a turnpike, the nose wheel collapsed and the prop was damaged. Investigation revealed that the…NTSB NYC87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Montgomeryville, PAWhile climbing through about 1500' after takeoff, the engine began to lose power. The pilot turned back toward the airport, but subsequently all power was lost & the aircraft was damaged during a landing in a corn field. A post- accident examination revealed…NTSB NYC87FA241Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Selinsgrove, PAThe pilot was conducting a demonstration flight in an overweight aircraft in conditions of low ceilings and fog. After a touch and go landing the aircraft stalled during the takeoff then collided with the ground. Exam of the wreckage did not disclose any…NTSB NYC87LA238Accident · Serious injuriesLimited investigationFinal reportBoeing B-17G · Beaver Falls, PADrg an apch in gusty winds, the plt noted a rgt x-wind. He stated that after touchdown, the roll-out was stabilized for a short distance, then the rgt wing began to lift. He applied full aileron & rudder to maint control, but was unable to stop on the…NTSB NYC87LA224Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · York, PAThe Ercoupe model 415 experienced a loss of power in flight. The pilot made a forced landing in a field. He went under some power lines, however, he could not avoid the telephone lines and went through them. The pilot received serious injuries and the…NTSB NYC87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Prospectville, PAThe student plt was practicing takeoffs & landings. He rprtd that on the 2nd apch, he appeared to be landing too long, so he initiated a go-around. However, he said the acft then entered a departure stall & settled into shrubs & trees adjacent to the rwy.