NTSB investigations, PA
117 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 6 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 7 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 8 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2006 | 5 |
| 2007 | 3 |
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\" = 220)
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" = 220) 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 NYC07CA215Accident · 1 fatalData collectionFinal reportEbersole Hummel Ultra Cruiser · Newry, PAThe pilot's failure to maintain adequate clearance from trees while maneuvering.NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.NTSB NYC07LA114Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · New Holland, PAUnfavorable winds and terrain during a precautionary landing.NTSB NYC06CA194Accident · Serious injuriesData collectionFinal reportChampion 7FC · Harmonsburg, PAThe pilot's failure to maintain the proper altitude/clearance on final approach, which resulted in an in-flight collision with trees.NTSB NYC06FA156Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Philipsburg, PAThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into trees. Factors in the accident were the low cloud ceiling, and dark night conditions.NTSB NYC06CA150Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Mt. Holly Sprin, PAThe pilot's failure to maintain altitude/clearance from trees along his final approach path.NTSB NYC06CA111Accident · Serious injuriesData collectionFinal reportQuicksilver GT-400 · West Middlesex, PAThe pilot's failure to maintain adequate clearance from trees during the initial climb.NTSB NYC06CA109Accident · Serious injuriesData collectionFinal reportCessna 152 · Shamokin, PAThe pilot's failure to recover from a bounced landing, and her improper use of flaps during an aborted landing, which resulted in an in-flight collision with trees.NTSB IAD05LA008Accident · 1 fatalLimited investigationFinal reportCessna 180 · Freedom, PAThe pilot's failure to maintain obstacle clearance during the takeoff resulting in an in-flight collision with trees.NTSB NYC04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Collegeville, PAThe pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.NTSB IAD03FA070Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Factoryville, PAThe pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.NTSB NYC03LA110Accident · No injuriesLimited investigationFinal reportAgusta A109E · Harbor Creek, PAThe pilot's improper preflight inspection, during which he failed to remove a flashlight from the tailboom strake. A factor was the pilot's attention be diverted by a mechanic during the preflight inspection.NTSB NYC03LA087Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Waterford, PAThe pilot's inadequate visual lookout which resulted in the collision with the wire. Factors in the accident were the concealment of the poles by trees, the lack of contrast between the wire and grass field.NTSB NYC02LA194Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Erwinna, PAThe pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.NTSB NYC02LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clifford, PAThe pilot's failure to maintain a proper visual lookout for trees. A factor was sunglare.NTSB IAD02LA042Accident · No injuriesLimited investigationFinal reportWSK PZL PW-5 · New Smithville, PAThe pilot's inadequate evaluation of the weather which resulted in the loss of thermal lift and collision with trees.NTSB IAD02LA005Accident · Minor injuriesLimited investigationFinal reportAerostar SA-60A · Luxor, PAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion, and his subsequent inability to avoid power lines.NTSB NYC02LA008Accident · No injuriesLimited investigationFinal reportAerospatiale ATR 42-320 · Yardley, PAan in flight collision with birds.NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.NTSB IAD00FA079Accident · 1 fatalField investigationFinal reportMooney M20F · Jonestown, PAThe pilot's delay in aborting the landing, which resulted in a collision with transmission wires. Factors in the accident were the pilot's improper inflight decision to attempt a landing with a 14-knot tailwind, and his use of an unapproved pain medication.NTSB NYC00LA115Accident · No injuriesLimited investigationFinal reportMooney M-20F · Parker, PAThe pilot's failure to maintain an adequate visual lookout, due to his distraction with a flock of birds. A factor was the pilot's improper in flight decision to continue the simulated engine failure to too low of an altitude.NTSB NYC00LA108Accident · No injuriesLimited investigationFinal reportSportavia Putzer RF-5B · Gillespie, PAThe pilot's improper weather evaluation, resulting in a tailwind departure.NTSB NYC00LA095Accident · No injuriesLimited investigationFinal reportCessna 172 · New Brighton, PAThe pilot's inadequate compensation for the gusty wind conditions. A factor was the windshear encountered on final approach.NTSB NYC00FA064Accident · 2 fatalField investigationFinal reportAerostar 601P · Coatesville, PAThe pilot's failure to follow the published instrument approach procedure, and his failure to establish a climb after passing the missed approach point.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.NTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.NTSB NYC99FA193Accident · 2 fatalField investigationFinal reportPiper PA28R-180 · Seven Springs, PAThe pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.NTSB NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.NTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.NTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.NTSB NYC99LA053Accident · Serious injuriesLimited investigationFinal reportGrove AIR Command · Centre Hall, PAThe pilot's failure to maintain clearance from a power line. A factor was the sunglare.NTSB NYC98FA164Accident · 1 fatalField investigationFinal reportCessna 150L · Towanda, PAThe pilot's failure to obtain adequate climb and his premature retraction of the flaps. A contributing factor was his inadequate recovery from a bounced landing.NTSB NYC98LA079Accident · No injuriesLimited investigationFinal reportEnstrom F280F · New Alexandria, PAA bird strike.NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).NTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.NTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.NTSB IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.NTSB NYC96LA146Accident · No injuriesLimited investigationFinal reportCessna 172H · Cherry Tree, PAthe pilot's failure to assure that adequate takeoff distance was available to clear an obstacle.NTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.NTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB BFO96FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bird-In-Hand, PAthe pilot's (PIC's) improper in-flight planning/decision concerning simulated instrument flight during the traffic pattern/descent; and failure of the safety pilot (other crewmember) to provide adequate visual lookout to see-and-avoid the obstruction.NTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.NTSB NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…NTSB NYC95LA169Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-2S · Honesdale, PAthe pilots misjudgment of the altitude required to perform an aerobatic maneuver, and the subsequent collision with trees.NTSB BFO95LA057Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Quarryville, PAthe pilot's failure to attain proper altitude/clearance from obstacles during takeoff.NTSB NYC95LA119Accident · Minor injuriesLimited investigationFinal reportErwin Taylor Mono Plane · Freeport, PAthe pilot's improper decision to initiate a takeoff on an uphill runway with high grass, which resulted in a premature lift off, and an inadvertent stall/mush into trees.NTSB NYC95LA118Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Moscow, PAThe pilot's inadequate compensation for a cross wind and his failure to maintain adequate obstacle clearance. A factor is the crosswind.NTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.