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 20180702009039ACessna 172P · Troy, MIStudent pilot came in for landing at approx 0650AM. Student pilot was being observed by CFI from the ground. Student pilot bounced on landing, executed a go-around and then decided to reduce power and land again. This resulted in the aircarft landing on the…Accident 20180702009029ARobinson Helicopter R22 Beta · Georgetown, TXThe flight initially consisted of maneuvers such as hovering, autorotations and rapid decelerations over a sod area at the Georgetown Municipal Airport (gtu). The flight then progressed with stop-and-go landings involving normal takeoffs and concluding with…Incident 20180702009019ICessna 402C · Nantucket, MAAircraft was conducting single-pilot, cargo-only operations and was to reposition back to khya with no freight onboard. While holding short of runway 6, the pilot in command (PIC) was performing pre-takeoff checks and noticed the navigation (nav) light switch…Accident 20180702009009ARonnie Koonce Safari 400 · Aguilares, TXPilot was attempting to further phase I requirements following certification. During flight the aircraft started to vibrate. The pilot turned and started to descend in an effort to land in an opening when he heard a loud pop sound followed by a loss of the…Accident 20180701015809ACessna A185F · Miami, FLWhen: July 1, 2018 @ 15:30 EST Where: Cessna A185F, registration N14ED with the pilot being the sole occupant on board flying, took off from fort lauderdale international airport (fll) and repositioned the aircraft to the Miami Seaplane Base (X44). During the…Accident 20180701008999AAyres S2R- Turbine · Pantego, NCWhile completing a knowledge and skill demonstration, PIC entered steep approach to landing, settled and landing gear hit ground hard, prior to runway. Aircraft wing hit terrain causing aircraft to turn; and resulting in damage to the wings. Deemed…Accident 20180701008979ACessna 421B · Clifton, TXOn July 1, 2018 at approximately 1040 CDT, a Cessna 421B, N7625Q, [privacy data omitted] had an accident at Clifton municipal airport/isenhower field (7F7). [privacy data omitted] The pilot was on short final to runway 14 and contacted the ground prior to the…Accident 20180701008969ABeech 58TC · Macinac Island, MIAircraft departed runway end while braking during aborted takeoff attempt due to no airspeed indicated to PIC. Aircraft slid into and partially through airport perimeter fence.Incident 20180630024429IMooney M-18C · Bartow, FLThe pilot wanted to fly from 28J palatka, FL to zph zephyrhills, FL in his newly purchased airplane. He called the zph airport for a current weather condition and he said they said it was clear skies. The weather in palatka, was broken clouds so he decided to…Incident 20180630017079IBell 206B · Charleston, WVHelicopter departed general aviation ramp without ATC communications/clearance.Accident 20180630015799ACessna 152 · Panama City, FLPilot experienced a loss of RPM and a rough running engine after initiating a shallow descent from 2000 feet. Pilot was unable to regain RPM after adjusting throttle and leaning mixture. Pilot chose to make an emergency landing on a dirt road. On touchdown,…Incident 20180630015789IPiper PA-32R-301T · Lovelock, NVWhen on a flight plan from trk to pvu, the pilot performed a precautionary landing at lol due to an alternator low voltage indication. When the landing gear was selected to the down position, the pilot noticed that the nose gear green light was not…Incident 20180630015779IEurocopter Deutschland EC 135 P2 · Longview, TXOn June 30, 2018 at APPROXIMATELY1756 CDT, an EC-135, N308PH, owned and operated by phi air medical, LLC had an incident at the East Texas Regional Airport.(ggg) [privacy data omitted] the pilot, was bringing the helicopter to a hover prior to departing the…Accident 20180630015769APiper PA-25 · Flat Rock, ALDuring the takeoff roll, prior to rotation, the pilot heard a noise followed by a drop of the right wing. The right Landing gear leg dug into the turf causing the aircraft to slow, veer to the right and depart the runway. The pilot made an emergency engine…Accident 20180630008989ACessna 182A · Birchwood, AKPilot described as "self-induced power loss." Pilot was doing a high speed taxi to check airspeed indicator when aircraft started to porpoise and she took it airborne. She stated she was being distracted by other radio calls and may have pulled the mixture or…Accident 20180630008959ACessna 152 · Sacramento, CAAircraft suffered a very hard landing that resulted in damage to the nose strut and prop strike, engine mount supports broken, bent and fuselage dents in skin at approximately 2-8 inches aft of the upper firewall engine nount attachment,Accident 20180630008949ABell 206B · Rio Grande, PROn jun 30, 2018 at 1623 hrs. (UTC), rotorcraft N10CV, a Bell 206B, departed from fernando luis Ribas Dominicci Airport (sig/tjig) in san juan, puerto rico, traveling to puerto del rey restaurant at fajardo, PR. At 1640 (UTC)the helicopter lost engine power…Accident 20180630008939ACessna 337F · Baldwin City, KSThe pilot shut down the rear engine and feathered the prop as part of exploring the single engine charecteristics of his aircraft. He then flew turns and straight-and-level noteing single engine climb rates, etc. When he tried to un-feather the rear prop and…Accident 20180630008929ATravel Air Mfg 2000 · Shelter Island, NYAirman landed his aircraft to the south and continued his landing roll out further south than usual due to an aircraft landing behind him. He taxied the aircraft to the right of the runway to be off the landing surface in a cut out of the treeline. He then…Incident 20180630008919IRyan Navion · Monticello, NY06/30/2018, At approx. 1315Z, N4791K, a Navion, landed with the gear up at Monticello (kmsv). No injuries occurred. The aircraft suffered minor damage to underside of fuselage center section and both propeller blades severely bent.Accident 20180630008899ACessna 182T · Swainsboro, GAOn June 30 2018 at approximately 6 pm EST. [privacy data omitted] A private pilot with approx 96TOTAL hours, attempted to land a Cessna, 182T, N6167L on runway 32 at the Swainsboro, GA airport ksbo. The aircraft landed hard and bounced. The pilot performed a…Accident 20180630008889AFpna A-22 Valor · Malone, NYUpon touchdown, left wingtip contacted runway. Aircraft turned to left partially breaking left main gear off and folding nose gear to the left. Prop stike removed all three blades. Aircraft came to rest on runway.Incident 20180629024219IMooney M20C · Crewe, VAThe pilot used a checklist to set up for his landing during downwind, base and final. On each leg he verified his gear was down with the green light associated with the gear being down. This light is connected to the position of the johnson bar or gear lever.…Incident 20180629018669IBeech E-90 · Las Vegas, NVGear collapsed upon landing runway 8RIncident 20180629015759ICessna R182 · Rapid City, SDPilot was coming into land at Rapid City, SD regional airport on 06/29/2018 at approximately 1930 local time. Pilot put gear down and only main gear came down. Pilot tried to put gear down manually and nose gear still did not come down. Pilot landed finally…Incident 20180629013609IBeech 35-C33A · Sodus, NYFlight was being conducted by aircraft owner for the purpose of maintaining instrument currency. The PIC had a CFII on board to act as a safety pilot. The PIC had just conducted an instrument approach to runway 10 and was conducting a circling approach to…Accident 20180629013029ABeech 35-B33 · Berlin, MDPilot departed from oxb on rwy 32. On climb out the aircraft lost power. The pilot was unable to return to the airport and made a forced landing on golf course near the airport. Weather: Temp: 81 f Due point: 70 f Humidity: 69 % Wind direction: nne Wind…Accident 20180629010769ARobinson Helicopter R22 · Sterling City, TXJune 29, 2018, at approximately 2013 CDT, N787SH, a Robinson R22 helicopter impacted with the terrain. Pilot was attempting to land on a transport trailer on the owner?s private property five miles west-northwest of Sterling City, Texas. The helicopter was…Accident 20180629008909ABeech A36 · Spencer, IALanding approach to runway 18 in strong and gusting winds from 180. Communicating with departing and arriving traffic for same runway. Focusing on aircraft performance and failure to properly interpret audible warning. The pilot neglected to extend the…Accident 20180629008879AChampion 7GCAA · Arthur, NEOn June 29, 2018, about 1245 mountain daylight time, a Champion 7GCAA airplane, N9026L, Impacted terrain while maneuvering near Arthur, Nebraska. The pilot was fatally injured, and the airplane was substantially damaged. Several witnesses attending a cattle…Accident 20180629008869ABalony Kubicek Spol Sro BB30Z · Ashland, OHThe balloon had landed after a short flight that had originated as part of the Ashland balloonfest hot air balloon festival. They were just starting to deflate the envelope when the wind increased and caught the envelope, which ?acted like a sail and pulled…Incident 20180629008859IClassic Waco YMF · Waterford Twp, MIOn June 29, 2018 aircraft N196RB upon landing on runway 27L bounced and veered left. The pilot while attempting to regain control of the aircraft struck a runway edge light. The aircraft continued to roll right when the right wingtip rubbed on the runway.…Incident 20180629008849IMooney M20J · Willmar, MNAircraft landed with the landing gear in the up position due to pilot error.Accident 20180629008839APiper PA-18-150 · Anchorage, AKSeaplane takeoff headed north, climbed to approx 200', loss/partial loss of power. Descending, turned right toward gravel runway, crashed into soft boggy marsh between taxiway and runway.Incident 20180629008829IMichael Lee Day Excalibur · Missouri City, MOAircraft on approach stalled at approximately 5 feet above ground level, resulting in a hard Landing and runway excursion.Accident 20180629008819ACirrus Design SR22 · Hudson, NY06/29/18 At 9:45 pm at the Columbia County Airport, in Hudson NY (1B1), involving aircraft N615EM, serial number 3682, owned by ginther associates LLC, flown by [privacy data omitted] [privacy data omitted]. [privacy data omitted] Is an instrument rated…Accident 20180629006919APiper PA-32-300 · Salisbury, NCOn 29 June at approximately 1600(l) a 1976 cherokee 6 300, s/n 32-7740023, 3742.02 actt with IO-540-K1G5, 3742 ett, 1741.2 TSO received substantial damage during a forced landing at Mid-Carolina Regional Airport (ruq) after an engine failure. The pilot and…Accident 20180628024109APiper PA-18-150 · Anchorage, AKOn 06/28/2018, at 0645 the pilot took off from (AK12) flying crown airport Anchorage, AK. He flew over to the susitna river just north of bell island. While landing on a sandbar , just north of bell island, the brakes were applied a little too hard and the…Incident 20180628008809IAir Tractor AT-802A · Dallesport, WAAt the end of water scoop on Columbia river (aftr 3-4 scouting passes) aircraft hit 2 roller type waves in quick succession. After climb out noticed wrinkle on top ofrt side flap.Incident 20180628008759IBeech 1900C · Anchorage, AKAircraft was marshaled from parking spot on operators ramp. During taxi, aircraft left wing made contact with cargo container partially parked on ramp skirting area.Incident 20180628008749IAirplane Factory Sling LSA · Poplar Grove, ILOn June 28, 2018 at 0945 UTC the nose wheel of N521NG departed the aircraft due to a hard landing by the pilot in command (PIC). There was minor damage to the airframe and propeller. The PIC [privacy data omitted] reported that he was approaching runway 30 at…Accident 20180628008739ACessna T210N · Pocahontas, AROn June 28, 2018, at 11:10 cdst, at Pocahontas Municipal Airport (M70), Pocahontas Arkansas, N8386C, a Cessna T210N aircraft registered to the pilot in command after landing and on rollout the aircraft veered to the left side of the runway exiting the runways…Accident 20180628008729ACessna 320D · Fairfield, UTOn June 28, 2018 N320MF, a CE-320-D was performing aerial photography west of lake mountain near Fairfield, UT. According to radar data provided by TRACON, the aircraft was flying at 153 knots in a heading of 142 degrees for 61 seconds. At 16:54:47 zulu, the…Incident 20180628008719IPiper PA-24-260 · Waterford, MIFrom report: pontiac, MI (ptk): N8383P, PA24, 1D2-PTK, struck a twy light with the right wing after landing ptk when turning off rwy 27L. POB: 2, injuries: none, damage: minor. 06/28/2018 2317ZIncident 20180627024419IRyan Navion A · Burnet, TXPilot stated that while on downwind he placed the landing gear down and saw three green lights which he announced to the check pilot. The check pilot recalls this action. Upon landing the pilot stated the aircraft continued to settle after he thought the gear…Accident 20180627022449AAir Tractor AT-502B · Tappen, NDOn takeoff roll the aircraft seemed to suffer a partial loss of power. The pilot jettisoned the load and moved the power lever all the way forward. The aircraft failed to climb and ran off the end of the runway and into a pond in which it flipped and came to…Accident 20180627015749AGrumman Acft ENG Cor-Schweizer G-164B · Malin, ORAircraft was spraying a agricultural field near Malin or. Pilot states that during a maneuver to return to the field pilot hit power lines and aircraft crashed.Incident 20180627013679IPiper PA-28-140 · New Bedford, MAPilot was approaching the downwind leg, at which point ATC advised that the current wind was 215 at approximately 15 knots with possible higher gusts from this direction. While on the downwind leg, pilot observed the wind sock to be blowing in the direction…Accident 20180627008709ASchweizer SGS 1-34 · Boulder, COOn June 27, 2018 at approximately 1515 hours mountain daylight time at the Boulder, CO airport (bdu) a model Schweizer sgs 1-34 glider, N134BC piloted by student pilot [privacy data omitted] made a hard landing due to rapidly changing/adverse weather…Incident 20180627008699IPiper PA-44-180 · Chino, CAWhile on final approach to cno airport, student pilot noticed right main landing gear did not indicate down and locked. CFI instructor took control of aircraft as PIC and performed several gear cycles, perform rudder turns and wingtip side to side maneuvers,…