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 20040605012419AHughes 269C1 · Brentwood, CA(-23) Pilot was giving flight instruction to passenger/student, [privacy data omitted] including hands on of controls in a hover, approximately 3 feet off the ground, when he let the student have sole control of the cyclic control with himself (the pilot)…Incident 20040605010719IMaule M5235C · Fife Lake, MI(-23) Pilot reported that he had just landed and was coming off the step when the wake of a personal watercraft swamped the right float and the airplane flipped over in the water. Witnesses stated that the aircraft was moving very slowly when the large wave…Accident 20040605010229AScwzer G164B · Midvale, ID(-23) The pilot was spraying alfalfa flying east and west in rolling terrain, while flying under high voltage powerlines/towers. On the last pass witnesses observed the aircraft fly into the two lowest wires. As a result, the pilot lost control of the…Accident 20040605010189ACessna 150B · Benton, AR(-23) On 06/05/2004, student pilot Mr. Stan warrick was receiving flight instructions from Mr. Tom looker, at the Saline County Airport in boston, AR. (M99). Approximately 1600 CDT, Mr. Stan warrick was on his solo flight and was performing touch and go…Accident 20040605010109AN1852N · Caldwell, ID(-23) This Kitfox was built by the owner/pilot. The aircraft received a special airworthiness certificate on April 24, 2004, in the experimental amateur-built category. It had been operated 10.1 hours since it was built. During takeoff the elevator control…Incident 20040605008839ICessna 172L · Pickens, SC(-23) PIC reported that during landing rollout a deer hit the aircraft on the right side causing damage to the right aft fuselage and the right horizontal stabilizer. No further malfunctions or defects reported.Accident 20040604029639ABoeing 7377H4 · Liberal, KS(-23) On June 4, 2004, at 1817 central daylight time, a Boeing 737-7H4, N757LV, operated by southwest airlines co., as flight 2297, encountered turbulence approximately 15 nautical miles southeast of Liberal, KS, during cruise flight at flight level 370. One…Incident 20040604025379IBeech A45 · Rockford, IL(-23) Aircraft left rostrauer, pa where spar AD and annual was performed. Landed in lima, OH, pilot heard a mechanical sound when gear was extended but landed without incident. He then departed for poplar grove, IL. He attempted to lower the gear, but he…Accident 20040604017599ATcrafk DC65TCRAFT · Savannah, TN(-23) On June 4, 2004, aircraft N39190 crashed approximately 5 to 8 land miles from the hardin county airport in Savannah, TN. The pilot told the medical personnel who responded to the scene that he had run out of gas. Asi's later received a written statement…Accident 20040604016779ACessna 172P · Milwaukee, WI(-23) On June 4, 2004, at 1510 CDT, a Cessna 172, N50923, registered to gran aire, inc. lost directional control while practicing crosswind landings on runway 4 left at Lawrence Timmerman airport, Milwaukee, Wisconsin during a student training flight. The…Accident 20040604016709ANamer T28C · Manitowoc, WI(-23) On June 4th, 2004, at 1810 CDT, a north American T-28C, N404DK, registered to duane d. kalember of traverse city, Michigan lost power on climb-out after takeoff from runway 35 at Manitowoc County Airport, Manitowoc, Wisconsin. The aircraft sustained…Accident 20040604014379APiper PA18150 · Columbus, MT(-23) Second attempt at landing in Columbus (6S3), Montana, with 10 degrees of flaps. Touched down in crosswind conditions. Crosswind resulted in veering of aircraft to right. Pilot induced full power. Wind continued to move aircraft right of runway. As…Incident 20040604013919ICessna 175 · Blissfield, MI(-23) Mr. Thompson was flying the aircraft and failed to stop the aircraft on the grass strip runway. Aircraft departed the west end of the runway, crossed a public road (pence highway-a two-lane dirt road), and stopped in a ditch. Aircraft sustained damage…Incident 20040604013879IPiper PA24250 · Michigan City, IN(-23) Pilot became preoccupied during adjustment of prop governor settings. Failed to lower landing gear for landing.Accident 20040604013249AAirtrc AT301 · Cotton Plante, AR(-23) June 04, 2004 at approx. 18:30 CT N3166U, an AT-301-301 air tractor operated by southern aire of Cotton plant, Arkansas was substantially damaged when the pilot robert ferguson made an emergency landing in a cultivated field. The flight was under visual…Incident 20040604012779ILear 35A · Fairbanks, AK(-23) The pilot reported damage to the l/h wing tip tank after landing at anc. The aircraft's l/h wing had dipped on takeoff from fai, and unknown to the pilot, hit two runway lights 1500 feet down the runway. Later, the aircraft was taxied at different…Incident 20040604012319ISocata TBM700 · Wichita, KS(-23) The pilot stated that he landed approximately 6 feet short of the beginning of the runway. The landing blew the left main tire and resulted in wrinkled skin, a popped rivet, and a fuel leak on the left wing.Accident 20040604010549ACessna T210L · Wichita, KS(-23) During approach to runway 19L at Wichita Mid-Continent, the engine failed due to fuel starvation. A forced landing was made to a flood control diversion ditch short of the runway and off the airport. The aircraft was returning to it's home base in…Incident 20040603020049IEMB EMB135KL · Norfolk, VA(-23) At 1642EDT, flight 4876 diverted and landed on runway 02 at orf due to a number 2 engine shut down. The ARFF responded and the aircraft taxied to the ramp without further incident. The engine was shut down in flight due to the number 2 engine…Accident 20040603017449ANamer T28B · Tampa, FL(-23) Aircraft impacted trees/terrain shortly after departure from runway 32. The aircraft was destroyed and no post fire occurred. There was fuel spillage at the impact site and fuel in the fuel lines. Visual meteorological conditions existed at the time of…Incident 20040603014219IAmtr Lancaires · Roanoke, TX(-23) On June 3rd, 2004 at approximately 1020 local time, pilot in command Mr. Harry r. gurno ii operated Lancair, N764ES during landing at Northwest Regional Airport, Roanoke, Texas. Upon landing on runway 35, N764ES tracked to the left and came to a stop in…Accident 20040603013459ABeech M35 · Strafford, MO(-23) On June 3, 2004, at 1215 CDT, while enroute from perry county municipal airport (tel), tell city, Indiana to tulsa, Oklahoma (tul), the pilot stated the engine failed at 8000 feet. A forced landing was conducted off airport approximately 18 miles north…Incident 20040603012069IMooney M20M · Prescott, AZ(-23) Had been on IFR flight when cleared into traffic area for landing runway 21L at prc by tower. Several other aircraft in traffic pattern. Pilot stated had altitude alert set for higher altitude then traffic pattern altitude (tpa), which sounded as…Incident 20040603011979ILear 55LEAR · Lexington, KY(-23) N550AK upon landing it was determined that their speed was too great to stop the aircraft in time to stay on the runway. After skidding from the runway 22 the aircraft became stuck in the mud. No injuries minor damage.Incident 20040603011769IPiper PA24250 · Provo, UT(-23) Upon landing right main gear collapsed. Minor damage to aircraft no injuries.Incident 20040603011739IBell 47G · Hawthorne, CA(-23) Air traffic was notified vaughn eric dobalian, the pilot of Bell 47G, serial number 1084, N4115A, that he was declaring an emergency due to difficulty controlling to aircraft. Upon landing, Mr. Dobalian inspected the aircraft for damage that may cause…Incident 20040603011449IAmtr LANCAIR360 · Bremerton, WA(-23) Two commercial pilots, both with flight instructor ratings, were on a personal flight and landing rw 17L at cos. The flying pilot, Mr. Cox, had landed and was on the roll out with the intention of making another takeoff. The non-flying pilot, Mr.…Incident 20040603011419ICessna 172N · Houston, TX(-23) On June 3, 2004, approximately 17:48 CDT, a CE-172-N, N75897, received no damage when the PIC (student pilot) Mr. Michael e. watts veered to the left, and departed the runway surface approximately 1500 feet down runway 17 at Sugar Land airport (ksgr).…Accident 20040603011289ALet L13BLANIK · Durango, CO(-23) During maneuvering for landing the aircraft stalled and crashed.Accident 20040603011242AAirtrc AT502B · Weldon, AR(-23) On June 3, 2004, at 1800 CDT, an air tractor, AT-502B, N6068H, had just touched down/landed when air tractor, AT-502B, N5002D, landed on top on N6068H, near Weldon, Arkansas, on a private grass and asphalt runway. N6068H had executed a straight-in…Accident 20040603011241AAirtrc AT502B · Weldon, AR(-23) On June 3, 2004, at 1800 CDT, an air tractor, AT-502B, N5002D, collided with air tractor, AT-502B, N6068H, during the execution of a landing near Weldon, Arkansas, on a Private grass and asphalt runway. N6068H had executed a straight-in approach while…Incident 20040603010349IMaule M4210C · Durango, CO(-23) Tailwheel bearing seized on landing causing aircraft to ground loop.Accident 20040602021169ACessna 182C · Kutztown, PA(-23) The tow plane and glider departed runway 17. At approximately 150' AGL, the glider pilot suspected problems with the tow plane and released the tow rope from the glider. The glider made a turn to the left and then circled and made a landing onto the…Incident 20040602020029IEMB ERJ170100 · Syracuse, NY(-23) On June 2, 2004, usaa flt. 1610, ERJ-170, departed pit to syr, declared an inflight emergency enroute to syr due to an electrical odor in the cockpit. The aircraft landed at the Syracuse Hancock International Airport, Syracuse, NY. The ARFF responded…Accident 20040602017609APiper PA28181 · Dunsmuir, CA(-23) During landing at the Dunsmuir airport, California, the airspeed was fast and the approach was high. The airplane landed long and departed the end of the runway. The airplane was substantially damaged and the pilot was not injured.Accident 20040602014339ACessna 180E · Kenai, AK(-23) N5180, Cessna 180E, received substantial damage during an aborted take-off. The pilot said the winds were very gusty and as the aircraft started to turn in left, he pulled the power off. The aircraft ground looped and nosed over. (-23 additional…Accident 20040602009699ACessna A188A · Minden, NV(-23) The pilot was accomplising a self-checkout in the aircraft that is equipped with only one seat. The pilot lost control when he reduced power during a wheel landing. The aircraft veered off the runway and came to rest with the right main landing gear…Incident 20040602008609IAmtr Murphyrebel · San Jose, CA(-23) Pilot stated that he was having a problem with a new electronic ignition system in his aircraft. A new control unit and magnitos were installed and tested good. On the day of flight the system checked normal during the preflight and elected to fly the…Incident 20040601019889IMooney M20C · Newport News, VA(-23) On June 1, 2004, at approximately 1203 local, Mr. Frederick r. carter, as PIC of Mooney-20-C, N5913Q, taxied from hangar 9A at Newport News/Williamsburg International Airport (phf) to the active runway. While on the taxiway leading from the ramp, Mr.…Accident 20040601012239ACessna 150 · Midland, MI(-23) Student pilot on his second solo flight was landing at Midland airport on runway 24 after touchdown the aircraft bounced and came down hard on the right wing, the right landing gear sheared off, the fuselage bent as well as the horizontal stabilizer,…Accident 20040601011619ACessna U206F · Owatonna, MN(-23) Investigation revealed that the aircraft's left wing contacted the roof of a house at a very high angle of attack causing the aircraft to impact the ground at a high rate of speed. Note: will amend sections 23, 24, 25, 29, 31 and 42-3/4/8/9 when…Accident 20040601011279AScwzer G164 · Rexburg, ID(-23) While spraying the pilot executed a low level turn and collided with sprinklers.Accident 20040601011219APiper PA32300 · Leominster, MA(-23) On June 1, 2004, about 2130 EDT, a Piper PA-32-300, N21072, was destroyed when it impacted terrain in Leominster, MA during a GPS approach to runway 32 at fitchburg airport (fit). The certificated private pilot and one passenger were fatally injured.…Accident 20040601011059APiper PA28151 · Cle Elum, WA(-23) On June 1, 2004 1045 local time a PA-28-151 piloted by Mr. Jeremy fradet and Mr. Edmond stilp received substantial damage following a crash into mountainous terrain near Cle Elum lake in the Washington cascades. Mr. Fradet was flying the aircraft from…Incident 20040601010759IPiper PA14 · Mckinley Park, AK(-23) [privacy data omitted] pilot reported 2 miles east of Mckinley Park airstrip he was experiencing engine problems. Oil temp red line 240 degrees f and cylinder head temp of 575 degrees f. pilot set float equipped aircraft down on unnamed small lake 5.9…Incident 20040601009639IAmtr RV6 · Norwood, MA(-23) [privacy data omitted] pilot picked up his aircraft from maintenance hanger after annual maintenance had been performed. Pilot was taxiing to his tiedown. As the pilot made a right hand turn to join a taxiway he struck a helicopter dolly. The helicopter…Incident 20040601009559IEirvon PIK20E · Frederick, MD(-23) During a soaring competition out of W54, the pilot encountered unexpected clouds and weather moving in. Pilot decided to land at fdk which was closest airport. The winds became more severe and he encountered downdrafts and rain so he opted to land in a…Incident 20040601009109IAmtr RV6A · Arlington, WA(-23) On June 1, 2004, at about 1530 PDT, a hutton RV-6A, suffered a hard landing onto runway 16 at Arlington, Washington, causing minor damage to the aircraft. The private pilot was not injured. The pilot stated that while on final an aircraft had entered…Incident 20040531033689IStbros SC7SERIES3 · Eloy, AZ(-23) Skydiver exited aircraft with others to complete large freefall formation with 100 jumpers. Once the formation was over all jumpers deployed their canopies. Eye witnesses stated that at approximately 500 feet the canopy that [privacy data omitted] was…Accident 20040531030589APiper PA28161 · St Marys, GA(-23) On may 31, 2004, at approximately 1330 UTC, N8149Q reported mayday with an engine failure over cumberland island, 10 miles south of brunswick, Georgia. The pilot derek fox, certificate #2819507, decided to land at the beach, during the landing the nose…