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 NYC96LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bath, PAthe pilot's improper in-flight decision and planning, and his mismanagement of the fuel supply, which resulted in fuel exhaustion and the loss of engine power. Darkness and low clouds in the emergency landing area were related factors.NTSB NYC96LA095Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R200 · Forks Township, PAthe flight instructor's misjudgment of distance and altitude, and delay in performing remedial action.NTSB NYC96LA071Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Philadelphia, PAthe pilot's improper planning/decision, and his resultant flight into known icing conditions, which resulted in ice accumulation, loss of engine power, a forced landing, and subsequent collision with a residence and a vehicle. A factor relating to the…NTSB IAD96IA048Incident · Minor injuriesIncident investigationFinal reportBoeing 767-2B7 · Pittsburgh, PAthe in-flight encounter with unforecast turbulence.NTSB NYC96LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-350P · Butler, PAthe pilot's inadequate compensation for wind conditions during the final approach, which resulted in the uncontrolled descent and subsequent collision with the ground. A contributing factor is windshear conditions.NTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.NTSB NYC96LA058Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Bradford, PAthe pilot misjudged the flare during landing. Factors in the accident were: an improper recovery from a bounced landing, and the first officers lack of experience in this type operation.NTSB NYC96LA053Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-6 · Allentown, PAthe pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.NTSB NYC96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Silver Spring, PAA loss of engine power as a result of fuel exhaustion.NTSB NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.NTSB NYC96LA044Accident · 1 fatalLimited investigationFinal reportCessna 182E · Pymatuning, PAthe pilot's intentional suicide.NTSB NYC96LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Somerset, PAthe pilot's improper planning/decision and use of unsuitable terrain for a precautionary landing, which resulted in a collision with an embankment and subsequent nose over of the airplane. Factors relating to the accident were: the adverse weather conditions,…NTSB NYC96FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Rush Township, PAthe pilot's continued flight into adverse weather conditions which resulted in becoming lost and disorientated and subsequent impact with rising terrain. Factors in this accident were fog and a dark night.NTSB CHI96FA045Accident · 1 fatalField investigationFinal reportPiper PA-28 · Friedens, PAthe pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB NYC96LA026Accident · No injuriesLimited investigationFinal reportFairchild Merlin Iiia · Butler, PAfailure of the pilot to perform a missed approach, when the airplane was not properly aligned with the landing runway; and his failure to properly flare the airplane, which resulted in a hard landing.NTSB NYC96LA019Accident · Serious injuriesLimited investigationFinal reportPezold Lancair IV-P · Somerset, PAfailure of the fuel pump driveshaft, which resulted in fuel starvation and loss of engine power.NTSB NYC96LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Honsdale, PAthe pilot's improper evaluation of the weather briefing, and his decision to fly into known forecasted moderate to severe icing conditions. Factors in the accident were the adverse weather conditions encountered during the flight and landing.NTSB NYC96LA009Accident · No injuriesLimited investigationFinal reportCessna 172G · Wilkes-Barre, PAthe instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.NTSB NYC96LA007Accident · No injuriesLimited investigationFinal reportTeague Pitts S-1S · Erwinna, PAthe pilot's misjudged flare and improper bounced landing recovery. Factors were the pilot's lack of recent experience and a false oil pressure gauge indication.NTSB NYC96LA005Accident · No injuriesLimited investigationFinal reportKelosky Pulsar XP · Zelienople, PAThe pilot inadvertently allowed the airplane to lift-off during a high speed taxi check, while operating the airplane with a known deficiency that consisted of a partially blocked quick disconnect fitting, which resulted in fuel starvation and the loss of…NTSB BFO96FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bird-In-Hand, PAthe pilot's (PIC's) improper in-flight planning/decision concerning simulated instrument flight during the traffic pattern/descent; and failure of the safety pilot (other crewmember) to provide adequate visual lookout to see-and-avoid the obstruction.NTSB NYC96FA003Accident · 2 fatalField investigationFinal reportEnstrom 280C · Quakertown, PAimproper installation of the magneto by maintenance personnel, which resulted in the loss of ignition and the loss of engine power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB NYC95LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Warminster, PAthe pilot's improper positioning of the fuel selector which resulted in a total loss of engine power due to fuel starvation. A contributing factor was pilot distraction.NTSB NYC95LA227Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pittsburgh, PAthe pilot's failure to obtain the proper touchdown point and excessive airspeed which resulted in an overrun and a subsequent collision with a trailer off the departure end of the runway.NTSB NYC95LA222Accident · No injuriesLimited investigationFinal reportMooney M20J · Jonestown, PAthe pilot's failure to maintain adequate airspeed during a go-around.NTSB NYC95LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Quakertown, PAthe pilot's failure to maintain directional control, and the pilot's improper use of the wing flaps, which resulted in an inadvertent stall, and contact with trees. A factor was the crosswind.NTSB NYC95LA218Accident · No injuriesLimited investigationFinal reportMarkwood BD-4 · Connellsville, PALoss of braking action at the right brake, due to a low level of hydraulic fluid and inadequate maintenance, which resulted in the loss of aircraft control.NTSB NYC95LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Orson, PAThe pilot's improper planning/decision, and his delay in aborting the takeoff, which resulted in a collision with a pile of dirt and shrubs. The upsloping terrain (for takeoff) was a factor.NTSB NYC95LA197Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340-A · Philadelphia, PAthe failure of a titanium hydraulic line, which resulted in an uncontained hydraulic fluid wing fire. A factor was the use of a procedure by the operator, approved by the FAA, but not approved by the airplane manufacturer, which resulted in compartment…NTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.NTSB NYC95LA194Accident · 2 fatalLimited investigationFinal reportGreat Lakes 2T1-A2 · Fombell, PAthe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed.NTSB NYC95FA195Accident · 2 fatalField investigationFinal reportCessna 310R · Altoona, PApropagation of corrosion cracks in the right engine overboard exhaust stack and fatigue failure of the exhaust stack, which resulted in escape of hot/high velocity gases, in-flight fire, emergency descent, and subsequent collision with trees during an…NTSB NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…NTSB NYC95LA184Accident · No injuriesLimited investigationFinal reportMooney M20C · Montgomery, PAThe partial loss of engine power, as a result of an excessively rich fuel flow in the carburetor, and a subsequent forced landing. A factor relating to the accident was the malfunction of the landing gear.NTSB NYC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Avoca, PAthe pilot's poor inflight decision and improper fuel management resulting in fuel exhaustion and a subsequent forced landing over rocky terrain.NTSB NYC95LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Honesdale, PACorrosion and subsequent failure of the attaching lugs for the left (4H) shock strut assembly, which resulted in collapse of the landing gear/skid.NTSB NYC95LA169Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-2S · Honesdale, PAthe pilots misjudgment of the altitude required to perform an aerobatic maneuver, and the subsequent collision with trees.NTSB NYC95LA173Accident · Minor injuriesLimited investigationFinal reportRyan ST3-KR · Kennett Square, PAThe failure of the no. 3 cylinder connecting rod.NTSB NYC95FA162Accident · 1 fatalField investigationFinal reportCessna 140 · Danielsville, PAThe flight crew's improper in-flight planning/decision, and failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors relating to the accident were: darkness, fog, low clouds, and the high terrain.NTSB NYC95LA159Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Pottsville, PAimproper installation of a fuel line fitting by the pilot/owner which resulted in fuel blockage and subsequent loss of engine power due to fuel starvation.NTSB NYC95LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Beaver Falls, PAthe failure of the student pilot to maintain directional control after touchdown.NTSB NYC95LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Minersville, PAthe student pilot's improper go-around procedure, which resulted in an inadvertent stall/mush into trees.NTSB NYC95LA145Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Monogahela, PAThe failure of the pilots of the monney M20C, N2763W, and the Piper PA-28, N7416R, to see and avoid each other.NTSB NYC95IA164Incident · No injuriesIncident investigationFinal reportEnstrom F-28A · Philadelphia, PAthe pilot's failure to maintain aircraft control resulting in a collision with the water.NTSB NYC95LA141Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Smoketown, PAfailure of the pilot to follow the recommended starting procedures.NTSB BFO95LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Factoryville, PAthe loss of engine power for undetermined reasons, and the subsequent hard landing by the student pilot.NTSB NYC95LA132Accident · No injuriesLimited investigationFinal reportBeech 33 · Franklin Twp, PAThe pilot's improper planning/decision, his continued flight into adverse weather conditions, and his delay in reversing course (diverting to a new destination). The adverse weather with thunderstorms was a related factor.NTSB BFO95LA059Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncy Valley, PAthe non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.NTSB BFO95LA057Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Quarryville, PAthe pilot's failure to attain proper altitude/clearance from obstacles during takeoff.