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 20170822011909IBeech 35-33 · Wheatland, WYAircraft landed with gear retracted.Accident 20170822011669ARockwell International S-2R · Calipatria, CAOn August 22, 2017, about 1100 pacific daylight time, a Rockwell S-2R, N5022X, impacted terrain about 9 miles east of Calipatria, California. The crash was witnessed by an individual who was working in the area at the time. He observed the accident airplane…Accident 20170822011249ABombardier CL-600-2C10 · Dyersburg, TNThe crew was issued a heading for traffic. On that heading, the aircraft flew into weather and encountered severe turbulence. The aircraft diverted due to passenger and crew injuries. One passenger was in the hospital exceeding 48 hours.Incident 20170821021239IBrown John S6S · Jackson, MIOn August 12, 2017, about 1604 local, N964SS, a S6S Brown John, experimental float plane, with one pilot and no passengers departed Jackson county airport (kjxn) and returned to kjxn. At kjxn upon landing the right main gear collapsed. Pilot continued to…Accident 20170821019149ACessna 177RG · Byron, CAA Cessna cardinal CE-177-RG N8053G took off from burns municipal airport in Oregon and landed gear up a mile or so short of Byron Airport, CA. Aircraft ran out of fuel. Landing gear left retracted and landed in a cattle fields dried up pond bed. Aircraft had…Incident 20170821017269IHughes Helicopters 369E · Dalton, PAThe pilot was conducting work along power lines when the main rotor struck a ground wire. He was able to safely land the aircraft.Incident 20170821017249IVans RV-12 · Shreveport, LAAircraft shuddered @ 200 feet AGL and engine RPM dropped off to 4300. Pilot declared an emergency due to loss of power. Aircraft landed shv without further incident. Inspection by maintenance technician revealed contamintated fuel. Fuel system flushed and…Accident 20170821015859AGreene R/Greene S Rans S-17 · Erie, COOn 08/21/2017 at 1845 MDT, N117BE, a rans S-17 light sport airplane, impacted the ground at Erie municipal airport (eik). There was one person on board, who received no injuries. The aircraft was substantially damaged. The weather at the time was VMC.Accident 20170821015849ABeech C23 · Rexburg, IDFrom phone conversation with pilot: Prior to flight, pilot and father-in-law arrived Friday for eclipse viewing. Plan was to depart right after around 11:40-noon but everyone was departing so they elected to grab lunch then fly. Arrived 2PM to the airport.…Accident 20170821013549ACessna 170B · Rochelle, ILDescription of accident: on August 21,2017 the pilot in command (PIC) of N2486D, a Cessna 170, landed hard at Rochelle Municipal Airport (krpj) on runway 07 resulting in substantial damage to the aircraft. Wind at the time of landing was 220 degrees at 15…Accident 20170821013539ALuscombe 8A · Perryville, MOThe pilot lost control of the aircraft on the takeoff roll. The aircraft throttle was not reduced immediately when the aircraft began to swerve to the left. The right landing gear broke away from the aircraft. The aircraft then struck the PAPI lights and…Accident 20170821011599AAir Tractor AT-402A · Shaw, MSAround 6:30 pm, August 21, 2017 aircraft registration number N247LA crash on takeoff in Shaw, Mississippi. The pilot reported that as he was trying to take off with a full load from his home base he noticed that he was redline torque and RPM, and when he made…Accident 20170821011289ACessna 172N · Guntersville, ALPilot departed calhoun, ga on a cross country flight to Guntersville, AL. The takeoff and enroute portion from calhoun to Guntersville was uneventful. The pilot entered the traffic pattern to conduct a touch and go on runway 07. The touchdown was uneventful.…Incident 20170820021529IAero ACMNDR-690 · Hailey, IDThe airman landed on runway 31. After landing, the airman inadvertently cut the corner while taxiing off of BRAV0 five. The airman realized it, stopped the aircraft and advised ATC. After stopping the aircraft to reverse thrust, he realized the propeller had…Incident 20170820017239ICirrus Design SR22 · Tangier Island, VAThe pilot was hesitant to go to Tangier Island due to the length of the runway and lack of facilities available. He had experience with short runways in the Cirrus that he was flying. The pilot made a lower than normal approach and aimed to touchdown on the…Incident 20170820017229IQuad City Ultralight Acft Challenger LW1 · Watervliet, MIAn experimental aircraft operating as light sport and flown by a private pilot-certificated owner experienced a power failure for unknown reasons during cruise flight. The pilot performed a forced landing on a golf course approximately 1.5 mile west of the…Accident 20170820013519ACessna R182 · Boonville, MOAfter landing on runway 18 at kver, the pilot applied the brakes and the left brake locked up. The aircraft veered left and departed the runway. The aircraft came to rest in a deep drainage ditch on the east side of runway 18.Accident 20170820013509APiper J3C-65 · Green Creek, NJAircraft took off from paramount airport at 09:48 EST to conduct banner tow operations. Aircraft flew until 13:40 EST, at which point it dropped its last banner and turned downwind. Following the turn, at approximately 250 feet AGL, the engine quit, at which…Accident 20170820013499ACessna 180 · Newport, NHPilot of a Cessna 180 had right brake control issues while taxiing, which resulted in the pilot ground looping the aicraft.Accident 20170820013489ABell 47G-2A · Saint Marys, PAThe PIC / student pilot was flying solo for approximately 1.5 hours on the day the accident occurred. He stated that he was flying to and from the airport sightseeing as the sole occupant of the aircraft. There is no evidence the pic/student pilot was being…Accident 20170820011679ADehavilland DHC-6-300 · San Diego, CAAfter departing John Nichol'S Field(0CL3), the airman thought he experienced a bird strike. The airman notified ATC and diverted to the nearest airport which was brown field. (Ksdm) after further investigation it was determined that what the airman assumed…Accident 20170820011379AMooney M20C · Palm Coast, FLOn August 20, 2017, about 2055 eastern daylight time, a Mooney M20C, N6833N, was substantially damaged (fire damage to the complete cockpit)during a forced landing following a total loss of engine power after takeoff from flagler executive airport (fin), Palm…Accident 20170820010439ABell 206B · Minden, NVDuring an approach for landing at an off airport helipad, the pilot stated "while landing at helipad, helicopter encountered lte (loss of tail rotor effectiveness). I maneuvered the aircraft to vacant pasture adjacent to helipad. Aircraft then slid and tail…Accident 20170820010429APiper PA-28R-200 · St Augustine, FL^T. camillo^ and instructor ^mohamed defrawy^ were doing traffic pattern/touch and go. During one of the take-off'd at 500 ft ^t. camillo^ switched the fuel to the other tank and with the fuel pump on and the engine failed. As soon as the engine failed,…Accident 20170820010419ABeech A36 · Lowman, IDAirman was landing runway 02 during the late afternoon with high temperatures, high density altitude and gusting winds. According to the pilot, the approach was normal, however during the flare he realized the wind had changed from a cross-wind to a tailwind.…Incident 20170819017209IPiper PA 46-350P · Hutchinson, KSN14BC was landed at Hutchinson Municipal Airport with the gear in the up position. Verified normal gear operations by putting aircraft on jacks and operating the system. All gear down lights illuminated, gear warning horn operated normal.Incident 20170819017199IAviat Pitts S-2B · Sherman, TXOn 08-19-2017 while praticeing aerobatics in the pratice box located at the Sherman airport (kgyi) the S2B pitts aircraft suffered a right rudder cable failure due to corrision caused by sweat from pilots leg touching the cable while flying. During landing at…Incident 20170819017189IPiper PA-28-151 · Crystle Beach, TXDuring a 14 CFR 91 flight, the pilot was taking two friends to have lunch. The pilot reported that he was a little fast and high on the approach and went off the end of the runway.Incident 20170819017179ICessna 208B · Bolder City, NVUpon takeoff airman received a TCAS warning and aborted takeoff on runway 27L. Airman made decision to continue takeoff from point on runway, about 1/3 down runway and second guessed decision. Aborted takeoff a second time and breaking to the end of the…Accident 20170819013479ASmith Aerostar 601P · Marietta, PAAirman failed to apply proper corrections to maintain centerline of runway during takeoff roll. Airman lost controll of aircraft. Aircraft exited the runway and sustained substantial damage.Accident 20170819011709APiper PA-28-161 · Mohave, AZPilot landed on runway 18 at sun valley airport near fort Mohave, Arizona. During the flare, just prior to touchdown, pilot stated that he encountered a strong gust of wind that lifted the aircraft upward. That when the wind subsided, the aircraft settled…Accident 20170819010409ARich Mark Wheeler Express · Madras, ORThe pilot of the home-built Wheeler Express experimental aircraft N246TM was on his way to view the total eclipse at Madras Oregon. The pilot held a private pilot certificate with an instrument rating. According to a controller statement N246TM experimental…Accident 20170819009229ACessna R182 · Clearwater, FLThe pilot stated that at approximately 1200 EDT he departed kvdf enroute to kclw, while in the process of performing a gump check, the landing gear failed to come down and lock. The pilot stated that he did a missed approach and departed from the pattern to…Accident 20170818021769ABoeing E75 · Centerville, TNDuring flight instruction, student pilot had landed the aircraft and was on roll-out when he experienced light crosswinds causing the aircraft to drift off the rwy centerline. The instructor pilot (ip) stated "I have the aircraft". He was able to steer the…Incident 20170818020699IPiper PA-18 · Carry Falls, NYUpon landing on the beach at Carry Falls reservoir, NY, the aircraft experienced a sand bar causing the aircraft to flip onto its back causing minor damage to the prop, left wing, left wing lift strut and rudder.Incident 20170818020689IDiamond Aircraft Ind DA20-C1 · Columbus, GADuring a cross country student solo flight, aircraft departed from auburn, al airport after a full stop landing. Upon departure, the nose wheel fell off the aircraft. An emergency landing was accomplished at Columbus, GA airport.Incident 20170818017169IBeech 95-B55 (T42A) · Shrevrport, LAOn August 18, 2017 on or about 1605 CST, the airman was practicing emergency procedures with a flight instructor. While performing a simulated engine failure on takeoff the aircraft veered left off the runway. The airman and flight instructor discussed abort…Incident 20170818017159IPiper PA-34-220T · Peachtree City, GA1981 Piper seneca iii model PA-34-220T N8417H serial number 34-8133178 registered to riddell enterprises inc. was involved in an occurrence which took place on August 18, 2017 at 0705 EDT, kffc atlanta regional airport-falcon field. The code of federal…Incident 20170818017149IDalin Ronald K T-51 Mustang · Ashtabula, OHDuring fly over event on 08/18/2017 the aircrafts canopy opened in flight, striking the right side of the fuselage, the right hand flap then traveled aft striking the top of the vertical and rudder. The aircraft declared an emergency, landed without incident…Incident 20170818017139IBeech A36 · Conroe, TXPilot was on his way back to houston from athens Texas. Pilot noticed he had zero oil pressure, he reported to ATC he needed to land at nearest airport. ATC directed him to Conroe cxo. Pilot proceeded to cxo and then oil spray was coming over the windshield.…Incident 20170818015839ICessna 414A · Muscle Shoals, ALWhile at 15,000 ft. MSL, en route from kmkl to kdts , the right engine manifold pressure decayed. The right manifold pressure began to increase with right throttle advancement. The pilot heard a loud bang from the right engine and observed oil streaming from…Accident 20170818013469ACostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAAircraft performing touch an go training experienced engine failure on climb-out approximately 600 ft. AGL. Instructor attempted restart twice before making emergency landing in horse pasture. Aircraft collided with wooden fence outlining the field.…Accident 20170818013459ACessna A185F · Aniak, AKImmediately after application of full power for departure roll, 3/4 of one blade separated from 2 bladed propeller assembly. Pilot heard loud pop then felt severe vibration and immediately shut down engine and aborted take-off roll and came to a complete…Incident 20170818012069IMooney M20K · Yellow Pine, IDPilot reported that he set up an approach to land full stop on runway 19 at Big Creek (U60). Landing was with full flaps. During the landing flare at approximately 5-10 feet AGL, the aircraft dropped onto the runway. The hard landing caused the nose gear to…Incident 20170818011819IEurocopter AS 350 B3 · Aspen, COOn 08/18/17 @ 0545 mt, an air methods (qmla) helicopter, N392LG, was on approach into a Back Country landing zone on the conundrum creek trail in Aspen Colorado. It was night VMC and the pilot was operating on night vision goggles. The landing was very close…Accident 20170818010579ABellanca 7ACA · Fairhope, ALFront seat pilot was practicing touch and go landings on runway 19. During climbout after 6th landing and at approximately 500 feet AGL, pilot reports engine quit. He attempted a restart by adding carburetor heat, checking the throttle, and checking fuel on.…Accident 20170818010399APiper PA-18-150 · Sweetwater, TXOn August 18, 2017, at 1145 local time, N82912, a Piper PA-18-150 super-cub, registered to united states department of agriculture ground looped while landing. The accident occurred while landing on runway 17 and ground looped to the left at Avenger field,…Accident 20170818010389AMike L Reed Reed/Javron CUB · Murphy, IDPilot was landing on an unimproved strip, located between 6 to 7 miles southwest of Murphy Idaho. The landing direction was to the northeast which had a slight down hill gradient. Pilot reported that winds were light and variable. Approximantely 100 ft. from…Incident 20170817017129IPiper PA 46-350POn August 17, 2017, at approximately 17:55 hours, a Piper PA-46-350P [privacy data omitted] operated by the pilot, crashed at Brownsville Airport when its nose gear collapsed during landing. VFR flight conditions prevailed and the pilot did not file a flight…Accident 20170817015829ABeech A36 · Gonzales, LAAircraft departed Gonzales Regional Airport (reg) for an instrument training flight. On-board were the private pilot [privacy data omitted] and the flight instructor. After take-off at approximately 150 feet the pilot states the aircraft would not climb. The…