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.

Accident 20060410011079ACessna TR182 · Fort Wayne, IN(-23) Pilot was practicing touch and go's and failed to extend landing gear. Due to a similar incident on 11/05/2005 at vpz [privacy data omitted]Apr 10, 2006 · N287BW · Substantial damageIncident 20060410010609ICessna 188CESSNA · Desoto, TX(-23) Aircraft experienced partial power loss, engine ran rough, aircraft was unable to hold altitude. Aircraft made precautionary landing in vacant field. Upon inspection by mechanic, it was determined the mixture control cable was not properly secured to…Apr 10, 2006 · N9889VIncident 20060410010339ICessna R182 · Milwaukee, WI(-23) Pilot was having trouble with his GPS and was adjusting it while landing. During this time the landing gear warning sounded but the pilot failed to identify it as such. The first indication that he recognized as a problem was when he heard the propeller…Apr 10, 2006 · N9827C · Minor damageIncident 20060410009829IGulstm 500S · Peoria, IL(-23) [privacy data omitted] aircraft was enroute to Peoria, IL (pia) for an annual inspection. R/h engine failed in flight. Pilot landed at pia without incident. Misc data: engine tt 1583 TSO s/n L-805848 last annual performed by byerly aviation on 05/05/05.…Apr 10, 2006 · N90JPAccident 20060410007079AAmtr RV9A · Venice, FL(-23) RV-7A aircraft was landing to runway 4 at Venice Municipal Airport when he experienced a nosewheel first landing. This landing resulted in benging the nosewheel strut and causing damage to the engine firewall. Aircraft was towed off the runway to triple…Apr 10, 2006 · N339DL · Substantial damageAccident 20060409014009APiper PA28181 · Logansport, IN(-23) Pilot was practicing touch and go landings, aircraft bounced, pilot lost control of aircraft, prop struck runway, engine mount broke at landing gear attachment point and bent firewall. Nose landing gear bent backward and caused a hole in belly.Apr 9, 2006 · N793MA · Substantial damageIncident 20060409012809IAirbus A319131 · Washington, DC(-23) Ual flight 221 departed gate at 14:40 for runway 30 departure. On take off roll at approximately 40 knots with engines at full t/o crew received icas message left engine fail with a large compressor stall and the aircraft veered to the left. Crew…Apr 9, 2006 · N802UAAccident 20060409012269APiper PA28RT201 · Philadelphia, PA(-23) Upon takeoff & landing gear retraction a loud noise was heard with a severe vibration. Land gear was re-cycled but the vibration remained. Aircraft lost engine power & air speed. Pilot elected to land on grassy part of the runway safety zone & performed…Apr 9, 2006 · N901AV · Substantial damageIncident 20060409011199IAviat A1B · Wakefield, NH(-23) The pilot [privacy data omitted] pilot in command of Aviat N153EL, landed in a friends hay field. The purpose of the landing was to visit the owner of the field. Upon landing, the pilot [privacy data omitted] explained that the tail of the aircraft…Apr 9, 2006 · N153ELIncident 20060409008999ICessna 320C · Bismarck, ND(-23) The owner/pilot reported that after departing Bismarck, ND on a VFR flight with himself and 4 passengers onboard he experienced an electrical system failure. On returning to the airport the electrical system momentarily began functioning. At this point…Apr 9, 2006 · N3026T · Minor damageIncident 20060409008799ICndair CL6002B19 · Springfield, IL(-23) [privacy data omitted] cgkej, operated by air Canada as call sign, jazz 8021, a CJ2 aircraft, was enroute from Kansas city international to toronto, Canada when the flight crew reported an asymmetric flap control problem the flight crew elected to…Apr 9, 2006Accident 20060409005179ACessna 150J · Sandstone, MN(-23) Pilot [privacy data omitted] departed hawk aviation in rush city MN in a Cessna 150 (N50970) at approximately 2100 on 04/10. There were no employees at the facility at the time. The pilot [privacy data omitted] ^ accessed the rental aircraft without the…Apr 9, 2006 · N50970 · Substantial damageIncident 20060409004559IAmrgen AA5 · Imperial Beach, CA(-23) During the pilot's prelight, he discovered debris inside of the engine cowling consistent with what you might see when a bird is building a nest. He stated that he removed the material before departing. At about 2500 feet, he initiated a descent and…Apr 9, 2006 · N5477LIncident 20060409004469IDiamon DA20C1 · Baltimore, MD(-23) Pilots shoe lace became stuck between two pieces of plastic under the panel. This reduced the pilots ability to depress the brake completely. Pilot reduced the power but the right wing struck the rudder of N227NH.Apr 9, 2006 · N956CT · Minor damageAccident 20060409003809ACessna 172S · Denton, TX(-23) On April 9, 2006, a Cessna 172S, N358TW, sustained substantial damage during takeoff roll at Denton Municipal Airport (dto), Denton, TX. The aircraft was piloted by [privacy data omitted] student pilot [privacy data omitted] who was conducting his first…Apr 9, 2006 · N358TW · Substantial damageAccident 20060408018889APiper PA28181 · Coalinga, CA(-23) The aircraft was landing at Harris Ranch Airport when the pilot reported a cross wind as he touched down. The nose landing gear collapsed and bent aft causing damage to the firewall and lower fuselage just aft of the firewall. The pilot lost directional…Apr 8, 2006 · N8068J · Substantial damageIncident 20060408009709IPiper PA24250 · Jackson, MI(-23) After landing, aircraft veered left and struck a sign which damaged the left flap.Apr 8, 2006 · N8347P · Minor damageIncident 20060408008829ICessna 310I · Troy, MI(-23) Flaps were inoperative. Pilot started the before landing checklist, was distracted by getting set up for a no flaps landing, and failed to resume the checklist. In ground effect the pilot pulled the throttles to idle ( no warning horn due to inoperative…Apr 8, 2006 · N1011S · Minor damageAccident 20060408005169ACessna 195 · Pinecreek, MN(-23) [privacy data omitted] the pilot [privacy data omitted] accepted delivery of N3456V in owatonna MN from owner [privacy data omitted] the afternoon of 4/8/06. Prior to the export flight to Canada N3456V received canadian registration markings c-gemo.…Apr 8, 2006 · N3456V · Substantial damageIncident 20060408004679ICndair F86EMK5 · Montgomery, AL(-23) Right mainmount failed to extend. Emergency extension procedure also failed due to jammed gear door uplock. Emergency landing accomplished on left mainmount and nose gear with minor damage to right external fuel cell, wingtip, and flap assemblies.Apr 8, 2006 · N86FS · Minor damageIncident 20060408004619IMooney M20C · Duncan, OK(-23) On April 08, 2006, at approximately 1800 CDT, an M-20 had the gear collapse on landing on runway 35 at Duncan (kduc), OK. The pilot (student) was receiving instruction for commercial certificate when this event occurred. The instructor had given engine…Apr 8, 2006 · N6530U · Minor damageAccident 20060408003729ARobsin R22BETA · Tooele, UT(-23) Aircraft was being used for flight training under part 61. Student pilot also is a private pilot with instrument rating in fixed wing aircraft. Aircraft was under the control of the instructor pilot departing upwind to the southwest from Tooele valley…Apr 8, 2006 · N921U · Substantial damageAccident 20060407011989ACubcft CC18180 · Tallahassee, FL(-23) On April 7, 2006 at 1700 hours easter daylight time, a cub crafter CC-18-180 airplane, N577CC, registered to and operated by the university of north dakota under part 91, ground looped upon landing at Tallahassee, Florida. Visual meteorological…Apr 7, 2006 · N577CC · Substantial damageIncident 20060407009779IDoug DC931 · Detroit, MI(-23) Aircraft was parked at gate in a designated parking area. The gate was located adjacent to an active service drive. Passengers were in the process of boarding the aircraft. An airport employee shuttle bus struck the left removable wingtip of the…Apr 7, 2006 · N8944E · Minor damageAccident 20060407009449AAmtr Ctsw · Shelbyville, TN(-23) Aircraft took off from marco island, Florida, on 04-07-06 at 0715 CDT and ran out of fuel at Shelbyville, TN (syi) at 1230 CDT. Aircraft landed hard approximately 1000 feet short of runway 18. Aircraft sustained major damage to firewall, engine mount…Apr 7, 2006 · N122JV · Substantial damageAccident 20060407008089AAmtr Turbinlegend · Hammond, LA(-23) Following failed inflight attempt to extend the nose landing gear, the pilot set up for a nose gear retracted landing. During final approach, the engine experienced a sudden loss of power. The aircraft impacted the ground 750 yards short of the runway,…Apr 7, 2006 · N724TL · Substantial damageIncident 20060407007539IBeech B60 · Shreveport, LA(-23) Aircraft was being ferried from paint shop at redbird airport (krbd) to the Shreveport downtown airport (kdtn) for an annual inspection. On arrival, pilot had indication that landing gear was not fully extended. After multiple attempts to remedy the…Apr 7, 2006 · N1WA · Minor damageAccident 20060407006929ACirrus SR20 · Kerrville, TX(-23) The pilot departed glendale municipal airport (kgeu), near phoenix, Arizona on a cross country flight to the houston, Texas area. At approximately 1320 CDT, a fuel stop was made at the Kerrville, Texas airport. At approximately 1410 CDT, the flight…Apr 7, 2006 · N142SF · Minor damageAccident 20060407006889ACessna 172M · Vero Beach, FL(-23) On April 6, 2006, at approximately 1910 EDT, a Cessna 172, N64425, piloted by [privacy data omitted] departed the left side of the runway while landing in a crosswind on runway 11R at Vero Beach, Florida. The airplane travelled approximately 275 feet in…Apr 7, 2006 · N64425 · Substantial damageIncident 20060407006629IDoug MD9030 · Boise, ID(-23) Delta flight 1234, enroute from slc to sea diverted to Boise. Pilot noted a vibration while at FL320. He checked the engine instruments and saw the left engine epr had rolled back and EGT was flashing approximately 634 degrees. He retarded the throttle…Apr 7, 2006 · N915DNAccident 20060407006529ACessna 170A · Lakeland, FL(-23) Aircraft ground looped upon landing at lal, sun-n-fun. No injuries. Mechanical brake failure possible, unable to be determined. [privacy data omitted] Wx, METAR klal 071346Z 19008KT 10SM BKN250 22/19 A3001Apr 7, 2006 · N9291A · Substantial damageAccident 20060407004899ACessna 177B · Blackburn, MO(-23) Witnesses reported aircraft maneuvering at low altitude prior to impact with electrical line (approximately 50 feet AGL).Apr 7, 2006 · N34200 · Destroyed · 1 fatalAccident 20060407004759APiper PA28140 · Lakeview, AR(-23) April O7, 2006, N4316T a Piper PA-28-140, crashed just off the end of the runway at gaston's resort at Lakeview, AR. Visual meteorological conditions prevailed and no flight plan had been filed. Pilot was airlifted to st. john's hospital in Missouri and…Apr 7, 2006 · N4316T · Substantial damageAccident 20060407004449ABell 206B · Sprague, WA(-23) The pilot [privacy data omitted] was flying with two Washington state fish and wildlife people bagging and tagging mule deer in the draws due east of Sprague Washington. He flew around the end of a butte westward in a 50 foot deep draw, a mule deer was…Apr 7, 2006 · N96NW · DestroyedIncident 20060407004199IMaule M7235C · Fort Worth, TX(-23) On April 7, 2006, a Maule-7, N4280B, registered [privacy data omitted] was involved in an incident at Fort Worth Spinks Airport. The aircraft was operated by the pilot [privacy data omitted] after touchdown on runway 35, the pilot experienced a gust of…Apr 7, 2006 · N4280B · Minor damageAccident 20060407003869APiper PA30 · Chesapeake, VA(-23) The pilot was dealing with a compound emergency. His left engine was not producing power and the landing gear was not indicating down. The pilot elected to perform a single engine go-around at pvg. During maneuvering, he attempted to troubleshoot the…Apr 7, 2006 · N7812Y · DestroyedIncident 20060406016679IMooney M20E · Leonardtown, MD(-23) Pilot did not lower landing gear, made belly landing, damaged propeller and fuselage.Apr 6, 2006 · N3263F · Substantial damageAccident 20060406011969ACessna 172P · Cambridge, MD(-23) A student pilot was on his first solo cross country to cge, he landed on rwy 34. After making a hard landing, the aircraft ran off the runway. The student pilot stated there was a cross wind. The aircraft sustained substantial damage to the firewall and…Apr 6, 2006 · N54928 · Substantial damageIncident 20060406007609IAmtr Glasairiii · Mesa, AZ(-23) The pilot had just taken delivery of N251WH and was making a normal landing at ffz when, at the point of touchdown, the aircraft appeared to settle lower than usual. The pilot immediately applied full power and went around the pattern again. After…Apr 6, 2006 · N251WH · Minor damageAccident 20060406006479ACessna 310N · Lincoln, CA(-23) Nose gear collapsed on landing. Witnesses said nose gear was resting in wheel well at a 45 degree angle. Unable to contact pilot. No injuries. Aircraft has substantial damage to nose gear compartment, fuselage skin was ground down into pitot tube area.…Apr 6, 2006 · N5096Q · Substantial damageAccident 20060406006449AAmtr LANCAIR320 · Mulberry, FL(-23) Pilot made hard, short landing. Left main gear broke off, aircraft skidded off the left side of runway, through ditch, and into road. Nose gear and right main broke off during skid, tail broke off just forward of horizontal tail, push pull tube for…Apr 6, 2006 · N200JW · Substantial damageAccident 20060406006229ACessna 172K · Wickenburg, AZ(-23) The airplane veered off the runway during the landing roll. The student pilot decided to perform touch-and-go practice takeoff and landings after arriving at his destination airport. On the third landing the main landing gear touched down first with the…Apr 6, 2006 · N84034 · Substantial damageAccident 20060406006009ASlinds 100ACMDR · Englewood, FL(-23) On April 6, 2006, at 0815 EST, an aero commander 100, N3602X, operating on a personal flight, aborted take off (due to low airspeed indication) and veered off runway 120 into a 15 foot ditch that was parallel to runway at Buchan Airport, Englewood,…Apr 6, 2006 · N3602X · Substantial damageIncident 20060406005259ICessna 310Q · Phoenix, AZ(-23) The pilot [privacy data omitted] was giving a SIC flt check to a new hire for air west, inc. they had done several take off and landings and this was to be the last one and it was to be a touch and go and return to falcon field (ffz). The SIC [privacy…Apr 6, 2006 · N7793Q · Minor damageAccident 20060406004839ASnias AS350BA · Haines, AK(-23) On 4/06/2006, approx 1550 adt, a Eurocopter AS-350-BA helicopter, N209CH, sustained substantial damage when, while in hovering flight, its main rotor blades struck the top of a small tree during landing on talsani island, Alaska. The coastal helicopters…Apr 6, 2006 · N209CH · Substantial damageIncident 20060405010219IBell TR918 · Wrangler Field, TX(-23) On April 5, 2006, approximately 8:30 a.m. at Wrangler Field (an abandoned flight training airport 70 miles west of forth worth, Texas), Bell's TR918 risk reduction prototype (rrp) technology demonstrator, was performing a deceleration maneuver at 300'…Apr 5, 2006 · N5916A · Substantial damageIncident 20060405009359ICessna T210M · Monee, IL(-23) Approximately 20 minutes into flight, N732XD a Cessna model CE-210-T210, observed smoke in the cockpit and a reduction of engine oil pressure. Pilot landed at Monee-Sanger Airport (C56). Aircraft went off the end of the runway collapsing left main…Apr 5, 2006 · N732XD · Minor damageIncident 20060405009159INamer AT6D · Lakeland, FL(-23) The aircraft landed and was being marshalled by ground crew. The ground crew allowed the pilot to taxi his aircraft into a ground cart.Apr 5, 2006 · N29941 · Minor damageAccident 20060405008369APiper PA18150 · Hollandale, MS(-23) Pilot lost control while maneuvering and crashed into a rice field. The accident site was approximately one mile southeast of the longwood flying services air strip in Hollandale Mississippi.Apr 5, 2006 · N3887P · Destroyed · 2 fatalAccident 20060405005989AAyres S2RT34NORMAL · Folkston, GA(-23) On April 5, 2006 at 1823, acft N3096H, model Ayres-thrush, aircraft was involved in an accident shortly after takeoff. At 100 feet the aircraft experiened a loss of power, with the engine shutting down. Pilot observed black smoke and white sparks coming…Apr 5, 2006 · N3096H · Substantial damage