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 20070905830039IEMB ERJ190100IGW · Buffalo, NY(-23) Jet blue flight 1211, boston, ma to Buffalo, NY, 1441 zulu time. During configuration for final approach into buf, the captain [privacy data omitted] encountered a "slat fail" annunciation when engaging the flaps. Recycled system, annunciation remained.…Accident 20070905824179ABell 206B · Lakeland, FL(-23) Pilot reported that just prior to touchdown, fifteen to twenty feet above the ground, the aircraft lost tail rotor effectiveness and spun around several times. He said he executed a hovering autorotation and landed the aircraft resulting in a hard…Accident 20070905022749ACessna 172M · Pontiac, MI(-23) Pilot bounced landing and did not use proper recovery techniques resulting in hard landing.Accident 20070905022669AAmtr Sportstar · Leesburg, FL(-23) On Wednesday, September 5, 2007 at approximately 13:35 hours, the pilot [privacy data omitted] was conducting a solo flight in a evector aerotechnik sport star EV-98 light sport aircraft, N702LF. The pilot [privacy data omitted] was practicing touch and…Accident 20070905022629ACessna 208B · Cross City, FL(-23)On September 5, 2007 at or about 0910Z, on a reposition flight from kbfm to ktpa, N702PA, a Cessna 208B serial # 208B-0702 experienced an engine failure at 11,000 feet approximately 29 miles east of the Cross City, Florida airport. The engine failure was…Incident 20070905021069IBbavia 11CC · Hood River, OR(-23) At approximately 1730 PST on 09/05/2007 at the Hood River airport (4S2) instructor [privacy data omitted] was conducting tail wheel transition training with [privacy data omitted]. During take-off roll the aircraft swerved violently to the left causing…Incident 20070905018309IPiper PA18150 · Palmer, AK(-23) Pilot indicated that he was making a routine landing on the upper colony glacier when at the end of the landing roll the aircraft sank into some soft snow and slush. The propeller dug into the snow and came to stop in a near vertical position thereby…Accident 20070905017699AAmtr Challengerii · Edgewood, NM(-23) On September 5, 2007, at 1140 MDT, an experimental amateur-built aircraft model challenger ii, N41734, registered to the pilot, impacted terrain after takeoff from Sandia airpark Estates in Edgewood, new Mexico. The aircraft was being operated on a…Accident 20070905017609ACessna 172M · Grand Junction, CO(-23) The pilot was flying up a canyon looking at elk when he determined that the aircraft would not clear the ridge. Pilot attempted to turn around stalling the aircraft and impacting the ground.Incident 20070904830359IBeech F33A · Augusta, ME(-23) Aircraft departed rwy 36 at Augusta at 920 hrs. Pilot retracted gear and lights/electrical system failed. Pilot put gear down lights/electrical system began working again. All indicators shown gear down. Pilot confirmed with ground personnel prior to…Accident 20070904829749APiper PA28161 · Williamson/Sod, NY(-23) On 9/4/2007, N444CF took off from great valley airport (N56) enroute to the Williamson/Sodus airport (ksdc). The pilot [privacy data omitted] attempted to land on runway 10 at the Williamson/Sodus airport (ksdc) at 1300 hours. During touchdown the…Incident 20070904826739IBeech A36 · Waukesha, WI(-23) After take-off the left MLG (main landing gear) lower torque knee became detached from the MLG assembly. This condition caused the gear to over extend so it wouldn't clear the gear well upon retraction. The pressure of the motor trying to bring the gear…Incident 20070904825829IMaule M5180C · Owatonna, MN(-23) Landing runway 12 with crosswind from 200 degrees at 11 with gusts 18. Ground looped.Incident 20070904022819IAmtr LANCAIR235 · Daytona Beach, FL(-23) On downwind nose gear light did not illuminate on gear extension, contacted 7FL6 (spruce creek) airport manager and arranged fly by. Advised that nose gear was fully retracted and gear was cycled several times with no results. Performed emergency gear…Incident 20070904021569IBlanca 14192 · Fullerton, CA(-23) N7683B, Bellanca, while on approach to kful, pilot lowered the landing gear and did not get a green light for the left main gear. He requested a go around from the tower and asked ATC if the gear appeared to be down, to which they replied that the gear…Incident 20070904021519ICessna 310R · Camarillo, CA(-23) During approach the landing gear handle was placed in the down position. The nose and left main gear indicated down and locked with a corresponding unsafe condition on the right main gear. After three low approaches and an attempt to manually extend the…Accident 20070904020869AAmtr Hornet · Santa Paula, CA(-23) Pilots were delivering a new airplane from ramona airport (rmn), ramona, CA to the new owner in lake chelan, WA. Their first stop enroute was Santa Paula airport (szp), Santa Paula, CA. During approach to runway 22 (szp) the student pilot overshot the…Incident 20070904020739ICessna 210M · Geneva, AL(-23) Gear up landing.Incident 20070904018809IBeech B200 · Palm Springs, CA(-23) Pilot declared an emergency and landed without incident at Palm Springs international airport (psp). The pilot reported smoke in the cockpit. Actual event was the smell of something burning, no smoke was present. Investigation revealed a small plastic…Accident 20070904017489ACessna 172R · Boston, MA(-23) On September 4, 2007, at approximately 1405 eastern standard time (EST), a Cessna C172R, N445AF taxiing inbound on November (n) taxiway was tipped on its left wing by a B767-300 jet blast. The Cessna pilot stated in a written statement, he was…Incident 20070903831349IPwrcht Pegasus · Black Creek, WI(-23) Vehicle made contact with power line causing vehicle to crash.Incident 20070903830309IRyan Navion · Sterling, MA(-23) The pilot wanted to make a "practice" simulated engine out approach and commenced a gliding approach to rwy 34. The pilot stated that neither he or his pilot rated passenger realized that he had failed to lower the landing gear.Incident 20070903830219IMeyers OTW145 · Annville, PA(-23) Engine cylinder flange studs failed during cruise flight. Piston departed aircraft, striking and damaging propeller. Aircraft was landed in open farm field. No injury to pilot or passenger. No other aircraft damage occurred.Accident 20070903829769AAronca O58B · Pequannock, NJ(-23) The pilot was practicing landings at N07, (lincoln park airport, lincoln park, NJ). On the downwind the pilot heard a load pop and the aircraft started vibrating, with no forward momentum. The pilot elected to attempt landing the aircraft in an…Accident 20070903829619APiper PA34200T · Wilmington, DE(-23) Aircraft landed at New Castle Airport (ilg) on 09/03/2007 at 1338E and taxied to the ramp at red eagle avionics. According to the tower transcripts the only transmission identified from the pilot to the tower after landing was that he stated his parking…Incident 20070903828249IPiper PA24 · Iowa City, IA(-23) Pilot was making a series of landings and became distracted and failed to lower the landing gear.Incident 20070903827719ICessna 172M · Boone, IA(-23) While on a VFR flight local in nature, the pilot attempted a landing at dusk at an airport where the runway was closed for resurfacing. A proper NOTAM was in place. Pilot stated the runway lights would not work. Lights were turned off for runway…Incident 20070903824829IBeech A36 · San Angelo, TX(-23) On September 3, 2007, pilot declared an emergency with midland approach control. Aircraft landed with the landing gear in the retracted position on runway 03, at the San Angelo Mathis field airport, San Angelo, Texas.Accident 20070903023119ACessna 310Q · Brownsburg, IN(-23) Inspector statement: in discussing the events the pilot [privacy data omitted] provided the following information: the pilot [privacy data omitted] specified that he filed an IFR flight plan and obtained weather reports using the flight service station…Accident 20070903022399AAmtr Mustangthund · Reno, NV(-23) During takeoff from runway 26, the pilot noticed the airspeed indicator was inoperative. At the approximate midfield point, the takeoff was aborted. The aircraft decelerated and stopped in the dirt approximately 300 feet off the departure end of the…Accident 20070903021939AAmtr Superstrdstr · Verona, KY(-23) On 03 September 2007, the pilot [privacy data omitted] was giving rides in his home built starduster too for a wedding party being held at Ryan Field, (7KY2) located in Verona KY. At approximately 15:30 local time, after giving two uneventful rides to…Accident 20070903021819AYaklev YAK52 · Chicago/Lake I, IL(-23) After departure from runway 26 at Lake In The Hills Airport (3CK), witnesses report the aircraft climbing to 50 feet, retracting the gear and continuing the takeoff at low level before starting to climb. At the runway departure end, the aircraft was…Accident 20070903021799ACessna 172C · Kelley'S Islan, OH(-23) Upon departure from Kelley'S island, Ohio at night, the aircraft impacted the water resulting in the death of the pilot and one passenger. All accessible control surfaces moved with appropriate cable inputs. Engine cylinders were intact and held…Accident 20070903021729AHughes 269C · Ramona, CA(-23) On September 3, 2007, a certified flight instructor was training a private pilot rated helicopter pilot in preparation for a commercial rotorcraft certificate. While demonstrating the procedure for a practice autorotation, the helicopter experienced an…Accident 20070903021639ABbavia 8KCAB · Mammoth Lakes, CA(-23) The pilot [privacy data omitted] departed the flying "m" ranch at approximately 0900 hrs on September 3, 2007. He never returned and an extensive search has not produced any information. This report is being generated to meet the requirements per FAA…Accident 20070903021389AAmtr Pulsarxp · Cottonwood, AZ(-23) On departure climbout from the airport the engine experienced a rapid loss of power due to an oil leak. The pilot elected to land straight ahead, alit on the runway overrun and slid into a ditch, causing substantial damage. There were no injuries to the…Accident 20070903021339ADhav DHC2MK1 · Kodiak, AK(-23) The pilot stated that while landing a float equipped aircraft on a saltwater bay in a semi remote region of Kodiak island in Alaska, the wind in the bay was gusting over the leeward side of terrain causing wind downbursts onto the surface. He stated as…Accident 20070903020969APiper PA18150 · Valdez, AK(-23) The pilot indicated that he landed on an off airport strip and had experienced an overly bumpy landing roll out. Careful examination of the off airport strip was made by the airman and the decision was made to takeoff on the smoother portion of the off…Accident 20070903018849AAronca S15AC · Mason Lake, WA(-23) On 09/03/2007 N1118H, an Aeronca S15AC on floats piloted by [privacy data omitted] was taking off from Mason Lake, WA, when the aircraft float hit a boat wake. The pilot corrected and caught the right wing tip in the water and spun the aircraft around…Incident 20070903017849ICessna 195 · Chatham, MA(-23) On September 3, 2007, at approximately 1120 eastern standard time (EST), a Cessna C195, N1083D being flown by the pilot [privacy data omitted] failed to control the aircraft during the landing phase. The aircraft sustained minor damage. The pilot of the…Accident 20070903017759ACessna 182P · Fall City, WA(-23) On 9/03/07, N58596 owned and operated by the pilot [privacy data omitted], landed short of the runway and experienced a hard landing at Fall City Airport resulting in a collision with a post on the ground, shearing off 6 feet of the left wing and…Incident 20070902826679ICessna 172RG · Shelbyville, IN(-23) After completing approximately one hour of airwork, with the landing gear warning horn sounding almost continuously, the pilot in command allowed himself to become "desensitized" to the sound of the warning horn and landed the aircraft with the landing…Incident 20070902826069IMooney M20F · Glen Ullin, ND(-23) Pilot stated on roll out after a normal landing he inadvertently placed the landing gear actuator handle to the up position instead of the flaps. Subsequently the left main gear retracted and the aircraft fell on the left wingtip.Incident 20070902825659ICamron A250 · Lakemoor, IL(-23) During landing, balloon came in contact with a tree. The balloon broke an approximately 6 inch diameter tree limb which tore a large hole in the envelope just above where the cables tie into the envelope. During impact the burners were engaged and…Accident 20070902022759ASlnsby T45 · Hutchinson, KS(-23) The glider was being towed by another aircraft for departure when the aircraft enterd pitch oscillations, at approximately 100 feet AGL, the glider pilot released the cable. The glider attempted a turn back to the runway but hit the ground during the…Accident 20070902022509AMaule M5210C · Central City, NE(-23) Pilot stated while landing he was distracted by his son, and lost control of his aircraft.Accident 20070902019449ABeech B35 · Borger, TX(-23) On 9/20/2007, at approximately 1358 CDT, the pilot [privacy data omitted] experienced an engine failure in N118TT, a BE-35-B35 bonanza, manufactured in 1950. The pilot departed hicks field (T67), in fort worth, Texas on 9/2/2007 at approximately 1205…Incident 20070902018289IBeech B100 · Westerly, RI(-23) After returning from a flight at Westerly, RI the pilot [privacy data omitted] requested the aircraft in his parking spot be moved. While landmark aviation was moving the aircraft [privacy data omitted] taxied his aircraft into the vacated spot.…Incident 20070902017939IAmtr Varieze · Tooele, UT(-23) After a x-country flight and arrival at ktvy there were intermittent rain showers in the vicinity of the airport so the pilot circled for a few minutes west of the airport to await the passing of the showers at the airport. The pilot then entered the…Accident 20070902017809ACessna 150J · Hazleton, PA(-23) Consistent witness statements indicate pilot was making a left turn, 180 degrees, from downwind to final for runway 28 at hazelton airport when the aircraft stalled at approximately 250 feet AGL and spun into the ground in line with the runway. Aircraft…