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 20070702014899ACambal Z77 · Battle Creek, MI(-23) Aircraft landed safely in light to no-wind conditions. As the envelope began deflating and collapsing toward burner equipment, pilot began rotating burner assembly away from envelope. Envelope-skirt material inadvertently drug across fuel levers causing…Incident 20070702013129ICessna 172M · Iowa City, IA(-23) Pilot declared emergency due to smoke in the cockpit. Aircraft landed without further incident at iow. Maintenance personnel found that the alternator and voltage regulator had failed and caused the main supply circuit breaker to burn out.Incident 20070702013079INancng CJ6A · Brigham City, UT(-23) Landed hard and broke nose gear.Incident 20070702012779IMooney M20C · Lee'S Summit, MO(-23) Pilot departed VFR from Lee'S Summit Municipal Airport (lxt), Lee'S Summit, Missouri, on a flight that was conducted in accordance with a special flight permit. Shortly after takeoff, the pilot returned to lxt to retrieve aircraft maintenance records…Accident 20070702012649AAirtrc AT301 · Albany, TX(-23) On July 2, 2007 at 2030 CDT, N7305E, an air tractor AT-301, owned by neal aircraft, of slaton, Texas and operated by murphree flying service (TNPG5691) of rotan, Texas crashed five miles north of lueders, Texas during maneuvering for the purpose of…Incident 20070702011999IPiper PA18150 · Fairbanks, AK(-23) After touchdown off airport the pilot observed standing water in his rollout path. In an attempt to avoid the water he applied excessive braking resulting in the aircraft nosing over onto the propeller. [privacy data omitted] Amendment to follow.Incident 20070702010479IAmtr Longez · Block Island, RI(-23) On July 2, 2007, at approximately 1700 eastern standard time (EST), an experimental aircraft long ez, N141AP failed to stop at the end of runway 28 in Block Island, RI (kbid). The pilot of the aircraft stated, he was traveling approximately 70 KTS over…Incident 20070701825989IMooney M20E · Wadsworth, OH(-23) Witness statements support pilot's claim that the landing gear was fully extended upon touch down. Toward the end of landing roll-out all three landing gear retracted with selector in down position. During retrieval the landing gear freely extended and…Incident 20070701825459IStnson 10ASTNSON · Lake City, MI(-23) The pilot [privacy data omitted] and CFI [privacy data omitted] were attempting to land on a 3830' x 160' grass strip in Lake City Michigan. [privacy data omitted] Was the pilot in command when, during the landing rollout, he lost control of the…Accident 20070701017149ACessna 172S · Santa Barbara, CA(-23) The pilot [privacy data omitted] stated he flew N214GZ, Cessna 172S, s/n 9862, from van nuys to sba on July 01, 2007. The pilot stated he flew with one female passenger named [privacy data omitted]. The pilot stated that he landed on runway 25, and felt…Accident 20070701017109AGrob Speedastirii · Centre Hall, PA(-23) During take off during aero tow from runway 6, eyewitnesses reported glider became airborne in normal manner during tow and pitched up abruptly. Aircraft rotated right and right wing impacted runway followed by nose. Aircraft impacted runway in near…Incident 20070701017039IPiper PA23250 · Fryeburg, ME(-23) [privacy data omitted] pilot statement disclosed that departed fxe at 0900 to izg with a fuel stop at dpl. About 1800 upon landing at izg the pilot felt and heard the right prop striking the pavement, feeling a go-around would be too dangerous, the…Accident 20070701014799APiper PA18150 · Talkeetna, AK(-23) Original -23 not saved and expect this document to be amended. 7/27/07. Pilot has not completed NTSB report as of this date. Pilot will get a statement to me by 7/30/07. I will amend this document the week of 7/30/07. (-23 amendment) 8/29/07: interview…Accident 20070701014599ACessna 180A · Fort Collins/L, CO(-23) The pilot reported a gust of wind on landing causing the aircraft to ground loop. The aircraft suffered substantial damage. Wind reports were calm 30 minutes prior to the accident and 180 degrees at 5KTS. 10 minutes prior to the accident.Incident 20070701013889IBbavia 7ECA · Cedartown, GA(-23) The pilot [privacy data omitted] encountered a strong crosswind on landing after touchdown. He had made a wheel landing and was at about 30 knots when the aircraft was blown sideways and rotated to the left. The right tire received sufficient side…Accident 20070701010939APiper PA24250 · Boulder City, NV(-23) Event: at approximately 10:20 am PDT concluding a flight from kingman, AZ, the accident aircraft (PA-24-250, N6370P) arrived on the right downwind for runway 9R at Boulder City, NV. The wind was reported light and variable from the east. The pilot…Accident 20070701010599AMooney M20R · Mitchellville, MD(-23) Aircraft ran off the end of runway 18, continued down a 5 foot embankment and sustained damage. It appears that the pilot "landed long" and was not able to stop before departing the runway. Skid marks measuring 513 feet were documented at the scene.…Incident 20070701010539IAmtr Condor · Fort Davis, TX(-23) On July 1, 2007, at approximately 0800 CDT, N2547S, a powered parachute, made a hard landing approximately 6 miles north of Fort Davis, Texas, just off highway 17. After lift-off the pilot attempted to turn the aircraft with no response. The parachute…Accident 20070701010009ASchemp Discuscs · Freehold, NY(-23) PIC stated that launch using runway 30, and climb out were normal until he encountered turbulence and bumped his head on the canopy. PIC notified tow pilot of turbulence by radio and experienced turbulence and bumped head again. The second time he hit…Incident 20070630826079IAntonv AN2 · Ray, MI(-23) Aircraft departed Ray airport and after takeoff into the climb aircraft engine started to have problems. Pilot landed the aircraft into a field, off of 28 mile rd and teller rd. aircraft shows signs of striking trees. The right bottom side of fuselage…Incident 20070630826059ICessna 182Q · Joliet, IL(-23) The pilot [privacy data omitted] departed from double eagle ii airport, albuquerque, NM (kaeg), in his Cessna 182Q making two stops enroute to Joliet Regional Airport, Joliet, IL (kjot). When arriving at kjot at 2130 local the weather conditions were…Incident 20070630825939ITlultr Stingsport · Germantown, WI(-23) Aircraft departed timmerman airport (mwc) at 10:11 am CDT. During cruise flight at 3,000 feet AGL the pilot felt strange jerking in controls and engine RPM increased. He noticed the aircraft was sinking at 500 fpm rate and realized the propeller had…Accident 20070630020079AAirtrc AT301 · White Hall, IL(-23) The pilot in command stated that during completion of a procedure turn to re-enter the cornfield he was spraying, he became distracted by making sure he missed guy wires on a nearby tower. The aircraft descended into the corn crop and subsequently…Incident 20070630017949ICessna 172N · West Palm Beac, FL(-23) Pilot states he was not tied down in his normal spot on the ramp. He reported he did not compensate spacing correctly.Incident 20070630017259IAronca 15AC · Daytona Beach, FL(-23) Airman landed in variable winds and ground looped a/c. no structural damage.Incident 20070630015739IPiper PA34220T · Linden, NJ(-23) Aircraft landed gear up at Linden mun. Airport (ldj) Linden NJ. There were no injuries to the pilot, who was the only occupant onboard the aircraft. Damage to the aircraft was limited to both propellers, both inboard flap areas, and an antenna on the…Incident 20070630015679IAyers S2RG1 · Agency, IA(-23) During a cross-country repositioning flight, pilot attempted a precautionary landing on a gravel road due to a "low fuel" indication. Left wing of aircraft impacted a road sign post, pilot lost directional control, aircraft left the roadway, impacted an…Accident 20070630015009ACubcft CC11100 · Palm Springs, CA(-23) During landing at psp the aircraft veered from the runway and ground looped. Substantial damage to right wing. Pilot stated no mechanical reason for accident. (-23 amendment) incident time (block 9) was corrected to 1440.Accident 20070630012979AAirtrc AT502A · Chowchilla, CA(-23) After takeoff, the aircraft experienced loss of power with flames observed exiting out of the exhaust. The aircraft landed straight ahead into a field sustained damage underneath both wings, such as flaps and ailerons and the rear spar area. Preliminary…Incident 20070630012069IBoeing 737490 · Juneau, AK(-23) Aircraft departed sea for anc diverted to jnu due to be engine hydraulic pump warning light illumination. Maintenance in Juneau found b system acoustic filter leaking from blown "o" ring. Alaska airlines maintenance replaced the acoustic filter and…Accident 20070630011339ACessna 500CESSNA · Conway, AR(-23) On June 30, 2007, at 14:48 CDT, a Cessna citation, CE-500, N771HR, while attempting an aborted landing on a wet runway, overran the runway, and collided with a blast fence and a house at the Conway, Arkansas (kcws) municipal airport. The commercial…Accident 20070630010369APiper PA28R200 · Lubbock, TX(-23) On June 30, 2007, while making a simulated power off 180 degrees approach to the airport, N41585, a Piper PA-28R-200, began to go into a stall just above the end of runway 35L at the Lubbock international airport (klbb). The commercial student pilot…Incident 20070629017419ICessna 340CESSNA · Punta Gorda, FL(-23) On June 29, 2007, a Cessna 340, N247AT registered to air ambulance by air trek, inc. landed at Charlotte County Airport, Punta Gorda, FL, while on a part 91 flight. Upon rollout, the right main gear collapsed and the aircraft sustained minor damage. The…Accident 20070629016719ABbavia 7KCAB · Cordova, SC(-23) The aircraft circled the field and atempted a landing on runway 03. The aircraft was too high and too fast and the pilot executed a go around at the point of 1/3 of runway remaining. The wind was 180 degrees and 10 mph which is a tail wind. On the…Incident 20070629016229IBeech H35 · San Rafael, CA(-23) The pilot [privacy data omitted] took off from CA35, the aircraft was pre-flighted and fuel load was confirmed as main tanks full and aux tanks 3 gallons each prior to the flight. After a normal take-off and reaching cruise a fuel smell was noticed. The…Accident 20070629015899ACessna 172N · Yorkville, IL(-23) The pilot [privacy data omitted] departed from olive branch airport (kolv), olive branch, Mississippi, enroute to aurora municipal airport (karr), sugar grove, Illinois, when the aircraft (N738SV) engine lost power. The pilot [privacy data omitted]…Incident 20070629015839ICessna 172S · Winslow, AZ(-23) After takeoff from Winslow, AZ, approximately 10 inches of one of the two propeller baldes separated. Pilot reduced power and landed at inw without substantial damage to aircraft. The propeller was replaced and the aircraft returned to service.Accident 20070629015149ACessna 172P · Perry, GA(-23) Airman [privacy data omitted] departed Perry-Houston County Airport solo for a local flight. Upon landing on runway 36, student pilot [privacy data omitted] said that a gust of wind caused the aircraft to go off the runway to the right and he was unable…Accident 20070629012919AAmtr RV9A · Tucson, AZ(-23) On June 29, 2007, at approximately 0530 MST, a homebuilt experimental vans RV-9A, N394RS, was substantially damaged in a collision with terrain following a loss of power on climbout from Ryan Field Airport, runway 6R, Tucson, Arizona. The private pilot,…Incident 20070629011829IBell 47G2 · Oroville, WA(-23) Operator was conducting cherry drying operations at the time of the incident. Operator was hovering over trees blowing off water on the cherries when the engine lost power. The pilot tried to line up the helicopter with the tree rows and autorotated. As…Incident 20070629010519IMooney M20K · The Dalles, OR(-23) N231KJ, a Mooney-20-K, was on a VFR flight from missoula, mt to troutdale, Oregon. The weather was deteriorating at troutdale and he elected to land at The Dalles. The weather was good VFR with some gusty winds mostly down runway 30. Winds were…Accident 20070629010359APiper PA28R180 · Las Vegas, NV(-23) Aircraft approached the Henderson airport from the south, and was instructed to enter a right downwind for landing on runway 17R. Once abeam his landing point, airman lowered his gear and deployed 10 degrees of flaps. Airman stated that he was on a…Accident 20070628831969AHughes 269C · Slidell, LA(-23) Single-engine helicopter encountered settling with power resulting in a hard landing on a marsh land. The 3400 hour commercial pilot was hovering the helicopter at approximately 100 feet above the ground (AGL) whle performimg a wildlife/mapping survey,…Incident 20070628827329ICessna 560XL · Toledo, OH(-23) While climbing through 5000 feet, shortly after take-off, a large portion of the upper cowling of the l/h engine broke apart from the aircraft. Only two small pieces were recovered by the police department of maumee, Ohio.Incident 20070628825919ICirrus SR22 · Grand Forks, ND(-23) After receiving taxi clearance from the ramp to runway 35C, N631CD came in contact with a fuel truck at the wing tip. Minor damage, breakage of the strobe light and light scratches on the wing tip.Accident 20070628018859ACessna 150L · Salem, IL(-23) N11419, a CE-150 aircraft operated by a student pilot, was conducting a flight for the purpose of building flight time and experience. The student left the centralia, Illinois airport and was flying for approximately 2.5 hours when the engine sustained…Incident 20070628016959IPiper PA28180 · Dodge City, KS(-23) On June 28, 2007 at approximately 1100 CST, the pilot on landing, bounced the aircraft and started to porpoise. The ending result was damage to the nose wheel and a prop strike with the runway. The aircraft involved was Piper PA28-180. There was one…Incident 20070628016909ICessna 152 · Tucson, AZ(-23) At the time of the incident the pilot in command (PIC) of N68737 was on his first solo flight at the Ryan airport, Tucson, AZ. After the PIC landed on runway 6R he tried to exit the runway at taxiway B3 with excessive groundspeed. The PIC lost control…Accident 20070628015989ACessna 150 · Lancaster, PA(-23) Rocc (regional operations command center) reported emergency off airport landing south east of Lancaster airport (lns). Aircraft landed in a corn field. Substantial damage to aircraft airframe, minor injury to sole occupant (pilot). Local police…Accident 20070628015509ACessna 172 · Oak Grove, MN(-23) Student pilot VFR with no flight plan or air traffic involvement on solo cross country from backus MN (7Y3) to st. cloud MN (STC) and back, weather was good, departed st. cloud approximately 4:30 pm CDT. Pilot lost position and was off course. Engine…