NTSB investigations, PA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, newest first
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' 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' 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 NYC98LA114Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Strasburg, PAA fire of undetermined origin.NTSB NYC98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAfailure of the pilot to maintain directional control of the airplane during the takeoff roll; and/or his failure to abort the takeoff, while there was sufficient space available to do so without hitting trees.NTSB NYC98LA097Accident · Serious injuriesLimited investigationFinal reportLet L-23 Super Blanik · Pipersville, PAthe pilot's misjudgment of distance and altitude, while on an approach to an off-airport landing area, which resulted in a lack of airspeed and/or altitude to reach the intended landing area (undershoot), a stall or mush into tree(s), and collision with a…NTSB IAD98FA044Accident · 2 fatalField investigationFinal reportPiper PA-20 · Beaver Falls, PAThe pilot's failure to maintain aircraft control, and his failure to attain adequate airspeed, which resulted in a stall. Contributing was the pilot's lack of familiarity with the airplane, and his misjudgment of wind information which resulted in a tailwind…NTSB NYC98LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Warren, PAThe pilot's failure to obtain the proper touchdown point.NTSB NYC98LA079Accident · No injuriesLimited investigationFinal reportEnstrom F280F · New Alexandria, PAA bird strike.NTSB IAD98FA037Accident · 1 fatalField investigationFinal reportCessna 152 · West Mifflin, PAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A related factor was the pilot's impairment due to the use of drugs.NTSB NYC98LA075Accident · Serious injuriesLimited investigationFinal reportFokker F-100 · Philadelphia, PAThe driver's failure to maintain clearance from the parked airplane. Related factors were night conditions and the driver's diverted attention.NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).NTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.NTSB NYC98FA066Accident · 1 fatalField investigationFinal reportCessna 172P · York, PAThe pilot's failure to maintain airspeed during final approach which resulted in an inadvertent stall/spin.NTSB IAD98LA022Accident · No injuriesLimited investigationFinal reportCessna 182M · Mount Pleasant, PAThe pilot's failure to initiate a go-around, and his failure to maintain adequate airspeed.NTSB NYC98FA060Accident · Serious injuriesField investigationFinal reportCessna 500 · West Mifflin, PAThe failure of the pilot to make a go-around when he failed to achieve a normal touchdown due to excessive speed, and which resulted in an overrun. Factors were the reduced visibility due to fog, and the wet runway.NTSB IAD98LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Philadelphia, PAfailure of the tug driver to see-and-avoid the taxiing airplane.NTSB IAD98LA020Accident · No injuriesLimited investigationFinal reportCessna 172M · Blue Bell, PAThe pilot's failure to attain the proper touchdown point, and his failure to make a go-around, while there was sufficient runway remaining.NTSB NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.NTSB NYC98LA052Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Lancaster, PAPassenger control interference which resulted in pilot's failure to maintain control of the airplane during landing.NTSB NYC98FA048Accident · 2 fatalField investigationFinal reportCessna 152 · Spring City, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent in-flight collision with terrain.NTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.NTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.NTSB NYC98LA043Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · Belle Vernon, PAThe pilot's improper out-of-ground hover procedure, which resulted in a loss of tailrotor effectiveness.NTSB IAD98LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAThe pilot's failure to attain the proper touchdown point. Related factors were tailwind, and lack of total experience.NTSB NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.NTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.NTSB IAD98LA009Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Smoketown, PAThe pilot in command's (CFI) improper management of the fuel supply, which resulted in fuel exhaustion of the selected tank and the subsequent loss of engine power.NTSB NYC98LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Philadelphia, PAthe pilot's failure to check the elevator trim prior to takeoff, and his failure to retard the power in a timely manner after touchdown.NTSB NYC98FA018Accident · No injuriesField investigationFinal reportEnstrom F-28C · Fairview, PAinadequate maintenance, which led to detonation and a melted piston, and subsequent power loss.NTSB NYC98LA013Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Pittsburgh, PAthe tug driver's failure to obey a stop sign and his failure to yield right-of-way to the airplane.NTSB NYC98LA011Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26A · Fairfield, PAThe improper installation of the elevator cables and elevator control bell-crank by the pilot, and an inadequate annual inspection by the mechanic. Also causal was the pilot's inadequate preflight of the flight controls prior to takeoff.NTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.NTSB NYC97LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kutztown, PAthe student pilot's failure to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the student's pilot's selection of the wrong runway, the resultant tailwind, and the encounter…NTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.NTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.NTSB NYC97LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Chester, PAthe pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.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 NYC97LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Slatington, PAThe pilot's failure to maintain control of the helicopter.NTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.NTSB NYC97LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blairsville, PAthe pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB NYC97LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brickerville, PAFuel starvation as a result of the pilot performing a takeoff with the fuel selector in the 'OFF' position.NTSB NYC97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Perkasie, PAthe pilot's inadequate preflight, by failing to verify the fuel supply, which led to subsequent fuel exhaustion and loss of engine power. A related factor was: the inaccurate fuel quantity gauge.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB NYC97LA161Accident · No injuriesLimited investigationFinal reportCessna A150L · Waynesburg, PAthe pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.NTSB NYC97LA154Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350B · Philadelphia, PAfailure of the pilot to follow the checklist and verify the throttle was in the ON position before lift-off, which resulted in low rotor RPM and loss of control, while attempting to hover/taxi.NTSB NYC97LA145Accident · Minor injuriesLimited investigationFinal reportSlingsby T65A · Bethel, PAThe pilot's improper flare. A factor in the accident was the pilot's fatigue.NTSB NYC97LA140Accident · No injuriesLimited investigationFinal reportCessna 182A · Hayfield Twnshp, PAThe pilot's improper decision to attempt a takeoff from unsuitable terrain and failure to maintain airspeed. A factor in this accident was the gusty wind conditions.NTSB NYC97LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Tioga, PAThe pilot's improper inflight decision to land downwind with an inoperative airspeed indicator, and his improper landing flare.NTSB NYC97LA128Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bellwood, PAthe total loss of engine power due to failed connecting rods.NTSB NYC97LA114Accident · No injuriesLimited investigationFinal reportLuscombe 8F · New Town, PAThe pilot's improper fuel management, which resulted in an intermittent fuel supply, and a loss of engine power.NTSB IAD97LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Punxsutawney, PAPilot in command became disoriented and continued flight until fuel exhaustion. A factor to this accident is the pilot's inadequate in-flight planning/decision by over flying several airports during his disorientation.NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.