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.
Accident 20170507008699ARotorcraft Development OH-58A+ · Waterloo, ILOn may 07, 2017 at approximately 1450CST OH-58A+ helicopter, N993YC contacted power lines while performing aerial spraying operations which caused the pilot to lose control of the aircraft. The aircraft crashed and landed in the field approximately 300 feet…Accident 20170507008039ABay St Louis, MSThe unmanned aircraft system?s remote pilot in command reported that on Sunday may 07, 2017 approx. between 10:30 and 11:00 am at the bay st. Louis Mississippi public boat marina (30 18? 37.5696? N 89 19? 25.1544? W) which is in class g airspace. The PIC…Incident 20170507006709IBeech 200 · Calhan, COOn 05/07/2017, at approximately 1230 MDT, aircraft N32SV, a Beech 200, made a pass at approximately 12,000? AGL for skydive passengers to exit the aircraft. A skydiver in a wing suit was reportedly spiraling after the main canopy deployed between 5,500-5,000?…Incident 20170507004619IGlobe GC-1B · Franksville, WIOn may 7, 2017 at 1000 N78175 a 1946 Globe GC-1B with only the pilot on board, experienced a collapsed left main landing gear upon landing on runway 1 at Cindy Guntly Memorial Airport (62C). There were no injuries to the pilot. The weather at the time was…Incident 20170507004589IBeech C90 · Beloit, WIOn may 7, 2017, at approximately 11:41 CDT a Beechcraft C90 king air, N157CB, landed gear-up at 44C airport on runway 25. The commercial pilot was the sole occupant and received no injuries. The aircraft sustained minor damage. The aircraft was being operated…Accident 20170507004169AGrumman Acft ENG Cor-Schweizer G-164A · Madera, CAPilot stated that he had made aproximately 3 aerial application flights in this aircraft from the same runway just prior to the accident takeoff attempt. Pilot stated that as he began his downwind takeoff with a 7KT, gusting to 14 kt tailwind, the aircraft…Accident 20170507003949ACessna A185F · Big Rapids Town, MIThe pilot stated he made several successful touch and goes on runway 32. The pilot said the wind was reported as 320@10. The pilot decided he was going to practice a crosswind landing on the third attempt so he switched to runway 27. Recorded video at the…Incident 20170507002569ICirrus SR22T · Richfield, UTPilot stated he made a good landing and onrollout encountered a bad vibration in the nosewheel and it continued until the nosewheel failed and snapped off from the aircraft at the attachment point.Incident 20170506013039IBeech V35B · Plattsmouth, NE05/06/2017, 1215 CST aircraft touched down at the Plattsmouth Municipal Airport with the gear up. Aircraft skidded to a stop on the runway.Accident 20170506006719AJohnson Kenneth Super CUB Sport · Spanish Fork, UTFollowing touchdown and deceleration during rollout, pilot stated possible asymetrical application of the brakes.Incident 20170506003981IPiper PA-28-180 · Longmont, COOn may 6, 2017, at approximately 0830 hours (MST), N888AW, a Piper PA-28-180 sustained minor damage during ground run-up at Vance Brand Airport (klmo), CO. Weather at time was visual metrological condition (VMC). There was one occupant with no injuries…Accident 20170505012399AShort Bros. & Harland SD3-30 · Charleston, WVOn may 5, 2017 at 6:51 a.m. eastern daylight time (EDT), air cargo carriers flight 1260, a shorts SD3-30, N334AC, crashed during landing on runway 5 at the Charleston Yeager international airport (crw), Charleston, west Virginia. The airplane was destroyed…Accident 20170505009629ACessna 170A · Taos, NMOn may 5, 2017, at 1400 MST, a Cessna 170A, N9268A, registered to serendipity flying club, lost control after landing on runway 22 at Taos, NM. Visual meteorological conditions prevailed at the time and no flight plan was filed. The aircraft was substantially…Accident 20170505009179AAdrian George W EUROPA-CLASSIC · Wellington, KSWhile practicing takeoffs and landings, on his last approach the pilot stalled the aircraft at approximately 6 feet above the runway, resulting in a hard landing. The nose of the aircraft contacted the runway and the main gear broke, forcing the wing spar to…Accident 20170505008689AThrush S2R-H80 · Gypsum, KSOn may 5, 2017, at approximately 1500 hrs central standard time, the airman, and pilot-in-command, of a Thrush aircraft,S2R-H80, was involved in an aircraft accident after losing power and landing in a field east of Gypsum, KS. The S2R-H80 is owned and…Accident 20170505005729AStinson 108-2 · Pedro Bay, AKAfter landing and working in the area for 4 hours, pilot walked the runway to familiarize himself with the surface. At approximately 40 mph, tail still down a bit, resulting in limited visibility and did not allow him to see a rock on the right edge of the…Accident 20170505004979ACirrus Design SR22 · Clearwater, FLOn may 5, 2017 at approximately 2330Z, a Cirrus Design Corp. SR-22 was attempting to land on runway 17 at the Clearwater airpark in Clearwater, FL. The AWOS reported the winds as 27015G23. During a go-around attempt, the pilot in command lost control of the…Accident 20170505004739ARobert E Bounds Bounds Bearcoupe · Hanksville, UTThe owner of the aircraft was in Utah to do some backcountry flying. He hired a local flight instructor to show him some of the airports in the area. On 5/5/2017 the local instructor and the owner did some touring of the bank country airports in southern…Accident 20170505004159ARobinson Helicopter R44 · Santa Barbara, CADuring a part 91 air tour, aircraft lost engine power, entered an autorotation, impacted two parked vehicles during autorotative landing, and was subsequently destroyed by a post impact fire. During the post-fire examination, number 3 cylinder was not…Accident 20170505004069AQuicksilver Manufacturing SPORT2S R582 · Arecibo, PROn 05/05/2017 around 0830 I(ASI jose f.zayas) received a call from Mr. Edgar sierra (Arecibo airport manager) reporting that an experimental aircraft had crash at the Arecibo airport, registration number N228KM. He stated that there were no injuries to the…Accident 20170504009739ARedcrest, CADate of event 05/04/2017. FSDO notified 06/21/2017. Upon arriving the following was discovered. ? Witnesses reported hearing a rough running engine prior to takeoff. After climb out and just out eye sight,the PIC attempted to return to (river bed) landing…Accident 20170504006819AAutogyro USA AX7-77 · Stevenville, MDPilot was on takeoff roll at W29, lost control of aircraft, ran off runway, causing major damage to aircraft. Winds 110 @ 16 KTS gusting clearAccident 20170504006729ACurtis Lund Vortex · Spanish Fork, UTThe student pilot was practicing a normal landing to a runway but flared too high. The aircraft then landed hard and tipped over on its side. The pilot stated that the aircraft was operating normally.Accident 20170504005079ACessna 190 · Prescott, AZOn the morning of may 4 [privacy data omitted] was practicing stop and go landings in a newly purchased CE-195 with a more experienced CE-195 pilot. According to discussion with [privacy data omitted], discussion with and statement by the other pilot with…Accident 20170504004119AAir Tractor AT-502 · Tahoka, TXOn may 4, 2017, at approximately 1400 CDT, Air tractor, AT-502B aircraft registration number N144HF, impacted terrain at T-Bar Airport (2F4), in Tahoka, Texas. The pilot reported, shortly after takeoff rotation the aircraft lost power. The aircraft was being…Accident 20170504003999ANelson Sydney Vans Acft RV8A · Englewood, COAt 11:23, aircraft struck runway 28 while landing, damaging the nose gear. The aircraft departed the runway approximately 200 yards and to the left of the initial point of contact with the runway. The aircraft flipped over as it left the runway and came to…Accident 20170503021549ACessna C172 · Molokai, HIMolokai, HI (mkk): N173LL, C172, student solo x-c, no injs; rptd elevator issue; lndd on nose; bent fire wall/sub dmg; no ATC svcs; txt sent; notfd ntsb/simpson; hnl fsdo/kanayama POB: 1, injuries: none, damage: sub dmg. 5/3 1755Z. Here?s the emailed…Incident 20170503013029IClapp William Merle KR2-S · Iowa City, IAThe airman was making his second flight in the aircraft to become comfortable with it?s characteristics. The airman was planning on practicing full stop landings on runway 25. After takeoff the airman climbed to altitude and remained in the traffic pattern.…Accident 20170503006669ACessna T182T · Ravenna, OHPilot was a student pilot flying solo. Departed cuyahoga county airport(kcgf). The pilot stated, that he decided to practice touch and go at Portage County Airport(kpov). He landed just left of the center line on the runway. The aircraft continued left and…Accident 20170503006079APiper Navajo · Colton, NYAircraft departed cyqb in route to cyhu. Aircraft passed through montreal terminal airspace and pilot was unresponsive. Aircraft crashed into heavily wooded area at 327 windmill road, Colton, NY. Fire ensued and aircraft was destroyed. One on board was fatal.…Incident 20170503005989ICessna T210M · Claremont, NHOn approach to newport parlin field, pilot selected gear down. Green gear down light did not illuminate. Diverted to cnh. Ran checklist for gear malfunction. Attempted to manually pump gear down then filled reservoir with bottled water. Both unsuccessful.…Incident 20170503004079IRobinson Helicopter R44On may 3, 2017, at 1715 MST, a Robinson R-44 helicopter, N401JS, registered to flying helicopters inc, made a hard landing at a clearing on a high altitude ranch, approximately 50 miles west of Raton, NM airport, while on a personal flight. Visual…Accident 20170502017799ABell BHT-206 · Ft Mccoy, FLWent to accident site located at NE 212th lane, fort Mccoy, Florida. Located about 0.5 miles from bay lake. Met local law enforcement and aviation unit commander. Took pictures of the accident scene and destroyed helicopter. The helicopter was inverted in…Accident 20170502011029AAirbus A320-232 · Boston, MAAt approximately 1910 on may 2, 2017, jetblue airways flight 1317 en-route from Boston, MA to John F. Kennedy International Airport, new york, NY encountered turbulence. Summary of events: Inflight- all three flight attendants described the climb out as…Accident 20170502008569AMooney M20E · Olathe, KSThe pilot departed kixd and during climb out through 1000 feet, the engine lost power. The pilot declared an emergency and landed the aircraft in a farm field.Accident 20170502007469ACessna 172S · Atlanta, GAOn about 9:35 05/10/17 aircraft was landing at pdk. It had entered a right downwind for 21R. The wind was 250 at 8 knots. On final approach slightly left of the centerline. Aircraft transitioned from a nose-low to a nose-high attitude about 30 feet above the…Incident 20170502006859ITextron G36 · Dalhart, TXOn may 2, 2017 N429LD a Beechcraft G36 made an off-field landing five miles south of Dalhart Texas. The pilot was enroute to Dalhart for a fuel stop when the engine quit. The pilot noted that the fuel selector was on the left tank, he moved the selector to…Incident 20170502006029IPilatus PC-12/45 · Worcester, MAOn may 1, 2017, at 2342 hours, the pilot in command (PIC) departed the reading regional airport (krdg) located in reading, PA. En-route to Worcester Regional Airport (korh) located in Worcester, MA. Weather reports indicated rain, thunderstorms and fog for…Accident 20170502005009ABell 407 · Boothville, LAA Bell 407 helicopter was enroute to an offshore location . At approximately three (3) minutes after takeoff on the first flight of the day, the pilot heard a "pop" which was followed by a vibration he diagnosed as emanating from the tail section of the…Incident 20170502004049IPiper PA-28-181 · Pembroke Pines, FLStudent pilot on a solo flight at her base airport was clear to land by North Perry tower of runway 19L. When ATC controller then advised to exit next available taxiway the pilot rush to turn right and loose directional control and stop in the grass hitting…Incident 20170502004029IPiper PA-46R-350T · Charleston, SCOn 05/02/17 at 2303 hours z/ 1903 hrs EST aircraft N825A landed at chs from myam. After landing roll-out on runway 33 and exiting taxiway alpha, the pilot reported hitting taxiway lights while exiting the runway. There was 1 POB, no injuries.Accident 20170502003979APiper PA-32-260 · Mukilteo, WAAt approximately 1526 local time, N3457W, a Piper PA-32-260 (cherokee 6) departed from runway 16R at snohomish county airport (kpae) in everett Washington. The intended destination was klamath falls, Oregon (klmt). On board was the pilot, occupying the left…Incident 20170502001889IKevin Shannon Supercub · Priest River, IDBecause the airplane is equipped with tundra tires, the pilot elected to land next to the runway on the grass. The direction of landing was parallel to runway 19 (to the south). The right gear collapsed when it struck a hole or ditch in the grass. The prop…Accident 20170501015059ACessna 208B · Perryville, AKCessna 208B aircraft, N803TH, crashed into the side of a mountain at approximately 3000 feet while enroute on grant aviation flight GV340/341 between Port Heiden Alaska and Perryville Alaska. The pilot was fatally injured during the crash.Accident 20170501007139ASr20 Cirrus · Lakewood, NJOn may 1, 2017 a CFI from nassua flyers (part 61 flight school) departed republic airport, NY (frg) to pick up his student at monmouth executive airport (blm) in new jersey. The training flight was to be conducted on familurization of the avionics in the SR20…Incident 20170501004679IBombardier CL-600-2B19 · West Chicago, ILOn may 1, 2017, American airlines flight #2936, a CRJ-700, N866AS, operated by skywest airlines (swia) was scheduled to operate from Chicago, IL (kord) to cedar rapids (kcid). The flight had 3 crew, 50 passengers and 1 lap child on board. Initial reports…Accident 20170430020949AMaule MX-7-180A · Floydada, TXOn April 30, 2017, at 1230 CDT, N3035M, a Maule MX-7-180A registered to a private owner, encountered strong surface winds during taxi after landing and flipped over at Floydada, TX (F41F). The aircraft was being operated on a personal flight. Visual…Incident 20170430009599ICessna 210-5 · Abilene, TXOn approach to RUNWAY35L, the plane was in a crab and was being blown off centerline. Pilot did not feel comfortable, and never touched down. Pilot requested the crosswind runway. Pilot landed smoothly in the center of runway 22, then a gust started pushing…Accident 20170430004519AZwicker Murray R Glastar · Napa, CAMade 3 successful touch and go's on the lake. During the 4th touch and go, upon touchdown, the aircraft spun approximately 250 degrees and flipped upside down.Accident 20170430004499ANorth Wing Uum Sport X2-N · Boulder City, NVAircraft encountered a dust devil while on short final to flare on approach for landing. Control of the aircraft was lost during the wind shift. The aircraft collided with the terrain causing substancial damage to the aircraft. According to the instructor,…