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 20090807015749IRobsin R44II · Lakeside, CA(-23) Pilot heard a loud noise followed by a loss of power and RPM, pilot executed an auto rotation to a dirt road at el capitan reservoir near Lakeside, CA.Accident 20090807014679ABbavia 7AC · Broadus, MT(-23) On 08/07/2009 at approximately 0700MDT, [privacy data omitted] was acting as pilot in command of N84787, an Aeronca 7AC. During the flight while operating close to the ground, [privacy data omitted] impacted the ground with the right wing. The aircraft…Incident 20090807014369ICessna 172S · Van Nuys, CA(-23) Pilot said that he touched down on runway 16L at approximately 40 knots near taxiway "gulf" and applied normal braking soon afterwards. He stated that the left brake "grabbed" unexpectedly - possibly locking up. As the aircraft veered left he applied…Accident 20090807013169ATmpson Naviona · Nyssa, OR(-23) The non instrument rated pilot and two passengers had departed jerome, Idaho and were en route to southern Washington state in maginal VFR weather conditions with localized mountain obscuration. The aircraft did not arrive at it intended distination and…Accident 20090807012419ACessna 182R · Newburgh, NY(-23) Operated under 14 CFR part 91, pilot was departing airport on grass runway. Pilot began to lose control of aircraft drifted left and the left wing tip began striking tree branches until coming to a full stop.Accident 20090807012329APiper PA22150 · Paris, ID(-23) Aircraft was near gross weight on high density altitude day. The aircraft did not have the performance to climb high enough to get through the mountain pass. The aircrafts right wing struck the ground resulting in a hard landing, and the right wing…Accident 20090806048429ACessna 172S · Bluffton, OHStudent departed fdy for solo practice. While practicing touch and go landings at 5G7, on runway 5, the pilot reported the left main touched down first, followed by the nose gear. He reported hearing a noise, but thought it was the nose gear hitting the…Incident 20090806048109IBeech 99 · Port Alsworth, AKThe anchorage FSDO incident number is:IAL0320090049. Nose gear failed to extend prior to landing. At tpo pilot attempted to extend gear normally and later by emergency means, but nose gear would not extend. Pilot conferred with maintenance staff and tried…Incident 20090806025329ICessna 170B · Anchorage, AK08/06/09- The airman was practicing touch and go landings on runway 25 at mri. The conditions were day VMC, dry, wind 290/04. On the airman's second landing he lost control and the aircraft veered off the runway to the right and nosed over causing damage to…Incident 20090806018649IBoeing 737890 · Los Angeles, CALeft hand nose tire failed during takeoff. Aircraft executed a fly by, then landed without incident. Both nose wheels were replaced and the aircraft was taken to the gate.Incident 20090806015279IPiper PA31 · Independence, KS(-23) Enroute to wiley post (kpwa) from alma municipal airport (K36V), 17 miles north of Independence, Kansas, the aircraft experienced an engine fire on the l/h engine. The pilot shut off the fuel, feathered the prop and shut down the left hand engine. He…Incident 20090806014549IBeech 45 · Lincoln, NE(-23) On an IFR flight plan from st. cloud regional (kstc), to pueblo memorial (kpub), at a cruising altitude of 43000 feet, the pilot noticed the hydraulic low pressure light illuminate followed by a total loss of pressure. The pilot declared an emergency…Incident 20090806013009IPiper PA16 · Bloomfield, KY(-23) Aircraft lost power and landed in a field. The aircraft contacted a barbed wire fence on landing. Aircraft came to rest facing 180 degrees to the director of the initial landing roll and contacted a concrete pylon prior to stopping. Minor damage to…Accident 20090805048759AVanderhoof AIR Command · Mentone, INAircraft lost directional control during landing rollout. After running off the right side of the runway the gyroplane collided with a parked gyroplane. Regarding #12, NTSB is calling the parked aircraft on side of runway an object instead of an aircraft…Accident 20090805048409ADe Havillan DHC-8-311 · Fayetteville, NCPrior to entering clouds the pilot notified the flight attendant to discontinue the beverage service. The aircraft experienced moderate turbulence for 15 seconds. Flight attendant advised PIC of medical situation. PIC declared emergency and received approval…Incident 20090805048211ITaylorcraft BC12-D · Somerset, NJThe pilot was propping the engine in order to fly. The rope that was tieing the tailwheel to the ground stake broke when the engine started. The pilot grabbed the wing strut to hold the aircraft from moving. The aircraft pivoted and turned into the aircraft…Incident 20090805048169ICessna 152 · Ruleville, MSPilot was on a cross country flight for his course curriculum under the 141 program. Pilot failed to verify that full tanks were full at departure airport other than putting finger in tank. At first airport of landing pilot failed to check the aircraft fuel…Accident 20090805019409ACessna 182S · Napa, CA1 North of Napa, CA: N23750, C182, Napa-bakersfield, CA. Crashed shortly after takeoff in hilly terrain under unknown circumstances. POB: 1, injuries: fatal, damage: substantial.Accident 20090805017649AHomebuilt · Kaplan, LA(-23 Aircraft took off at approximately 1345 from private strip off of farmers road in Kaplan Louisiana. The aircraft headed north over tee brads flying service. Neighbor heard engine cut out on aircraft and proceeded down the road looking for Mr. Ramero.…Accident 20090805016979ABeech 35BEECH · St Johns, AZ(-23) [privacy data omitted] was PIC and the only occupant of the aircraft at the time of the accident. He stated that during the takeoff roll he applied crosswind corrections for a left quartering headwind but did not experience the "buffeting" associated…Accident 20090805016759AEirvon PIK20B · Tucson, AZOn 08/05/2009 at approximately 1500 MST, N77MA (a eiriavon oy pik 20B glider) made an off-airport landing when unable to locate sufficint thermal lift activity to enable the glider to return to el Tiro glideport near marana, AZ while returning from a…Accident 20090805013159ABeech 35BEECH · Oklahoma City, OK(-23) Aircraft lost power while inbound to Sundance Airpark (khsd) in Oklahoma City, Oklahoma. Aircraft made an off airport landing approximately 3/4 mile north-west of runway 17 at khsd. During the landing the nose wheel strut sheared off causing the nose of…Accident 20090805012919ALuscom 8A · Eatonville, WA(-23) The pilot reports that after approximately 1 hour flight time the aircraft started having problems. He stated that the engine stopped and would not re-start. He managed to glide the aircraft down and into a field. Upon touchdown the aircraft slid…Accident 20090804053959ABombardier CL-600-2B19 · Louisville, KYOn August 4, 2009 pinnacle airlines flight 2871 operated as northwest airlink while enroute from knoxville, TN to detroit, mi encountered severe turbulence while cruising at 30,000 feet. Multiple injuries on board the aircraft required the flight crew to make…Accident 20090804048729AAustin Howa Rans S-12XL · Quitman, GAPilot states that due to his own error he got low on approach and contacted a tree top.Incident 20090804048679ICessna 402B · Miami, FLOn 8/4/2009 ATP rated pilot flew N6363C, CE-402B, via ferry permit from fxe to Tamiami airport, Miami for maintenance. Pilot took off, climbed and performed normal retraction of nose and left main gear. Rt main showed not retracted and landing gear c/b was…Accident 20090804048069ACessna 172S · Calera, ALFirst solo flight: total flight time: 23.1 hours, total time in aircraft: 23.1 hours, 3.4 hours in last 30 days. Student pilot attempting first solo landing touched down at mid field (2500') bounced twice, then re-applied power to gain directional control.…Accident 20090804025319ADestiny Destiny XLT · Athens, GAOn August 4, 2009, about 1930 eastern daylight time (EDT), an unregistered experimental two place powered parachute impacted trees just beyond a pasture on a private cattle ranch located in Athens, Georgia. There is no record of the pilot being a certificated…Accident 20090804016959ABoeing E75 · Happy Jack, AZ(-23) On 8/4/2009 at approximately 1510 MST, Mr. Robert remiro was flying from cottonwood Arizona to holbrook, Arizona, when the plane he was piloting, a Boeing E-75 stearman, struck the ground approximately 35 miles southeast of flagstaff, Arizona. During…Accident 20090804016509AAirtrc AT401B · Oelwein, IA(-23) Two separate witnesses stated that the aircraft let out a puff of smoke prior to the accident. The aircraft lost engine power. The pilot made an emergency landing in the cornfield. The initial investigation revealed that the engine was not producing…Accident 20090804016419ASnias AS350B3 · Jacksonville, FL(-23) While conducting a training flight for us customs/border patrol, the student was practicing normal approach to a hover and hydraulic-loss emergency scenarios. When the aircraft became too difficult to control the student turned over the controls to the…Incident 20090804015319ICessna 210 · Santa Ana, CA(-23) This was a night flight from cma to sna. The pilot discovered after takeoff from cma that the landing gear would not retract. The landing gear up and locked light would not illuminate and the pilot heard the landing gear actuator cycling, but would not…Accident 20090804012599ALBL 240ALBL · Albuquerque, NM(-23) On August 4, 2009 at 0805 MDT, N494LB, a lindstrom A240 hot air balloon, laned near I-40 and 98th st. in Albuquerque NM. After the landing, one passenger complained of a hurt right arm. The arm was subsequently diagnosed as broken. The pilot and nine…Accident 20090803857449AMooney M20F · Suffolk, VAAfter approximately 10 minutes of flight, the engine experienced a power loss due to fuel exhaustion. The pilot attempted a forced landing on a road, when he touched down, he was unable to negotiate a turn in the road and lost directoinal control. The right…Incident 20090803053879ICessna 182H · New Knoxville, OHThis incident was never reported when it occurred and was discovered during the investigation of complaint #CGL0720100005 on March 11, 2010.while completeing the roll out after landing on runway 26 at Niel Armstrong Airport (axv) N8486S was struck by a…Accident 20090803016529APiper PA25235 · Royal, IA(-23) Pilot was commencing aerial application operations. The pilot reported that the aircraft had 39 gallons of fuel and 104 gallons of chemical. Pilot report shows aircraft was operating under the aircraft gross weight. ASOS weather was calling winds at 5…Accident 20090803016149ACessna 172S · New Braunfels, TX(-23) Student pilot on second supervised solo flight during the third landing failed to control rate of descent on short final allowing the aircraft to bounce back airborne, then the aircraft landed hard on the nose gear and bounced a second time. The student…Accident 20090803014429AUnivar 1082 · Salt Lake City, UT(-23) The engine quite running so the pilot landed in a field one mile east of slc airport. The aircraft went through deep ditch which folded the gear back. It slid on its belly for 150 feet or so. The inspection of the aircraft revealed that the accessory…Incident 20090803012669ICessna TR182 · Killeen, TX(-23) On August 3, 2009, Mr. Koerper acted as pilot in command his aircraft a 1978 Cessna 182RG registration number N73622. During the landing phase at Skylark airport, Killeen, TX, Mr. Koerper did not lower the landing gear. The aircraft skid on the runway…Incident 20090803012659IEMB ERJ170100SU · Pittsburgh, PARight outboard tire failure had occurred. Damage occurred to right outboard landing gear door, bottom of wing (puncture), wing access panel, two attaching tubes, (one bent and the other broken). Tire appeared to have approximately 50 percent tread life…Accident 20090803012189AAmrgen AA1B · Whitney, TX(-23) On August 03, 2009 N1644R, Grumman AA1B departed lake Whitney airport, F50 for a routine flight at 1015 hours. Right after takeoff the engine started to run rough and lose power. The pilot, mr jonathan wroten attempted to turn around and land at the…Incident 20090802049509ICessna 172R · Hollywood, FLATC cleared N402ER to stay at or below 500 feet along the shoreline for traffic separation. At the time N402ER has been visually acquired the ac was probably flown around 100 feet off the water close by the shoreline. Initially the impression was that the ac…Accident 20090802048719APiontkowski Challenger · Kankakee, ILMr. Piontkowski departed the greater Kankakee airport. He flew over the river at an altitude lower than the treetops as described by two witnesses. He impacted a wire that ran from the shoreline to an island. During the rescue and ensuing successful attempt…Accident 20090802047979APiper PA-34-200T · Lincoln Park, NJOn 08/02/09 at approximately 1238 local time, N551N a Piper PA-34-200T, was substantially damaged after its gear collapsed while landing on runway 19 at Lincoln Park Airport, NJ (N07). The pilot stated that the aircraft bounced on the initial touchdown and…Accident 20090802014629ASchemp Discuscs · Williams, CA(-23) Glider released from tow plane at low altitude. Aircraft made a right turn, caught the right wing and cart wheeled into a rice field adjacent to the willims glider port at 021140 PDT. The sole occupant was transported to chico hospital with injuries.Accident 20090802014589AAmtr Davez · Santa Monica, CA(-23) On August 2, 2009, about 1445 pacific daylight time, a william a. davenport dav-ez, experimental amateur built airplane. N7CE, sustained substantial damage following an uncontrolled descent and impact with terrain at the Santa Monica Municipal Airport…Accident 20090802014449ACessna 182P · Gateway, CO(-23) The pilot and two passengers departed montrose, CO airport (mtj) at approximately 0915. After flying around montrose for awhile they headed to Gateway, CO. After landing the roll out the left wheel hit some soft dirt which pulled the plane further to…Incident 20090802013119IBeech A36 · Roche Harbor, WA(-23) N161TS a Raytheon A36 was parked on an inclined ramp. Pilot removed nose wheel chalks from aircraft N161TS. N161TS started to roll down the incline. The pilot attempted to get inside the aircraft to gain control. He was unable to stop the aircraft…Incident 20090802012229IPiper PA28236 · Omaha, NE(-23) The pilot reported encountering a gust of wind just as the aircraft was landing on runway 30. This caused the aircraft to go off the right side of the runway and hit two runway lights. Minor damage to the right wheel fairing was the result. METAR kmle…Incident 20090801049229IThrush S2RHGT65 · Knox, INPilot reported a loss of power and requested the nearest airfield as soon as possible. Post landing engine inspection revealed the gas turbine section had what was described as "came apart" and failed. Aircraft landed without incident and was dis-assembled…