NTSB investigations, PA
205 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 12 |
| 1984 | 14 |
| 1985 | 9 |
| 1986 | 6 |
| 1987 | 12 |
| 1988 | 8 |
| 1989 | 3 |
| 1990 | 9 |
| 1991 | 7 |
| 1992 | 10 |
| 1993 | 6 |
| 1994 | 9 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 16 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 7 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 9 |
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\" = 250)
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" = 250) 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 NYC08CA048Accident · Serious injuriesData collectionFinal reportVans RV-8 · Latrobe, PAThe pilot's failure to maintain directional control during landing.NTSB NYC07CA231Accident · No injuriesData collectionFinal reportMooney M20C · Allentown, PAThe pilot's improper recovery from a bounced landing.NTSB NYC07LA210Accident · 1 fatalLimited investigationFinal reportCessna 150J · Hazleton, PAThe pilot’s failure to maintain airspeed while maneuvering at low altitude.NTSB NYC07LA175Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Collegeville, PAThe pilot's inadequate recovery from a bounced landing.NTSB MIA07LA121Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Unionville, PAThe pilot's failure to maintain control of the glider for undetermined reasons.NTSB NYC07LA155Accident · 1 fatalLimited investigationFinal reportBurkhart Grob Flugzeugbau Speed Astir II · Centre Hall, PAThe pilot's inability to maintain control of the glider for undetermined reasons.NTSB ATL07CA095Accident · Minor injuriesData collectionFinal reportZaverton Elmer PJ260 SR Aero Sport · Lehighton, PAThe failure of the pilot to maintain sufficient airspeed while maneuvering to avoid a stall, which resulted in an inadvertent stall/spin, and collision with trees and terrain.NTSB NYC07LA123Accident · Serious injuriesLimited investigationFinal reportDever Stits Playmate SA11A · Connellsville, PAThe pilot's inability to maintain control of the airplane due to an undetermined physiological impairment.NTSB MIA07LA091Accident · 1 fatalLimited investigationFinal reportLee Stevens Sorrell SNS-2 Guppy · Stewartstown, PAThe pilot's failure to maintain airspeed resulting in inadvertent stall. Contributing to the accident was the pilot's lack of experience in the airplane.NTSB NYC07FA003Accident · 2 fatalField investigationFinal reportMooney M20F · Brownsville, PAA loss of aircraft control, for unknown reasons, while maneuvering.NTSB NYC06LA220Accident · Serious injuriesLimited investigationFinal reportFlight Design Ctsw · Tunkhannock, PAThe pilot's improper recovery from a bounced landing.NTSB NYC06FA155Accident · 3 fatalField investigationFinal reportPiper PA-34-220T · Tafton, PAThe pilot's inadvertent encounter with a thunderstorm, which resulted in a loss of aircraft control, and a subsequent in-flight breakup.NTSB NYC06LA139Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Du Bois, PAThe pilot's inadequate compensation for wind conditions, which resulted in a stall and subsequent impact with the ground. A factor was the wind gust as reported by the pilot.NTSB NYC06LA127Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-35 · Eighty Four, PAThe pilot's incapacitation, which resulted in a loss of aircraft control during approach, and subsequent collision with trees.NTSB NYC06FA100Accident · 2 fatalField investigationFinal reportBell 47G-3B-1 · East Hanover Tw, PAThe pilot's improper decision to hover out-of-ground-effect in a tailwind, and his failure to maintain aircraft control. A factor in the accident was the tailwind.NTSB NYC06CA183Accident · No injuriesData collectionFinal reportCessna 180H · Blue Bell, PAThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in the right wing contacting the runway. A factor was the crosswind.NTSB NYC06LA019Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Doylestown, PAThe flight instructor's inadequate remedial action, which resulted in a hard landing and subsequent rollover.NTSB NYC06CA008Accident · No injuriesData collectionFinal reportEnstrom F-28C · Smoketown, PAThe student pilot's failure to maintain aircraft control while performing pedal turns at a hover, resulting in a collision with terrain.NTSB NYC06MA005Accident · 1 fatalMajor investigationFinal reportAugusta 109E · Smethport, PAThe pilot's failure to maintain aircraft control. Factors in the accident were, night instrument meteorological conditions, pilot workload, and improper air traffic control procedures by the approach controller.NTSB IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB NYC05CA108Accident · No injuriesData collectionFinal reportMooney M-20J · Toughkenamon, PAThe pilot's failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with trees. A factor was the crosswind.NTSB IAD05FA047Accident · 6 fatalField investigationFinal reportPilatus PC-12/45 · Bellefonte, PAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an instrument final approach to land, which resulted in an inadvertent stall/spin. Factors associated with the accident are the inadvertent stall/spin, the pilot's failure to follow…NTSB IAD05LA003Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Pittsburgh, PAThe delayed remedial action by the flight instructor.NTSB NYC04FA179Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Exton, PAThe pilot's failure to maintain aircraft control in instrument meteorological conditions, which resulted in the airplane impacting a residence. Factors in the accident were the pilot's lack of recent instrument experience.NTSB NYC04LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Erwinna, PAThe student pilot's failure to maintain airspeed and his failure to follow the go-around procedure which resulted in a stall.NTSB NYC04FA137Accident · 1 fatalField investigationFinal reportCessna 182C · Kutztown, PAThe towplane pilot's failure to maintain a climb while towing a glider for undetermined reasons, which resulted in the early release of the glider and the tow plane's subsequent impact with trees.NTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.NTSB NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB NYC04CA089Accident · No injuriesData collectionFinal reportCessna 172P · Zelienople, PAThe pilot's improper recovery from a bounced landing.NTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.NTSB NYC03CA152Accident · Minor injuriesData collectionFinal reportMaule MX-7-235 · East Brady, PAThe pilot's failure to maintain control of the airplane during landing.NTSB NYC03FA088Accident · 2 fatalField investigationFinal reportAviat Pitts S-2B · Newport, PAThe pilot's improper decision to perform aerobatics at a low altitude, which inhibited his ability to recover from an encountered flat spin. A factor related to the accident was the aft center of gravity, which was beyond the operational limit for the…NTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.NTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.NTSB NYC02LA125Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · York, PAThe pilot's failure to maintain proper airspeed, which resulted in a stall/mush into a corn field. A factor was the high density altitude.NTSB IAD02FA018Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Pittsburgh, PAThe (undetermined) pilot-at-the-controls' early, and over rotation of the airplane's nose during the takeoff attempt, and his failure to maintain directional control. Also causal, was the captain's inadequate remedial action, both during the takeoff attempt…NTSB IAD02FA002Accident · 2 fatalField investigationFinal reportCessna 210M · Pittsfield, PAThe pilot's loss of control in flight due to spatial disorientation, and his subsequent overstress of the airplane during a recovery attempt. A factor in the accident was the pilot's use of inappropriate medications.NTSB NYC01LA190Accident · 1 fatalLimited investigationFinal reportHolsclaw Barnett J4B · Titusville, PAThe pilot's failure to maintain control while maneuvering. A factor was the pilot's lack of experience in type of gyroplane.NTSB NYC01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150J · West Mifflin, PAThe pilot's failure to maintain airspeed while picking up a banner, and subsequent delay in releasing the banner, resulting in a stall/mush.NTSB NYC01LA138Accident · Serious injuriesLimited investigationFinal reportInterplane Sky Boy · Sayre, PAThe pilot's failure to maintain an adequate climb airspeed.NTSB NYC01LA130Accident · No injuriesLimited investigationFinal reportContinental Copters Tom Cat Mark 5A · Benton, PAThe pilot's inadequate preflight inspection, which resulted in a takeoff with a hose still attached and a subsequent dynamic rollover.NTSB IAD01LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Williamsport, PAThe pilot's premature raising of flaps resulting in his failure to establish a climb and his failure to maintain directional control.NTSB NYC01FA001Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Seven Springs, PAThe pilot's improper recovery from a bounced landing.NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.NTSB NYC00LA184Accident · 2 fatalLimited investigationFinal reportHartzell Rans S-12 · Strattanville, PAThe pilot's failure to maintain adequate airspeed during low level maneuvering, which resulted in an inadvertent stall/spin.NTSB NYC00LA180Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Bally, PAThe pilot's failure to maintain control of the airplane after an aborted takeoff.NTSB NYC00LA130Accident · Minor injuriesLimited investigationFinal reportLudeman HP-18 · Kutztown, PAThe pilot's failure to maintain control of the glider. A factor related to the accident was the pilot's lack of experience in make and model.NTSB IAD00LA039Accident · Minor injuriesLimited investigationFinal reportRotorway Rotorway 162F Exec · Mcmurray, PAThe pilot's improper in-flight planning and decision to hover out of ground effect which resulted in a loss of tail rotor effectiveness.NTSB IAD00LA031Accident · No injuriesLimited investigationFinal reportBeech 23 · Selinsgrove, PAThe student pilot's inadequate correction for torque, which resulted in a loss of directional control of the airplane.NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.