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 20090115001509AN3107CWhile decending for a low altitude seeding pass, propeller RPM was increased and an engine vibration was felt. As power was increased, the vibration increased dramatically. The pilot made a forced landing in a snow and sagebrush covered area, and as the…Accident 20090115000329AGulstm 690C · Wray, CON840NK, an aerocommander 690C (GA-690-C) departed centennial airport (kapa) on an IFR flight plan to Wray, Colorado (2V5). The PIC was [privacy data omitted] and the second pilot was [privacy data omitted]. Also on board was a passenger [privacy data…Incident 20090115000279ISwftms GC1B · Half Moon Bay, CA(-23) The pilot took off from (sql) san carlos and headed to (haf) Half Moon Bay Airport. He landed on runway 30, during roll out he encountered a strong crosswind from the right. The aircraft ground looped and the side load on the left main gear caused a…Incident 20090115000189IBag JETSTM3201 · Grand Island, NEN874CP, ba jetstream-321, was operated as a commercial flight by corporate flight management under usc 14 CFR part 135. The flight departed st. louis, MO enroute to Grand Island, NE (gri). On approach into gri, the crew advised the tower that they had no…Accident 20090115000059AAirtrc AT301 · Beaver, UTWhile providing 14 CFR part 137 services under contract to the Utah division of wildlife resources (seeding), the aircraft experienced an engine vibration, lost power, and the pilot emergency landed the aircraft in a snow and sage brush covered area. Upon…Incident 20090114005439IDoug MD11 · Atlanta, GA(-23) Preliminary pilot deviation report was submitted by atl approach which cited the need for a vector instruction to a world airways MD-11. The vector was given to ensure traffic separation because of the world aircraft's failure to maintain the required…Incident 20090114002689ICessna 310N · Fort Myers, FLOn January 14, 2009, at approximately 1600 EDT, a Cessna aircraft, model 310N, N5097Q, serial #310N-0197, sustained minor damage when the nose gear collapsed upon landing on rny 005 at Page Field Airport, Fort Myers, Florida. Visual meteorological conditions…Accident 20090114001259AStits SA6B · Los Olivos, CAPilot had landed aircraft on figueroa mountain rd. after claiming to have experienced engine trouble. After conducting a successful engine run-up, he took off from the road. At about 50 ft. AGL pilot claims to have lost engine power. Pilot chose an oak tree…Incident 20090114001099IPiper PA44180 · Grand Forks, ND(-23) Upon gear extension, crew did not receive a gear down and locked indication. Nose gear was not visible in witness mirror or observed down and locked by ground personnel during intentional low pass. Aircraft landed with nose gear in retracted position.…Accident 20090114000429AHynes B2B · Cement, OK(-23) The pilot was landing during a test flight off of rented property approximately 2 minutes duration. One skid touched and the pilot over reacted with the cyclic in the opposite direction and then the helicopter rolled over on its side causing extensive…Accident 20090114000349ACessna U206E · Crane Island, WACrane Island airport is a Private runway, 1270’, with wet grass at the time of the accident. Airman landed the aircraft with insufficient runway remaining to safely stop. Airman applied full left rudder to “skid” to a stop resulting in right wing damage and…Incident 20090114000219IMooney M20R · San Antonio, TXOn January 14, 2009, a report submitted by Stinson ATCT stated the following: a Mooney M20-R, registration N197DT was issued alternative taxi instructions from parking to runway 32 via taxiway b and runway 32. N197DT was instructed to turn left a t the runway…Incident 20090113025029IBoeing 737-4Q8 · Kodiak, AKThe anchorage FSDO incident number is: IAL0320090010THE pilot stated: we were unable to fly the 'rwy 25 ils' approach into adq due to tailwind limits. We therefore planned the 'RNAV rwy 36' approach. The weather was good 1300/6, with winds out of the NE. Rwy…Accident 20090113009789ACirrus SR20 · Menomonie, WI(-23) N495LV destroyed on impact 5 miles north of Menomonie WI during enroute from sheboygan (sbm), WI to new richmond (rnh), WI. Aircraft was on instrument flight rules (IFR) flight plan. Aircraft fueled in sbm with 18.7 gallons. Enroute to rnh, aircraft…Accident 20090113001929APiper PA32R300 · Manteo, NCAircraft N7918C (complex se Piper lance) was cleared for GPS rwy 23 approach into Manteo, NC (mqi) by ATC at 2240Z. AWOS indicated wind 360DEG. @ 9KTS, vis. 4MI./rain, ceiling overcast. ATC radar service terminated at 2241Z. Approx. 2245, pilot contacted mqi…Incident 20090113001109ICessna 172RG · Carbondale/Mur, IL(-23) When the main landing gear was selected down for landing, a gear unsafe light illuminated. The pilot followed the emergency procedures and a fly by of the ATC tower at mdh was conducted where the controllers informed the pilot that his gear looked…Incident 20090113000079ILancar LC41550FG · Hailey, IDThe pilot of N504JL, a Lancair model LC-41 taxiied to the self serve fuel pump at sun. Because of an injured leg the passenger got out of the aircraft and pumped the fuel. Upon start up the pilot taxiied straight forward into a traffic cone which was placed…Accident 20090112001979ASnias AS350B2 · Gulf Of Mexico, USAs the accident helicopter picked up into a hover, it was moved sideways due to wind turbulence. The tail rotor struck a 24" steel "lightening strike protector" mounted vertically on the corner of the helideck. The commercial pilot reduced collective and set…Incident 20090112001159ILear 55LEAR · Chicago/Aurora, IL(-23) Pilot in command (PIC) was the pilot not flying in the right seat. The type rated second in command was the pilot flying from the left seat. Both pilots stated tht the approach (ILS 9 arr) was normal until just before touchdown when the aircraft started…Incident 20090112000759ITmpson Naviona · Latrobe, PAThe PIC was on a cross-country from monticello, NY (kmsv) to st. louis, MO. PIC departed approximately 9:00 am from kmsv. No flight plan was filed or planned, according to [privacy data omitted] statement. After several hours into the flight, PIC descended…Incident 20090112000639ICessna TU206G · Baton Rouge, LACessna model 206-G taxied off the taxi way into the sod. The aircraft propeller was damaged. No injuries. The airport is under construction and the pilot was confused as to where the taxi way was. Only 1 taxi light was out at the entrance of the taxiway.Incident 20090112000409IBlanca 1730A · Vivian, LAThe pilot stated he had a problem with the nose wheel steering after touchdown. The aircraft ran off the runway damaging the propeller. The aircraft was on a special flight permit.Accident 20090112000359ABeech 95A55 · Corona, CAPilot stated about 20 – 50 feet after takeoff aircraft loss power on rt engine and veered rt and touched down and impacted two parked airplanes and a hangar. There were no fire and the only occupant was the pilot with no injuries. Substantial damage to…Incident 20090112000199IMooney M20M · Reidsville, NCUpon arrival at Shiloh airport (sif) in Rockingham county, NC the pilot neglected to place the landing gear control handle in the down position prior to landing on runway 31.Accident 20090112000179AProbst Babyaced · Longview, TXOn January 12, 2009, about 1330 central daylight time (CDT), a Probst baby ace d, N610DD, collided with power lines and subsequently impacted terrain. The commercial pilot was fatally injured. The aircraft received substantial damage. This personal flight was…Accident 20090111002779APiper PA46500TP · Milton, FL(-23) Aircraft N428DC, PA-46-500TP departed from (aid) anderson Indiana, enroute to (dts) destin, FL. Airplane crashed in a wooded swampy area near black water river 1 mile northwest of peter prince airport (2R4). During flight pilot called in a in-flight…Incident 20090111001809IPiper PA28180 · Laurel, MD(-23) While landing on runway 03 at Suburban Airport (W18), the pilot descended into the tree tops at the approach end of the runway. At the time (17:05 on 01/11/2009) the pilot reported the winds from 340 @ 11 gusting 15. In addition, the pilot stated it was…Incident 20090111001519INord 1101 · Sparta, IL(-23) A crankshaft failure while aircraft was in the pattern for runway 18 at Sparta, IL, caused the aircraft to land short of the runway.Accident 20090111001459ACessna 150L · Sellersburg, IN(-23) This flight was to be an instructional flight. The student performed a normal takeoff. After becoming airborne at approximately 30 feet, the aircraft turned into the wing and entered a stall. The instructor took control of the aircraft, attempting a…Incident 20090111001059IBailey Avidmagnum · Upland, CA(-23) Aircraft was on private personal flight. The flight originated from Cable Airport to Cable Airport. The aircraft landed on runway 24 after short flight. The aircraft touched down and began a rollout. The aircraft was traveling at approximately 15 knots…Accident 20090111000499APilats PC1245 · Hayden, CO(-23) On January 11, 2009, about 0942 mountain standard time, a Pilatus PC-12 single engine airplane, N604WP, was destroyed on impact with terrian following loss of control while on initial takeoff climb by Hayden, CO. The private pilot and passenger were…Incident 20090111000309IBeech C24R · Chino, CA(-23) N6698F a Beechcraft BE-24 was in the traffic pattern to land on rwy 3, cno airport. The aircraft landed gear up. The pilot was the sole occupant with no injuries and the airplane sustained minor damage.Accident 20090110002019APiper PA18150 · Lake George To, MN(-23) On 01/10/2009 at 1705Z (1105 local) a Piper PA-18-150, owned by [privacy data omitted], operated by [privacy data omitted], landed in a field near lake George township, MN and flipped over due to the deep snow pack. VFR flight conditions prevailed, no…Accident 20090110001149ACessna 172RG · Carson City, NVDuring flight, the r/h main landing gear failed to extend; however, the l/h landing extended normally. After several attempts to cycle the gear, a landing was made with the gear in the up position. Post accident investigation determined that the (p/n…Incident 20090110000529IPiper PA32RT300 · Georgetown, TXPilot entered class d airspace without radio contact with ATC. Pilot did not respond to light gun signals during approach to gtu runway 36. Pilot attempted to land at gtu runway 36 with gear retracted. The propeller struck the runway surface creating an…Incident 20090110000289ICessna R182 · Davis, CA(-23) Pilot [privacy data omitted] was receiving instructions from his instructor. Both pilots briefed the procedure to be used for doing takeoffs and landings. During the second landing, pilot [privacy data omitted] reached for the gear instead of the flaps.…Accident 20090110000269ACessna 150L · Pescadero, CAThe pilot in command of the aircraft believed that he had a fuel leak and could not complete the flight to his destination airport. He elected to made a precautionary landing in a plowed field. As the aircraft came to a stop the nose wheel folded and the…Accident 20090110000139ACessna T210L · Albuquerque, NMPilot failed to remove the towbar after preflight inspection. Nose landing gear jammed during initial retraction and subsequently would not extend. Pilot elected to land gear up on runway 03 at abq.Incident 20090109003089ICessna 210B · Sebring, FL(-23) On 9 January, 2009 at 1224 local EDT, a Cessna 210, N9542X, serial number 210-57842, operated by [privacy data omitted], had a gear up landing during a post maintenance test flight at the Sebring Regional Airport (ksef) in Sebring, Florida. The aircraft…Accident 20090109002089ACessna R172K · Palo Alto, CA(-23) On January 9, 2009 at 2215 pacific standard time, a Cessna R172K, N758FN, made an emergency off field landing shortly following taking off from the Palo Alto municipal airport, Palo Alto California. The aircraft sustained substantial damage during the…Accident 20090109002059AParker 77 · Phoenix, AZ(-23) The owner/pilot was doing touch and go landings for currency/proficiency. On the fifth landing, the pilot states he might have flared a little high, then settled in to the three point landing profile. The plane bounced a little. It started to oscillate,…Accident 20090109000479ACessna 172F · Hardin, KY(-23) On 9 January 2009 at 0600 CST a 1965 Cessna 172F, registration number N28RP, serial number 17252854 crashed in a field in Hardin, Kentucky. Visual meteorological conditions prevaield and no flight plan was filed. The aircraft impacted the ground and…Incident 20090108005529IBeech A36 · San Luis Obisp, CA(-23) On January 8, 2009 at approximately 1255 local time, the pilot of N6696Y, a Beechcraft model BE-55, was landing at san Luis obispo airport (sbp). In a statement from the pilot, he was practicing the approach with a circle to land with a short final but…Incident 20090108001819IAerosp ATR72212 · Memphis, TN(-23) On 01/07/09 the technician in springfield, MO (sgf). Changed a number one engine starter/generator and performed an operational test per his signoff. The aircraft departed sgf for Memphis, TN. (Mem) enroute the number one engine experienced a low oil…Incident 20090108001089IPiper PA28161 · Chandler, AZ(-23) N4122T'S left wing tip rode up over N82044'S right wing tip when trying to pass through to the runway between the aircraft in the run-up area and the right edge of the taxiway. Wings overlapped approximately 18". N4122T'S wing leading edge had slight…Incident 20090108000089IRyan Navion · Kearney, NEAfter landing, while rolling down the runway at approximately 30-40 mph, the left main gear collapsed. Subsequent inspection at the repair shop, found the side brace bearing and bushing worn allowing movement of 2-4 degrees, allowing the left main to collapse.Incident 20090107003059IQuinon Lancairivp · Aguadilla, Puerto Rico(-23)[privacy data omitted] landed his aircraft registration number N9070R and mistakenly raised the landing gear instead of flaps, causing the nose gear to collapse.Incident 20090107001339IMooney M20C · Mojave, CA(-23) The PIC was on 6 mile final when a child in the back began to get ill. He was distracted while on approach. He put the gear down, heard it cycle like normal, but can't remember if he checked the gear lights. He touched down, rolled about 100-200' then…Accident 20090107000669ALavign Lancairivp · Iola, KSPilot was VFR enroute to Iola, Kansas (K88) for a planned fuel stop. The pilot made a visual approach torunway 1 and was in the landing flare as he observed another aircraft approaching to land on runway 19. The pilot of the accident aircraft elected to…Accident 20090107000489AInman Kolbmkiii · Coal Hill, AR(-23) 01/07/2009 1300 Hrs. Airplane N313JD, make:Inman j.d. model:kolb mark iii, amature built, experimental aircraft, located at [privacy data omitted], N35 60.35 W93 69, 46 attempted a takeoff from a Private grass strip airfield. The pilot [privacy data…