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 NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…NTSB NYC84LA260Accident · No injuriesLimited investigationFinal reportCessna 335 · University Park, PAThe acft experienced a rt main gear collapse during landing. The plt stated that the gear was checked down & locked on base & final apch. After landing, according to the plts statement, the landing gear warning sounded & the acft started aturn to the rt. A…NTSB NYC84LA244Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PADuring the initial climb at aprx 10 ft AGL the airspeed dropped to 40 KTS and the stall warning horn came on. The plt pushed the nose down to prevent a stall. The right wing dropped and the acft veered off the rwy on touchdown. The acft then contacted a tree…NTSB NYC84LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Canton, PAThe pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…NTSB NYC84LA254Accident · No injuriesLimited investigationFinal reportCessna 310I · York, PAThe pilot stated that he was performing touch and go landings and was climbing after his fifth takeoff when the right engine lost power. The pilot continued to state that the landing gear was cycling up when the loss of pwr occured. The aircraft stopped…NTSB NYC84LA251Accident · Minor injuriesLimited investigationFinal reportCessna C172 · Bloomsburg, PAThe acft was ditched in a river during an attempted go-around. The plt said he approached the arpt with full flaps at about 70 mph. During the aborted landing he applied full power and then experienced a sudden low left wing, a mushy control feeling and a…NTSB NYC84LA249Accident · No injuriesLimited investigationFinal reportCessna C172 · Sandy Lake, PAThe acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no…NTSB NYC84LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe student plt landed in a corn field short of the rwy on his 3rd solo landing. The plt stated that he 'misjudged the end of the rwy.' He also said he should have had a 'higher approach speed.'NTSB NYC84LA238Accident · No injuriesLimited investigationFinal reportScheibe Flugzeugbau SF-27M · Grove City, PAThe motorglider lost power after takeoff. According to the plt the takeoff seemed long but he did not abort because thiswas his first self-launch and he was unsure of the operation. About 200 ft AGL a turn was made to the east to return to the arpt and the…NTSB NYC84LA237Accident · No injuriesLimited investigationFinal reportSchleicher ASW-15 · Fairfield, PAThe glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft…NTSB NYC84FGM06Accident · Serious injuriesFinal reportTeratorn II · Brownsville, PAThe owner/plt had previous flown the home built acft which was constructed similar to an ultralight. An optional pilot enclosure (canvas covering over the plt compartment) had just been installed. On 7/7/84, the owner/plt taxi checked the acft for about 30…NTSB NYC84FGM05Accident · No injuriesFinal reportBell 47G-5 · Penn Run, PAThe plt was spraying a potatoe field with a lightly loaded helicopter when the eng failed. At that time, the helicopter was about 10 ft AGL in a slight right turn & at aprx 35 mph. The plt flared to stop the forward movement & landed, but the tail rotor…NTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…NTSB NYC84FU004Accident · Serious injuriesFinal reportTeratorn TA · Landenberg, PAThe plt had previously flown 75 to 80 hrs in an ultralight controlled by a combination of weight-shift & rudder. On the day of the accident, he & his partner had practiced a series of crow hops in a Teratorn ta. The Teratorn ta was a 3-axis controlled…NTSB NYC84LA213Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Monongahela, PAThe certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal…NTSB NYC84LA212Accident · No injuriesLimited investigationFinal reportHiller 12E · Meadville, PAThe acft flew into wires during a crop spraying mission. The acft was flying at about 5-10 ft when a flash was seen overhead. The acft vibrated and slowed before impacting the ground and rolling over.NTSB NYC84LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perkasie, PAThe sailplane lost lift and during a forced landing wires were spotted on the approach. In attempting to fly under the wires the acft was flown into an embankment.NTSB NYC84LA215Accident · No injuriesLimited investigationFinal reportCessna C172 · Patton, PAThe plt landed fast and long and before running off the end of the 1750 ft rwy he turned right toward the ramp. A gust of wind caught the acft and the acft collided with a ditch beside the ramp.NTSB NYC84LA210Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Mahaffey, PAThe acft veered off the prepared landing area in tall weeds and rocks where it nosed over. The plt had changed from a gravel rwy to the dirt one because of downdrafts. The 1st landing on the dirt rwy was made on the wheels and when the tail lowered the plt…NTSB NYC84LA204Accident · No injuriesLimited investigationFinal reportHughes 500D · Bedford, PAAccording to the plt, the helicopter took off with under 200 lbs of fuel indicating on the fuel gage. Fifteen minutes after takeoff at 125 ft AGL the engine out warning system indicated an engine failure. The acft began to rotate about its vetical axis and…NTSB NYC84LA206Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Patton, PAEng quit at an alt of 50-75 ft after takeoff. A forced landing was made in a plowed field. The acft was removed from thefield and examined by a FAA airworthiness inspector at a later date. Inspection revealed the fuel tank was empty and thegascolator was…NTSB NYC84IA200Incident · No injuriesIncident investigationFinal reportBoeing 720-025 · Philadelphia, PAWhile climbing thru 600 ft after takeoff, the crew heard a loud bang, the acft shuttered & the #3 eng fire warning light illuminated. A fire bottle was discharged. The coplt saw flames coming from the eng & the fire warning light remained illuminated, so a…NTSB NYC84FGT02Accident · No injuriesFinal reportBell 47G-3 · Landisburg, PAThe helicopter lost eng power while turning on approach for landing, autorotated to a hard landing with main rotor contact to the tail boom. Two gals of fuel were drained from the acft fuel tank at the accident site. An eng run up was performed & found…NTSB NYC84FGM04Accident · No injuriesFinal reportHiller UH-12E · Sigel, PAThe plt was on an aerial application flt over a wooded area. According to him, he had a tail rotor problem & it was necessary to extend his glide to reach an open area. Subsequently, the helicopter landed hard & the main rotor blades struck & severed the tail…NTSB DCA84AA024Accident · 4 fatalFinal reportLockheed L-188 · Chalkhill, PAAfter departing the baltimore-washington arpt, the acft had climbed to FL 220. According to info on the cockpit voice recorder (vcr), the crew experienced gyro problems during the climb. They selected the #1 vertical gyro to drive both approach horizons…NTSB NYC84LA187Accident · No injuriesLimited investigationFinal reportCessna 177 · Annville, PAThe plt stated that during an aborted landing while trying to recover from a bounced touchdown he misused the flaps. Once airborne the acft settled into a wheat field. The plt stated excessive airspeed was gained during the steep landing apch.NTSB NYC84LA185Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Williamsport, PAThe aircraft was engaged in student flight training; the student was performing touch and go landing in shifting, gusty wind conditions. A gust hit the aircraft on short final and the student was unable to recover control before a hard landing and bounce…NTSB NYC84FA184Accident · 1 fatalField investigationFinal reportCessna T210M · Bloomsburg, PAThe acft collided with pwr lines during an attempted go-around. Witnesses stated the acft was nose low until just prior to touchdown when it pitched up. The acft bounced into the air and touched down on the nose gear. The acft 'rocked side to side' on the rwy…NTSB NYC84FGT01Accident · Serious injuriesFinal reportMooney M20C · Slate Run, PAThe acft crashed shortly after takeoff from the black forestairport. Investigation revealed that the acft traveled approx 2/3RDS of the rwy distance, became airborne, settled back on the rwy & became airborne again. At the time of takeoff the acft was loaded…NTSB NYC84FHD02Accident · 1 fatalFinal reportCessna 337 · Coatsville, PAAfter touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in…NTSB NYC84LA174Accident · No injuriesLimited investigationFinal reportBeech Bonanza F33A · Tarentum, PAPlt made lndg apch to rwy 02 at 95 mph, flaps one-third down and rt wing down for wind compensation. Plt stated winds were at 090 deg. At 30 ft above the rwy the acft encountered a sudden gust of wind from 270 deg. The acft drifted to thert side of the rwy…NTSB NYC84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montrose, PAPilot attempted to land on a 2200 foot grass runway. The plt overshot the runway and attempted to go-around. The aircraft collided with trees at the end of the runway.NTSB NYC84FA170Accident · 1 fatalField investigationFinal reportI.C.A. Brasov IS-29D2 · Collegeville, PAAccording to a witness who ran the wing of the glider during takeoff, at 250 to 300 ft AGL the tow acft turned left but the glider maintained rwy heading. Shortly thereafter the tow line released at the glider-end and the glider initiated a right turn. After…NTSB NYC84FA163Accident · 2 fatalField investigationFinal reportCessna 310K · New Cumberland, PAThe plt departed VFR without a formal wx briefing or filing a flt plan. The wx at dest was VFR when the plt departed. The forecast indicated that ceilings would lower. The wx did, in fact, deteriorate while the flt was enroute and the plt obtained an IFR…NTSB NYC84FA157Accident · 1 fatalField investigationFinal reportCessna A152 · Bethlehem, PAThe acft crashed while spinning from low alt. The acft was observed by witnesses doing aerobatics at low alt. At the topof loop or vertical climb the acft did a hammerhead stall under power and went into a spin. It appeared to one witness as if the plt was…NTSB NYC84FA148Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Hopwood, PAThe ATP rated pilot obtained a complete wx briefing including forecasts of occasional moderate icing, a cleveland center wx advisory, winds aloft with temps at the flt planned alt of 6000 ft ranging from -1 to -4 deg c and pireps of moderate icing from 5000…NTSB NYC84LA145Accident · No injuriesLimited investigationFinal reportCessna A185F · Hazleton, PAAccording to the plt, he attempted to takeoff on rwy 28 with a variable wind from 180 deg at 9 KTS gusting to 19 KTS. After rolling about 200 ft, he gradually added power, but the acft began turning left, so he reduced the power. The acft straightened out,…NTSB NYC84LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its…NTSB NYC84FA142Accident · 1 fatalField investigationFinal reportBeech 58 · Bentley Creek, PAThe last radio call made by the plt was at 0658 EST when he reported level at 8000 ft. radar data at 0708 EST, showed the acft changing heading from 327 to 335 degrees, alt decreased from 8000 to 5000 ft and ground speed increased from 179 to 188 KTS.…NTSB NYC84FGM03Accident · Minor injuriesFinal reportBliss Corbin Baby ACE CM-1 · Emporium, PAOn final approach the acft struck several trees, the pilot lost control of the acft. The acft then struck telephone wires & a pole and crashed.NTSB NYC84FA135Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, PAThe acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light…NTSB NYC84LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Jeanette, PAOne of the aircrew members was buying the acft & was receiving dual instruction before flying solo. After several landings, he flared for a 3-point landing. During the landing roll, the acft began drifting left & the student correctedback to the right. The…NTSB NYC84LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Forty Fort, PADuring a supervised solo flt, the student plt had difficulty with directional control on his 6th landing. Subsequently, the acft swerved & the landing gear and wing were damaged.NTSB NYC84LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Factoryville, PAPlt stated that he inadvertently allowed the acft to drift left during the landing roll when he reached for the hand brake. The left main and nose gears contacted a snow bank and the acft nosed over.NTSB NYC84LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Reedsville, PAThe plt reported that at about the time he applied power to takeoff, the acft veered to the left. He stated that his efforts to return the acft to the centerline of the rwy did not work. Subsequently, the acft went thru a snowbank beside the rwy, then entered…NTSB NYC84LA119Accident · No injuriesLimited investigationFinal reportCessna C172 · Corry, PAThe pilot stated that he landing on runway 32 and on initial touchdown the nosewheel contacted the runway after the right main gear, causing the aircraft to ascend back into the air. The aircraft 'porpoised', the left wing tip dipped and collided with a…NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB NYC84LA112Accident · No injuriesLimited investigationFinal reportBeech 76 · Pittsburgh, PADuring the takeoff portion of a touch-&-go, the student plt forgot to raise the flaps. The instructor (CFI) yelled at the student '...the flaps', & at the same time, reached for the flaps with his right hand under the control wheel. Subsequently, the left…NTSB NYC84LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · West Mifflin, PAThe acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy.NTSB NYC84FA104Accident · 1 fatalField investigationFinal reportCessna 172Q · Meadville, PAPlts were briefed on snowstorm advancing toward destination, departed in hope of arriving ahead of wx. Encounting IMC conditions (snow) enroute, plt filed IFR and continued. Communications transcript indicates that when eng began to lose power, plt used carb…