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 20120905023319IPiper PA-18A 150 · Nenana, AKWhile departing a gravel bar airstrip the pilot dragged his landing gear through some brush causing a substantial loss of lift resulting in the aircraft settling into the trees. Pilot stated a slight downdraft kept him from clearing the brush during…Incident 20120905020349IPiper PA-18-150 · Nenana, AKPilot was landing at his off airport hunting strip near Nenana, Alaska when on roll out he started to drift because of the gusty winds and applied brakes too hard causing it to nose over and damage the spinner and propeller. The aircraft just had a new high…Incident 20120905020099IMooney M20E · Erie, COOn 09/05/2012 at approximately 1915 hrs. MDT, N15LG a Mooney model M20E aircraft sustained minor damage while landing at Erie Municipal (keik) airport, CO. The two occupants on board were uninjured. Weather at the time was visual meteorological conditions,…Accident 20120905019769AEllefson Daniel T-BIRD II · Richfield, UTPilot reported that during test flights ,following recent re-assembly of aircraft, the aircraft was having pitch controllability issues. During flight the aircraft pitched up uncontrollably and subsequently crashed. Forward fuselage structure damaged, main…Accident 20120905019609ACostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYAircraft accident after take-off apparently due to excessive cross winds from thunderstorms approaching Addington Field (ekx) from the west. According to ekx a.w.a.s. winds at take-off were sustained 23KTS from 320 degrees with peak winds at 27KTS from 320…Accident 20120905019389ALake John K MA-5 Charger · Eagle Mountain, UTPilot landed on a narrow, dirt, private airstrip at a ranch. On the landing rollout, at approximately 20 mph, the lower wing of the biplane struck some sagebrush on the side of the runway causing the aircraft to flip over. Damage to upper portion of vertical…Incident 20120904029009IBell Helicopter Textron 206L-1 · Harrison, AROn September 4, 2012 the left-hand chin bubble departed the aircraft while in cruise-flight. Subsequent investigation determined that the chin bubble had been installed 6 days earlier and by admission of the mechanic, the installation instructions had not…Accident 20120904021479APiper PA-32-300 · Lancaster, CAOn 09/04/2012, 0848, N308DF, a Piper PA-32-300, during takeoff lost power and landed off the east end of fox field runway, Lancaster, CA. The pilot was the only person onboard at the time of the attempted takeoff. The aircraft sustained substantial damage. No…Incident 20120904021049IPiper PA-28RT-201 · Appleton, WI[privacy data omitted] Private pilot 3452258, was the pilot in command of N2895L when it departed the taxiway and impacted a taxi sign at the intersection of n and N3 taxiways. [privacy data omitted] Was out on a 0.6 hrs instructional flight in the pattern at…Accident 20120904020931ABombardier DHC-8-402 · Seattle, WADuring push back operations N448QX and N413 qx sustained impact damage to to both ac's RH elevators.Accident 20120904020789APiper PA-18-150 · Ekwok, AKOn September 4, 2012 N4127Z crashed into a cliff departing Ekwok. I have sent a letter of investigation and made several attempts to call the individual. I will amend this -23 when I am able to talk to the pilot.10/9/12 amendment, the pilot stated that as he…Accident 20120904020691ABombardier DHC-8-402 · Seattle, WADuring push back operations 448QX and 413QX sustained impact damage to both ac's RH elevator damage.Incident 20120904019589IBeech A36 · Lincoln, NEOn approach into Lincoln municipal airport aircraft experienced a right main landing gear unsafe indication with gear down and locked.Incident 20120904018999IGrob-Werke G 120A · Goodyear, AZOn September 04, 2012, about 1030 mountain standard time, a Grob G-120A, N867AF, sustained minor damaged during a simulated engine failure to the right main gear and flap just after takeoff from the Goodyear airport in Arizona. The aircraft was operated by…Accident 20120904018879APiper PA-22-108 · Lewiston, IDPilot was conducting a cross country plane trip. After two earlier flights in the day the pilot took off and the left main landing gear tire fell off after rotation. He was informed by the local UNICOM person about the tire coming off. Pilot decided to fly to…Incident 20120904018199IPiper PA-34-200T · Big Spring, TXOn landing at Big Spring, TX (bpg) the pilot encountered a hard landing which put excessive stress on the nose gear resulting in the partial collapse of the nose landing gear. Minor damage occurred. The aircraft was being transferred from its previous owner…Incident 20120904017939IPiper PA-28-161 · Tamiami, FLPilot reported a strong vibration from the engine at 500 feet after takeoff. Vibration lasted for about one minute then settled down. Pilot elected to turn around and land. Tower asked if he wanted to declare an emergency and pilot responded yes. Pilot made…Accident 20120904017839ASchneider John W PT-2A · Watkins, COOn sep 4, 2012 @ approx. 0829HRS MDT, N6744J, a pro-tech PT-2A experimental, veered off rwy 17 at ftg, sustaining substantial damage. 1 POB, no injuries.Incident 20120903024419IPiper PA-31-350 · Vineyard Haven, MAPilot and passengers noticed acrid smell in aircraft immediately after climb & level off after departing kack. Pilot stated it smelled of electrical burning and declared an emergency and diverted to kmvy. Upon landing and shutdown the smell ceased. Passengers…Incident 20120903022119IPiper PA-30 · Springfield, MOPIC neglected to extend landing gear prior to landing. Both props struck the runway and the PIC attempted a go-around. However, the acft settled onto the runway and slid off onto the grass. Aircraft damage limited to bent propeller blades and scratches to the…Incident 20120903021769IMooney M20C · Burlington, COOn 9/3/2012, at 1130 MDT, Mooney M-20C, N7133V, landed gear up the the kit carson airport (kitr). No injuries to the one POB. Conditions were VMC at the time.Accident 20120903021459ACessna 172S · Sebring, FL09/03/2012: 09:00LT student pilot departed lakeland airport to conduct a solo cross-country flight as part of his flight training program. The pilot experienced no mechanical problems during the flight in VFR conditions. The pilot navigated by means of…Incident 20120903020529IHelio H-295 · San Diego, CAPilot doing touch and go landings at myf. Myf ATCT cleared aircraft for short approach, pilot failed to do a gump check and landed on floats with gear in up position.Incident 20120903019899IPiper PA-28-161 · Miami, FLThe flight originated at kfxe to kcoi then to ktmb. The aircraft landed at ktmb for a 40 minute crew rest, after the rest the pilot attempted to start the aircraft and continue with his flight to kfxe. When he initiated the start sequence he noticed smoke…Accident 20120903019139ACessna 150M · Toledo, ORAircraft left runway 31 to the right at the first taxiway exiting the runway after landing, traveled approximately 600 feet across turf, impacted hangar door with right wing and hangar door support with left wing. Airplane then traveled approximately 60 feet…Accident 20120903018329ABeech 95-55 · Spanaway, WAUpon arriving at S44 following a pleasure flight, the PIC decided to go around. The pilot retracted the landing dear during the go-around. The aircraft remained in the pattern. During the second attempt the aircraft landed with the gear retracted. The PIC…Accident 20120903017909AChampion 7GC · Spanish Fork, UTThe pilot had not flown conventional gear for an extended period of time. The pilot became current and then gave the aircraft owner and then his son a ride. Upon landing with the son, the pilot mismanaged the controls resulting in a ground-loop. The aircraft…Accident 20120903017859ASkykits USA Savannah ADV · Murtaugh, IDPilot lost control of aircraft entering a stall-spin while manuevering searching for livestock.Incident 20120902028889ICirrus Design SR20 · White Plains, NYDuring solo, student pilot [privacy data omitted] on landing runway 11 hpn, struck propeller, inspected aircraft and records at hpn precision flight. Aircraft had damage to prop, engine , nose landing gear, and NLG strut.Incident 20120902028541IPiper PA-28-161 · Groton, CTPilot was manuvering the aircraft in a non-movement area to a tie-down position when the right wing leading edge and tip contacted a parked aircraft on the left side at the engine nacelle skin.Incident 20120902023609ICessna 172N · Broomfield, COOn 9/2/2012, at 1636 MDT, Cessna 172, N5247D, sustained minor damage when it impacted the ground and flipped over while attempting to land at rocky mountain metro airport (kbjc). No injuries to two POB. Conditions were VMC with gusty winds at the time.Incident 20120902023429ICessna U206F · Buckland, AKHard landing resulted in nose gear landing and propeller strike. On final approach, the pilot in command encountered a down draft which caused the aircraft to suddenly lose altitude. Subsequently the nose tire touched down first causing the propeller strike…Accident 20120902021389APiggott John H Bearhawk · Sequim, WAPilot stated he had departed Sequim Valley Airport was practicing areil work and had performed several take-off and landings at the port angeles and jefferson county airports. He then returned to the Sequim Valley Airport and was making a normal approach. The…Accident 20120902021369AMaule MXT-7-180A · Manzanita, ORWhile landing rwy 33 which is hard surfaced, 50 feet wide and 2350 feet in length. The airplane drifted to the right and touched down with right main wheel off the runway. The airplane bounced once and continued to the right before touching down a second…Accident 20120902020469ATaylorcraft F21 · Willow, AKPilot/owner was enroute to anchorage from schlotna lake and diverted to Willow Lake because of wind and weather. After a 15 minute wait, he decided to take-off for seymor lake (east). On take off, aircraft had difficulty gaining altitude, pilot made a steep…Incident 20120902019949IDiamond Aircraft Ind DA 42 · Naples, FLOn 9-2-2012 pilot took off from Naples airport, Florida (apf) runway 5 in Diamond da 42 N160TS. No weather conditions. After take off nose door popped open. Can of deicing fluid flew out and hit right propeller causing damage to prop. Aircraft circled back…Accident 20120902019829APiper PA-18-150 · Deadhorse, AKAccident occured 1234 LCL time. Wx at scc @1153LCL was pasc 021953Z 06016KTS10SM OVC023 06/03 A2978 rmk A02 SLP085 T00560028NOTE: accident occured about 100 sm south of scc in atigun pass. Telecon with pilot stated he followed road thru atigun pass due to low…Accident 20120902019579ACessna 182P · Newberry, MIOn September 2, 2012 at 1416 eastern daylight time, a Cessna 182 single engine aircraft, N5981J, registered to the Michigan department of natural resources (dnr) and operated by an airline transport pilot, was destroyed when it impacted the threshold…Incident 20120902018439IDouglas AD-4N(A) · Everett, WAOn 9/2/2012, AD-4N aircraft, N965AD, struck a taxiway sign sustaining minor damage to the propeller.N965AD was cleared by pae ATCT for take-off on runway 34L at taxiway K-6. After completing an engine run-up on the taxiway, the pilot taxiied forward to enter…Accident 20120902018429ACessna 182L · Sullivan Lake, WAPilot was landing at the Sullivan Lake airport. A witness reported that his approach was higher and longer than normal. He touched down long and, according to the pilot, encountered a wind shear that caused him to run off the north end of the runway across a…Accident 20120901028879ACessna 172S · Farmingdale, NYPilot statement: I had a solo cross country flight: Farmingdale / groton / bridgeport / Farmingdale. The accident happened during final landing at Farmingdale around 11.30 am. I was landing on runway 32, with wind of 10 KTS from 350 ( 5 KTS crosswind ).…Accident 20120901028129ACessna L-19E · Lancaster, TXOn September 1, 2012 the pilot departed fredericksburg, TX at 0735L with flight plans to Lancaster Regional (lnc), TX. The flight time enroute to lnc was uneventful. Weather contiditon was not a factor. He touched down at lnc at approximately 0905L, upon…Accident 20120901027659AAeronca 7AC · Brighton, MIWitnesses near the north end of the airport stated that the engine run-up and take-off on runway 22 sounded and appeared normal. Witnesses at the south end of the airport (departure end or runway 22)stated that the engine sounded like it was not producing…Incident 20120901023539IBeech 95-B55 (T42A) · Columbus, TXThe pilot and one passenger were on a sight seeing flight in the vicinity of the Columbus airport. While he was at 2000' AGL and three miles from the airport, both engines quit running. The pilot stated he had both engines feeding from the RH main tank and…Accident 20120901021939ACessna 172E · East Bend, NCAircraft departed grass strip and during climb making a left turn, the engine lost power. Pilot landed aircraft in a corn field.Incident 20120901021719ITL Ultralight Sro Stingsport · Erie, COOn 9-1-2012, aircraft N898N, a light sport aircraft, experienced major damage when one propeller blade separated from the hub during cruise flight. Flight conditions were VMC. No injuries to 2 POB.Accident 20120901021679ACessna 180 · Kenai, AK09/02/2012THE pilot of a Cessna 180 was on a pleasure flight from merrill field to the kustatan river, with his son to do some fishing. The pilot landed on a small sand landing strip along the river. Upon roll out the main gear hit a stump that had worked its…Accident 20120901021209AAero Vodochody L39C · Davenport, IAThis accident occurred during an airshow at the Davenport, Iowa airport (dvn). The incident occurred during a crossover maneuver where the accident aircraft went from the left rear side of a triangle formation to the right side. There was no collision between…Incident 20120901020839ICroman SH-3H · Covelo, CAAircraft was contracted for public use on a fire contract for the department of forestry when the incident happened. Aircraft was sent to hotshot area division v to drop water on the fire per helicopter control (U.S. Department of forestry).the aircraft…Accident 20120901020049ABurkhart Grob G 103 Twin II · El Paso, TXOn September 1, 2012, at 1100 mt, a grob 103, N5489X registered to El Paso soaring society, was substantially damaged during a winch launch at horizon airport El Paso, TX. Visual meteorological conditions prevailed at the time and no flight plan was filed.…