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 20190529008532ADougherty John G RV4 · Green Cove Spri, FL*Note: original FSDO notification referenced tail number N313RL. The correct tail number is N319RL. On may 29, 2019, at approximately 10:45 (local time), N203DD and N319RL (both RV-4S), collided in midair near Green Cove springs, Florida. N203DD sustained…Incident 20190529005419IPiper PA-28R-200 · Lubbock, TXOn may 29, 2019, at approximately 2200 CDT, N41585, a Piper PA-28-R-200 was involved in a gear-up landing. The aircraft was being operated on a personal flight. Visual meterological conditions prevailed at the time and an IFR flight plan was filed. The…Incident 20190529005409IPiper PA-24-250 · West Palm Beach, FLThe airman was operating N8044P, and intented to only due one traffic pattern with the gear down but, there was too much noise so he put the gear up and failed to lower the gear again since it wasn?t in his original plan to put it down in the first place.Accident 20190529005399APipistrel Lsa S R L Alpha Trainer · Salida, COAircraft was emergency landed on 05/29/2019 at approximately 20:45 in a field southwest of Salida, CO airport (ank). Upon emergency landing in the field the pilot was unable to control the aircraft rollout due to rough terrain. Aircraft contacted a barbwire…Incident 20190529005389IPiper PA-24-260 · Greenfield, INOn may 29, 2019, at approximately 6:15PM eastern daylight time (EDT), a Piper PA-24-260, N8965P, landed gear-up on runway two-five at the Indianapolis Regional Airport - Greenfield, Indiana (kmqj) The commercial pilot and [privacy data omitted]second pilot…Accident 20190529005379AMooney M20J · Cape May, NJThe pilot flew extremely low and fast over the water, shoreline, boats and people for approximately 20 minutes before impacting the water and sinking.Incident 20190529005369ICessna 172S · Millville, NJOn 05/29/2019, an incident took place at Millville Executive Airport, in Millville, NJ (kmiv). N346BS departed runway 28 at Millville Executive Airport, and prepared for a touch and go. Prior to landing and in the flare, the aircraft hit the right wheel and…Incident 20190529000641IBoeing 737-900ER · Jamaica, NYBritish airways B-747-436, reg. # g-civk, s/n 25818. On Wednesday evening, 29 may 2019, at approximately 1920 hours local time, british airways was pushing back from terminal 7 gate 10 for flight #174 to lhr airport. The B747-436 was pushed back behind the…Incident 20190528024629ISan Bernardino, CAUps pilot reported a drone within 200 feet of the aircraft while on the ILS approach into San Bernardino (sbd). Event occurred at 1808 local on 5/28/19.Incident 20190528023579ICessna 172S · Belleville, MIKyip tower called emi FSDO aprox. 1300L and informed FSDO that aircraft N5253C pilot had called in to tower after landing and reported a tie down hook missing upon a rough land on runway 23R. Tail tie down was available for inspection upon arrival at aircraft…Incident 20190528017179IPiper PA-12 · Anchorage, AKPIC was returning from bcv airport after practicing takeoffs and landings. Upon arrival at mri, PIC asked mri tower for a wind check. The reported wind differed from the wind sock indication for runway 23(the gravel runway on the south side of the airport).…Accident 20190528005359ADehavilland DHC-2 · Los Banos, CAOn may 28, 2019, at approximately 1500, N501J a Dehavilland (DHC-2) attempted to land on the San Luis Resevoir and upon touching down on the water surface the aircraft flipped and was submerged upside down in the water. The pilot was able to escape the…Accident 20190528005349ACessna R172K · Mertzon, TXOn may 28, 2019, at approximately 1400, N2583V, a Cessna R172K registered to a private owner, impacted terrain near Mertzon, Texas. The aircraft was being operated on a business flight. Visual meteorological conditions prevailed at the time and no flight plan…Incident 20190528005339INorth American SNJ-6 · Kissimmee, FLKissimmee FL, (ism) reported aircraft N452WA (T6) (ism-ism) lost a 6-foot right side panel while flying over farmland. Aircraft landed without incident and taxied to the ramp without incident. POB (2) no injuries, no structural damage . (1825Z)Accident 20190528005329ARaytheon A36 · Hilton Head, SCN998LS a BE36 landed gear up at Hilton airport (hxd). The aircraft slid on its belly causing substantial damage to the underside of the aircraft.Accident 20190528005319ASikorsky UH-19D · Brewster, WAPIC was evaluating applicant pilot for hire in this type aircraft for cherry drying flying. Applicant was at controls, rotor system lost power, aircraft had an engine over-speed and it failed. Evaluating pilot (PIC) heard a "bang", saw the over-speed on the…Accident 20190528005309APiper PA-28R-180 · Auburn Township, OHAircraft was VFR on a flight from Mt. Sterling Kentucky (kiob) to geauga county airport (7G8). The pilot made a stop at cincinnati lunken airport to drop off a passenger before continuing to geauga county. Weather containing heavy rain and thunderstorm…Incident 20190528005289IBoeing 747-430 · Philadelphia, PAReceived a report from Philadelphia ATC, that deutsche lufthansa, d-abvu, B747-430, s/n 29492 experienced a hard landing on runway 27R. During landing, # 1 and # 2 engine stuck the runway causing damage on both engines. Specifically, from the bottom of the…Incident 20190527011439ICessna 150M · Cario, ILOn 05/27/2019,aircraft N9244U, a Cessna 150M, serial # 15078194, departing from (cir) cairo municipal airport, the pilot and his passenger were out lesurly flying this day. Arriving at (2R2) hendricks county airport ?gordon graham field, indianapolis,…Incident 20190527005279ICessna R182Upon landing at ral, aircraft veered to the right off of runway. R/h MLG collapsed shortly after landing causing right wingtip to contact ground. Pilot states he had green indication light just before touchdown. Tire tracks on runway indicate r/h gear may not…Incident 20190527005269IPiper PA-28R-201 · Santa Barbara, CAThe pilot took off from rwy 25 at ksba. Soon after take-off , the pilot heard rattling and a loud sound coming from the engine. The pilot decided to return to the airport. Distracted by the unusual engine noise the pilot forgot to lower the landing gear. Ksba…Accident 20190527005259AAir Tractor AT-802A · Fisher, ARN802WW attempted northerly takeoff on a dry grass airstrip located on wixon lane in Fisher, Arkansas. After travelling approximately 500 feet, the aircraft veered to the left at a heading of approximately 330 degrees north-west. The aircraft departed the…Accident 20190527005249APiper PA-18-150 · Palm City, FLAircraft departed Witham airfield (ksua) at or about 1500 (local) for a local area flight. After about 45 minutes of flight, returned inbound for landing at Witham Field. At or about 1500 feet, engine lost power, 2 miles from airport. Aircraft landed short in…Incident 20190527005239IPiper PA-28-180 · Palm Coast, FLAircraft N3468R had a departed from kevb with a destination to kcrg. While it ransitioned through the kdab charlie airspace at 1,000 ft. off shore. After clearing the kdab airspace the aircraft climbed up to 5,500. Shortly after (~15MIN) they were about 4…Accident 20190527005229AChampion 7AC · Concord, GAOn may 27, 2019 at approximately 1000 EST, N1797E, a tail wheeled Aeronca 7AC airplane conducting a part 91 flight, was involved in an accident at coordinates 33°02?37? North and 84°25?55? West. On board the aircraft at the time of the accident was only the…Accident 20190527005219ABeech S35 · Bowie, MDAircraft landed on runway 36 at Freeway Airport (W00). Gear was not in the down position. Aircraft sustained structural damage to the belly. Weather: wind 070 at 4, visibility 10 statue miles, 5,500 scattered, temperature 28, dew point 15, altimeter 29.89…Incident 20190527005209I5 Rivers SQ-2 · Homer, AKOn may 27, 2019 at 1043 AKDT, N58SQ, a back country cubs MSQ2, received minor damage when the right landing gear broke during a hard landing at the Homer Airport in Homer, AK. Winds at the time of the incident were 140 at 11 gusting 19.Accident 20190526023589ACessna 150F · Garberville, CAOn may 26, 2019, at 1430 pacific daylight time, aircraft N8746S, a Cessna 150F, collided with a tree while on approach to the Garberville Airport, Garberville, California. The pilot and sole occupant, was seriously injured as a result. The aircraft sustained…Accident 20190526017189AJones Mark S Rand Robinson KR-2S · Poplar Grove, ILAll times are approximate. Alt and time data derived from aprs system tracking for KC9DAH transmitter operating in the aircraft at the time. 1550: Aircraft departed kfep rwy 6 after normal preflight and runup as per aircraft checklist. 1551: Climbout was…Incident 20190526011169IAeronca 11CC · Roseau, MNAs stated by the pilot via email "at landing on grass runway heading east, a gust of wind caught the wing and tail causing a ground loop, hitting a ditch taking out the landing gear, prop strike and left wing tip hitting the ground"Incident 20190526008479IAero Commander 200D · Pell City, ALDuring landing touchdown, an unknown mechanical malfunction occurred with the nose landing gear. Directional control was lost and the aircraft radically departed the runway, coming to rest after approximately 146 yards into the grass runway median. The nose…Incident 20190526005199IBellanca 17-30A · Detroit, MIAircraft was cleared to on rwy 15, the pilot then placed the gear control handle in the down position. The aircraft landing with the gear up.Accident 20190526005189ALuscombe 8A · Carbondale, ILOn 26MAY19 at Southern Illinois Airport (mdh) at 1335 local, N45729, s/n 2256, a 1946 Luscombe model 8A was taxing on runway 36R after touchdown, when a wind gust from the west caused the pilot to apply right rudder to correct, foot slipped off of the right…Incident 20190526005179ICessna 172S · Bedford, MAThe recently certificated flight instructor was returning to the ramp after conducting an intro flight with a prospective student. The student's wife was a passenger. The CFI was allowing the student to learn how to taxi and the aircraft began to drift toward…Incident 20190525023979IPiper PA-31-350 · Mckinney, TXOn may 25, 2019, at 1518 central daylight time, a Piper PA-31-350, N353JP, lost total power on both engines while on landing approach to Mckinney national airport, (tki), Mckinney, Texas. The pilot subsequently made an off-airport forced landing in a field…Accident 20190525005299ARockwell International S-2R · Oakes, NDN4907X departed 2D5 at 2 pm headed to the south east about 10 na miles from the airport. Pilot started spraying on the east side of the field spraying north and south and working his way toward the west, into the wind. On the turn around, on the north end of…Accident 20190525005169ACessna 180D · Yankee Creek, AKPilot in command stated the following during phone interview. He was very familar with the land and takeoff surface. He has landed at this location for many years. Completed preflight and takeoff checks Weather at the time was not a factor. On takeoff roll…Accident 20190525005159AHukill Christopher J RV10 · Okeechobee, FLThe pilot reported initiating a normal visual approach. As he flew in the traffic pattern he said "something felt a little off. I stalled the airplane not too FAR above the runway and came down hard".Accident 20190525005149ACessna TR182 · Saint Simons Is, GAN6123T was on visual approach into ssi and approved to change to advisory frequency. The aircraft disappeared from radar at 0923 EST at approximately 1,300 feet. The aircraft wreckage was located 5.5 miles NE of ssi oriented at about a heading of 210 degrees.…Incident 20190525005139IBeech A36 · Pearson, WAPilot landed 26 at Pearson airport, on the rollout a flock of birds flew off and one hit the underside of the right wing tip tank.Accident 20190525005129APiper/Cub Crafters PA-18-150 · Cody, WYStudent pilot was low on final and added power to extend. After crossing threshold for runway 22, student flared, but cut the power too quickly and added up elevator quickly resulting in a low (1-2 foot) bounce, then landed smooth enough to just roll on the…Accident 20190525005119AJihlavan Airplanes Sro KP5 · East Haddam, CTMay 25, 2019, instructor pilot and student pilot were conducting training on soft field take-offs (grass strip). The first two take-offs were conducted by the instructor pilot with no issues. The third take off was attempted by the student pilot. The student…Incident 20190525005109IMooney M20B · Winchester, VAN74566 is a 1961 Mooney M20B [privacy data omitted]. The standard a/w certificate date is 11 October 1961 and the valid registration certification issue date is 12 September 2016. The purpose of the flight was for personal/recreational reasons. The pilot…Incident 20190524011159ISchweizer 269C · Riverside, CAThis part 91 flight was intended to be a supervised solo in the traffic pattern. Reported winds 290/05 knots. Student and CFI performed three dual traffic patterns to the Riverside airport (ral) runway 16 helicopter practice area. The student pilot and her…Incident 20190524008469ICostruzioni Aeronautiche Tecna P2002 Sierra · Boulder City, NVThe takeoff was normal on runway 27, lifted off about 80 mph and made a left turn (crosswind) and flew downwind. During this time raised the landing gear, nothing was out of the normal with regards to the sounds of the gear. Stayed in the pattern to practice…Accident 20190524005729ACessna 560 · BHAircraft in cruise at FL 390. Checked in with ATC atl center level FL390. Upon attempt to contact flight with freq change to next controller was not acknowledged. Attempts were made on guard freq. And checks with previous controller advised no response.…Accident 20190524005099AAero Commander S2R · Grangeville, IDPilot was practicing aerial application over uncle's farm with load of water. Maneuvered to avoid uncle's house and to execute a 180 degree turn to start a new pass. Aircraft exhibited impending stall characteristics in a right turn ,pilot did not complete…Accident 20190524005089ACirrus Design SR22 · Grover, UTOn may 24, 2019, about 1122 mountain daylight time, a Cirrus SR22 airplane, N809SR, impacted terrain about 6 miles southeast of Grover, Utah. The private pilot and one passenger died, and the airplane was destroyed. The airplane was registered to tierra…Accident 20190523023709APiper PA-28-140 · Mckinney, TXOn 05/23/2019 around 1710 CDT N1568J, while on a part 91 flight, during landing, attempted a go-around, during which the aircraft lost control on climb out and impacted a storage facility and a residential house. The pilot and passenger both sustained serious…Accident 20190523016659ACessna 172M · Fredricksburg, VAN64003 is a 1975 Cessna 172M owned and operated by shannon school of aeronautics in fredericksburg, VA. The standard normal utility a/w Date is 15 March 1975 and the valid certification issue date Is 9 October 2018. The purpose of this flight was personal in…