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 20080718841199AScwzer G164A · Bovina, TX(-23) On July 18, 2008 at approximately 2300 gmt, N7832, a Grumman G-164A departed a private airstrip near Bovina, Texas conducting aerial agricultural application under title 14 CFR part 137 over a field 12 miles southeast of Bovina, Texas. Following a…Incident 20080717856219ICessna 172RG · Stockbridge, GAIn VMC while conducting approach and landings at Berry Hill Airport 4A0, Stockbridge, GA. Pilot failed to extend landing gear. Aircraft contacted runway 29 and skidded to a stop. No persons were injured and the aircraft sustained only minor damage.Accident 20080717855169ABeech A36 · Tampa, FL(-23) On July 17, 2007, at approximately 1530 EDT, a Beech aircraft, model A36, N36CL, serial #E-1980, was totally destroyed after striking a navaid (ils-gs) tower upon departure from vandenburg airport, Tampa, Florida. The aircraft was airborne from runway…Incident 20080717847509IEclips ECLIPSEEA500 · Chicago/Prospe, IL(-23) On July 17, 2008 at 1700 CDT on a part 91 flight from pinedale, Wyoming enroute to wheeling, Illinois at approximately 250 knots, 5,000 feet MSL and passing through cumulus clouds over rockford, Illinois, a loud bang was heard. All controls and…Incident 20080717847149IPiper PA24 · Joliet, IL(-23) [privacy data omitted] was making a normal approach to kjot. Selected the "gear down" position, but failed to verify that the gear was down. It was not. After landing gear-up he noticed that the gear down light was not illuminated. Paying much attention…Accident 20080717844529ACessna T210M · Van Horn, TX(-23) At approximately 0930 CDT on July 17, 2008, the certificated private pilot [privacy data omitted] of N6882B, a Cessna turbo centurion (CE-T210M) flew the aircraft into the ground while attempting an emergency extension of the landing gear. The aircraft…Accident 20080717844019APiper PA30 · Rockport, TX(-23) Pilot stated that after a routine taxi and engine run-up a normal take-off roll was initiated, upon reaching rotation speed the aircraft settled onto the runway when the gear prematurely retracted. The two passengers and pilot exited the aircraft…Incident 20080717843179IPiper PA23250 · Nashua, NH(-23) On Thursday July 17, 2008 [privacy data omitted] was acting as pilot-in-command of a Piper PA-23-250, N62840 on a VFR flight from bedford hanscom field (bed) to Boire Field (ash). The flight was normal up unitl touch down when the pilot realized he had…Incident 20080717841409INamer SNJ6 · Pendleton, OR(-23) Pilot departed from twin falls, Idaho en route to mccord air force base Washington, with a scheduled fuel stop in Pendleton. As he approached Pendleton airport, he entered on a left base for runway 25, gear and flaps were down. Winds were said to be 15…Accident 20080717841149ABeech 65A80 · Midland, TX(-23) On July 17, 2008, at approximately 0921 CDT, N6AQ, a 1964 Beechcraft queen air, BE-65-A80-8800, operated by western air express, inc. (WX5A), landed on runway 10 at the Midland International Airport (maf) in Midland, Texas after reporting a landing gear…Incident 20080716857219IBell 47G2A · Fairhope, AL(-23) Ground wheel assembly retaining pin vibrated out of position allowing wheel assembly to slide off axle in flight, falling to ground with no injuries or damage to property. Pilot in command states that he checked the assembly for proper stowage and…Incident 20080716856229IBeech F33A · Naples, FLWhile moving aircraft from one hanger to another pilot foot slipped off rudder pedals and aircraft hit parked vehicle.Accident 20080716855189APiper PA18150 · Myrtle Beach, SC(-23) Engine teardown found no mechanical problems. Suspect carburator ice. Hornet nest found in carburator airbox that could have restriced use of carburator heat.Incident 20080716847499IEirvon PIK20E · Waynesville, OH(-23)On July 16, 2008, at 1700 EDT, a molino oy glider, N858E, registered to [privacy data omitted], struck a power line while landing off field when returning fro a cross country flight. Visual meterological conditions prevailed at the time. A VFR flight…Accident 20080716841439AAmtr Carata · Edgewood, NM(-23) On July 16, 2008, at approximately 1420 MDT, N234CT, an ams flight model carat a motorized glider, crashed in a field southwest of Edgewood, new Mexico. The private pilot, who was the sole occupant of the single place aircraft anc co-owner, was…Accident 20080716841179ACessna 172N · Cross Keys, NJ(-23) Student pilot was unable to handle the Cross-wind and unable to handle go-around. The flight instructor will receive a 44709 letter for his ability to instruct.Accident 20080716841159AAmtr Kitfoxiv · Burkesville, KY(-23) Catastrophic engine failure in flight.Accident 20080716840499AAmtr Sportstar · Frankfort, KY(-23) On 07/16/2008 student pilot [privacy data omitted], certificate number [privacy data omitted], was receiving flight instruction from [privacy data omitted], certificate number [privacy data omitted]. The aircraft was N603EV, an evektor-aerotechnik…Accident 20080716840459ACessna 441 · Sunriver, OR(-23) According to witnesses, the aircraft made a normal touchdown on the main landing gear just past the runway threshold but soon thereafter the nose wheel hit the runway with enough force that the airplane bounced back in the air. The airplane then touched…Incident 20080715856239IDiamon DA42 · Daytona Beach, FLDuring a commercial amel practical test, the applicant and pilot examiner failed to recognize a “door open” warning indication on the garmin 1000 display prior to takeoff. During takeoff roll, the rear passenger door blew open, ripped away from its hinges,…Accident 20080715855209ASocata TBM700 · Atlanta, GA(-23) Aircraft impacted trees and ground approximately 1.8 nautical miles west of runway 9 at ryy. Aircraft burst into flames upon impact with trees and aircraft was destroyed by the impact and fire.Accident 20080715843979AAmtr STARDUSTER2 · Tappahannock, VA(-23) A certificated pilot observed and reported the following: normal takeoff with a vx best angle of climbout. At approximately traffic pattern altitude, airplane was observed to steepen in climb. The engine noise suddenly stopped and airplane entered into…Accident 20080715843679AAmtr Aventuraii · Flushing, MI(-23) Approximately 1415Z aircraft was taking off from runway 27 at 3DA. Aircraft was headed west south west when an undetermined lack of power caused the aircraft to manuever into a nose up attitude. The aircraft began to stall and rolled over hard left…Accident 20080715843639ASwrngn S2RG6 · Kilbourne, IL(-23) Agricultural aircraft crashed after attempting to depart a 3500 foot private landing area two miles south of Kilbourne, IL. On take-off, the aircraft became airborne as it struck a shallow ditch between the runway and highway. The aircraft then became…Incident 20080715842239IGulstm 680 · Pittsburgh, PA(-23) During departure, aircraft retracted gear, crew heard a loud noise and had an associated unsafe gear light.Accident 20080715841499ABell UH1H · Rock Springs, WY(-23) The restricted catagory helicopter engine failed while operating under part 133. A 1,700 pound external load, on a 100 foot line, was atttached to the hook. The operation was being conducted at 9,000 density altitude in 81 degrees f. the pilot and round…Accident 20080715840979AHughes 269B · Mountain Home, AR(-23) On July 15, 2008 at approximately 0927 CDT a Hughes 269B helicopter, N469E, was conducting routine powerline inspections when it crashed into a wooded area approximately one mile from the norfolk dam in salesville, AR 72653. The aircraft was destroyed…Accident 20080715840159ACessna 182T · Factoryville, PA(-23) Pilot was landing at the Seamans Field (9N3) Factoryville, PA on runway 22. Pilot during the landing phase landed long and bounced landing. Pilot attempted a go around, which put him further down the runway. He attempted to stop the aircraft on the…Incident 20080715840009ICessna 402B · Portland, OR(-23) At approximately 2033 PDT the aircraft landed rwy 25 at Troutdale, Oregon, enroute from spokane, Washington on a part 135 cargo flight. Following landing, on roll out, the left main landing gear collapsed. The aircraft skid to a stop in the grass just…Incident 20080714847519ICndair CL6002B19 · Milwaukee, WI(-23) Flight attendant fainted after takeoff. Passengers called the flight deck via the interphone. First officer left the flight deck to help the flight attendant. First officer found nurse on board to help the flight attendant. Crew diverted to mke. EMS met…Incident 20080714847169IAmtr Vortex · Platteville, WI(-23) While practicing power off landings. Pilot flaired up to high, resulting in hard landing.Incident 20080714847069IEMB EMB145LR · Covington, KY(-23) Aircraft N569RP, experienced a dual main landing tire blowout during takeoff from 36C at cvg. The aircraft exited runway at taxiway D9. The passengers were evacuated and the aircraft was evaluated on the taxiway by chatouqua technicians. The following…Incident 20080714846889IAmtr Challengerii · Elbow Lake, MN(-23) Experimental aircraft N24100 out of Elbow Lake airport (Y63) encountered a loss of power at approx 100 feet after takeoff from runway 14. Pilot made forced landing in plowed dirt field at end of runway 14. Counseled owner and pilot on the importance of…Accident 20080714844589AAmtr STITSSA3A · St Louis, MO(-23) Aircraft entered 7' corn stocks and impacted ground at high angle, nose down and in left bank approximately 100 yards off center and midfield of the 3120' grass runway. The aircraft found upright facing 180 degrees to direction of travel. Upper area of…Incident 20080714842349IPiper PA28140 · El Valle, Mexico(-23) On July 14, 2008, N1331T was attempting to land in El Valle, Mexico; however, the runway was flooded so personnel at the airport waved the pilot toward a highway where they blocked traffic so the pilot could land. It was raining and nearly dark as the…Incident 20080714842169IAmtr LANCAIR320 · Prineville, OR(-23) Pilot used memory of previous trip to airpark and current sectional chart to provide him with airport data. He did not have current Prineville weather for the airport 10 miles northwest he attempted three approaches, he noted that the windsocks were not…Accident 20080714840859ABell 47G3B1 · Shafter, CA(-23) During agricultural operathions N1390XP was attempting to spray a field at night, when the aircraft suffered an electrical failure, causing the floodlight to stop working. Theaircraft was diving down towards the aa field when this occurred. The pilot…Incident 20080714839559IPiper PA32R300 · Mountain Home, AR(-23) July 14, 2008 approx 21:00 CDT N2125V a PA-32, departed (fsm) for smith, Arkansas returning to (bkp) Mountain Home, Arkansas. The aircraft was piloted by [privacy data omitted] along with two passengers. Pilot states that approx. 15 minutes out of (bpk)…Incident 20080714839199ICurtis P40N5 · Starkville, MSLeft main landing gear collapsed at slow speed at the end of the landing roll. Damage occurred to the propeller and left wing tip.Incident 20080713857499ILear 45 · Saratoga, NYWhile on rnav/gps approach to r/w 5 at 5B2, left wing and landing gear contacted trees that were approx. 50-55 feet tall and were approx. 1000-1200 feet short of the r/w. damage to the wing was: winglet leading edge dented 12" apove nav light, wing leading…Accident 20080713852309AScwzer G164B · Alturas, CA(-23) While performing dry fertilizer aerial application, approximately 11 miles south of Alturas, CA, the engine lost power and the pilot performed an emergency landing in a pasture. The aircraft nosed over onto its back. Inspection of the aircraft fuel…Accident 20080713841939ACessna 414A · Camarillo, CA(-23) Aircraft while taxiing drifted left ot taxiway centerline causing left wing tip to strike the left propeller of a king air parked in transient parking.Accident 20080713841629ADiamon DA20C1 · Norfolk, VA(-23) Instructor and student were taxiing in ramp area to the runway for pattern work. Instructor got distracted inside the cockpit while the student applied power and lost directional control. The aircraft's left wingtip impacted a light pole.Incident 20080713841399ICessna 207(-23) Pilot landed on hallo bay which is a sandy beach. On takeoff from hallo bay aircraft didn't accelerate as quickly as pilot expected. Before rotation aircraft went through some soft sand and water. Aircraft was nose high when it impacted river bank.Accident 20080713840939AAmtr Challengerii · Winslow Townsh, NJ(-23) On July 13,2008, an ultralight (N2785A) operated under FAR part 91 landed off airport on a resident's front lawn closest to 701 watertown road in Winslow township, NJ. The post office mailing address for this residence is berlin, new jersey. The…Accident 20080712855239AGrumma G164A · Pelham, GA(-23) The aircraft appeared to have impacted the ground gear first. Skidded approx 13 ft then bounced approx 10 ft. the nose of the aircraft impacted the ground creating a small crater approx 6 ft wide and 14 ft long. Then the plane came to rest inverted in…Incident 20080712847659IDiamon DA40 · Kelleys Island, OH(-23) Airman stated when he landed at grove city pa, from kellys Island, Ohio, he noticed the propeller had damaged to both tips with slight twists. Airman had no idea how it happened. Airman flew aircraft back to burke lakefront airport the next day.Incident 20080712847489IDiamon DA40 · Kelleys Island, OH(-23) Airman stated when he landed at grove city, PA, from kellys Island, Ohio, he noticed the propeller had damage to both tips with slight twists. Airman had no idea how it happened. Airman flew aircraft back to burke lakefront airport the next day.Incident 20080712847339IPiper PA28140 · Boonville, IN(-23) During VFR weather conditions on 07/12/08 at 1530 hr. Local time N601FL piloted [privacy data omitted] overran runway at Boonville, Indiana airport (I91). Aircraft entered into the runway 27 normal traffic pattern. Aircraft landed over half way down…Incident 20080712847119IGrtlks 2T1A · Pendleton, IN(-23) On Saturday, July 12, 2008 at approximaely 1245 hours, aircraft N647K piloted by a private pilot landed on a private grass runway (IN31). During landing rollout the aircraft's lower right wing struck a telephone utility post on the north side of the…