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 20120817020199IBoeing 767-332 · Los Angeles, CA#2 Engine struck by loading crew damaging eng cowl. Passengers had started the boarding process when the acft was damaged. Passengers deplaned and acft unloaded. Acft taken to hangar awaitng parts to repair from atl 18AUG. Flight canceled and will ferry as an…Accident 20120817019239ACessna 152 · Rockford, ILN152BA departed poplar grove airport (C77) for Rockford airport (rfd)for air traffic control instruction with a CFI and student pilot on board. On approach to runway 25 approximately one and one-half miles from touchdown, the CFI reported to Rockford tower a…Accident 20120817019089AAir Tractor AT-502B · Bogata, TXOn 08/20/2012 this office was informed that N6047G was involved in an accident on 08/17/2012. N6047G was operating out of a grass strip near Bogata Texas. The aircraft was loaded with 450 gallons of a round up / water mix in the hopper. The aircraft attempted…Incident 20120817018799IPiper J3C-65 · West Milford, NJDuring after landing taxi, pilot was power taxing with tail up, nose level and prop struck the runway light.Accident 20120817018109AFantasy Air Sro Allegro 2000 · Bear Creek, WIOn August 17, 2012, at 15:45 cdst, the pilot of a Fantasy air, allegro 2000, N5064E, lost lateral control of the aircraft on roll out as he applied braking action. The aircraft received substantial damage. The pilot reported no injuries. The aircraft was…Accident 20120817018099APiper PA-18A 150 · Talkeetna, AKPIC was conducting off-airport landings and stated that initial part of the landing surface was dry and braking action was good, but towards the end it was slippery. Surface was moss, and weather included rain at the time of the accident. According to the…Accident 20120817018069ACessna 170B · Fairbanks, AKPilot landed on fai ski strip 20. Pilot stated he landed on the right side of the runway and the right tire got caught in soft terrain and pulled rest of aircraft off runwayAccident 20120817018049AMooney M20E · Gresham, WIOn August 16, 2012, at 12:30 cdst the pilot of a Mooney M20E, N5642Q, lost laterial control of aircraft during a takeoff from his private stripe near Gresham WI. The aircraft drifted to the right and contacted the corn planted next to the runway. This was a…Accident 20120817017769ARobinson Helicopter R22 Beta · Spanish Fork, UTSubstantial damage was sustained after a hard landing during an instructional flight. The flight instructor and student pilot were practicing autorotations. They were practicing multiple straight-in autorotations and then initiated one from a 180-degree turn.…Incident 20120817017649IEmbraer EMB-120 · Cedar City, UTAircraft made a left turn approximately at 80 knots on take-off roll. Flight crew responded by inputting full right rudder and positioning power levers in reverse. Tire markings on runway start at 1000 feet and exit the runway at 1800 feet at approximately a…Incident 20120817017559ICirrus Design SR20 · North Myrtle Be, SCOn August 17, 2012, at 1213 pm, N855CD, a Cirrus sr 20 operating part 91 VFR, landed on runway 23 at Myrtle beach, SC, at the grand strand (cre) airport. The aircraft landed and began to porpoise as it slowed to exit the runway causing a propeller strike to…Incident 20120817017099IBombardier CL-600-2B19 · Omaha, NEOn approach into Omaha aircraft experienced a landing gear disagree indication (eicas). Followed by a hydraulic #3 low pressure caution with indication showing 5% fluid level with zero pressure. Manual gear extension procedures followed.Accident 20120816024529APiper PA-24-260 · Holton, KSAircraft N8546P was enroute to phillip billiard municipal airport from mitchell south dakota flying VFR. At 2148 local time contacted Kansas city center and advised them the prop was running wild. The controller advised them of the nearest airport. The pilot…Incident 20120816020389IPiper PA-24-260 · El Cajon, CADuring flight operations, N99FB, electrical landing gear extension failed. Pilot manualy extended gear, with green light safe indication. During landing roll-out all three gear collasped. Investigation on going. Inspection revealed electric gear motor wire…Incident 20120816018059IArgos Marine Sportsman GS-2 · Tracy Arm, AKDuring a water landing, an experimental amphibious airplane experience a float rigging failure causing the aircraft to list to the right after water landing. Minor damage to the float rigging (and wire pulls) occurred; no structural damage to the aircraft. No…Accident 20120816017519AMD Helicopters 369E · Columbus, OHAt approximately 1:50AM, after a pre-flight inspection of the aircraft and a check of the weather, the aircraft departed the Columbus police heliport, located at 2130 w. broad st, COLUMBUS43223. Pilot maintained a southeastern departure, ultimately turning to…Accident 20120816017279AMeyers OTW-160 · Whorton, MDInstructor was teaching landings, after touch down the right shock strut tube broke. This caused the right gear to collapse. The right wing tip struck the ground and the airplane nosed over. The aircraft came to a stop in an almost vertical position. There…Accident 20120815029159ABrown Mitch Challenger II · Fisk, MOPilot stated he was flying low level across a field when he struck power lines and crashed. Aircraft received substantial damage. Pilot received minor injuries.Accident 20120815023039ABeech A36TC · Clifton Park, NYOn 15 August 2012 at approximately 0723 EST N678DR, BE-36- A36TC departed alb IFR to pbg. Immediately after departure the pilot advised alb approach that he lost his engine. Approach asked the pilot if he would like to return to alb and he said he would land…Incident 20120815020589ICessna 560XL · Des Moines, IAAccording to the pilots,the following occurred. The aircraft departed fcn at 0815 on 08/15/2012.the intended destination was arlington,TX.prior to departing fcn,the aircraft waited for a thunderstorm to pass and sat in the rain for approximately 45 minutes to…Accident 20120815019999ASchweizer G-164B · Kaplan, LAAircraft was maneuvering to make it's final pass on an agricultural field when the landing gear struck the top utility wire approximately 100 ft AGL and impacted the ground then flipped in a field near ward road and wildflower road.Accident 20120815018299APiper PA-18-150 · Farewell, AKDeparted healy 12:10 8/15/2012 direct to confluence of ripsnorter and tonzona river arriving at 14:00. Hunter notified out of food needed pick up . Left rear quartering tail wind at landing site. Pilot stated that his landing was fine but as he was taxiing a…Accident 20120815017079APiper PA-24-260 · Coolin, IDPilot unfamiliar with airport. Airport has turf runway leading uphill from north to south. Pilot landed aircraft past runway halfway point, too fast, and overshot the end of the runway. Aircraft came to rest in barrow pit on north side of east/west road on…Incident 20120815016519IPiper PA-38-112 · Mason City, IADuring cruise flight from boone, IA to rochester, MN the engine suddenly dropped 400 to 500 RPM. Pilot notified minneapolis ARTCC and attempted to divert to Mason City, IA. Engine speed continued to deteriorate and an emergency landing was excecuted on to a…Incident 20120814027079IPiper PA-34-200 · Lancaster, TXVideo surveillance for Lancaster airport showed aircraft traveling approximately 1004 ft iver a tune if about 4.5 seconds. Aircraft was calculated to be traveling 132 knot just prior to ground impact with the flaps up. POH recommended speed for landing of…Incident 20120814020039IGrumman American Avn. AA-5A · Houston, TXStudent pilot on training flight approached for short field landing. According to pilot aircraft bounced and then began to porpoise. Student realizing he was in a porpoise situation added power to correct the situation. There was plenty of runway left for…Incident 20120814019889ICessna 501 · Tamiami, FLOn August 14, 2012, aircraft N347MH a Cessna 501, serial number 501-0155 was on descent into ktmb when the left engine digital display unit failed emitting minor electrical smoke into the cockpit. The crew notified ATC and continued to ktmb and landed without…Accident 20120814019469ABell 47G-2 · Flandreau, SDOn August 14th, 2012 at 08:34 am CDT (local time) a bht 47G-2 helicopter was involved in an accident/engine power loss while in cruise @ 500FT AGL, during a pleasure flight. VMC conditions prevailed and no VFR flight plan was filed. The aircraft was…Incident 20120814018229IPiper PA-31-350 · Minot, NDDuring a part 91 operation during a flight from williston ND to grand forks ND, the pilot noticed the oil temperature "going into the red" and a significant drop in manifold pressure on the right engine. The pilot shut down the engine and diverted to Minot ND…Accident 20120814017619AFechtner Joseph M KR-2 · Tehachapi, CAAircraft crashed less than 1/2 mile from approach end of rwy 29-ktsp, during turn to final. Accident site located in open field.Accident 20120814017499ARockwell International S-2R · Royal City, WAOn takeoff, aircraft lost power. Pilot was able to sustain it enough to attempt a landing on the highway. He was unable to land straight and when the aircraft touched down it went off the south side of the highway. Aircraft came to an abrubt stop. After the…Accident 20120814016989ACessna 180J · Wausau, WIPilot did not correctly respond to windshift during flare; pilot did not recognize aircraft was drifting right; pilot attempted correction, aircraft left wing lifted and aircraft began turning left (upwind) until it left runway and ground looped, tipping…Accident 20120814016979AAir Tractor AT-502 · Hanley Falls, MNPilot was making his 3rd pass on the field, but the first pass going north to south along powerlines. Pilot was lining up to make his pass when he spotted a guy-wire and attempted to pull up. The left wing impacted the guy-wire and severed both the wing and…Accident 20120814016439ACessna 172R · Everett, WAOn August 14, 2012, at 10:25 local PST, N863CP, a Cessna CE-172 was being operated as a 14 CFR part 91 solo flight by a student pilot at the Snohomish County, Paine Field Airport, Everett, WA. Directional control was not maintained during a touch and go…Incident 20120813019779ICessna 402C · St. Louis, MOCaptain ordered evacuation of aircraft due to smoke produced from malfunctioning RH alternator. Maintenance found RH alternator and voltage regulator needed replacement. Evacuation was precautionary only. FAA did not visit scene as aircraft was already…Incident 20120813018909IBell 206L-3 · Burnett, TXWhile making a landing on hwy 29 @ n. rhomberg rd. in Burnett, Texas to pick up a patient, helicopter struck a temporary banner wire installed across hwy 29 at the landing zone. Tail rotor blades made contact with wire severing the wire and causing damage to…Incident 20120813017779IHaeussler Ray Sonex · Waterford, CTDuring a VFR flight from akron, n.y. (9G3) to groton, CT (kgon) the pilot stated his engine stopped suddenly resulting in a forced landing on a tidal marsh at Waterford beach park, about three miles west of groton. The pilot wasn't injured and the aircraft…Incident 20120813016459IStarkel G/Newton W Vans Acft RV-8 · Nebraska City, NEOn August 13, 2012, at 10:45 CDT, an experimental RV-8, N762DF, was flying formation with N6315T on a VFR flight from st. joseph, Missouri, to columbus, Nebraska. The flight of two adjusted their track to the southwest to avoid a presidential TFR that was in…Incident 20120813016449ICessna A185F · Port Angeles, WAOn August 13, 2012 at approx. 1440,the owner and operator of N5403E, a amphibious Cessna 185F with one passenger on board had departed from lake sutherland, Washington, on a scenic flight. Shortly after takeoff the pilot experienced a powerloss and performed…Accident 20120812020739APiper PA-22 · Napa, CAOn August 12, 2012 at approximately 15:08 PDT, aircraft N3580A, a Piper PA-22, serial number 22-1855, was performing touch and go's on runway 18R at the Napa county airport (apc) in Napa, CA. The pilot lost control of the aircraft and it crashed to the right…Accident 20120812020579ACessna 180K · Upland, CAPilot lost conrol of the aircraft while landing. Pilot stated the aircraft began to track to the right and then a wind gust lifted the right wing and the aircraft departed the runway to the left. Pilot then initiated a go around and partially retracted flaps.…Accident 20120812019639AIson Eros · Schoolcraft, MIPilot taking off and aircraft made a left turn. Pilot recovered and leveled out about 25' above ground. Pilot landed in neighbor property running into corn field.Accident 20120812019519ADykas Frank J Kitfox Series 7 · Monroe, MIPilot was low on approach to a private grass strip. The main wheel struck power lines that are 27' high and 360' from the end of the runway. The aircraft crashed in a corn field that is between the wires and the grass strip coming to rest about 75' short of…Accident 20120812018039APiper PA-18 · Anchorage, AKThe pilot was landing at 6 mile airstrip, upon landing the aircraft bounce slightly. The tail wheel aircraft was sliding to one side of the runway and controls to correct the problem were applied. The pilot applied brakes to get the aircraft back to…Incident 20120812017929IRaytheon 400A · Miami, FLOn August 14, 2012, incident number ISO192012060 was given to flight standards district office 19 (FSDO 19) to investigate. The incident report read; fort lauderdale, FL (fll): N258TX, be 400, diverted from arturo michelena international airport, venezuela…Accident 20120812017699AEvektor-Aerotechnik Sportstar · Lebanon, PAThe pilot failed to lock the airplane canopy before takeoff. On takeoff roll he realized this, attempted to lock it, and lost control of the airplane. It departed the runway to the left and struck a propane tank.Accident 20120812017689ADestiny XLT 2000 · Grayson, GAPilot took off from school parking lot. Upon descent back to land, pilot flew into powerlines, lost control and crashed.Accident 20120812016999APiper PA-22-160 · Bay Minette, ALDuring the landing sequence the aircraft began to drift left. Maximum right rudder and full braking was applied. Aircraft entered a left ground loop departing the left side of the runway and came to a stop with right side of empennage striking the PAPI light.…Incident 20120811022629IBell 407 · Jenkins, KYTail rotor was found damaged during a preflight on 08/11/2012. The louisville flight standards district office was notified by the operator. Inspectors from the FSDO went to the Jenkins, KY heliport to investigate and found that aparently something struck the…Accident 20120811021139ASackman Randal D Sackman Special · Ste Genevieve, MOPilot reported that he had departed Ste Genevieve MO airport grass runway to the north. He turned to the north east and climbed to approximately 2000 feet MSL and performed 3-4 wingover then descended back to the airport and performed a low pass in front of…