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 NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.NTSB NYC99LA189Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Greencastle, PAThe pilot's misjudgement of speed and distance during the approach and his failure to perform a go around.NTSB NYC99LA170Accident · No injuriesLimited investigationFinal reportPilatus B-4 · Erwinna, PAThe pilot-in-command's failure to maintain aircraft control.NTSB NYC99LA165Accident · 2 fatalLimited investigationFinal reportLakeland Ultralites Kolb Mark III · Clark, PAThe pilot's improper decision to perform an aerobatic maneuver with inadequate altitude for recovery/clearance.NTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.NTSB NYC99LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Tinicum, PAThe pilot's failure to maintain a proper altitude above the water.NTSB NYC99LA143Accident · No injuriesLimited investigationFinal reportFlaherty RV-6 · Jeannette, PAThe pilot-in-command misjudged altitude during a simulated forced landing.NTSB NYC99LA142Accident · No injuriesLimited investigationFinal reportMorrow RV-6 · Bradford, PAThe pilot's improper flare which resulted in a hard landing, and subsequent collapse of the nose gear.NTSB IAD99LA046Accident · 1 fatalLimited investigationFinal reportPoskus Revelation · Latrobe, PAWas the pilot's failure to maintain directional control.NTSB NYC99LA115Accident · Serious injuriesLimited investigationFinal reportHammond Twinstar Gyroplane · Bloomsburg, PAThe pilot's failure to maintain sufficient takeoff rpm. Factors included crosswind gusts, and the FAA's lack of category and class rating requirements for pilots flying non-type-certificated experimental aircraft.NTSB NYC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Chambersburg, PAThe loss of engine power for undetermined reasons.NTSB IAD99FA041Accident · 3 fatalField investigationFinal reportCessna 305A · Hilltown, PAThe inadequate lookout of both pilots, and the pilot of the other aircraft.NTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.NTSB IAD99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zelienople, PAThe pilot's inadequate preflight planning to practice crosswind landings in wind that exceeded the airplane's demonstrated capability and his failure to maintain directional control. A factor in the accident was the high wind.NTSB NYC99LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln Univ., PAThe student pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush. Also causal was the certified flight instructor's inadequate supervision.NTSB NYC99LA081Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pottstown, PAThe failure of maintenance personnel to properly inspect and torque the crankcase bolts.NTSB NYC99IA079Incident · No injuriesIncident investigationFinal reportCessna 550 · State College, PAImproper assembly of the left main landing gear (LMLG) actuator by the airplane manufacturer, which resulted in an incorrect 'locked' indication on the LMLG switch, and the subsequent collapse of the LMLG during taxi.NTSB IAD99FA034Accident · 2 fatalField investigationFinal reportBeech BE-76 · Dravosburg, PAThe pilot's failure to accurately calculate fuel required for the flight, and his decision not to divert for fuel prior to his intended destination. A factor in the accident was the pilot's over confidence in his ability to operate the airplane with minimal…NTSB NYC99LA072Accident · Minor injuriesLimited investigationFinal reportMiner Rotorway Exec 162F · Mechanicsburg, PAThe pilot's inadvertent induced dynamic rollover. A factor in the accident was the pilot's lack of helicopter experience.NTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.NTSB IAD99LA030Accident · Minor injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Kutztown, PAwas the in-flight encounter with thermal sink over unsuitable terrain for landing.NTSB NYC99LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Herminie, PAThe partial loss of engine power for undetermined reasons.NTSB NYC99LA053Accident · Serious injuriesLimited investigationFinal reportGrove AIR Command · Centre Hall, PAThe pilot's failure to maintain clearance from a power line. A factor was the sunglare.NTSB NYC99LA050Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9 · Plainfield, PAThe wake turbulence from the proceeding Boeing 747.NTSB NYC99LA048Accident · No injuriesLimited investigationFinal reportCessna 310R · Allentown, PAThe pilot's improper decision to reduce too much power during the landing flare.NTSB NYC99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairfield, PAThe pilot's failure to properly use carburetor heat which resulted in carburetor ice and loss of engine power. Contributing factor were trees.NTSB NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.NTSB IAD99LA012Accident · No injuriesLimited investigationFinal reportPitcairn RAF 2000 · Doylestown, PAThe pilot's inadequate compensation for wind conditions and his inadequate recovery from a bounced landing. Contributing to the accident were the pilot's fatigue and the crosswind conditions.NTSB NYC99LA020Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · West Chester, PAThe pilot's failure to obtain/maintain the proper airspeed during the landing, and failure to perform a go-around. A factor in the accident was the crosswind conditions.NTSB NYC99LA008Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Hilltown, PAThe pilot's misjudgment of altitude/distance which resulted in an in-flight collision which trees.NTSB NYC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Toughkenamon, PAThe pilot's inadequate preflight inspections which failed to detect an open fuel strainer valve, which resulted in a loss of engine power.NTSB NYC98FA180Accident · 5 fatalField investigationFinal reportBeech A23-24 · Shunk, PAThe pilot-in-command's attempted flight into known adverse weather conditions, his failure to maintain control of the aircraft, and his exceeding the airframe design limits resulting in separation of the outboard left wing. Contributing factors were clouds,…NTSB NYC98FA179Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar TS-600 · Marietta, PAThe failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…NTSB NYC98LA177Accident · No injuriesLimited investigationFinal reportDouglas DC-9-30 · Philadelphia, PAthe failure of the fuel truck driver to follow airport operating procedures, and yield the right-of-way to the airplane. Factors were the stopped airplane, which obscured the fuel truck from the approaching airplane and the approaching airplane from the fuel…NTSB NYC98LA175Accident · Minor injuriesLimited investigationFinal reportStubler Taylor Titch · Lock Haven, PAThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's decision to use his left hand to actuate the flap handle located on the right side of the cockpit, while on final and over the runway.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB IAD98FA092Accident · 1 fatalField investigationFinal reportAustin Revolution Mini 500 · Northampton, PAthe improper maintenance adjustment and the failure to properly torque the pitch-change link barrel by the owner/builder which resulted in main rotor to tailboom contact and main rotor separation.NTSB NYC98FA164Accident · 1 fatalField investigationFinal reportCessna 150L · Towanda, PAThe pilot's failure to obtain adequate climb and his premature retraction of the flaps. A contributing factor was his inadequate recovery from a bounced landing.NTSB IAD98LA091Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Windsor Twnship, PAThe pilot's mismanagement of the fuel which led to fuel exhaustion and subsequent loss of engine power.NTSB NYC98IA165Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Mcconnellsburg, PAA high altitude encounter with wake vortices.NTSB NYC98LA154Accident · No injuriesLimited investigationFinal reportJohnson Revolution MINI-500 · Shermans Dale, PAThe builder/pilot's carburetor modification that did not allow for rapid fuel demand, which resulted in a loss of engine power of final approach.NTSB NYC98LA153Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Jeanette, PAThe pilot's delay in applying the brakes during the landing rollout.NTSB NYC98LA143Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Bedford, PAThe pilot's inadequate preflight inspection in which he failed to secure the oil filler cap, and his misjudgment of distance and altitude from the runway.NTSB IAD98LA074Accident · No injuriesLimited investigationFinal reportAmerican Blimp ABC-A-60 · Lock Haven, PAthe pilot's encounter with unforecasted downdrafts.NTSB NYC98LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Pottstown, PAThe student pilot's excessive application of the right brake, resulting in a ground loop.NTSB NYC98LA131Accident · No injuriesLimited investigationFinal reportNarrin-Whittman W-8 Tailwind · Germanstown, PAthe pilot's delay in initiating an abort after the wind shifted from a headwind to a tailwind during the takeoff roll. A factor was the sudden windshift.NTSB NYC98FA127Accident · 3 fatalField investigationFinal reportPiper 601P · Martinsburg, PAThe pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.NTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…NTSB NYC98LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Blakeslee, PAThe pilot's inadequate preflight resulting in fuel exhaustion. A factor was the pilot's failure to refuel the aircraft prior to departing.NTSB NYC98LA115Accident · No injuriesLimited investigationFinal reportCessna 177B · Brogue, PAfailure of the pilot to maintaining proper runway alignment during an aborted landing (go-around). Related factors were: the pilot's improper recovery from a bounced landing, inadvertent porpoise, and the small trees encroaching into the runaway environment.