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 20070930022409APiper PA32R301T · Stockton, CA(-23) Aircraft was on final approach to runway 27 at pine mountain lake. On short final aircraft encountered a sudden down draft and aircraft rapidly descended. Right gear touched down hard on approach end of runway and right gear strut was damaged. Pilot…Accident 20070930022269AHelio H295 · King Salmon, AK(-23) At approximately 1720 Alaska daylight time, N295BA a Helio H-295, collided with trees and tundra about 40 miles northeast of King Salmon, Alaska. The aircraft suffered substantial damage from the impact. The aircraft was operating under visual flight…Incident 20070930022179IIsrael 1124 · Houston, TX(-23) N290CA a IA-1124 aircraft was enroute to sugarland, Texas (sgr). An isolated thunderstorm had passed over minutes earlier. Sugarland tower had cleared the aircraft for landing on runway 35. The aircraft touched down on centerline approximately 300 feet…Incident 20070930022069IScwzer 269D · Houston, TX(-23) Pilot taxied away from the p.d. area. Prior to take off he was turning the helicopter into the wind at which time he felt a "thump" and the helicopter dropped. Pilot conducted a hovering autorotation upon impact with the ground the aircraft yawed to the…Incident 20070930021589IBeech A24R · Readington, NJ(-23) Pilot performed a full stop landing on runway 22 at N51, taxied back and initiated another take off and landing sequence. While on final approach to runway 22, the pilot noticed deer on the runway. He initiated a go around, retracting the gear and…Accident 20070930021299ABbavia 7GCBC · Laurel, MT(-23) On September 30, 2007 at 1400 MDT, a Bellanca 7GCBC, N41695 registered to the pilot [privacy data omitted] had the left main gear collapse on landing, while on a training flight. Visual meteorological conditions prevailed at the time. No flight plan had…Accident 20070930021259AAmtr Fokkerdvi · Morristown, TN(-23) Pilot stated he was flying the airport landing pattern and lost power and tried to land in a field striking a bank of dirt.Accident 20070930021249ACessna 182F · Bakersfield, CA(-23) The pilot and three passengers were taking a local flight under VFR conditions. The pilot washed the aircraft prior to departure and placed a machine screw in the left hand control lock hole (on the yoke) to secure the ailerons. When preflighting the…Incident 20070930021079IAmtr Kitfoxiv · London, KY(-23) The owner/pilot of N43472, an experimental light sport, kit fox iv, stated: "I have had some trouble with the ground handling on this aircraft so I waited until late Sunday evening when there was good weather and no wind in order to practice some more…Incident 20070930020709IStbros SC7SERIES3 · Moab, UT(-23) The jumper was the second jumper in a group of three and the group was the next to last of several previous groups. His two companions lost sight of the victim relatively soon after they exited and did not witness anything abnormal. After the other…Incident 20070929832409IWillia Sonex · Rochester, IN(-23)Pilot stated that he lost engine power in cruise flight approx 12 miles w. of Rochester, IN. Airport. PIC made emergency landing in corn field. No damage to aircraft and no injuries to PIC. PIC stated that he inspected engine and determined that…Accident 20070929830599AScwzer G164A · Pittsgrove, NJ(-23) On Saturday, September 29, 2007 at 4:55 pm eastern daylight time, a Grumman G-164A, N8761H, ser# 1516, was substantially damaged after an emergency landing in a field at Pittsgrove new jersey. The aircraft was operated by the [privacy data omitted].…Accident 20070929830149ARobsin R22BETA · Rodeo, NM(-23) The pilot [privacy data omitted] stated that he operated his aircraft over a ridge line into a narrow valley. As he descended into the valley to check for livestock and fence conditions, he encountered gusty, quartering tailwinds with a subsequent loss…Incident 20070929829729IBoeing 73776N · Philadelphia, PA(-23) Airtran flt 47 took off from phl on runway 27L, was climbing out at approximately 3500-3800 feet when the aircraft was struck by a flock of geese. Substantial damage to fo window (R1). Captain declared an emergency and returned to phl for visual…Incident 20070929828569IConaer LA4200 · Gainesville, FL(-23) After 28 hours of training, the pilot [privacy data omitted] was traveling home to south carolina. The pilot [privacy data omitted] was stopping for fuel in Gainesville, FL (gnv). During the landing phase of flight, the pilot [privacy data omitted]…Accident 20070929825229AAmrgen AA5 · Truesdale, MO(-23) Mishap pilot was conducting flights for children of local organization. Upon approaching to land, he stated that he experienced a strong gust of wind causing him to lose control and contact trees. The aircraft's right wing struck first causing the…Accident 20070929824279AAmtr Sidewinder · Pensacola, FL(-23) On September 29, 2007, the pilot turned from base to final. He lined up on the runway and entered a slip to lose altitude. He held the slip for approximately 190 ft which made him land long on the runway. Witnesses said that the pilot [privacy data…Incident 20070929824099ICessna 206CESSNA · Raleigh/Durham, NC(-23) Raleigh, NC: N5188U, C206, landed short of runway 5L due to a rough running engine. No damage. No injuries. 10/11/207; talked with the pilot [privacy data omitted], aircraft was enroute from salisbury and engine started running rough. Adjusted mixture,…Incident 20070929023619IBoeing 737210C · Hilo, HI(-23) Cargo flight 956 hnl-ito on takeoff crew noted vibration that cleared after takeoff. On landing in ito crew noted vibration again. Crew checked aircraft and found #4 main tire separated from rim. Remnants of the tire were found on runway 8L in hnl.Accident 20070929023369ABeech B35 · Waterloo, IA(-23) Aircraft departed waukesha, Wisconsin (ues) at approximately 1830 on September 29, 2007, enroute to Waterloo, Iowa (alo). Pilot received a VFR clearance to runway 18, and as reported by ATC, was experiencing difficulty locating the airport. At one…Incident 20070929023249IGryf MD3RIDER · Fullerton, CA(-23) Upon landing the pilot lost directional control and the airplane departed the runway causing minor damage to the airplane. The student pilot had 44 hours and was on a solo flight.Accident 20070929023089APiper PA24250 · Navasota, TX(-23) The aircraft, N7149P, was doing touch and go landings at Navasota Municipal Airport (60R). On the third landing, the nose gear collapsed and both main gear struts pushed through the top wing skin (causing damage to both wing spars). The aircraft…Accident 20070929022999ALuscom 8E · Ramona, CA(-23) The owner/student pilot recently purchased the aircraft in order to receive instruction and obtain his private pilot certificate. The owner/student pilot was conducting a VFR solo flight under 14 CFR part 91. On the second of a series of stop and go…Accident 20070929022579ACessna 172P · Belleville, IL(-23) On September 28, 2007, during preflight, one of the flying club's member pilots discovered damage on the aircraft. Upon closer investigation, it was discovered that the firewall was kinked and creased in several locations. In the cockpit, the front seat…Incident 20070929022019IMaule MT7260 · Austin, TX(-23) On 09/29/2007 at approximately 1700 CST, aircraft N42388 upon landing at Austin Bergstrom airport, on runway 17L, impacted the runway breaking the nose wheel strut, and striking the propeller. Aircraft came to rest on runway with no injuries. Weather…Accident 20070929021839ACessna 172S · Newark, OH(-23) During landing on runway 27 at the Newark airport, the aircraft bounced 2 or 3 times on the nosewheel. Aircraft departed runway and came to rest in the grass beyond the parallel taxiway. No one was injured. The aircrfaft sustained substantial damage.Accident 20070929021659APiper J5A · Turlock, CA(-23) According to the pilot and witnesses, the following are the events that occurred resulting in this accident. The aircraft's engine stopped at the end of the runway prior to takeoff due to the fuel selector being in the "off" position. After…Incident 20070929021119ICessna 150L · Block Island, RI(-23) The pilot was operating the aircraft on his flight to bid under 14 CFR part 91. The weather at the time of the incident was clear with winds reported at 020/11 with gusts to 17 knots. The pilot stated to riac inspector [privacy data omitted] that he set…Incident 20070929021059ILear 60LEAR · Bedford, MA(-23) At 115 knots during takeoff departure on runway 29 at kbed the pilot experienced both left main tires fail. The pilot aborted the takeoff and stopped the aircraft on taxiway e. the two pilots and six passengers were evacuated as the aircraft filled with…Accident 20070928832029ADoug DC982 · St Louis, MO(-23) On September 28, 2007, at approximately 1340 local time, an American airlines MD-82 experienced an in-flight fire in the no.1 engine shortly after takeoff from stl enroute to ord. The crew declared an emergency and secured the engine while attempting to…Accident 20070928830699AAMD FALCON900 · Teterboro, NJ(-23) On 9/28/07 at approximately 1312 EDT while taxiing for departure on taxiway zulu at kteb, N90TH struck a steamroller with its left wing. Although taxiing on centerline approximately four feet of the left hand wing was hanging over into the construction…Incident 20070928830459IRhnflu EA300L · Warehouse Poin, CT(-23) The pilot [privacy data omitted] was practicing full stop landings at Skylark Airpark (7B6). He had completed 6 or 7. While rolling out on the last full stop landing on runway 28, the pilot [privacy data omitted] attempted to exit the runway to the…Incident 20070928826299IBeech 23 · Pontiac, MI(-23) At 1350 aircraft N8778M BE23 (Beech musketeer) landed Pontiac airport runway 27R. Aircraft ran off runway to the left. Aircraft clipped runway sign box near "j". Pilot taxied to terminal.Incident 20070928825639IBeech 99 · Rapid City, SD(-23) The pilot [privacy data omitted] flew a BE-99 aircraft, N4381Y, from rap to pir when he discovered he had a gear-down warning indication. The pilot [privacy data omitted] then flew the aircraft back to Rapid City and verified that the nose gear was not…Incident 20070928824009IMncoup 110SPECIAL · Atlanta, GA(-23) Incident aircraft was landing on runway 27 at mccollum field. After touchdown the aircraft ground looped to the left, damaging the left wingtip and collapsing the left gear. Wind reported to be 240@6 gusts to 15, variability 240-40.Accident 20070928823799ACessna 172S · Mc Kinney, TX(-23) During landing phase, student pilot bounced aircraft numerous times on main landing gear with final bounce on nose gear causing nose gear to collapse. The collapse of the nose gear allowed the prop to contact the ground forcing the engine rearward…Incident 20070928023649ICessna 182D · Wilson Bar, ID(-23) The pilot [privacy data omitted] was taxiing up hill when he hit several rocks approximately 8" in diameter.Incident 20070928023559ICessna 172S · Horseshoe, ID(-23) While landing at the Private air strip, the pilot failed to see a set of powerlines on approach and flew directly through them causing minor damage to the aircraft.Incident 20070928023309ICessna T210N · Greer, SC(-23) Pilot stated that after lowering the landing gear, and after a slight flare was initiated after crossing the runway threshold, the aircraft dropped hard to the runway causing damage to the nose landing gear.Incident 20070928023269IRkwell NA26560 · Cedar Rapids, IA(-23) Due to loss of cabin pressurization, the pilot initiated an emergency descent resulting in a loss of standard separation from an aircraft traveling in the opposite direction. Incident [privacy data omitted] is closed with this report.Incident 20070928022829IPiper PA34200 · Madera, CA(-23) CFI [privacy data omitted] was demonstrating a short field landing to student [privacy data omitted]. All 3 green landing gear lights were observed. After landing the CFI, the student, and a back seat student observer all state that the landing gear…Accident 20070928021309APiper PA31350 · Pampa, TX(-23) On September 28, 2007, at approximately 0945 CDT, while on a CFR title part 91 VFR repositioning flight from borger (bgd) to Pampa, Texas, (ppa), the pilot and single occupant of N45014, a Piper model PA-31-350, landed on runway 17 with the aircraft…Incident 20070928020639IBeech 58TC · Erie, PA(-23) Right engine developed a crack in the crank case at the #6 cylinder, and the aircraft returned to the airport.Incident 20070927830679IBeech 58 · Memphis, TN(-23) Pilot received remedial training on ground awareness procedures and taxi/takeoff procedures.Incident 20070927826559IPiper PA31P · Tucson, AZ(-23) Pilot was attempting to land when on short final the throttle cable broke on the left engine. The engine was stuck at 23 inches of map. During the landing the pilot applied excessive braking causing the left main tire to blow. No injuries and no damage…Incident 20070927826019ICessna 182P · Mineral Point, WI(-23) The pilot [privacy data omitted] made a hard landing and, as a result, induced a porpoising effect on the aircraft. The aircraft came to a stop after the third touchdown when the prop struck the runway and the nose wheel fractured. A displaced threshold…Accident 20070927023409AUrocop EC130B4 · Meadview, AR(-23) Helicopter struck a large bird which came through the wind screen striking occupants. Helicopter landed on a dirt strip, pearce ferry airstrip (L25) Meadview AZ. Pilot's statement: on September 27, 2007, at about three pm pacific daylight time, I, the…Accident 20070927023099ACessna R172K · Bethel, AK(-23) Pilot states he was attempting to land on a slough approximately 44.2 miles northwest of Bethel to drop his daughter and friend off to hunt moose. After his reconnaissance of the area the pilot began his approach at a slight angle to the slough in order…Incident 20070927022009IDhav DHC2MK1 · Cordova, AK(-23) According to the pilot, the drag link failed due to an oversized tail wheel tire landing on hard surface.Incident 20070927020659ICessna 172G · Laurel, MT(-23) Pilot lost control of the aircraft in a crosswind landing.