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 20071109826519AAmtr BULLDOG120 · Cramerton, NC(-23) During cruise flight from rhp to akh, pilot missed akh airport and began to zigzag when the engine quit running. The electric fuel pump was turned on and the engine did not return with power. The oil pressure was indicating and the propeller was…Incident 20071109826159ICessna U206C · Canon City, CO(-23) On November 9, 2007, the pilot took off from the freemont county airport, and the engine quit at 800 feet AGL. The pilot made an emergency landing on county road 123 approximately 2-3 miles from the airport. Two mechanics from the pro av repair station…Incident 20071109825339IPiper PA28180 · Houston, TX(-23) On 11/09/07 at approx 11:00 am the pilot [privacy data omitted] departed iws west bound enroute to brenham, Texas. At approximately 1700 feet altitude he experienced engine problems, losing oil pressure and engine RPM. He declared an emergency and…Accident 20071109825189AAirtrc AT502 · Loupe City, NE(-23) On November 9, 2007 at about 12:00 local time the pilot [privacy data omitted], a commercial pilot, was operating N9192X an air tractor inc. AT-502 for certificate holder dlog, dba miller flying service inc. an agricultural aircraft operator. While…Accident 20071108828509ACessna T182T · Las Vegas, NV(-23) On November 8, 2007, approximately 1917 pacific standard time, a Cessna T182T, N881CP, was destroyed after impacting mountainous terrain while in a climb near mount potosi, approximately 24 nautical miles southwest of Las Vegas, Nevada. The airplane was…Accident 20071108828439ABeech A36 · Jean, NV(-23) On November 8, 2007, at approximately 1837 pacific standard time, a Beech A36, N3672B, experienced a loss of power and encountered rough terrain during a forced gear-up landing on the desert floor about 3 miles northeast of the Jean airport (0L7). The…Incident 20071108826789IMooney M20K · Winder, GA(-23) On a personal flight under VFR conditions from bwg to wdr, aircraft experienced a hard landing. Aircraft sustained damage to propeller at the blade tips.Accident 20071108826399AHughes 269C · Baker City, OR(-23) Experienced fixed wing pilot in training as a student in rotorcraft helicopter on a solo flight was observed by eyewitnesses to depart the airport to the north. Between about 800-1500 feet above the ground, the witnesses described the helicopter falling…Accident 20071108823829ACessna 152 · Ardmore, OK(-23) On November 8, 2007, a Cessna 152, N4830B, piloted by a student pilot, was involved in a landing accident at the Ardmore-executive airport, Ardmore, OK. The pilot stated that he lost control of the airplane during the flare to landing on runway 17.…Incident 20071107832359IPiper PA18150 · ND(-23) Owner/pic was attempting to land on a rural road when he struck a wire which damaged the lift struts and windshield breaking part of the left side of the windshield. The pilot was able to land the aircraft with minor damage. He stated he was flying into…Incident 20071107831609IPiper PA24 · Ocala, FL(-23) Pilot was practicing engine out landing and forgot to extend landing gear. Damage limited to prop and belly skins.Incident 20071107830349ISocata TB9CTAMPICO · Cahokia/St Lou, IL(-23) The student was conducting a short field takeoff under the supervision of the flight instructor on runway 5 at cps. At 60 KTS the student unexpectedly aborted the takeoff due to a loose fuel cap on the left wing. The instructor called "off the brakes"…Incident 20071107829019IPilats PC1245 · Aspen, CO(-23) On November 7, 2007, at approximately 20:45 local time, N559PB was departing from the Aspen, Colorado airport following the LINDZ4 departure procedure when the pilot was temporarily blinded by an extremely bright laser beam in the cockpit of the…Incident 20071107827619IPiper PA28181 · Mesa, AZ(-23) The pilot landed on 22R at Falcon field airport (ffz) in Mesa, AZ. Upon touching down the aircraft veered towards the left of the runway and departed the runway when the pilot lost control of the aircraft. The aircraft came to a stop in the drainage…Incident 20071107826879ICessna 152 · St Augustine, FL(-23) The private pilot [privacy data omitted], while acting as the pilot in command of N4948P, lost control of the aircraft while attempting to land on runway 31 at st. Augustine airport (sgj), Florida. The winds at sgj were reported 010 degrees at 15 knots,…Incident 20071107825739IRosharon, TX(-23) On November 7, 2007 at approximately 4:30 pm local, a parachutist received fatal injuries as a result of voluntary sport parachute activity in the vicinity of fm road 521 and fm road 1462 in brazoria count Texas. He was not discovered until November 9,…Accident 20071107009799AReportIncident 20071106831629IBeech V35 · Merritt Island, FL(-23) Made a gear up landing, no injuries, minor damage to aircraft.Incident 20071106831219ICndair CL6002B19 · Springfield, IL(-23) At acceleration altitude, when the flaps were selected from 20 to 8, there was a flaps fail caution. The flaps failed at 16 degrees. After running the cfm, the crew returned the aircraft to kspi. An emergency was declared and the aircraft landed without…Accident 20071106830069AAgusta A119 · Cody, WY(-23) Helicopter landed hard at approximately 12,000 feet asl at approximately 200 pounds under maximum gross weight.Accident 20071106829639APiper PA18135 · Durbin, WV(-23) Airman stated he departed kagc at approximately 11:00 EST enroute to kric. Approximately two (2) hours into flight he heard a "pop" and oil covered the windshield. Engine oil pressure began to drop and airman stated he elected to make an emergency off…Incident 20071106829029IRaythn 390 · Lexington, KY(-23) On 11/06/2007, the pilot of N71KV while taxiing for take-off allowed the aircraft's t-tail to come into contact with the seam of the hangar door damaging the elevator and horizontal stabilizer and removing a static wick which landed in the Grass next to…Incident 20071106827629IAmtr Lancairiv · Upland, CA(-23) After landing on runway 6, the pilot turned too sharp on taxiway 26. The aircraft's rudder and lower fuselage tail surface struck the sign. The pilot regained control and taxied to his hangar. Damage consisted of a chipped fiberglass rudder and tail…Accident 20071106827159ACessna 340CESSNA · Garberville, CA(-23) The aircraft (owned and operated by roy ladd, inc.) took off from redding (rdd) at approx 8:00 am local enroute to Garberville Airport O16. The pilot and two passengers were on board. Witnesses saw the aircraft near the Garberville Airport at approx…Accident 20071106827069ABeech A100 · Chino, CA(-23) N30GC departed the Chino airport on an IFR clearance from runway 26R. The aircraft impacted trees approximately 1/2 mile west of the Chino airport. Portions of the right wing and right stabilizer were separated from the aircraft. The aircraft came to…Accident 20071106827029AAmtr CH701 · Lebanon, TN(-23) Aircraft N4225G on approach to M54 runway 01 from I91 touched down just past threshold of runway. Aircraft ballooned up off runway then nosed over, landing hard on runway with nosewheel touching down first. The nose wheel sheared off from the nose gear.…Incident 20071106826849IBeech 95B55 · Crystal River, FL(-23) Aircraft experienced gear problems and landed gear up at Crystal River, Florida airport. No ATC involvement.Accident 20071106826469ABell OH58A · Cougar, WA(-23) Pilot took off with fertilizer bucket attached. Suspension cable from bucket was inadvertently over lower blade of wire strike protection system. Pilot failed to verify bucket suspension cables were clear of helicopter and rigging was correct prior to…Accident 20071105831699ACessna 140 · Pultney, VT(-23) On initial landing at a newly prepared prival runway, the tailwheel struck a large rock, which caused the tailwheel mount rivets to fail. The tailwheel then jammed the rudder, which caused a loss of control. The aircraft ground looped, hitting the right…Incident 20071105830389IJabiru J250SP · Plainville, CT(-23) On 11-05-07 during a demonstration flight, aircraft N605J, a Jabiru J250-SP light sport aircraft, landed short of runway 20 at Robertson airport (4B8). The pilot in command demonstrating the aircraft to a prospective buyer stated that on short final he…Accident 20071105829099ABeech J35 · Fort Worth, TX(-23) Pilot states that he was enroute from houston executive airport (tme) to Fort Worth hicks field (T67) when a sudden loss of power occurred. He was at 2200 feet MSL about 1.5 miles northeast of Fort Worth meacham field (ftw) in cruise flight when the…Accident 20071105828149ARobsin R44 · Jamestown, TN(-23) On November 5, 2007, at 1300 central standard time, a Robinson R44 astro, N8356C, owned and operated by fly-n-dollar helicopter services, collided with trees and terrain after takeoff from a creek bed in Jamestown, Tennessee. The certificated commercial…Incident 20071105827609IBeech B60 · Concord, CA(-23) Purpose of flight was a maintenance test flight. Pilot and passenger reported actuating landing gear, hearing a muffled pop and seeing the nose wheel and left hand main wheel indicator lamps indicate green;right hand gear lamp indicated unsafe. Both…Accident 20071105827559ACessna 172F · Nashville, TN(-23) November 05, 2007, at 1341 local time aircraft N5555R Cessna 172F was taxiing on sierra 7 taxiway for departure on runway 20C. Aircraft taxied behind USAF air guard C-130 that was performing a high power ground run. Cessna N5555R taxied into the C-130…Accident 20071105826429AAmtr RV7A · Mascot, VA(-23) Pilot was enroute from st. maries county airport (2W6) to westpoint (W97). At 2,500 ft., engine quit. Pilot called mayday on 121.5. Aircraft landed upright in a bean field just short of the westpoint airport.Accident 20071105824669APiper PA18150 · Cortez, CO(-23) The pilot landed the aircraft after local flight around cez (Cortez, CO), 11/05/07, 11:00 MST. Upon touchdown, the passenger inadvertently applied the brakes. The aircraft flipped over onto back, causing substantial damage to the propeller, vertical…Incident 20071105824029IPiper PA44180 · Miami, FL(-23) Mismanaged gear by the pilots caused the gear up landing.Incident 20071104830819IBeech F33A · Teterboro, NJ(-23) On November 4, 2007 at approximately 7:18AM local time N861DS performed a gear up landing on runway 24 at kteb. The pilot reported he was cleared to land, performed a normal approach with normal landing gear indications, but the landing gear collapsed…Incident 20071104830779ICessna 320B · Livermore, CA(-23) Right main landing gear collapsed during touch down caused by failure of the right main bellcrank assy.Incident 20071104830499IBeech B200 · Binghamton, NY(-23) On Sunday November 4, 2007, 1628 EST, a Beechcraft BE-200, s/n BB-1171, N786DD, operated by scott richard aviation services, inc., a CFR part 135 air carrier, experienced the main cabin door separating from the aircraft while in flight. The aircraft was…Incident 20071104829989IBeech B90 · West Point, VA(-23) The pilot stated this was his eighth drop of the day. On the incident flight he dropped the skydivers at 14,000 feet with the engines at idle. The gear warning horn was initially on but cancelled by the pilot. The pilot, after the drop, descended to…Accident 20071104829759AGrob G103ATWIN2 · Green County, NY(-23) During a routine pleasure flight, N46009 lost lift and crashed into a heavily wooded remote area. This was observed by hikers who notified the NY state police. The individuals were airlifted for treatment by helicopter. Statements from the two…Accident 20071104829629AAmtr CH601XL · Farmington, DE(-23) Witnesses stated that during runup and during takeoff the engine (corvair) sounded normal. Takeoff roll was unusually long (2800 +/- ft) from runway 34. Aircraft climb performance was lacking, having to make a RH turn to go around stand of trees.…Incident 20071104829539IPiper PA32R300 · Sylva, NC(-23) PIC stated, departure from active runway 33, rotated, retracted gear and initiated climb. A gust of wind from the east pushed aircraft down and to the left, corrected with right rudder and aileron but was unable to climb. Lowered nose to increase…Accident 20071104827909AAmtr CH601HD · Greenwood, IN(-23) Shortly after departing Greenwood municipal airport (hfy) the pilot saw a puff of smoke come from the engine. He immediately turned back towards the airport. During this time he lost complete engine power and it seized up on him. The pilot lined up with…Incident 20071103831149IAviat A1B · Ash River, MN(-23) Pilot was patroling national park in float equipped aircraft operating under public use. Pilot landed to check hunters. On approach to water, pilot landed short. When floats hit the water, the aircraft tipped on its nose. Aircraft suffered minor damage.…Incident 20071103828359IBeech M35 · Mesa, AZ(-23) On 11/3/07, at approximately 0945 MST, the pilot departed ffz rwy 4R at ffz in bonanza N9831R. Shortly after takeoff, he selected the landing gear handle to the up position, and the green gear-down indicator illuminated. He placed the gear selector…Accident 20071103828139ACessna 172I · Gladwin, MI(-23) Pilot was taking pictures over a housing complex. Witnesses stated that the plane was circling when wings rocked, aircraft banked, resulting in the aircraft contacting the ground.Incident 20071103826859ICASA C212CC · Houston, TX(-23) Parachutist broke his left ankle during a high speed downwind landing during a demonstration mass parachute jump at the ballunar liftoff festival on the grounds at NASA johnson space center.Incident 20071103826759ICessna 172S · Sedona, AZ(-23) Pilot in command was taxiing out for a north departure at sez. Numerous taxiways were closed necessitating the pilot in command to back taxi on the runway to get to the departure end. The pilot in command heard anorther pilot calling in for landing and…