NTSB investigations, PA
290 cases where NTSB found Task performance.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 20 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 22 |
| 2013 | 12 |
| 2014 | 14 |
| 2015 | 22 |
| 2016 | 18 |
| 2017 | 23 |
| 2018 | 18 |
| 2019 | 22 |
| 2020 | 14 |
| 2021 | 17 |
| 2022 | 16 |
| 2023 | 5 |
| 2024 | 15 |
| 2025 | 7 |
| 2026 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 ERA26LA334Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American Harvard III · Sanatoga, PAThe pilot’s failure to maintain control of the airplane while landing in a crosswind.NTSB ERA26LA245Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft DCO-65 · Renovo, PAThe pilot’s failure to maintain control during an off-airport landing.NTSB ERA26LA187Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Quakertown, PAThe pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.NTSB ERA26LA064Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Blue Bell, PAThe pilot's failure to maintain airplane control of the airplane during an aborted landing, resulting in a runway excursion and collision with terrain.NTSB ERA25LA379Accident · No injuriesClass 4 · LimitedFinal reportMccaa Robert T Avid/Kitfox Flyer · Oakland, PAThe pilot/owner’s failure to accurately determine the airplane’s weight and performance limitations before initiating the takeoff. Contributing to the outcome was the flight instructor’s improper engine power management and landing flare, which resulted in a…NTSB ERA25LA334Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Pottstown, PAThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the engine mounts.NTSB ERA25LA204Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Fort Washington, PAMaintenance personnel’s failure to identify and replace damaged rivet nuts at the air conditioning louver assembly, which resulted in the separation of the louver assembly from the helicopter, the louver assembly’s impact with the tail rotor, and subsequent…NTSB ERA25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Bethlehem, PAThe student pilot’s failure to maintain control of the airplane while landing in gusting crosswind conditions.NTSB ERA25LA137Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Lititz, PAThe pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…NTSB ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.NTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.NTSB ERA25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195A · Bethel, PAThe pilot’s failure to maintain directional control during landing.NTSB ERA25LA034Accident · No injuriesClass 4 · LimitedFinal reportHunt Exec 162F · North East, PAThe pilot’s failure to maintain control of the helicopter during landing following an encounter with an unanticipated wind gust, which resulted in a dynamic rollover.NTSB ERA25LA030Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 HDS · Altoona, PAThe total loss of engine power due to fuel starvation as a result of a deteriorated gascolator gasket. Contributing was the failure of the mechanic to replace the gasket during the most recent condition inspection.NTSB ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.NTSB ERA24LA316Accident · 1 fatalClass 3 · LimitedFinal reportSheaffer Leroy B Kitfox Model IV · Palmyra, PAThe pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.NTSB ERA24LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Myerstown, PAThe failure of maintenance personnel to properly secure a B-nut on the No. 5 cylinder fuel injector line, resulting in a fuel leak and engine fire.NTSB ERA24LA202Accident · No injuriesClass 4 · LimitedFinal reportStephen R Kunkle Mustang II · Philadelphia, PAA loss of directional control during the landing roll.NTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…NTSB ERA24LA192Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Zelienople, PAThe pilot’s inadequate compensation for the gusting crosswind condition during landing.NTSB ERA24LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech A23 24 · Somerset, PAThe student pilot’s failure to maintain directional control, and the flight instructor’s lack of remedial action during a landing attempt in a gusty wind, which resulted in a loss of directional control and runway excursion.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB ERA24FA103Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. GA-7 · Coatesville, PAThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…NTSB ERA24LA101Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150M · Franklin, PAThe pilots’ inadequate preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA24LA081Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Gordonville, PAThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and subsequent off-airport forced landing.NTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.NTSB CEN23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Philadelphia, PAThe pilot receiving instruction’s failure to maintain control during a go-around. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.NTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.NTSB ERA23FA252Accident · 1 fatalClass 3 · FieldFinal reportCessna 180 · Harrisburg, PAThe pilot’s inadequate preflight fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with terrain and objects.NTSB ERA23LA213Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · West Mifflin, PAThe student pilot’s improper landing flare, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA23LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Toughkenamon, PAThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in substantial damage to the airplane.NTSB ERA23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Factoryville, PAThe pilot's failure to maintain directional control while practicing a soft-field takeoff maneuver, which resulted in a runway excursion and impact with a hangar.NTSB ERA22LA357Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Leghighton, PAThe pilot’s improper recovery from a bounced landing on a slope, which resulted in dynamic rollover.NTSB ERA22LA355Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Cranberry Township, PAThe pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…NTSB ERA22LA341Accident · No injuriesClass 4 · LimitedFinal reportGarlick OH-58A+ · Bloomsburg, PAThe pilot's inadequate preflight planning and visual lookout, which resulted in impact with a powerline.NTSB ERA22LA312Accident · Serious injuriesClass 3 · LimitedFinal reportFlightstar Flightstar II SC · Russell, PAThe pilot failed to maintain adequate airspeed and exceeded the airplane’s critical angle of attack while attempting to climb over trees, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA22LA304Accident · Serious injuriesClass 4 · LimitedFinal reportArion Lightning · Indiana, PAThe airplane pilot’s inadvertent encounter with rotor wash/turbulence during short final approach, which resulted in a loss of control in flight.NTSB DCA22LA133Incident · No injuriesClass 3 · LimitedFinal reportBoeing 737-9 · Pittsburgh, PAThe flightcrew’s misidentification of the intended landing runway, which resulted in approach to and landing on the wrong runway. Contributing to the incident was the distraction caused by the dual reset of the flight management computer displays.NTSB ERA22LA244Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7AC · Monongahela, PAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall.NTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.NTSB ERA22LA210Accident · No injuriesClass 4 · LimitedFinal reportHenderson Clifford S Super Bear CSH-1 · Indiana, PAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB ERA22LA195Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32 · Carlisle, PAThe pilot’s improper landing flare, which resulted in the airplane’s empennage impacting the runway surface during landing.NTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.NTSB ERA22LA127Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210N · Honesdale, PAThe pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun and collision with terrain.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.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 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 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.