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 20120104000049ICostruzioni Aeronautiche Tecna P2002 Sierra · Newport News, VAHard landing during instructional flight which resulted in collasped nose landing gear.Incident 20120103005269IAeropro CZ A220 · Petaluma, CAOn 1/3/2012 at 16:45 PST, airman [privacy data omitted], PIC of an aerotrek A220 was observed by California highway patrol airborne unit, officers [privacy data omitted] and [privacy data omitted], of the golden gate division, air operation unit 314, flying…Accident 20120103000539ACessna 172P · Conroe, TXAircraft departed kiws @ 2120 local time northeast bound, navigated the david wayne hooks airport airspace. Flight continued on with plans to land at kcxo @ 1600FT and 9 miles out received the AWOS information for kcxo. Made contact with kcxo controller…Accident 20120103000299APiper PA-28-160 · San Angelo, TXThe aircraft was substantially damaged during a forced landing after the engine lost power. VMC prevailed at the time of the accident. The instructional flight was being conducted under the provisions of 14 CFR part 91 without a flight plan. The local flight…Accident 20120103000289AButler John R SX 300 · Truth Or Conseq, NMOn January 3, 2012, at 1220 MST a Butler SX-30, N120J, registered to rainbow sports, inc., sustained a hard landing while on a personal flight, visual meterological conditions prevaileld at the time and a flight plan was not filed. The aircraft was…Incident 20120103000109IBeech 400A · Denton, TXAt flight level 310 a low hydraulic level annunciator indicated a loss of hydraulic fluid. Crew returned to Denton airport (dto). Used alternate nitrogen system for gear and braking. Nitrogen system reported to work as advertised.Incident 20120103000029IBombardier DHC-8-402 · Yakima, WAOn January 03, 2012 while on short final to ykm, N405QX struck a flock of 4 or 5 canadian geese at approximately 100 - 200 feet above the runway. Damage was sustained to three blades of the left hand propeller and propeller spinner.Incident 20120102003219ISwanson Raymond H Flightstar II SC · Tulsa, OKThe pilot and a passenger were flying this aircraft when the engine RPM slowed approximately 1,000 rpm's. at that time the pilot tried to add a little power and the engine locked up. The aircraft was flying at approximately 1,ooo ft. the pilot landed the…Incident 20120102000659IMcdonnell Douglas DC-9-83(MD-83) · Vienna, OHAllegiant air flight# 892 from pie to yng was cleared to land on runway 32 @ yng. The aircraft landed safely and then, during taxi, slid off the taxi way during the right turn onto H1. The left main and nose landing gear went off the taxiway and the aircraft…Incident 20120102000479IBeech 58P · St. Louis, MOOn Monday jan 2nd, N77LV was on a part 91 flight to kstl on a four mile final to runway 30R. The aircraft encountered a bird strike to the windshield. The pilot declared an emergency at 1915. The bird strike penetrated the windshield and traveled aft to…Incident 20120102000459IBeech 95-B55 (T42A) · Atlanta, GAVisible damage to left engine prop blades is scaring on the ends with a bend approximately 1 inch from the tip, consistent with an engine making power and lightly striking the runway with the blade tips. Last METAR: 021953Z 28017G28KT 10SM clr 07/M13 A3009Accident 20120102000269AMaule M-5-180C · River Ranch, FLOn Monday, 2 jan 2012, at approximately 1300 EST, N171GS, a Maule M5 + stol mod, experienced a loss of control and subsequent ground loop upon rollout from a landing at River Ranch Resort (2RR) rw 16, River Ranch, FL. The runway was dry, and VMC prevailed at…Incident 20120102000169IPiper PA-18-135 · Del Norte, COAt 1330 local on 01/02/2012 at 8V1 (Del Norte Municipal And County Airport, Colorado) aircraft impacted snow bank on landing rollout causing minor damage.Incident 20120102000079IMooney M20J · Lansing, ILAfter landing on runway 36 at Lansing muni. Pilot intended to retract the flaps due to gusty conditions and mistakenly retracted the landing gear. The pilot returned the landing gear lever to the down position and applied full power to attempt a takeoff but…Incident 20120102000039IPiper PA-22 · Ocala, FLUpon landing the aircraft began putting side load on the landing gear due to a cross wind and lack of control from the pilot. The right landing gear bent under the fuselage and the right wing tip scraped the runway. Additionally the prop struck the runway.Accident 20120102000019APiper PA-34-200T · Shelter Island, NYWinds reported in the area at the time of the accident were out of the west in the high teens gusting to high twenties. Airman was landing on runway 22 which is 1600 feet long. Airman stated he encountered wind shear, which resulted in a hard landing. On…Incident 20120101006479IBeech F33A · Perkasie, PAPilot reported cascading electrical failure in flight. Diverted to Pennridge Airport. Pilot began emergency extension of landing gear and stopped procedure when he was sure he was able to land on the runway. Pilot did not verify gear down or complete the…Accident 20120101000959AHaney John F B Seastar XP · Mansfield, CTDuring a touch and go on runway 27 at Windham Airport in CT , ijd, at the end of the runway at approx 300 ft the aircraft went to a partial power condition, the pilot decreased the throttle then went to full increase, the engine rpm's increased to full then…Accident 20120101000889AMcadam W E Christen Eagle II · Eureka, CAOn landing the pilot veered to the left prior to touch down to avoid a deer on the runway. Aircraft struck a VASI light causing significant damage to the VASI light and aircraft's lower left wing. Pilot recovered and completed his landing.Accident 20120101000549ABell-Continental Copters 47G2 · Lohn, TXPilot stated he did a pre flight inspection per the operator's manual, loaded his passenger for the purpose of pasture count of deer on hunting leases. On the fourth pass on the pasture counts flying slow and low went to make a turn and lost tail authority,…Incident 20120101000129IZephyrhills, FLOn Sunday , January 1, 2012, at approximately 1437 local time parachutist (teresa elaine mclaughlin-wrage) impacted the terrain at Zephyrhills Municipal Airport (kzph) Zephyrhills, Florida.1.name: teresa elaine MCLAUGHLIN2.experience: 600 to 700 jumps 3.club…Accident 20111231030349APiper PA-32-260 · Elk Rapids, MIOn 12/31/2011 at 1150 local time a CFR part 91 pleasure flight departed ktvc for a local sight seeing flight. Pilot stated during cruise flight the engine started running rough and vibrated. Pilot executed emergency checklist the engine continued to vibrate…Accident 20111231029949ACessna 404 · Fort Lauderdale, FLPilot reported, " on ltakeoff got rotation speed, couuld not get airborn, tryed to abort at that time a/c got airborn, and came back up on main gear, bounced back andforth between the main and nose three times til nose gave."provided by [privacy data omitted]Accident 20111231029639APiper PA-25-235 · Jacksonville, FLOn Saturday 31 dec 2011, at approximately 1111 local time, N7408Z, a Piper pa 25-235 "pawnee", impacted a parking lot just south of Craig Municipal Airport, (kcrg), Jacksonville, FL. The pilot suffered fatal injuries and the aircraft was substantially…Incident 20111231029539IPiper PA-34-220T · Salt Lake City, UTOn January 31, 2011 at 1318 local, N104WT, a Piper PA-34-220T, was involved in an incident when the RH main gear collapsed during landing rollout on runway 35 at Salt Lake City International Airport (slc).the aircraft was piloted by [privacy data omitted],…Incident 20111230030199ICessna 172S · Austin, TXPilot was departing aus to waco. Pilot was instructed by ATC to taxi to rwy 17L via lima/bravo from the signature FBO. Pilot mistakenly turned east onto the east service road and wing impacted the fence. Minor damage to the aircraft.Incident 20111230030089ICirrus Design SR20 · Tucson, AZPilot made a normal approach. Upon landing the nose gear of the aircraft touched first and the pilot did not correct in time to avoid nose gear and propeller damage. Aircraft received minor damge. No damage to the aircraft firewall.Incident 20111230030009IDial Robert M Thorp T-18 · Kennesaw, GAPilot reported that during takeoff roll and transitioning to main gear (tailwheel), he encountered a wind gust that caused the aircraft to swerve to the left. He continued to control for takeoff and in recovery a impact was felt of unknown origin after…Accident 20111230029919AFleet Fleet 16B · Marion, TXPilot stated he performed a standard pre flight had a normal engine start and run up, departed Zuehl field for a local pleasure flight. Approximate 15 to 20 minutes into the flight the engine surged two or three times then the engine stopped completely. He…Accident 20111230029859APiper PA-28-161 · Fuquay_varina, NCThe pilot in command departed sanford- lee county airport after receiving limited weather information indicating strong gusty winds. While enroute to Triple W Airport, he checked ASOS from johnston county airport which reported wind at 8 knots. No weather…Incident 20111230029799IBombardier CL-600-2C10 · Baton Rouge, LAWhile repositioning the aircraft from the maintenance hanger to the terminal, the pilot did not swing wide enough at a 90 degree taxiway turn and dropped the right main into the mud.Incident 20111230029749IJacobsen Jens SEA REY · Fort Pierce, FLOn Friday, 30 dec 2011, at 1559 EST, N49DJ, an experimental amateur-built "searey" amphibian, experienced a left main landing gear (lmlg) and tailwheel collapse upon landing rollout on rw 10R at st. Lucie county Int'L airport (kfpr), Fort Pierce, FL. The…Incident 20111230029709IBeech C24R · Torrance, CAOn 12/30/2011 at 1424 PST, N3803B, BE24 was unable to lower the right main landing gear and landed on runway 29R at Torrance airport (ktoa) with all three gear retracted.Accident 20111230029389AKoth Larry Jabiru Calypso · Mansfield, MAThe pilot stated that he had made a series of short flights "in ground effect" on runway 32 for a flight check in reference to an adjustment to increase the angle of incidence of the left wing to correct for a left rolling tendency. The pilot had confirmed…Incident 20111229028789IPiper PA-32RT-300T · Linconton, NCOn December 29, 2011, N828SR, a Piper PA32RT-300T departed (hky) hickory regional airport for (ipj) lincolnton/lincoln county airport. [privacy data omitted] The owner of the aircraft and private pilot was at the controls with [privacy data omitted], a…Accident 20111228030099AMaule M-7-235 · El Dorado, TXThe pilot ground looped while landing in a moderate (10-12KT) crosswindAccident 20111228029849ACessna 650 · Ft Lauderdale, FLOn aircraft takeoff aircraft rolled right uncommanded and began a turn to the right. Pilot attempted to correct . Upon gaining runway visual pilot proceeded to land. He touched down half way down runway and ran off end through fence prior to aircraft stopping.Accident 20111228029819ASchweizer SGS 1-26B · Lake Elsinore, CAN8641R, a Schweizer sgs 1-26B glider, departed Skylark Airport, Lake Elsinore, and encountered a down draft 4 to 5 miles southeast of the field. Pilot landed on a high plateau striking a mailbox. Substantial damage to the aircraft and no injuries to the…Incident 20111228029649ICessna TR182 · Avalon, CAPilot departed kajo at approx 1130 on December 28, 2011 to kavx. Upon landing at kavx approx 1200 pilot stated he did not lower aircraft landing gear and landed the aircraft with the gear retracted. Pilot stated he did not hear the gear up warning horn when…Accident 20111228029629APiper PA-28-180 · Lebanon, OHThe accident occurred on December 28, 2011 at 1600 local 911 dispatchers received several call reporting aircraft crash, the plane is located in the back yard next to a barn at [privacy data omitted], Lebanon, Ohio. The aircraft was substantially damaged and…Incident 20111228029279IPiper PA-32R-300 · Grants, NMOn December 28, 2011, at 1545 MST, aircraft N1723H, a Piper lance PA-32R-300, registered to co-operative crossroads flying club, was on a cross country flight from phoenix gateway airport (iwa) to double eagle airport (aeg), under visual flight rules.…Accident 20111228029239AMitsubishi MU-2B-20 · Picayune, MSDuring the landing the pilot experienced a hard landing.1. Nose gear collasped.2. Left main tire and hub separated and blew out.3. Left and right upper and lower wing spar damaged.4. Left and right side of nose bay area wrinkled aft of pressure vessel.5. Left…Incident 20111228029189IAir Tractor AT-602 · Gilbert, LAPilot was landing aircraft and pulled prop back into feathered position. Aircraft accelerated and pilot was not able to stop aircraft before the end of the runway. Aircraft departed runway, crossed road and stopped in ditch. No injury to the pilot; minor…Incident 20111228028339IAirbus Industrie A319-132 · Sacramento, CAUs airways flight 335 encountered multiple birdstrikes to number one engine while on approach to Sacramento international airport. The landing was uneventful. A postflight inspection revealed damage to the number one engine inlet cowl at the 12 o'clock and 3…Accident 20111227029999ARyan Navion · Concord, CAPilot performed a take off on runway 32R, Concord, CA..at an altitude of approximately 200 feet the engine quit, pilot banked aircraft left, lowered the landing gear, pilot noticed while aircraft was losing altitude that it was going to land on or hit…Incident 20111227029909IAlden Richard C Lancair 320 · Burleson, TX[privacy data omitted] Stated he was distracted by a radio call while executing his prelanding checklist and missed the step to lower the landing gear handle. When on final approach he began a second prelanding checklist and again was distracted by a radio…Incident 20111227029809IBoeing Of Canada/Dehav Div DHC-8-311 · Charlotte, NCOn 12/27/2012 piedmont flt#4184 gsp to clt at approximately 15:10 EST. Aircraft N328EN expirenced a low level windshear warning at 200 ft. AGL requiring moderate (40%) torque to fly through. Approach was then stabilized and landing was turbulent but stable.…Incident 20111227029669IEmbraer EMB-120ER · Salt Lake City, UTOn December 27, 2011, at approximately 1900 MST, an EMB-120ER, N299SK, operated as skywest airlines flight 1302, struck five runway lights during takeoff from runway 34L at the Salt Lake City International Airport, Salt Lake City, Utah. Night visual…Incident 20111227029399IDehavilland DHC-6-300 · Perris, CAA skydiver was fatally injured after impacting a pond while in a horizontal position under an open parachute.Incident 20111227029359IBoeing 737-3H4 · Sacramento, CASouthwest airlines flight 2287, a Boeing 737 aircraft, attempted to depart the Sacramento international airport at approximately 1813 hrs on December 27, 2011. During the take off roll at approximately 95 knots, the take off was aborted due to blown main…