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.
Accident 20090425025149APiper PA-18-135 · Palmer, AK[privacy data omitted] Was observed water skiing his PA-18 around 20 feet from bystanders. A video was made of this. Shortly after the video was made, N3256B, the PA-18[privacy data omitted] was flying crashed. [privacy data omitted] Isn't a certificated…Accident 20090425010599AAmtr Sonex · Louisville, OH(-23) Pilot was returning from salem airport, witness stated the engine made reving noises and then stopped. Pilot made a turn then the aircraft fell from the sky. Family stated he took $50.00 to buy fuel at salem airport, the $50.00 was with his personel…Incident 20090425010359IBbavia 7GCAA · Old Town, ME(-23) During a cross wind landing phase of an instructional flight the flying pilot realized less than optimum steering authority when the tail wheel was down and he relinquished control to the rear pilot (PIC). During the roll out, with limited steering…Incident 20090425008969IBeech F33A · Goodyear, AZ(-23) On 04-25-2009 at approx 0730 a flight instructor and 2 students departed Goodyear (gyr). During take-off the instructor noticed a slight shimmy in the nose gear that stopped as the gear was raised. The tower notified the instructor that he had lost the…Accident 20090425008909AAmtr Glastar · Redding, CA(-23) Pilot reported engine power loss during cruise and determined lack of fuel pressure on the fuel gauge. He turned on the second fuel pump which gave fuel pressure for a few seconds and the engine quit completely. He made an off airport landing in a field…Accident 20090425007889ADiamon DA20C1 · Shellman Bluff, GA(-23) Upon landing the airplane veered left, the pilot added power attempting to takeoff and struck a tree with the left wing tip ground looping the airplane, breaking off the tail section. The pilot reported a cross wind of 5 to 8 mph during the landing.Accident 20090425006759ARobsin R44RAVENII · Kent, TX(-23) On April 25, 2009, at approximately 1100 CDT, N5183SJ, a Robinson R-44 ii raven helicopter,privately owned and operated under CFR title 14 part 91, was substantially damaged when the tail boom struck the ground in a rural area approximately 10 miles…Incident 20090425005339ICessna 210E · Wilmington, DE(-23) While in traffic pattern for chester county airport, (mqs), the pilot states that the landing gear lever was placed in the down position and the landing gear indicator failed to show down and locked. The "landing gear-emergency operations procedures"…Incident 20090425005249IMooney M20F · Mansfield, MA(-23) N6878V landed at marlboro, MA on runway 32 and clipped a tree with its right wing at approximately 1130 EDT, 4/25/2009. No injuries reported.Accident 20090425005019ALkheed P2V7 · Stockton, UT(-23) The aircraft flew into the side of a mountain during low ceilings and restricted visibility.Accident 20090425004979ALkheed P2V7 · Stockton, UT(-23) The aircraft flew into the side of a mountain during low ceilings and restricted visibility.Accident 20090425004409ACessna 172E · Waterford, MS(-23) On Friday, 4/25/2009, around 1835 local time [privacy data omitted] was preparing to land at a private air strip. At touch down the aircraft bounced, nosed over striking the propeller and breaking the nose landing gear out from under the aircraft. The…Accident 20090424857179AAmtr MK1 · Demopolis, AL(-23) Aircraft departed off runway 22 Demopolis, AL(dya), then turned to a downwind position. Aircraft engine sputtered and then quit. Aircraft impacted the ground in a nose low attitude and a fire ensued after impact. Aircraft destroyed and pilot received…Accident 20090424053829AEllumax Lea Epic LT · Astoria, ORPilot departed Astoria with approximately 1200 pounds of fuel. He made a maximum performance climb (2500 fpm) to 8,000 feet where he was leveling. He felt a surge in the aircraft, and glanced at his engine instruments, when the engine lost power. The pilot…Accident 20090424048819ACessna 150G · Kingston, NYPilot misjudged altitude on final approach, and clipped some trees ,which resulted in loss- of- control .the airplane went through a vinyl fence near the end of the runway this collapsed the nose gear bringing the airplane to a stop just short of the runway..Accident 20090424016809ATecnam P2002SIERRA · Lake Wales, FLThe pilot departed on runway 18 in a special light sport airplane, with his grandson onboard. The turf runway was 2,313-feet-long by 50-feet-wide, and sloped down toward the middle, with sandy, soft soil. The recorded wind at an airport located 9 miles west…Accident 20090424013449AValent TAIFUN17EII · Mammoth Lakes, CA(-23) A valentin taifun 17 e ii motor-glider, collided with terrain under unknown circumstances near Mammoth Lakes, California. The airplane sustained substantial damage to the wings and fuselage from impacting trees. The empennage remained intact. The last…Incident 20090424009079ILear 60LEAR · West Palm Beac, FL(-23) While enroute to the Bahamas, at cruiseing altitude, the flight crew noticed a loss of all hydraulic fluid. The PIC declared an emergency and diverted to Palm Beach International and landed the aircraft safely. Mobile aircraft services performed…Accident 20090424007809AMooney M20J · Moncks Corner, SC(-23) During takeoff portion of flight: power up okay, pulled back at 65/70, and left ground. Engine began to miss, checked mixture/propeller/throttle, engine ran okay. Then the engine begam missing again to approximately 50 ft AGL and stopped climbing. Pilot…Accident 20090424006699ACessna 172N · Pinehurst/Sout, NCStudent pilot [privacy data omitted], during his first solo flight, landed approximately 2300 past the approach end of runway 23 at ksop. [privacy data omitted], During this landing, struck the tail and prop, resulting in a bent tail tie down, broken prop…Accident 20090424005709ACessna 177 · Kinston, NC(-23) Aircraft was in cruise flight and developed a rough running engine. Pilot tried to correct the engine roughness with different power settings with no success. Pilot was unable to maintain altitude to land at the nearest airport 10 miles away. Pilot…Incident 20090424005609ILBL 60XLBL · Louisville, KY(-23) Safety restraint strap that runs between two carabiners at the burner frame broke during night balloon envelope was inflated and hot. Balloon broke loose from the tie down and lost control, striking one crewmember and a van from another balloon team. No…Accident 20090424004699ACessna T210* · Hanford, CA(-23) Aircraft lost engine power at 5,000' MSL, approx 4 NM north of Hanford Municipal Airport (khjo). Pilot stated that he attempted restarts but was unable. (He admits he did not switch tanks from right to left) the pilot landed the aircaft in a freshly…Incident 20090424004569IPiper PA24250 · Modesto, CAAircraft lost electrical power due to a broken alternator field wire. PIC extended the landing gear using the emergency extension system. At this time there was insufficient battery power remaining to illuminate the landing gear position lights. On landing…Incident 20090423014609ICzawsp Sportcruiser · Lakeland, FL(-23) N888MS, a Sportcruiser, LSA touched down 800 feet down at approximately 65-70 knots on a 1400 foot grass runway at "paradise city" at sun n fun (klal) on 04/23/2009. The aircraft continued down the remaining 600 feet of runway where as the PIC stated he…Accident 20090423013499AAyres S2RT34510 · Robbins, CA(-23) On may 23, 2009 at 4:30 pm aircraft N3094L a Ayres S2R-34-510 was involved in a ground loop accident on an dirt runway located 5 miles northeast of Robbins, CA. The skies were clear OAT 90 degrees winds southeast at 20 knots. While landing the pilot…Incident 20090423009579ICessna 550 · Allentown, PA(-23) Aircraft was departing on runway 24, when aircraft encountered a bird strike into right engine. Aircraft aborted take-off and taxied to the ramp without incident.Accident 20090423009309ARolsch LS818 · Fairfield, PA(-23) The pilot was participating in his first group event after several months of glider inactivity. [privacy data omitted] Was the first of four gliders launched. The second and third gliders launched encountered good lift conditions and continued on toward…Incident 20090423009199IMooney M20K · Atlanta, GA(-23) Pilot failed to extend the landing gear on approach and landed aircraft with landing gear in the retracted position.Accident 20090423007879ACessna A188B · Pinehurst, GA(-23) The agricultural aircraft on a commercial flight was substantially damaged while landing at a private turf airstrip near Pinehurst, Georgia. The airplane touched down long heading north, toward the extreme left side of the runway. The airplane traveled…Accident 20090423007619APiper PA28R200 · Hilliard, FL(-23) Pilot stated that while enroute he heard a loud bang and aircraft began to shake. While trouble shooting and with ATC help he turned to nearby airport. Enroute to airport the engine stopped. He elected to land in a field several miles short of airport.…Accident 20090423005279ABeech 58P · Houston, TX(-23) Aircraft landed with l/h main gear up on runway 17 from northwest to the southeast into a prevaling south wind. Distance from touch down to complete stop was approximately 900 feet. The left wid tip and flap impaced the runay at approximately 825 feet…Incident 20090423005189ICessna T182T · Berryville, AROn April 23, 2009 at 1030 CST a Cessna T182, N351SS registered to Cessna employee flying club took off from mid-continent airport (kict) in wichita Kansas. Visual meteorological conditions prevailed at the time and a VFR flight plane was not filed. The…Incident 20090423005149IPiper PA44180 · Portland, OR(-23) Pilot and instructor were flying VOR a approach to Hillsboro. Gear was lowered and confirmed by the pilot and CFI separately, at the initial approach fix. Gear was again separately confirmed down by both the pilot and CFI on base and again on final.…Accident 20090422011279AAmtr SONERAI2 · Grantsburg, WIAfter takeoff the pilot made a left turn in a sonerai 2 airplane and crashed in a wooded area south of circle t, a private airstrip south of Grantsburg, WI.Accident 20090422010629ACessna 210 · Richmond, IN(-23) Aircraft was on a training flight originating from phillisburg airport (3I7). While performing stop and go landings at Richmond Municipal Airport (rid) the aircraft landed gear up on runway 24 during the last landing attempt. Aircraft sustained…Incident 20090422009119IMooney M20C · Greer, SC(-23) On March 22, 2009, on about 1455 eastern standard time, a Mooney M20-C aircraft N3411X registered to [privacy data omitted]. Operating as 14 CFR part 91 flight had a prop strike during take off from runway 22 at Greenville Spartanburg airport (gsp).…Incident 20090422009089IAmtr Barracuda · Melbourne, FL(-23) After the poor hard landing in melborne, in a right cross wind the right retractable gear on this Barracuda experimental (N289DH) collapsed causing minor damage to the right wing tip. They were able to lift the wing on the runway and lower the gear to…Accident 20090422007909ABell 206B · Fort Rucker/Do, AL(-23) The accident occurred while performing military training. The aircrew was conducting a simulated engine failure while on approach and entered a standard autorotation to lane 5 in the pattern at Toth stage field. The aircraft sustained substantial damage…Accident 20090422007899AMaule M5180C · Moultrie, GA(-23) The aircraft was substantial damaged during a forced landing on approach to Spence Airport (mul), Moultrie, Georgia. During the approach and descent into kmul, the airplane was at an altitude of approximately 1,500 feet above mean sea level (MSL)and…Accident 20090422007099ACessna 172E · Tucson, AZ(-23) On 04-22-2009 at approximately 1311 MST, N3880S (CE-172-E) lost directional control and departed the left side of runway 24L at Ryan Field (kryn) near Tucson, AZ during the takeoff roll. METAR records form 22/1946Z (1246 MST) 25 minutes prior indicated…Accident 20090422006679ACessna 182T · Rangely, CO(-23) The pilot departed from laramie, WY at about 10:30. His destination was scottsdale, AZ. On the final approach to runway 24 the airspeed was apparently too fast as the aircraft floated down the runway. When the aircraft touched down approximately half…Accident 20090422005859ALuscom 8C · Terrell, TX(-23) During taxi (after landing) the right wheel assembly broke off while approaching taxi turnoff.Incident 20090422005849ICapras AVENTURA2 · Des Allemands, LA(-23) During take off and climb while makeing a left handed turn; airplane lost altitude and struck a tree before impacting the ground 15' from the tree causing fatal injuries to the pilot. Airplane skidded and came to a rest inverted 25' from the point of…Incident 20090422005719IAmtr Lancair · Eads, CO(-23) Experimental amature built aircraft N114L, was en route from palo alto, California to dodge city, Kansas when the window in the pilots door failed at FL 230. The pilot and pax immediately used the oxygen during descent to the airport. The pilot made a…Accident 20090422004549AHughes 269C · Las Vegas, NV(-23) On 4/22/2009, PIC [privacy data omitted] was demonstrating a pinnacle approach to his student within the foothills adjacent to the northwest practice area, and approximately 15 miles n/w of the north Las Vegas airport (vgt). PIC [privacy data omitted]…Incident 20090421014619IAmtr FM2 · Lakeland, FL(-23) After a performance during sun-n-fun, on landing roll out the pilot lost directional control damaging his left wing tip causing slight buckling of the associated skin off setting his airspeed pitot tube approximately 5 degrees. As damage was minor we…Incident 20090421009129ITecnam P92EAGLET · Quitman, GA(-23) While flying at 5500 ft and 5100RPM the left leading edge started pulling loose and rivets poping on wing out board of wing light assy. Fuel tank collapsed from landing light fairing to left strut along with the rivets pulled loose from the main wing.…Accident 20090421007229ACessna 172M · Corona, CA(-23) On landing,the aircraft touched down on the nose gear first, causing the nose gear strut to collapse and a wrinkle to appear on the engine bay firewall.Accident 20090421007189ABeech V35B · Groveland, CA(-23) While performing a simulated "engine out" approach for a downwind landing on runway 9 at E45: due to the steep approach, the certificated pilot and certificate flight instructor attempted a go-around but reported that the engine did not respond to…