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 20010729020969IDoug MD83 · Grand Rapids, MI(-23) On July 29, 2001, flight 872, MD80, N822NK, spirit airline, departed dtw to lax, at climb the pilot reported an emergency. The pilot reported to ATC, that right engine was shuddering and oil quantity read (zero), smoke entered the cockpit and the cabin.…Incident 20010729020909ICessna T210N · Mackinac Island, MI(-23) Pilot initially contacted runway with gear in the up position during landing. Pilot was able to recover the aircraft to flight and lower aircraft's gear prior to landing. N4936Y'S propeller blades and belly skin sustained minor damage.Accident 20010729020669APiper PA32260 · Puyallup, WA(-23) Shortly after takeoff from pierce county airport, the aircraft with pilot and passengers stalled during takeoff climbout. The aircraft banked left and descended into trees.Incident 20010729019679INamer T28B · San Jose, CA(-23) Pilot states: on approach to rhv he was in traffic and started to put his landing gear down, but was distracted by traffic and ATC. After he landed, he realized he had not put the landing gear handle in the down position and as a result he landed with…Accident 20010729019319ACessna 152 · Naples, FL(.19) On July 29, 2001, about 1153 eastern daylight time, a Cessna 152, N944AC, registered to Naples air center, inc., ran off the runway when the nose gear collapsed during landing at Naples Municipal Airport, Naples, Florida, while on a 14 CFR part 91…Accident 20010729019249APiper PA31350 · Grand Junction, CO(.19) On July 29, 2001, at 0932 mountain daylight time, a Piper PA-31-350, N114SA, operated by American aviation, inc., as an on demand title 14 CFR part 135 cargo flight, sustained substantial damage during an emergency landing when the nose wheel landing…Accident 20010729018859AN3837U · Faribault, MN(.19) On July 29, 2001, about 1555 central daylight time, a burkhart grob G102 std astir iii, N3837U, piloted by a private pilot, sustained substantial damage when the left wing impacted terrain during a hard landing at Faribault Municipal Airport (fbl), near…Accident 20010729017869ACessna 172S · Scottsdale, AZ(.19) On July 29, 2001, at 1625 hours mountain standard time, a Cessna 172S, N3532T, porpoised during landing on runway 21 and collapsed the nose landing gear at the Scottsdale airport, Scottsdale, Arizona. The airplane was owned and operated by the private…Accident 20010728039909APiper PA18150 · Bethel, AK(-23) On July 28, 2001, the pilot of a PA-18-150, N6893B, was attempting to land on a ridge top strip at an old mining camp. He had been to the strip several times before, but on this occasion there was a strong crosswind and he tried to force the aircraft…Accident 20010728038509AAmtr BARNETTJ4B · Titusville, PA(-23) Witness stated that aircraft turned right after takeoff from runway 18. Aircraft appeared to continue to turn right, descend and hit the ground. Pilot sustained fatal injuries and aircraft was destroyed.Incident 20010728035619IMooney M20C · La Belle, FL(-23) Pilot in command failed to extend landing gear prior to landing.Incident 20010728031629IPiper PA28140 · Philipsburg, PA(-23) On July 28, 2001 at 1100 hours, a PA-28-140, N4911F operated by student john knepp crashed after a hard landing at psb airport. Visual meteorological conditions prevailed at the time of the incident. The aircraft received minor damage to prop. Pilot…Accident 20010728030559AAmtr RV6A · Hawthorne, CA(-23) On July 27, 2001 at 1851 hours PDT, a RV-6A, N131LH, made a hard landing on runway 25 at Hawthorne airport (hhr). The aircraft received substantial damage to the left wing, left main landing gear, nose gear, and propeller. The pilot reported that during…Accident 20010728027549AAmtr Aeronca · Charlestown, NY(-23) Aircraft struck electrical wires came to rest inverted in shallow water. Pilot and passenger deceased.Accident 20010728025889ACessna A188B · Thomasville, GA(-23) Victim was grn crew refueler/tanker after fueling right wing tank, put cap on turned right and walked directly into rotating propeller. Aircraft was in ground servicing after last flight before next flight. Hot refuel is a normal process in FAR 137…Accident 20010728023359ACessna 182Q · Ocala, FL(-23) Pilot attempted takeoff wet grass airstrip, ran through fence at end of runway. (.19) on July 27, 2001, about 0815 eastern daylight time, a Cessna 182Q, N78234, registered to tlc land trust, and operated by a private individual as a title 14 CFR part 91…Accident 20010728022669ACessna 182B · Headland, AL(.19) On July 28, 2001, about 1327 central daylight time, a Cessna 182B, N7202E, registered to, and operated by a private individual, as a title 14 CFR part 91 parachute jumping flight, crashed while landing at Headland, Alabama. Visual meteorological…Accident 20010728022179AMooney M20J · Clarksboro, NJ(-23) During take off from runway 14 (turf strip) at NJ25 Clarksboro, NJ, N246JC, Mooney 20J serial number 24-1557, tracks on the ground indicate that the aircraft started to drift left off the airstrip and into a soy bean field. The aircraft skidded right,…Incident 20010728021999ICessna A188B · Oakfield, NY(-23) On Saturday, July 28, 2001, aircraft CE-A188B, operated b Mr. Thomas kutschera, contacted power lines with the landing gear while conducting aerial applications. The wire cutters on the landing gear severed the power lines and there was no damage to the…Incident 20010728021669ICessna T210M · Boise, ID(-23) The pilot admitted to having forgot to select gear down before landing. Gear system operated normally after the aircraft was recovered. Minor damage to the aircraft.Accident 20010728021479AAirtrc AT301 · Devils Lake, ND(-23) On July 28, 2001 at 1500 local time, an air tractor AT-301 owned by brekke aerial service, lost the right wheel on takeoff for a CFR 137 flight. VMC prevailed and no flight plan was filed. The aircraft received substantial damage and the pilot received…Accident 20010728021459ACessna 172RG · Gunnison, CO(-23) Aircraft had departed the Gunnison, CO airport and struck high terrain approximately 7 miles ese.Accident 20010728020829ACessna 2105 · Locksburg, AR(-23) On July 28, 2001, at approximately 11:40 CDT, Cessna 205, N8324Z, a general aviation airplane, experienced a fatal accident near Locksburg, Arkansas. The airplane is registered to skywagon aviation, LLC, and was operated by george nelson of Oklahoma…Accident 20010728020749ACessna T210M · Spanish Fork, UT(-23) On landing aircraft was hit with gust of wind. Pilot applied power and tried to make a go around. Aircraft veered to the right of the runway and crashed into a ditch.Incident 20010728019469ICessna 152 · Pittsfield, MA(-23) Landing runway 26 at Pittsfield Municipal Airport (psf). As stated by the student pilot, while landing, the airspeed was a little high. The nose of the aircraft was brought up to hold off the airspeed. The aircraft touched down a little before the…Accident 20010728018829APiper PA46350P · Westfield, MA(.19) On July 28, 2001, about 1655 eastern daylight time, a Piper PA-46-350, was destroyed when it struck a building during a go-around at the barnes municipal airport (bai), Westfield, Massachusetts. The certificated private pilot was fatally injured, and…Incident 20010728018599ICessna TR182 · Jackpot, NV(-23) Pilot experienced a less than expected performance from the aircraft on the initial takeoff. He then returned to land, disembarked his wife and performed a magneto check again. After it checked normal, he performed another takeoff and at 600 feet AGL,…Incident 20010728018519ICessna T188C · Claycenter, KS(-23) Aircraft was applying chemicals to a field 6 miles south of clay center airport, clay center, when it struck an electrical service wire located on the border of the field. The aircraft did not sustain any damage. No injuries.Accident 20010728017899ACessna 152 · Pacoima, CA(.19) On July 28, 2001, about 1846 hours pacific daylight time, a Cessna 152, N67418, was substantially damaged during approach to landing at Pacoima, California. The private pilot received minor injuries and the private pilot passenger received serious…Incident 20010728017569IPiper PA23250 · Orlando, FL(-23) During landing roll-out, right main gear collapsed. Investigation revealed that the right main landing gear center draglink bolt had broken and fallen out of the draglink assembly, allowing the gear to collapse.Incident 20010727030299ICessna 172H · Elizabethtown, IL(-23)[privacy data omitted]- received a report from the hardin county sherriff's dept that N275SW had landed on a bridge near elizabeth, IL. According to the report, the aircraft received no damage and the pilot had stated he was going cross-country from st.…Accident 20010727027639AAmtr LANCAIR320 · Charleston, NY(-23) Per witness, pilot overflew a private airport two times, very low at a high rate of speed. On a third pass aircraft was in a dive, failed to pull out and struck trees.Accident 20010727026489AN6790 · Cambridge, OH(-23) On July 28, 2001 at 05:45Z inspector jerald e. womick was contacted by the FAA great lakes regional control center concerning an accident that was reported to them on July 27, 2001 at 23:41Z. Upon arriving at the scene the aircraft was found upside…Accident 20010727024529ACessna 180H · Northway, AK(-23) Pilot elected to take off downhill into lower terrain with light and variable wind conditions. The aircraft never became airborne near the end of the 1300 foot, 3300 MSL runway, the temperature was approximately 60 degree f. the aircraft impacted the…Incident 20010727024029IBeech E55 · Conway, AR(-23) The pilot stated during take off roll at M03 for departure to little rock at approximately 60 knots the landing gear retracted, leaving the aricraft in ground effect to settle back on the runway with full power t/o. no injuries, damage to both prop…Accident 20010727022259APiper PA28180 · West Milford, NJ(-23) Student pilot breslin was attempting to do solo landings in his aircraft at Greenwood Lake Airport, runway 06. The weather was clear with light winds. During his landing, the wind apparently changed, probably due to terrain features at the airport, and…Incident 20010727021169IBeech B200 · Pagosa Springs, CO(-23) Upon approach to the Pagosa Springs airport, the pilot lowered the gear but failed to get a three-green indication. He then recycled the gear while one of his passengers, also a pilot, observed the gear extension from the cabin. The gear appeared to…Accident 20010727020249ATcraft BC12D · Wall, SD(.19) On July 27, 2001, at 1800 central daylight time, a Taylorcraft BC12-D, N39971, sustained substantial damage during landing roll when it nosed over in a field. The 14 CFR part 91 business flight had departed from a private airstrip en route to the Wall…Incident 20010727020212IAmtr LANCAIR360 · Oshkosh, WI(.19)On July 27, 2001, at 1453 central daylight time, a Boeing 727-2Q6, N782AT, operated by an airline transport pilot as American trans air (ata), amtran flight 7991, maneuvered abruptly left during takeoff roll on runway 9 (6,178 feet by 150 feet, dry…Incident 20010727020211IBoeing 7272Q6 · Oshkosh, WI(-23) On July 27, 2001, at 1453 central daylight time, a Boeing 727-2Q6, N782AT, operated by an airline transport pilot as American tans air (ata), amtran flihgt 7991, maneuvered abruptly left during takeoff roll on runway 9 (6.178 feet by 150 feet, dry…Accident 20010727018759APiper PA28R200 · Jeffersonville, IN(.19) On July 27, 2001, at 2140 eastern standard time, a Piper PA-28, N2125T, sustained substantial damage when it hit a deer during landing roll. The 14 CFR part 91 instructional flight had departed bowman field (lou), louisville, Kentucky, and had flown the…Accident 20010726039329ACessna A185E · Yakutat, AK(-23) On t/o @ remote strip pilot lost control & aircraft ran off of runway into trees.Accident 20010726039269ACessna A185F · Kennedy Glacier, AK(-23) During t/o @ 12,000 MSL pilot lost control of aircraft, aircraft crashed & came to rest in Glacier cravas. Pilot fatal, 2 passengers seriously injured.Incident 20010726038629IAmtr Varieze · Mtvernon, MO(-23) Per statement of the pilot. Turbulence was encountered during cruise descent. The cowl and the engine departed the aircraft. A normal approach and touchdown was made to a field. The main gear failed aft and off. The nose gear was retracted. The plane…Accident 20010726038329AScwzer G164B · Wallace, NE(-23) On July 26, 2001, at approximately 0830 CDT, ag cat G-164B, N80083, sustained substantial damage as a result of the loss of engine power while engaged in aerial application near Wallace, Nebraska. The PIC reported no injury resulting from the impact.…Incident 20010726034709ICessna 150F · Sanford, FL(-23) Acft departed sfb enroute ded. While passing 1500', then engine lost power due to the #1 cylinder failing. The pushrod was bent with the intake valve stuck open. The pilot landed in an open field.Accident 20010726026319AAmtr Steenskybolt · Lebanon, IN(-23) While landing at a private airstrip, pilot mis-judged landing approach, undershot runway, aircraft veered to the left and rand into soybeans planted adjacent to the runway, as speed decreased, the aircraft continued to settle and flipped over, coming to…Incident 20010726025199IPiper PA44180 · Winters/Davis/W, CA(-23) During a practice single engine approach, instructor/student forgot to lower landing gear.Accident 20010726023259APiper PA28R201 · Orlando, FL(-23) While maneuvering the aircraft into the parking space on the ramp, the pilots misjudged his distance form the fence bordering the west side of the ramp. He struck the fence with the leading edge of the right wing and wing tip. Damage was limited to…Incident 20010726022659IPiper PA18150 · Chandler, AZ(.19) On July 26, 2001, about 1450 hours mountain standard time, a Piper PA-18-150, N57528, operated by Chandler air service, inc., Chandler, Arizona, ground looped during landing rollout on runway 22L at the Chandler Municipal Airport. Visual meteorological…