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 20070707020589ACessna 421B · Oceanside, CA(-23)The right landing gear collapsed on landing and the aircraft drifted off the right side of the runway and into a chain-link fence. There were no injuries to the pilot or passenger, but the aircraft sustained substantial damage from contact with the…Incident 20070707020299IPiper PA34220T · Vineyard Haven, MA(-23) During approach and landing on runway 24 at mvy, pilot struck a threshold light. Although the pilot reported no damage, the aircraft's right main tire went flat during a subsequent taxi for takeoff. A U.S. Airways pilot, holding short of runway 24,…Accident 20070707019369ACessna 170 · Spanaway, WA(-23) Pilot failed to maintain control of N9716A after and aborted takeoff and veered off runway where the aircraft flipped over.Accident 20070707018899AWSK PZLM18B · Kyle, SD(-23) The pilot [privacy data omitted] took off from rap in N14067 loaded with slurry and flew 5 miles southwest of Kyle, SD. He attempted to pull up over a ridge when the aircraft lost altitude. He pushed the nose over and dumped his load. The aircraft…Incident 20070707017029IBeech B90 · Yuma, AZ(-23) This was on an instructional flight with a planned landing at kyum airport. The air traffic control tower was closed at the time of the incident. The PIC reports that there were two other aircraft reported on CTAF that were also landing at kyum. One…Incident 20070707017009IAmtr Searey · Newport News, VA(-23) Pilot attempted water landing. On 3rd bounce, a wave came over the nose breaking the plexiglass windscreen and flooding the pilot's compartment. The aircraft sank to the wings immediately.Accident 20070707015629AAirtrc AT402B · Eldorado, TX(-23) On July 07, 2007, central daylight time, a single engine AT-402B aircraft, N712GS was substantilly damaged following loss of power 3 miles from take off from a Private strip, 10 miles west of Eldorado, Texas. Pilot was forced to land after an engine…Accident 20070707014989AUrocop EC130B4 · Hudson River(-23) On base final to the west 30th street heliport (jra) over the Hudson River in NY, during a sight-seeing tour with seven passengers onboard, pilot experienced a loud bang noise, followed by airframe vibration. PIC elected to perform a forced landing by…Accident 20070707014539APiper PA20135 · State College, PA(-23) During landing rollout on runway 24 pilot applied brakes, planning to return to a taxiway behind the aircraft. While applying brakes aircraft ground-looped to the left collapsing the left gear and striking the left wing on the runway. The propeller…Incident 20070707013449ICessna 172C · Cresco, IA(-23) Enroute from winona, MN (ona) to grinnell, IA (ggi), pilot experienced engine problems with a loss of power, and an emergency landing was executed on a field near Cresco, IA (cjj). A local certificated mechanic was called to the scene. On arrival, the…Incident 20070707012329IAmtr LANCAIR320 · Winder, GA(-23) During the approach to landing phase of flight, the PIC observed the gear selector knob in the down position but failed to notice whether or not the gear position lights were illuminated. The landing gear did not extend as a result of a mechanical…Accident 20070707012239AWSK M18A · Burns, OR(-23) While enroute to drop retardant on a fire, the engine lost power due to fuel starvation. The pilot dropped his retardant load and made a forced landing in an open field. Pilot sustained minor injury and plane was substantially damaged.Incident 20070706824969ICessna 177RG · Kenosha, WI(-23) The pilot stated that approximately 20 minutes into the flight he heard a single "pop" sound, the airspeed dropped 20 knots, the main gear was partially extended and the gear up light was no longer illuminated. The main and emergency gear extension was…Incident 20070706017989ICessna T210M · St Francis, KS(-23) Aircraft landed long and rolled off the end of the runway into a sod area damaging the nose gear, propeller and right wing tip.Accident 20070706017549ACessna 177RG · Pedricktown, NJ(-23) A CE-177RG, N52650, experienced single engine failure at approximately 300' AGL after departing runway 25 on a VFR flight from 7N7 (Spitfire) to dkx (knoxville). The plane experienced substantial damage after landing in a farmer's field 1.5 miles…Incident 20070706016569ICessna 210G · Upland, CA(-23) Pilot entered traffic pattern at Cable Airport for landing after flight to john wayne airport. Performed "gumps" check twice--once on base leg and once on final approach. Pilot recalls gear doors being open, but does not remember visually confirming…Accident 20070706015959ACessna 150M · Muncie, IN(-23) While attempting a landing on runway 32 at Muncie airport, the pilot lost control of the aircraft and ran off the runway, coming to rest in a ditch damaging the aircraft left wing and nose gear.Incident 20070706015349ICessna R182 · Colorado Sprin, CO(-23) This was a training flight, conducted under VFR conditions, part 91. During the approach, the instructor took control of the aircraft. Upon touchdown during touch and go maneuver, the student pilot reached over and raised the landing gear handle causing…Accident 20070706014949APiper PA28181 · Chicago/Lake I, IL(-23) Pilot was practicing night takeoff and landing procedures on runway 26 at Lake In The Hills Airport (K3CK), Lake In The Hills, Illinois. Upon touchdown, the aircraft departed the runway and struck a fence. There was one passenger on board; no reported…Accident 20070706014929AAmtr CH601HDS · Jamestown, OH(-23) The pilot initiated the TAKE0OFF on runway 24, a 1220 ft. grass runway. The aircraft lifted off approx. 5/8 of the way down the runway & rose to approx. 10 ft. the pilot stated that the engine seemed to lose power & then the aircraft settled back down…Incident 20070706013249ICessna 182N · Little Rock, AR(-23) On June 25, 2007 at approximately 1630 CDT, a Cessna 182, CE-182-N, N92405, piloted by an ATP certificated pilot encountered severe turbulence while circumnavigating thunderstorms enroute from tulsa, Oklahoma (ktul) to university-oxford, Mississippi…Incident 20070706012019ICessna TR182 · Kent, WA(-23) 07/06/2007, Crest Airpark Kent Washington at 8PM N756SE, had a gear up event with minor damage to the aircraft. Pilot believes the gear handle was not in the down and locked position. During takeoff the pilot noted the aircraft did not feel right and…Incident 20070706010459IAmtr LC41550FG · West Kingston, RI(-23) The pilot experienced a hard landing on runway 29, damaging the left wheel and left wheel pant, left fairing and causing a tear approximately 12 inches in length on the left aft under-surface of the wing.Accident 20070706010319ASocata TB20TRINIDAD · Groesbeck, TX(-23) On 6 July, 2007, at 1146 CST, trinidad aircraft, registration number N2801W, owned by southwood partners, [privacy data omitted], descended from 5,000 feet cruise flight and crashed into a wooded area southwest of Groesbeck, Texas, while on a personal…Accident 20070705020439ACessna A185F · Kenai, AK(-23) The pilot stated as they were flying west to east through lake clark pass in the Alaska mountain range, they encountered deteriorating weather while flying at approximately one thousand (1000) feet above ground level. As they approached areas of fog,…Accident 20070705019599AHughes 369D · Comfrey, MN(-23) Pilot reported losing power during spray run. N2 was observed below minimum red line. Minimal altitude was obtained, chose to turn away from power lines and out of the tall corn to a clear area in an attempt to avoid more serious damage and attempted…Accident 20070705015549ACessna 195 · Warrenton, VA(-23) The pilot stated that the approach to and landing on runway 33 were normal. The surface wind was estimated to be from 240 degrees at approximately 6-8 knots. During rollout, directional control was lost at approximately 35-40 mph. The aircraft departed…Accident 20070705014629AAmrgen AA1C · Perry Township, OH(-23) During heavy thunderstorms in the surrounding area, along with mist and fog locally, Grumman AA1C, N200JA crashed through a tree line and struck the ground. The aircraft was destroyed, with 2 fatalities on board.Accident 20070705014169AAmtr Stilettorg · Quartzsite, AZ(-23) The pilot [privacy data omitted] requested to be fueled at the chandler airport prior to his departure on July 5, 2007. His passenger is a pilot and during the fueling process the pilot [privacy data omitted] was called away from the aircraft. The pilot…Accident 20070705013269ASphrth VENTUS2C · Bridgeport, CA(-23) Pilot statement 7-11-07: I was able to repair the instruments enough in my glider today to retrive the information from my data logger. I can now be much more accurate in my description of this accident. I took a tow from the glider port at truckee and…Incident 20070705013159ICndair CL6002B19 · Omaha, NE(-23) Rexa FLG5966 returned to Omaha due to an open oxygen panel located on the exterior of the fuselage below the first officer side window. No emergency declared and no special handling. Aircraft did several fly arounds until the aircraft was at landing…Incident 20070704825679ICessna 172RG · Newberry, MI(-23) Pilot landed gear up after forgetting to lower the gear prior to landing.Incident 20070704824939IAviat A1B · Orr, MN(-23) Aircraft with amphibious floats attempted a water landing with wheels extended. On contact with the water aircraft nosed over and sank in an inverted position.Accident 20070704018049AAmtr Xairrajhamsa · Pima, AZ(-23) Pilot stated during landing on runway 18 he experienced a sudden downdraft and was not able to control the aircraft. He stated that the aircraft was driven into the runway and that the aircraft began to porpoise down the runway until the left gear…Accident 20070704014469AAmtr Ctsw · Colorado Sprin, CO(-23) Upon landing, the aircraft porpoised and bounced down the runway. In attempts to get the aircraft on the ground, a hard landing resulted causing damage to the prop, nose landing gear, and to the firewall. No prevailing weather or mechanical conditions…Accident 20070704013789AScwzer G164B · Joles, CO(-23) Pilot narrative and eyewitness statements indicate that the aircraft attempted takeoff with a left quartering crosswind, a 3/4 fuel and 3/4 hopper load. The temperature was estimated at 75 degrees f. the aircraft gained takeoff speed with normal power…Accident 20070704013649ABoeing N2S3 · Trenton, MO(-23) Several witnesses observed the pilot performing aerobatic maneuvers east of Trenton municipal airport (trx). Prior to impact in the Trenton upper lake, the pilot was observed performing a vertical up manuever, followed by a vertical down maneuver.…Accident 20070704012899APiper PA22135 · Johnson, NE(-23) On July 4, 2007, the pilot of a Piper pacer PA-22-135, N3737A, took off from the tecumseh NE, airport, and flew over his home at Johnson, NE. After flying over his home, he made a right hand turn to fly to falls city, NE, where he was taking the…Incident 20070704011119IBell OH58A · Jonesboro, GA(-23) With engine running and rotor engaged at idle RPM to facilitate battery recharging, passenger seated in right seat inadvertently depressed left rudder pedal causing aircraft to swing left and impact a portable battery charger unit positioned to the left…Accident 20070703021329ABeech E90 · Carlsbad, CA(-23) On July 3, 2007, civil aircraft N47LC, a Beechcraft king air E-90, took off from kcrq on a 14 CFR part 91 flight to ktus. The PIC and one certificated passenger were the only occupants onboard the aircraft. The PIC obtained weather information and filed…Accident 20070703017529ACessna T210N · Fort Collins/L, CO(-23) The pilot [privacy data omitted] stated that he was unable to get the current weather on AWOS at fnl and when he finally was able to see the wind sock he entered a right downwind for runway 15. He said he was very busy looking for traffic and simply…Incident 20070703017329ICessna 210L · Orlando, FL(-23) Nose gear would not extend and lock for landing. Upon landing nose gear retracted with damage to prop and nose gear doors.Accident 20070703014779AAyres S2RT15NORMAL · Marion, IN(-23) While spraying crops pilot encountered an engine failure, performed an emergency landing into a bean field and came to rest in a 30 foot ditch.Incident 20070703014439IAmtr VELCITY173RG · Gaithersburg, MD(-23) Prior to landing at gai, the main landing gear indication light was not showing the main landing gear to be down and locked. The pilot executed a go-around and performed an emergency gear extension. After an individual on the ground visually verified…Incident 20070703012049IMock Hyperhopper · Kiefer, OK(-23) On July 3, 2007, an experimental aircraft, N787SM, landed in an open field after a loss of engine power near Kiefer, OK. In so doing, the aircraft received minor damage to the landing gear assembly. The pilot was not injured. There was no damage to…Accident 20070703011759ACessna 172K · Cedar City, UT(-23) On 7/2/2007 at approx 1500 local time student pilot [privacy data omitted] landed on a dry lake bed to check his fuel load. After check pilot was taking off when a wind gust caught the aircraft and weather vaned perpendicular to his flight path. Lowered…Accident 20070703011379AMooney M20E · Winnsboro, SC(-23) On July 03, 2007, Mooney M20E departed cae @ 1445 and was enroute to fdw. This was an instructional flight for a CFI applicant. A simulated engine failure was performed @ 3,500 ft and @ 700 AGL, a recovery was made on the climb, and passing through…Accident 20070703011239ARobsin R22BETA · Long Beach, CA(-23) The pilot stated that he was giving dual instruction to a student. He said that he and the student had previously conducted various maneuvers and that they were going to practice hovering autorotations. The pilot said that he demonstrated one to the…Accident 20070703010889ACessna 172S · Spanish Fork, UT(-23) While landing at U77, student pilot bounced on attempted landing, on fourth attempt, aircraft had blown nose wheel tire. During tire inspection mechanic noted that the axle was bent and the engine firewall was also wrinkled and buckled.Accident 20070702017579APiper PA36285 · Belle Plaine, IA(-23) Left brake failed during landing. Aircraft went off the right side of the runway and stopped in a ditch adjacent to the runway. Substantial damage resulted to the left wing and aft fuselage, left landing gear, engine, and propeller.