NTSB investigations, PA
128 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 7 |
| 1984 | 10 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 8 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 6 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 7 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 6 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 NYC08CA066Accident · No injuriesData collectionFinal reportPiper PA28-180 · Blue Bell, PAThe student pilot's failure to maintain directional control while landing.NTSB NYC08CA010Accident · No injuriesData collectionFinal reportCessna 150M · Palmyra, PAThe student pilot's improper recovery from a bounced landing, and the CFI's failure to take remedial action.NTSB MIA08LA002Accident · 1 fatalLimited investigationFinal reportBellanca 7GCAA · Toughkenamon, PAThe reason for this accident is undetermined.NTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.NTSB NYC07LA227Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · West Chester, PAThe total failure of the left brake disc due to corrosion.NTSB MIA07CA118Accident · No injuriesData collectionFinal reportPiper PA-20-135 · State College, PAThe failure of the pilot to maintain directional control of the airplane.NTSB NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.NTSB NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.NTSB NYC06LA081Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Philadelphia, PAThe operator's inadequate maintenance of the fuel computer harness which resulted in engine surging and a subsequent loss of control by the flight crew during the takeoff roll.NTSB NYC06CA043Accident · No injuriesData collectionFinal reportPiper PA-23-250 · State College, PAThe pilot's failure to maintain directional control during the takeoff run. A factor was the snow-covered runway.NTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.NTSB NYC05LA070Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Warren, PAThe pilot's failure to follow the balked landing checklist while attempting to abort a landing. Factors in the accident were his failure to maintain directional control during the landing, and a gust of wind.NTSB NYC05LA067Accident · No injuriesLimited investigationFinal reportCessna 182S · West Mifflin, PAThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the gusty wind conditions.NTSB NYC05CA047Accident · No injuriesData collectionFinal reportBell 206B · Lancaster, PAThe pilot's loss of lateral control while attempting to transition to a hover from the ground. A factor was the bright sunlight conditions.NTSB NYC05LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Smoketown, PAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.NTSB NYC04LA195Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pittsfield, PAImproper installation of the tailwheel assembly and the inadequate annual inspection which resulted in a loss of directional control during landing.NTSB IAD04FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Toughkenamon, PAThe pilot's decision to add power, in an attempt to abort the landing after the airplane had veered off the runway. A factor was the pilot's failure to maintain directional control after the landing.NTSB IAD04LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Wellsboro, PAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.NTSB NYC04LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Factoryville, PAAn encounter with a deer, as reported by the pilot. A factor in this accident was the muddy grass off the left side of the runway.NTSB NYC04CA097Accident · No injuriesData collectionFinal reportCessna 182T · Perkasie, PAThe pilots' inadequate compensation for winds and his failure to maintain directional control during landing. A factor related to the accident was the gusting wind conditions.NTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.NTSB NYC03CA209Accident · No injuriesData collectionFinal reportWells Pitts S1S · Duncannon, PAThe pilot's failure to maintain directional control while landing. Factors were the gusting cross winds.NTSB NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC03LA077Accident · No injuriesLimited investigationFinal reportWaco YOC · Allentown, PAThe pilot's failure to maintain directional control while landing which resulted in a ground loop. A factor in the accident was the crosswind.NTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.NTSB NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC02LA111Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Toughkenamon, PAThe pilot's failure to maintain directional control while landing, a factor was the gusting wind conditions.NTSB NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB IAD01LA088Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's operation of the airplane with known deficiencies. Also causal was the loss of brake pressure, which resulted in the failure of the right brake, and subsequent loss of control of the airplane.NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.NTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB IAD01LA003Accident · Minor injuriesLimited investigationFinal reportPitts S-1A · Mount Pocono, PAPilot's inadequate compensation for wind conditions during landing. A factor was the crosswind.NTSB NYC00LA264Accident · No injuriesLimited investigationFinal reportAeronca 11AC-991 · Gettysburg, PAThe pilot's failure to maintain control of the airplane after landing which resulted in the inadvertent ground loop.NTSB IAD00LA077Accident · No injuriesLimited investigationFinal reportFoulke Europa TRI-GEAR · Doylestown, PAThe pilot's failure to maintain directional control during landing.NTSB NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.NTSB NYC00LA126Accident · No injuriesLimited investigationFinal reportCessna 185F · Pottstown, PAThe second pilot's inadequate compensation for wind conditions and the inadequate supervision of the flight instructor. Factors related to the accident were the crosswind and gusting wind conditions.NTSB NYC00LA110Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Waynesburg, PAThe private pilot's inadequate compensation for wind conditions and the flight instructor's delay in remedial action. A factor in the accident was the gusting wind conditions.NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB IAD00LA016Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Waynesburg, PAthe pilot's failure to maintain aircraft control during the landing roll-out.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.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 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 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 NYC98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAfailure of the pilot to maintain directional control of the airplane during the takeoff roll; and/or his failure to abort the takeoff, while there was sufficient space available to do so without hitting trees.NTSB NYC98LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Johnstown, PAthe pilot's failure to maintain direction control of the airplane during the takeoff roll. Factors relating to this accident were: the crosswind condition, and snowbank.NTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.NTSB NYC97LA189Accident · No injuriesLimited investigationFinal reportCessna 172 · Kutztown, PAthe student pilot's failure to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the student's pilot's selection of the wrong runway, the resultant tailwind, and the encounter…NTSB IAD96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pottstown, PAThe pilot's failure to maintain directional control during takeoff/ground run resulting in in-flight collision with a fence. Related factors were the pilot's poor planning/decision making, and the fog.