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 19991026030149ISwrngn SA227AC · Billings, MT(-23) On 10/26/99 at 0719 LCL MDT, a big sky airlines fairchild SA-227-AC, N159MC, experienced a hydraulic failure of the landing gear system. During landing, the flight crew selected gear down and the main landing gear failed to deploy. The crew manually…Incident 19991026029419IBag JETSTM3101 · Johnstown, PA(-23) The following narrative was developed through interviews with the flight crew of chautauqua flight 4203, the air traffic control tower (ATCT) personnel of the Johnstown-Cambria County Airport (jst), and a review of the air traffic control audio tape.…Accident 19991025047129ACessna 182B · Atlanta, ID(.4)As the aircraft touched down, it began to veer to the right side of the runway. In an attempt to correct the situation, the pilot applied full power and left rudder. Before the pilot could regain directional control, the aircraft's landing gear collided…Accident 19991025046889AN904PD · San Jose, CA(-23)On October 25, 1999 at approximately 1515 hours, officer desmond casey was in the process of conducting a ferry flight in aircraft N904DP, a mcdonald Douglas 500N notar helicopter. This aircraft was owned and operated by the San Jose police air traffic…Accident 19991025046299AN47BA · Aberbeen, SD(-23) Aircraft crashed in a swampy area near mina, SD. The aircraft was destroyed and two crewmembers and four passengers were fatally injured. The last air traffic communication with the aircraft was at approximately 0944 EDT northwest of gainesville, FL…Incident 19991025037549IAmtr CHRISEAGLE2 · Prescott, AZ(-23) During taxi pilot got nose wheel off edge of the taxi way, causing the prop to hit the concrete. Pilot stated it was "pitch dark and the taxi lights were not on", causing him to misjudge the turn.Incident 19991025035769IBeech A36 · San Antonio, TX(-23) During engine start, Mr. Eppes used the hot engine start sequence. When the engine started the throttle was full open. Mr. Eppes failed to arrest the moving aircraft and contacted a parked aircraft before stopping.Incident 19991025035709ICessna 210 · Denver, CO(-23) On 10/25/99 1225 local time while landing at a apa county airport engewood co nose gear collapsed. Cause of gear collapse under investigation for cause. If further evidence discovered will update.Accident 19991025033699ARobsin R22MARINER · West Boca Raton, FL(.19) On 10-26-99 at about 1720 EDT, a Robinson R22, N2285Z, registered to vally aviation inc. and operated by volar helicopters inc., landed hard and flipped over while attempting a left 180 degree autorotation maneuver while on a 14 CFR 141 instructional…Incident 19991025033579IBoeing 737322 · Lincoln, NE(-23) N365UA, a B-737-300 being operated as united airlines flight 1660 enroute denver, CO, to philadelphia, PA, on October 25, 1999, diverted into Lincoln, NE, after the crew received an oil filter by-pass light illumination. The light extinguished upon…Incident 19991025031019ICndair CL600* · Wichita, KS(-23) On October 11, 1999, at 16:44 local time, an experimental test aircraft experienced a blow-out on a main gear tire after touch-down on runway 19R at Wichita Mid-Continent Airport at Wichita, Kansas. Some damage was noted to the landing gear, but no…Accident 19991025030789ABeech D55 · Corona, CA(.19) On October 25, 1999, at 1600 hours pacific daylight time, a Beech D55, N7674N, veered off runway 25 during the takeoff ground roll and collided with a brick wall and a fence at the Corona, California, airport. The aircraft was owned and operated by the…Accident 19991025030459APiper PA34200 · Hopedale, MA(.19) On October 25, about 1020 eastern daylight time, a Piper PA-34-200, N16397, was substantially damaged while landing at the Hopedale Industrial Park Airport (1B6), Hopedale, Massachusetts. The certificated flight instructor, student pilot, and passenger,…Incident 19991025030169IMooney M20J · Easton, MD(-23) The flight instructor/commercial pilot was conducting a flight review to a private pilot. They conducted a visual (no view limiting device) GPS approach to runway 22 at Easton airport. On the procedure turn, the flight instructor observed the private…Incident 19991025029559IPiper PA28140 · Louisville, KY(-23) On October 25, 1999, a Piper PA-28-140 sustained minor damage as a result of a hard landing at the Louisville-Bowman airport, Louisville, KY. The solo student pilot was not injured and damage was contained to only the aircraft's propeller. According to…Incident 19991025029549IMooney M20J · Mitchellville, MD(-23)The pilot landed airplane on runway 36 (2,425 feet long, with a slight up slope). The pilot failed to stop airplane before reaching the end of the runway. The airplane continued past the end of the runway down a grass hill towards an airport perimeter…Incident 19991025029329IPiper PA28181 · King City, CA(-23) While landing at King City airport, King City, CA N181GP, a Piper 28-181 serial number 28-8490061, landed hard and struck the propeller. The pilot, unaware of the ground strike, applied power took off went around the airfield and landed a second time…Incident 19991025029289IDoug DC915 · Minneapolis, MN(-23) On landing the #3 wheel assembly departed the aircraft, investigation determined a standard sized axle nut was installed on an oversized axle, which allowed the axle nut to back off, thus allowing for wheel separation.Incident 19991024042059IGrumav TBM3EAIRTRD · Joliet, IL(-23) Aircraft landed at Joliet airport with the landing gear retracted. No one was hurt and the aircraft was jacked up and the landing gear was lowered normally. The pilot called the dupage FSDO and said he failed to lower the landing gear.Incident 19991024041209ICessna 172P · Gary, IN(-23) On October 24, 1999, at 1830 hours (EST), Cessna 172, N52062, was coming in for landing at Gary airport (gyy). The airport veered off to the left on runway 30 and the propeller struck the runway light. The student pilot decided to go around and…Accident 19991024040439AN1231 · Bremerton, WA(-23) Aircraft owned and operated by uncertificated, per-solo student pilot departed Boeing fiels (kbfi) for a dual instruction flight to Bremerton National Airport (kpwt). While practicing takeoffs adn landings at pwt, studnet pilot (owner) made a normal…Accident 19991024038249ABbavia 7ACA · North Little Ro, AR(.4) The 179-hour private pilot delayed abortin the takeoff from a 3,009 foot runway after she noticed that the takeoff roll seemed longer than usual. The airplane became airborne at 50 mph and climbed to approximately 50 feet AGL. The pilot became aware that…Incident 19991024037849IBoeing 727200 · Lincoln, NE(-23) N910PG, operated as transmeridian flight 342, landed in Lincoln, NE, after a flight from austin, TX. The pilot stated the departure and flight were uneventful. On approach to Lincoln, after the gear was down, the lst officer heard a thud. After landing…Accident 19991024037529APiper PA12 · Orange, MA(.4) The tailwheel-equipped airplane made an uneventful approach. Upon touchdown, the wind shifted about 50 degrees, and pushed the tail to the left. The airplane then ground-looped to the right, and departed the runway. The active runway was changed to the…Accident 19991024037229ACessna 172N · Crandon, WI(.19) On October 24, 1999, at 2145 central daylight time, a Cessna 172N, N4776E, collided with a deer on takeoff from runway 29 at the Crandon Municipal Airport, Crandon, Wisconsin. The private pilot and his passenger were not injured. The airplane was…Incident 19991024033829IPiper PA28180 · Warrensburg, MO(-23) On October 24, 1999, Mr. Jeremy j. kraemer operated Piper PA28-180, N7483W, as pilot in command on a flight from spirit of st. louis airport, st. louis, Missouri, to lee's summit airport, lee's summit, Missouri. At approximately 2000 CDT, Mr. Kraemer…Incident 19991024032869IBbavia 7ECA · Waukesha, WI(-23) The commercial pilot [privacy data omitted] was getting an aircraft check out just after a touch and go landing on the initial climb the aircraft suddenly veered to the right. The flight instructor [privacy data omitted] tried to gain control of the…Incident 19991024031519IMooney M20F · Ellensburg, WA(-23) Witnesses at the eln airport observed the aircraft during the landing and the gear appeared to be extended. Pilot charneski stated that the gear collapsed during the landing roll. The aircraft has a mechanical landing gear extension and retraction…Accident 19991024030669AAmtr Murphyrebel · St Johns, MI(.4) On October 24, 1999, at 1230 eastern daylight time, a welch murphy rebel, N8160X, built and piloted by a private pilot, sustained substantial damage on impact with trees during a go around on runway 25 (3,425 feet x 120 feet, dry/grass) at Schiffer Acres…Incident 19991024030009IMeyers MAC145 · Jackson, MS(-23) The flight was an instructional flight for the purpose of a conventional landing gear endorsement for Mr. Bobbitt. This was the 5th instructional session. During this session the CFI demonstrated one takeoff and landing, the next takeoff and landing was…Incident 19991024029829ICessna 172F · Cortland, NY(-23) On Sunday, October 24, 1999, at approx. 1640 local, a Cessna 172, co-owned and operated by walter a. dippo of Cortland, NY, reported an engine fire after taxiing to the run-up area at Cortland county airport (N03). During an interview with Mr. Dippo on…Accident 19991024028959AAmtr Speziosport · Mathis, TX(.19) On October 24, 1999, at 1752 central daylight time, a sturges spezio sport amateur built airplane, N75JS, was destroyed when it impacted power lines and terrain, and then collided with an automobile while maneuvering near Mathis, Texas. The airline…Accident 19991023047649ACessna 150F · Arecibo, PR(.4) The airplane came in low during final approach to landing. The left main landing gear impacted hay bundles and separated from the airplane. The airplane landed on the runway and during rollout, skidded for approximately 200 to 300 ft. the left wing…Accident 19991023047579AUnivar 1081 · Dallas, TX(.4) After the airplane touched down on runway 31, it veered right and departed the runway. The pilot applied power in order to avoid a ditch, and the aircraft turned left, crossed over to the west side of the runway and struck two posts of a barbed wire…Accident 19991023045119ACessna TU206A · Jeanerette, LA(-23) The pilot stated that the a/c lost power during the descent after completing a parachute drop. The pilot was able to restart the engine during the descent, but lost power again on downwind for landing. The a/c crashed short of the runway after the pilot…Accident 19991023043749APiper PA28161 · Lake Wales, FL(-23) A/c departed lal, with touch and go planned at X07 then direct mlb. Following touch and go, PIC experienced decreasing engine power and declared emergency on 121.5, ATC could not establish contact with a/c. PIC attempted to locate X25 for emergency but…Accident 19991023040759ACessna 172R · Aspen, CO(-23) On October 23, 1999 at 1248 mountain daylight time a Cessna 172R, N9548A impacted terrain during climb in vicinity of independence pass near Aspen co. the private pilot in command received fatal injuries and the two private pilot passengers received…Incident 19991023038719ICndair CL6002B19 · Fort Wayne, INWhile repositioning the aircraft from gate six to gate two, the left winglet made contact with the jetway and 17 inches of vertical wing tip was broken off from left wing.Incident 19991023034189IBeech E18S · Charlotte Amali, U.S. Virgin Islands(-23) During landing roll out the aircraft nosed over causing damage to both propellers and nose cone.Incident 19991023032019IPiper PA24250 · Lincoln, GA(-23) Aircraft leveled off at FL 9500, engine started to vibrate, then pilot had blue smoke in the cockpit. After shutdown, blue smoke dissapated. Pilot opted to shut engine down. Glided to cow pasture and landed. Pilot claims no damage to aircraft but oil…Incident 19991023031802IAmtr RV6A · Wenatchee, WA(-23) During a personal cross country flight, this aircraft was involved in a mid air collision. At the last instant noticed an aircraft covering most of the wind shield and took immediate evasive maneuver to avoid collision. Both aircraft sustained end wing…Incident 19991023031801ICessna 172P · Wenatchee, WA(-23) Dual training flight, practicing instrument approaches at Wenatchee, WA, aircraft was involved in a midair collision. Second aircraft approached from the right side, then immediately diving underneath. Both aircraft sustained end wing minor damage and…Accident 19991023031759ACessna 150B · Sweet Home, OR(.19) On October 23, 1999, about 1645 pacific standard time, a Cessna 150B, N1252Y, registered to and operated by the commercial pilot, was substantially damaged during an off-airport landing following an abrupt loss of engine power, one mile east of the…Incident 19991023031589IAmtr Skybolt · Lufkin, TX(-23) The pilot reported that upon approach to landing that a gust of wind caused him to go to the left of the runway where he hit a taxi sign with his left main and lefthand elevator. He applied power and went around. He then made his approach again and…Incident 19991023031529IBarneston, NE(-23) This uncertified individual was attempting a takeoff in an uncertified, unregistered ultralight gyrocopter. When he applied excessive nose up pitch control the vehicle over rotated. The rotor struck the ground to the rear of the vehicle. The vehicle…Incident 19991023031129ITmpson Navionb · West Chester, PA(-23) On October 23, 1999, at approximately 17:30 EDT, a ryan navion b, registered as N62A, while turning left base in the pattern, was forced to land in a uncultivated farm field, approx. 2 miles south east of Brandywine Airport (KN99), east goshen, PA. On…Incident 19991023030839IMooney M20K · Atlantic City, NJ(-23) [privacy data omitted] the Mooney had damage to his wing tip, nav lite and lents. Witness statements prove that the pilot of N231HE, walter cooper, did in fact collide with another aircraft and he also removed parts off of N3438W, to repair his own…Accident 19991023030589AAmtr Avidflymkiv · Sea Brook, TX(-23) The pilot experienced a rough running engine and elected to make an emergency landing. He landed downwind on a road situated in a pasture. He lost control during braking and ran off the road. The nose gear collapsed and the aircraft flipped over. No one…Incident 19991023029859ICessna 172M · Reading, PA(-23) Student pilot on landing at the Reading airport (rdg), runway 31, made a hard landing, knocking the front nose wheel off and damaging the propeller, which struck the runway on roll out. Student pilot (michael cooney) was counseled at the allentown…Accident 19991023029659ABell 206L4 · Santa Clarita, CA(.19) On October 23, 1999, at 1115 hours pacific daylight time, a Bell 206-L4, N36R, landed hard and rolled over in the Lake Piru riverbed near Santa Clarita, California. The helicopter, operated by ag aviation, teterboro, new jersey, was substantially…