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 20040723020169ICessna 185C · Newberry, MI(-23) While making a low approach the pilot inadvertently hit wires. He then landed and discovered he had hit the wires, damaging the spinner. Other minor damage to the wing and fuselage was discovered later.Incident 20040723020109IAmtr Challengerii · Lawrenceville, IL(-23) [privacy data omitted] the pilot/operator of a challenger ii ultralight vehicle, without civil registration markings, had told others of his intent to conduct a 'taxi only' check of this aircraft. The pilot and aircraft were later found resting upside…Accident 20040723018969ABbavia 7GCAA · Friendly, MD(-23) During landing roll aircraft departed the runway striking an irrigation pipe. Substantial damage to RH wing struts and wing. Pilot stated that after a 3 point landing aircraft turned left, he attempted to push right rudder but could not get any rudder…Accident 20040723017929AAmtr Dragonfly · Covington, LA(-23) The pilot stated that the aircraft would not rotate until he reached the end of the 3000' runway. The aircraft struck the tops of a 60' tree line that was approximately 200' from the departure end of the runway. The pilot lost control of the aircraft…Accident 20040723017669ACessna 172RG · San Diego, CA(-23) On July 23, 2004, N5167R, a Cessna CE-172-RG aircraft was involved in an accident while conducting a full stop landing at Montgomery airfield (kmyf) San Diego, CA. During landing roll out the right main landing gear collapsed. The aircraft sustained…Accident 20040723017159ABeech 95B55 · Minden, NV(-23) On 07-23-2004 this aircraft experienced a gear up landing. Examination of the aircraft on 07-26-2004 revealed damage to both propellers and abrasive damage to the underside of the aircraft causing structural damage to the skin and bulkheads. Examination…Accident 20040723017109ABell 206L1 · Escalante, UT(-23) The pilot of the helicopter landed next to a refueling truck in order to conduct a "hot fueling" operation. At the end of the refueling, the pilot left the helicopter to assist the ground refueler with the fueling hose. When they were finished refueling…Incident 20040723016209ICessna 172RG · Tulsa, OK(-23) The CFI and her student were practicing landing at krvs. The CFI stated that there was heavy traffic in the pattern and this caused her to extend her downwind. The CFI elected to defer extending the landing gear when the checklist called for it due to…Accident 20040723015519AAirtrc AT502B · Mendota, CA(-23) On 7/23/2004 at 0515 hours, N5010E, an air tractor AT-502-B, was destroyed when it crashed during take off from an agricultural airstrip approximately 3 miles west of Mendota, CA. The pilot in command, Douglas edward thiel, commercial certificate…Accident 20040723014979ACessna 172D · Morton, WA(-23) Aircraft landed Morton airport and went off end of runway into brush.Incident 20040723014469IMooney M20L · Pikeville, KY(-23) On approach to the active runway at the Pikeville Hatcher county airport Mr. Wells made the touchdown on the active runway with the gear up. Mr. Wells admitted that he had inadvertently forgot to lower the gear causing the gear up landing.Incident 20040722024379IBolkms BK117B1 · St. Augustine, FL(-23) While responding to an automobile accident at the intersection of roberts road and sr 13 near saint Augustine, FL, air ambulance, N117US, a BK-117 operated by cj systems (trama one of jacksonville, FL) landed in close proximity to a small roadway sign.…Incident 20040722023949IUnivar 1081 · Oak Grove, LA(-23) The aircraft flipped onto its back after the pilot lost control while taxiing. The pilot reported that there were thunderstorms in the area that created gusty winds. The pilot also stated that he was practicing taxiing and that he did not have an intent…Incident 20040722021699ICessna 150F · Corona, CA(-23) Mr. Guy f. saber is a student pilot, receiving flight instruction from Corona flight academy, 1903 aviation dr., Corona, CA, 92882. This flight was to complete the long cross country required to obtain his pilot certificate. The flight plan that Mr.…Accident 20040722017889AScwzer G164A · Vale, OR(-23) Number four cylinders came apart during spraying operations. Aircraft lost power. Pilot landed in a soft field and the aircraft flipped over onto its back.Incident 20040722017259IBoeing 757232 · Windsor Locks, CT(-23) Left engine had a compressor stall and sustained excessive damage to the blades and engine lost total power.Incident 20040722017229IAmtr Excalibur · Sanford, ME(-23) On 3rd flight of new aircraft at sfm, pilot observed that it did not climb as well as on previous flight. Tach and other engine indications appeared normal. While on a wide downwind for runway 14, the engine suddenly stopped. His altitude was…Accident 20040722017129APiper PA24250 · Model, CO(-23) Pilot flew VFR from north las vegas airport (vgt) enroute to steubenville, oh (2G2) in visual meteorological conditions. Pilot planned to stop in lamar, CO (laa) to refuel as he had on previous flights, but failed to monitor fuel consumption. Pilot ran…Incident 20040722016249IPiper PA31310 · Fairbanks, AK(-23) A/c departed otz approx. 2200HRS during cruise they had a total loss of electrical power. Pilot called 911 on a cell phone and requested assistance in communication between fai tower and himself. Pilot landed @ fai with no incidentals. Further review…Incident 20040722016219IBeech C99 · Wolf Point, MT(-23) On takeoff at Wolf Point, Montana, a deer ran into the left engine, with damage to propeller, engine, and cowling.Accident 20040722015189ACessna T210L · Columbus, TX(-23) Pilot attempted to take-off and did not correct for torque. Aircraft left runway prior to becoming airborne. Abort was not performed. Aircraft proceeded to impact ditch and inverted.Accident 20040722015019APiper J5A · Kotzebue, AK(-23) As pilot was departing runway 17 in Kotzebue, the aircraft started turning to the left. Pilot applied right rudder to correct the problem, without success. Pilot then increased right rudder pressure and attempted to abort takeoff. Right brake locked up.…Accident 20040721035669ACessna 182R · Mitchellville, MD(-23) Pilot was receiving duel night instruction. Pilot flared too high and dropped in from about 15'. Flight instructor was [privacy data omitted]Accident 20040721031379AAmtr STOLCH801 · Erie, CO(-23) The pilot was conducting an initial test flight and had completed ten take-offs and landings on runway 33. Just after turning downwind from crosswind following the eleventh take-off, the engine power dropped to less than half. Unable to maintain pattern…Accident 20040721029239ABell 206B(-23) On July 21, 2004 at 08:22 a.m., aircraft N133RT a BHT-206B was inbound to grand chenier, Louisiana with 2 passengers. Aircraft lost power and crashed into the gulf of Mexico.Accident 20040721028219ALuscom 8A · Merrill, WI(-23) Instructor and student were performing touch and goes on runway 34 at Merrill, WI (rrl). After third landing, student applied power for takeoff. Once airborne, aircraft yawed to the right and the student released the controls. The instructor assumed…Incident 20040721024679IPiper PA28R200 · Lebanon, TN(-23) Pilot departed 4TN9 to M54 at 3 pm CST. Upon departure, the gear in transit light remained lit. Upon reaching 2500 MSL pilot began cycling gear. Gear transit light would not go off. Pilot contacted memphis approach and informed them of problem. Pilot…Accident 20040721022859ACessna 182P · Marco Island, FL(-23) On July 21, 2004 at Marco Island executive airport (mky) FL aircraft attempted a touch and go maneuver. Aircraft encountered a hard landing so severe it bent forward the nose landing gear. Investigation of aircraft damage was not performed due to the…Incident 20040721020559IBoeing 73783N · Chicago, IL(-23) ^^Industrial incident-no intent to fly. During a thunderstorm on JULY21, 2004 at 1715 local time ata aircraft N301TZ, a Boeing 737-800 parked at gate A4A weathervane in the wind while parked and chocked. The aircraft rotated clockwise, moving the nose…Incident 20040721018649IBlanca 1730A · Napa, CA(-23) This flight was Mr. Bailey's bfr. Mr ross was the CFI. Both reported that the landing gear would not full retract after take-off. The landing gear also failed to fully extend when commanded. The landing gear collapsed during landing on runway 24, Napa…Accident 20040721018499APiper J3C65 · Palmer, AK(-23) On July 21, 2004, Mr. Ronald hills was the pilot in command of N3458N a PA-J3. Mr. Hills departed VFR from a remote strip located at N61.28W 148.50. During the climb at approximately 500 AGL flying into a 20 mph wind, he made a turn against a canyon…Accident 20040721017019ACndair CL6002B19 · Snowhill, MD(-23) While cruising at flight level 290, a TCAS ra was observed by flight crew. First officer (fo) was pilot flying. Fo disconnected autopilot and initiated TCAS escape maneuver. Captain assumed command of aircraft and initiated greater rate of climb. At…Accident 20040721015859ASwrngn SA226T · Rifle, CO(-23) Airplane was departing from Rifle, CO to lafayette, LA. Flight crew continuous alcohol/water injection (cawi) for take-off. Flight crew indicated that the right engine torque meter was reading 100% and the left torque meter was reading 85%-95%. About…Incident 20040721015389ICessna 172M · Weatherford, TX(-23) Airman deviney was doing a supervised solo landing, instructor larry dial, watching from the side of the runway. The incident occurred at Parker County Airport on July 21, 2004, approximately 1500 local time. Upon touchdown, the aircraft, (N1272U,…Incident 20040721015299IAirtrc AT301 · Edna, TX(-23) During aerial application of chemicals the aircraft engine shut down due to fuel starvation. The pilot landed the aircraft in an open field and it flipped upside down during landing. There was damage to the propeller, r/h landing gear, r/h aileron…Accident 20040721014669AAmtr EXEC162F · Cameron Park, CA(-23) Pilot departed Q61 heading south. Started to turn southeast when a loud "bang" noise was heard and then the engine backfired. Debris was reported falling to the ground. The rotorcraft inverted and crashed into a house and was engulfed in flames. The…Incident 20040721014149ICessna 421B · Portland, OR(-23) After aircraft departed Portland Oregon (pdx) approx. 30 minutes into the flight smoke started filling the cabin. The pilot secured electrical systems and asked controllers to return to pdx. The controllers gave N1942G priority handling and the aircraft…Accident 20040720035429ACessna 172S · Winder, GA(-23) Acft departed canton, GA (47A) enroute to Winder (wdr), the pilot had to hold right rudder to keep it centered. On touchdown he continued to hold right rudder and when the nose wheel touched down, the acft veered off the runway ot the right. After…Accident 20040720022899AAmtr Rotorwayexec · Conroe, TX(-23) On 20 July 2004 at appx 1836 local time at the lone star executive airport (cxo) Conroe, TX 7730. An experimental home built rotorway executive helicopter registered as N342RD; s/n 4162 experienced a hard landing after the engine stopped. The pilot…Incident 20040720020449IPiper PA16 · Urbana, IL(-23) [privacy data omitted] the pilot of N5655H reported that as he accelerated for takeoff on runway 27 at Urbana-Frasca field, the aircraft tail had just come up when the aircraft veered off the north side of the runway and entered some standing corn in…Accident 20040720019259APiper PA25235 · Baldwin County, AL(-23) On July 20, 2004, a Piper PA-25-235, N7222Z, registered to seair aerial advertising, LLC, crashed while attempting to pick up a banner at a private air strip in foley Alabama. The pilot reported while trying to pick up a banner on the first attempt he…Accident 20040720016069ACessna P210N · Douglas, WY(-23) While descending from 22,000 feet AGL the engine stopped running due to a broken crankshaft forcing an unplanned landing.Incident 20040720015889IMooney M20F · St Anthony, ID(-23) Around 1630 MST the pilot was practicing crosswind take-off and landings. He attempted to land the airplane on runway 22 and was coming in a little hight. The airplane dropped and "bounced" onto the runway two times before a "go-around" was initiated.…Incident 20040719020199IPiper PA44180 · Rochester, MN(-23) While doing simulated single engine work in pattern at Rochester international airport (krst) pilots waited on gear until landing assured. Crew of two flight instructors became preoccupied with approach and failed to extend gear. Pilot on controls…Incident 20040719016389IFrchld 24W40 · Casa Grande, AZ(-23) On July 19, 2004, at approximately 0900 local, Mr. Michael still was pilot-in-command of N28648, a fairchild 24W-40, and performing touch and go landings at Casa Grande Municipal Airport (cgz) for currency. On the second approach and landing, upon…Incident 20040719015659IBeech C90A · Omaha, NE(-23) On July 19, 2004, at approximately 0330 CDT, Beech king air C90A, N242EM, sn: LJ-1351, experienced an unsafe down and lock indication for the RH main landing gear. Following several landing gear cycles, the aircraft landed without incident at Eppley…Incident 20040719015289IPiper PA28140 · Sallisaw, OK(-23) On July 17, 2004, a Piper, PA-28-140 experienced a loss of power after taking off from the Sallisaw Municipal Airport. The pilot reported he was conducting touch and go flight operations with 2 passengers on board. During the last touch and go, during…Accident 20040719015139ACessna 182J · Farmington, NM(-23) On July 19, 2004, at 1455 MST, a Cessna 182J, N2602F, made a hard landing at Four Corners Regional Airport, Farmington, new Mexico. Visual meteorological conditions prevailed at the time. No flight plan was filed. The aircraft sustained substantial…Accident 20040719014569AAgusta A119 · Big Bear City, CA(-23) The purpose of the flight was to demonstrate the aircraft to the local sheriffs department. The pilot in command, a certificated helicopter flight instructor, loaded the helicopter to its maximum allowable gross weight at the rialto airport in…Accident 20040719014549ALear 55LEAR · Ft Lauderdale, FL(-23) Lear jet N55LF departed the ft. Lauderdale int'l. airport (fll) for a re-positioning FAR 91 VFR ferry flight to the ft. Lauderdale executive airport (fxe). The fxe tower cleared the aircraft to land on runway 31. The issued wind was 230 variable 300 at…