NTSB investigations, PA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 BFO95LA056Accident · No injuriesLimited investigationFinal reportKnoll-Bensen B-80 · Germansville, PAthe private pilot's misjudged flare, which resulted in a hard landing.NTSB NYC95LA120Accident · No injuriesLimited investigationFinal reportCessna 177B · Allentown, PAthe pilot misjudged the flare, resulting in a hard, bounced landing and impact with the runway. A factor in this accident was an improper recovery from a bounced landing.NTSB NYC95LA121Accident · No injuriesLimited investigationFinal reportCessna 182E · Frederick, PAThe pilot's inadequate inflight planning by failing to verify the wind direction for landing. Also causal is the pilot's failure to obtain the proper touch down point and to do a go-around.NTSB NYC95LA119Accident · Minor injuriesLimited investigationFinal reportErwin Taylor Mono Plane · Freeport, PAthe pilot's improper decision to initiate a takeoff on an uphill runway with high grass, which resulted in a premature lift off, and an inadvertent stall/mush into trees.NTSB NYC95LA118Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Moscow, PAThe pilot's inadequate compensation for a cross wind and his failure to maintain adequate obstacle clearance. A factor is the crosswind.NTSB NYC95LA108Accident · No injuriesLimited investigationFinal reportCessna 310J · Ararat, PAThe complete loss of electrical power for undetermined reasons, and the pilot's improper decision to make an off-airport landing.NTSB BFO95LA053Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dubois, PAThe failure of valve springs in the number two engine cylinder which resulted in a total loss of engine power during initial climb. The unsuitable terrain encountered during the subsequent forced landing was a factor.NTSB NYC95LA096Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Clarion, PAA partial failure of the brake system.NTSB BFO95LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Jeannette, PAthe failure of the magneto pinion gear failure, which resulted in a total loss of engine power during initial climbout over usuitable terrain.NTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.NTSB BFO95LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Erie, PAThe loss of engine power for undetermined reasons.NTSB NYC95LA077Accident · No injuriesLimited investigationFinal reportCessna 150J · Slatington, PAThe pilot's improper use of carburetor heat which resulted in carburetor icing and a subsequent loss of engine power. A factor is carburetor icing conditions.NTSB NYC95FA050Accident · 3 fatalField investigationFinal reportAgusta A109C · Jackson Twp, PAThe pilot's improper in-flight planning/decision and failure to maintain control of the airplane after becoming spatially disoriented. Factors related to the accident were: darkness and the adverse weather conditions.NTSB BFO95LA027Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Clarion, PAThe failure of the right wing de-ice boot during operation in conditions of ice accumulation, which resulted in a loss of aircraft controllability during the approach/landing. The icing condition was a factor.NTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…NTSB BFO95LA019Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Montrose, PATotal loss of engine power for undetermined reasons.NTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.NTSB BFO95LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Blooming Grove, PAThe malfunction of the carburetor heat control which resulted in loss of engine power. The carburetor icing weather condition was a factor.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB NYC95LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Freeport, PAThe pilot's attempted takeoff in an overweight airplane, his failure to follow approved short field takeoff procedures, not attaining a positive rate of climb, and attempting an operation beyond his experience level.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB NYC95LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pillow, PAThe pilot did not attain the proper touchdown point on a grass runway covered with frost, which resulted in inadequate braking, and runway overrun.NTSB NYC95LA015Accident · No injuriesLimited investigationFinal reportCessna 172B · Honesdale, PAthe fuel selector was in the improper position, which resulted in a total loss of engine power, due to fuel starvation, a forced landing, and subsequent impact with a stone wall.NTSB NYC95LA013Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Worthington, PAThe failure of the aileron control cable which resulted in the inflight loss of control and collision with trees.NTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.NTSB BFO95LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ebensburg, PAThe loss of partial engine power due to the failure of the right magneto's nylon gear on the rotating magnet and the low compression in the number three cylinder.NTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.NTSB NYC94LA175Accident · No injuriesLimited investigationFinal reportCessna T210R · Tunkhannock, PAUse of improper procedures during a short field landing which resulted in an overrun and noseover.NTSB DCA94MA076Accident · 132 fatalClass 1 · MajorFinal reportBoeing B-737-300 · Aliquippa, PAA loss of control of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB NYC94FA166Accident · 2 fatalField investigationFinal reportCessna 310R · Blain, PAThe pilot's impairment of judgment and performance due to drugs, failure to maintain control of the airplane, and exceeding the design stress limits of the airplane, which resulted in an in-flight breakup of the airplane. A factor related to the accident was:…NTSB BFO94LA155Accident · No injuriesLimited investigationFinal reportHughes 369D · Butler, PAThe malfunction of the emergency fuel vent and the exhaustion of the fuel supply which resulted in the loss of engine power.NTSB BFO94LA147Accident · 1 fatalLimited investigationFinal reportRans S-14 Airaile · Phoenixville, PAthe pilot's failure to perform a preflight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB NYC94FA160Accident · 4 fatalField investigationFinal reportCessna 320C · Waynesboro, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall/spin and his lack of qualification to conduct flight in type aircraft. A factor is the loss of engine power for undetermined reasons.NTSB BFO94LA133Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Freeport, PAThe student pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision.NTSB NYC94LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Pottsville, PAThe pilot's failure to attain adequate airpseed, which resulted in a stall/mush and collision with a tree.NTSB NYC94LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wellsboro, PAThe pilot's impairment of judgment and performance due to alcohol, which led to his misjudgment of altitude and distance to the runway and collision with terrain, while on final approach to land. A factor related to the accident was: darkness.NTSB BFO94LA130Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Morris, PAThe pilot misjudged altitude and distance, which resulted in an undershoot of the runway.NTSB NYC94LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Towanda, PAThe pilot's improper recovery from a bounced landing.NTSB NYC94FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Trout Run, PAthe delayed decision of the pilot to deviate from known weather which resulted in an inflight loss of control and impact with terrain.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.NTSB BFO94FA120Accident · 2 fatalField investigationFinal reportBeech 76 · Elizabeth, PA1) The failure of the pilot-in-command (CFI) to provide adequate supervision of the dual student during a simulated single-engine approach, and 2) his failure to perform remedial action. This led to a loss of aircraft control in close proximity to the ground.…NTSB BFO94LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Quarryville, PAThe pilot's failure to touchdown at the proper point and his delayed remedial action. A factor related to the accident was a tailwind.NTSB BFO94LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Seven Springs, PAThe pilot's failure to attain adequate airspeed and his premature liftoff which resulted in a stall mush and collision with trees.NTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.NTSB BFO94LA090Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA318C · Rassellas, PAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the lost of engine power. Factors in the accident were the pilot operating the helicopter with known deficiencies in equipment and no suitable terrain available for landing.NTSB BFO94LA083Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-C · Fairfield, PAThe pilot-in-command's failure to maintain control of the airplane during the maneuver.NTSB NYC94LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Spring City, PAThe pilot's improper inflight planning and inaccurate fuel consumption calculations, resulting in fuel supply exhaustion, loss of engine power, and the subsequent collision with trees during a forced landing.NTSB BFO94LA072Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Clarion, PAThe pilot's failure to maintain directional control which resulted in an overrun of the runway and collision with a berm.NTSB BFO94LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Bedford, PAThe pilot's failure to maintain the proper descent rate which resulted in an undershoot of the runway.