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 20110205003999ACessna 150L · Gonzales, LAPilot was returning from btr after several hours of flight instruction, experienced engine failure which appears to be due to fuel starvation. On final approach to a pasture the pilot hit the top of a tree and crash into the pasture, with substantial damage…Accident 20110205003129APiper PA-12 · Sebago Lake, MEA telephone interview was conducted on 2/23/2011 by ASI ron hodgdon with mr. [privacy data omitted] [privacy data omitted] is the[privacy data omitted] in command of Piper PA-12, N3806M. [privacy data omitted] Is presently in Maine medical hospital recovering…Accident 20110205002429AGrumman ACF G-164B · Buttonwillow, CAOn 02-05-2011, 9.30AM (local) an aerial applicator , while conducting an aerial application operation, hit a standpipe (irrigation pipe) with its propeller. The aircraft at the time of the accident was laying down smoke to identify the wind direction for…Accident 20110205001949APiper PA-34-220T · New Orleans, LAPilot flying from austin TX. To bogalusa la. Landing in bogalusa pilot reported he was hit by a gust of wind, aircraft lifed up and than dropped down hard. Started a go-around realized aircraft was yawing to the right and had a gear unsafe light. Decided to…Accident 20110205001819APiper PA-16 · Fort Atkinson, WIOn February 5, 2011 at 1505 CT, the pilot of a Piper PA-16 made an emergency landing on lake koshkonong, near Fort Atkinson, WI. The pleasure flight was conducted in visual meteorological condition and a flight plan was not filed. The pilot was unijured and a…Incident 20110205001379IPiper PA-28R-180 · Lamar, COOn feb 5, 2011, [privacy data omitted] acted as pilot in command of N4557J. Aircraft touched down at Lamar (laa) with landing gear in up position. Aircraft sustained damage to propeller and under belly; no injuries or damage to other property.Accident 20110205001059APiper PA-28-181 · Minden, NVStudent pilot solo. Lost control while landing, exited runway 34 and came to rest in a ditch.Incident 20110205000929ICessna 140 · Rangeley, MEPilot was attempting to land on a frozen lake. The Landing area was plowed in preparation for a fly-in that was scheduled. The pilot while on short final realized he was aligned on the wrong side of the cone markers. The pilot attempted to correct, caught a…Incident 20110205000909IBoeing 737-890 · Chicago, ILAlaska airlines flight 7702, aircraft N560AS, a Boeing 737-890, serial number 35179 was parked at o'hare international gate L-1 preparing to depart to puerto vallarta Mexico with the crew and passengers on board. A prospect service truck #201 drove under the…Incident 20110205000769ICessna 152 · Middleton, WIA student pilot was on a solo flight performing touch and goes. Upon landing the student mismanaged the controls and hit a snow bank on the side of the runway.Incident 20110204002749ICessna 172P · Fort Pierce, FLStudent pilot in CE-172, N54855, was taxiing out 10R for departure when student pilot instructed by CFI to move a "little" left on runway to avoid aircraft at taxiway intersection doing run-ups. CFI notices aircraft moving to right on taxiway and took control…Accident 20110204002599AMcdonnell D 369E · Elverta, CAWhile assisting in hanging tensioning pullies on pull rope used to string cables between large electrical towers, helicopter came in contact with pull rope strung between towers and tangled rotor mast, 3 rotor blades were broken and helicopter went to the…Incident 20110204002209IRaytheon Ai C90A · San Jose, CADuring take off of aircraft N99DW, which was piloted by [privacy data omitted] from runway 30L at the sjc airport, a loss of power was noted by the right seat pilot [privacy data omitted]. At this time [privacy data omitted] assumed control of the aircraft…Incident 20110204001299IEmbraer-Emp ERJ 170-200 · New York City, NYShuttle america flight number 5950 on February 5 2011, operating between ord and lga. 15 minutes into the flight experienced moderate turbulence without any warning east of lake Michigan north of gij VOR while level at FL310 on the way to FL350. Reported…Incident 20110203003549IBeech 76 · Redding, CAOn feb 3, 2011 at approximately 14:04 PST Redding municipal airport…aircraft N6628X a BE-76 shortly after touch down veered off runway 34 into the midfield. The aircraft had been involved in completing several touch-and-go departures. On the final touch and…Incident 20110203002419IRaytheon Ai BAE 125-800 · Chesterfield, MOPILOT HEARD A LOUD BANG FROM THE LEFT ENGINE AND NOTICED ITT DECREASING. ENGINE WAS SHUT DOWN AND PILOT RETURNED TO KSUS, APPROXIMATELY 24 MILES WITHOUT INCIDENT. AMENDED 09/27/2011 AS FOLLOWS: Inspection of the engine tailpipe revealed ferrous metal…Accident 20110203002239AAeronca 0-58B · San Luis Obispo, CAPilot stated, while in cruise level flight, engine began operating rough, so he applied carb heat, but engine subsequently shut down. Pilot stated he successfully performed an air start but engine shut down again. Pilot stated he committed to an emergency…Accident 20110203001789ACessna 402C · Albuquerque, NMOn February 3, 2011, at approximately 0805 MDT, N5820C, a Cessna CE-402C, s/n 402C0047, registered to south aero, inc. departed abq on a VFR flight to lvs. Following gear retraction, the pilot reported to abq ATCT that the hydraulic pressure light was still…Accident 20110203000739ARobinson He R44 · Ogden, UTDuring a demonstration practice engine out autorotation, the pilot mismanaged the controls resulting in low rotor RPM and slower than normal airspeedpilot used an incorrect procedure to attempt to regain rotor RPM without success, at about 200 feet above the…Accident 20110202028359AFouga CM 170 Magister · Kissimmee, FLOn February 2, 2011 at approximately 1733 eastern standard time (EST) (UTC -6), a CM-170 Fouga magister, registration N415FM, operated by a private individual crashed short of the runway while attempting to land on runway 24 at Kissimmee Gateway Airport…Incident 20110202000799ICessna 310R · Pelion, SCOn February 2, 2011, about 1450 eastern daylight time, a Cessna 310R, N15AT, received minor damage when it landed at Pelion airport (6J0) at Pelion, south carolina on runway 18 and the landing gear collapsed on touchdown. The certificated private pilot was…Incident 20110201007149IPiper PA-28R-200 · Titusville, FLThe acft touched down on rwy 9 with the ldg gear partially extended. The CFI & CFI student on board aborted the landing and initiated a go-around as the acft began contacting the rwy. The CFI then contacted tix ATCT and confirmed during a tower fly-by that…Incident 20110201001629IBoeing 767-2B7 · Charlotte, NCUpon landing at the Charlotte Douglas international airport (clt) on runway 23 the left engine nacelle ski jump fairing separated from the aircraft. Engine serial number = 69567Incident 20110201001209IMcdonnell D MD-10-10F · Newark, NJAt 0923 local time in ewr, N567FE an MD10 was parked on fedx spot 1 at ewr. N399FE another MD10 was parked on the center line and being deiced by a bucket truck being operated by omni serve (a vendor). While the bucket truck was moving off of the RH wing on…Accident 20110201000749ACessna 182K · Eastsound, WA[privacy data omitted] Intended to fly his C-182, but found his battery too weak to start the engine. He decided to start the engine by propping it. On his first attempt, the engine briefly started then died. On the second attempt the same thing happened and…Accident 20110131003209AMcdonnell D 369FF · Avra Valley, AZAircraft crashed while landing on a pinnacle to drop off personnel to assess site for a new antenna location. Arrived at base of peak of scene of accident and made contact with local law enforcement (pima county sheriffs department, pcsd). Weather and…Accident 20110131002409ACessna 172 · Glendora, CAOn 1/31/2011, at 15:28 hours pacific standard time, a Cessna 172 crashed into the foothills of Glendora, CA. The airplane departed from Brackett Field in la verne, CA earlier that afternoon. According to the glendor police departments incident report, the…Incident 20110131001609ICostruzioni P92 Eaglet · South Hackensac, NJAircraft experienced engine failure during descent into teb airport. Pilot was balancing fuel and had the right tank/valve off. When selected back on, he stated the engine surged then failed. Attempt at restart was unsucessful. Pilot landed on I-80 near exit…Incident 20110131001399IEmbraer EMB-145LR · Vandalia, OHExpress jet flight 2693 slid off runway 6R after landing (at intersection of rwy 6R & RWY36). Minor damage to gear door. No injuries reported.Incident 20110131001259ICessna 172RG · Hickory, NCAt approximately 1820 on January 31,2011 the nose landing gear collapsed upon landing on Cessna N5209V. The student ([privacy data omitted]) was on his second lesson to become familar with the aircraft. We were doing touch and go'es on runway 6. On his six(6)…Incident 20110130002879IBombardier CL-600-2C10 · San Antonio, TXOn January 30, 2011, a Bombardier model CL-600 aircraft operating for mesa airlines cert. (Masa) departed chicago o'hare (ord) flight number 7195 to San Antonio, Texas airport (sat). Upon arrival and during preparing to deplane pax, the ground handler…Accident 20110130002389APiper PA-30 · Big Bear City, CABig Bear, CA: N64RJ, PA30, shortly after takeoff from big Bear arpt, crashed under unkn circumstances into the roof of a house at approx 300719PST. The pilot was transported to the hospital with unkn injuries, however, he did walk out of the crash. 1 person…Accident 20110130002049AOtterback N Lightning · Crescent City, FLOn January 30, 2011 at approximately 1545 EST, an arion Lightning, experimental (N324AL), serial # 59, landed hard on second attempt to land and ran off runway 18 at eagles nest airport (FD44), Crescent City, Florida. The flight was conducted as a personal…Accident 20110130001849AErcoupe 415-CD · Hess Lake, MIPilot stated that he was at a local fly - in on a frozen lake ( Hess Lake)that had a snow plowed runway. While taking off his left wing tip contacted a snowbank flipping the aircraft onto its nose.Incident 20110130001829IRaytheon Ai C90A · Seneca, SCAircraft was landing at about 0115 on the morning of January 30, 2011. Aircraft was on the runway, flaps were up, braking applied, and began reversing props. Two deer ran from left to right across runway. The second deer was hit by the left engine propeller.…Accident 20110130001589AExperimenta Excalibur · Immokalee, FLOn January 30, 2011, at 0845 local time, [privacy data omitted] crashed his experimental light sport aircraft at the Immokalee Airport, Florida. The aircraft was destroyed and [privacy data omitted] suffered a broken left ankle. [privacy data omitted] States…Accident 20110130001239AKolb Aircra Kolb Mark I · Rutherforton, NC[privacy data omitted]Accident 20110130001029ACirrus Desi SR22 · Bennett, COWhile practicing instrument approaches at front range airport (ftg) during night flying conditions, pilot became spatially disoriented and lost control of aircraft. Pilot deployed airframe parachute, and aircraft impacted ground nose first.Accident 20110130000729ACessna 172P · South Point, OHPilot stated, after departure from runway 8, the aircraft engine suddenly began to run rough during the climb. Pilot stated he executed a steep left turn with intention to land on runway 26. During approach pilot stated he was too high and subsequently…Accident 20110129005209AMooney M20J · Death Valley Na, CAThe aircraft went down shortly after takeoff on November 29, 2011, for unknown reasons approximately 6.7 miles south of the Furnace Creek Airport located in the Death valley national park. The aircraft impacted the ground in a dry lake bed comprised of an…Accident 20110129003179ACessna 172S · Saint Petersbur, FLOn 01/25/2011 at approximately 1345 n 6013J departed the runway after normal landing and contacted a metal fence with the left wing substantially damaging the aircraft. Pilot states that ATC instructions were cleared to land, full stop as wind conditions had…Accident 20110129001929APiper PA-28-161 · Chamblee, GAStatement received from pilot states he made an unintentional wide turn and felt he misjudged the turn and should have started turn earlier when cleared to taxi. States it would have been a better outcome if he would have come to a complete stop. Aircraft…Accident 20110129001541ACunningham MODEL-1 · Burlington, IAAircraft entered the traffic pattern at Southeast Iowa Regional Airport in Burlington, Iowa (kbrl). The aircraft had no radio on board so no position calls were made. The aircraft landed on rwy 36. During rollout and prior to exiting the runway, the landing…Accident 20110129001531AErtz Mark G Zodiac 601X · Burlington, IAThe pilot of the zodiac made several radio transmissions prior to and while in the local traffic pattern for runway 36 at Southeast Iowa Regional Airport in Burlington, Iowa (kbrl). He was communicating with other aircraft throughout the event. The aircraft…Accident 20110129001489ACessna 182K · Adrian, ORAircraft departed ontario, Oregon (kono) at approximately 2000 local time, enroute to nampa, Idaho (kman). At approximately 2030 and for unknown reasons, the aircraft impacted terrain approximately 2 miles south of Adrian, Oregon in a wings-level attitude.…Accident 20110129001479AMiller Greg GOT Rocks · Skwentna, AKAirman made a off airport landing on mount susitna. Landing was made on ski's in snow conditions. During the departure roll aircraft flipped over on its back.Accident 20110129001439AMooney M20R · Cypress, TXAt 0825 CST, aircraft impacted trees, power lines & power pole approximately 1/2 mile NE of Weiser airpark. Student pilot states that he was attempting to land on runway 09 at keyq. During the approach, he noticed he was a little high & a little fast, but…Incident 20110129001271IAero Comman 100-180 · Miami, FL[privacy data omitted] Got into his airplane and started it up with no intent on going flying, aircraft was still tied down. Once he started the aircraft he was taking a video of the whole aircraft to send it to a perspective buyer. After filming the cockpit…Incident 20110129001069IAmerican CH 7GCBC · Palo Alto, CAOn second approach to runway 31, the aircraft was onspeed, on center line, on glide path with good crosswind correction. Upon touchdown, a go around was initiated. During go around procedure the pilot noted a significant thump coming from the tail section.…Accident 20110129001039AMcholland C Solitaire · Wellington, COAircraft was on short final to runway 27 at 4CO2. Upon crossing interstate highway 25 a severe unexpected down draft was encounted. The runway was not attainable. In order to avoid a railroad track bed on a raised berm the pilot attemped to turn aircraft…