NTSB investigations, 2005, PA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2005
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") = 2005 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 NYC06CA043Accident · No injuriesData collectionFinal reportPiper PA-23-250 · State College, PAThe pilot's failure to maintain directional control during the takeoff run. A factor was the snow-covered runway.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 NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.NTSB NYC06LA019Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Doylestown, PAThe flight instructor's inadequate remedial action, which resulted in a hard landing and subsequent rollover.NTSB CHI06IA011Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · West Grove, PAThe separation of the left engine exhaust nozzle during cruise climb due to inadequately designed attachment hardware.NTSB NYC06CA008Accident · No injuriesData collectionFinal reportEnstrom F-28C · Smoketown, PAThe student pilot's failure to maintain aircraft control while performing pedal turns at a hover, resulting in a collision with terrain.NTSB NYC06MA005Accident · 1 fatalMajor investigationFinal reportAugusta 109E · Smethport, PAThe pilot's failure to maintain aircraft control. Factors in the accident were, night instrument meteorological conditions, pilot workload, and improper air traffic control procedures by the approach controller.NTSB IAD05LA147Accident · Minor injuriesLimited investigationFinal reportHanson VariEze · New Cumberland, PAThe owner/builder's inadequate fuel tank inspection during construction, which resulted in fuel contamination and subsequent fuel starvation to the engine.NTSB IAD05LA130Accident · No injuriesLimited investigationFinal reportCessna 172S · Kutztown, PAThe pilot's failure to attain a proper touchdown point as a result of the airplane's excessive airspeed. A factor was the partial loss of engine power due to a seized exhaust valve.NTSB IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB NYC05LA137Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Sandy Lake, PAA total failure of the engine driven fuel pump, and the pilot's failure to recognize a diminishing fuel supply in the fuselage (header) fuel tank, which resulted in a total loss of engine power during cruise flight and subsequent collision with trees during a…NTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.NTSB IAD05FA125Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · West Chester, PAThe pilot's improper decision to abort the landing after the airplane contacted the runway. A factor in the accident was the pilot's failure to ensure the landing gear was extended during the landing.NTSB IAD05LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Smoketown, PAA loss of engine power during the climb for undetermined reasons, resulting in a forced landing.NTSB NYC05LA134Accident · 3 fatalLimited investigationFinal reportPiper PA-28-180 · Erie, PAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion on approach, and subsequent loss of engine power.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 NYC05CA120Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Allentown, PAThe pilot's improper flare, which resulted in a hard landing.NTSB NYC05CA108Accident · No injuriesData collectionFinal reportMooney M-20J · Toughkenamon, PAThe pilot's failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with trees. A factor was the crosswind.NTSB NYC05FA105Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Fairview, PAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff and subsequent collision with a residence.NTSB NYC05CA112Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, PAThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a nose gear collapse while landing.NTSB IAD05LA083Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Bath, PAThe pilot/owner's failure to maintain adequate airspeed following a loss of engine power, which resulted in an inadvertent stall/spin. Factors in the accident were the stripped spark plug threads, and an inadequate preflight inspection by the pilot/owner.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 IAD05LA079Accident · No injuriesLimited investigationFinal reportCessna 414 · Butler, PAThe pilot's decision to conduct the flight with a known equipment deficiency. A factor was the tailwind condition.NTSB IAD05LA076Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Toughkenamon, PAThe failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.NTSB IAD05FA069Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Levittown, PAThe pilot's improper in-flight planning which resulted in a total loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and uncontrolled…NTSB IAD05IA066Incident · No injuriesIncident investigationFinal reportCessna R182 · West Mifflin, PAThe failure of the landing gear actuator downlock pin due to fatigue, which resulted in the nose landing gear collapsing on landing.NTSB NYC05LA081Accident · No injuriesLimited investigationFinal reportZeidman RV-6A · Kennett Square, PAA fuel pump malfunction, as reported by the pilot, which resulted in a loss of engine power due to fuel starvation.NTSB NYC05CA072Accident · No injuriesData collectionFinal reportCessna 172B · Collegeville, PAThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident was the downdraft wind conditions.NTSB NYC05LA070Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Warren, PAThe pilot's failure to follow the balked landing checklist while attempting to abort a landing. Factors in the accident were his failure to maintain directional control during the landing, and a gust of wind.NTSB NYC05LA067Accident · No injuriesLimited investigationFinal reportCessna 182S · West Mifflin, PAThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the gusty wind conditions.NTSB IAD05FA047Accident · 6 fatalField investigationFinal reportPilatus PC-12/45 · Bellefonte, PAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an instrument final approach to land, which resulted in an inadvertent stall/spin. Factors associated with the accident are the inadvertent stall/spin, the pilot's failure to follow…NTSB NYC05FA053Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Coatesville, PAThe pilot's inadequate remedial action during an engine failure, which resulted in a loss of airplane control. A factor was the pilot's improper fuel management, which resulted in fuel starvation to one engine, and its subsequent loss of engine power.NTSB NYC05CA047Accident · No injuriesData collectionFinal reportBell 206B · Lancaster, PAThe pilot's loss of lateral control while attempting to transition to a hover from the ground. A factor was the bright sunlight conditions.