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 NYC92LA043Accident · No injuriesLimited investigationFinal reportCessna 177B · Dalmatia, PAThe pilot's failure to maintain proper altitude and object clearance which resulted in a collision with power lines.NTSB NYC92LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-36 · Erwinna, PAThe pilot rotated the glider prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were the pilot's total lack of experience in gliders, no experience in this type of glider, and improper trim…NTSB NYC92DGM01Accident · 1 fatalFinal reportWillkins-Wayne VARI-VIGGEN · Erie, PAThe pilot lost control of the airplane at too low an altitude to recover. Factors related to the accident were the pilot's low time and experience in this type of airplane.NTSB NYC92LA024Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Jim Thorpe, PAThe pilot's improper use of carburetor heat, resulting in carburetor ice and a loss of engine power and subsequent forced landing in trees. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB NYC92DHA01Accident · 1 fatalFinal reportJesse Knight Long EZ · Milford, PAThe pilot's inadequate visual lookout.NTSB NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…NTSB NYC91LA251Accident · Minor injuriesLimited investigationFinal reportCessna C-152 II · Blue Bell, PAThe pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…NTSB NYC91LA244Accident · Serious injuriesLimited investigationFinal reportCessna 170B · E. Stroudsbury, PAImproper takeoff planning by the pilot which resulted in the airplane striking trees during initial climb. A factor related to the accident was the failure of the pilot to make his departure turn in a timely manner.NTSB NYC91LA241Accident · No injuriesLimited investigationFinal reportRobinson R22B · Wexford, PAThe pilot's improper procedures during a practice autorotation, and selection of unsuitable terrain. Contributing to the accident was a loss of engine power for undetermined reasons, at a low altitude.NTSB NYC91LA240Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Slippery Rock, PAThe on ground collision with a farm vehicle during landing roll out.NTSB NYC91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Johnstown, PAA collision with a deer while landing. A factor related to the accident was night conditions which restricted the pilot's view of the deer until it was within the illumination of the landing light.NTSB NYC91LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Easton, PAAn overrun after the pilot-in-command landed long on a short, wet runway. A factor related to the accident was the failure of the pilot to make a go-around.NTSB NYC91LA219Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Meadville, PAEngine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.NTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.NTSB NYC91LA213Accident · No injuriesLimited investigationFinal reportCessna 150C · Kemblesville, PAThe instructor pilots' inadequate supervision, the student pilots' overshoot of the simulated landing area, and the power loss for undetermined reasons.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.NTSB NYC91FA097Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Muncie Valley, PAThe pilot's attempt to maintain visual flight into known instrument meteorological conditions, resulting in a collision with trees. Factors related to the accident were: the pilot's failure to obtain a pre-flight weather briefing and his failure to maintain…NTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB NYC91FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Fogelsville, PAThe improper decision by the non-instrument rated pilot to attempt VFR flight in instrument meteorological conditions, which resulted in a loss of airplane control. Factors related to the accident were: the pilot's overconfidence in his ability, his lack of…NTSB NYC91LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Thomasville, PAThe pilot's improper use of flight controls during the landing roll, which resulted in a loss of airplane control. Factors related to the accident were: the loose nose wheel shimmy dampener and the pilot's lack of flight experience in this make and model of…NTSB NYC91LA176Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Stebensville, PAThe pilot's failure to refuel the airplane, his improper fuel consumption calculations, and his failure to flare the airplane during the forced landing.NTSB NYC91FA171Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Wernersville, PAThe pilot's loss of airplane control due to spatial disorientation/vertigo. Factors related to the accident were the pilot's use of an antihistamine and self induced pressure to complete the flight.NTSB NYC91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAImproper use of the flight controls by the pilot which resulted in an inadvertent stall on takeoff with insufficient altitude for recovery. Factors related to the accident was the failure of the pilot to properly set the elevator trim prior to takeoff and the…NTSB NYC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Doylestown, PAThe flight instructor allowed the student to continue a simulated engine failure to a hard landing, resulting in a bounced landing and loss of directional control and a collision with the VASI.NTSB BFO91LA055Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Philadelphia, PAFailure of the pilot to ensure cabin crew members were prepared for an encounter with turbulence.NTSB NYC91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dushore, PAThe pilot landed with excessive airspeed, which resulted in ineffective braking and a loss of control.NTSB NYC91LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tuckhannock, PAThe failure of the pilot to achieve a proper touchdown point. A factor related to the accident was the pilot's failure to make a go-around.NTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.NTSB NYC91DGT05Accident · Minor injuriesFinal reportAlexander Schleicher ASW-24 · Beaver Springs, PAThe pilot's loss of control in flight as the result of a strong downdraft and wind shift.NTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.NTSB NYC91DGT04Accident · No injuriesFinal reportGeorge E Heide, JR. Moni Motorglider · Annville, PAThe pilot's intentional landing on unsuitable terrain due to a loss of altitude precipitated by a downdraft.NTSB NYC91DGT03Accident · Serious injuriesFinal reportBell 47-G3B1 · Hughesville, PAThe loss of engine power for undetermined reasons and the pilot's selection of the forced landing area.NTSB NYC91LA131Accident · No injuriesLimited investigationFinal reportCessna 185C · New Hanover, PAThe loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.NTSB NYC91LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Jessup, PAA power loss due to oil starvation for unknown reasons, over unsuitable terrain.NTSB NYC91LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Meadville, PAThe improper use of carburetor heat control by the pilot, which resulted in the total loss of engine power and the subsequent emergency forced landing in rough terrain. A factor relating to the accident was the lack of experience of the student pilot.NTSB NYC91FA112Accident · 1 fatalField investigationFinal reportPiper PA-30 · Hollidaysburg, PAThe pilot's loss of control for undetermined reasons.NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…NTSB NYC91LA093Accident · No injuriesLimited investigationFinal reportCessna 150L · Chambersburg, PACarburetor ice and the pilot's improper use of carburetor heat. A factor related to the accident was: carburetor icing (weather conditions).NTSB NYC91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phillipsburg, PACarburetor ice and the pilot's improper use of carburetor heat. Factors related to the accident were: the carburetor icing (weather) conditions and the lack of suitable terrain for a forced landing.NTSB NYC91LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PADue to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.NTSB NYC91LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Punxsutawney, PAIntentional flight by the pilot into instrument meteorological conditions which resulted in a inflight collision with rising terrain, which was obscured by fog. A factor related to the accident was the pilots evaluation of the weather.NTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.NTSB NYC91LA068Accident · No injuriesLimited investigationFinal reportBeech 200 · Johnstown, PAThe pilot's failure to maintain proper directional control of the airplane during landing, resulting in a collision with a snow bank and runway marker. A factor relating to the accident was the low visibility during landing.NTSB NYC91FA067Accident · 4 fatalField investigationFinal reportMBB BK 117 B-1 · Sonestown, PAThe pilot's inadequate preflight planning to assure that the intended course and altitude provided adequate terrain clearance. Contributing factor(s) was: the dark night, snow and mountainous terrain.NTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…NTSB NYC91DGT01Accident · 1 fatalFinal reportKolb Twin Star · Carlisle, PAThe pilot's failure to maintain adequate altitude above the ground.NTSB NYC91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Easton, PAThe flight instructor allowed the airplane to get too low on final approach during the demonstration of a power off landing.NTSB NYC91LA040Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Easton, PAAn inflight failure of the left side cabin mount bracket which resulted in a loss of lateral cyclic control. Factors related to the accident were: an incomplete inspection of the helicopter following a hard landing with a blade strike.