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 NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.NTSB NYC90LA080Accident · No injuriesLimited investigationFinal reportCessna CE-172P · Hollidaysburg, PAPilot factor in that he failed to ensure there was sufficient fuel on board to complete the flight. This resulted in an engine failure & subsequent forced landing.NTSB NYC90LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Philadelphia, PAThe failure of the pilot to ensure sufficient fuel was on board for the intended flight, resulting in a power loss due to fuel exhaustion. Factors related to the accident were unsuitable terrain, and the failure of the pilot to divert in a timely manner.NTSB NYC90FA077Accident · 2 fatalField investigationFinal reportCessna 177 · Forty Fort, PALoss of engine power for an unknown reason, and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB NYC90LA071Accident · No injuriesLimited investigationFinal reportCessna 177RG · Harford, PAA loss of braking action which allowed the aircraft to run into trees after the pilot made a precautionary landing due to a rough running engine of undetermined cause.NTSB NYC90LA064Accident · No injuriesLimited investigationFinal reportMooney M20-K · Gibsonia, PAThe collision with rods in the field as the pilot was attempting a forced landing after a complete engine failure.NTSB NYC90LA062Accident · No injuriesLimited investigationFinal reportCessna 182N · Milford, PAThe loss of directional control by the pilot during a short soft field takeoff on a snow packed runway.NTSB NYC90LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Brogue, PAOff airport landing due to an engine power loss due to failure of the no. 2 crankshaft bearing.NTSB NYC90LA052Accident · Serious injuriesLimited investigationFinal reportCessna C150 · E. Prospect, PAPilot's improper execution of emergency procedures after the engine failed. The pilot lost control of the airplane while maneuver the airplane back to the airstrip during the forced landing. The pilot stalled the airplane at too low an altitude to recover.NTSB NYC90IA050Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Philadelphia, PAThe flight crew of EAL121 taking off on a taxiway. Contributing was failure of the flight crew of eal 121 to maintain an adequate visual lookout during taxi and takeoff.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…NTSB NYC90LA045Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Slippery Rock, PALoss of airspeed and an inadvertent stall by the pilot during an attempted return to the airport, following a power loss due to carburetor ice.NTSB NYC90LA043Accident · No injuriesLimited investigationFinal reportCessna 150L · Lehighton, PALoss of engine power for an undetermined reason.NTSB CHI90FA050Accident · 2 fatalField investigationFinal reportBeech 60 · Erie, PAThe pilot's failure to assure that the aircraft had an adequate supply of fuel on board for the intended flight. Contributing factors to the accident were an inoperative right fuel quantity gage which resulted in inaccurate fuel consumption calculations, and…NTSB NYC90LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Johnstown, PAFailure of the pilot to maintain proper airspeed and altitude on an ILS final approach, which allowed the aircraft to descend below the glide path and collide with approach lighting. Factors related to the accident were: darkness, adverse weather conditions,…NTSB NYC90LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Coatesville, PAImproper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC90LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Friendsville, PAThe pilot failed to maintain airspeed and stalled the aircraft.NTSB NYC90LA014Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Pittsburgh, PAThe pilot's improper in-flight planning and decision, and diverting of his attention, which resulted in fuel exhaustion to both engines. Darkness and trees in the emergency landing area were related factors.NTSB NYC90LA010Accident · No injuriesLimited investigationFinal reportBeech 58 · Philadelphia, PAThe failure of the pilot of N333TQ to taxi at a speed that would allow him to stop under existing conditions of visibility and taxiway conditions.NTSB NYC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Falls, PAThe right fuel vent became clogged allowing the left fuel tank to become exhausted. In addition, the pilot failed to adequately monitor the fuel supply in each tank.NTSB NYC89FA221Accident · 1 fatalField investigationFinal reportAeronca 65TL · Beaver Falls, PAThe failure of the left wing, rear upper strut attachment. The failure was caused by not installing the retaining bolt and nut.NTSB NYC89LA217Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Philadelphia, PAFuel starvation, due to the pilot's failure to assure the fuel selector was positioned to a tank with adequate fuel for landing, and his failure to follow the proper emergency procedure after the tank emptied.NTSB NYC89LA216Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Andreas, PAFailure of the pilot to maintain airspeed, which resulted in a stall.NTSB NYC89LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly · Hatboro, PAImproper in-flight planning/decision by the pilot which resulted in his failure to maintain clearance obstructions. A related factor was: the low level of propane (fuel), which resulted in low burner pressure.NTSB NYC89LA202Accident · No injuriesLimited investigationFinal reportCessna 150H · Northeast, PAA power loss due to an over-rich engine for undetermined reasons. The combination of an over-rich running engine and the pilot's pumping of the throttle during the recovery attempt caused the engine to flood.NTSB NYC89LA196Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Factoryville, PAInadequate preflight by the pilot and his misjudgement of the fuel supply, which resulted in fuel exhaustion. The ditch was a related factor.NTSB NYC89LA187Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Mount Joy, PAThe pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.NTSB NYC89LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Philadelphia, PALoss of engine power for an unknown reason. A factor related to the accident was: water in the emergency landing area.NTSB NYC89LA218Accident · No injuriesLimited investigationFinal reportCessna 305A · Chalfont, PAThe pilot's improper use of carburetor heat, which resulted in a power loss due to carburetor ice. Factors related to the accident were: carburetor icing conditions and rough/uneven terain in the emergency landing area.NTSB NYC89FA177Accident · 7 fatalField investigationFinal reportBeech A36 · Salisbury Twp, PAThe failure of both pilots to see and avoid each other. A contributing factor to the accident was that neither pilot was heard over the radio announcing their position and intentions.NTSB NYC89LA178Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt Pleasant, PAAn improper flare by the pilot that resulted in a hard landing.NTSB NYC89LA173Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-23 · Eighty Four, PAPoor handling of the glider durig landing. The pilot over corrected and caused the nose to strike the runway surface. Directional control was lost, resulting in a groundloop.NTSB NYC89FA166Accident · 3 fatalField investigationFinal reportPiper PA-28-236 · Thomasville, PAThe pilot's failure to fly the published approach procedure, which resulted in controlled flight into the terrain.NTSB NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.NTSB NYC89LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Doylestown, PAImproper preflight preparation by the pilot by taking off with the flaps extended, which resulted in an inadequate rate of climb to clear obstructions beyond the end of the runway, and the pilot's delay in aborting the takeoff and his failure in maintaining…NTSB NYC89DHA01Accident · No injuriesFinal reportVehafric Jungster ONE · Reading, PAThe failure of the pilot to properly use carburetor heat.NTSB NYC89LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Pittsburgh, PALoss of control during landing rollout due to excessive application of brakes by the pilot.NTSB NYC89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dillsburg, PAThe engine stoppage caused by the lack of engine lubricant.NTSB NYC89LA145Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Erwinna, PALoss control and collision with trees due to failure of the student pilot to compensate for the wind and lack of supervision by the CFI.NTSB NYC89LA143Accident · No injuriesLimited investigationFinal reportBeech 60 · Philadelphia, PAImproper flare by the pilot during the landing, and his failure to maintain directional control of the aircraft.NTSB NYC89LA136Accident · No injuriesLimited investigationFinal reportMaule M5 · Kutztown, PAAn off airport landing in unsuitable terrain due to a power loss for undetermined reasons.NTSB NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.NTSB NYC89LA130Accident · No injuriesLimited investigationFinal reportCessna C182Q · Beaver Falls, PAThe pilot failure to properly flare the airplane during landing and the improper recovery from a bounced landing.NTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.NTSB NYC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dushore, PACollision with trees during a rejected takeoff from a private turf strip due to the pilots failure to take advantage of the existing wind.NTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.NTSB NYC89LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · W.Mifflin, PAThe improper level off of the aircraft by the pilot which resulted in a hard landing and subsequent gear collapse.NTSB NYC89LA117Accident · No injuriesLimited investigationFinal reportCessna 172M · Palmyra, PAThe pilot misjudged the airspeed and distance during the landing.NTSB NYC89GA116Accident · 2 fatalFinal reportBell 206B · Airville, PAThe pilot was unable to see and avoid the unmarked power lines stretched across the river. A contributing factor was the lack of visual clues.NTSB NYC89DGM01Accident · No injuriesFinal reportSharp FOX Model 1 · Loretto, PAThe loss of engine power for undetermined reasons.