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 20120723021899IGrumman G-44 · Northway, AKPilot landed in Northway Alaska without any problems. At the end of the runway the pilot had trouble turning the twin engine tail wheeled aircraft around to taxi back to parking. The aircraft did a left 360 and another 180 on the ground before heading back…Incident 20120723018959IBeech 35-C33A · New Braunfels, TXPilot landed airplane with the landing gear in the retracted position. The aircraft came to rest on the centerline of runway 13.Accident 20120723018699APiper PA-25-235 · Off Of Westerly, RIAircraft departed Westerly, RI (wst) for a banner towing operation along the shore of block island, RI. The pilot reports that while in cruise flight at 650 feet over block island sound, the engine shuddered violently and immediately began losing power.…Incident 20120723017819IBoeing 737-823 · Chicago, ILAa flight #1725, boston to Chicago, declared a medical emergency due to an injured flight attendant. The flight attendant tripped over a passenger and injured her back. The flight attendant was taken to a local hospital and then was released without being…Accident 20120723016769AAero Commander 500 SDuring an air-attack coordination for aerial forest firefighting activities, the aircraft remained on station for approximately 4 hours and 30 minutes. Upon return to Elko, both engine started surging with a subsequent complete engine power loss. An emergency…Accident 20120723016579AJeffko ED & Claire Glasair · Tonasket, WAOn July 23, 2012, aircraft did not arrive at its planned destinatin of sequim valley airport, sequim, WA. Pilot was presumed to have sustained fatal injuries. Flight departed Tonasket Municipal Airport, Tonasket, WA around 0830. Aircraft remains missing.…Incident 20120723016079IBoeing 737-3Y0 · Minneapolis, MNBird strike on final approach to 30L. Dent on inboard leading edge, right wing.Incident 20120723015249ICessna 210L · Omaha, NEPilot noticed an unsafe gear indication. Requested low pass by tower to verifiy gear down and locked. Aircraft landed without incident.Accident 20120723012239ABoeing 747-451 · TokyoApproximately 1 1/2 hours prior to landing a fa was walking the stairs leading from the upper deck to the main cabin. She missed the last 3-4 steps and fell. There was no turbulence and the seat belt sign was off. Doctor onboard assisted in the care of the…Accident 20120722018739ACessna A185F · Mapleton, MEPilot stated that he took off from a private field in ashland Maine. Said he was going to presque isle (pqi) to get fuel. He stated that there was 26-28 gallons of fuel on board when he took off. He decided to do some VOR work on his way to pqi. Pilot stated…Accident 20120722016959ACirrus Design SR22 · Pickens, SCAt approximately 9000 ft. enroute from mccullom field (ryy) Georgia to greensboro (gso) in north carolina the aircraft engine ran rough and quit. The pilot declared an emergency with greer approach and was directed to Pickens County Airport (lqk) in south…Incident 20120722016879IDehavilland DHC-2 MK. I(L20A) · Talkeetna, AK7/22/2012 At 12:40 p.m. PIC taxied out to runway 18 at the Talkeetna state airport, performed a run-up and everything was fine.PIC added take-off power and at approximately 1/2 way down the runway the airplane lost power when 100 feet in the air at 12:45 p.m.…Accident 20120722016649ALuscombe 8A · Leander, TXOn 07/22/2012 at approximately 2045Z, the pilot of N71743 with one passenger attempted to take off on runway 17 at Kittie Hill Airport for a 91 VFR pleasure flight. Upon take off the pilot stated he was not able to get the aircraft to climb and was not able…Accident 20120722016539ACubcrafters CC11-160 · Stanley, IDOn landing, the pilot applied the brakes and the aircraft pitched forward and flip onto it's back. Pilot exited safely.Incident 20120722016299IPiper PA-38-112 · Coshocton, OHN528W departed Richard Downing Airport (I40) just before 7:00 local on 7/22/2012. After completing the after takeoff check turning off the fuel boost pump. The engine suffered a significant power reduction that the pilot was unable to correct. The pilot…Accident 20120722016159AYamokoski William Glastar · Chicago, ILOn July 22, 2012, at approximately 13:00 CDT, N4970Y an experimental amateur built Glastar, enroute from oshkosh, WI to benton harbor, mi declared an emergency to gary tower due to loss of engine power. The aircraft landed in an empty dredge field along lake…Incident 20120722016129IPiper PA-28R-180 · Escondido, CAPilot was returning from mammoth lakes. Flight to mammoth took 2.7 hr. Pilot had fuel tanks topped in mammoth. Took 26 gal. (Verified by FBO at mmh) plane has 48 gal usable fuel. Pilot planned fuel for 3.25 hr return flight: approx 33-35 gal total. Time…Accident 20120722016119APurtee Kevin M Pietenpol Aircamper · Brodhead, WIAircraft lost power shortly after take-off, stalled and spun into cornfield 1/4 mile from airport. Investigation showed water in fuel was likely cause.Accident 20120722016089AToman Jack JR Skystar Kitfox 4 · Crosslake, MNAircraft was on pleasure flight over whitefish lake near Crosslake, MN. The aircraft was observed to be about 300-500FT AGL in a nose high attitude when it rolled left and impacted the water nose first causing fatal injuries to the pilot in command and…Incident 20120722016049IHalverson Russell D Sonex · Oshkosh, WIOn July 22, 2012 at 1500 local N292SX experienced a loss of power after take off in Oshkosh wisonsin and made an emergency landing. N292SX, a Sonex experimental aircraft departed runway 27 then experienced a loss of engine power. The aircraft made an…Incident 20120722015929IGarrett James C Europa XS · Torrington, WYOn 07/22/2012, at approx. 0600HRS MDT, experimental europa, N67JG, sustained minor damage after emergency off-airport landing due to partial power failure. 1 POB, no injuries.Incident 20120722015609IAir Tractor AT-502B · Palacios, TXWhile landing at the company's private ag strip (3XS1) for the third time that day, the pilot stated that he landed slightly left of center on the grass runway #32. During the roll out, the left wing spray boom contacted the un-mowed tall grass. The aircraft…Incident 20120722015579IRaytheon B200 · Martinsville, VABlue ridge airport, Martinsville, VA: N500VA, a BE-200, landed gear up on runway 30. The local fire and police department responded and gave assistance. Injuries: none, damage: minor, 7/22 0415ZIncident 20120722015309ICessna 150L · Council Bluffs, IAA student was performing his first supervised solo after completing 4 touch and go's with the flight instructor on board. Under nearly calm winds, on the first landing, the student landed on the nosewheel and bounced. Upon settling to the ground, the…Accident 20120722015019ADornier DO 27 B5 · Jackson Hole, WYOn 7/22/2012, approx. 1100MST, N780AX impacted terrain vic jac, WY. Sub damage, 2 POB no injuries.Incident 20120722014699ICessna 150G · Richardson, TXAircraft departed arlington municipal airport, arlington TX, enroute to dallas airpark, dallas, TX (F69). Aircraft remained clear of class bravo airspace to the east of dallas enroute, resulting in depletion of fuel on board. Pilot had added 6 gallons of gas…Accident 20120721023019ACessna 172M · Hammond, NYUpon landing on the mowed landing strip, the pilot experienced a gust of wind from the right side, causing the aircraft to roll off the runway to the left. The aircraft hit a small ditch breaking the nose gear, and the aircraft flipped over causing…Accident 20120721021029AAtlas Township, MIOn July 21, 2012 at approximately 3 pm eastern time, an unregistered eipper quicksilver mxl sport ii, home built - light sport aircraft, equipped with floats, departed from a residence on the western shore of lake shinanguag in goodrich, MI for a local…Accident 20120721020569APiper PA-22-150 · Augusta, KSOn July 21, 2012 at approximately 11:30AM, a private pilot was operating a 1956 Piper PA-22-150 tri-pacer from Augusta Municipal Airport (3AU) when they experienced ineffective braking upon landing. The pilot was planning to fly a family member, the only…Incident 20120721019209ICessna 210N · Waterford, MIOn 7/21/2012 at 1410L N5426Y veered off runway 27R at ptk during landing roll out. The aircraft went off the north side of runwy 27R just east of taxiway k. the propeller struck a runway edge light before aircraft taxied across the grass and onto the parallel…Accident 20120721018729ARepublic RC-3 · Snohomish, WAWitness said it didn't sound like the eng was developing full power. They thought the pilot was doing a high speed taxi and not going to take off. Pilot lifted off clearing the fence and just barely flying. Struck a tree top stalled and crashed in a pond next…Incident 20120721017419IPerner/Pitts S1S · St Augustine, FLPilot was flying in formation and landed long to allow other aircraft to land behind him. The ground roll took him to the over run area and ran into soft ground. The aircraft flipped over and landed on the top of the fuselage.Incident 20120721017249IDunseith, NDSmoke entered the cockpit. Returned towards KS28. Turned off master switch to stop smoke. Landed at KS28 gear up.Accident 20120721016149AMooney M20J · Oshkosh, WIOn July 21, 2012, at approximately 1620 CDT, a Mooney M20J airplane, N339PB, was substantially damaged when, on landing at Oshkosh, Wisconsin, it bounced several times, veering to the right exiting runway 36R. The aircraft struck several vehicles parked along…Accident 20120721016059APiper PA-20 · Cooperstown, NYOn 7/21/2012 at approximately 11:15AM while taking off runway 2 on a northern heading, at very low altitude, the aircraft drifted into a cornfield on the east side of the runway departure end and flipped upside down landing in a southern heading. The corn…Accident 20120721015819AMooney M20E · Mark Tree, AROn July 21, 2012, at 0829 CST, a Mooney M20E, N1310W, [privacy data omitted], attempted an emergency landing contacting the ground short of Mark Tree, Arkansas airport, while on an animal rescue flight. Visual meteorological conditions prevailed at the time…Incident 20120721015669IGrumman American Avn. AA-5A · Houston, TXOn 07/21/2012 while landing at ellington field (efd) Houston Texas, pilot stated that he was making a standard approch to runway 35L, and that his landing was "flat" and when the aircraft touched down the aircraft bounced back into the air. The pilot pushed…Incident 20120721015269IPiper PA-24-250 · Belton, SCOn July 21, 2012, at approximately 1645 hours, N7134P, a Piper PA-24-250, ran off the end of the runway trying to miss a deer at oak hill field (SC82) in south carolina. Two people were on board the aircraft including the pilot. There were no injuries…Accident 20120721014869ACessna 182A · Farmingdale, NJOn 7/21/2012, at approximatley 17:00 EDT a Cessna CE-182-A, serial number 51466, N2166G, was involved in a landing accident while approaching runway 14 at kblm. According to the pilot's interview and written and signed statement the aircraft was at about 100…Accident 20120721014689AAeropro CZ A220 · Bremerton, WAPilot stated that a gust of wind caught the aircraft on landing causing the a/c to veer off runway. Lt main gear leg broke causing the prop to hit the ground and the airframe to twist leaving wrinkles in fabric along the rt side of fuselageAccident 20120721014659ANanchang China CJ-6A · Walsenburg, CO1800HRS, 7/21/2012, N96YK impacted terrain 1/2 mile west of 4V1, 2 POB, 2 fatally injured, aircraft was substancially damaged.Incident 20120721014469IGonzenbach Jack Lightning · Osh, WIOn July 21, 2012, at 1430 CST an arion Lightning, N874HA, landed hard on the nose gear after flaring high at oshkosh, WI. The private pilot and one passenger received no injuries and the aircraft sustained minor damage. The aircraft was being operated by…Accident 20120721014459ABertram William J Bertram 2000 · Shiocton, WIPilot was operating aircraft near Shiocton Airport flying approximately west, parrallel to hwy 54 and east of mack road. Aircraft impacted a power line support cable, spun twice, and landed in a ditch approximately 15 feet north of hwy 54. Pilot was the only…Incident 20120721014079IBloodworth Tommy Lancair IV-P · Asheville, NCRetractable nose gear collapsed damaging the propeller. Nose gear drag links are made of steel stock and were unpainted with light rust. Forward, middle and aft drag link mount bolts were extremely loose with play in the the shear direction. Nose gear retract…Accident 20120721013819APiper PA-30 · Yelm, WAPilot cut power too soon and dropped in from approximately 50 feet, had to come in to land over tall trees and get down to runway quickly due to length of runway. Nose gear and rt main gear collapsed, rt main wheel broke off and hit stab, both props damaged,…Incident 20120721013769ICessna A188B · Anahuac, TXA Cessna 188A ag wagon, being operated by chambers county mosquito control experienced a sudden engine RPM drop during a climb over Anahuac Texas. The pilot reported while heading westbound over the city, to perform aerial application the engine rpm's drop to…Accident 20120721013759ABeech A24R · Miami, TXThe aircraft departed a private runway near Miami, Texas for a private flight. The aircraft was being operated by the owner, who holds a private pilot certificate. After approximately 1.5 hours of flight, the aircraft impacted terrain approximately 300 yards…Accident 20120721013599AHerem Gary DR-107 · Bridger, MTOn Saturday July 21, 2012 during the annual Bridger days celebration and fly-in, witness reports indicate that N58GH [privacy data omitted] took off from the Bridger Airport (6S1) at approximately 09:15 local (mdst) using runway 34, climbed at what appeared…Accident 20120720024509APiper PA-28-180 · Statesboro, GAOn July 21 at 1030 am approximately an inspector from this office arrived at Statesboro ga. Specifically a location in a tree line between a peanut field and soy field (henry mikell lane). Inspector keberly was responding to the original notification of the…Incident 20120720021659IPiper PA-24-250 · Fredonia, AZOn 07/20/2012 at approximately 1030 hours, the pilot of N6086P, a Piper PA-24 airplane, reported to the coconino county sheriif's office that he had made an emergency landing on a gravel forest service road near Fredonia, Arizona. Deputies responded to the…