NTSB investigations, PA
68 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
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\" = 230)
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" = 230) 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 NYC08CA072Accident · No injuriesData collectionFinal reportBeech BE-55 · Lancaster, PAThe pilot's failure to maintain a proper glidepath during the landing approach. Contributing to the accident was the pilot's improper decision to fly with known deficiencies in equipment, and the icing conditions.NTSB NYC06FA104Accident · 1 fatalField investigationFinal reportCessna 172L · Montgomery Twp, PAAn impact with mountainous terrain for an undetermined reason.NTSB NYC03FA176Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Pleasantville, PAThe pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.NTSB IAD03FA001Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Bradford, PAThe pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.NTSB DCA01MA065Accident · 44 fatalMajor investigationFinal reportBoeing 757 · Shanksville, PAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB NYC01FA040Accident · 3 fatalField investigationFinal reportMooney M20K · Rixford, PAThe pilot's loss of control of the airplane while maneuvering. Factors included low ceilings and the pilot's lack of instrument flight experience.NTSB NYC00FA257Accident · 1 fatalField investigationFinal reportCessna 172L · Mill Creek, PAThe pilot's improper pre-flight planning, and in-flight planning decision to continue visual fight into deteriorating adverse weather conditions. Factors were the night conditions, low clouds and fog.NTSB NYC00LA160Accident · Minor injuriesLimited investigationFinal reportBryant/Rhodus LONG-EZ · West Chester, PAWas the failure of the pilot to attain his proper touchdown point. Factors were the downdraft and rising terrain leading to the runway.NTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.NTSB NYC99LA165Accident · 2 fatalLimited investigationFinal reportLakeland Ultralites Kolb Mark III · Clark, PAThe pilot's improper decision to perform an aerobatic maneuver with inadequate altitude for recovery/clearance.NTSB NYC99LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Tinicum, PAThe pilot's failure to maintain a proper altitude above the water.NTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…NTSB NYC98LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Warren, PAThe pilot's failure to obtain the proper touchdown point.NTSB IAD98LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAThe pilot's failure to attain the proper touchdown point. Related factors were tailwind, and lack of total experience.NTSB NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.NTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.NTSB NYC97LA050Accident · No injuriesLimited investigationFinal reportBerry Vans RV-4 · York, PAthe pilot's delay in initiating a go-around, and his failure to maintain airspeed, which resulted in an inadvertent stall/mush and contact with the terrain.NTSB NYC96LA053Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-6 · Allentown, PAthe pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.NTSB NYC96LA044Accident · 1 fatalLimited investigationFinal reportCessna 182E · Pymatuning, PAthe pilot's intentional suicide.NTSB NYC95FA162Accident · 1 fatalField investigationFinal reportCessna 140 · Danielsville, PAThe flight crew's improper in-flight planning/decision, and failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors relating to the accident were: darkness, fog, low clouds, and the high terrain.NTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…NTSB BFO94LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Slatington, PAThe pilot's inadequate compensation for wind conditions and failure to maintain alignment with the runway. The crosswind was a factor.NTSB BFO93LA180Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottdale, PAThe pilot's selection of unsuitable terrain for landing and his delay in performing remedial action.NTSB BFO93LA098Accident · 1 fatalLimited investigationFinal reportCessna 150 · Milroy, PAThe pilot's inadvertent flight into instrument meteorological conditions, and his failure to maintain clearance with terrain. Factors related to the accident include mountain obscuration and fog.NTSB BFO93LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Philipsburg, PAThe inadequate removal of snow from the runways by airport personnel and the procedures/directives for airport snow removal not understood.NTSB NYC92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · West Mifflin, PAA yaw for unknown reason(s) which resulted in the tail rotor contacting the dirt bank and a loss of control. A factor related to the accident was the decision of the pilot to operate in close vicinity to the dirk bank.NTSB BFO92LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beavertown, PAThe pilot's failure to maintain ground clearance. Contributing to the accident was a downdraft and insufficient altitude.NTSB NYC92FA079Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Hamburg, PAThe pilot's improper in-flight decision, his failure to follow proper IFR procedures, and an improperly planned approach, which resulted in an inflight collision with rising terrain during the execution of the missed approach procedure. Factors related to the…NTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB NYC91FA067Accident · 4 fatalField investigationFinal reportMBB BK 117 B-1 · Sonestown, PAThe pilot's inadequate preflight planning to assure that the intended course and altitude provided adequate terrain clearance. Contributing factor(s) was: the dark night, snow and mountainous terrain.NTSB NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.NTSB NYC91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Easton, PAThe flight instructor allowed the airplane to get too low on final approach during the demonstration of a power off landing.NTSB NYC90LA062Accident · No injuriesLimited investigationFinal reportCessna 182N · Milford, PAThe loss of directional control by the pilot during a short soft field takeoff on a snow packed runway.NTSB NYC89LA187Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Mount Joy, PAThe pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.NTSB NYC89LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Doylestown, PAImproper preflight preparation by the pilot by taking off with the flaps extended, which resulted in an inadequate rate of climb to clear obstructions beyond the end of the runway, and the pilot's delay in aborting the takeoff and his failure in maintaining…NTSB NYC89FA022Accident · 1 fatalField investigationFinal reportCessna 207 · Monoghan, PAEvidence indicates that the airplane flew straight into the side of a 1320 ft mountain at the 1280 ft level. The recommended minimum flight altitude for this designated mountainous area, at night, is 3500 ft. there was no evidence of any mechanical problems.NTSB NYC88LA217Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Wellsboro, PAThe pilot attempting a takeoff in an over grossed aiarcraft in high density altitude and flew off the end of the runway into high grass.NTSB NYC88LA194Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bally, PAThe plt was taking off with a left tailwind/crosswind. At liftoff, the left wing dropped and the pilot attempted to correct with rudder. The acft collided with the terrain.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 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 NYC86FA199Accident · 4 fatalField investigationFinal reportRockwell 114 · Bedford, PAThe acft nearing the close of a x-country flight had requested a decent to start an approach to land at its final destination. ATC had granted the request, but stated to the pilot that he most remain VFR, the pilot acknowledged the clearance. Acft was located…NTSB NYC86LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lock Haven, PAThe pilot made a departure from an uncontrolled airport. During the climb in IMC conditions, the aircraft struck trees and crashed. The aircraft received substantial damage and the pilot received serious injuries. The pilot had a clearance, however, the…NTSB NYC86LA139Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Johnstown, PAThe flight departed Johnstown-cambria airport at about 1600 hours and returned at about 1700 hours. On landing, the pilot forgot to lower the landing gear and landed gear up. The aircraft slid to a stop and about five minutes later fire erupted.NTSB NYC86LA099Accident · No injuriesLimited investigationFinal reportSikorsky S-76 · Safe Harbor, PAThe helicopter was maneuvering at low altitude, low airspeed, while on a search and rescue mission at night, looking for a capsized boat, when it impacted the water.NTSB CHI86MA025Accident · 5 fatalMajor investigationFinal reportCessna 441 · Derry, PADrg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…NTSB NYC86FA006Accident · 1 fatalField investigationFinal reportde Havilland DHC-6 · Homer City, PAThe acft was observed flying at low altitude along about a 5 mile distance. Some witnesses described the acft altitude as just above treetops. Witness heard engine sounds and saw lights on the acft. The acft flight was on a southeast direction before it…NTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…NTSB NYC85FA064Accident · 2 fatalField investigationFinal reportBeech G90 · St. Mary'S, PAThe acft crashed during a log DME approach. According to ATC the acft crashed after making a procedure turn at the faf. The winds in the area were being called 250 degrees at 10 KTS gusting to 28 knts. A caution on the apch plate has a remark,-'precipitious…NTSB NYC85FGT01Accident · Serious injuriesFinal reportCessna 335 · Barrville, PAThe Cessna 335 was making a contact approach when it flew into the ground. The aircraft received substantial damage and the pilot received serious injuries. Winds in the area were reported at 25 knots with gusts to 35 knots. Visual meteorological conditions…