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 20070810015649IBeech V35A · Slaton, TX(-23) On August 10, 2007, at approximately 1705 CDT, the pilot of N1240A, a Beechcraft model V35A, executed a landing to runway 18 at Slaton Municipal Airport (F49). On landing flare the pilot heard the landing gear warning horn, and discovered the landing…Accident 20070809828059ALuscom 8A · Mason, TX(-23) After landing turf (sod) runway 13 at Mason County Airport, Mason, TX T92, aircraft made hard left yaw collapsing right main gear and damaging right wing tip.Incident 20070809825849ICessna 182P · Rice Lake, WI(-23) Aircraft lost power due to fuel exhaustion and landed about 3 miles short of the Rice Lake airport in a soybean field with no damage sustained. Fuel had exited tanks through fuel cap vents and also displaced internal tank bladders causing a faulty fuel…Incident 20070809824439IDoug DC951 · Mcfarland, WI(-23) On August 9, 2007 @ 1400 mke FSDO received a telephone call from the Mcfarland police department Mcfarland wis. Sgt. [privacy data omitted] Informed this office that a found property complaint had been filed from a local citizen. A part from an aircraft…Incident 20070809023629IAirtrc AT302 · Creston, IA(-23) The pilot attempted to takeoff on a grass strip, with approximately 200 gallons of lorsban for an aerial application operation. After a ground roll of approximately 600 feet, the pilot aborted the takeoff. After the pilot applied the brakes, the…Incident 20070809022929IBoeing 7373H4 · Little Rock, AR(-23) On August 9, 2007 while on board southwest airlines (swaa) flight number 2632 that departed the chicago midway international airport, chicago, Illinois (kmdw) enroute to adams field airport, Little Rock, Arkansas (klit), a passenger smoked a cigarette…Accident 20070809021289ASphrth Ventuscm · Benton, CA(-23) The glider impacted mountainous terrain and was destroyed at approximately 10,000 fet MSL near boundary peak in the inyo national forest.Incident 20070809019779IPiper PA28R201 · Cahokia/St Lou, IL(-23) Aircraft was on a training mission that departed parks bi-state and upon landing on runway 30L at parks bi-state student inadvertently failed to lower landing gear. Instructor took control of aircraft and landed aircraft gear up. Damage to propeller,…Incident 20070809018659IBeech B200 · Topeka, KS(-23) At 12:30 local time the pilot of N1925P, BE-200, enroute from ict to pea reported electrical problems to zkc. The aircraft diverted to foe and landed without incident at Topeka, KS (foe) at 12:51 local time.Accident 20070809018439ACessna 182P · Bremerton, WA(-23) N1298M had a hard landing at Bremerton National (pwt) on 08/09/2007. During approach for a short field airspeed became too low and aircraft bounced off runway, then recovered in the air after the bounce and returned to Boeing field (bfi).Incident 20070809017969IMooney M20K · Las Vegas, NV(-23) The airplane was cleared to land on runway 12R. The pilot reports that there were gusty winds, but no significant crosswind. During the flare for landing, the aircraft "ballooned" (ceased descending and climbed). The pilot lowered the nose to compensate…Accident 20070809017619AAirtrc AT502 · Stringtown, IA(-23) The pilot had finished his application on a soybean field and was returning to creston municipal airport. The pilot reported that the engine quit without any warning. The pilot set up to land on a nearby highway but realized he did not have sufficient…Accident 20070809016799AEagle DW1 · Waterville, WA(-23) A/c lost power during loaded take-off, landed in soft dirt field adjacent to airfield, a/c overturned, came to rest upside down, pilot exited a/c, post accident fire, no injuries.Incident 20070808824519ICessna 172S · West Palm Beac, FL(-23) Instructor allowed the student to go too FAR on the approach to landing causing confusion. There was not a positive exchange of controls and the aircraft experienced a very hard landing. No further action is recommended in that I have counseled the…Accident 20070808022709ACessna A185F · Bethel, AK(-23) Aircraft just came out of 100 hr annual inspection. Preinspection ck list shows l/h tank empty r/h tank 1/2. Fuel selector valve handle and position indication cover was removed to facilitate maintenance. At time of removal handle was located so that…Accident 20070808019909ABeech 77 · Bloomington, IN(-23) N1837Y piloted by [privacy data omitted] departed Bloomington, IN (bmg) airport runway 17 to the north, then turned to the west. After roll out from the turn the pilot [privacy data omitted] noted the fuel indicated on board was less than he remembered…Accident 20070808019609AMaule M5235C · Talkeetna, AK(-23) CFI [privacy data omitted] was giving dual instruction to commercially rated pilot [privacy data omitted]. They were practicing landings at the Talkeetna, AK airport. The pilot [privacy data omitted] was on the controls. During a landing attempt on…Incident 20070808018379IDhav DHC2MK1 · Bethel, AK(-23) The pilot [privacy data omitted] made a hard landing on a glassy lake causing the right float strut to collapse. The failure of the strut caused an inward movement of the right float which was hit by the propeller.Accident 20070808018189ACessna 180 · Skwentna, AK(-23) Lost right brake on landing causing a ground loop, damaging a wing and wing spar. 08/21/07: 8020-23 completed this date and not expected to be amended.Incident 20070808017919IBeech A36 · Boca Raton, FL(-23) Pilot preoccupied with taxi instructions from ATC. Turned too close to curb hitting curb, resulting in the nose gear collapsing and causing damage to the aircraft. Piolt was counselled. No further action recommended.Incident 20070808017909IAerovd L39C · Mojave, CA(-23) Aircraft was performing a local flight from Mojave Airport (mhv), Mojave, CA. After approx 30 minutes of flight, the pilot noticed throttle becoming sticky & abnormal EGT reading. Performed normal landing at mhv. An engine tail pipe fire was noticed at…Accident 20070808015489ACessna A188B · Garden City, TX(-23) On August 8, 2007 at approximately 0815 CDT, N4827J, a Cessna CE-188-A188B, piloted by [privacy data omitted] impacted terrain near Garden City, Texas. While crop dusting, the pilot hit a cotton trailer located in an arroyo causing the aircraft to…Accident 20070808015469AMooney M20J · St Louis, MO(-23) After a night landing, the pilot exited the runway on a reverse high-speed taxiway. The pilot mistook this for a standard 90 degree taxiway and departed the paved surface making contact with a runway/taxiway sign with the aircraft's right wing. Damage…Incident 20070807023729IPiper PA32300 · Saipan Island, MP(-23) The pilot departed the tinian international airport for the scheduled 10 minute flight to the Saipan international airport. The cherokee six made a hard landing resulting in the nose gear collapsing and the propeller striking the runway. There were no…Incident 20070807019819IAyres S2R · Mt. Pleasant, IA(-23) The pilot was in a turn after applying the second swath of chemical on a field when the engine lost power and gauges went to zero. Pilot initiated emergency procedures and feathered propeller. Pilot picked a spot to land, dumped the chemical load, and…Accident 20070807019499ABell 206B · Warrenton, VA(-23) During landing maneuver tail boom bent to the right after touchdown. Crew shut down engine and evacuated aircraft.Incident 20070807017869ICessna 650 · Ankeny, IA(-23) The aircraft landed long on runway 18 at the Ankeny, IA airport and attempted to turn onto the taxiway at the end of the runway. The nose wheel slid off into the grass and mud adjacent to the taxiway. The aircraft was powered through the mud for…Incident 20070807017349IPiper PA44180 · Orlando, FL(-23) During a training flight, student pilot lost control of aircraft while practicing single engine landings 9L at Orlando Sanford International Airport (ksfb), Sanford, FL. After turning base the student was having trouble maintaining control of the…Incident 20070806018769IBlanca 1730 · Pueblo, CO(-23) On August 6, 2007 at approximately 1400 MDT, N6667V, a Bellanca model BL-17-30 experienced a right hand landing gear collapse after leaving runway 17 at memorial airport (pub), Pueblo Colorado. The aircraft sustained minor damage and was removed from…Incident 20070806018709IBoeing 737832 · Hayes Center, NE(-23) Dal 992 was eastbound at FL370 with standby power failure whereby loss of one of the standby electrical busses occurred which makes the aircraft in no way rvsm qualified. Den ARTCC turned aircraft 30 degrees left which caused a loss of separation…Accident 20070806017689APiper PA18180 · King Salmon, AK(-23) The PIC on takeoff from an off airport location encountered a wind shear causing the aircraft to roll to the right, striking the ground, causing substantial damage to the right wing, front and rear spar, and propeller. The wind at the time of the…Accident 20070806016439ACessna 172B · Sisters, OR(-23) Pilot received private pilot certificate 2 days before the accident. Pilot was distracted by a person near the runway surface and executed a go around. The aircraft drifted right of centerline and impacted several trees before coming to rest nose down…Accident 20070806014849APiper PA46350P · Sitka, AK(-23) Notified by FSDO that roc called to report that a Piper malibu crashed in downtown Sitka. Aircraft was on IFR approach to sit, circle to land ended up NE of airport over town of Sitka. Circled two times and then clipped trees at 57 03 181 n and 135 20…Accident 20070805827789ASIXCHUTER* · Toledo, WA(-23) On August 5, 2007, about 1134 pacific daylight time, an unregistered powered parachute made a hard landing at the ed Carlson memorial field - south lewis county airport, Toledo, Washington. The unregistered aircraft was substantially damaged. The pilot…Incident 20070805022089IBeech P35 · Centerville, TN(-23) Aircraft N35CD was level at 9,000'. ATC observed the aircraft to be at 9,000'. When the controller questioned the pilot, the pilot replied that he had just flown over a cloud and that an updraft had pushed the aircraft ot 9,300', and that he was…Accident 20070805020049AScwzer G164A · Vinton, IA(-23) Pilot was spraying a field near Vinton, Iowa. Tail caught a power line and spun the aircraft into another power line. Aircraft crashed and burned. Pilot escaped with minor injuries.Incident 20070805019679IBoeing 747422 · Washington, DC(-23) Aircraft was being towed from gate C-3 to gate C-27 for reposition of a revenue flight, when the #1 engine struck a heavy loader that was parked inside the red zone at gate C-27. No injuries were reported and the aircraft sustained major damage on the…Incident 20070805019189IEMB EMB145LR · Wichita, KS(-23) On August 5, 2007, at 1911 local time, the flight crew for trans state airlines, operating as flight 5473 departing st. louis, Missouri (stl) for denver, Colorado (den) diverted to Wichita, KS (ict) because of warning indications from the eicas. The #1…Incident 20070805018639IBeech A36 · Oskaloosa, KS(-23) Aircraft N123SN departed stockton, KS (OS2) enroute to lawrence, KS (lwc). During descent into lwc the pilot reported a loud bang followed by vibration and oil on the windshield. Shortly thereafter smoke started coming from the engine compartment and…Incident 20070805017269IBoeing 767332 · Lincoln, NE(-23) N133DN, a Boeing 767-332, was operated by delta airlines as flight 58, enroute from seattle, WA to atlanta, GA. The crew diverted to Lincoln, NE after a loss of oil pressure in the left engine. Maintenance found the oil tank empty and a significant…Accident 20070805016829ABeech 36BEECH · Jean, NV(-23) Sequence: the pilot in command (PIC) stated that N9ET departed calexico airport (kcxl) at approximately 1900 PST with the destination of north las vegas, NV (kvgt). Prior to leaving kcxl, the PIC estimated his fuel based on the fuel quantities indicated…Accident 20070805016819APiper PA28140 · South Lake Tah, CA(-23) Aircraft N8938C, piloted by [privacy data omitted] departed tvl on 08/05/2007 at approximately 0930 local. Witnesses observed the aircraft trying to climb in a nose high attitude, battling winds gusting to 27 KTS, while heading in a southerly direction.…Incident 20070805016599IBeech 76 · South Lake Tah, CA(-23) During the landing flare the aircraft encountered a gust of wind which caused the aircraft to pitch up and roll to the right. The aircraft contacted the runway with the right wing tip and aileron. The aircraft then became airborne again, pitching down…Accident 20070805016409ACessna 207A · Fairbanks, AK(-23) [privacy data omitted] pilot stated that oil pressure dropped to zero and then indicated below zero on gauge. Engine seemed to run normally, oil temp stayed normal, and the constant speed prop responded normally. Pilot assumed faulty oil pressure…Incident 20070805016119ICessna 177RG · Abilene, TX(-23) Airman departed coleman, Texas (com), for a flight to Abilene, Texas (abi). Upon arrival at abi, the pilot was cleared to land on runway 17R. The pilot entered downwind, turned base leg, then final for landing. Pilot failed to lower the landing gear…Accident 20070805015559ABbavia 7AC · Westerly, RI(-23) While attempting a landing on runway 07 at Westerly State Airport, RI, the airplane departed the runway to the south. The right main landing gear struck the ground causing the mount to collapse. The propeller contacted the ground and splintered. The…Accident 20070805014869ABeech E90 · Ruidosa, NM(-23) At approximately 2130 on August 5, 2007 N369CD a BE-90, operated by enchantment aviation inc. dba southwest medevac, departed sierra blanca regional airport enroute albuquerque international airport with one ATP rated pilot, flight nurse, paramedic, a…Incident 20070804828379IBell 222 · Aurora, IL(-23) While circling an automobile accident the helicopter lost power. The PIC stated that the low rotor speed horn sounded and caution light came on. The PIC also stated that he could hear the rotor speed start to decay. The PIC entered an autorotation to…Incident 20070804826049IBeech J35 · Janesville, WI(-23) Pilot stated he had flown the aircraft numerous times with alternator inoperative, recharging battery at landing points prior to jvl. Landing gear is electrically operated. Pilot stated the battery failed upon descent into jvl, and he attempted a normal…Incident 20070804824819IUrocop EC135T2 · Twin Falls, ID(-23) While in level cruise flight at 5500 feet indicated, encountered a bird strike. Made precautionary landing and notified company. Operational control center (occ).