NTSB investigations, PA
25 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1990 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2000 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 2 |
| 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\" = 430)
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" = 430) 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 NYC07CA070Accident · Minor injuriesData collectionFinal reportSchweizer 269-C · Columbus, PAThe pilot's improper decision to continue the landing attempt in whiteout conditions, which resulted in his disorientation, and the helicopter's subsequent dynamic rollover. Factors included the whiteout conditions, and the pilot's inadequate weather…NTSB NYC07IA023Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland EC135T1 · Harrisburg, PAThe pilot's inadequate preflight preparation, which resulted in the cyclic stick lock not being disengaged prior to lift-off, and his subsequent inability to control the helicopter. Contributing to the accident was the operator's inadequate procedures, the…NTSB NYC06LA197Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bellefonte, PAImproper maintenance of the throttle linkage, which resulted in a lack of engine power during takeoff. Factors were the pilot's premature retraction of the flaps, an improper elevator trim setting, a high gross takeoff weight, and a high density altitude;…NTSB NYC06LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-800 · State College, PAThe pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…NTSB IAD05CA100Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Altoona, PAThe pilot's improper engine starting procedure, resulting in an uncontrolled taxi, and collision with a hangar.NTSB NYC05CA104Accident · No injuriesData collectionFinal reportPiper J3C-65 · Fredericksburg, PAThe pilot's improper engine starting procedures, which resulted in the airplane taxiing unoccupied and impacting a light pole.NTSB NYC04IA116Incident · No injuriesIncident investigationFinal reportDornier DO-328-100 · Allentown, PAThe opening of the main cabin door after takeoff, for undetermined reasons.NTSB NYC04LA063Accident · No injuriesLimited investigationFinal reportSaab-Scania 340A · Pittsburgh, PAThe failure of the baggage cart E-hitch pin, which resulted in the baggage cart separating from its tug, and subsequently impacting a parked airplane.NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB IAD00LA042Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Gettysburg, PAThe pilot's improper pre-flight which resulted in the fuel strainer valve being left in the open position.NTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.NTSB NYC97LA176Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX-10 · Akron, PAfailure of a passenger to hang onto the ropes, as directed; which allowed another passenger to be struck as the basket tipped over, broking her arm. A related factor was the wind, which was strong enough to tip the basket, while the envelope was deflating.NTSB NYC97LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Pottstown, PAwas the flight instructor's diverted attention while standing on the wing behind a turning propeller, which resulted in his departure from the wing, forward into the turning propeller.NTSB IAD97LA004Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Krosno KR-03A · Kutztown, PAthe glider pilot's improper decision to takeoff despite the presence of a glider winch cable lying on the runway area, which led to the glider snagging the winch cable during the takeoff roll and a subsequent forced landing. A related factor was: the airport…NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB NYC90IA050Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Philadelphia, PAThe flight crew of EAL121 taking off on a taxiway. Contributing was failure of the flight crew of eal 121 to maintain an adequate visual lookout during taxi and takeoff.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…NTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.NTSB NYC87LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Erie, PAReason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a…NTSB NYC87LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Philadelphia, PADuring hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the…NTSB NYC86IA215Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Pittsburgh, PACo-plt was flying acft on short final approach/landing. Capt observed co-plt having difficulty maintaining glideslope and airspeeds. Co-plt stopped flying the acft. Capt took control at 50' AGL and landed safely. Medical help requested and received from cabin…NTSB NYC86LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Hazleton, PAPiper aircraft ran off the runway during landing at Hazleton Pennsylvania. According to the pilot the first approach was missed due to bad visibility. The flight returned to the initial aprroach fix for a second attempt. The pilot broke out of the clouds at…NTSB NYC85LA122Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Toughkenamon, PAThe glider was being towed for takeoff & had just become airborne when the canopy came open. The plt tried to latch the canopy, but was unable, so he released the glider from the tow plane. While the plt continued to try to latch the canopy, the glider went…NTSB DCA85IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Erie, PAThe orig destn was youngstown, OH, but its wx was blo mins, so the flt to transport a football team was planned to Erie which was slightly above mins. The coach & business manager were not happy about this, but plans were made to bus the team on to…NTSB NYC84LA015Accident · 1 fatalLimited investigationFinal reportShort Brothers SD3-30 · Middletown, PAAfter takeoff on a flt to Washington, DC, the aircraft was climbing thru about 3500 ft when a person (riding as a passenger) moved to the right rear door, opened it & departed the acft. Prior to the flt, an associate, who was an acft refueler, saw the person…