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 19990902028269IPiper PA32R300 · Roanoke, VA(-23) On 09/02/1999, at 2345 EDT, as the pilot began the approach to runway 24 Roanoke airport (roa), the landing gear was lowered, but only two gear came down. The left main gear remained in the up position. Upon further investigation, it was determined that…Incident 19990902027569ISwrngn SA227AC · Anchorage, AK(-23)On approach into Anchorage, extended ldg., got a green light on nose and left MLG, red light on right MLG. Recycled gear 2 more times with same results. Had to cancel approach and did a go around. Cycled gear one more time with same results. Accomplished…Accident 19990902026179AMooney M20D · Bear Valley, CA(.19) On September 2, 1999, between 1138 and 1245 hours pacific daylight time, a Mooney M20D, N6831U, owned and operated by the pilot, descended into mountainous terrain about 10 nautical miles east-northeast of Bear Valley, California. Visual meteorological…Incident 19990902025529ICessna 152 · Woodland, WAPrivate pilot landed at Woodland airport. During landing rollout, aircraft departed the hard surface onto a grass area and struck a fence. Pilot was practicing touch-and-goes. Pilot reported crosswinds on landing. No damage to fence. Minor damage to outboard…Accident 19990901047669AAyres S2R · Cairo, GA(.4) Shortly after liftoff from the runway, the engine backfired and lost power. An eyewitness at the airport reported seeing black smoke coming from the airplane during the attempted takeoff. The pilot turned right and selected a field for the emergency…Accident 19990901047139ABeech J35 · Union, OR(.4)The commercial pilot was landing the aircraft on a remote grass runway. Shortly after touch down, the aircraft rolled over a rut, and the airplane veered to the right of the runway. The pilot stated that he was unable to correct the situation and the…Accident 19990901046699APiper PA18 · Cordova, AK(-23) On September 1, 1999, at approximately 1900 local time, alvin fulton acting as pilot in command of a PA-18, attempted a takeoff from a riverbank near clear creek. He reported that the left wing contacted an alder bush during takeoff causing the aircraft…Accident 19990901045989AHughes 269C · Utica, NY(-23) No narrativeAccident 19990901044919APiper PA28181 · Villa Grove, CO(-23) The accident airplane was one in a flight of three airplanes being used to train fbi pilots in mountain flying techniques. According to the other two fbi agents, they came through hayden pass and turned north. They were to practice turning around in…Accident 19990901042539ABell 206B · Delhi, CA(.4)The pilot reported that the engine RPM began decreasing during the takeoff climb, about 200 to 300 feet AGL, while he was over a grove of trees. He extended his autorotative glide to make it past the trees, which resulted in a further decrease of main…Incident 19990901035439IBeech 58 · Harrisburg, PA(-23) Pilot informed ATC shortly after takeoff from 29D (grove city, PA) that he had a landing gear problem. Nose gear was not locked and main gear status (locked/not locked) unknown. Pilot elected to land cxy (Capital City pa), runway 08, gear-up. Aircraft…Incident 19990901035399IDoug DC1030F · Newark, NJ(-23) On departure from ewr the aircraft lost a leading edge faring. It continued to its destination and landed at mem without incident.Accident 19990901031789ASukhoi SU29 · Fort Lauderdale, FL(.19) On September 1,1999, about 0930 eastern daylight time, a Sukhoi SU-29, N52PB, registered to aerial three inc., impacted with the ground near unincorporated Fort Lauderdale, Florida. Visual meteorological conditions prevailed at the time, and no flight…Incident 19990901031439IScwzer SGS126D · North Plains, OR(-23) This office determined that dale l. archibald was the pilot in command and sole occupant of a SGS-1-26D glider that landed short of North Plains glider airport on Oregon highway 26. At the time of the incident, Mr. Archibald was a private pilot with a…Accident 19990901030729APiper PA12 · Neguanee, MI(.19) On September 1, 1999, at 2030 eastern daylight time, a Piper PA-12 floatplane, N91901, was destroyed when it impacted a 200 foot communications tower located 1/4 mile from the intended landing site on dead river basin, Neguanee, Michigan. The private…Accident 19990901030449ACessna 150L · Midland, MI(.19) On September 1, 1999, at 2000 eastern daylight time (EDT), a Cessna 150L, N1316Q, operated by a solo student pilot sustained substantial damage when during landing the airplane struck the ground hard and came to a stop 100 feet left of runway 24 (3800'…Incident 19990901029629IPiper PA34200 · Akron, OH(-23) Aircraft c-grak landed rwy 1 on roll out the nose gear collapsed.Incident 19990901028769IPiper PA28180 · Marquette, NE(-23) Pilot departed grand island, NE, for davenport, IA, on a VFR flight at 1845Z on 09/01/1999. 14 miles east of grand island, the aircraft lost vacuum instruments. Pilot reported power loss and elected to land in a milo field resulting in minor damage to…Accident 19990901027719AAmtr RV4 · Bayfield, CO(.19) On September 1, 1999, approximately 1105 mountain daylight time, a wroblewski RV-4 homebuilt, N95PW, was destroyed following an in-flight collision with terrain while maneuvering 6 miles northeast of Bayfield, Colorado. The private pilot and one…Accident 19990901027699ABbavia 11AC · Heber, UT(.19) On September 2, 1999, approx. 0800 mountain daylight time, an Aeronca chief (11AC), N86096, was substantially damaged during takeoff when the left wing strut impacted an airport sign at Heber ciy municipal airport, Heber city, Utah. The private pilot,…Accident 19990901026399AHughes 369HS · Pacific Ocean, Guam(.19) On September 1, 1999, about 1000 hours local ship time, a Hughes 369HS, N42054, crashed into the Pacific Ocean about 1200 miles southeast of guam under unknown circumstances. The helicopter, operated by hoffman helicopters, inc., of yona, guam, was…Incident 19990901025509ICessna U206A · Taylor Mountain, AKMr. King was hunting in the Taylor Mountain area, and was wanting to return to palmer. Called and received a weather briefing from the ena automated fss thru the sparevohn remote. Merrill pass was reported closed and the weather was good at illiamna and…Incident 19990901025259IN97ME · Tacoma, WAPilot was conducting a test flight. The digital checklist/audible warning system (ed 100), had not been programmed. Therefore, the gear warning system was not yet operational. During landing the pilot neglected to lower the gear. The aircraft contacted the…Incident 19990901025039IMooney M20E · Torrance, CAOn 9/1/99, doug bombard, owner and PIC of Mooney M20E, N7842V, attempted to extend his landing gear while on a 45 degree approach to Torrance airport. Mr. Bombard discovered that the handle would only go half way down and flew out over the water to cycle the…Accident 19990831047599APiper PA28235 · Boulder City, NV(.4) The student pilot was departing with a left crosswind that he estimated to be 8 to 10 miles per hour. He said during the takeoff roll, about 55 miles per hour, as he was starting to raise the nose he heard a loud popping noise. That was followed by the…Accident 19990831046139APiper PA34200 · Plymouth, MA(-23) Aircraft conducting multiengine training, and during a single engine operation a go-around was attempted while on approach to rwy 06. Aircraft rolled right, caught right wingtip and cartwheeled. Aircraft destroyed by post crash fire.Accident 19990831042799APiper PA28180 · Colorado Spring, CO(-23) Low level wind shearIncident 19990831035429IGulstm 680FL · Morristown, NJ(-23) Mr. Bechara lost power on the left engine while in cruise flight VFR at 6500 feet and shut the engine down. He asked N90 for radar vectors to the nearest airport and landed at Morristown, NJ airport without further problems. The aircraft had a broken…Incident 19990831032959IPiper PA28140 · Clanton, AL(-23) Pilot stated that engine quit while doing maneuvers. Attempts to restart engine by switching fuel tanks and using primer failed. Pilot chose a hay field and made an emergency landing, was unable to stop before hitting a fence. Damage to the left wing…Incident 19990831028749IArctic S1B1 · South Naknek, AK(-23) Reports indicate pilot made a hard landing 165 feet inside landing threshold on runway 12 resulting in total landing gear failure. Attempts to interview pilot thus FAR have been unsuccessful. Photo attached.Accident 19990831028479ACessna 152 · Baker, FL(.19) On August 31, 1999, at 2200 central daylight time, a Cessna 152, N5377L, landed long and ran off the departure end of runway 27, at a grass airstrip in Baker, Florida. The flight was operated by the flight instructor under the provisions of title 14 CFR…Incident 19990831027359IPiper PA31P · Rogers, AR(-23) The pilot stated that during landing the aircraft touched down at a normal speed and within the first 1,000 feet of the runway. He added that he felt the left brake did not work a well as the right causing the aircraft to veer off the runway and into a…Incident 19990831027279IBell 205A1 · Lydia, TX(-23) Pilot stated he came into dipsite (water pond) with "bambi" bucket on belly hook. He filled bucket on belly hook and had cleared bottom of bucket by about 2 to 5 feet. Aircraft had sudden yaw and engine audio and engine out light activated. Low rotor…Incident 19990831026029ICndair CL6002B19 · Indianapolis, INAircraft N936CA declared an emergency, and landed at Indianapolis, Indiana internation airport. Pilot logbook writeup stated: "on climb out autopilot was engaged and had an autopilot pitch trim and nose down message come on. The copilot disconnected the…Incident 19990831025579ICessna 152 · Shelby, NCThe pilot was doing step turns and power off stalls. Pilot decided to do a power on stall. After the nose dropped the engine lost power and started running rough. Pilot tried to recover power but could not. Headed back to the a/p and decided he was not going…Accident 19990831025389APiper PA12 · Skwenta, AK(.19) On August 31, 1999, about 1450 Alaska daylight time, a tundra tire equipped Piper PA-12 airplane, N3824M, sustained substantial damage while landing at a remote area, about 53 miles west of skwentna, Alaska, at latitude 62 degrees, 03.978 minutes north,…Incident 19990831019119IAmtr Mong · San Diego, CA(-5)Aircraft lost power (engine quit) moments after takeoff from rwy 28R at myf. The pilot stated the taxi out and static runup were uneventful. Furthermore there was no other indications prior to the power loss (I.e. backfiring, sputtering, etc...). The…Accident 19990830047559AAmtr ROTORDYNE200 · Kent, WA(.4) The co-owner/builder had been engaged in resetting the angle of attack (pitch angle) of the main rotor blades previous to the accident. Witnesses reported observing the gyrocopter depart to the south, proceed west, and then execute several oscillatory,…Accident 19990830047159ACessna A188B · Seminole, TX(.4)During the landing roll, the agricultural airplane departed the right side of the runway, rolled into soft terrain, and subsequently nosed over to the inverted position. The pilot reported that during the landing roll, his seat became dislodged from the…Incident 19990830035019ICessna 152 · Cameron Park, CA(-23) Pilot was approaching rwy 13 at Cameron Park. During the flare he pulled back excessively on the control causing the airplane to balloon and float down the runway. After that, a heavy sink rate was developed which caused a hard landing. The airplane…Incident 19990830034709IBeech C23 · Kansas City, MO(-23) PIC stated that the airplane began "porpoising" during her landing. The aircraft contacted the runway twice before she pushed the nose down to level out. The airplane drifted to the left due to a cross-wind, and the nose gear contacted the runway. PIC…Incident 19990830028339ICessna 152 · Livermore, CA(-23) The student pilot was practicing touch and go landings. He made a three point landing on 25R with wind from his left, as he opened the throttle to continue the touch and go, a wind gust from the left caused the tail to move right, turning the plane…Incident 19990830027979IPiper STCJ3 · Fernandina Beac, FL(-23) While descending to 1600 feet, the aircraft engine began running roughly. Carburetor heat was applied but the engine continued to run roughly. Emergency landing accomplished on sand bar adjacent to bird island. The right main gear dug into the sand upon…Incident 19990830027289ICessna 177RG · Lufkin, TX(-23) Aircraft landed with gear up. When I arrived the gear handle was down and both lights were operational with the circuit breaker being popped. It was determined that a wire was broken at the motor which allowed it to run continuously until it popped the…Accident 19990830025499APiper PA24 · Minneapolis, MN(.19) On August 30, 1999, at 1145 central daylight time, a Piper PA-24, N6606P, piloted by a private pilot sustained substantial damage during a gear up landing on runway 27R (3,599 feet by 75 feet, dry/asphalt) at the Flying Cloud Airport, eden prairie,…Incident 19990830025289ICessna A188A · Wolfpoint, MTPIC stated that on landing on Private grass landing strip, the wind started pushing aircraft to the right. A correction was made with pedal and brakes. This resulted in the left gear breaking away from the aircraft and the aircraft ground looped to the left.Incident 19990830025129ICessna 172P · San Jose, CAAfter completing the before takeoff checklist, runup, and receiving takeoff clearance, miss krueger and Mr. Walker departed runway 29. They applied full power for takeoff and during climbout, around 400 feet, the aircraft began to shake and a reduction in…Incident 19990830025119IDoug DC931 · St Louis, MOPrior to push back, contract maintenance changed the left quantity fuel guage, push back was on time. Three miles out, the left aircraft engine indicated a fire. Crew shut down engine, declared an emergency, and returned to stl. Aircraft landed and upon…Incident 19990830025089IBell 47G2A · Walnut Ridge, AROn August 26, 1999, helicopter N8484E, a Bell 47, operated by a.a.c. flying services, a 137 certificated operator, and piloted by rick meeks, contacted a powerline 3 miles south of porti, AR., the a/c landed with damage to the bubble, right fuel tank vent,…Accident 19990829046509AN3255Y · Jonesboro, AR(-23)While on a glider pleasure flight with a non pilot passenger the aircraft struck a powerline. The pilot reported that his approach was inititally too high. He added flaps and extended spoilers in an effort to correct the high approach. Once established…