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 20170803011409APipistrel Virus SW · Immokalee, FLLight sport aircraft Pipistrel Virus Sw, registration number N811AW with two persons onboard flying, took off from Immokalee airport (imm). Aircraft was accomplishing touch and goes at a private landing strip near big cypress reservation. Aircraft crashed on…Accident 20170803010299ARalph Michael P Marine Devil DOG · Danville, AROn August 3, 2017, at approximately 11:00 central time, an experimental weight-shift aircraft (trike), registered as N165AB landed on runway 11 at the Danville municipal airport, Danville, Arkansas. On rollout, the left main tire came off the rim due to…Accident 20170803010289ACessna 170A · Moab, UTPilot and wife departed cny airport at 1945. Pilot had been watching changing weather and had delayed takeoff for 30-45 minutes to avoid transitioning storms. Pilot said he had 15 knot headwind and had a good climb initally but realized after takeoff that he…Incident 20170802019069IBritten-Norman BN2A-26 Islander · Culebra, PROn 08/02/2017, N906GD departed antonio Rivera rodriguez (tjvq) airport at at/around 13:05 local time on a scheduled flight to Benjamin Rivera Noriega (tjcp) airport located at Culebra, puerto rico with one flight crew (PIC) and 6 passengers. Upon landing on…Incident 20170802016859ICessna 305A · Westerly, RIThe airman was returning from a sight seeing trip. The airman lined up with runway 14 and at the time, the wind was 180 degrees at 9 knots. In the airman's statement, "a gust occurred after touchdown and he was unable to keep the aircraft on the runway." The…Incident 20170802016849ICessna 310 · Riverside, CADuring level flight 8 miles southeast of rei, the radios system became weak. A total electrical failure occurred prior to arriving at ral. Landing gear was extended manually. Pilot was in contact with ral tower by cellular telephone and landed at ral…Accident 20170802015709AMooney M20K · Skiatook, OKDeparted kbvo around 5 pm on a direct flight to 2F6 to fuel N95442, which is 28 statute miles. Upon departure left tank low fuel light was on, right tank low fuel light was off and showed between 1/8 and 1/4 full. Fuel selector was on right tank. Pilot made…Accident 20170802012739ACessna 172R · Kearney, NEOn August 2, 2017, at 4:30 pm CST, a Cessna 172, N91966, was involved in an accident at the Kearney regional airport (kear), Kearney, Nebraska. The PIC was returning to kear after a 4.8 hour flight to complete lesson 10 in the university of Nebraska Kearney…Accident 20170802011129ASikorsky S-97A · Jupiter, FLOn August 2, 2017, at 0720 eastern daylight time, a Sikorsky S-97, N971SK, experienced a flight control Anomaly while lifting to a hover resulting in excessive roll oscillations leading to intermeshing of the Counter-rotating rotor system resulting in a hard…Accident 20170802010279AAB Sportine Aviacija LAK-17A · Uvalde, TXOn August 2, 2017, N128LA launched from Garner Field (kuva), in Uvalde, Texas, as part of a soaring competition that was being held there. The glider, a LAK-17AT-18, was being towed by N42VA, a Piper pawnee. The two aircraft were attached to each other by a…Accident 20170802010269AAir Tractor AT-402B · San Angelo, TXThis was a research flight related to weather modification. The aircraft had a spray system that put an electrical charge on the water as it exited the spray boom. There were researchers on the ground collecting real time data from the aircraft. The flight…Incident 20170801017909IDehavilland DHC-2 MK. I(L20A) · Ketchikan, AKFlight was operated as a part 135 flight with 5 passengers on board. Pilot departed the dock at Waterfall Resort and failed to recognize the wind direction. On takeoff, the pilot could not maintain directional control due to a strong tailwind. As pilot…Incident 20170801016839IRobinson Helicopter R22 Beta · Middle River, MDOn August 1, 2017 the instructor and student on board the aircraft were practicing hover auto rotations at kmtn, on airport property. After stabilizing the aircraft in an approximately 2 foot hover, the student lowered the collective to initiate the auto…Incident 20170801015689IDiamond DA20-C1 · Newnan, GAOn August 01 2017, at approximately 1800, student pilot departed kcco for a solo flight to auburn, AL. Airport (kauo). At 1930, student pilot was returning from kauo and preparing to land at kcco on runway 14. Student pilot stated that she believes her…Accident 20170801015679AAmerican AA-1B · Phoenix, AZOn August 1, 2017 aircraft n 6216L, a Grumman AA-1B, departed Deer Valley Airport (dvt) on runway 25L, at approximately 12:45 pm local time. The air traffic control manager reported that the pilot declared an emergency shortly after take-off and right before…Accident 20170801015669ACessna 180 · Skwentna, AKPilot was searching for landing sites for hunting. While at 60 foot AGL, 80 knots air speed, 20 degrees flaps, flying up hill. Pilot experienced a down draft. Pilot attempted to correct and stalled the aircraft. Aircraft touched down on main landing gear.…Accident 20170801010689ACessna 150F · Bullard, TXAircraft took off from tarrant field (grass) runway 12, on climb out stalled and crashed in ditch along northbound us hwy 69, mile marker 352, north of mt stelman TX. Flight was student instruction with CFI. Weather at jso wind 18007KT 10SM SCT060 90/65…Accident 20170801010239ARockwell International S-2R · Brawley, CAPilot reported while flying on the north side of the field he noticed a loss of power. He leveled the wings flying north west some power was received then another power loss which forced him to land in nutmeg 4 field with substantial damgage to the aircraft.Accident 20170731020629APiper PA-30 · Topeka, KSOn July 31, 2017, at approximately 2047 central daylight time (CDT), the airman, a certified flight instructor, whom was providing multiengine flight instruction to a private pilot certificated airman, was involved in an aircraft accident while maneuvering…Incident 20170731016819ICessna T206H · Lapeer, MIOn 7/31/2017 at approximately 2100 local time, N204JH (an amphibious Cessna 206) experienced a gear up landing on a paved runway 36 at D95 airport (Lapeer, MI). This landing resulted in the aircraft touching down on the floats, with very minimal damage to the…Incident 20170731016809IDiamond Aircraft Ind DA20-C1 · Tulsa, OKTulsa tower cleared the pilot/aircraft to land on 18R. Aircraft bounced on initial touchdown then bounced 2 or 3 more times, bending the nose gear and contacting the tips of both propeller blades. No pilot injury or other damage issues were noted with the…Incident 20170731016799IColumbia Aircraft Mfg LC41-550FG · Chandler, AZ07/31/2017 1820MST; 0120Z, N8725, Columbia 400 LC41-550FG aircraft lost engine power, declared and emergency and made a forced landing in a farm field about 6 miles south of (chd) Chandler airport. 4-POB, 0-injuries, minor-damage. Engine threw rod which…Accident 20170731015659AChapman Robert E T-BIRD II (Tierra) · Potosi, MOOn July 31, 2017 at approximately 0835 central daylight time the pilot performed a normal takeoff from Washington county airport (8WC) near Potosi, MO. This was the pilot's first flight in this airplane make and model. After climbing to approximately 100 150…Accident 20170731012729ARobinson Helicopter R44 II · Dunlap, ILNarrative of sequence of events relative to the accident: A Robinson R-44 helicopter engaged in agricultural operations departed from a nurse truck platform with the chemical supply hose attached to the chemical tank fitting on the helicopter. Upon departure…Incident 20170731012249ILearjet 60 · Johns Island, SCPilot statement: Event: deer strike Date: 7/31/2017 Time: 00:30 local Airport: kjzi Registration: N821DF Call sign: JTL82 Flight rule: part 91, IFR flight plan, vfr/night conditions Flight plan: kpdk - kjzi "During our night, VFR landing rollout (runway 9 dry…Accident 20170731010249APiper PA-28-181 · Englewood, COOn 07/31/2017 at approximately 1157 MDT, N2146R, a Piper archer ii landed at Centennial Airport, Englewood, CO and received substantial damage to the landing gear and wing spar after traveling off the runway, into the grass parallel to the runway and…Accident 20170731010229AAir Tractor AT-802A · Wells, NVThe Air tractor light attack tanker was landing at the Wells airport after working a fire. The touchdown was normal, and as the tail wheel began to settle, the aircraft made a hard right, and departed the runway. The left landing gear tore off as it dug into…Accident 20170731010219ACessna T210F · Llano, CAOn 07/31/2017, at 1735 PDT, N6109R, a Cessna 210A, enroute from modesto, CA to hemet, CA, lost engine oil pressure. An emergency was declared, and N6109R diverted to 46CN, crystalaire airport, Llano, CA. N6109R landed wheels up approx. 1/2 mile short of 46CN…Accident 20170731010209ACessna 172S · West Seattle, WAEngine had a catastrophic failure during descent to Boeing field when the crank shaft completely seprated at approximately its midpoint. Instructor pilot recognized initial indications of loss of oil pressure and low oil pressure light and diverted and landed…Incident 20170730024779ICessna 172D · Anchorage, AKOn 30 jul 17 mishap aircraft had loud noise followed by extreme engine vibration during cruise at 2,100' MSL. Pilot initiated proper procedures for a forced landing on a gravel/stone strip located at 61 22.37N, 150 02.85W. No damage to the airframe during…Accident 20170730017899AKolb Firestar II · Westfield, PAThe crash of an ultralight aircraft was reported to the roc on 07/30/2017. An occurrence investigation began. During the investigation it was determined the aircraft held an experimental special airworthiness certificate and did not qualify as an ultralight.…Incident 20170730016789IJim Faist Calidus · Blum, TXOn instructional flight with CFI and student pilot. Student pre-rotated rotor to 200 RPM, released brakes, and began takeoff roll. Student did not apply sufficient power; CFI pushed power control forward. Student realized front wheel was coming up, noticed he…Incident 20170730016779IBoeing E75N1 · East Alton, ILPilot performing touch and go's at st. Louis regional airport (kaln) using runway 11. On first attempt aircraft landed on the left wheel, aircraft exited the runway into the grass and the tail wheel struck a hold short sign. Corrective action Remedial…Incident 20170730016769IUltravia Aero Intl Pelican Sport/A · Port Clinton, OHPilot was attempting to land on runway 27. He stated at approximately 10 feet prior to touchdown, the aircraft caught a gust of wind which caused the aircraft to lift up 5 to 7 feet. The aircraft then slamed down and bounced again for the second time. It was…Accident 20170730015649APiper PA 46-350P · Tahlequah, OKPilot and three passengers departed joplin (kjln) at 18:06 central time. Climbed to 12500. About 10 min. After obtaining 12500, pilot noticed a change in the engines sound and subsequently felt the engine shake. Pilot contacted fort worth center, who directed…Accident 20170730015639ASteele John J Acro Sport II · Loudonville, OHMy adult son [privacy data omitted] and I were returning from oshkosh Wisconsin to brunswick Maine on Sunday, August 30, 2017. We were flying my recently restored acro ii and conducting multiple legs and refueling stops on our journey. At approximately 5 pm…Incident 20170730015559IBeech A36 · North Canton, OHAircraft flew from traverse city to flint, Michigan. Pilot reported his battery was dying. Did not have his three green landing gear lights. He flew pass the tower to confirm his gear was down and landed at flint Michigan. The next day he had a mechanic look…Accident 20170730015549AChampion 7ECA · Butler, PAPilot stated wind caused aircraft to drift, he lost control attempted recovery, and during recovery struck an airport sign.Incident 20170730015539ICessna 180H · Oshkosh, WIOn Sunday, July 30 2017 the pilot of a Cessna 180 while taxiing to leave Oshkosh felt the aircraft was not handling correctly so he decided to taxi back to parking to investigate. During the taxi process the pilot needed to maintain pressure on the right…Incident 20170730015529IGrumman American Avn. AA-5B · Ky Dam Village, KYPilot stated the aircraft would not start, so he got out and had his wife hold the brakes while he held the battery cable. When the aircraft started the plane began to roll and she was not able to stop it before it rolled off the ramp and into the ditch,…Accident 20170730012719ACessna 172S · Danbury, CTJul 30, 2017 - received telecom from the FAA the centralized regional operations center (croc) regarding aircraft accident, daily report application (dra) incident notification event id 320849. Aircraft was U.S. Registration N612DF, model CE-172-S, serial…Accident 20170730012689AJames D Riggs RV-10 · Lawrenceburg, TNThe owner took the aircraft out for a local flight after completing the condition inspection. During landing on runway 35, the aircraft touched down hard, bounced and made a hard left turn contacting the ground on the left side of the taxi way and came to…Incident 20170730012059IAir Tractor AT-301 · Adrian, ORDescription of event: Pilot said just as he pulled up from making a pass over an onion field the engine suddenly stopped, no sputtering or coughing, just quit. Pilot stated that initially he wanted to land on a road, but it became apparent that he couldn't…Incident 20170730011899IDenney Charles O Thunder Mustang · Evanston, WYAfter landing roll out the pilot moved the aircraft to the left side of the run way to prepare to exit left. The aircraft veered sharply to the right. The left main gear had collapsed inboard. The right main gear collapsed outboard. The aircraft came to rest…Accident 20170730010199ACessna 172S · Carlsbad, CADeparted krnm enroute to kcrq. Approx. 10 miles east of kcrq received weather, contacted kcrq tower and received reporting instructions, straight in clearance to land rwy 24. Approximately 1330 PDT porpoise landing resulted in prop strike. Executed go around,…Accident 20170730010189ALet L-23 Super Blanik · Homestead, FLAirman [privacy data omitted] was flying the rented glider in the pattern with a passenger friend. He advised in his statement that he experienced gusty winds and a downdraft while on base to final and ran out of lift causing him to make an emergency landing…Accident 20170729016739ACessna 172S · Santa Ana, CADamage was noticed by a pilot test applicant during the preflight portion of practical test. The damage presumably was caused by one of the renter pilot(s) prior to the scheduled flight test. Review of the aircraft rental records revealed that this aircraft…Incident 20170729015519IPiper PA-24 · Oskaloosa, IAThe pilot reported that upon rotation the landing gear did not retract properly. A "burnt smell" was noted in the cockpit. The pilot attempted to extend the landing gear and elected to return to the airport. The pilot noticed that the green down and locked…Incident 20170729015499ICessna 172S · Palo Alto, CAOn July 29, 2017 at approximately 13:24 PDT, N6009M, a Cessna 172 was on landing roll runway 31, the aircraft veered off the left side of the runway striking the taxiway c sign before re-entering back onto the runway.Incident 20170729015489IBeech A36 · Memphis, TNPilot attempted landing at General Dewitt Spain Airport at 1250 local time and struck the ground much harder than intended. This caused the nose gear wheel and tire assembly to break off and depart the aircraft. The pilot executed a go-around. Another…