NTSB investigations, 2002, PA
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 per year
| 1963 | 2 |
|---|---|
| 1964 | 157 |
| 1965 | 149 |
| 1966 | 172 |
| 1967 | 192 |
| 1968 | 154 |
| 1969 | 132 |
| 1970 | 136 |
| 1971 | 153 |
| 1972 | 104 |
| 1973 | 118 |
| 1974 | 143 |
| 1975 | 131 |
| 1976 | 123 |
| 1977 | 116 |
| 1978 | 124 |
| 1979 | 109 |
| 1980 | 89 |
| 1981 | 92 |
| 1982 | 96 |
| 1983 | 81 |
| 1984 | 84 |
| 1985 | 75 |
| 1986 | 64 |
| 1987 | 64 |
| 1988 | 65 |
| 1989 | 45 |
| 1990 | 65 |
| 1991 | 47 |
| 1992 | 47 |
| 1993 | 48 |
| 1994 | 41 |
| 1995 | 55 |
| 1996 | 38 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 41 |
| 2000 | 47 |
| 2001 | 34 |
| 2002 | 35 |
| 2003 | 29 |
| 2004 | 37 |
| 2005 | 33 |
| 2006 | 36 |
| 2007 | 35 |
| 2008 | 33 |
| 2009 | 30 |
| 2010 | 19 |
| 2011 | 27 |
| 2012 | 39 |
| 2013 | 27 |
| 2014 | 24 |
| 2015 | 35 |
| 2016 | 32 |
| 2017 | 33 |
| 2018 | 28 |
| 2019 | 30 |
| 2020 | 19 |
| 2021 | 28 |
| 2022 | 35 |
| 2023 | 11 |
| 2024 | 19 |
| 2025 | 17 |
| 2026 | 12 |
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 year(c.\"eventDate\") = 2002
AND 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 year(c."eventDate") = 2002 AND 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 NYC03LA034Accident · No injuriesLimited investigationFinal reportSocata TB 9 · Mount Union, PAThe pilot's delay in aborting the takeoff. A factor was the soft runway.NTSB IAD03LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369A · Marietta, PAThe flight instructor 's misjudgment of the helicopter's height above the river.NTSB NYC03IA011Incident · No injuriesIncident investigationFinal reportPiper PA-28-236 · Altoona, PAA failure of the fuel selector for an undetermined reason.NTSB NYC03LA006Accident · No injuriesLimited investigationFinal reportBeech 58 · Allentown, PAThe pilot's inadvertent retraction of the landing gear on the ground.NTSB IAD03LA002Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Somerset, PAThe mechanic's failure to discover several mechanical deficiencies during a pre-buy inspection, which either independently or collectively resulted in a subsequent engine failure. A factor was the power lines in the forced landing area.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 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 NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.NTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.NTSB NYC02LA158Accident · No injuriesLimited investigationFinal reportCessna R182 · Reading, PASeparation of a hydraulic line from its landing gear motor fitting.NTSB IAD02LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Mount Pocono, PAThe pilot's improper flare, which resulted in a hard landing.NTSB NYC02LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Coatesville, PAThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.NTSB IAD02LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Williamsport, PAThe student pilot's failure to maintain adequate clearance from a building while taxiing.NTSB NYC02LA201Accident · Serious injuriesLimited investigationFinal reportUnknown T-Bird II · Berlin, PAFailure of the elevator attachment bolts.NTSB NYC02FA152Accident · 4 fatalField investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's improper decision to operate an airplane with known mechanical deficiencies, his improper decision to return to the airport with inadequate altitude remaining, and his failure to maintain airspeed. A factor related to the accident was the…NTSB IAD02LA079Accident · No injuriesLimited investigationFinal reportBeech A-36 · West Mifflin, PAThe failure of the alternator. A factor was the pilot's inability to manually extend the landing gear.NTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.NTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.NTSB IAD02LA071Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Unionville, PAThe pilot's evasive maneuver to avoid a collision with a departing airplane, which resulted in a landing short of the runway. A factor was the pilot's decision to land on the runway opposite the one in use.NTSB IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.NTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.NTSB IAD02LA063Accident · No injuriesLimited investigationFinal reportMurawski Pulsar · Bentleyville, PAFailure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.NTSB IAD02LA062Accident · Minor injuriesLimited investigationFinal reportCastle Glasair II-SRG · Mill Hall, PAThe failure of the crankshaft due to a lack of lubrication.NTSB NYC02LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsburgh, PAThe student pilot's failure to maintain adequate clearance while maneuvering to avoid obstructions.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 NYC02LA111Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Toughkenamon, PAThe pilot's failure to maintain directional control while landing, a factor was the gusting wind conditions.NTSB NYC02LA108Accident · No injuriesLimited investigationFinal reportCessna 182B · Littlestown, PAThe pilot's improper flair, which resulted in a hard landing. A factor in this accident was the crosswind condition.NTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.NTSB IAD02LA048Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fairfield, PAThe pilot's failure to attain proper runway alignment. A factor in the accident was the pilot's delay in retracting the spoilers.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 NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB NYC02LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Coatesville, PAThe student pilot's loss of aircraft control which resulted in a hard landing, and the CFI's delayed remedial action. Factors related to the accident were the fatigue cracks which initiated at the attachment hole on the landing gear strut, and the crosswind…NTSB IAD02LA029Accident · No injuriesLimited investigationFinal reportCessna 172P · Doylestown, PApilot's failure to maintain clearance between the airplane and a parked fuel truck while taxing.