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 20070902017099ACessna 172M · Union Star, MS(-23) The student pilot departed solo from the st. joseph rosecrans airport (stj), st. joseph, MO at approximately 1350 CDT after being instructed by his flight instructor to practice maneuvers in the practice area 10 miles west of the airport. At…Accident 20070901829849AScwzer G164A · Goshen, NY(-23) After dispensing crop fertilizer at one location and heading to another nearby field at low altitude (approx. 50 ft AGL), PIC experienced a single loud bang from the radial engine which he stated that it sounded like a backfire. The engine immediately…Incident 20070901826609IArostr RX8 · Plymouth, IN(-23) During approach a cable used to assist ground personnel to steady the balloon after landing contacted an electrical wire which the pilot reported not seeing. The arcing caused an upright support to melt severing one of the mounts. There were no injuries…Accident 20070901823919AAmtr Kitfoxv · Kerrville, TX(-23) Sept. 1, 2007, on takeoff roll, the pilot lost control when the tail wheel came off the runway during a crosswind takeoff. The pilot believes he did not have enough airspeed for proper control. The aircraft drifted to the left almost immediately then it…Accident 20070901023349ABeech A36 · Elizabethton, TN(-23) Preliminary examination of the accident site revealed the airplane first impacted several trees located on up sloping terrain, then impacted the up sloping terrain located at 36 degrees 26.021 minutes north latitude and 082 degrees 06.418 minutes west…Accident 20070901022569AScwzer SGS233A · Alliance, OH(-23) Pilot made a low approach and hit a tree. The glider locked in left wing into the tree and landed right side up.Accident 20070901022559ABoeing A75N1 · Edmond, OK(-23) Pilot was taking off to the south when the aircraft started drifting to the left. He applied full right rudder and aileron but had insufficient airspeed for rudder control. Left wing tip hit tall sunflowers and pulled aircraft to the left. The wheels…Accident 20070901022419AAmtr Aventuraii · Okeechobee, FL(-23) On September 1st, 2007 at approximately 9:45 am, an experimental amateur built aventura ii seaplane crashed into lake Okeechobee Florida following practice touch and go landings on lake. Pilot made a successful touch and go landing, at lake, and was…Accident 20070901021719ACessna T210N · San Jose, CA(-23) On September 01, 2007, the pilot of N5479A, a Cessna T210N was enroute from psp airport to hwd airport when the engine quit. The pilot declared an emergency and was given the direction and distance to rhv airport. In a statement from the pilot, he put…Accident 20070901021709AAmtr Vortex · Mesa, AZ(-23) While operating in the Mesa, AZ area on a pleasure flight, the aircraft made a loud noise and began vibrating violently, at the same time losing thrust. The pilot reduced power, set up for best glide @ 50 mph, and executed an emergency landing in a dry…Incident 20070901021409ISnias SA341G · Chino, CA(-23) After landing, helicopter began to vibrate. Pilot applied rotor brake. Helicopter then turned approximately 270 degrees with weight on skids. Skid supports failed.Accident 20070901021279AAmtr Hummelultrcr · Newry, PA(-23)On September 1,2007 at approximately 1754 eastern time (et) a non-registered hummel aviation ultra cruiser was substantially damaged after impacting a tree approximately 100 feet short of and 50 feet to the right of the approach end of runway 29 at Blue…Accident 20070901020959AStbros SC7SERIES3 · Mystic Lake Lo, AK(-23) On landing pilot claims he hit a soft spot which caused the nose landing gear to fold aft crushing the lower belly frame and tearing the landing gear free from its mount. (-23 amendment) it appears that the pilot may have landed nose gear first (wheel…Accident 20070901020069AAmtr SR2AYRESJOHN · Goldendale, WA(-23) Pilot practicing departures and landings in Goldendale, Washington (on pilot's 75 acre ranch), experienced a loss of control on the second departure. Pilot attempted to abort which caused the aircraft to crash into a fence.Accident 20070901018879APiper PA22150 · Modesto, CA(-23) The pilot [privacy data omitted] departed mod three times during the accident day. After the first and second takeoff, he reported smoke in the cockpit and returned to mod. Fire equipment was called out both times. After each occurrence, the pilot…Accident 20070831831399ACessna 182P · Eau Claire, WI(-23) The pilot [privacy data omitted] was on a local flight in his Cessna 182P, N7321S, from Eau Claire, WI (eau) on August 31, 2007. His only passenger was his wife [privacy data omitted]. The pilot [privacy data omitted] took off in visual meteorological…Incident 20070831830889IPiper PA31T1 · Madison, WI(-23) On August 31, 2007, at the Madison (msn), WI, airport, the pilot [privacy data omitted] was unable to lower the right main gear. He chose to land gear up.Incident 20070831830209IPiper J5A · Danielson, CT(-23) During landing roll on rwy 31, the aircraft began to drift to the right, because the pilot made a wheel landing and held the tail off the runway, there was insufficient rudder authority to compensate. The aircraft drifted into the grass and nosed over…Incident 20070831829669ICndair CL600* · Teterboro, NJ(-23) Preliminary aircraft incident report stated that vp-ckr landed runway 6 teb after reporting a fuel emergency inbound. A review of the ATC approach control tapes reveals center handoff to TRACON stating "fuel emergency, 30 minutes fuel remaining, 10…Accident 20070831827799ALuscom 8A · Reedley, CA(-23) On August 31, 2007 N1544K was landing at a private airport (42CN) near Reedley, CA at approximately 1400 PDT. The pilot stated that he was just rolling out of the landing when the airplane ground looped at a fairly slow speed. The pilot reported that…Incident 20070831826209ICessna 172RG · Dallas, TX(-23) Pilot stated that landing/touchdown was normal. On roll-out, pilot added power near twy golf isxn intending to turn off at twy foxtrot. Nose gear collapsed, aircraft skidded on nose veering left of centerline. Initial prop strike found parallel to south…Incident 20070831825889IBeech V35B · Delavan, WI(-23) On August 31, 2006, at 1330 CDT, at delevan, WI, the pilot [privacy data omitted] did land an aircraft gear up. Pilot indicated he forgot to lower the gear. The part 91 flight was not on a flight plan and the weather was VMC. Damage was minor.Accident 20070831823939AUnivar 415C · Middletown, OH(-23) On August 31, 2007, at 1230 EDT, a Ercoupe 415-C, N93783, registered to the pilot [privacy data omitted] made a hard landing on the nose gear at Middletown airport, Ohio (mwo) while on a student solo flight. Visual meteorological conditions prevailed at…Accident 20070831023759APiper PA30 · Lawrence, KS(-23) An ASI from the wichita FSDO stopped at hetrick air services in Lawrence, KS on 09/07/2007 to look at a CE182 they were adding to their part 135 air carrier certificate. Piper N22HW was observed on jacks in the hangar. There was apparent damage to the…Incident 20070831022899IMooney M20J · Waterloo, IA(-23) After landing the gear collapsed causing minor damage to the aircraft and no injuries. The aircraft incident report (8020-9) from Waterloo ATC reported the plane landed and gear collapsed. The landing gear system is being torn down and inspected. This…Incident 20070831022789IConaer LA4200 · Blue Cypress L, FL(-23) Pilot landed on Blue Cypress lake vero beach FL in a LA-4-200 amphibious airplane for picnic. Pilot thought the right float was taking on water. He attempted to takeoff and return to the vero beach airport. During the takeoff run the right float "dug…Accident 20070831020979ALancar LC41550FG · Kernville, CA(-23) Information received from Kern county sheriff's department witness statements report the aircraft entering the airport traffic area and appeared to begin an approach to runway 35. The aircraft then made a sharp left turn and crashed. The witness…Accident 20070831019969AMooney M20K · Fort Wayne, IN(-23) Aircraft landed off airport adjacent to the Fort Wayne international airport due to engine failure caused by rod disconnecting from crankshaft and puncturing the crankcase. Aircraft came to rest in a corn field sustaining substantial damage to the…Incident 20070831019039IRobsin R44RAVENII · Las Vegas, NV(-23) Pilot received clearance for departure and started transitioning to lone mountain. As the pilot left the class d airspace, at approximately one mile to the northeast of lone mountain at approximately 3,600 MSL. Co-pilot announced a simulated engine…Accident 20070831018539AScwzer SGS233 · Morgan, UT(-23) During an instructional flight and on short final to rwy 21 the CFI states a gust of wind picked up his tail which caused the rt wing to dip and the aircraft to drift rt of centerline. Just as he was leveling the aircraft he saw he was to the rt of…Incident 20070831018259ICessna 177B · Gerlach, NV(-23) During landing at temporary airport (black rock desert, NV) the right brake/wheel assembly overheated and caught fire. Fire was contained to the wheel assembly, wheel pants, and landing gear strut fairing. Inspection of the wheel and brake assembly…Accident 20070831017659ABeech 35B33 · Tucumcari, NM(-23) On August 31, 2007, at 1252 MDT, a Beechcraft 35-B33, N2133B, registered to yuma rg flyers, LLC, impacted terrain during takeoff from Tucumcari Municipal Airport in Tucumcari, new Mexico. The aircraft was being operated on a private flight by the holder…Incident 20070830830469ICessna 152 · Westampton, NJ(-23) The pilot [privacy data omitted] who departed N87, reported his aircraft began to run rough over Westampton twp, new jersey while on a sight-seeing flight with friend [privacy data omitted]. The engine was reportedly not producing required power when…Incident 20070830825379IPiper PA23 · Chicago/Aurora, IL(-23) The pilot [privacy data omitted] stated he took off from runway 36 at karr. At about 2100 feet MSL and 5 miles north of karr the left engine was running rough and the rpm's started to decrease. The pilot decided to shut the engine down as a precaution.…Accident 20070830021219APiper PA28161 · Sevierville, TN(-23) Aircraft landed on wet grass and a muddy field at Seymour airpark (TN20), Seymour, TN. Aircraft skid marks appear about centerfield of this 2300' x 100' foot runway. Aircraft departed the west end of the field, crossed a county road and rested on trees…Accident 20070830020929ACessna 182Q · Dunsmuir, CA(-23) During a part 91 flight from salienas, CA, to grants pass or, the pilot [privacy data omitted] stated that while cruising at an altitude of 7,000 feet he observed the amp meter was indicating zero and concluded he had an alternator failure. He stated he…Accident 20070830020499AAmtr Kitfox · Placerville, CA(-23) N96KL departed cameron airpark airport at approximately 0615 hrs on 8/30/07 for a flight to Placerville airport. A few minutes after departing cameron airpark, the pilot noticed that aircraft had entered a warm air inversion layer and noted that oil…Accident 20070830018839ABeech A36 · Cameron Park, CA(-23) Aircraft departed Cameron Airpark, California (O61), runway 31, at about 12:35 on 08/30/2007 for ensenada, Mexico (mmes), with the pilot and three passengers. According to videotape shot by a local news crew, the aircraft became airborne after a long…Accident 20070830018529ATmpson Navionh · Atlantic, IA(-23) Pilot advised he landed hard and left gear collapsed causing substantial damage to the aircraft. The pilot and two passengers had no injuries.Incident 20070830017999ICessna 172M · Stanwood, WA(-23) Pilot stated that he came in to land and was too high. He thought that there were power lines he needed to clear prior to landing. He landed long, couldn't stop and ran off the end of the runway into the blackberry vines. No injuries to the pilot and…Accident 20070830017459ACessna 172R · Pawtucket, RI(-23) On August 30, 2007, at approximately 1400 eastern standard time (EST), a Cessna C172R, N2459Y being flown by a student pilot on his second solo flight failed to control the aircraft. The aircraft sustained substantial damage. The pilot of the aircraft…Incident 20070829824059IPiper L21B · Pedro Bay, AK(-23) While taxiing after landing the aircraft hit a dip on the beach causing the aircraft to rock forward allowing the propeller to strike the ground causing minor damage to the propeller.Incident 20070829023579IPiper PA34200 · Ormond Beach, FL(-23) During landing being conducted by student, flight instructor failed to intervene quickly enough to prevent aircraft from sustaining a hard landing, causing damage to both propellers and nose gear assembly.Accident 20070829023489AAirtrc AT502B · Vicksburg, AZ(-23) Pilot departed dirt strip downwind, to the west with a load. Tailwheel was lifting off and settling back down repeatedly. Pilot attempted to abort the takeoff and ground looped the airplane. The left wing struck the ground. Left gear and wind suffered…Incident 20070829022189IMooney M20F · Martinsburg, WV(-23) Pilot stated that he was coming in over the construction area (mrb runway has been under construction and usable was reduced to 2300 feet) and, just as he was about to flare, he was distracted by a piece of construction equipment which caught his eye.…Incident 20070829018799IBoeing 737490 · Fairbanks, AK(-23) Aircraft was in the process of landing and at 100 feet off runway encountered water fowl. Two birds struck the aircraft one on the nose and one on the left wing. Aircraft landed without incident and upon investigation no damage was noted and the…Accident 20070829017219ACessna 172S · Bakersfield, CA(-23) Student pilot stated he landed normally on both mains when it felt like the aircraft was being pushed to the left before the nose wheel even touched the pavement. He attempted to counteract the left drift with right rudder. Upon leaving the runway…Accident 20070828827439AAmtr Tundra · Zephyrhills, FL(-23) On August 28, 2007 at approximately 6:40PM, an apollo north america Tundra (N304AP), an experimental aircraft crashed and burned into a backyard located at [privacy data omitted] in pasco county. The aircraft was completely destroyed. The pilot and…Accident 20070828022739APiper PA31P · Newton, KS(-23) On 8/28/07 at 1300 local time, N7325L PA-31P departed kewk rwy 17. At 300 feet AGL, power to the right engine was lost. Loss of power was caused by cylinder number 6 exhaust gasket failing. This failure allowed hot exhaust gas to damage the lower spark…Accident 20070828021769AAirtrc AT502B · Blythe, CA(-23) During take off roll, the aircraft's left main landing gear tire hit a runway pothole which caused the pilot to lose control. As the aircraft continued in momentum, the left, then right wingtip struck the runway. The aircraft continued across a farm…