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 20070813018509ABell 206L3 · Gulf Of Mexico, US(-23) While enroute to an offshore oil platform, N85TC, a Bell helicopter 206L-3 operated by evergreen helicopters, in galveston, Texas. The pilot did not refold and sat in the backseat a large (3'X4') sunshade. He completed the first leg of the trip without…Accident 20070813017569AMaule M5180C · Cane Creek, AK(-23) Aircraft crashed into the side of steep mountainous terrain 4500 feet above sea level on Cane Creek, Alaska (n 68.43.8 w 145.15.77). Aircraft wreckage burned on impact and aircraft is completely destroyed. 2 fatal. [privacy data omitted]Accident 20070813017499ARobsin R22BETA · Tucson, AZ(-23) On 08/13/2007 at approximately 11:15 MST N453SH, a Robinson R-22 helicopter, piloted by the flight instructor [privacy data omitted] on an instructional flight with the student pilot [privacy data omitted] was maneuvering in an open desert area…Incident 20070813017289IAmtr PITTSS2C · San Jose, CA(-23) While taxiing the aircraft for takeoff on taxiway "z" the pilot clipped a blue taxiway light in the run up area. The aircraft only knocked off the lens but did not break the bulb of the light assembly. The aircraft received some minor damage to the…Accident 20070813015619ACessna 182M · Montrose, PA(-23) Pilot departed stroudsburg pocono airport, stroudsburg, PA (N53) enroute to Husky Haven Airport, Montrose, PA (P32). Pilot landed runway 9 at Husky Haven Airport, which is a grass strip, and was unable to stop the aircraft on the runway. The aircraft…Incident 20070812825909INamer T28B · Joliet, IL(-23) PIC stated that enroute and traffic pattern were normal. Final approach was approximately 5 knots slow descending on the VASI, due to short runway. Stated aircraft floated more then usual - about 3/4 down runway. Stated that she thought she should go…Accident 20070812022649AMooney M20C · Hicksville, OH(-23) Aircraft was landing on 2200' Private grass strip. The pilot stated he was too fast on approach and landed long. The pilot initiated a go-around, but was too slow to allow the aircraft to fly. The aircraft departed the end of the runway and entered a…Accident 20070812021979AAirtrc AT502B · Cooksville, IL(-23) During takeoff to the south on a north/south oriented unimproved airstrip the pilot was unable to attain enough altitude to clear a corn crop at the southern end of the airstrip. The aircraft contacted the corn, traveled approximately 250 feet and…Incident 20070812019759ICessna 177RG · Bluefield, WV(-23) Airman stated while on visual approach to Bluefield, WV (blf) runway 23 he was "high." Airman stated he selected gear handle to gear down position but did not confirm down and locked indication. Airman stated on touchdown aircraft seemed to yaw left and…Accident 20070812019469AAmtr Falconxp · Montgomery, NY(-23) Private pilot departed rnwy 26 @mgj in his expr'mntl amateur built a/c. climbing out at pattern alt. The engine experienced partial pwr for 5 sec., then full pwr for 5 sec., then zero pwr. The a/c crashed on the extended centerline of rnwy 26. Pilot…Accident 20070812017829AAmtr DAKOTAHKDH23 · Sebring, FL(-23) On August 12, 2007 at approximately 1141 EDT, an experimental homebult dakota hawk, N6128A, flown by the pilot [privacy data omitted] landed on runway 14 at the Sebring, Florida airport. During the landing rollout, the right main landing gear collapsed…Accident 20070812017059ACessna 195 · San Diego/El C, CA(-23) On August 12, 2007, Cessna N1031D a Cessna model 195 aircraft departed ely Nevada (kely) direct Gillespie Field, el cajon CA (ksee). The pilot states that during his landing flare at ksee, runway 27R, a gust of wind lifted his aircraft an estimated 8-10…Accident 20070812016029AQckslv GT500 · Newberg, OR(-23) On August 12, 2007 at approximately 0930, the pilot took to flight in N8058J at the Newberg, Oregon, airport 2S6. After taking three passes at landing on the runway, on climb out on the third pass, the aircraft stalled, rolled to the right and impacted…Accident 20070812015869APiper J3C65 · Frenchtown, NJ(-23) The pilot stated prior to his descent from 1,400 feet MSL to approximately 700 feet MSL over the deleware river near Frenchtown NJ, he applied carburetor heat and retarded the throttle. During his level off at 500 feet AGL, he stated he turned off the…Incident 20070811830439IRavin RAVIN500 · Rutherfordton, NC(-23) During cruise flight, the pilot switched fuel tanks as part of routine fuel management, the engine continued to run normally. The engine began to run rough, the pilot turned the boost pump on and switched back to the previous tank. The engine continued…Incident 20070811828969IHinckley, IL(-23) Witnesses stated that after the parachutist deployed the parachute she went into a slow spin and was having a hard time. The canopy was described as being half inflated with the right side of the canopy deflated and shroud lines tangled. The parachutist…Accident 20070811022679APiper PA18150 · Mcgrath, AK(-23) On August 11, 2007, about 1330 Alaska daylight time, a tundra tire-equipped Piper, PA-18 airplane, N7051, sustained substantial damage when it nosed over during landing rollout. The aircraft came to rest upside down on the off airport landing surface,…Accident 20070811021959AChris A1 · Kelleys Island, OH(-23) Pilot landing runway 27 at 89D. Pilot lost control of aircraft during landing, striking a telephone pole and hangar.Incident 20070811021189IAmtr Babyaced · Blue Grass, IA(-23) Pilot landed hard, resulting in damage to the left main gear. Pilot was unable to provide documentation that he was in compliance with 61.31(I). [privacy data omitted]Incident 20070811020259ICessna 172RG · Oklahoma City, OK(-23) While in cruise flight, pilot heard a bang and then saw the gear unsafe light illuminate. Pilot also noticed an increase in drag and the aircraft slowed. Pilot placed the gear handle in the down position, but nothing happened. He turned back toward kpwa…Accident 20070811019879ACessna 172M · Marine City, MI(-23) Pilot attempted a landing and elected to perform a go-around and stated that the engine "sputtered." The aircraft ran out of runway and went off the south end of runway 22 approximately 400' and nosed over flipping on its back.Accident 20070811019839AUnknwn Notreported · Toledo, OH(-23) Non certificate pilot attempted takeoff with gyrocopter on maumee river under IS75 bridge near Toledo, OH catching tip of float. Gyrocopter flipped upside down. No injuries.Incident 20070811019689IAmtr LANCAIR235 · Fredericksburg, VA(-23) While taking off from VA 42 engine lost power and pilot landed aircraft back on runway gear up. This is an experimental aircraft and the fuel selector does not have a detent to lock the selector in the on or off position. The fuel selector had moved…Accident 20070811019249AAmtr Glasairiii · Captiva Island, FL(-23) Aircraft lost power and landed on beach at end of Captiva Island. Aircraft rolled approximately 100 yards and flipped over when nose gear sunk into sand. Pilot received no injuries, passenger received minor cuts and bruises. Aircraft canopy was broken,…Incident 20070811019099ICessna 177RG · Latrobe, PA(-23) On August 11, 2007, at 1036EDT, N53160 a Cessna 177RG received minor damage following an emergency landing at klbe in which the nose gear failed to extend. Further inspection revealed a misinstalled turn buckle that failed allowing the nose gear door to…Accident 20070811018489AAmtr Kitfoxv · Silverdale, WA(-23) Kitfox v, N422NL, was landing at Apex airport in Silverdale, WA. The aircraft touched down then added power and attempted to depart. The aircraft lost speed, stalled, and made a final hard landing causing substantial damage to the aircraft.Accident 20070811018039ACirrus SR22 · San Diego, CA(-23) On August 11, 2007 N336SR, a Cirrus SR-22 aircraft was landing at Montgomery Field, San Diego CA (kmyf). The pilot states the aircraft touched down, bounced and he failed to regain control of the pilot induced oscillation cycle (pio). The nose gear…Accident 20070811017769AAmtr Ebjenny · Surry County, VA(-23) The pilot reported he departed akq at 1000 local. After approximately 10 minutes, he observed the engine coolant temperature indicator near red line. Eventually, the pilot reported the indicator went to 0. At that time, he observed a dramatic loss of…Accident 20070811017649ACessna 172C · Pascagoula, MS(-23) After reaching cruise altitude, the engine began to lose power (RPM). Engine completely shut down shortly after losing power and pilot initiated an emergency off airport landing. Aircraft hit a mound of dirt and flipped upside down. No injuries.…Accident 20070811017159ACessna T210G · Lomita, CA(-23) On August 11, 2007, N225RJ requested a down wind and departed torrance airport (ktoa) from runway 29R. Aircraft was inbound to airport and observed by torrance tower at a low altitude. N225RJ was cleared to land with no response. Witness statements…Incident 20070811016529IDoug DC1030F · Boston, MA(-23) Returned to ramp from position and hold due to an odor in the cockpit. Crew decided to stop on taxiway and request fire equipment as a fire was suspected. Crew discharged the L1 door evacuation slide because it is the preferred door. Evacuated aircraft…Incident 20070811014349IBeech 65A90 · Perkasie, PA(-23) Pilot reported that while attempting to put the gear down for landing, he selected "down" but did not get any "green lights" indicating a "down and locked position." He performed a "low pass maneuver" over the airport and the FBO personnel said the gear…Incident 20070810824949IDiamon DA42 · Chicago/Schaum, IL(-23) Pic/cfi states that he did not extend the landing gear nor did he instruct the student to do so. They were practicing a one engine inoperative approach and landing. During the one engine out approach and landing, both failed to recognize that the…Accident 20070810023449ABbavia 7AC · Big Lake, AK(-23) The student pilot stated he was in left turn following his departure from the Big Lake airport and headed toward willow's airport. He stated "a strange gust of wind came up behind me and flipped me forward and down to the left." He added that "I had…Accident 20070810022639AGolden Chief · Hinesboro, IL(-23) Pilot stated that he was 15 minutes north of mattoon airport at 1000 feet enroute rantoul, IL, when the engine started sputtering and losing power. Pilot applied carb heat to no avail. By now the engine was still running but not producing enough power…Accident 20070810021829ACessna 180 · Princeton, NM(-23) Pilot stated that while enroute from lacross, WI to Princeton, MN at about 3 miles south of the Princeton airport the aircraft lost power and he performed an emergency landing in a soybean field. Upon exiting the aircraft he noticed the right fuel cap…Accident 20070810021369ARobsin R22BETA · Chino, CA(-23) While accomplishing 180 degree autorotations to a power recovery, the helicopter attained a descent rate that could not be adequately controlled resulting in a hard landing causing substantial damage to the helicopter, but no immediately identifiable…Accident 20070810021229ACessna A185F · Pedro Bay, AK(-23) While landing at dry bay, the pilot's [privacy data omitted] 185 tail began to pull to the right. The pilot [privacy data omitted] applied left rudder and it seemed to correct the problem. As the aircraft decelerated the tail again began to go to the…Accident 20070810020889ASnowac 600S2DSNOW · Hazelton, ND(-23) On the first flight of the day, the pilot stated that he did a normal take off from 6H8. He then made a pass over a field and the engine started shaking and power decreased. He then attempted to set the aircraft down in the field. During landing…Incident 20070810020349IPiper PA28R201 · Palatka, FL(-23) Pilot forgot to extend gear. Minor damage, no injuries.Accident 20070810020109ACessna 210D · Ft. Wayne, IN(-23) The pilot's intent was to do pattern work and complete 3 touch and go landings. After checking ATIS, the pilot called the tower and was cleared to runway 32 at the midway section. The pilot chose to do a left hand traffic pattern. The downwind leg was…Accident 20070810020099ACessna 182P · Jasper, MN(-23) Pilot stated shortly after take off the engine quit. An attempt was made to return to the private grass strip, but he decided to perform an emergency landing in an adjacent corn field. The pilot also stated he took off on right fuel tank. Right fuel…Accident 20070810019899APiper PA28140 · West Bend, WI(-23) On August 10, 2007, at or about 5:10 am CST, an ELT signal was received by the flight service station. The signal was determined to have come from a Piper PA-28-140, N1696H, which was found approximately one quarter mile northwest of the runway 24…Incident 20070810019669IPiper PA23250 · Des Moines, IA(-23) On departure from Des Moines int'l airport, the pilot experienced roughness in the left engine. The pilot declared engine trouble and executed an emergency landing back at Des Moines. The pilot did a ground run and could not duplicate the roughness, so…Incident 20070810017859IBraero HS125700A · Grand Island, NE(-23) N128WU, a HS-125-700A, departed north platte, NE, enroute to kalamazoo, MI. The crew had leveled off at a cruise altitude of 27,000 feet, when they noticed a fuel unbalance. They attempted to crossfeed fuel to the right tank to balance the fuel load…Accident 20070810017509AAmtr Avidflyer · Sequim, WA(-23) The experimental amateur built aircraft (avid flyer) was operating at a low altitude and crash landed approximately 100 feet from the intersection of blue mountain and lily rd in Sequim VA.Incident 20070810017409IBell 206L4 · Lawrenceville, GA(-23) During landing on the platform the pilot looked out the door to line up the skids longways on the platform. When the skids contacted the platform the rear cross tube was not fully on the platform and the helicopter tipped backwards and came to rest on…Incident 20070810016579IBell 407(-23) Pilot thought the aircraft had proper clearance from rlc N207RT to be refueled. Pilot slowly lowered the collective to position the aircraft, but the aircraft drifted towards N207RT causing the rotor to strike N207RT. Which caused substantial damage to…Incident 20070810016149ITcrafk DCO65TCRAFT · San Jose, CA(-23) Pilot stated that on climbout (upwind leg) aircraft lost most of its power which resulted in an off field emergency landing on a local road.Incident 20070810016079IBbavia 7AC · San Jose, CA(-23) On August 10, 2007, aircraft N2791E piloted by [privacy data omitted] landed on runway 31R at Reid Hillview airport (rhv). When applying the brakes to exit on taxiway "c" pilot states he misapplied the brakes causing the aircraft to unexpectedly exit…