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 20110626011399IGoodsell Vern XP-TALON · Prineville, ORDuring landing at Prineville, OR (S39) airport, xp talon, N420XP, s/n: AA-001, piloted by [privacy data omitted], the aircraft made a gear up landing, exited the runway and came to rest off the side of the runway. There were no injuries, no fire, and no…Accident 20110625013969AHelio H-295 · Brasstown, NCAircraft departed (1A5) macon county, NC airport enroute to Payne Airstrip, Brasstown, NC.at 6500 ft the engine begin to loose power and quit. Pilot was able to restart but only for a short period of time. Aircraft had descended to 1000 ft. pilot attempted to…Accident 20110625013849APiper PA-32-300 · Bridgeport, CTOn 6/25/11 at 2145 EDT N600DK a PA32-300 piloted by [privacy data omitted] a private pilot holding certificate number [privacy data omitted] struck the blast fence at bdr while landing on runway 24.the left wing of the aircraft became lodged in the blast…Accident 20110625013439ASchweizer G-164B · Cash, AROn June 25, 2011, at 1545 CDT a loaded Schweizer G-164B turbine powered ag-cat, N3629C, aircraft registry indicating sale reported, departed a remote operating location near Cash Arkansas. Shortly after takeoff the engine lost power. During the landing…Accident 20110625013369AAviat A-1B · Livermore, CAPIC of a husky aircraft loses control during the landing phase for runway 25L. PIC ground loops the aircraft while attempting to go-around. Damage to aircraft considered substantial - by NTSB.Accident 20110625013009APiper PA-28R-201 · Rantoul, ILOn 06/25/2011 at the Rantoul, IL airport (tip) a Piper PA-28R-201 landed gear up. The pilot[privacy data omitted] holder of a private pilot certificate # [privacy data omitted] was at the controls with one passenger on board. After take off the pilot selected…Incident 20110625012999ICessna T210L · Great Falls, MTOn June 25, 2011, an aircraft registered to [privacy data omitted] with a registration number N1657X Cessna T210L, s/n 21060692 landed gear up on it's belly on the Great Falls International Airport (gtf) on runway 21. There were no injuries and the aircraft…Incident 20110625012419IBellanca 7KCAB · Santa Ana, CAPilot stated he was asked by sna ATC to expedite into the midfield runup area while vacating rwy 19L. In the process of doing so the pilot focused on manuevering so as to avoid another aircraft parked at the entrance of the runup area. In doing so he failed…Accident 20110625011919AVandenburg David R Pietenpol AIR Cmpr · Marquette, MIOn June 25, 2011 at 2:54PM EDT an experimental owner/amateur built pietenpol air camper aircraft, registration N16DV, sustained substantial damage during a crosswind landing rollout on runway 1 at Sawyer International Airport (saw)in gwinn, Michigan. During…Accident 20110625011431ACessna 177RG · Olympia, WAAircraft was peroforming a maintenance run infront of its hanger, had no intension for flightAccident 20110625011402ACessna 172N · Olympia, WAAircraft was taxing from parking to ramp area when the left wing tip, struck the turning propeller of N300ZX. Pilot didnot move to the right to avoid contact with propellerAccident 20110624018529ACessna A188B · Castroville, TXThe agricultural pilot was making his first pass of the day when the airplane struck a center pivot irrigation system. The impact damaged the irrigation system, and the right landing gear and tail wheel separated from the airplane. The airplane then…Incident 20110624015419IPiper PA-28RT-201T · Martinsburg, WVThe pilot stated that he experienced some form of a prop governor failure. He moved the prop and throttle controls and could not effect any change as FAR as thrust from the engine. He was unable to maintain altitude and landed in a field short of…Incident 20110624015239IMooney M20F · Topeka, KSAfter take off, the gear did not fully retract when commanded. (Gear up light did not come on.) Pilot found and reset popped circuit breaker, operated gear control several times, but could not verify gear movement or position. The pilot returned to the…Accident 20110624013979ABeech C23 · Pompano Beach, FLUpon touchdown on runway airman states that when nose wheel came down he heard a snap and the nose gear collapsed and the prop and nose hit the ground.Incident 20110624013789ICessna 152 · New Century, KSStudent released by CFI for 1st solo in traffic pattern (rwy 18). He stated that his 1st solo touch-and-go landing was "bumpy." During his 2nd approach to landing, he flared too high & noticed a low IAS. He attempted a go-around; however, after applying…Incident 20110624013359ICessna 414 · Bay City, TXThe airplane was just out of annual. The pilot was going for local currency flight and after takeoff the pilot smelled smoke and felt yaw to the right. Pilot asked passenger to look at right engine. Passenger saw fire and smoke. Pilot shut engine down and…Incident 20110624013319IBeech A36 · Olathe, KSPilot executed takeoff from runway 18 at kojc. At approximately 500 ft AGL, the engine lost all power and the prop started windmilling. Pilot executed a forced landing in a grass field about 2.5 miles southeast of kojc.Accident 20110624012019ABeech A36 · Charleviox, MIOn June 24, 2011, approximately 1935 EDT, a Beech A36 single-engine airplane, N88MN sustained substantial damage when it impacted terrain and a residential garage while maneuvering near charlevoix, Michigan. The private pilot and one passenger sustained fatal…Accident 20110624011779AAir Tractor AT-502 · Lewistown, MTOn June 24, 2011, at 2016 MDT, an AT-502, N1022N, registered to srb aerial applicators, LLC, suffered an engine failure and crash landed in a wheat field 18 miles northwest of Lewistown, Montana off state highway 426 after dropping a load of chemical. Visual…Accident 20110624011459AAir Tractor AT-301 · Circle, MTAircraft took off from Circle mt airport and made a right turn on a 285 heading. The aircraft was approximately 1 mile from airport when the pilot tried to gain altitude. The aircraft would not respond and the pilot saw some bluffs ahead of him and he decided…Accident 20110624011419AHendricks George David JR RV8 · Angel Fire, NMOn June 24, 2011 at 1102 MDT, N678VR, an RV-8 amateur built aircraft, departed the right side of runway 17 at the Angel Fire, NM airport while landing in a crosswind reported as 260 degrees at 16 knots gusting to 24 knots. As the pilot was trying to stop the…Incident 20110623018189IDenson Roy M WAG-A-BOND · Grosse Ile, MIPilot was conducting touch and goes at konz airport, and stated that on his 3rd landing he encountered a gust of wind that caused the aircraft to be blown towards the edge of the runway. The pilot could not react quick enough to correct the direction of…Accident 20110623015449ANavion Navion B · Red Oak, NCThe aircraft took off from the private grass strip (19NC) headed south when the engine quit, the aircraft banked out to the southeast in an apparent attempt to return to the strip or land in a tobacco field adjacent to the strip. Due to the lack of altitude…Accident 20110623015229ACessna 182F · Warrenton, VAPilot was taxiing to runway 22 at Warrenton Air Park when the left main gear broke off of the arcraft. Airplane came to rest on its belly. Major damage done to left horizontal stabilizer and left elevator. This is a skydiving operation. No one was injuried.Accident 20110623014229ACessna 172S · Palo Alto, CAThe aircraft was entering the traffic pattern at Palo Alto Airport, Palo Alto, CA. The pilot attempted to add power but the engine was not responding, he continued to add power when he realized the engine had failed. The aircraft landed in a field.Accident 20110623013059ABeech B36TC · Akron, COOn 6/23/2011 at 09:30 MDT, N93PP, a Beech bonanza airplane experienced engine problems while on approach to the Colorado plains airport (ako) and landed approximately 300 feet short of the intended runway. There were two soles. No injuries were reported. The…Accident 20110623012969AHawker/Beech A-36 · El Monte, CAA-36 was VFR and enroute from chino, CA to camarillo, CA when pilot reported loss of engine power and diverted to El Monte, CA airport (EMT). Aircraft made a hard landing resulting in gear collapse in safety area between runway 01 and taxiway alpha, south of…Accident 20110623012719AHiller UH-12E · Hanford, CAAt 0430 the aircraft was being service and refueling when the pilot noticed excess play and oil leaking from the tail rotor drive coupling while the aircraft was at idle. As the pilot moved the aicraft from the service truck to the ground for further…Accident 20110623012599ARockwell International S-2R · Brawley, CAN8520V an S2R during the repositioning for part 137 aerial application operation attempted an emergency landing due to engine issues, during the emergency landing the aircraft struck railroad tracks and caught fire destroying the aircraft. The pilot suffered…Accident 20110623012379APiper PA-18-150 · Tyonek, AKWhile landing on mcarthur river sandbank, pilot touched down and applied the brakes over aggressively. Aircraft rotated forward contacting the propeller and flipped upside down. Pilot sustained minor injuries to the top of his head. Aircraft propeller, right…Accident 20110623011819ABeech C24R · Valparaiso, FLOn June 23, 2011, at 0444 central daylight time, a Beech C24R, N38029, registered to and operated by Eglin air force base (a.f. b.) aero club as a 14 code of federal regulations part 141 instructional flight collided with the ramp after requesting a…Accident 20110623011789AEnstrom F-28C · Blair, NEPilot and observer were conducting powerline patrol at 150 foot AGL. The pilot heard and felt a loud bang, followed by high vibrations and total loss of tail rotor control. During the emergency landing, the left skid hit the ground first, causing the…Accident 20110623010969APiper PA-36-285 · Havre, MTAircraft was departing a gravel road behind another aircraft of the same make and model. Pilot states he had made 5 previous takeoffs that day from the road. The pilot states he lifted off at 70 mph with 15 degrees of flaps. Pilot states the aircraft started…Accident 20110622013329AUltralight America Spitfire II Modelctv · Ranger, TX[privacy data omitted]Pilot was in the process of demonstrating the aircraft to a potential buyer. On departure and climb-out, the aircraft experienced a departure stall with subsequent crash and post crash fire. Two souls were on board with two fatalities.Incident 20110622011839ICessna 210B · Omaha, NEThe aircraft was landing on runway 32 at Omaha eppley airfield. A gust of wind pushed the aircraft into the runway light, knocking it over. The reported wind was 300 heading at 15 knots gusts to 28 knots.Incident 20110622011829IColumbia Aircraft Mfg 400 · Alexander City, ALOn June 22, 2011, at 1649 CST, a Columbia, N401ST, registered to rep surgery and consulting inc, suffered minor damage on landing at kalx, Alexander City airport, while on a CFR part 91 personal flight. An IFR flight plan was filed. The aircraft nose wheel…Accident 20110622011699AInhofe James M / Davis Jim Vans RV-8 · Sheridan, WYOn June 22, 2011 at approximately 1730 LCL N4546Y, a vans RV-8, sustained substantial damage upon landing at Sheridan, WY. The pilot and one (1) passenger received no injuries. Visual meteorological conditions prevailed at the time. The flight was being…Incident 20110622011469ICessna 172S · Naples, FLStudent pilot on landing with minimum crosswind ran off side of runway after touchdown . No damage to aircraft.Incident 20110622011389ICessna 172RG · Osage Beach, MOThe airman stated that he encountered a minus 15-knot windshear while landing, causing the aircraft to descend rapidly. Hearing the stall warning, he added power and lowered the nose. He said the aircraft continued to descend so he lowered the nose more and…Incident 20110621024509IBoeing 757-232 · Atlanta, GAAfter takeoff in climb, the left engine caught on fire and continued to burn even after both fire bottles were discharged into the engine. The fire was extinguished by emergency response fire trucks after landing. This was an overweight landing with an…Incident 20110621024319IBeech 35-A33 · Greenville, TXOn June 21 2011, about 1020 central daylight time, a Beech 35-A33, N738Q, s/n CD-291 landed without the landing gear extended at majors field airport (gvt), Greenville, Texas. The two occupants; the commercial rated pilot and passenger were not injured. The…Incident 20110621023739IPiper PA-28R-180 · Hudson, NYThe albany FSDO investigated a reported gear up landing of a PA-28R-180, registration number N3946T, at the Columbia County Airport (1B1) on 06/21/2011. The incident was reported by the [privacy data omitted] and pilot of the aircraft [privacy data omitted],…Incident 20110621020709IBombardier CL-600-2B19 · Chattanooga, TN1. Thunderstorms were approaching the field from the west as asq 5241 conducted a visual approach to runway 20.2. Several windshear advisories were issued by the ATCT while asq 5241 was in the approach pattern.3. At 200' AGL, indicated airspeed increased 20…Incident 20110621013729IPiper PA-44-180 · Tooele, UTThe damage to the aircraft was limited to the propellers on both engines and limited damage to the flaps and step up to the wing of the aircraft. The pilot forgot to put the gear down. While in the flare the pilot realized the mistake and conducted a…Accident 20110621013559AAir Tractor AT-301 · Hogeland, MTNote: times, headings, and altitudes are approximate. Aircraft took off from harlem, MT airport at 0500 mountain standard time (MDT). The aircraft was [privacy data omitted] piloted by [privacy data omitted], a commercial pilot with single and multiengine…Accident 20110621013539ABell 212 · Mesa, AZOn June 21, 2011 a Bell 212 helicopter (N49678) operated by "the Boeing company" was conducting a pilot currency flight when the aircraft struck the ground, rolled over, and burned. The crash site is located approximately 4.5 miles north of falcon field…Accident 20110621012939ASchweizer G-164B · Marysville, CADuring takeoff just prior to liftoff from an ag dirt-strip the right main tire wheel and gear assembly broke off and bounced up and struck right aileron. The pilot flew the aircraft to the near by airport and declared an emergency. The aircraft executed an…Incident 20110621012459IBeech 99AWhile in cruise, 20 miles north of the gorman VORTAC, the pilot of N1927T noticed sparks coming from the exhaust on the right engine. Soon after that, he saw engine gauges starting to show that the performance was deteriorating on that engine. He elected to…Accident 20110621012349ACessna 320F · Phoenix, AZOn June 21, 2010 Cessna aircraft N6160Q departed Deer Valley Airport (dvt) at approximately 0924 mountain standard time; 1624Z was substantially damaged when the pilot encountered a main landing gear malfunction after departure and returned to the (dvt)…