FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20090704015709ISocata TBM700 · Van Nuys, CA(-23) On July 4, 1009 1725 (z) the pilot of N850TT, a [privacy data omitted] was on the Van Nuys ILS landing 16R. [privacy data omitted] Reported run way in sight. The tower instructed [privacy data omitted] to land run way 16L. N850TT went around and was…Accident 20090704012559AAmtr Glastar · Arlington, WA(-23) On July 4, 2009 N432P, [privacy data omitted] operated by [privacy data omitted] received substantial damage after a hard landing at the Arlington airport, Arlington Washington. The pilot inadvertently switched to an empty tank, causing the engine to…Incident 20090704011349IBombdr DHC8402 · Seattle, WA(-23) PIC reported that on approach ATC requested change from runway 34L to 34C. During aircraft manuever to 34C the right outboard roll spoiler stayed fully deployed. The PIC was able to compensate with aileron, rudder and trim to level the aircraft. The…Incident 20090704011279IPiper PA28R200 · Sunriver, OR(-23) Pilot and 2 passengers landed at Sunriver to refuel. Weather was 90 degrees f., light wind, airport elevation 4126. Refueled airplane up to 38 gallons total fuel, loaded 100 pounds baggage, and 3 men in aircraft of average weight. Engine runup fouled…Accident 20090704011109ACessna 150B · Mayflower, AR(-23) On July 4, 2009 N1124Y departed from a farm pasture with a westerly bearing. The aircraft was being operated by the [privacy data omitted]pilot [privacy data omitted], a student pilot with approximately 400 hours total time. As the aircraft climbed…Accident 20090704009939ACessna 172M · Princeton/Rock, NJ(-23) Pilot turned base for runway 28 at Princeton Airport. He reduced the power for landing and then the engine lost power significantly. After 5-6 seconds the engine regained full power after turn to final on runway 28. As he reduced power for landing, once…Incident 20090703054179IPiper PA24250 · Daytona Beach, FLFlight instructor aborted take-off as they were rolling down runway 25L at Daytona Beach international airport due to a no airspeed indication. The CFI brought the engine to idle and applied the brakes in an attempt to stop before the end of the runway 25L…Accident 20090703053999ABeech C35 · Weslaco, TXJuly 3, 2009, approximately 1050 central daylight time, a Beech C35, N2043D, owned and operated by the commercial pilot, was substantially damaged upon impact with terrain during a go-around at the mid-valley airport (T65), Weslaco, Texas. The private pilot…Accident 20090703053869ACessna 172H · Clifton, MEPilot lost power shortly after take-off and at approximately 400 feet AGL. Pilot attempted to turn back and land on the lake. The pilot hit a dock on landing and destroyed the airplane. One passenger sustained minor injuries.Incident 20090703047839IWilloughby Streak Shad · Salem, WVDuring climbout engine choked and quit for unknown reasons. Pilot attempted emergency landing in grass field and ran into a fence prior to stopping causing minor damage. Pilot stated that engine ran normally prior to takeoff. Verified fuel available.Incident 20090703047709ICessna 207A · Kongiganak, AKAccording to the pilot, there were rain showers in the area, but the weather was good. The winds were from the southeast at about 30 KTS. The pilot landed on runway 18, which would result in a quartering head wind from the left. According to the pilot, after…Incident 20090703047669ICessna 172M · Pensacola, FLPilot david mccartney stated while at cruise over lillian bay at 115KTS and approximately 700 foot the aircraft engine sputtered. He stated that he added power to clear the magnetos. The sputter increased regardless of the power setting. He decided that he…Incident 20090703047579ICessna 152 · Okeechobee, FLAs the pilot taxied to the fuel pumps for refueling the passengers foot accidently slipped onto the right rudder pedal and the aircraft veered right into a security fence. The right wing leading edge and tip were damaged. Note: the FAA did not participate on…Incident 20090703047469IMooney M20C · Dawson, GAAs aircraft touched down and began roll-out on rwy 31 at 16J (Dawson Municipal Airport) both gear collapsed. Pilot advised he had green gear-down and locked indication in cockpit. Aircraft came to rest about 1000' from touchdown point. Minor damage outer…Incident 20090703025259ICessna 172S · Jacksonville, FLThe pilot was warned by the tower of the possibility of wake turbulence from a Cessna citation that just departed runway 23. The pilot was accomplishing his second touch and go of the day when he touched down and lost directional control and went off the…Incident 20090703018539IPiper PA28161 · Lake Geneva, WIPilot landed on a notam-closed runway. In his haste to clear the runway for another aircraft that was supposedly going to land, taxied onto closed taxiway. Hit pothole with nose gear and incurred propeller strike. Minimal damage incurred to aircraft.Incident 20090703017889IRobsin R22 · Put In Bay, OH(-23) Landed aircraft long, lost directional control ran off runway, thru rock pile, then taxied thru a drainage ditch.Accident 20090703016999APiper PA30 · Tucson, AZAircraft departed runway 11 left at Tucson International Airport. Left engine lost power at altitude of 20 to 30 feet and left wing dipped impacting the ground approximately 90 feet to the left of the runway. The aircraft then rolled on the ground from the…Accident 20090703013559ATcrafk DCO65TCRAFT · Tracy, CA(-23) The non certificated pilot reported that after completing his pre-takeoff checklist, he taxied onto runway 30, and proceeded to takeoff. He stated that he lifted off normally and climbed to about 300 feet above ground level. As the airplane neared the…Accident 20090703012399ACessna 172 · Latimer, IA(-23) On July 3, 2009 at approximately 1330 CDT a Cessna 172, N8138B, being flown by david n. colglazier, private pilot certificate number 2716791, impacted the roadway (C25, also known as 190th street) approximately 4 miles nw of the hampton airport (hpt)…Accident 20090703010499ACessna 441 · Albuquerque, NM(-23) On July 3, 2009 at 0540 MDT,N988AE, a Cessna 441, made a gear up landing at alburquerque international Sunport 9ABQ). The air ambulance flight had departed double eagel ii airport (aeg) in Albuquerque at 0320 MDT. After aborting the mission to socorro,…Accident 20090702047879AEurocopter AS 350 B2 · Loris, SCOn July 2, 2009,at 2101HRS, in VMC conditions, a hems helicopter circled to land at the helipad near Loris medical center, Loris, SC for an approach and landing. On final approach, the pilot asked crewmembers in the rear to call out when clear of the…Incident 20090702014359IFrchld M62A · Banning, CA(-23) Landed on runway 26 and on roll out right main gear collapsed.Incident 20090702014339IBowers 1A · Riverside, CA(-23) Pilot stated he lost power on final approach and landed short of runway 27 at ral.Accident 20090702011799ABell 206L1 · Summit County, CO(-23) While performing an external load operation the pilot noticed the aircraft start to rotate he attempted to stop the rotation but was unable, he then released the load and but was still unable to regain control which resulted in a hard impact with the…Accident 20090702011599AMooney M20M · Steamboat Spri, CO(-23) After flying in the local area, the pilot attempted a touch and go the pilot said he was at a slower than usual airspeed on final approach which resulted in a hard landing and then the aircraft started to porpoise. The pilot then initiated a go around…Accident 20090702010449APiper PA46310P · Providence, RI(-23) Reported low fuel and was vectored for the ILS approach to runway 23 at pvd but was unable to land due to poor weather conditions. Pilot then circled to rwy 34 and landed gear up.Accident 20090701054129ACessna R172K · Page, AZThere are conflicting reports on the actual date of the hard landing. There is a date of July 1, 2009 where the pilot reported to the aircraft rental location that she experienced a hard landing. Then there is another report of a hard landing by the same…Incident 20090701047729ICessna 172S · Longwood, FLOn July 1, 2009, at around 8:55 local, aircraft N60616, a Cessna model C172, lost power and landed uneventfully at the Leffler Airport near Longwood, Florida. The flight that day was a dual, instructional flight to the local practice area over lake ashby. The…Incident 20090701025229ICessna 177RG · Anchorage, AKBoth pilots stated they were on a 14CFR part 91 instruction flight that departed mri. The CFI student demonstrated gear emergency procedures when the main gear failed to extend and lock. All attempts to lower the gear using the emergency checklist failed.…Incident 20090701020029IBell 230 · Peoria, ILPilot reported a hydraulic system failure and declared and emergency. The aircraft landed without incident at Peoria, IL (pia). This incident is closed with this report.Accident 20090701017369ARemos REMOSG3600 · Oshkosh, WI(-23) Aircraft departed osh for a 1/2 hour eaa-sponsered air academy introductory flight. After approximately 30 minutes of flight, engine stopped. Determined post-accident that it was due to fuel exhaustion. Aircraft came to rest inverted, facing N280°-300,…Incident 20090701015399IPiper PA24250 · Camarillo, CA(-23) Upon landing at cma the right main landing gear partially collapsed causing the aircraft to spin off the runway.Accident 20090701012849ACessna 172N · Benton, AR(-23) On July 2, 2009, at 1700 CDT, a Cessna 172N, N5238E, departed the left side of runway 02 at Saline County Regional Airport (ksuz) Benton, Arkansas, while attempting a touch and go landing. The airplane traveled approximately 2000 feet after departing…Accident 20090701012409ASwrngn S2RG6 · Ainsworth, IA(-23) On 07/01/2009 at 12:06 pm 100 gallons of jet a was put into the aircraft by the pilot. At 12:46 pm the Washington county communications center received a 911 report of a small plane described as a crop duster that had crashed in a field in the [privacy…Accident 20090701011719ACessna T210L · Santa Teresa, NM(-23) On July 1, 2009, N2118S, a Cessna model CE-T210L aircraft with serial number 210610081 landed on runway 28 at the dona anna county airport (5T6) near Santa Teresa, NM at approximately 0820 local time. Upon landing, the aircraft left mian landing gear…Accident 20090701010459AStolam RC3 · Burley, ID(-23) Aircraft struck powerlines on takeoff climbout, when both pilots noted that aircraft was not maintaining climb performance. Weather was VMC at the time. The flight involved a student pilot[privacy data omitted] and his flight instructor, who were taking…Accident 20090701009579ADiamon DA20C1 · Spanish Fork, UT(-23) On July 1, 2009 at approximately 1300 local time, N765DC, piloted by student pilot heath buczek, was involved in an accident while performing a touch and go landing at the Spanish Fork-Springville (U77) airport in Spanish Fork, UT. During the landing…Accident 20090630020239ASchler ASK21 · Jean, NVDuring the launch phase upon reaching 60 knots airspeed, the pilot rotated and climbed to approximately 50 feet AGL, with the same airspeed the glider would not climb and immediately began to descend. The pilot simultaneously lowered the nose and released the…Incident 20090630019299IBeech 95C55 · Chicago/Prospe, ILAircraft settled down on lt. wing just after touchdown due to lt. main gear failed to extend. Pilot had gear down indication prior to landing.Accident 20090630016899ACessna LC126C · Lincoln, CA(-23) Aircraft N1064D landed at the Lincoln, CA (lhm) airport at approximately 1100 hrs on 6/30/09. Shortly after touchdown, the left main landing gear separated from the aircraft and came to rest on the left side of the runway approximately 500 feet from the…Accident 20090630011669APiper PA46350P · St George, UT(-23) Aircraft left north las vegas enroute to cedar city, Utah. Aircraft climbed to 9500 ft and was being followed by la ARTCC when radio contact was lost. Radar tracks show that the aircraft began a descent with no recovery attempts. Air traffic tried…Incident 20090630009789ICndair CL6002C10 · Salt Lake City, UT(-23) Skywest airlines aircraft N705SK was scheduled to fly from Salt Lake City to chicago on flight number 6184. The aircraft developed smoke in the cabin after push back from gate B-9. This occurred after the APU was shut down and power was applied to the…Incident 20090630009679ICessna TR182 · Austin, TX(-23) On June 30, 2009, central daylight time, a single engine Cessna 182, N5076R departed aus enroute to gtu when an engine failure occurred. The pilot made a forced landing on Texas state hwy 130. Incident was contributed to fuel starvation. VFR conditions…Incident 20090629047799IHughes 369D · Shrimp Bay, AKOn June 29, 2009, at 1613 Alaska daylight time, a Hughes HU-369-D helicopter, N1088N, operated by temsco helicopters, ketchikan, Alaska as a 14 CFR part 135 power line patrol flight sustained minor damage when a rotor blade struck a guide wire on tower #102…Incident 20090629047629IRockwell 112A · Meridianville, ALOn June 29, 2009, aircraft N1425J experienced an in flight electrical failure while in route from breckenridge county airport (I93) to madison county executive airport (mdq) causing the pilot to land the aircraft with the landing gear up. There were no…Incident 20090629012159IAmtr Kitfox · Emporia, KS(-23) On June 29, 2009 the pilot was performing touch and go's at the Emporia airport. On the third take off the engine stopped making power. With limited power and with attempts to avoid the highway, a golf course, trees, and power lines, the pilot was able…Accident 20090629011589ACirrus SR22 · Austin, TX(-23) Aircraft N220TX, a Cirrus SR-22 serial no. 2951, was returning to Austin Texas from houston Texas at 4500 feet. Pilot felt a surge then the engine stopped. Pilot executed an emergency landing onto a private dirt road. The aircraft struck a barb wire…Incident 20090629011299IGlaser DG500M · Bozeman, MT(-23) On June 29, 2009, at 1705 local time, a motorized glider, Glaser-dirks DG-500M, registered to high ridge airways, ltd, flown by [privacy data omitted] landed at the kbzn (Bozeman airport) in belgrade, monatana, on runway 30. While turning off runway 3,…Accident 20090629010279AAlexan ASW2718E · Ephrata, WA(-23) Aircraft was observed to enter thermal and then enter a stall, followed by a spin, which then progressed to a steep, spiral dive. After but a couple of rotations the wings separated from the fuselage, resulting in a fatal accident. To those observing it…