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 20120728014679IMooney M20C · Spanish Fork, UTUpon landing at Spanish Fork Airport. Pilot reported that he failed to engage the gear as he was distracted on approach.Accident 20120727029089AMooney M20TN · Adrian, MINotified 0935 local by Lenawee County Airport manager that there was an aircraft accident. He stated that is a single engine Mooney and the pilot was not hurt. The aircraft was facing northeast on the west side of the runway opposite the direction of impact.…Incident 20120727026599IGates Learjet 35A · Johnstown, PAUpon touchdown at kjst, N298CK (lifeguard flight) exited the left side of runway 33 into the grass. The aircraft struck six runway edge lights and a distance remaining sign before completely coming back on to the runway. As a result, there was minor damage to…Incident 20120727021089IAeropro CZ Eurofox LSA 2K · South St. Paul, MNPilot stated that after landing he was taxing and a 3/4 crosswind gust caught aircraft causing it to spin around and break the right gear leg.Incident 20120727018409ICessna 210B · Fort Worth, TXOn Friday, July 27, 2012 at approximately 5:08PM CST, Cessna 210B, N9571X, landed on the IH35 south bound access road approximately 4 miles west of the Fort Worth spinks airport (fws), Texas. The aircraft landed gear up and flaps up shortly after departure of…Accident 20120727017429ABell 47G-2A · Austin, INThe aircraft was on its third low level pass at 2-3 ft altitude at approximately 60 KTS over a soybean field doing aerial application operations. The pilot glanced at his agnav GPS and then he noted a noise from the left spray boom that sounded like leaves or…Accident 20120727016222AAndrews Joseph C JR VAN RV-4 · Valentine, NEOn July 27, 2012, a flight of four rv aircraft were returning home from the oshkosh air show on a leg from jackson, MN (kmjq) to Valentine, NE (vtn). The flight was operated under visual meteorological conditions with a loose formation of ¼ mile between…Accident 20120727016212ASmith Harold H RV-6 · Valentine, NEOn July 27, 2012, a flight of four rv aircraft were returning home from the oshkosh air show on a leg from jackson, MN (kmjq) to Valentine, NE (kvtn). The flight was operated under visual meteorological conditions with a loose formation of ¼ mile between…Incident 20120727015719IAeronca 0-58B · Shirley, NYPilot states he was attempting a landing on the grass area on the north side of runway 24 at hwv and while avoiding a collision with multiple deer, ground looped the aircraft and struck a runway/taxiway sign.Accident 20120727015649APiper PA-24-250Aircraft made emergency landing on airport property after experiencing loss of engine power. Touched down in a parking lot hitting a chain link fence. Broke lt. wing approx 4 ft from wingtip. Rt. Wingtip fuel tank severed. Propeller was bent. No rotational…Accident 20120727015439AInterplane Skyboy EX · Sandy, ORWhile climbing out after departure, the PIC said he experienced a sudden loss of power. The engine did not quit completely, but loss enough power that the aircraft could not continue to climb. Because of the wooded area surrounding the airport, the PIC said…Accident 20120727014989ABeech 95-A55 · Homerville, GAPilot stated by telephone that the aircraft was flying south at 5000FEET when the left hand engine stopped producing power. He feathered the propellor on the left hand engine and prepared for an emergency landing. He landed the aircraft and rolled about 1500…Incident 20120727014589IWeber Larry D Titan Tornado II · Oshkosh, WIOn July 27, 2012, a tornado titan ii, N9168P, landed hard at osh, Wisconsin during airventure 2012. The private pilot, operating the aircraft for pleasure under CFR part 91, sustained no injuries. The aircraft sustained minor damage. Visual meteorological…Incident 20120726018569IDower Dale RV6-A · Clinton, WA[privacy data omitted] Stated that he had run out of fuel.Incident 20120726017189IPilatus PC-12/45 · Harrison, AROn July 26, 2012, at 1745CDT, a Pilatus PC-12, registered to seaport airlines encountered severe turbulence descending from 17000FT to 16000FT into Harrison, Arkansas. Instrument meteoroligical conditions prevailed until reaching 16000FT. The aircraft was on…Incident 20120726016379IPiper PA-28-161During landing roll out aircraft struck a deer statement from CFI pilot stated that the aircraft speed was not sufficient enough to go around and too fast to stop.Accident 20120726016359APiper PA-12 · Middle Township, NJThe pilot was finishing the day of banner towing, and was planning to drop the banner, then enter the traffic pattern to return for a landing. After dropping the banner, the pilot started the climb back to traffic pattern altitude. As the aircraft pitched up,…Incident 20120726016339ICessna P210N · Creswell, ORPilot forgot to lower landing gear on approach to landing. Propeller contacted ground and aircraft landed on belly. Pilot exited aircraft. No injuries resulted.Accident 20120726016179ABeech B-60 · Sedona, AZOn July 26th, 2012, at approximately 0830 MST, a 1979 Beechcraft, BE-60, duke crashed off of the end of runway 21 at Sedona regional airport, AZ. The aircraft impacted in a ravine 750 feet southwest of and 300 feet below the airport departure end and caught…Incident 20120726016139IAmerican Champion 8KCAB · Oshkosh, WIWhile performing aerobatic routine during airshow, pilot seat suffered structural failure allowing pilot to pivot backward 55 to 65 degrees. Pilot momentarily lost control of aircraft. Pilot regained control after being able to free himself from the rear…Accident 20120726015889ACessna 172P · Plainville, CTOn the second approach to land on runway 20 at 4B8, the aircraft undershot the runway and impacted downsloping terrain prior to the runway threshold. Eyewitness statements report that the aircraft flew directly into the downsloping terrain prior to the runway…Accident 20120726015399ABayliss Milton A III Xair · Houlton, METhe pilot was conducting a series of takeoffs and landings at the Houlton International Airport, Houlton, ME (hul).the pilot was attempting to land on runway 23, due to a strong cross wind he elelcted to go-around and attempt a landing on runway 19. He…Accident 20120726015289AHughes Helicopters 369E · The Dalles, ORSeveral witness stated the helicopter had just picked up the 3 power lines and started to pull the lines when they heard a loud "pop" and a very noticeable engine spool down. The PIC immediately released the lines and turn the aircraft away from the crew…Accident 20120726015259ABeech F33A · Fairbanks, AKDuring departure engine quit, forcing pilot to crash land the aircraft between runway 20L and 20R at the south end.Accident 20120725021759ANelson Miles SKY Star Kitfox S 5 · Weatherford, TXThe pilot was practicing takeoffs and landings when the accident occurred. During the landing flare, the airplane drifted to the left of the runway centerline. The pilot over corrected to the right before applying full power in an an attempt to go-around. The…Accident 20120725017979AFlight Design Ctls · Conway, AROn July 26, 2012 at 1000 cdst, a Flight design clts, N930SA, registered to sparrow flying club, Conway, AR, was being operated by a club member on a cross country Flight from searcy, AR (ksrc) to Conway, AR (kcws) on a leisure Flight. During the approach to…Incident 20120725017829IEmbraer EMB-145XR · Chicago, ILUnited express flight #5959, Chicago to memphis, was on taxi out and an American plane pulled in front of them. The pilot had to slam on the brakes and the flight attendant fell into the galley counter. The plane returned to the gate and the flight attendant…Accident 20120725016709ACessna 172M · San Juan, PRThe PIC [privacy data omitted], was enroute from (tjab) arecibo airport, to (tjig) Isla Grande Airport when the pilot informed the control tower that he believes that the aileron control cable broke and is having trouble keeping the aircraft in a straight and…Incident 20120725016389ICirrus Design SR20 · Omaha, NEDuring final approach to landing the nose wheel contacted the runway first causing the aircraft to start porpoising. On the third bounce the nose wheel broke off and the propeller contacted the runway. Aircraft came to rest in grass off the side of the runway…Accident 20120725015699ARaytheon B36TC · Sugar Grove, ILN471BB piloted by [privacy data omitted] departed runway 36 at Aurora airport, Sugar Grove, Illinois, when it then impacted the ground in a cornfield north of runway 36. Current ATIS report at the time of the accident was 1352Z 160009KT 9SM SCT250 26/21…Accident 20120725015679ACessna 172N · Ashland, ORStudent pilot was practicing short field landings when she landed hard on the left main gear, struck the tail tie-down, and subsequently had nose gear hit hard, resulting in damage to firewall/nose gear mount. No propeller strike occurred. No injury resulted.Accident 20120725015639ABell 47G-2A · Akeley, MNPilot stated he was making a clean up pass to the north. He crossed some small power lines as he descended and shortly thereafter felt a small vibration in the rudder pedals. The helicopter started to yaw to the right and go nose down. He attempted to push…Accident 20120725015429AFairchild M-62A · Albion, NYThe PIC stated that this was a local flight and he was taking his granddaughter for a flight. The PIC stated that shortly after passing the windsock, he encountered a gust of wind that weather-vaned the airplane into the wind. The PIC stated and pointed to a…Incident 20120725015329ICessna 182 · Chatham, MAOn July 27,2012, [privacy data omitted] conducted her first tandium sky dive with instructor marcus silva at sky dive cape cod in Chatham,MA. Upon landing, [privacy data omitted] may have inadvertinely extended her legs which resulted in her breaking her…Incident 20120725015299ICessna 152 · Hillsboro, ORThis was the first solo and first landing for the student pilot when the incident occurred. He said his traffic pattern was normal with the exception, when he turned ¾ mile final he was at 900 feet MSL instead of a normal 700 feet MSL (500 feet AGL). He said…Accident 20120725015069ABoeing 767-332 · Seattle, WAEnroute from atl-sea, passenger [privacy data omitted] got out of her seat to use the lavatory. Witnesses observed her having difficulty opening the lav door. Her eyes closed and she fell to the ground, first hitting her hip, then hitting her head. It…Incident 20120725014709ICessna P210N · Addison, TXOn 07/25/2012, [privacy data omitted], pilot [privacy data omitted], departed athens TX (F44) enroute to Addison TX (ADS) in hi scessna P210N, registered as N4845W. [privacy data omitted] Landed at ADS without extending the gear, resulting in minor damage to…Incident 20120725014599INorth American SNJ-5 · Oshkosh, WIOn July 25, 2012 at 1345 CST a North American SNJ-5, N3725G, on base to final approach to runway 27 at osh, WI, had a loss of power/engine failure. The aircraft landed in grass, crossing a taxiway and closed runway, coming to rest in the grass adjacent to…Incident 20120725014549IAir Tractor AT-402B · Eureka, ILWhile performing a clean-up pass, the aircraft clipped a wire that was not routed along a road. The wire was running across 2 adjacent fields. The operator was busy watching for drift over a near by home.Accident 20120725013799AMooney M20M · Heber Springs, AROn July 25, 2012, at approximately 1430 CDT, N9145L, a Mooney M20M aircraft, [privacy data omitted] and operated by a private pilot attempted landing at the Heber Springs municipal airport located in Heber Springs, AR. During landing the aircraft bounced…Incident 20120724017069IDiamond Aircraft Ind DA 20-C1 · Cahokia, ILEngine lost power on takeoff. Pilot was able to land straight ahead on remaining runway. Tower notified the school who went out and towed the aircraft to the hanger.Incident 20120724015939IAviat S-2C · Meadow Lake, CO07/24/2012 Colorado springs, CO (kfly), Aviat S-2C, N19FC, ground looped during taxi operations. Substantial damage, no injuries.Incident 20120724015629IGarlick Helicopters OH-58C · Waukon, IAThe airman was conducting aerial application of chemical to a corn field. The airman stated that during his aerial survey of the field prior to the application he had identified the electrical transmission wires he eventually struck. The airman stated he had…Accident 20120724015589AEurocopter Deutschland MBB-BK 117 C-2 · Houston, TXMedical flight (life flight 5) from 70TS to memorial hermann hospital s.e. with stop at 38TE to pick up a nurse. Upon approach to 38TE the pilot and crew heard a thump and felt a shudder in the aircraft. Upon landing the passenger boarded the aircraft and the…Accident 20120724015459ACessna TR182 · Steamboat Sprin, COOn 7/19/2012, approx. 1350 MDT, Cessna TR-182, N73VX, landed at sbs with landing gear retracted. Aircraft sustained substantial damage, 1 POB, no injuries.Accident 20120724015359AMooney M20TN · Hilton Head, SCAfter landing roll out, pilot reports aircraft veered to the left due to crosswind. Aircraft veered off the runway and contacted the runway/taxi sign causing damage to the propeller, left outboard wing, left aft tail fairing and tail cone.Accident 20120724014949AHughes 269C · St. Petersburg, FLOn July 24, 2012 at approximately 1850 EST local time, a Hughes 300C helicopter, N9679F, s/n 310103, [privacy data omitted], crashed while hovering in St. Petersburg, FL. [privacy data omitted] Was the only occupant on board and was not injured. The aircraft…Incident 20120724014639IPiper J3C-65 · Casselberry, FLPilot phone #: [privacy data omitted]boat owner & #: [privacy data omitted]witness in boat: [privacy data omitted]witness on shore: [privacy data omitted]seminole county shefiff's case #: [privacy data omitted]; phone[privacy data omitted]NTSB: corkey…Incident 20120724014569ICubcrafters CC11-160 · Boulder City, NVN164RW, sustained minor damage after making an off field desert landing approximately 5 miles south of kbvu. The PIC stated that after making one low altitude pass over the intended landing area, a normal approach into the wind was made. The conventional gear…Incident 20120723023339ICessna 180K · AKThe airman landed the aircraft on a sandy moraine below a Glacier, and was repositioning the aircraft for take-off. He stopped short of what appeared to be a shallow stream, shut the aircraft down, and got out to check the streams depth. After probing the…