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.

Incident 20020704016399IPiper PA24 · Ft Worth, TX(-23) On July 4, 2002, at 1534 hours a Piper PA-24 aircraft owned by Mr. David l. jackson landed with the landing gear partially extended at Fort Worth Alliance Airport. Visual flight conditions prevailed and no flight plan was filed. The aircraft received…Jul 4, 2002 · N400BK · Minor damageAccident 20020704015809APiper PA28161 · Providence, RI(-23) While attempting to land rwy 23 7/4/02 at 08:05, a/c bounced twice and veered off the rwy to the left striking two road signs and coming to a rest on taxiway b, 500 feet from rwy 23.Jul 4, 2002 · N8081G · No damageAccident 20020704015739AAmtr Pulsarxp · Prineville, OR(-23) On July 4, 2002, around 0845, N777XP veered off the left side of runway 28 during landing at Prineville, OR. The aircraft went into some soft dirt collapsing it's landing gear and damaging the propeller. Mr. Welborn, pilot-in-command, said he was on his…Jul 4, 2002 · N777XP · No damageIncident 20020704015609IAirtrc AT301 · Idahofalls, ID(-23) Pilot was conducting spray operations flying under powerlines. Pilot forgot about the existance of this particular set of lines. Flew under them and misjudged his height contacting the wire strike protection bar on the canopy with the wire. The wire ran…Jul 4, 2002 · N3165A · Minor damageAccident 20020704015349ACessna 335 · Tensed, ID(-23) I assisted NTSB investigator deddie eckrote of the seattle NTSB office. The aircraft departed pullman, WA enroute to sandpoint, ID, a distance of 110 statue miles. The on scene investigation revealed the aircraft impacted the ground in an uncontrolled,…Jul 4, 2002 · N27069 · No damage · 2 fatalIncident 20020703027459IRaythn 390 · Wichita, KS(-23) Ten minutes into flight after leaving pueblo, CO. The r/h low fuel press light illuminated. The r/h fuel quantity indicator indicated 200# less fuel than the left. Engine indications were normal. Pilot in command elected to shut down the r/h engine and…Jul 3, 2002 · N460ASAccident 20020703025669AGulstm 112TC · Stuart, FL(.4) The pilot stated that he had 55 gallons of fuel on the airplane, when he departed spruce creek airport. He said he determined the fuel quantity based on the fuel level with respect to the metal tab in the tank, and that he flew the airplane to daytona…Jul 3, 2002 · N4561W · DestroyedIncident 20020703020569ICessna 180A · Duluth, MN(-23) While water-taxiing to launch area after landing, LH float began to taking on water. Pilot shut down aircraft. Pilot and passenger evacuated aircraft as aircraft rolled left and sunk in approx. 12-15 feet of water on fish lake. No injuries were incurred…Jul 3, 2002 · N180GP · Minor damageAccident 20020703019889AAmtr Kitfox · Edenton, NC(-23) An amateur-built Kitfox-outback departed a private airstrip near Edenton, NC under visual meteorological conditions (VFR) on a local flight on July 3, 2002 at approximately 1600 hours EDT. The two occupants on board the aircraft were the owner/pilot and…Jul 3, 2002 · N74PT · No damage · 2 fatalIncident 20020703019359IUrocop EC155B · Washington, DC(-23) Upon approaching the landing site pilot requested the landing checklist. The co-pilot notified the pilot that there was no indication of gear "in-transit" or gear down lights. The gear level was recycled but still no indication. Pilot requested the…Jul 3, 2002 · N604FD · Minor damageIncident 20020703016079ICessna T210G · Torrance, CA(-23) Pilot was planning to land at ksna to pick up a passenger when the landing gear failed to extend normally. Pilot aborted the landing and circled for more than an hour in the vicinity of the Torrance airport while he attempted to extend the gear both…Jul 3, 2002 · N6872R · Minor damageAccident 20020703015199AScwzer G164B · Shelley, ID(.19) On July 3, 2002, approximately 2030 mountain daylight time, a Grumman G-164B "agcat," N297AL, registered to nef flying service, inc., and being flown by a commercial pilot, was destroyed during a forced landing following a loss of power during a spray…Jul 3, 2002 · N297AL · Substantial damageAccident 20020703013779AAmtr Kitfoxiv · Sprakers, NY(-23) Non certificated, inexperienced pilot flying non certificated, unregistered Kitfox iv aircraft lost control while attempting to go around from a balked landing attempt. Aircraft stall/spun from an altitude of about 400' AGL and impacted the ground…Jul 3, 2002 · No damage · 1 fatalAccident 20020702038409APiper J3C65 · Sparta, IL(-23) During the landing rollout the pilot in command lost directional control, the aircraft departed the runway encountering a culvert, which flipped the aircraft onto it's back. The aircraft received substantial damage to the right wing, propeller main…Jul 2, 2002 · N7744B · Substantial damageIncident 20020702027359IBoeing 7373S3 · Omaha, NE(-23) Male passenger admitted to smoking in the aft lavatory during a flight from phoenix, Arizona to Omaha, Nebraska.Jul 2, 2002 · N312AWIncident 20020702020369ICessna 182P · Jacksonville, FL(-23) PIC stated the aircraft porpoised after touchdown landing hard on nose gear. FAA inspection found minor damage to nose wheel and prop.Jul 2, 2002 · N79598 · Minor damageAccident 20020702019859AAmtr Varieze · Covington, TN(-23) Statement of interview with ian stone: 07/02/2002 15:30 local Covington, TN airport; inspectors steve brown and ken pannell; Mr. Stone informed us that he had just bought an experimental aircraft N57EZ and had come to Covington to pick it up and fly it…Jul 2, 2002 · N57EZ · No damageAccident 20020702019749AMooney M20R · Mt Pleasant, SC(-23) The pilot stated that the aircraft porpoised during landing. He attempted to go-around, lost control, and impacted the ground. (.19) on July 2, 2002, about 1430, eastern daylight time, a Mooney M20R, N2043N, registered to and operated by a private…Jul 2, 2002 · N2043N · No damageIncident 20020702019609IPiper PA32RT300T · Corinth, MS(-23) 30 Miles sse of Corinth (crx) electrical problems found, shut down most systems, but all power failed, pilot reported that he tried to lower gear at crx using emergency procedures, gear failed to extend. Landed on crx taxiway gear up. Maintenance…Jul 2, 2002 · N39654 · Minor damageIncident 20020702019429IBoeing 777222 · Seattle, WA(-23) On July 2, 2002 at 0830 PDT united 876 morioka, japan-sea, landed without incident. After taxiing to gate S-10, the ground crew called fire equipment due to a brake fire. One of the ground crew attempted to put the fire out with an extinguisher before…Jul 2, 2002 · N795UA · Minor damageAccident 20020702018509ACessna 182E · Sweetgrass, MT(-23) Pilot stated to NTSB that directional control was lost during a crosswind landing in gusty wind conditions.Jul 2, 2002 · N3387Y · Substantial damageAccident 20020702017499ACessna 182A · Siler City, NC(-23) On July 2, 2002, about 0200, eastern daylight time (EDT), a Cessna CE-182-A, N9996B, piloted by james william cockrell, private pilot certificate number 224332379, operating as a title 14 CFR part 91 ferry flight, made a forced landing one mile south of…Jul 2, 2002 · N9996B · No damageAccident 20020702016729APiper PA18125 · Talkeetna, AK(-23) On July 2, 2002, a float equipped Piper PA-18-125, aircraft N1129A, registered to and piloted by william j. fitzgerald was involved in an aircraft near sheep river, Alaska. According to the pilot he and his observer, seth cameron, were looking for an…Jul 2, 2002 · N1129A · No damageIncident 20020702016329IEMB EMB145ER · Pittsburgh, PA(-23) On July 2, 2002 trans states flight #5311 returned to pit due to lav smoke icas message. The aircraft landed on runway 28R ARFF responded and the aircraft taxied to the gate without further incident. It was discovered that the APU had an oil leak which…Jul 2, 2002 · N808HKAccident 20020702016239ATcraft F19 · Heron, MT(-23) Aircraft clipped trees on approach to private airstrip, Heron, MT. Aircraft flipped on to nose and somewhat inverted. No injuries.Jul 2, 2002 · N37YD · No damageAccident 20020702015509APiper PA28RT201 · Lebanon, TN(.19) On July 2, 2002, at 1500 central daylight time, a Piper PA-28RT-201, N8143B , registered to airhead LLC and operated by air tech, collided with a power line and terrain during initial climb after takeoff from Lebanon Municipal Airport in Lebanon,…Jul 2, 2002 · N8143B · Destroyed · 2 fatalAccident 20020702013979ARobsin R22BETA · Chatsworth, CA(.19) On July 02, 2002, at 1445 pacific daylight time, a Robinson R22 beta helicopter, N4072T, was substantially damaged following a loss of control during a precautionary landing near Chatsworth, California. The private pilot sustained minor injuries and his…Jul 2, 2002 · N4072T · Substantial damageAccident 20020702013659ADoug MD88 · Houston, TX(.19) On July 02, 2002, at 0922 central daylight time, a Mcdonnell Douglas MD-88 transport category airplane, N911DL, operating as delta flight 239, was substantially damaged when the left wing of the airplane collided with parked construction trucks while…Jul 2, 2002 · N911DL · Substantial damageAccident 20020701032669APiper PA18A150 · Belmar/Farmingd, NJ(-23) At 1115, 7/1/02 N2414P, struck a wingtip ot the runway while attempting to depart runway 32R, cart wheeled, crashed and burned. Sole occupant on board was fatally injured and aircraft was destroyed.Jul 1, 2002 · N2414P · Destroyed · 1 fatalIncident 20020701029489IRobsin R22BETA · Plymouth, MN(-23) Airman made a normal approach to his helipad, which is located on the shore of a lake, at his personal residence. After the approach, the airman began to hover taxi his helicopter towards the hospital, with a 10-knot tailwind at 4-5 feet above the…Jul 1, 2002 · N27AT · Minor damageIncident 20020701023729IPiper J3C65 · Hastings, FL(-23) Mr. Johnson, who was the PIC and only person onboard, was attempting to take off from an unimproved area--a dirt road. On lift off the aircraft drifted to the right and struck some small pine trees at about five feet above ground level. The pine trees…Jul 1, 2002 · N2023M · Minor damageAccident 20020701021339ACessna 172E · Battle Ground, WA(-23) Pilot of N3706S, CE-172 collided with a tree while on the landing rollout at Cedars north airport, Battle Ground, Washington. According to the pilot, the aircraft lost oil pressure shortly after departure.Jul 1, 2002 · N3706S · No damageAccident 20020701019739APiper PA22 · Jacksonville, FL(-23) Student pilot lost control of aircraft after landing and ground looped aircraft. Instructor pilot was not rated in the aircraft and was giving instruction in an aircraft he was not rated for.Jul 1, 2002 · N1693A · No damageAccident 20020701018119APiper PA16 · Moneta, VA(-23) Airman reports landing runway 05 in full stall landing. The roll out was initially normal, then the aircraft suddenly veered left and ran off the side of the runway. The aircraft struck a one foot high berm approximately 40 feet from the runway edge and…Jul 1, 2002 · N5921H · No damageAccident 20020701016449AScwzer G164A · Eunice, LA(-23) The pilot received information from the ground crew that they could see an unusual amount of leakage coming from the belly of the aircraft. At this time the pilot noticed that some of the spray chemical he was distributing was coming into the aircraft…Jul 1, 2002 · N8917H · No damageAccident 20020701016249ABeech G35 · Yakima, WA(-23) Pilot john cosman ii and wife jane were transitioning into the ykm airport at 5000 MSL with clearance to land while crossing the last ridge when the aircraft started to shake/flutter violently. Pilot john cosman reduced power and pulled the nose up. The…Jul 1, 2002 · N4647D · No damageIncident 20020701015839IAmrgen AA5B · Hartford, CT(-23) On 07/01/02, at 17:26Z, N28857, an AA-5B on final for runway 20 at hfd. One quarter mile out on an upwind approach the pilot saw an aircraft approaching his aircraft head on. Tower told pilot that the aircraft was a helicopter (UH-60) and it was not a…Jul 1, 2002 · N28857 · Minor damageAccident 20020701015679AAmtr RS15 · Jackson, WY(-23) Pilot was flying too close to grand teton peak where high gusty wind conditions existed, the left wing struck the mountain, severing the wing. Note: section 31 (pilot information) incomplete. Pilot logbook was destroyed in wreckage.Jul 1, 2002 · N33515 · No damage · 1 fatalAccident 20020701013949ABeech H18 · Tatum, NM(-23) Observers saw the plane descending and they thought it was landing. Investigations showed that both engines were operating, the landing gear was up and the flaps were stowed. The aircraft had a low sink rate and contacted the ground at cruise speed or…Jul 1, 2002 · N835K · No damage · 1 fatalAccident 20020630038239APiper J3C65 · Mcconnelsville, OH(-23) The pilot landed at the Morgan co. airport (I71) for fuel at 10:30 a.m. (local). After refueling, the pilot departed the runway with the intention of completing a touch-n-go landing before departing the airport for the next destination. After the…Jun 30, 2002 · N35545 · Substantial damageAccident 20020630038179AAmtr Acrosport · Jacksonville, IL(-23) The owner and properly certificated pilot and sole occupant of the single place aircraft was attempting to land after a short flight, when he lost control, resulting in a hard landing, causing the collapse of the left landing gear. The aircraft ran off…Jun 30, 2002 · N1419 · Substantial damageAccident 20020630027729AAmtr RV8 · Papillion, NE(-23) On June 30, 2002, at approximately 1225 CDT, waltz RV-8, N877TC, sustained substantial damage as a result of an emergency landing 4 miles south of Papillion, Nebraska. During descent to the omaha millard airport (mle) the pilot noted a slow fluctuation…Jun 30, 2002 · N877TC · Substantial damageIncident 20020630027099ICessna 404 · Kansas City, MO(-23) The pilot landed the aircraft gear up after several failed attempts at normal and emergency landing gear extension. Investigation revealed a hydraulic leak in the vicinity of the center wing section under the cabin floor. The landing gear hydraulic…Jun 30, 2002 · N104FA · Minor damageAccident 20020630023349AMooney M20C · Denver, CO(-23) Pilot was practicing touch and go landings and forgot to put the landing gear down. The pilot has new certificate and very few hours.Jun 30, 2002 · N6283U · Substantial damageIncident 20020630019349IPiper PA24250 · Pueblo, CO(-23) Aircraft landed in a strong crosswind and the right main gear collapsed. Pilot stated that when he was making his approach the wind was calm, but as he descended, the tower reported an increase in the wind. As he landed, the wind sock was straight and…Jun 30, 2002 · N6027P · Minor damageAccident 20020630018659AUnivar 1083 · Colorado Spring, CO(-23) The pilot was on takeoff roll when he reported that he could not keep the aircraft on the center of the runway. It went off the left side of the runway and flipped over. The pilot stated that the brake may have hung up. As he observed a black line…Jun 30, 2002 · N6968M · Substantial damageAccident 20020630018409AAmrgen AA1 · York, PA(-23) On takeoff from rwy 34 airspeed accelerated normally. After lift off the pilot noticed the aircrafts climb performance was not as expected, he could not obtain enough power to clear the terrain ahead. The airplane bounced off the first ridge and into…Jun 30, 2002 · N5684L · Substantial damageAccident 20020630017249AUnivar 1083 · Window Rock, AZ(-23) On takeoff on runway 26 @ P34 (mifflintown airport) at approximately 100 feet altitude the engine shut down for no apparent reason. Emergency landing was attempted off the airport. Pilot avoided homes in a residential area, but flew through various…Jun 30, 2002 · N6678M · No damageAccident 20020630016859ACessna 207A · Chevak, AK(-23) On June 20, 2002, at about 1450 Alaska daylight time, a wheel equipped Cessna 207 airplane, N7384U, sustained substantial damage as a result of a landing accident at Chevak, Alaska. The airplane was operated by flight Alaska, inc. as a 14 CFR part 135…Jun 30, 2002 · N7384U · No damageAccident 20020630016699ACessna A185F · Skwentna, AK(-23) On June 30, 2002, about 1000 Alaska daylight time, a tundra tire-equipped Cessna 185 airplane, N1078F, sustained substantial damage during landing at a remote airstrip, about 19 miles south of Skwentna, Alaska. The airplane was being operated as a…Jun 30, 2002 · N1078F · No damage