NTSB investigations, 2021, PA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2021
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") = 2021 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 ERA22LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Hazleton, PAThe pilot’s failure to maintain proper airspeed on approach in tailwind conditions, which resulted in an extended touchdown, bounced landing, and runway excursion.NTSB ERA22FA076Accident · 2 fatalClass 3 · FieldFinal reportCessna T210R · Grove City, PAA catastrophic engine failure due to oil starvation after the pilot’s failure to secure the oil filler cap before flight. Contributing to the accident was the pilots’ decision to continue the flight following the oil loss event and precautionary landing.NTSB ERA22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportK Copters 47G-2 · Lancaster, PAThe flight instructor’s failure to ensure a positive transfer of aircraft control, which resulted in a loss of control and collision with terrain.NTSB ERA22LA072Accident · No injuriesClass 4 · LimitedFinal reportAeronca O58B · Jonestown, PAThe pilot’s incorrect glide path and landing flare, which resulted in a collision with obstacles on final approach and a hard landing.NTSB ERA22LA060Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Wilkes-Barre, PAThe pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.NTSB ERA22LA039Accident · No injuriesClass 3 · LimitedFinal reportBell 47D1 · Zelienople, PAA total loss of engine power for reasons that could not be determined.NTSB ERA22LA028Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Sligo, PAA total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.NTSB ERA22LA018Accident · Serious injuriesClass 3 · LimitedFinal reportZ-Hi-Max 1400 · Benton, PAThe pilot’s loss of control and encounter with an aerodynamic stall during a planned low-altitude turn toward the airport after takeoff.NTSB ERA22LA003Accident · No injuriesClass 4 · LimitedFinal reportCulp John S Culps Specl Sopwith · Pottstown, PAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA391Accident · No injuriesClass 3 · LimitedFinal reportBoeing E75 · Nicholson, PAA total loss of engine power as a result of damaged internal carburetor mixture control components.NTSB ERA21LA357Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F28 · Toughkenamon, PAThe pilot’s failure to maintain control of the helicopter during an out-of-ground effect hover in a gusty wind, due to loss of tail rotor effectiveness.NTSB ERA21LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Philadelphia, PAThe pilot’s exceedance of the wing’s critical angle of attack, which resulted in an aerodynamic stall and loss of aircraft control.NTSB ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…NTSB ERA21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Bloomsburg, PAThe pilot’s loss of directional control during the landing rollout, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Reading, PAThe captain’s improper decision to continue an unstabilized approach despite several go-around calls by the pilot monitoring, which resulted in a runway excursion and substantial damage to the pressure vessel.NTSB ERA21LA277Accident · No injuriesClass 3 · LimitedFinal reportVans RV7 · Pottstown, PAA total loss of power for reasons that could not be determined based on the available information.NTSB ERA21LA271Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Bentleyville, PAThe flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.NTSB ERA21LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Mount Pocono, PAThe pilot’s loss of aircraft control following a bounced landing.NTSB ERA21FA253Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Buckingham, PAAn exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.NTSB ERA21LA243Accident · No injuriesClass 4 · LimitedFinal reportJabiru USA Sport J250-SP · Marietta, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.NTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.NTSB ERA21LA193Accident · No injuriesClass 4 · LimitedFinal reportTextron 208B · Laceyville, PAThe pilot’s improper decision to conduct a low altitude flight and his failure to see and avoid powerlines. Contributing was the operator’s lack of safety guidance or a safety policy for low-altitude operations.NTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB ERA21LA171Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R66 · Palmyra, PAThe pilot’s improper judgment to attempt a flight while impaired by medications, which resulted in the helicopter’s abnormal ground contact, loss of control, and collision with terrain.NTSB ERA21LA396Accident · No injuriesClass 4 · LimitedFinal reportSonex Waiex · Doylestown, PAThe pilot’s failure to maintain a proper glidepath during landing. Contributing to the accident was his failure to ensure the canopy locks were properly configured prior to flight.NTSB ERA21LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · West Chester, PAThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with airport lights and a hangar.NTSB ERA21LA134Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · St. Marys, PAThe pilot’s decision to continue the approach to a snow-covered runway in low-visibility conditions with limited ability to visually differentiate the left runway edge from the snow berm that ran along that side of the runway.