Skip to content

NTSB investigations, PA

28 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
  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'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310)
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 NYC05LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Philadelphia, PAThe failure of the ground controller to coordinate the runway crossing of a maintenance tug, with the local controller, which resulted in a ground collision with an MU-2 airplane during it's takeoff roll.Nov 30, 2004 · N941MA · Substantial damage NTSB NYC05LA013Accident · Minor injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAThe flightcrew's misjudged clearance from a parked airport vehicle while taxiing. A factor was the vehicle operator's improper decision to park within a taxiway safety area.Oct 27, 2004 · N592ML · Substantial damage NTSB IAD02LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Williamsport, PAThe student pilot's failure to maintain adequate clearance from a building while taxiing.Aug 5, 2002 · N739GV · Substantial damage NTSB NYC02LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe student pilot's failure to maintain adequate clearance while maneuvering to avoid obstructions.Jun 19, 2002 · N95035 · Substantial damage NTSB IAD02LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Doylestown, PApilot's failure to maintain clearance between the airplane and a parked fuel truck while taxing.Jan 26, 2002 · N172P · Substantial damage NTSB IAD02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PACollision with a deer during the takeoff roll.Nov 16, 2001 · N9373W · Substantial damage NTSB NYC00LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Fredericksburg, PAWas the inadequate visual lookout by the pilot of the Stearman.Oct 9, 1999 · N52951 · 2 aircraft · Minor damage NTSB NYC98LA177Accident · No injuriesLimited investigationFinal reportDouglas DC-9-30 · Philadelphia, PAthe failure of the fuel truck driver to follow airport operating procedures, and yield the right-of-way to the airplane. Factors were the stopped airplane, which obscured the fuel truck from the approaching airplane and the approaching airplane from the fuel…Sep 2, 1998 · N927VJ · Substantial damage NTSB NYC98LA075Accident · Serious injuriesLimited investigationFinal reportFokker F-100 · Philadelphia, PAThe driver's failure to maintain clearance from the parked airplane. Related factors were night conditions and the driver's diverted attention.Mar 12, 1998 · N863US · Substantial damage NTSB IAD98LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Philadelphia, PAfailure of the tug driver to see-and-avoid the taxiing airplane.Jan 6, 1998 · N845AA · Minor damage NTSB NYC98LA013Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Pittsburgh, PAthe tug driver's failure to obey a stop sign and his failure to yield right-of-way to the airplane.Oct 15, 1997 · N162ZV · Substantial damage NTSB IAD96LA152Accident · No injuriesLimited investigationFinal reportCessna 182B · Hanover, PAthe pilot's improper planning/decision and failure to maintain clearance from obstacles during the landing roll. Related factors were: darkness, the lack of usable runway lights, and the road grading equipment parked 50 feet from the edge of the grass runway.Sep 22, 1996 · N2731G · Substantial damage NTSB IAD96LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Hanover, PAthe pilot's delay in aborting the landing. Factors related to the accident were: the lack of braking action on the wet grass runway, the pilot's lack of experience in the make and model of airplane, and the sign near the departure end of the runway.Aug 15, 1996 · N9103V · Substantial damage NTSB NYC93LA153Accident · No injuriesLimited investigationFinal reportCessna 172RG · Philadelphia, PAFailure of the cessa pilot to remain clear of the parked Beech C90.Aug 13, 1993 · N6419V · 2 aircraft · Substantial damage NTSB NYC91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Johnstown, PAA collision with a deer while landing. A factor related to the accident was night conditions which restricted the pilot's view of the deer until it was within the illumination of the landing light.Sep 13, 1991 · N38147 · Substantial damage NTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.May 23, 1991 · N739GV · Substantial damage NTSB NYC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Washington, PAThe pilot's failure to maintain clearance from objects while taxiing, and his visual lookout was inadequate.Jul 8, 1990 · N35551 · Substantial damage NTSB NYC90LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Philadelphia, PAThe failure of the pilot of N333TQ to taxi at a speed that would allow him to stop under existing conditions of visibility and taxiway conditions.Oct 11, 1989 · N333TQ · 2 aircraft · Substantial damage 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…Dec 1, 1987 · N32307 · Substantial damage 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…Jun 14, 1987 · N4889L · 2 aircraft · Substantial damage 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…May 17, 1987 · N4387X · Substantial damage 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.Feb 6, 1987 · N6539E · Substantial damage NTSB NYC85LA252Accident · No injuriesLimited investigationFinal reportBeech C35 · Wexford, PAAircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed.Sep 29, 1985 · N1886D · Destroyed NTSB NYC84LA020Accident · No injuriesLimited investigationFinal reportCessna 340 · Washington, PAThe pilot said that when about 8 miles out he called UNICOM to report in and receive advisories. He was told that horseshad been chased off the runway earlier and to use caution. During the approach he came in high and touched down about 700 feet down the…Nov 3, 1983 · N7632Q · Substantial damage NTSB NYC82DA196Accident · No injuriesFinal reportPiper PA-28-161 · Wilkes Barre, PAThe student pilot stated that as he began to taxi, he proceeded about 35 ft and then the aircraft suddenly veered to the left as if the wheel had locked. He applied right rudder, then right brake. However, the aircraft struck a building and an automobile.Aug 13, 1982 · N2962Q · Substantial damage 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.…May 10, 1982 · N77BF · Substantial damage 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…Apr 29, 1982 · N3DY · Substantial damage 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…Mar 20, 1982 · N6925Q · Substantial damage