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 20090619008269IMichel Bearhawk · Dixie, ID(-23) The pilot indicated that upon attempted landing he bounced the aircraft and tried to go around. Upon applying full power, he realized that he wouldn't be able to make the go-around so he pulled power off and attempted second landing. Aircraft landed…Incident 20090618025219IPiper PA-44-180 · Sanford, FLOn the takeoff roll of a multiengine instructional flight, the flight instructor simulated a failure of the left engine by cutting the left mixture. The student did not react quickly enough to close the throttles, and the flight instructor failed to intervene…Incident 20090618019359IConvai 640440D · St Johns, ACOn 06/18/2009 at 1830 EST, while taxiing out to runway 10 in Antigua (tapa), the right engine was reported smoking. The right engine was shutdown, feathered and the "t" habdle was pulled. The propeller moved from fine pitch position, causing the engine to…Accident 20090618012549APiper PA18150 · Dixie, ID(-23) Landed long and applied brakes too hard. Aircraft equipped with tundra tires and good brakes. Aircraft flipped on its back due to hard breaking.Accident 20090618011689AAmtr Titantornado · Chadbourn, NC(-23) Pilot taxied aircraft to end of runway and performed an engine run up inspection. Engine sound seemed normal. Aircraft proceeded to takeoff. At about the time the aircraft reached the end of the runway, the engine seemed to lose power. The engine then…Incident 20090618011169ILear 45LEAR · Fort Worth, TX(-23) This Lear jet (LR-45) was being operated by a & p mechanics employed by turbine engine specialists (TEHR262X) for the purpose to taxi out for an engine test run on the #1 (left engine). During taxi it was necessary to stop the aircraft for motor vehicle…Accident 20090618010749AScwzer G164A · Yerington, NV(-23) Aircraft lost altitude and contacted the ground during turn around maneuver while engaged in aerial application.Incident 20090618009759IPiper PA44180 · Ellensburg, WA(-23) During a training flight with a student, instructor simulated failure of both engines in the pattern, instructing the student to accomplish an all engine out landing. This maneuver had not been briefed beforehand, and the student's response was slow,…Accident 20090618009329ACessna 152 · Fort Collins/L, CO(-23) The pilot started the aircraft to go on a local flight to retain currency. He performed a cold start by excersizing the throttle several times to prime the engine. The engine backfired once it started and immediately went to full power and the aircraft…Accident 20090618009079ACessna R182 · Dougherty, TX(-23) On June 18, 2009, at approximately 2145 CDT, the flight crew of N182GT encountered severe blowing dust due to a storm front passing through the area. The national weather service was reporting a haboob in the area in the at 2130 CDT. The aircraft…Accident 20090618009069ABlanca 1731ATC · Roosevelt, UT(-23) Post maintenance operational check flight. After landing at Roosevelt, UT. (74V) during rollout about 1000 feet left main landing gear collapsed. Green light went out, red warning light came on, left wing dipped and hit the ground aircraft veered to…Accident 20090618008929ASimmon VANSRV8A · Cameron Park, CA(-23) The pilot reported that at the time of the accident he and a passenger were practicing landing at the Cameron Park airpark (O61). Some of the landings were touch and go and some were to a full stop. During the accident landing on runway 13, the pilot…Incident 20090618008299IAirbus A320232 · Boston, MA(-23) A vehicle deviation/runway incursion occurred at Boston ma when a construction vehicle crossed runway 15R at taxiway m without authorization at 0636 EDT, on 6/18/09. A usaa A320, flight 27 was departing on runway 15R at the time. Closest proximity was…Incident 20090618008289IAmtr Searey · Klamath Falls, OR(-23) On June 18, 2009 [privacy data omitted] took off from Klamath Falls Airport. After takeoff a gust of wind lifted the right wing and the aircraft veered to the left. The aircraft lost airspeed and it descended to the ground at a reported 1000 feet per…Incident 20090617047369IMooney M20C · Dillion, SC[privacy data omitted]Incident 20090617019319IAeronc 7AC · Greenfield, IN[privacy data omitted] Was transporting N1049W from pope field in Greenfield, IN to sheridan aviation at 5I4, sheridan, IN for a summer service call. About 15 to 17 minutes into the flight and at 3000 feet, the engine started to lose power. Carburetor heat…Accident 20090617009969ACessna 150L · Rockwall, TXOn June 16, 2009, approximately 2015 central daylight time, a Cessna 150L, N66016, piloted by a commercial pilot, was destroyed when it impacted terrain at the Phillips Flying Ranch Airport, terrell, Texas. Visual meteorological conditions prevailed at the…Accident 20090617009249ADornie Alphajet · Arlington, WA(-23) The pilot stated that he had made three transmission of his position and intent and had heard no response. The pilot stated that when he was approaching the abeam position on right downwind to runway 16 he saw a light aircraft approximately one third of…Accident 20090616047359ACessna 207 · Crooked Creek, AK[privacy data omitted] Departed aniak, AK on the morning of June 16,2009 with two passengers and flew to sleetmute,AK. They departed sleetmute around 3:30 local time and flew to Crooked Creek, AK. Upon arrival to the Crooked Creek Airport there was a rain…Accident 20090616018739ACirrus SR22 · Minneapolis, MNN214BN crashed at Crystal Airport (mic) at 2205PM on 06/16/2009. Pilot received fata received fatal injuries and aircraft was destroyed. All maintenance logs and pilot logbooks were destroyed in the fire and are unavailable for data. Last record of aircraft…Accident 20090616010769ASabre 2PL · Harrison, NE(-23) The sport pilot was performing a takeoff from a private grass strip for his first solo flight in a weight-shift airplane. Shortly after takeoff, the airplane entered an uncommanded left bank, descended, and impacted the terrain. The pilot stated that…Incident 20090615022719ICessna 172R · Bowling Green, OHInspection by maintenance of low nose landing gear tire led to the discovery of minor firewall damage. Subsequent investigation by this office and university flight department were unable to determine the time, location or pilots responsible for the damage.Accident 20090615012469ACessna U206F · Islesboro, MEAircraft lost power takeoff landed in trees at end of airport. The pilot head fueled and sumped the aircraft prior to flight. Water was found and drains were sumped until clear fuel. Post accident found water and other brown sludge in header tank in pod.…Accident 20090615012429ADreyer Stardustersa · Wales, NY(-23) On June 15, 2009 at approximately 1610 EDT local time, an experimental amateur-built starduster SA-300 aircraft, s/n 1145, bearing reegistration number N3DL, registered to promise recording inc., piloted by Mr. Roy berube, sustained substantial damage…Incident 20090615010059ICessna 172S · Denver, CO(-23) Pilot decided to roll out long due to long/fast landing and hot grabbing brakes. Hit runway end light with main gear leg. No serious damage, dented gear leg fairing only. This inspector talked to owner operator [privacy data omitted] on damage, was…Incident 20090615009989IPiper PA28R200 · Payson, AZ(-23) Pilot was distracted during the landing phase of flight and neglected to put the gear down prior to landing. Minor damage to the aircraft resulted.Incident 20090614047489IPiper PA-32-260 · Naples, FLOn June 14, 2009 [privacy data omitted] made a return night flight from (kmth) marathon, Florida to (kapf), Naples, Florida where the aircraft is based. He landed on runway 32 at approxiomatly 9:30 pm. His taxi instructions were right turn onto runway 5, exit…Accident 20090614047259ACessna 180F · King Salmon, AKAirman stated that on landing at the King Salmon Airport with a slight crosswind that he lost control of his airplane and it spun around (ground looped) on him.Accident 20090614016819AGrob G103CTWINIII · Gregory, MIGround launch tow cable broke on lauch/takeoff. Aircraft did not achieve sufficient altitude to continue normal flight. Pilot initiated a 180 degree turn to land on airport property. Witness accounts and crash scene evidence support stall/spin scenario. Post…Accident 20090614012459APiper PA28R180 · Scotia, NY(-23) On June 14, 2009 at approximately 14:21 hours EDT, N3226R, a Piper PA28R-180 attempted takeoff on runway 33 at the Mohawk Valley Airport (K13) in Scotia, NY. The pilot of the aircraft failed to attain adequate flying speed during the takeoff. After…Accident 20090614011219AAviat A1A · Garrison, MN(-23) Pilot was attempting to land on camp lake to the south. He chose a very narrow part of the lake to land. He bounced the landing and aircraft turned 45 degrees to the left while airbourne. He applied full power, but realized he was facing the bank with…Accident 20090614009019AAmtr Glastar · Wenatchee, WAPilot was giving his nephew a local sight-seeing flight and during the landing the pilot stated that he had a quartering tailwind and stalled the airplane on base leg turning final collapsing the landing gear.Accident 20090614008989AAirtrc AT602 · Magee, MS(-23) On takeoff from Magee, MS (17M) on runway 18 the aircraft's engine stop producing power causing the aircraft to stall and crashed land at the end of the runway.Accident 20090614008579APiper PA18150 · Cottonwood, ID(-23) Pilot on final approach to Salmon Bar Airport. On final approach to runway 15 pilot made a slight right turn to align aircraft to runway and struck a tree with the right wing. The aircraft impacted the ground and the left main landing gear dug into the…Accident 20090614007719AAirbau XT912 · Alamogordo, NM(-23) On June 14, 2009, at 1200 MST, and airborne XT-912, N595VZ, registered to [privacy data omitted], ran off runway 30 at Alamogordo-White Sands Regional Airport while on a pleasure flight. Visual meterological conditions prevailed at the time of the…Accident 20090613054199AArostr RX9 · Wausau, WIThe balloon took off in 6 knot winds. Within a few minutes the pilot noticed groundspeed increasing to over 35 knots. The envelope started collapsing forcing the pilot to attmept an emergency landing. Pilot pulled rip cord at 50 feet to quickly release the…Accident 20090613047279ASchweizer 269C-1 · Titusville, FLPilot was on a solo instructional flight practicing for a commercial flight check. During hovering manuvering the pilot allowed the aircraft to settle and the right skid came in contact with the ground and rolled over.Accident 20090613025209ABeech F33A · Rock Hill, SCDuring landing phase of flight: on rollout on runway 2, about 1400 feet past the numbers at taxiway g, the gear extension alarm activated and within 2-4 seconds the nose gear collapsed, with the right main gear to follow and then the left main gear. The…Accident 20090613014659AAmtr Longez · Placerville, CA(-23) Enroute from the marysville airport, CA and subsequent landing at Placerville Airport, CA. Onto runway 23 the left brake failed. The airplane veered of the runway crossed over the parallel taxiway next into a ramp tie-down area. Then the airplane…Incident 20090613010199IMooney M20M · Imperial, NE(-23) At a crusing altitude of 21,000 feet MSL the engine quit. The pilot declared an emergency and was vectored to Imperial, Nebraska by denver ATC. Descending through 8,000 MSL the engine regained partial power and an uneventful landing was completed. It…Accident 20090613009959ADiamon DA40 · West Chester, PA(-23) CFI william king stated aircraft N659PS landing on runway 09 at brandwine airport, PA landed hard and bounced several feet in the air. Full power was delayed by student pilot after CFI announced full power. Aircraft drifted to left of runway in a…Accident 20090613009819ACessna 177RG · Laconia, NH(-23) Upon inspection of the aircraft engine, a small amount of oil was found in the case. Inspection of the aircraft found oil on the right lower side of the aircraft that came from the area of the right cowl flap. Oil as found on the runup area of the ramp…Incident 20090613009469IAmtr Murphyrebel · Laurel, MT(-23) On June 13, 2009 at 1635 local time, a murphy rebel homebuilt aircraft, N117MR was flying from libby, MT (S59), to Laurel, MT (6S8). On arrival at Laurel the aircraft ground looped and departed runway 22 to the right and damaged the propeller and…Incident 20090613009449ICessna 172 · Perkasie, PA(-23) Operated under 14 CFR part 91 pilot states he aborted take-off and could not get aircraft stopped. He was departing kckz on runway 2.6, aircraft came to rest off the approach end of runway.Accident 20090613009089ACessna 150H · Lawrenceville, VA(-23) The student pilot experienced a power loss and engine shutdown at approximately 400 feet AGL. He elected to glide to a dirt road next to a lumber yard. During landing, the aircraft wings struck a utility light pole causing substantial damage.Accident 20090613008749ADhav DHC6TWINOTTE · Orange, VA(-23) The jump aircraft pilot conducted a low pass over the parachute drop zone while a parachutist was still airborne. The aircraft flew through the drop zone, impacting the parachute canopy with the left engine, shredding the canopy. The parachutist fell…Incident 20090613008669IPiper PA32300 · Berlin, NJ(-23) Pilot states that while landing, leading edge of thunderstorm was seen approaching field. Runway was wet from previous rain however it was not currently raining. The aircraft floated 1/4 to 1/3 down runway before settling. Pilot further states that he…Incident 20090613008469IPiper PA16 · Batavia, OH(-23) On landing roll out, pilot taped his brakes to slow down. The right brake grabbed harder than the left brake causing the aircraft to swerve to the right. The aircraft departed the runway into the grass, coming to rest in a drainage ditch. The right gear…Accident 20090612053889APiper PA-36-285 · Clark, SD6/12/2009 Pilot [privacy data omitted] flew N57625 under [privacy data omitted] part 137 certificate O2HG performing agriculture spray operations. He departed 8D7 airport around 1015 CDT with 120 gallons of chemical. During spray operations he was distracted…Incident 20090612047329ICessna 172K · Talachulitna, AKWhile enroute to cabin at 150'AGL over beluga mountains, engine started running very rough and lost power. Was able to establish glide and make precautionary landing at Talachulitna lodge landing strip (pvt). There was no damage to the aircraft nor injury to…