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 20100605006019IChampion 7FC · Pequot Lakes, MNPrivate pilot in the front seat lost control of the aircraft on landing. The CFI in the rear seat failed to take control in a timely manner consequently the aircraft exited the runway midfield into an area of grass and sand. The right main landing gear…Accident 20100605005939AChampion 7ECA · Northwood, NDIndividual was conducting low level flying while searching for cattle. The aircraft struck a power line approximately 30 feet from the ground damaging the vertical stabilizer and rudder forcing the aircraft to land in a ditch. The aircraft struck the ditch…Incident 20100605005479IBeech 65-A90 · Sussex, NJAircraft was being repositioned to receive fuel. As the aircraft moved approx. 6 feet forward, a loud pop was heard and the aircraft began to move to the right as the nose began to collapse to the ramp surface. The nose of the aircraft struck the ramp as well…Accident 20100605005269ACessna 180 · Kenai, AKAirman made an Off Airport landing on the mud flats next to the cook inlet. During the landing roll out the aircraft's main landinig gear struck a soft spot in the mud which caused the aircraft to flip over on its back.Accident 20100604047939ABoeing A75L300 · Salina, KSAircraft N75263 departed Burger Valley field (58KS), near Salina, KS. Immediatly after take-off, the engine power dropped after becoming airborne as reported by the pilot. There was insufficient airspeed or altitude to clear the road at the FAR end of the…Accident 20100604037689ACessna 182P · Rainelle, WVDuring the takeoff roll on runway 35, the pilot attempted to become airborne, was unable to do so, and left the end of the runway into trees and down a slope 40 feet into a heavily wooded ravine destroying the aircraft. The conditions were VMC, temperature 79…Incident 20100604037089IPiper J3C-65 · Ocean City, NJPilot was returning to air field to drop banner off and ran out of fuel in the left tank. Pilot tried to swith to right tank which was full but was to late. Engine sputted and stopped running. Pilot tried to restart engine but was unable and made a emergency…Incident 20100604035779IRonald A. D Acrosport I · Water Ford, MIAircraft was on landing rollout when it suddenly veared to the right, tipped over on the propeller spinner. Propeller impacted runway and aircraft came to rest on it's wheels.Accident 20100604035139APiper PA-28-140 · Richfield, UTAfter takeoff on runway 19 at rif at approximately 500 AGL aircraft lost power and engine gurgled, pilot added more fuel with no effect and aircraft landed in alfalfa field that was just irrigrated. Aircraft hit fence with both left and right wings were…Incident 20100604035079IMcdonnell D MD-11F · Anchorage, AKAircraft N260UP departed rwy 14. At approximately 600' AGL, the #3 engine fire indication came on for approximately 5 seconds and then extinguished. The hydraulic failure warning illuminated. The crew reduced power to the #3 engine, declared an emergency,…Accident 20100604034959ACessna 421B · Anderson, INThis runway excursion was preceded by a loss of directional control after an unsatisfactory attempt at a rejected takeoff. The pilot holds a commercial certificate with a multi-engine rating earned in July, 2009. Since obtaining this rating, the pilot has…Accident 20100604005539ACessna 172S · Middle River, MDAircraft had hard landing at mtn. Substantial damage to aircraft:firewall wrinkled, prop strike, cowling shock mounts torn from brackets, wrinkles from main landing gear to firewall on belly of aircraft. Pilot was landing on runway 33AND had encountered a…Incident 20100604005509IPiper PA-28-236 · Waterbury Oxfor, CTPilot declared an emergency 5 miles northwest of Waterbury Oxford Airport CT at 10:50 EDT on 06/04/10 due to losing oil pressure. Aircraft landed on runway 18 at 10:55 engine was depleted of oil supply. Alert vehicles did respond, no impact on traffic.Incident 20100604005499ICoelho Jame RV-4 · Caldwell, IDTaxing on runway after landing to next taxiway and told by air show person to exit nearest taxiway so the pilot turned aircraft 180 degrees, to comply with instructions, when wind lifted the tail causing a prop strike.Incident 20100603038389IMonnett Joh SUB Sonex · Oshkosh, WIExperimental aircraft in r & d status. During takeoff roll, pilot lost control of aircraft as tail achieved lift. Aircraft veered drastically to the right. Went off runway striking a runway light and sustained minor damage to left wing root and center wheel.Incident 20100603037119IHawker Beec G36 · Mineral Wells, TXOn June 3, 2010 at 1921 local time, a Beech bonanza, N831CA owned and operated by [privacy data omitted]had a loss of ATC separation with N2023Z during cruise flight on an IFR flight with IMC weather conditions prevailing. An IFR flight plan was filed. The…Accident 20100603036079ACessna 180 · Humble, TXThe aircraft was on ILS approach into bush intercontinental (kiah) rwy 26R when the pilot communicated his intent to execute an emergency landing due to loss of engine power & fuel state. The pilot reported to ATCT that the aircraft would not make it to bush…Accident 20100603034949AMooney M20M · Port Clinton, OHThe pilot abandoned initial attempt for a landing on runway 36. The pilot conducted a close-in and unstable approach to runway 18. This approach included the use of spoilers just prior to touchdown and below 100' AGL, followed by a subsequent touchdown more…Accident 20100603034499AAir Tractor AT-502B · Pollard, AROn June 3, 2010, 1700 local, AT-502B, N6083G, serial # 502B-0284, was conducting aerial application operations near Flanigan Airstrip 3 miles northwest of Pollard, Arkansas. Air temperature was about 85 degrees and winds were calm. The aircraft had just…Accident 20100603005199ABeech C90 · Fort Worth, TXDuring routine training landing pilot reported loud bang during landing gear extension . Tower told pilot that gear was not fully extended .pilot hand cranked down gear again no nose indication made landing and nose gear collapsed.Incident 20100602055919ICirrus Design SR22 · Victoria, TXPilot stated that he was to fast for landing, but he thought that he can land the aircraft anyway. His approach to steep and fast for the aircraft, which made the first attempt a porpoise landing attempt after the second bounce the pilot took it for a…Incident 20100602043149IBeech 56TC · Rostraver, PAThe aircraft owner decided to accomplish a high speed taxi with the aircraft after an engine change, and prior to the aircraft being returned to service. The owner/pilot admitted he was going too fast at the end of the runway. He veered off the runway, ran…Incident 20100602038839IPereyra Car JET FOX · Misquite, NVOn June 2, 2010 at approximately 1010 local time, N197JF made a hard landing at 67L. During the roll out, N197JF ran over a taxiway sign and caused damage to the fuselage, wheel covers, nose wheel attach fork and one of the main tires of the experimental…Accident 20100602038379ACessna 182A · Franksville, WIPilot forgot to remove pitot cover during preflight. At rotate noticed no airspeed indication and aborted takeoff. Grass was wet, very poor braking, aircraft slid off end of runway causing substantial damage. No injuries to pilot or pax.Accident 20100602037759APiper PA-28R-200 · Brookshire, TXThe pilot lost control of the aircraft, while attempting to land in a cross wind. The plane went off the side of the runway and impacted a raised concrete slab. The collision tore the left main gear off of the plane, causing damage to the wing, wing spar, and…Accident 20100602036649APiper PA-28-181 · Block Island, RIThe pilot stated that he approached runway 10 at possibly a higher than normal speed and landed long, aproximately 1/2 way down the runway. This resulted in a poor landing in which the aircraft bounced. The pilot applied braking, but continued to drift to the…Accident 20100602036089ABell 222U · Midlothin, TXThe helicopter was in cruise flight at approximately 600 feet above ground level (AGL) when several witnesses saw the tail boom and the main rotor system separate from the helicopter. The fuselage was destroyed in an immediate post-impact fire. The main rotor…Accident 20100602035529APiper PA-20 · Dover, ARA Piper PA-20 not registered, operated by [privacy data omitted] at 1645 June 2, 2010 attempted a takeoff from a grass strip 5 miles east of Dover Arkansas. The pilot reported hitting a deer during the takeoff roll near takeoff speed. The pilot reported that…Accident 20100602035129ACzech Aircr Sportcruise · El Cajon, CAOn June 2, 2010 [privacy data omitted] was the sole pilot-in-command of light sport aircraft N334BB a light "sportcruiser".on this date at Gillespie Field (ksee)at approximately 10:38 local time, [privacy data omitted] took the active runway 27R at ksee with…Incident 20100602006069IPiper PA-28-140 · Plainwell, MIPilot aborted takeoff on wet turfrunway. Aircraft slid off runway unable to stop. No injuries and minor damage to aircraft.CFI providing flight instruction.Accident 20100602005419ARobinson He R22 Beta · Spokane, WAOn June 2, 2010 at 16:32 hours local time N522SA, a 2005 Robinson R-22 helicopter crashed in a neighborhood near the Felts Field Airport in Spokane, Washington. The helicopter was destroyed resulting in the fatal injuries of the sole occupant a student pilot…Accident 20100601041049APiper PA-44-180 · Okmulgee, OKThe aircraft was on an instruction flight doing a practice ILS approach. Upon landing the crew elected to do a touch and go. The student pilot inadvertantly grabbed the gear handle and selected it to the up posistion thinking it was the flaps. The instructor…Accident 20100601036749ASwanson Ray RV-9A · Hanover, VAThe aircraft engine lost power. Pilot was too high to make the runway at ofp. Glided down length of runway 34, touched down main wheels approx. 50 yards beyond runway in grass, rolled out about 100 feet, nosewheel touched down and aircraft flipped over…Accident 20100601035419ACessna U206F · Anchorage, AKAircraft initiated flight at Merrill Field Airport Anchorage, AK. Aircraft was taking off from runway 25 heading west. Aircraft was witnessed having trouble gaining altitude and was described as using more than average length of runway for the type of…Incident 20100601035329IAeronca 15AC · White Lake, MIOn 06/01/2010 at 0800 pm et, [privacy data omitted] made a water takeoff from Pontiac Lake in N1337H. During the initial part of the take off, his aircraft has headed directly toward a small fishing boat with 3 occupants. The forward visibility was extremely…Accident 20100601034859ACessna 172S · Greenfield, INAs the plane approached the runway for landing, the pilot realized the nose was low, began the flare and came down hard on the landing gear. A porpoise resulted with the aircraft nose tire and strut becoming compressed to the limit resulting in a single prop…Incident 20100601034799ICessna 172N · Henderson, NVN2726E sustained minor damage after the aircraft landed on rwy 17R at khnd and the pilot lost control of the aircraft. N2726E skidded off the runway approximately 1000 feet from the approach end of rwy 12R and came to rest in a ditch on the left side of the…Accident 20100601034419ACessna 172H · Dania Beach, FLOn June 01, 2010 I was on stand by duties for accident investigation for the office FSDO-19. At approximately 19:54 of 06-01-10 I have received a dispatch call from regional operational center (atl-oprtr ken) for an accident at the above location. Upon…Accident 20100601005369AEagle Aircr Eagle DW-1 · Waterville, WAPilot was making a delivery flight from Waterville, WA to chester, Montana. Approximately 10 minutes into flight the engine started to run rough, surge, and backfire. Pilot turned back towards airport and troubleshoot. Pilot could not figure out anything and…Accident 20100601005359AShaffer Wil Quicksilver · Visalia, CAOn initial approach to land onto a dirt road, crosswinds were encountered. The PIC initiated a go around and set up to land into the wind on to an adjoining stubble field. The surface was to soft/rough causing the right main gear to collapse. Additional…Incident 20100601005149IHudson Ralp GL20 Glasai · Everett, WAThe [privacy data omitted]/pilot of this aircraft was performing touch and gos at pae when preparing for the second landing, he noticed that the he did not have a green landing gear down light for the left main gear. He flew past the tower and they verified…Accident 20100601005129AAirborne Wi Edge X · Alturus, CAThis information was provided to the reporting inspector via email on 6/2/2010 by [privacy data omitted] (PIC), PIC was instructing [privacy data omitted] on June 1st getting him finished up for his solo which he was ready for the following morning. We were…Accident 20100531037749ACessna 172K · Wellington, KSOn may 31st, 2010, at approximately 1320 local time, a private pilot was involved in an aircraft accident while attempting to hand-prop an aircraft with the intent to depart from the Wellington municipal airport (kegt), Wellington, Kansas. The aircraft…Accident 20100531036759ACessna 172N · Sterling, MA05/31/10 [privacy data omitted] departed Sterling Airport with 2 passengers at 11AM on 5/31/2010, they flew to plum island for lunch. Departed plum island at approx 1430 hrs, she flew over Sterling Airport at approx 1540 hrs at approx 1500 feet, [privacy data…Incident 20100531036199IPowrachute Airwolf 912 · Mankato, MNPilot reports that he was flying south from a nearby grass strip and completing a circle over a park. At the completion of the turn it suddenly droppped on the right side and began a rapid spiraling decent.Incident 20100531036189ICessna TU206G · Camden, ALPilot attempted takeoff run on the Alabama river in Cessna 206. Pilot noticed that he could not get aircraft airborne and aborted the takeoff run. Engine was functioning properly and no signs of any malfunction. On the taxi back to the dock pilot noticed that…Accident 20100531035949ACessna 182H · Oliver Springs, TNN8311S touched down beyond the last 1/3 of runway 33 @ TN08 (pvt) Oliver Springs, TN. Heavy braking was applied on the grass airstrip up to a point approximately 250-300 feet from the end of runway 33. A go-around was initiated. The aircraft came to rest in…Accident 20100531035439APiper PA-22-160 · Port Alsworth, AKThe pilot was taking off from a gravel bar and ran out of land. He hydroplaned in for about 60 feet before flipping over in about 8 inches of water.Accident 20100531035169APiper PA-22-135 · Wellington, KSOn may 31st, 2010, at approximately 2200 local time, a non-certificated pilot was involved in an aircraft accident after incorrectly restarting the aircraft upon landing at the Wellington municipal airport (kegt), Wellington, Kansas. The aircraft involved in…Accident 20100531035119APiper PA-20 · Durham, CAAircraft N7013K, a Piper PA-20 departed pm duster's airfield, a privately owned airfield approximately 20 miles south of chico CA at approximately 1630 hours. At approximately 1645 hours, the aircraft containing a pilot and two passengers, crashed into a rice…